ACCATRANS

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRNSET1 ALLOC-GROUP
STEP
ALLOC-NAME
LINE-NBR
ACTIVITY
ACCT-CATEGORY
FISCAL-YEAR
PERIOD
SEQ-NUMBER
AC130 AC131
TRNSET2 ALLOC-NAME
LINE-NBR
STEP*
SEQ-NUMBER
ALLOC-GROUP
KeyChange
AC130 AC30.1
AC30.2 AC30.3
AC32.1
TRNSET3 ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
CONTROL-GROUP
LINE-NBR
SEQ-NUMBER
ALLOC-GROUP
STEP
ALLOC-NAME
KeyChange
AC10.1 AC120
AC131 AC300


ACCATRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


ACCATRANS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acalprdamt ACALPRDAMT
TRN-ALLOC-NAME->ALA-ALLOC-NAME
  ALA-LINE-NBR
  ALA-ACTIVITY
  ALA-ACCT-CATEGORY
  ALA-ORIG-ACCT-CAT


File created: Thu Jun 09 11:03:57 2016

Home
Contact Us



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