|
|
CAHEADER FILE
Allocation Header
The Allocation Header file contains allocation control information used to
process allocation detail records.
REFERENCED BY
CA110 CA215 CA240 GLCC.1 IFGT.1 CA199
CA00.1 CA00.2 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 Numeric 4 CA10.2 CA10.6
Element: Company The company number allocations are GL110 GLCC.1
defined for.
CAH-ALLOC-NAME Alpha 12 CA10.2 CA10.6
Element: Allocation GLCC.1
CAH-ALLOC-TYPE Alpha 1 CA10.2 CA10.6
Element: Allocation TypThe allocation type determines where GLCC.1
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
CAH-ALLOC-TYPE-1 Derived
Element: Allocation TypThis field, used for drill around,
displays the Allocation Type field
values.
CAH-ALLOCATION-GRP Alpha 12 CA10.2 CA10.6
Element: Allocation GroThe allocation group where an
allocation is stored.
CAH-STEP Numeric 3 CA10.2 CA10.6
Element: Step Value 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
CAH-DESCRIPTION Alpha 30 (Lower Case) CA10.2 CA10.6
Allocation The description of the allocation.
Description
CAH-OPERATOR Alpha 10 CA10.2 CA10.6
Element: Operator This field is used to store the login
ID of the person who entered the record.
CAH-AUTO-ZERO Alpha 1 CA10.2 CA10.6
Element: Auto Zero PercThis field is used to determine if
amounts are to be zeroed out after
processing.
N = No
Y = Yes
CAH-AUTO-ZERO-1 Derived
Element: Auto Zero PercThis field, used for drill around,
displays the Auto Zero field values.
CAH-BEG-PERIOD Numeric 2 CA10.2 CA10.6
Element: Beginning PeriThe 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
CAH-BEG-YEAR Numeric 4 CA10.2 CA10.6
Element: Beginning YearThe beginning year you want to post
transactions in.
CAH-END-PERIOD Numeric 2 CA10.2 CA10.6
Element: Ending Period 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
CAH-END-YEAR Numeric 4 CA10.2 CA10.6
Element: Ending Year The last year you want to post
transactions in.
CAH-STATUS Numeric 1 CA10.1 CA10.2
Element: Status This field indicates the transaction CA10.7 CA15.1
status: Released or Unreleased. CA15.2 CA190
1 = Released
0 = Unreleased
CAH-POST-PERIOD Alpha 1 Occurs 13 Times CA10.2 CA10.6
Element: Posting PeriodThe periods you want the allocation to
be processed in.
CAH-DAY Numeric 2 CA10.2 CA10.6
Element: Posting Day 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.
CAH-LP-PERIOD Numeric 2 CA190 CA195
Last Processed This is the last-processed period for GL500
Period the allocation.
CAH-LP-YEAR Numeric 4 CA190 CA195
Element: Last ProcessedThis is the last-processed year for the GL500
allocation.
CAH-MAINT-DATE Numeric 8 (yyyymmdd) CA10.1 CA10.2
Element: Last Changed This is the date the allocation was CA10.4 CA10.6
most recently changed. CA10.7 CA15.1
CA15.2
CAH-JE-NBR Numeric 8 CA10.2 CA10.6
Element: Journal Entry The journal entry number assigned in
GL40.1 (Journal Entry) assigned to the
allocation.
CAH-JE-TYPE Alpha 1 CA10.2 CA10.6
Element: Journal Entry The type of journal entry associated
with the allocation: Normal or
Intercompany.
CAH-JE-TYPE-1 Derived
Element: Journal Entry This field, used for drill around,
displays the Journal Entry Type field
values.
CAH-BKPST-JE-NBR Numeric 8 CA15.1 CA15.2
Backposted Journal This is the journal entry number to be CA190
Entry Nbr used for back-posting this allocation.
CAH-BKPST-PERIOD Numeric 2 CA15.1 CA15.2
Element: Backposted PerThe period you want to back-post the CA190
allocation to. The period must be open
for back-posting in the General Ledger
system.
CAH-BKPST-YEAR Numeric 4 CA15.1 CA15.2
Element: Backposted YeaThe year you want to back-post the CA190
allocation to.
CAH-SOURCE-CODE Alpha 2 CA10.2 CA10.6
Element: Source Code A two character code assigned to a
transaction to identify where the
transaction was created.
CAH-REFERENCE Alpha 10 (Lower Case) CA10.2 CA10.6
Element: Reference Reference is a user-defined field used
to track transactions. For example, type
a purchase order number for audit
purposes.
CAH-BASE-ZONE Alpha 15 CA10.2 CA10.6
Element: Base Zone
CAH-BUDGET-NBR Numeric 3 CA10.2 CA10.6
Element: Budget 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).
CAH-CTRA-AU Alpha 15 CA10.2 CA10.6
Contra Accounting You can use a contra account to retain
Unit 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.
CAH-CTRA-ACCOUNT Numeric 6 CA10.2 CA10.6
Element: Contra AccountYou 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.
CAH-CTRA-SUB-ACCT Numeric 4 CA10.2 CA10.6
Element: Contra SubaccoYou 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.
CAH-TOTAL-PCT Signed 7.4 CA10.1 CA10.4
Element: Total Percentage CA10.6 CA10.7
CA190 CA195
CAH-LAST-CMT-SEQ Numeric 4
Last Comment This is the sequence number of the last
Sequence comment for the transaction.
CAH-LAST-LINE-NBR Numeric 6 CA10.1 CA10.4
Element: Last Line UsedThis is the number of the last line CA10.6 CA10.7
item added to the transaction. It is CA210
used to determine the number for the
next line added to the transaction.
CAH-NBR-LINES Numeric 6 CA10.1 CA10.4
Element: Line Number CA10.6 CA10.7
CAH-NBR-CMT-LINES Numeric 6
Number of Comment This is the number of comment lines for
Lines the transaction.
CAH-AUTO-REV Alpha 1 CA10.2 CA10.6
Element: Auto Reversal 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.
CAH-AUTO-REV-1 Derived
Element: Auto Reversal This field, used for drill around,
displays the auto reversal sign.
CAH-JRNL-BOOK-NBR Alpha 12 CA10.2 CA10.6
Element: Journal Book NThe journal book assigned to the
transaction.
CAH-MX-VALUE-APPLY Alpha 1 CA10.2
Element: Apply Value 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
CAH-MX-VALUE Alpha 32 Occurs 3 Times CA10.2 CA10.6
Element: Value 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.
CAH-ACTIVITY-APPLY Alpha 1 CA10.2 CA10.6
Element: Apply ActivityThis 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
CAH-SEGMENT-APPLY Alpha 1 CA10.2
Element: Apply User AnaThis field determines where the user
analysis values are applied for an
allocation.
T = Post To Accounts
F = Post From Accounts
B = Both Accounts
CAH-SEGMENT-BLOCK Alpha 103
Element: User Analysis 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 CA10.1 CA10.2
ALLOC-NAME CA10.4 CA10.5
ALLOC-TYPE CA10.6 CA10.7
CA110 CA15.1
CA190 CA195
CA210 CA215
CA240 GL110
GL500 GLCC.1
IFGT.1
CAHSET2 COMPANY KeyChange CA10.2 CA10.6
JE-NBR
JE-TYPE
ALLOC-NAME
ALLOC-TYPE
CAHSET3 COMPANY KeyChange, Subset CA10.2 CA10.6
BKPST-JE-NBR Where BKPST-JE-NBR != Zeroes CA15.1 CA15.2
JE-TYPE
ALLOC-NAME
ALLOC-TYPE
CAHSET4 COMPANY CA10.1 CA10.2
ALLOC-TYPE CA10.4 CA10.6
ALLOC-NAME CA10.7 CA110
CA15.1 CA15.2
CA199 GL110
CAHSET5 COMPANY KeyChange CA15.1 CA215
STEP
ALLOC-NAME
ALLOC-TYPE
CAHSET6 ALLOCATION-GRPKeyChange CA00.1 CA00.2
ALLOC-TYPE CA110 CA15.2
COMPANY CA200
ALLOC-NAME
CAHSET7 ALLOCATION-GRPKeyChange CA15.2 CA215
STEP
COMPANY
ALLOC-NAME
ALLOC-TYPE
CAHEADER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
Fbheader FBHEADER
CAH-COMPANY -> FBH-COMPANY
CAH-BUDGET-NBR -> FBH-BUDGET-NBR
FBH-FISCAL-YEAR
|
