CAHEADER – Allocation Header

System
General Ledger (GL)
Prefix
CAH
Primary key
COMPANY, ALLOC-NAME, ALLOC-TYPE
Fields
46
Updated by
12 programs
Referenced by
66 programs

CAHEADER is the Allocation Header table in Lawson General Ledger (prefix CAH). It is indexed by COMPANY, ALLOC-NAME, ALLOC-TYPE (CAHSET1); alternate indexes: CAHSET2, CAHSET3, CAHSET4, CAHSET5, CAHSET6 and CAHSET7. It is related 1:1 to CAALLOCGRP, GLSYSTEM, GLMASTER and GLCODES and 1:M to CADETAIL, CAHEADERAU and FBHEADER. It is updated by CA10.1, CA10.2, CA10.4, CA10.6, CA10.7, CA15.1, CA15.2, CA190 and 4 more and referenced by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 58 more. The table has 46 fields, 7 indexes and 7 documented relations.

About CAHEADER

The Allocation Header file contains allocation control information used to process allocation detail records.

Fields (46)

Column = COBOL field name without the CAH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CAH-COMPANY PK
COMPANY		Numeric 4The company number defined the allocations.CA10.2, CA10.6, GL110, GLCC.1
CAH-ALLOC-NAME PK
ALLOC_NAME		Alpha 12The allocation name represents an allocation as defined in CA10.1 (Allocation).CA10.2, CA10.6, GLCC.1
CAH-ALLOC-TYPE PK
ALLOC_TYPE		Alpha 1The allocation type determines where funds are allocated to. The default is Actual. You can select Current Year budget or Next Year budget.
  • A Actual
  • C Current Year Budget
  • N Next Year Budget
CA10.2, CA10.6, GLCC.1
CAH-ALLOC-TYPE-1
ALLOC_TYPE_1		DerivedThis field, used for drill around, displays the Allocation Type field values.—
CAH-ALLOCATION-GRP
ALLOCATION_GRP		Alpha 12The allocation group where an allocation is stored.CA10.2, CA10.6
CAH-STEP
STEP		Numeric 3This field determines when an allocation detail line will get processed. All lower steps are processed before processing higher steps. 001 999
  • 000 Defined on Detail
CA10.2, CA10.6
CAH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the allocation.CA10.2, CA10.6
CAH-OPERATOR
OPERATOR		Alpha 10This field is used to store the login ID of the person who entered the record.CA10.2, CA10.6
CAH-AUTO-ZERO
AUTO_ZERO		Alpha 1This field is used to determine if amounts are to be zeroed out after processing.
  • N No
  • Y Yes
CA10.2, CA10.6
CAH-AUTO-ZERO-1
AUTO_ZERO_1		DerivedThis field, used for drill around, displays the Auto Zero field values.—
CAH-BEG-PERIOD
BEG_PERIOD		Numeric 2The beginning period you want to post transactions in.
  • 01 Period 1
  • 02 Period 2
  • 03 Period 3
  • 04 Period 4
  • 05 Period 5
  • 06 Period 6
  • 07 Period 7
  • 08 Period 8
  • 09 Period 9
  • 10 Period 10
  • 11 Period 11
  • 12 Period 12
  • 13 Period 13
CA10.2, CA10.6
CAH-BEG-YEAR
BEG_YEAR		Numeric 4The beginning year you want to post transactions in.CA10.2, CA10.6
CAH-END-PERIOD
END_PERIOD		Numeric 2The last period you want to post transactions in.
  • 01 Period 1
  • 02 Period 2
  • 03 Period 3
  • 04 Period 4
  • 05 Period 5
  • 06 Period 6
  • 07 Period 7
  • 08 Period 8
  • 09 Period 9
  • 10 Period 10
  • 11 Period 11
  • 12 Period 12
  • 13 Period 13
CA10.2, CA10.6
CAH-END-YEAR
END_YEAR		Numeric 4The last year you want to post transactions in.CA10.2, CA10.6
CAH-STATUS
STATUS		Numeric 1This field indicates the transaction status: Released or Unreleased.
  • 1 Released
  • 0 Unreleased
