CATRANS

Allocation Transactions

The Allocation Transaction file contains the allocations transactions to be posted to the Lawson General Ledger system.

REFERENCED BY
GLRV.1 MLRV.1


UPDATED BY
CA10.2 CA10.4 CA10.1 CA10.5 CA10.7 CA110
CA190 CA195 GL110 GL500 CA15.1 CA15.2
CA210 CA215 CA290

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAT-COMPANY
Element: Company
Numeric 4
The company number you are defining the allocation for.
CA110 GL500
CAT-ALLOC-NAME
Element: Allocation
Alpha 12
The allocation name represents an allocation as defined in CA10.1 (Allocation).
CA110 GL500
CAT-ALLOC-TYPE
Element: Allocation Type
Alpha 1
This field defines what the allocation affects: actual amounts, current year budget, or next year's budget.
A = Actual
C = Current Year Budget
N = Next Year Budget
CA110 GL500
CAT-LINE-NBR
Element: Line Number
Numeric 6
This field contains the allocation detail line number.
CA110 GL500
CAT-ALLOCATION-GRP
Element: Allocation Group
Alpha 12
The allocation group where the allocation is stored.
CA110 GL500
CAT-SEQ-NUMBER
Element: Sequence Number
Numeric 6
The sequence number is a unique number assigned to each transaction.
CA110 GL500
CAT-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year for the transaction.
CA110 GL500
CAT-ACCT-PERIOD
Element: Accounting Period
Numeric 2
This is the accounting period for the transaction.
CA110 GL500
CAT-TRANS-TYPE
Element: Transaction Type
Alpha 1
This field determines whether amounts or units are processed for the transaction.
A = Amounts
U = Units
CA110 GL500
CAT-STEP
Element: Step
Numeric 3
This field determines when in a series of steps an allocation detail line gets processed. Lower-numbered steps are processed before higher steps.
CA110 GL500
CAT-ACCOUNT
Element: Account
Numeric 6
This field and the accounting unit and subaccount define the location (account) where amounts and other account information are stored.
CA110 GL500
CAT-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field and the accounting unit and account define the location (account) where amounts and other account information are stored.
CA110 GL500
CAT-GLT-COMPANY
Element: Company
Numeric 4
This is the company the transactions are for.
CA110 GL500
CAT-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The accounting unit is a shorthand notation representing a location (variable level) in the company structure. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
CA110 GL500
CAT-TO-BUDGET
Element: To Budget
Numeric 3
This is the budget allocated to.
CA110 GL500
CAT-BKPST-FLAG
Element: Backposting Flag
Alpha 1
This field determines whether the transaction is to be back-posted.
Y = Yes
N = No
CA110 GL500
CAT-RECORD-TYPE
Element: Record Type
Alpha 1
This field indicates the type of record defined: To or From.
F = From
T = To
CA110 GL500
CAT-AMOUNT-UNITS
Element: Amounts or Units
Signed 18.2 Occurs 13 Times
This field indicates the amounts or units to be posted to an account for the period.
CA110 GL500
CAT-RPT-AMOUNT-1
Element: Report One Amount
Signed 18.2 Occurs 13 Times
This field stores the amounts calculatd by CA110 in Report Currency 1.
CA110 GL500
CAT-RPT-AMOUNT-2
Element: Report Two Amount
Signed 18.2 Occurs 13 Times
This field stores the amounts calculated by CA110 in Report Currency 2.
CA110 GL500
CAT-TRAN-ND
Element: Transaction Number
Numeric 1
This is the number of decimal positions used for the transaction.
CA110 GL500
CAT-JE-NBR
Element: Journal Entry Number
Numeric 8
This is the journal entry number in the Lawson General Ledger system.
CA110 GL500
CAT-JE-TYPE
Element: Journal Entry Type
Alpha 1
The type of the journal entry: normal or intercompany.
N = Normal
I = Intercompany
CA110 GL500
CAT-JE-DESC
Journal Entry
Description
Alpha 30
This is the journal entry description.
CA110 GL500
CAT-ACTIVITY
Element: Activity
Alpha 15
The activity associated with the allocation.
CA110 GL500
CAT-ACCT-CATEGORY
Element: Account Category
Alpha 5
The account category associated with the allocation. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting. Set up account categories for an activity before you do any budgeting or transaction processing. Using account categories, you can sort and combine incoming amounts into groups for reporting and inquiry on activities. You can tie account categories to general ledger accounts using AC07.1 (Account Assignment). You can also streamline your maintenance of changes to general ledger accounts; use AC04.1 (GL Code) to define GL codes to represent general ledger accounts.
CA110 GL500
CAT-AUTO-REV
Element: Auto Reversal
Alpha 1
When the Auto Reversal field is Yes, GL199 (Period Closing) creates an opposite entry for this transaction in the next period.
Y = Yes
N = No
CA110 GL500
CAT-TRANS-DATE
Element: Transaction Date
Numeric 8 (yyyymmdd)
The date of the transaction.
CA110 GL500
CAT-SEGMENT-BLOCK
Element: Segment Block
Alpha 103
This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.
CA110 GL500


CATRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CATSET1 COMPANY
ALLOC-NAME
ALLOC-TYPE
LINE-NBR
SEQ-NUMBER
CA10.1 CA10.2
CA10.4 CA10.5
CA10.7 CA15.1
CA15.2 CA195
CA210 CA215
GL500
CATSET2 COMPANY
ALLOC-TYPE
STEP
ALLOC-NAME
SEQ-NUMBER
KeyChange
CA110
CATSET3 COMPANY
FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
ALLOC-NAME
STEP
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ-NUMBER
KeyChange
CA190 CA195
GL110
CATSET4 FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
TRANS-TYPE
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
STEP
SEQ-NUMBER
COMPANY
ALLOC-NAME
KeyChange
CA290 GLRV.1
MLRV.1
CATSET5 ALLOCATION-GRP
COMPANY
FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
ALLOC-NAME
STEP
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ-NUMBER
KeyChange
CA190
CATSET6 ALLOCATION-GRP
FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
TRANS-TYPE
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
STEP
SEQ-NUMBER
COMPANY
ALLOC-NAME
KeyChange
GLRV.1 MLRV.1


CATRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
CAT-GLT-COMPANY->GLM-COMPANY
CAT-ACCT-UNIT->GLM-ACCT-UNIT
CAT-ACCOUNT->GLM-ACCOUNT
CAT-SUB-ACCOUNT->GLM-SUB-ACCOUNT
Acct Unit GLNAMES Required
CAT-GLT-COMPANY->GLN-COMPANY
CAT-ACCT-UNIT->GLN-ACCT-UNIT
Alloc Name CAHEADER Not Required
CAT-COMPANY->CAH-COMPANY
CAT-ALLOC-NAME->CAH-ALLOC-NAME
CAT-ALLOC-TYPE->CAH-ALLOC-TYPE
Chart Detail GLCHARTDTL Not Required
GLS-CHART-NAME->GDT-CHART-NAME
CAT-ACCOUNT->GDT-ACCOUNT
CAT-SUB-ACCOUNT->GDT-SUB-ACCOUNT
Company GLSYSTEM Required
CAT-COMPANY->GLS-COMPANY
To Company GLSYSTEM Not Required
CAT-GLT-COMPANY->GLS-COMPANY


File created: Wed Jun 08 20:48:36 2016

Home
Contact Us



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