Activity Allocation
The Activity Allocation file stores information on new allocations from AC30.3 (New Allocation).
REFERENCED BY
AC230 | AC32.1 |
AC130 | AC131 | AC30.1 | AC30.2 | AC30.3 | AC30.4 |
AC37.1 | AC37.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
AOC-ALLOC-NAME Element: Allocation Name | Alpha 12 This is the allocation name. Allocation name is defined in AC30.1 (Allocation). |
|
||||||||
AOC-DESCRIPTION Allocation Description | Alpha 30 (Lower Case) This is the allocation description. |
|
||||||||
AOC-POOL-NAME Element: Allocation Pool | Alpha 12 This is the name assigned to the pool (or amount to be allocated). A pool consists of posted monetary amounts or statistical units found in ranges of activities and account categories, or ranges of companies, accounting units, accounts, and subaccounts specified in AC32.1 (Allocation Pool). Pool balances can be accumulated on a period, year-to-date, or life-to-date (for activity pools only) basis. A pool is attached to an allocation in AC30.1 (Allocation) or to individual allocation lines in AC30.2 (Multiple Pool Allocation). |
|
||||||||
AOC-ALLOC-TYPE Element: Alloc Type | Alpha 1 This field defines where the allocation will take place. A = AC Only B = Both AC and GL |
|
||||||||
AOC-OPERATOR Element: Operator | Alpha 10 This field displays the login ID of the person who entered an allocation record. |
|
||||||||
AOC-AUTO-ZERO Element: Auto Zero | Alpha 1 If you set this field to Yes (Y), percents you enter in AC30.1 (Allocation) are zeroed out after the allocation is processed. Y = Yes N = No |
|
||||||||
AOC-AUTO-REV Element: Auto Reverse | Alpha 1 If you set this field to Yes (Y), a reversing entry is created by AC131 (Allocation Update) in the run following the run that creates the original entry. Y = Yes N = No |
|
||||||||
AOC-STATUS Element: Status | Numeric 1 This is the allocation status. 0 = Unreleased 1 = Released 2 = Calculated |
|
||||||||
AOC-DEFAULT-DESC Element: Default Description | Alpha 30 (Lower Case) This description becomes the transaction description for each transaction whose Description field in AC30.6 (Entry) has been left blank. If this field is left blank in AC30.3 (New Allocation), the allocation description defaults into this field. |
|
||||||||
AOC-PF-ACTIVITY Element: Post-From Activity | Alpha 15 Optional. This field specifies the activity to which an offsetting transaction is posted. |
|
||||||||
AOC-PF-ACCT-CAT Post-From Account Category | Alpha 5 This is the account category of the post-from activity, to which an offsetting transaction is posted. |
|
||||||||
AOC-CONTROL-GROUP Element: Control Group | Numeric 8 This is the control group number assigned to the transactions created by the most recent run of AC131 (Allocation Update). |
|
||||||||
AOC-MAINT-DATE Element: Maintenance Date | Numeric 8 (yyyymmdd) This is the date the allocation was last changed. |
|
||||||||
AOC-MAINT-TIME Element: Maintenance Time | Numeric 6 (hhmmss) This is the time the allocation was last changed. |
|
||||||||
AOC-RUN-DATE Element: Run Date | Numeric 8 (yyyymmdd) This is the date of the most recent processing run of AC131 (Allocation Update). |
|
||||||||
AOC-RUN-TIME Element: Run Time | Numeric 6 (hhmmss) This is the time of the most recent processing run of AC131 (Allocation Update). |
|
||||||||
AOC-ALLOCATED-DATE Element: Allocated Date | Numeric 8 (yyyymmdd) This is the date the allocation amount was allocated. |
|
||||||||
AOC-ALLOCATED-TIME Element: Allocated Time | Numeric 6 (hhmmss) This is the time the allocation amount was allocated. |
|
||||||||
AOC-TOTAL-PCT Element: Total Percent | Signed 11.4 This is the sum of the percent values entered in the detail lines of AC30.1 (Allocation). |
|
||||||||
AOC-LAST-CMT-SEQ Last Comment Sequence Number | Numeric 4 This is the sequence number of the last comment for the allocation. |
|
||||||||
AOC-LAST-LINE-NBR Element: Last Line Number | Numeric 6 This is the number of the last line item added to the allocation. It is used to determine the line number when the next line is added to the allocation. |
|
||||||||
AOC-NBR-LINES Number of Detail Lines | Numeric 6 This field indicates the number of detail lines for the allocation. |
|
||||||||
AOC-NBR-CMT-LINES Number of Comment Lines | Numeric 6 This field indicates the number of comment lines for the allocation. |
|
||||||||
AOC-PT-COMPANY Element: Post-to Company | Numeric 4 This is the company to post the allocation to. |
|
||||||||
AOC-PT-ACCT-UNIT Post-to Accounting Unit | Alpha 15 This is the accounting unit to post the allocation to. |
|
||||||||
AOC-PT-ACCOUNT Element: Post-to Account | Numeric 6 This is the account to post the allocation to. |
|
||||||||
AOC-PT-SUB-ACCT Element: Post-to Subaccount | Numeric 4 This is the subaccount to post the allocation to. |
|
||||||||
AOC-PT-LIST Element: Post-to List | Alpha 12 This is the list to post the allocation to. |
|
||||||||
AOC-PF-COMPANY Element: Post-from Company | Numeric 4 This is the company for the post-from activity, to which an offsetting transaction is posted. |
|
||||||||
AOC-PF-ACCT-UNIT Post-from Accounting Unit | Alpha 15 This is the accounting unit of the post-from activity, to which an offsetting transaction is posted. |
|
||||||||
AOC-PF-ACCOUNT Element: Post-from Account | Numeric 6 This is the account for the post-from activity, to which an offsetting transaction is posted. |
|
||||||||
AOC-PF-SUB-ACCT Element: Post-from Subaccount | Numeric 4 This is the subaccount for the post-from activity, to which an offsetting transaction is posted. |
|
||||||||
AOC-POOL-LIST Element: Pool List | Alpha 1 Valid values are Yes or No. Y = Yes N = No |
|
||||||||
AOC-OFFSET-TYPE Element: Offset Type | Alpha 1 1 = AC Only 2 = GL Only 3 = AC and GL 4 = None |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AOCSET1 |
ALLOC-NAME |
|
| ||||||||||||||||
AOCSET2 |
CONTROL-GROUP* ALLOC-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Not Required
| |||
Acactivity | ACACTIVITY |
Not Required
| |||
Acpoolhdr | ACPOOLHDR |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acallocgp | ACALLOCX |
| |||||||||||||||
Acallocx | ACALLOCX |
| |||||||||||||||
Accatrans | ACCATRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.