|
|
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
Element: Company The company number you are defining the
allocation for.
CAT-ALLOC-NAME Alpha 12 CA110 GL500
Element: Allocation The allocation name represents an
allocation as defined in CA10.1
(Allocation).
CAT-ALLOC-TYPE Alpha 1 CA110 GL500
Element: Allocation TypThis 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
Element: Line Number This field contains the allocation
detail line number.
CAT-ALLOCATION-GRP Alpha 12 CA110 GL500
Element: Allocation GroThe allocation group where the
allocation is stored.
CAT-SEQ-NUMBER Numeric 6 CA110 GL500
Element: Sequence NumbeThe sequence number is a unique number
assigned to each transaction.
CAT-FISCAL-YEAR Numeric 4 CA110 GL500
Element: Fiscal Year This is the fiscal year for the
transaction.
CAT-ACCT-PERIOD Numeric 2 CA110 GL500
Element: Accounting PerThis is the accounting period for the
transaction.
CAT-TRANS-TYPE Alpha 1 CA110 GL500
Element: Transaction TyThis field determines whether amounts
or units are processed for the
transaction.
A = Amounts
U = Units
CAT-STEP Numeric 3 CA110 GL500
Element: 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
Element: 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
Element: 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
Element: Company This is the company the transactions
are for.
CAT-ACCT-UNIT Alpha 15 CA110 GL500
Element: Accounting UniThe 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
Element: To Budget This is the budget allocated to.
CAT-BKPST-FLAG Alpha 1 CA110 GL500
Element: Backposting FlThis field determines whether the
transaction is to be back-posted.
Y = Yes
N = No
CAT-RECORD-TYPE Alpha 1 CA110 GL500
Element: Record Type This field indicates the type of record
defined: To or From.
F = From
T = To
CAT-AMOUNT-UNITS Signed 18.2 Occurs 13 Times CA110 GL500
Element: Amounts or UniThis field indicates the amounts or
units to be posted to an account for the
period.
CAT-RPT-AMOUNT-1 Signed 18.2 Occurs 13 Times CA110 GL500
Element: Report One AmoThis field stores the amounts calculatd
by CA110 in Report Currency 1.
CAT-RPT-AMOUNT-2 Signed 18.2 Occurs 13 Times CA110 GL500
Element: Report Two AmoThis field stores the amounts calculated
by CA110 in Report Currency 2.
CAT-TRAN-ND Numeric 1 CA110 GL500
Element: Transaction NuThis is the number of decimal positions
used for the transaction.
CAT-JE-NBR Numeric 8 CA110 GL500
Element: Journal Entry This is the journal entry number in the
Lawson General Ledger system.
CAT-JE-TYPE Alpha 1 CA110 GL500
Element: Journal Entry 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
Element: Activity The activity associated with the
allocation.
CAT-ACCT-CATEGORY Alpha 5 CA110 GL500
Element: Account CategoThe 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
Element: 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
Element: Transaction DaThe date of the transaction.
CAT-SEGMENT-BLOCK Alpha 103 CA110 GL500
Element: Segment Block 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 KeyChange CA110
ALLOC-TYPE
STEP
ALLOC-NAME
SEQ-NUMBER
CATSET3 COMPANY KeyChange CA190 CA195
FISCAL-YEAR GL110
ACCT-PERIOD
ALLOC-TYPE
ALLOC-NAME
STEP
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ-NUMBER
CATSET4 FISCAL-YEAR KeyChange 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-GRPKeyChange CA190
COMPANY
FISCAL-YEAR
ACCT-PERIOD
ALLOC-TYPE
ALLOC-NAME
STEP
GLT-COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SEQ-NUMBER
CATSET6 ALLOCATION-GRPKeyChange 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
|