CA10.1, CA10.2, CA10.7, CA15.1, CA15.2, CA190
CAH-POST-PERIOD
POST_PERIOD		Alpha 1 Occurs 13 Times ×13The periods you want the allocation to be processed in.CA10.2, CA10.6
CAH-DAY
DAY		Numeric 2The day you want to post transactions. If you leave this field blank, the period end date defined for the company in GL10.1 (Company) defaults.CA10.2, CA10.6
CAH-LP-PERIOD
LP_PERIOD		Numeric 2This is the last-processed period for the allocation.CA190, CA195, GL500
CAH-LP-YEAR
LP_YEAR		Numeric 4This is the last-processed year for the allocation.CA190, CA195, GL500
CAH-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)This is the date the allocation was most recently changed.CA10.1, CA10.2, CA10.4, CA10.6, CA10.7, CA15.1, CA15.2
CAH-JE-NBR
JE_NBR		Numeric 8The journal entry number assigned in GL40.1 (Journal Entry) assigned to the allocation.CA10.2, CA10.6
CAH-JE-TYPE
JE_TYPE		Alpha 1The type of journal entry associated with the allocation: Normal or Intercompany.CA10.2, CA10.6
CAH-JE-TYPE-1
JE_TYPE_1		DerivedThis field, used for drill around, displays the Journal Entry Type field values.—
CAH-BKPST-JE-NBR
BKPST_JE_NBR		Numeric 8This is the journal entry number to be used for back-posting this allocation.CA15.1, CA15.2, CA190
CAH-BKPST-PERIOD
BKPST_PERIOD		Numeric 2The period you want to back-post the allocation to. The period must be open for back-posting in the General Ledger system.CA15.1, CA15.2, CA190
CAH-BKPST-YEAR
BKPST_YEAR		Numeric 4The year you want to back-post the allocation to.CA15.1, CA15.2, CA190
CAH-SOURCE-CODE
SOURCE_CODE		Alpha 2A two character code assigned to a transaction to identify where the transaction was created.CA10.2, CA10.6
CAH-REFERENCE
REFERENCE		Alpha 10 (Lower Case)Reference is a user-defined field used to track transactions. For example, type a purchase order number for audit purposes.CA10.2, CA10.6
CAH-BASE-ZONE
BASE_ZONE		Alpha 15A zone identifies a group of accounting units that stay in balance when transactions pass between defined zone areas.CA10.2, CA10.6
CAH-BUDGET-NBR
BUDGET_NBR		Numeric 3If you select Current Year or Next Year Budget in the Type field, type or select the budget number you want to allocate from. The budget must exist in FB20.1 (Period Budget, Rate).CA10.2, CA10.6
CAH-CTRA-AU
CTRA_AU		Alpha 15You can use a contra account to retain the integrity of your original data. The accounting unit you type here will replace the data in the From Accounting Unit field when you run CA110 (Allocation Calculation). If you use a contra account, the amount will appear on the Journal Entry for audit purposes. For example: If you want to allocate 50 percent from account 41000's balance of $5000, you can use contra account 42000 to allocate $2500 while keeping the integrity of account 41000's original balance.CA10.2, CA10.6
CAH-CTRA-ACCOUNT
CTRA_ACCOUNT		Numeric 6You can use a contra account to retain the integrity of your original data. The account you type here will replace the data in the From Account field when you run CA110 (Allocation Calculation). If you use a contra account, the amount will appear on the Journal Entry for audit purposes. For example: If you want to allocate 50 percent from account 41000's balance of $5000, you can use contra account 42000 to allocate $25000 while keeping the integrity of account 41000's original balance.CA10.2, CA10.6
CAH-CTRA-SUB-ACCT
CTRA_SUB_ACCT		Numeric 4You can use a contra subaccount to retain the integrity of you original data. The subaccount you type here will replace the data in the From Subaccount field when you run CA110 (Allocation Calculation). If you use a contra account, the amount will appear on the Journal Entry for audit purposes. For example: If you want to allocate 50 percent from account 41000's balance of $5000, you can use contra account 42000 to allocate $2500 while keeping the integrity of account 41000's original balance.CA10.2, CA10.6
CAH-TOTAL-PCT
TOTAL_PCT		Signed 11.4This field displays the total percentage for all allocation detail lines.CA10.1, CA10.4, CA10.6, CA10.7, CA190, CA195
CAH-LAST-CMT-SEQ
LAST_CMT_SEQ		Numeric 4This is the sequence number of the last comment for the transaction.—
CAH-LAST-LINE-NBR
LAST_LINE_NBR		Numeric 6This is the number of the last line item added to the transaction. It is used to determine the number for the next line added to the transaction.CA10.1, CA10.4, CA10.6, CA10.7, CA210
CAH-NBR-LINES
NBR_LINES		Numeric 6This is the number of detail lines.CA10.1, CA10.4, CA10.6, CA10.7
CAH-NBR-CMT-LINES
NBR_CMT_LINES		Numeric 6This is the number of comment lines for the transaction.—
CAH-AUTO-REV
AUTO_REV		Alpha 1If you select Yes in this field, the Lawson General Ledger Closing program GL199 creates an opposite entry for this transaction in the next period. The default is No.CA10.2, CA10.6
CAH-AUTO-REV-1
AUTO_REV_1		DerivedThis field, used for drill around, displays the auto reversal sign.—
CAH-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.CA10.2, CA10.6
CAH-MX-VALUE-APPLY
MX_VALUE_APPLY		Alpha 1You can select the type of account the activity (from the Activity Management system) applies to. When you post, the program creates transactions in the Activity Management and General Ledger systems.
  • B Both
  • F From Accounts
  • T To Accounts
