|
|
ACCATRANS FILE
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
UPDATED BY
AC120 AC130 AC131 AC30.1 AC30.2 AC30.3
AC300 AC32.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRN-ALLOC-NAME Alpha 12 AC130
Element: Allocation CodThe allocation name represents an
allocation as defined in AC30.1
(Allocation) or AC30.2 (Multiple Pool
Allocation).
TRN-LINE-NBR Numeric 6 AC130
Element: Line Number You can assign a line number to each
detail line of an allocation for
sequencing.
TRN-SEQ-NUMBER Numeric 6 AC130
Record Sequence A unique number assigned to each
Number allocation line.
TRN-ALLOC-GROUP Alpha 12 AC130
Element: Allocation GroThis is the allocation group, which is
defined in AC37.1 (Allocation Group).
TRN-STEP Numeric 3 AC130
Element: Step This field determines when an
allocation detail line will get
processed. All lower steps are
processed before processing higher
steps.
TRN-FISCAL-YEAR Numeric 4 AC130
Element: Last Closed YeThis is the current fiscal year. This
field is updated by Period Closing
(GL199).
TRN-PERIOD Numeric 2 AC130
Element: Period This is the period in the activity
group calendar to which the transaction
is posted.
TRN-TRANS-TYPE Alpha 1 AC130
Element: Transaction TyThis field identifies the type of value
for the transaction: amount or units.
A = Amount
U = Unit
TRN-UNIT-MEASURE Alpha 12 AC130
Element: Unit Measure
TRN-ALLOC-TYPE Alpha 1 AC130
Element: Allocation TypThis field defines where the allocation
will take place.
A = AC Only
B = Both AC and GL
TRN-ACTIVITY-GRP Alpha 15 AC120 AC130
Element: Activity GroupThis is the activity group of the
activity to which the transaction is
posted.
TRN-ACTIVITY Alpha 15 AC130
Element: Activity This is the activity to which the
transaction is posted.
TRN-VAR-LEVELS Alpha 30 AC130
Element: Variable LevelLevels 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 Alpha 5 AC130
Element: Account CategoThis is the account category to which
the transaction is posted.
TRN-DESCRIPTION Alpha 30 (Lower Case) AC130
Transaction This is the description of the
Description transaction.
TRN-REFERENCE Alpha 10 (Lower Case) AC130
Element: Requester 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 Numeric 4 AC130
Element: Company This is the company to which the
allocation is posted.
TRN-FROM-COMPANY Numeric 4 AC130
Element: From Company This is the company that is the source
of the allocation.
TRN-ACCT-UNIT Alpha 15 AC130
Element: Accounting UniThis is the accounting unit to which
the allocation transaction is posted.
TRN-ACCOUNT Numeric 6 AC130
Element: Account 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 Numeric 4 AC130
Element: Subaccount 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 Numeric 8 (yyyymmdd) AC130
Element: Date This is a user-defined date specifying
when the transaction was entered.
TRN-POST-DATE Numeric 8 (yyyymmdd) AC130
Element: Posting Date This is the date the allocation
transaction was posted.
TRN-AUTO-REV Alpha 1 AC130 AC131
Element: Auto Reverse 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 Numeric 8 AC130
Element: Control Group This is the control group number
assigned to the transactions created by
the allocation.
TRN-TRAN-CURRENCY Alpha 5 AC130
Element: Transaction CuThis is the transaction currency.
TRN-TRAN-BASERATE Signed 12.6
Transaction Base This is the rate that converts the
Rate transaction amount.
TRN-TRAN-AMOUNT Signed 15.2 AC130
Element: Transaction AmThis is the amount in transaction
currency.
TRN-UNITS-AMOUNT Signed 15.2 AC130
Element: Units Amount This is the number of units for the
transaction.
TRN-TRAN-ND Numeric 1 AC130
Transaction Number This is the defined number of decimal
of Decimals positions used for the transaction.
TRN-ACT-CURRENCY Alpha 5 AC130
Element: Activity CurreThis is the activity currency.
TRN-ACT-BASERATE Signed 12.6 AC130
Element: Activity Base This is the rate that converts the
transaction amount to the activity
amount.
TRN-ACT-AMOUNT Signed 15.2 AC130
Element: Activity AmounThis is the amount in activity
currency.
TRN-ACT-ND Numeric 1 AC130
Activity Number of This is the defined number of decimal
Decimals positions used for the transaction.
TRN-AG-CURRENCY Alpha 5 AC130
Activity Group This is the activity group currency.
Currency
TRN-AG-BASERATE Signed 12.6 AC130
Activity Group Base This is the rate that converts the
Rate transaction amount to the activity group
amount.
TRN-AG-AMOUNT Signed 15.2 AC130
Activity Group This is the amount in activity group
Amount currency.
TRN-AG-ND Numeric 1 AC130
Activity Grp Nbr of This is the defined number of decimal
Decimals positions for the activity group.
TRN-RPT-AMOUNT-1 Signed 15.2 AC130
Element: Adj Amt
TRN-RPT-RATE-1 Signed 12.6 AC130
Element: Rpt Rate 1 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 Numeric 1 AC130
Account Currency
Code
TRN-RPT-AMOUNT-2 Signed 15.2 AC130
Report Currency 2 The transaction amount for Report
Amount Currency 2.
TRN-RPT-RATE-2 Signed 12.6 AC130
Element: Rpt Rate 1
TRN-RPT-ND-2 Numeric 1 AC130
Element: Rpt Nd 2 The number of decimal positions for
Report Currency 2.
ACCATRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRNSET1 ALLOC-GROUP AC130 AC131
STEP
ALLOC-NAME
LINE-NBR
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
SEQ-NUMBER
TRNSET2 ALLOC-NAME KeyChange AC130 AC131
LINE-NBR AC30.1 AC30.2
STEP* AC30.3 AC32.1
SEQ-NUMBER
ALLOC-GROUP
TRNSET3 ACTIVITY-GRP KeyChange AC10.1 AC120
ACTIVITY AC300
ACCT-CATEGORY
CONTROL-GROUP
LINE-NBR
SEQ-NUMBER
ALLOC-GROUP
STEP
ALLOC-NAME
ACCATRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
TRN-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
TRN-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
TRN-ACTIVITY -> ACV-ACTIVITY
Acalloc ACALLOC Required
TRN-ALLOC-NAME -> AOC-ALLOC-NAME
Acallocgp ACALLOCGP Required
TRN-ALLOC-GROUP -> ALG-ALLOC-GROUP
Glsystem GLSYSTEM Required
TRN-COMPANY -> GLS-COMPANY
|
