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

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	CA15.1	CA15.2	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	GL500	GL70.1	GL70.2
GL70.3	GL70.6	GL75.1	RW298	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	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 Element: Company	Numeric 4 The company number related to the allocation detail line.	CA10.1 CA10.4 CA10.7 CA210 GL110 RW298
CAD-ALLOC-NAME Element: Allocation Name	Alpha 12 The allocation name represents an allocation as defined in CA10.1 (Allocation).	CA10.1 CA10.4 CA10.6 CA10.7 CA210 RW298
CAD-ALLOC-TYPE Element: Allocation Type	Alpha 1 This field defines where the allocation will take place. The values are: A = Actuals C = Currency Year Budget N = Next Year Budget	CA10.1 CA10.4 CA10.6 CA10.7 CA210 RW298
CAD-ALLOC-TYPE-1 Element: Allocation Type 1	Derived This field, used for drill around, displays the Allocation Type field values.
CAD-LINE-NBR Element: Line Number	Numeric 6 This field contains the allocation detail line number.	CA10.1 CA10.4 CA10.7 CA15.1 CA15.2 CA210 RW298
CAD-ALLOCATION-GRP Element: Allocation Group	Alpha 12 The allocation group where an allocation is stored.	CA10.1 CA10.2 CA10.4 CA10.6 CA10.7 CA210
CAD-STEP Element: Step	Numeric 3 This field determines when an allocation detail line will get processed. All lower steps are processed before processing higher steps.	CA10.1 CA10.2 CA10.4 CA10.6 CA10.7 CA210
CAD-TRANS-TYPE Element: Transaction Type	Alpha 1 The allocation type for each line. The 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	CA10.1 CA10.6 CA10.7 CA210
CAD-TRANS-TYPE-1 Element: Transaction Type 1	Derived This field, used for drill around, displays the Transaction Type field values.
CAD-ALLOC-PERCENT Element: Line Percent	Signed 7.4 The amount to be allocated. The percentage you define multiplied by the From Company account balance = the amount allocated. If you leave this field blank, 100 percent defaults.	CA10.1 CA10.7 CA190 CA195 CA210
CAD-AUTO-REV Element: Auto Reversal	Alpha 1 If you select Yes in this field, GL 199 (Period Closing) creates an opposite entry for this transaction in the next period. The default is No. Y = Yes N = No	CA10.1 CA10.6 CA10.7 CA210
CAD-AUTO-REV-1 Element: Auto Reversal 1	Derived This field, used for drill around, displays the auto reversal sign.
CAD-ACTIVITY Element: Activity	Alpha 15 The activity associated with the allocation. An activity is defined in Project Accounting (AC10.1)	CA10.1 CA10.6 CA10.7 CA210
CAD-ACCT-CATEGORY Element: Account Category	Alpha 5 The account category associated with the allocation. The Account category must exist in Activity Management and must be valid for the activity.	CA10.1 CA10.4 CA10.6 CA10.7 CA210
CAD-PT-COMPANY Element: Posting-To Company	Numeric 4 The company number to which the amounts are allocated. If you select a post-to company and accounting unit, leave the Allocation Code field blank.	CA10.1 CA10.4 CA10.7 CA210 GL110
CAD-PT-ACCT-UNIT Posting-To Accounting Unit	Alpha 15 The accounting unit to which the amounts are allocated If you select a post-to company and accounting unit, leave the Allocation Code field blank.	CA10.1 CA10.7 CA210
CAD-PT-ALLOC-CODE Posting-To Allocation Code	Alpha 12 The allocation code used to allocate to multiple accounting units. You cannot use an allocation code with a compute statement.	CA10.1 CA10.7 CA110 CA210
CAD-PT-ACCOUNT Element: Posting-To Account	Numeric 6 The account number to which amounts are 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.	CA10.1 CA10.7 CA210
CAD-PT-SUB-ACCT Posting-To Subaccount	Numeric 4 The subaccount number to which amounts 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.	CA10.1 CA10.7 CA210
CAD-PT-DETAIL-OPT Posting-To Detail Option	Alpha 1 Determines the Accounting Unit and 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	CA10.1 CA10.7 CA210
CAD-PT-DET-OPT-1 Posting-To Detail Option 1	Derived This field, used for drill around, displays the Posting-To Detail Option field values.
CAD-PF-ACCT-UNIT Posting-From Accounting Unit	Alpha 15 The accounting unit from which the amounts are allocated. If you select override accounting unit information, the program overrides this field when determining the allocated amount.	CA10.1 CA10.7 CA210
CAD-PF-ACCOUNT Element: Posting-From Account	Numeric 6 The account number from which the amounts are allocated. If you select override account information, the program overrides this field when determining the allocated amount.	CA10.1 CA10.7 CA210
CAD-PF-SUB-ACCT Posting-From Subaccount	Numeric 4 The subaccount number from which the amounts are allocated. If you select override subaccounts or a subaccount group, the program overrides this subaccount when determining the allocated amount.	CA10.1 CA10.7 CA210
CAD-PF-DETAIL-OPT Posting-From Detail Option	Alpha 1 The allocation amount that is created 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	CA10.1 CA10.7 CA210
CAD-PF-DET-OPT-1 Posting-From Detail Option 1	Derived This field, used for drill around, displays the Posting-From Detail Option field values.
CAD-COMPUTE-NAME Element: Compute Name	Alpha 12 The compute statement used to determine the percent allocated. You cannot select a compute statement if you selected an allocation code.	CA10.1 CA10.7 CA210
CAD-ACCT-UNIT Element: Accounting Unit	Alpha 15 Occurs 3 Times The override accounting unit.	CA10.1 CA10.7 CA210
CAD-FR-ACCOUNT Element: From Account	Numeric 6 The override From account range If you select an account range, leave the Account Group field blank.	CA10.1 CA10.7 CA210
CAD-TH-ACCOUNT Element: Through Account	Numeric 6 The override Through account range. If you leave this field blank, the from value defaults.	CA10.1 CA10.7 CA210
CAD-FR-SUB-ACCT Element: From Subaccount	Numeric 4 The override From subaccount range. You cannot select a subaccount range and a subaccount group.	CA10.1 CA10.7 CA210
CAD-TH-SUB-ACCT Element: Through Subaccount	Numeric 4 The override through subaccount range. You cannot select a subaccount range and a subaccount group.	CA10.1 CA10.7 CA210
CAD-LEVEL-GROUP Element: Level Group	Alpha 12 The override level group.	CA10.1 CA10.7 CA210
CAD-ACCOUNT-GROUP Element: Account Group	Alpha 12 The override account group.	CA10.1 CA10.7 CA210
CAD-SUB-ACCT-GRP Element: Subaccount Group	Alpha 12 The override subaccount group. You cannot select a subaccount group and an override subaccount range.	CA10.1 CA10.7 CA210
CAD-JE-DESC Journal Entry Description	Alpha 30 You can type a journal entry description that identifies what journal entry number the allocation will post to.	CA10.1 CA10.6 CA10.7 CA210
CAD-MATRIX-LIST Element: Accounting Unit List	Alpha 12 The override accounting unit list.	CA10.1 CA10.7 CA210
CAD-CHART-NAME Element: Chart Name	Alpha 12 The chart of accounts name. If you select a chart of accounts, select a summary account.	CA10.1 CA10.7 CA210
CAD-SUMRY-ACCT-ID Element: Summary Account ID	Numeric 6 The identifier for the summary account.	CA10.1 CA10.7 CA210
CAD-SEGMENT-BLOCK Element: 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.	CA10.1 CA10.7 CA210
CAD-ACCOUNT-LIST Element: Account List	Alpha 12 The override account List.	CA10.1 CA10.7 CA210
CAD-POOL-ACCT-UNIT Element: Pool Accounting Unit	Alpha 15 Occurs 4 Times The 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.	CA10.1 CA10.7 CA210
CAD-POOL-AU-LIST Pool Accounting Unit List	Alpha 12 The pool accounting unit list can be used with a compute data name, such as CPAMT, when the source amount account units are different than the post from accounting units..	CA10.1 CA10.7 CA210
CAD-POOL-LVL-GRP Element: Pool Level Group	Alpha 12 The 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.	CA10.1 CA10.7 CA210

CADETAIL FILE INDEX

CADETAIL FILE RELATIONS

ONE TO ONE RELATIONS

CADETAIL FILE RELATIONS

ONE TO MANY RELATIONS

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