CA10.2
CAH-MX-VALUE
MX_VALUE		Alpha 32 Occurs 3 Times ×3This is a transaction matrix value associated with the allocation transaction. You can assign a matrix value for each matrix category assigned to the source code. You can define up to three categories for each source code using GL05.1.CA10.2, CA10.6
CAH-ACTIVITY-APPLY
ACTIVITY_APPLY		Alpha 1This field determines the transaction type applied to the activity. You can select Both Sides of the Allocation, Post To Accounts, and Post From Accounts. When you post, the system creates transaction in the Activity Management and General Ledger systems.
  • T Post To Accounts
  • F Post From Accounts
  • B Both Post To And From Accounts
CA10.2, CA10.6
CAH-SEGMENT-APPLY
SEGMENT_APPLY		Alpha 1This field determines where the user analysis values are applied for an allocation.
  • T Post To Accounts
  • F Post From Accounts
  • B Both Accounts
CA10.2
CAH-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.—

Indexes (7)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CAHSET1COMPANY, ALLOC-NAME, ALLOC-TYPEPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
CAHSET2COMPANY, JE-NBR, JE-TYPE, ALLOC-NAME, ALLOC-TYPEKeyChangeCA10.2, CA10.6
CAHSET3COMPANY, BKPST-JE-NBR, JE-TYPE, ALLOC-NAME, ALLOC-TYPEKeyChange, SubsetWhere BKPST-JE-NBR != ZeroesCA10.2, CA10.6, CA15.1, CA15.2
CAHSET4COMPANY, ALLOC-TYPE, ALLOC-NAMECA10.1, CA10.2, CA10.4, CA10.6, CA10.7, CA110, CA15.1, CA15.2 +2 more
CAHSET5COMPANY, STEP, ALLOC-NAME, ALLOC-TYPEKeyChangeCA15.1, CA215
CAHSET6ALLOCATION-GRP, ALLOC-TYPE, COMPANY, ALLOC-NAMEKeyChangeCA00.1, CA00.2, CA110, CA15.2, CA200
CAHSET7ALLOCATION-GRP, STEP, COMPANY, ALLOC-NAME, ALLOC-TYPEKeyChangeCA15.2, CA215

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Allocation GrpCAALLOCGRPNot RequiredCAH-ALLOCATION-GRP → CAG-ALLOCATION-GRP
CompanyGLSYSTEMRequiredCAH-COMPANY → GLS-COMPANY
GlmasterGLMASTERNot RequiredCAH-COMPANY → GLM-COMPANY, CAH-CTRA-AU → GLM-ACCT-UNIT, CAH-CTRA-ACCOUNT → GLM-ACCOUNT, CAH-CTRA-SUB-ACCT → GLM-SUB-ACCOUNT
Source CodeGLCODESNot RequiredCAH-SOURCE-CODE → GCD-SOURCE-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
Alloc DetailCADETAILDelete RestrictedCAH-COMPANY → CAD-COMPANY, CAH-ALLOC-NAME → CAD-ALLOC-NAME, CAH-ALLOC-TYPE → CAD-ALLOC-TYPE, → CAD-LINE-NBR
CaheaderauCAHEADERAUCAH-COMPANY → CHA-COMPANY, CAH-ALLOC-NAME → CHA-ALLOC-NAME, CAH-ALLOC-TYPE → CHA-ALLOC-TYPE, → CHA-ACTION, → CHA-DATE, → CHA-TIME, → CHA-UNIQUE-I-D
FbheaderFBHEADERCAH-COMPANY → FBH-COMPANY, CAH-BUDGET-NBR → FBH-BUDGET-NBR, → FBH-FISCAL-YEAR

Programs

Updated by (12)

Referenced by (66)