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

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

ACCATRANS FILE INDEX

ACCATRANS FILE RELATIONS

ONE TO ONE RELATIONS

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