CATRANS FILE
Allocation Transactions
The Allocation Transaction file contains the allocations transactions to be
posted to the Lawson General Ledger system.
REFERENCED BY
CA15.1 CA15.2 CA210 CA215 CA290 GLRV.1
MLRV.1
UPDATED BY
CA10.2 CA10.4 CA110 CA190 CA195 GL110
GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAT-COMPANY Numeric 4 CA110 GL500
Company The company number you are defining the
allocation for.
CAT-ALLOC-NAME Alpha 12 CA110 GL500
Allocation The allocation name represents an
allocation as defined in CA10.1
(Allocation).
CAT-ALLOC-TYPE Alpha 1 CA110 GL500
Allocation Type 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
CAT-LINE-NBR Numeric 6 CA110 GL500
Line Number This field contains the allocation
detail line number.
CAT-ALLOCATION-GRP Alpha 12 CA110
Allocation Group The allocation group where the
allocation is stored.
CAT-SEQ-NUMBER Numeric 6 CA110 GL500
Sequence Number The sequence number is a unique number
assigned to each transaction.
CAT-FISCAL-YEAR Numeric 4 CA110 GL500
Fiscal Year This is the fiscal year for the
transaction.
CAT-ACCT-PERIOD Numeric 2 CA110 GL500
Accounting Period This is the accounting period for the
transaction.
CAT-TRANS-TYPE Alpha 1 CA110 GL500
Transaction Type This field determines whether amounts
or units are processed for the
transaction.
A = Amounts
U = Units
CAT-STEP Numeric 3 CA110 GL500
Step This field determines when in a series
of steps an allocation detail line gets
processed. Lower-numbered steps are
processed before higher steps.
CAT-ACCOUNT Numeric 6 CA110 GL500
Account This field and the accounting unit and
subaccount define the location (account)
where amounts and other account
information are stored.
CAT-SUB-ACCOUNT Numeric 4 CA110 GL500
Subaccount This field and the accounting unit and
account define the location (account)
where amounts and other account
information are stored.
CAT-GLT-COMPANY Numeric 4 CA110 GL500
Company This is the company the transactions
are for.
CAT-ACCT-UNIT Alpha 15 CA110 GL500
Accounting Unit 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.
CAT-TO-BUDGET Numeric 3 CA110 GL500
To Budget This is the budget allocated to.
CAT-BKPST-FLAG Alpha 1 CA110 GL500
Backposting Flag This field determines whether the
transaction is to be back-posted.
Y = Yes
N = No
CAT-RECORD-TYPE Alpha 1 CA110 GL500
Record Type This field indicates the type of record
defined: To or From.
F = From
T = To
CAT-AMOUNT-UNITS Signed 15.2 Occurs 13 Times CA110 GL500
Amounts or Units This field indicates the amounts or
units to be posted to an account for the
period.
CAT-RPT-AMOUNT-1 Signed 15.2 Occurs 13 Times CA110
Report Currency 1 This field stores the amounts calculatd
Amount by CA110 in Report Currency 1.
CAT-RPT-AMOUNT-2 Signed 15.2 Occurs 13 Times CA110
Report Currency 2 This field stores the amounts calculated
Amount by CA110 in Report Currency 2.
CAT-TRAN-ND Numeric 1 CA110 GL500
Transaction Number This is the number of decimal positions
used for the transaction.
CAT-JE-NBR Numeric 8 CA110 GL500
Journal Entry Number This is the journal entry number in the
Lawson General Ledger system.
CAT-JE-TYPE Alpha 1 CA110 GL500
Journal Entry Type The type of the journal entry: normal
or intercompany.
N = Normal
I = Intercompany
CAT-JE-DESC Alpha 30 CA110 GL500
Journal Entry This is the journal entry description.
Description
CAT-ACTIVITY Alpha 15 CA110 GL500
Activity The activity associated with the
allocation.
CAT-ACCT-CATEGORY Alpha 5 CA110 GL500
Account Category 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.
CAT-AUTO-REV Alpha 1 CA110 GL500
Auto Reversal 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
CAT-TRANS-DATE Numeric 8 (yyyymmdd) CA110 GL500
Transaction Date The date of the transaction.
CAT-SEGMENT-BLOCK Alpha 103 CA110 GL500
User Analysis 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.
CATRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CATSET1 COMPANY CA10.1 CA10.2
ALLOC-NAME CA10.4 CA10.5
ALLOC-TYPE CA10.7 CA15.1
LINE-NBR CA15.2 CA210
SEQ-NUMBER CA215 GL500
CATSET2 COMPANY CA110
ALLOC-TYPE
STEP
ALLOC-NAME
SEQ-NUMBER
CATSET3 COMPANY CA190 CA195
FISCAL-YEAR GL110
ACCT-PERIOD
ALLOC-TYPE
ALLOC-NAME
STEP
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ-NUMBER
CATSET4 FISCAL-YEAR CA290 GLRV.1
ACCT-PERIOD MLRV.1
ALLOC-TYPE
TRANS-TYPE
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
STEP
SEQ-NUMBER
COMPANY
ALLOC-NAME
CATSET5 ALLOCATION-GRP CA190
COMPANY
FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
ALLOC-NAME
STEP
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ-NUMBER
CATSET6 ALLOCATION-GRP GLRV.1 MLRV.1
FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
TRANS-TYPE
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
STEP
SEQ-NUMBER
COMPANY
ALLOC-NAME
CATRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
