|
|
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).
UPDATED BY
AC120 AC130 AC131 AC300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRN-ALLOC-NAME Alpha 12 AC130
Allocation Name The allocation name represents an
allocation as defined in AC30.1
(Allocation) or AC30.2 (Multiple Pool
Allocation).
TRN-LINE-NBR Numeric 6 AC130
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
Allocation Group This is the allocation group, which is
defined in AC37.1 (Allocation Group).
TRN-STEP Numeric 3 AC130
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
Fiscal Year This is the current fiscal year. This
field is updated by GL199 (Period
Closing).
TRN-PERIOD Numeric 2 AC130
Period This is the period in the activity
group calendar to which the transaction
is posted.
TRN-TRANS-TYPE Alpha 1 AC130
Transaction Type This field identifies the type of value
for the transaction: amount or units.
TRN-ACTIVITY-GRP Alpha 15 AC120 AC130
Activity Group This is the activity group of the
activity to which the transaction is
posted.
TRN-ACTIVITY Alpha 15 AC130
Activity This is the activity to which the
transaction is posted.
TRN-VAR-LEVELS Alpha 30 AC120 AC130
Variable Levels 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 Alpha 5 AC130
Account Category This 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
Reference 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
Company This is the company to which the
allocation is posted.
TRN-FROM-COMPANY Numeric 4 AC130
From Company This is the company that is the source
of the allocation.
TRN-ACCT-UNIT Alpha 15 AC130
Accounting Unit This is the accounting unit to which
the allocation transaction is posted.
TRN-ACCOUNT Numeric 6 AC130
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
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
Transaction Date This is a user-defined date specifying
when the transaction was entered.
TRN-POST-DATE Numeric 8 (yyyymmdd) AC130
Posting Date This is the date the allocation
transaction was posted.
TRN-AUTO-REV Alpha 1 AC130 AC131
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
R = Reverse (internal use only)
TRN-CONTROL-GROUP Numeric 8 AC130
Control Group This is the control group number
assigned to the transactions created by
the allocation.
TRN-TRAN-CURRENCY Alpha 5 AC130
Transaction Currency This 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
Transaction Amount This is the amount in transaction
currency.
TRN-UNITS-AMOUNT Signed 15.2 AC130
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
Activity Currency This is the activity currency.
TRN-ACT-BASERATE Signed 12.6 AC130
Activity Base Rate This is the rate that converts the
transaction amount to the activity
amount.
TRN-ACT-AMOUNT Signed 15.2 AC130
Activity Amount This 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.
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 Duplicates
LINE-NBR
STEP*
SEQ-NUMBER
TRNSET3 ACTIVITY-GRP Duplicates AC120 AC300
ACTIVITY
ACCT-CATEGORY
CONTROL-GROUP
LINE-NBR
SEQ-NUMBER
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
|