CATRANS – Allocation Transactions

System
General Ledger (GL)
Prefix
CAT
Primary key
COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR, SEQ-NUMBER
Fields
29
Updated by
7 programs
Referenced by
7 programs

CATRANS is the Allocation Transactions table in Lawson General Ledger (prefix CAT). It is indexed by COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR, SEQ-NUMBER (CATSET1); alternate indexes: CATSET2, CATSET3, CATSET4, CATSET5 and CATSET6. It is related 1:1 to GLMASTER, GLNAMES, CAHEADER, GLCHARTDTL and GLSYSTEM. It is updated by CA10.2, CA10.4, CA110, CA190, CA195, GL110 and GL500 and referenced by CA15.1, CA15.2, CA210, CA215, CA290, GLRV.1 and MLRV.1. The table has 29 fields, 6 indexes and 6 documented relations.

About CATRANS

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

Fields (29)

Column = COBOL field name without the CAT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CAT-COMPANY PK
COMPANY		Numeric 4The company number you are defining the allocation for.CA110, GL500
#CAT-ALLOC-NAME PK
ALLOC_NAME		Alpha 12The allocation name represents an allocation as defined in CA10.1 (Allocation).CA110, GL500
#CAT-ALLOC-TYPE PK
ALLOC_TYPE		Alpha 1This 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 PK
LINE_NBR		Numeric 6This field contains the allocation detail line number.CA110, GL500
#CAT-ALLOCATION-GRP SET5 SET6
ALLOCATION_GRP		Alpha 12The allocation group where the allocation is stored.CA110, GL500
#CAT-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6The sequence number is a unique number assigned to each transaction.CA110, GL500
#CAT-FISCAL-YEAR SET3 SET4 SET5 SET6
FISCAL_YEAR		Numeric 4This is the fiscal year for the transaction.CA110, GL500
#CAT-ACCT-PERIOD SET3 SET4 SET5 SET6
ACCT_PERIOD		Numeric 2This is the accounting period for the transaction.CA110, GL500
#CAT-TRANS-TYPE SET4 SET6
TRANS_TYPE		Alpha 1This field determines whether amounts or units are processed for the transaction.
  • A Amounts
  • U Units
CA110, GL500
#CAT-STEP SET2 SET3 SET4 SET5 SET6
STEP		Numeric 3This 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 SET3 SET4 SET5 SET6
ACCOUNT		Numeric 6This field and the accounting unit and subaccount define the location (account) where amounts and other account information are stored.CA110, GL500
#CAT-SUB-ACCOUNT SET3 SET4 SET5 SET6
SUB_ACCOUNT		Numeric 4This field and the accounting unit and account define the location (account) where amounts and other account information are stored.CA110, GL500
#CAT-GLT-COMPANY SET3 SET4 SET5 SET6
GLT_COMPANY		Numeric 4This is the company the transactions are for.CA110, GL500
#CAT-ACCT-UNIT SET3 SET4 SET5 SET6
ACCT_UNIT		Alpha 15The 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
TO_BUDGET		Numeric 3This is the budget allocated to.CA110, GL500
#CAT-BKPST-FLAG
BKPST_FLAG		Alpha 1This field determines whether the transaction is to be back-posted.
  • Y Yes
  • N No
CA110, GL500
#CAT-RECORD-TYPE
RECORD_TYPE		Alpha 1This field indicates the type of record defined: To or From.
  • F From
  • T To
CA110, GL500
#CAT-AMOUNT-UNITS
AMOUNT_UNITS		Signed 18.2 Occurs 13 Times ×13This field indicates the amounts or units to be posted to an account for the period.CA110, GL500
#CAT-RPT-AMOUNT-1
RPT_AMOUNT_1		Signed 18.2 Occurs 13 Times ×13This field stores the amounts calculatd by CA110 in Report Currency 1.CA110, GL500
#CAT-RPT-AMOUNT-2
RPT_AMOUNT_2		Signed 18.2 Occurs 13 Times ×13This field stores the amounts calculated by CA110 in Report Currency 2.CA110, GL500
#CAT-TRAN-ND
TRAN_ND		Numeric 1This is the number of decimal positions used for the transaction.CA110, GL500
#CAT-JE-NBR
JE_NBR		Numeric 8This is the journal entry number in the Lawson General Ledger system.CA110, GL500
#CAT-JE-TYPE
JE_TYPE		Alpha 1The type of the journal entry: normal or intercompany.
  • N Normal
  • I Intercompany
