|
CADETAIL FILE
Allocation Detail
The Allocation Detail file contains the allocation detail information defined
that is used to allocate amounts from a company accounting structure to
another company accounting structure.
REFERENCED BY
CA15.1 CA15.2 CA215 CA240 RW298 CA110
UPDATED BY
CA10.1 CA10.2 CA10.4 CA10.6 CA10.7 CA190
CA195 CA210 GL110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAD-COMPANY Numeric 4 CA10.1 CA10.4
Element: Company The company number related to the CA10.7 CA210
allocation detail line. GL110 RW298
CAD-ALLOC-NAME Alpha 12 CA10.1 CA10.4
Element: Allocation NamThe allocation name represents an CA10.6 CA10.7
allocation as defined in CA10.1 CA210 RW298
(Allocation).
CAD-ALLOC-TYPE Alpha 1 CA10.1 CA10.4
Element: Allocation TypThis field defines where the allocation CA10.6 CA10.7
will take place. CA210 RW298
The values are:
A = Actuals
C = Currency Year Budget
N = Next Year Budget
CAD-ALLOC-TYPE-1 Derived
Element: Allocation TypThis field, used for drill around,
displays the Allocation Type field
values.
CAD-LINE-NBR Numeric 6 CA10.1 CA10.4
Element: Line Number This field contains the allocation CA10.7 CA15.1
detail line number. CA15.2 CA210
RW298
CAD-ALLOCATION-GRP Alpha 12 CA10.1 CA10.2
Element: Allocation GroThe allocation group where an CA10.4 CA10.6
allocation is stored. CA10.7 CA210
CAD-STEP Numeric 3 CA10.1 CA10.2
Element: Step This field determines when an CA10.4 CA10.6
allocation detail line will get CA10.7 CA210
processed. All lower steps are
processed before processing higher
steps.
CAD-TRANS-TYPE Alpha 1 CA10.1 CA10.6
Element: Transaction TyThe allocation type for each line. The CA10.7 CA210
default is Amount.
To allocate units, the Post From and
Post To accounts must allow units. You
can verify this in GL20.1 (Chart of
Accounts).
A = Amounts
U = Units
CAD-TRANS-TYPE-1 Derived
Element: Transaction TyThis field, used for drill around,
displays the Transaction Type field
values.
CAD-ALLOC-PERCENT Signed 7.4 CA10.1 CA10.7
Element: Line Percent The amount to be allocated. CA190 CA195
CA210
The percentage you define multiplied by
the From Company account balance = the
amount allocated.
If you leave this field blank, 100
percent defaults.
CAD-AUTO-REV Alpha 1 CA10.1 CA10.6
Element: Auto Reversal If you select Yes in this field, GL 199 CA10.7 CA210
(Period Closing) creates an opposite
entry for this transaction in the next
period.
The default is No.
Y = Yes
N = No
CAD-AUTO-REV-1 Derived
Element: Auto Reversal This field, used for drill around,
displays the auto reversal sign.
CAD-ACTIVITY Alpha 15 CA10.1 CA10.6
Element: Activity The activity associated with the CA10.7 CA210
allocation. An activity is defined in
Project Accounting (AC10.1)
CAD-ACCT-CATEGORY Alpha 5 CA10.1 CA10.6
Element: Account CategoThe account category associated with the CA10.7 CA210
allocation.
The Account category must exist in
Activity Management and must be valid
for the activity.
CAD-PT-COMPANY Numeric 4 CA10.1 CA10.7
Element: Posting-To ComThe company number to which the amounts CA210 GL110
are allocated.
If you select a post-to company and
accounting unit, leave the Allocation
Code field blank.
CAD-PT-ACCT-UNIT Alpha 15 CA10.1 CA10.7
Posting-To The accounting unit to which the CA210
Accounting Unit amounts are allocated
If you select a post-to company and
accounting unit, leave the Allocation
Code field blank.
CAD-PT-ALLOC-CODE Alpha 12 CA10.1 CA10.7
Posting-To The allocation code used to allocate to CA110 CA210
Allocation Code multiple accounting units.
You cannot use an allocation code with a
compute statement.
CAD-PT-ACCOUNT Numeric 6 CA10.1 CA10.7
Element: Posting-To AccThe account number to which amounts are CA210
allocated.
If you select an override account range
and an error occurs when you run CA110
(Allocation Calculation), this account
defaults. If this account is invalid,
the system uses the company error
suspense account.
CAD-PT-SUB-ACCT Numeric 4 CA10.1 CA10.7
Posting-To The subaccount number to which amounts CA210
Subaccount are allocated.
If you select an override subaccount
range and an error occurs when you run
CA110 (Allocation Calculation), this
subaccount defaults. If this subaccount
is invalid, the system uses the company
error suspense account.
CAD-PT-DETAIL-OPT Alpha 1 CA10.1 CA10.7
Posting-To Detail Determines the Accounting Unit and CA210
Option Account allocation detail on the Post to
side. The default is Consolidate.
Select one of the following Post To
options:
Consolidate creates one transaction
line for each variable in the From
Accounting Unit and Account fields.
Level Detail creates as many
transaction lines as there are unique
variable levels in the override
information. The transaction contains
the From Account and From Subaccount
fields.
Account Detail creates as many
transaction lines as there are unique
accounts and subaccounts in the override
information. The transaction contains
the To side accounting unit.
Full Detail creates as many transaction
lines as there are unique accounting
unit, account, and subaccount
combinations in the override
information.
C = Consolidate
L = Level Detail
A = Acct Detail
D = Full Detail
CAD-PT-DET-OPT-1 Derived
Posting-To Detail This field, used for drill around,
Option 1 displays the Posting-To Detail Option
field values.
CAD-PF-ACCT-UNIT Alpha 15 CA10.1 CA10.7
Posting-From The accounting unit from which the CA210
Accounting Unit amounts are allocated.
If you select override accounting unit
information, the program overrides this
field when determining the allocated
amount.
CAD-PF-ACCOUNT Numeric 6 CA10.1 CA10.7
Element: Posting-From AThe account number from which the CA210
amounts are allocated.
If you select override account
information, the program overrides this
field when determining the allocated
amount.
CAD-PF-SUB-ACCT Numeric 4 CA10.1 CA10.7
Posting-From The subaccount number from which the CA210
Subaccount amounts are allocated.
If you select override subaccounts or a
subaccount group, the program overrides
this subaccount when determining the
allocated amount.
CAD-PF-DETAIL-OPT Alpha 1 CA10.1 CA10.7
Posting-From Detail The allocation amount that is created CA210
Option when you post. The default is
Consolidate.
Select one of the following Post From
options:
Consolidate creates one transaction
line for each variable level in the From
Accounting Unit and Account fields.
Level Detail creates as many
transaction lines as there are unique
variable levels for the From Accounting
Unit override fields. The transaction
uses the account and subaccount in the
From detail line.
Account Detail creates as many
transaction lines as there are unique
accounts and subaccounts in the override
information. The transaction uses the
accounting unit on the From detail line.
Full Detail creates as many transaction
lines as there are unique accounting
unit, account, and subaccount
combinations in the override
information.
C = Consolidate
L = Level Detail
A = Acct Detail
D = Full Detail
CAD-PF-DET-OPT-1 Derived
Posting-From Detail This field, used for drill around,
Option 1 displays the Posting-From Detail Option
field values.
CAD-COMPUTE-NAME Alpha 12 CA10.1 CA10.7
Element: Compute Name The compute statement used to determine CA210
the percent allocated.
You cannot select a compute statement if
you selected an allocation code.
CAD-ACCT-UNIT Alpha 15 Occurs 3 Times CA10.1 CA10.7
Element: Accounting UniThe override accounting unit. CA210
CAD-FR-ACCOUNT Numeric 6 CA10.1 CA10.7
Element: From Account The override From account range CA210
If you select an account range, leave
the Account Group field blank.
CAD-TH-ACCOUNT Numeric 6 CA10.1 CA10.7
Element: Through AccounThe override Through account range. CA210
If you leave this field blank, the from
value defaults.
CAD-FR-SUB-ACCT Numeric 4 CA10.1 CA10.7
Element: From SubaccounThe override From subaccount range. CA210
You cannot select a subaccount range
and a subaccount group.
CAD-TH-SUB-ACCT Numeric 4 CA10.1 CA10.7
Element: Through SubaccThe override through subaccount range. CA210
You cannot select a subaccount range
and a subaccount group.
CAD-LEVEL-GROUP Alpha 12 CA10.1 CA10.7
Element: Level Group The override level group. CA210
CAD-ACCOUNT-GROUP Alpha 12 CA10.1 CA10.7
Element: Account Group The override account group. CA210
CAD-SUB-ACCT-GRP Alpha 12 CA10.1 CA10.7
Element: Subaccount GroThe override subaccount group. CA210
You cannot select a subaccount group
and an override subaccount range.
CAD-JE-DESC Alpha 30 CA10.1 CA10.6
Journal Entry You can type a journal entry CA10.7 CA210
Description description that identifies what journal
entry number the allocation will post
to.
CAD-MATRIX-LIST Alpha 12 CA10.1 CA10.7
Element: Accounting UniThe override accounting unit list. CA210
CAD-CHART-NAME Alpha 12 CA10.1 CA10.7
Element: Chart Name The chart of accounts name. CA210
If you select a chart of accounts,
select a summary account.
CAD-SUMRY-ACCT-ID Numeric 6 CA10.1 CA10.7
Element: Summary AccounThe identifier for the summary account. CA210
CAD-SEGMENT-BLOCK Alpha 103 CA10.1 CA10.7
Element: Segment Block This field identifies the user analysis CA210
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.
CAD-ACCOUNT-LIST Alpha 12 CA10.1 CA10.7
Element: Account List The override account List. CA210
CAD-POOL-ACCT-UNIT Alpha 15 Occurs 4 Times CA10.1 CA10.7
Element: Pool AccountinThe pool accounting unit can be used
with a compute data name, such as CPAMT,
when the source accounting unit amount
is different than the post from
accounting unit.
CAD-POOL-AU-LIST Alpha 12 CA10.1 CA10.7
Pool Accounting The pool accounting unit list can be
Unit List used with a compute data name, such as
CPAMT, when the source amount account
units are different than the post from
accounting units..
CAD-POOL-LVL-GRP Alpha 12 CA10.1 CA10.7
Element: Pool Level GroThe pool level group can be used with a
compute data name, such as CPAMT, when
the source accounting units are
different that the post from accounting
units.
CADETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CADSET1 COMPANY CA10.1 CA10.2
ALLOC-NAME CA10.4 CA10.5
ALLOC-TYPE CA10.6 CA10.7
LINE-NBR CA15.1 CA15.2
CA190 CA195
CA210 CA215
CA240 GL110
RW298
CADSET2 COMPANY KeyChange CA110
ALLOC-TYPE
STEP
ALLOC-NAME
LINE-NBR
CADSET3 COMPANY KeyChange CA110
ALLOC-TYPE
ALLOC-NAME
STEP
LINE-NBR
CADSET4 ALLOCATION-GRPKeyChange CA110 CA190
COMPANY
ALLOC-TYPE
STEP
ALLOC-NAME
LINE-NBR
CADETAIL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
All Cod Hdr ACHEADER Not Required
CAD-PT-ALLOC-CODE -> ALH-ALLOC-CODE
Allocation CAHEADER Required
CAD-COMPANY -> CAH-COMPANY
CAD-ALLOC-NAME -> CAH-ALLOC-NAME
CAD-ALLOC-TYPE -> CAH-ALLOC-TYPE
Company GLSYSTEM Required
CAD-COMPANY -> GLS-COMPANY
Compute CMPUTE Not Required
CAD-COMPUTE-NAME -> CMP-COMPUTE-NAME
From Chart Dtl GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
CAD-PF-ACCOUNT -> GDT-ACCOUNT
CAD-PF-SUB-ACCT -> GDT-SUB-ACCOUNT
Glchart GLCHART Not Required
CAD-CHART-NAME -> GCH-CHART-NAME
Glchartsum GLCHARTSUM Not Required
CAD-CHART-NAME -> GCS-CHART-NAME
CAD-SUMRY-ACCT-ID -> GCS-SUMRY-ACCT-ID
Mxlisthdr MXLISTHDR Not Required
"ACCTU" -> MLH-OBJ-TYPE
CAD-MATRIX-LIST -> MLH-MATRIX-LIST
Post Fr Au GLNAMES Required
CAD-COMPANY -> GLN-COMPANY
CAD-PF-ACCT-UNIT -> GLN-ACCT-UNIT
Post To Au GLNAMES Not Required
CAD-PT-COMPANY -> GLN-COMPANY
CAD-PT-ACCT-UNIT -> GLN-ACCT-UNIT
Post To Comp GLSYSTEM Not Required
CAD-PT-COMPANY -> GLS-COMPANY
Pst To Company GLSYSTEM Not Required
CAD-PT-COMPANY -> GLS-COMPANY
To Chart Dtl GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
CAD-PT-ACCOUNT -> GDT-ACCOUNT
CAD-PT-SUB-ACCT -> GDT-SUB-ACCOUNT
CADETAIL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Grp Det RWGRPDET
"A" -> RGD-RECORD-TYPE
CAD-ACCOUNT-GROUP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
All Cod Det ACDETAIL
CAD-PT-ALLOC-CODE -> ALD-ALLOC-CODE
ALD-COMPANY
ALD-ACCT-UNIT
Lvl Grp Det RWGRPDET
"L" -> RGD-RECORD-TYPE
CAD-LEVEL-GROUP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
Sub Grp Det RWGRPDET
"S" -> RGD-RECORD-TYPE
CAD-SUB-ACCT-GRP -> RGD-HEAD-NAME
RGD-RANGE-NUMBER
|