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).
UPDATED 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).	AC130
TRN-LINE-NBR Element: Line Nbr	Numeric 6 You can assign a line number to each detail line of an allocation for sequencing.	AC130
TRN-SEQ-NUMBER Element: Seq Number	Numeric 6 A unique number assigned to each allocation line.	AC130
TRN-ALLOC-GROUP Element: Allocation Group	Alpha 12 This is the allocation group, which is defined in AC37.1 (Allocation Group).	AC130
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.	AC130
TRN-FISCAL-YEAR Element: Year	Numeric 4 Contains the fiscal year for the data stored on this record.	AC130
TRN-PERIOD Element: Period	Numeric 2 This is the period in the activity group calendar to which the transaction is posted.	AC130
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	AC130
TRN-UNIT-MEASURE Element: Unit Measure	Alpha 12	AC130
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	AC130
TRN-ACTIVITY-GRP Element: Activity Group	Alpha 15 This is the activity group of the activity to which the transaction is posted.	AC120 AC130
TRN-ACTIVITY Element: Activity	Alpha 15 This is the activity to which the transaction is posted.	AC130
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.	AC130
TRN-ACCT-CATEGORY Element: Acct Category	Alpha 5 This is the account category to which the transaction is posted.	AC130
TRN-DESCRIPTION Transaction Description	Alpha 30 (Lower Case) This is the description of the transaction.	AC130
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.	AC130
TRN-COMPANY Element: Company	Numeric 4 This is the company to which the allocation is posted.	AC130
TRN-FROM-COMPANY Element: From Company	Numeric 4 This is the company that is the source of the allocation.	AC130
TRN-ACCT-UNIT Element: Acct Unit	Alpha 15 This is the accounting unit to which the allocation transaction is posted.	AC130
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.	AC130 AC131
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.	AC130 AC131
TRN-TRAN-DATE Element: Tran Date	Numeric 8 (yyyymmdd) This is a user-defined date specifying when the transaction was entered.	AC130
TRN-POST-DATE Element: Posting Date	Numeric 8 (yyyymmdd) This is the date the allocation transaction was posted.	AC130
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	AC130 AC131
TRN-CONTROL-GROUP Element: Control Group	Numeric 8 This is the control group number assigned to the transactions created by the allocation.	AC130
TRN-TRAN-CURRENCY Element: Transaction Currency	Alpha 5 This is the transaction currency.	AC130
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.	AC130
TRN-UNITS-AMOUNT Element: Units Amount	Signed 15.2 This is the number of units for the transaction.	AC130
TRN-TRAN-ND Transaction Number of Decimals	Numeric 1 This is the defined number of decimal positions used for the transaction.	AC130
TRN-ACT-CURRENCY Element: Activity Currency	Alpha 5 This is the activity currency.	AC130
TRN-ACT-BASERATE Element: Activity Base Rate	Signed 14.7 This is the rate that converts the transaction amount to the activity amount.	AC130
TRN-ACT-AMOUNT Element: Activity Amount	Signed 18.2 This is the amount in activity currency.	AC130
TRN-ACT-ND Activity Number of Decimals	Numeric 1 This is the defined number of decimal positions used for the transaction.	AC130
TRN-AG-CURRENCY Activity Group Currency	Alpha 5 This is the activity group currency.	AC130
TRN-AG-BASERATE Activity Group Base Rate	Signed 14.7 This is the rate that converts the transaction amount to the activity group amount.	AC130
TRN-AG-AMOUNT Activity Group Amount	Signed 18.2 This is the amount in activity group currency.	AC130
TRN-AG-ND Activity Grp Nbr of Decimals	Numeric 1 This is the defined number of decimal positions for the activity group.	AC130
TRN-RPT-AMOUNT-1 Element: Intl Amt	Signed 18.2	AC130
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).	AC130
TRN-RPT-ND-1 Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	AC130
TRN-RPT-AMOUNT-2 Element: Intl Amt	Signed 18.2	AC130
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).	AC130
TRN-RPT-ND-2 Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.	AC130
TRN-ORIG-ACCT-CAT Element: Acct Category	Alpha 5

ACCATRANS FILE INDEX

ACCATRANS FILE RELATIONS

ONE TO ONE RELATIONS

ACCATRANS FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.