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.

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
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
FISCAL_YEAR		Numeric 4This is the fiscal year for the transaction.CA110, GL500
CAT-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the accounting period for the transaction.CA110, GL500
CAT-TRANS-TYPE
TRANS_TYPE		Alpha 1This field determines whether amounts or units are processed for the transaction.
  • A Amounts
  • U Units
CA110, GL500
CAT-STEP
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
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
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
GLT_COMPANY		Numeric 4This is the company the transactions are for.CA110, GL500
CAT-ACCT-UNIT
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CATSET1COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR, SEQ-NUMBERPrimaryCA10.1, CA10.2, CA10.4, CA10.5, CA10.7, CA15.1, CA15.2, CA195 +3 more
CATSET2COMPANY, ALLOC-TYPE, STEP, ALLOC-NAME, SEQ-NUMBERKeyChangeCA110
CATSET3COMPANY, FISCAL-YEAR, ACCT-PERIOD, ALLOC-TYPE, ALLOC-NAME, STEP, GLT-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SEQ-NUMBERKeyChangeCA190, CA195, GL110
CATSET4FISCAL-YEAR, ACCT-PERIOD, ALLOC-TYPE, TRANS-TYPE, GLT-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, STEP, SEQ-NUMBER, COMPANY, ALLOC-NAMEKeyChangeCA290, GLRV.1, MLRV.1
CATSET5ALLOCATION-GRP, COMPANY, FISCAL-YEAR, ACCT-PERIOD, ALLOC-TYPE, ALLOC-NAME, STEP, GLT-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SEQ-NUMBERKeyChangeCA190
CATSET6ALLOCATION-GRP, FISCAL-YEAR, ACCT-PERIOD, ALLOC-TYPE, TRANS-TYPE, GLT-COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, STEP, SEQ-NUMBER, COMPANY, ALLOC-NAMEKeyChangeGLRV.1, MLRV.1

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredCAT-GLT-COMPANY → GLM-COMPANY, CAT-ACCT-UNIT → GLM-ACCT-UNIT, CAT-ACCOUNT → GLM-ACCOUNT, CAT-SUB-ACCOUNT → GLM-SUB-ACCOUNT
Acct UnitGLNAMESRequiredCAT-GLT-COMPANY → GLN-COMPANY, CAT-ACCT-UNIT → GLN-ACCT-UNIT
Alloc NameCAHEADERNot RequiredCAT-COMPANY → CAH-COMPANY, CAT-ALLOC-NAME → CAH-ALLOC-NAME, CAT-ALLOC-TYPE → CAH-ALLOC-TYPE
Chart DetailGLCHARTDTLNot RequiredGLS-CHART-NAME → GDT-CHART-NAME, CAT-ACCOUNT → GDT-ACCOUNT, CAT-SUB-ACCOUNT → GDT-SUB-ACCOUNT
CompanyGLSYSTEMRequiredCAT-COMPANY → GLS-COMPANY
To CompanyGLSYSTEMNot RequiredCAT-GLT-COMPANY → GLS-COMPANY

Programs

Updated by (7)

Referenced by (7)