CAHEADER

Allocation Header

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

REFERENCED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 CA00.1 CA00.2
CA05.1 CA05.2 CA110 CA160 CA215 CA240
GL145 GL146 GL148 GL167 GL170 GL190
GL191 GL196 GL197 GL199 GL300 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL41.4
GL44.1 GL45.1 GL70.1 GL70.2 GL70.3 GL70.6
GL75.1 GLCC.1 IFGT.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA61.1
MA70.1 MA75.1 MAI1.1 MLIT.1 CA199 CA200


UPDATED BY
CA10.1 CA10.2 CA10.4 CA10.6 CA10.7 CA15.1
CA15.2 CA190 CA195 CA210 GL110 GL500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAH-COMPANY
Element: Company
Numeric 4
The company number defined the allocations.
CA10.2 CA10.6
GL110 GLCC.1
CAH-ALLOC-NAME
Element: Allocation
Alpha 12
The allocation name represents an allocation as defined in CA10.1 (Allocation).
CA10.2 CA10.6
GLCC.1
CAH-ALLOC-TYPE
Element: Allocation Type
Alpha 1
The 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
Element: Allocation Type 1
Derived
This field, used for drill around, displays the Allocation Type field values.
CAH-ALLOCATION-GRP
Element: Allocation Group
Alpha 12
The allocation group where an allocation is stored.
CA10.2 CA10.6
CAH-STEP
Element: Step Value
Numeric 3
This 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
Allocation
Description
Alpha 30 (Lower Case)
The description of the allocation.
CA10.2 CA10.6
CAH-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login ID of the person who entered the record.
CA10.2 CA10.6
CAH-AUTO-ZERO
Element: Auto Zero Percent
Alpha 1
This 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
Element: Auto Zero Percent 1
Derived
This field, used for drill around, displays the Auto Zero field values.
CAH-BEG-PERIOD
Element: Beginning Period
Numeric 2
The 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
Element: Beginning Year
Numeric 4
The beginning year you want to post transactions in.
CA10.2 CA10.6
CAH-END-PERIOD
Element: Ending Period
Numeric 2
The 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
Element: Ending Year
Numeric 4
The last year you want to post transactions in.
CA10.2 CA10.6
CAH-STATUS
Element: Status
Numeric 1
This 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
Element: Posting Period
Alpha 1 Occurs 13 Times
The periods you want the allocation to be processed in.
CA10.2 CA10.6
CAH-DAY
Element: Posting Day
Numeric 2
The 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
Last Processed
Period
Numeric 2
This is the last-processed period for the allocation.
CA190 CA195
GL500
CAH-LP-YEAR
Element: Last Processed Year
Numeric 4
This is the last-processed year for the allocation.
CA190 CA195
GL500
CAH-MAINT-DATE
Element: Last Changed
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
Element: Journal Entry Number
Numeric 8
The journal entry number assigned in GL40.1 (Journal Entry) assigned to the allocation.
CA10.2 CA10.6
CAH-JE-TYPE
Element: Journal Entry Type
Alpha 1
The type of journal entry associated with the allocation: Normal or Intercompany.
CA10.2 CA10.6
CAH-JE-TYPE-1
Element: Journal Entry Type 1
Derived
This field, used for drill around, displays the Journal Entry Type field values.
CAH-BKPST-JE-NBR
Backposted Journal
Entry Nbr
Numeric 8
This is the journal entry number to be used for back-posting this allocation.
CA15.1 CA15.2
CA190
CAH-BKPST-PERIOD
Element: Backposted Period
Numeric 2
The 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
Element: Backposted Year
Numeric 4
The year you want to back-post the allocation to.
CA15.1 CA15.2
CA190
CAH-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
CA10.2 CA10.6
CAH-REFERENCE
Element: 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
Element: Base Zone
Alpha 15
A 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
Element: Budget
Numeric 3
If 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
Contra Accounting
Unit
Alpha 15
You 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
Element: Contra Account
Numeric 6
You 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
Element: Contra Subaccount
Numeric 4
You 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
Element: Total Percentage
Signed 11.4
This 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 Comment
Sequence
Numeric 4
This is the sequence number of the last comment for the transaction.
CAH-LAST-LINE-NBR
Element: Last Line Used
Numeric 6
This 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
Element: Line Number
Numeric 6
This is the number of detail lines.
CA10.1 CA10.4
CA10.6 CA10.7
CAH-NBR-CMT-LINES
Number of Comment
Lines
Numeric 6
This is the number of comment lines for the transaction.
CAH-AUTO-REV
Element: Auto Reversal
Alpha 1
If 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
Element: Auto Reversal 1
Derived
This field, used for drill around, displays the auto reversal sign.
CAH-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
The journal book assigned to the transaction.
CA10.2 CA10.6
CAH-MX-VALUE-APPLY
Element: Apply Value
Alpha 1
You 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
Element: Value
Alpha 32 Occurs 3 Times
This 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
Element: Apply Activity
Alpha 1
This 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
Element: Apply Segment
Alpha 1
This 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
Element: Apply Segment Block
Alpha 103
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.


CAHEADER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAHSET1 COMPANY
ALLOC-NAME
ALLOC-TYPE
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.5
CA10.6 CA10.7
CA110 CA15.1
CA15.2 CA160
CAHSET2 COMPANY
JE-NBR
JE-TYPE
ALLOC-NAME
ALLOC-TYPE
KeyChange
CA10.2 CA10.6
CAHSET3 COMPANY
BKPST-JE-NBR
JE-TYPE
ALLOC-NAME
ALLOC-TYPE
KeyChange, Subset
WhereBKPST-JE-NBR !=Zeroes
CA10.2 CA10.6
CA15.1 CA15.2
CAHSET4 COMPANY
ALLOC-TYPE
ALLOC-NAME
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA110
CA15.1 CA15.2
CA199 GL110
CAHSET5 COMPANY
STEP
ALLOC-NAME
ALLOC-TYPE
KeyChange
CA15.1 CA215
CAHSET6 ALLOCATION-GRP
ALLOC-TYPE
COMPANY
ALLOC-NAME
KeyChange
CA00.1 CA00.2
CA110 CA15.2
CA200
CAHSET7 ALLOCATION-GRP
STEP
COMPANY
ALLOC-NAME
ALLOC-TYPE
KeyChange
CA15.2 CA215


CAHEADER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Allocation Grp CAALLOCGRP Not Required
CAH-ALLOCATION-GRP->CAG-ALLOCATION-GRP
Company GLSYSTEM Required
CAH-COMPANY->GLS-COMPANY
Glmaster GLMASTER Not Required
CAH-COMPANY->GLM-COMPANY
CAH-CTRA-AU->GLM-ACCT-UNIT
CAH-CTRA-ACCOUNT->GLM-ACCOUNT
CAH-CTRA-SUB-ACCT->GLM-SUB-ACCOUNT
Source Code GLCODES Not Required
CAH-SOURCE-CODE->GCD-SOURCE-CODE


CAHEADER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Alloc Detail CADETAIL Delete Restricted
CAH-COMPANY->CAD-COMPANY
CAH-ALLOC-NAME->CAD-ALLOC-NAME
CAH-ALLOC-TYPE->CAD-ALLOC-TYPE
  CAD-LINE-NBR
Caheaderau CAHEADERAU
CAH-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
Fbheader FBHEADER
CAH-COMPANY->FBH-COMPANY
CAH-BUDGET-NBR->FBH-BUDGET-NBR
  FBH-FISCAL-YEAR


File created: Thu Jun 09 02:13:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.