CA110, GL500
#CAT-JE-DESC
JE_DESC		Alpha 30This is the journal entry description.CA110, GL500
#CAT-ACTIVITY
ACTIVITY		Alpha 15The activity associated with the allocation.CA110, GL500
#CAT-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The 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
AUTO_REV		Alpha 1When 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
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.CA110, GL500
#CAT-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This 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

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CATSET1
  1. COMPANY
  2. ALLOC-NAME
  3. ALLOC-TYPE
  4. LINE-NBR
  5. SEQ-NUMBER
PrimaryCA10.1, CA10.2, CA10.4, CA10.5, CA10.7, CA15.1, CA15.2, CA195 +3 more
CATSET2
  1. COMPANY
  2. ALLOC-TYPE
  3. STEP
  4. ALLOC-NAME
  5. SEQ-NUMBER
KeyChangeCA110
CATSET3
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. ALLOC-TYPE
  5. ALLOC-NAME
  6. STEP
  7. GLT-COMPANY
  8. ACCT-UNIT
  9. ACCOUNT
  10. SUB-ACCOUNT
  11. SEQ-NUMBER
KeyChangeCA190, CA195, GL110
CATSET4
  1. FISCAL-YEAR
  2. ACCT-PERIOD
  3. ALLOC-TYPE
  4. TRANS-TYPE
  5. GLT-COMPANY
  6. ACCT-UNIT
  7. ACCOUNT
  8. SUB-ACCOUNT
  9. STEP
  10. SEQ-NUMBER
  11. COMPANY
  12. ALLOC-NAME
KeyChangeCA290, GLRV.1, MLRV.1
CATSET5
  1. ALLOCATION-GRP
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. ALLOC-TYPE
  6. ALLOC-NAME
  7. STEP
  8. GLT-COMPANY
  9. ACCT-UNIT
  10. ACCOUNT
  11. SUB-ACCOUNT
  12. SEQ-NUMBER
KeyChangeCA190
CATSET6
  1. ALLOCATION-GRP
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. ALLOC-TYPE
  5. TRANS-TYPE
  6. GLT-COMPANY
  7. ACCT-UNIT
  8. ACCOUNT
  9. SUB-ACCOUNT
  10. STEP
  11. SEQ-NUMBER
  12. COMPANY
  13. ALLOC-NAME
KeyChangeGLRV.1, MLRV.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERGLNAMESCAHEADERGLCHARTDTLGLSYSTEMCATRANS

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequired
CAT-GLT-COMPANY→GLM-COMPANY
CAT-ACCT-UNIT→GLM-ACCT-UNIT
CAT-ACCOUNT→GLM-ACCOUNT
CAT-SUB-ACCOUNT→GLM-SUB-ACCOUNT
Acct UnitGLNAMESRequired
CAT-GLT-COMPANY→GLN-COMPANY
CAT-ACCT-UNIT→GLN-ACCT-UNIT
Alloc NameCAHEADERNot Required
CAT-COMPANY→CAH-COMPANY
CAT-ALLOC-NAME→CAH-ALLOC-NAME
CAT-ALLOC-TYPE→CAH-ALLOC-TYPE
Chart DetailGLCHARTDTLNot Required
GLS-CHART-NAME→GDT-CHART-NAME
CAT-ACCOUNT→GDT-ACCOUNT
CAT-SUB-ACCOUNT→GDT-SUB-ACCOUNT
CompanyGLSYSTEMRequired
CAT-COMPANY→GLS-COMPANY
To CompanyGLSYSTEMNot Required
CAT-GLT-COMPANY→GLS-COMPANY

Programs

Updated by (7)

Referenced by (7)