AC Allocation Transaction
This file contains a set of intermediate results produced by AC130 (Allocation Calculation). These transactions are moved to the Activity Transaction file for posting by AC131 (Allocation Update) and posted by AC190 (Activity Posting).
REFERENCED BY
AC10.1 |
AC120 | AC130 | AC131 | AC30.1 | AC30.2 | AC30.3 |
AC300 | AC32.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TRN-ALLOC-NAME Element: Alloc Name | Alpha 12 The allocation name represents an allocation as defined in AC30.1 (Allocation) or AC30.2 (Multiple Pool Allocation). |
|
||
TRN-LINE-NBR Element: Line Nbr | Numeric 6 You can assign a line number to each detail line of an allocation for sequencing. |
|
||
TRN-SEQ-NUMBER Element: Seq Number | Numeric 6 A unique number assigned to each allocation line. |
|
||
TRN-ALLOC-GROUP Element: Allocation Group | Alpha 12 This is the allocation group, which is defined in AC37.1 (Allocation Group). |
|
||
TRN-STEP Element: Step | Numeric 3 This field determines when an allocation detail line will get processed. All lower steps are processed before processing higher steps. |
|
||
TRN-FISCAL-YEAR Element: Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||
TRN-PERIOD Element: Period | Numeric 2 This is the period in the activity group calendar to which the transaction is posted. |
|
||
TRN-TRANS-TYPE Element: Trans Type | Alpha 1 This field identifies the type of value for the transaction: amount or units. A = Amount U = Unit |
|
||
TRN-UNIT-MEASURE Element: Unit Measure | Alpha 12 |
|
||
TRN-ALLOC-TYPE Element: Alloc Type | Alpha 1 This field defines where the allocation will take place. A = AC Only B = Both AC and GL |
|
||
TRN-ACTIVITY-GRP Element: Activity Group | Alpha 15 This is the activity group of the activity to which the transaction is posted. |
|
||
TRN-ACTIVITY Element: Activity | Alpha 15 This is the activity to which the transaction is posted. |
|
||
TRN-VAR-LEVELS Element: Variable Levels | Alpha 30 Levels define an addressing system that organizes activities into a reporting hierarchy. Level names are defined for an activity group and should be able to be used across all activities in an activity group. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to macro activities at a higher level within the hierarchy. |
|
||
TRN-ACCT-CATEGORY Element: Acct Category | Alpha 5 This is the account category to which the transaction is posted. |
|
||
TRN-DESCRIPTION Transaction Description | Alpha 30 (Lower Case) This is the description of the transaction. |
|
||
TRN-REFERENCE Element: Reference | Alpha 10 (Lower Case) This is a user-defined field used for tracing the transaction to its origin. Allocation transaction Reference fields contain the name of the allocation. |
|
||
TRN-COMPANY Element: Company | Numeric 4 This is the company to which the allocation is posted. |
|
||
TRN-FROM-COMPANY Element: From Company | Numeric 4 This is the company that is the source of the allocation. |
|
||
TRN-ACCT-UNIT Element: Acct Unit | Alpha 15 This is the accounting unit to which the allocation transaction is posted. |
|
||
TRN-ACCOUNT Element: Account | Numeric 6 This is the account to which the allocation transaction is posted. If you select the Pool (P) posting option, and the pool consists of General Ledger balances, a separate transaction is created for each account/subaccount combination and posted to the post-to activity and account category. |
|
||
TRN-SUB-ACCOUNT Element: Sub Acct | Numeric 4 This is the subaccount to which the allocation transaction is posted. If you select the Pool (P) posting option, and the pool consists of General Ledger balances, a separate transaction is created for each account/subaccount combination and posted to the post-to activity and account category. |
|
||
TRN-TRAN-DATE Element: Tran Date | Numeric 8 (yyyymmdd) This is a user-defined date specifying when the transaction was entered. |
|
||
TRN-POST-DATE Element: Posting Date | Numeric 8 (yyyymmdd) This is the date the allocation transaction was posted. |
|
||
TRN-AUTO-REV Element: Auto Reverse | Alpha 1 When you set the Auto Reversal field to Yes (Y), reversing entries are created (R) by AC131 (Allocation Update) in the run following the run that produced the original entry. Y = Yes N = No |
|
||
TRN-CONTROL-GROUP Element: Control Group | Numeric 8 This is the control group number assigned to the transactions created by the allocation. |
|
||
TRN-TRAN-CURRENCY Element: Transaction Currency | Alpha 5 This is the transaction currency. |
|
||
TRN-TRAN-BASERATE Transaction Base Rate | Signed 14.7 This is the rate that converts the transaction amount. |
|
||
TRN-TRAN-AMOUNT Element: Transaction Amount | Signed 18.2 This is the amount in transaction currency. |
|
||
TRN-UNITS-AMOUNT Element: Units Amount | Signed 15.2 This is the number of units for the transaction. |
|
||
TRN-TRAN-ND Transaction Number of Decimals | Numeric 1 This is the defined number of decimal positions used for the transaction. |
|
||
TRN-ACT-CURRENCY Element: Activity Currency | Alpha 5 This is the activity currency. |
|
||
TRN-ACT-BASERATE Element: Activity Base Rate | Signed 14.7 This is the rate that converts the transaction amount to the activity amount. |
|
||
TRN-ACT-AMOUNT Element: Activity Amount | Signed 18.2 This is the amount in activity currency. |
|
||
TRN-ACT-ND Activity Number of Decimals | Numeric 1 This is the defined number of decimal positions used for the transaction. |
|
||
TRN-AG-CURRENCY Activity Group Currency | Alpha 5 This is the activity group currency. |
|
||
TRN-AG-BASERATE Activity Group Base Rate | Signed 14.7 This is the rate that converts the transaction amount to the activity group amount. |
|
||
TRN-AG-AMOUNT Activity Group Amount | Signed 18.2 This is the amount in activity group currency. |
|
||
TRN-AG-ND Activity Grp Nbr of Decimals | Numeric 1 This is the defined number of decimal positions for the activity group. |
|
||
TRN-RPT-AMOUNT-1 Element: Intl Amt | Signed 18.2 |
|
||
TRN-RPT-RATE-1 Element: Rpt Rate 1 | Signed 14.7 The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate). |
|
||
TRN-RPT-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
TRN-RPT-AMOUNT-2 Element: Intl Amt | Signed 18.2 |
|
||
TRN-RPT-RATE-2 Element: Rpt Rate 1 | Signed 14.7 The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate). |
|
||
TRN-RPT-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
TRN-ORIG-ACCT-CAT Element: Acct Category | Alpha 5 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TRNSET1 |
ALLOC-GROUP STEP ALLOC-NAME LINE-NBR ACTIVITY ACCT-CATEGORY FISCAL-YEAR PERIOD SEQ-NUMBER |
|
| ||||||||||||
TRNSET2 |
ALLOC-NAME LINE-NBR STEP* SEQ-NUMBER ALLOC-GROUP |
|
| ||||||||||||
TRNSET3 |
ACTIVITY-GRP ACTIVITY ACCT-CATEGORY CONTROL-GROUP LINE-NBR SEQ-NUMBER ALLOC-GROUP STEP ALLOC-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Required
| |||
Acactgrp | ACACTGRP |
Required
| |||
Acactivity | ACACTIVITY |
Required
| |||
Acalloc | ACALLOC |
Required
| |||
Acallocgp | ACALLOCGP |
Required
| |||
Glsystem | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acalprdamt | ACALPRDAMT |
|
All trademarks and registered trademarks are the property of their
respective owners.