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 |
| CA10.1 | CA10.2 | CA10.4 | CA10.5 | CA10.6 | CA10.7 |
| CA110 | 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. |
|
||||||||
| CAD-ALLOC-NAME Element: Allocation Name | Alpha 12 The allocation name represents an allocation as defined in CA10.1 (Allocation). |
|
||||||||
| 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 |
|
||||||||
| 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. |
|
||||||||
| CAD-ALLOCATION-GRP Element: Allocation Group | Alpha 12 The allocation group where an allocation is stored. |
|
||||||||
| 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. |
|
||||||||
| 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 |
|
||||||||
| 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. |
|
||||||||
| 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 |
|
||||||||
| 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) |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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 |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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. |
|
||||||||
| 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 |
|
||||||||
| 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. |
|
||||||||
| CAD-ACCT-UNIT Element: Accounting Unit | Alpha 15 Occurs 3 Times The override accounting unit. |
|
||||||||
| 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. |
|
||||||||
| CAD-TH-ACCOUNT Element: Through Account | Numeric 6 The override Through account range. If you leave this field blank, the from value defaults. |
|
||||||||
| CAD-FR-SUB-ACCT Element: From Subaccount | Numeric 4 The override From subaccount range. You cannot select a subaccount range and a subaccount group. |
|
||||||||
| CAD-TH-SUB-ACCT Element: Through Subaccount | Numeric 4 The override through subaccount range. You cannot select a subaccount range and a subaccount group. |
|
||||||||
| CAD-LEVEL-GROUP Element: Level Group | Alpha 12 The override level group. |
|
||||||||
| CAD-ACCOUNT-GROUP Element: Account Group | Alpha 12 The override account group. |
|
||||||||
| CAD-SUB-ACCT-GRP Element: Subaccount Group | Alpha 12 The override subaccount group. You cannot select a subaccount group and an override subaccount range. |
|
||||||||
| 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. |
|
||||||||
| CAD-MATRIX-LIST Element: Accounting Unit List | Alpha 12 The override accounting unit list. |
|
||||||||
| CAD-CHART-NAME Element: Chart Name | Alpha 12 The chart of accounts name. If you select a chart of accounts, select a summary account. |
|
||||||||
| CAD-SUMRY-ACCT-ID Element: Summary Account ID | Numeric 6 The identifier for the summary account. |
|
||||||||
| 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. |
|
||||||||
| CAD-ACCOUNT-LIST Element: Account List | Alpha 12 The override account List. |
|
||||||||
| 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. |
|
||||||||
| 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.. |
|
||||||||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CADSET1 |
COMPANY ALLOC-NAME ALLOC-TYPE LINE-NBR |
|
| ||||||||||||||||||||||
| CADSET2 |
COMPANY ALLOC-TYPE STEP ALLOC-NAME LINE-NBR |
|
| ||||||||||||||||||||||
| CADSET3 |
COMPANY ALLOC-TYPE ALLOC-NAME STEP LINE-NBR |
|
| ||||||||||||||||||||||
| CADSET4 |
ALLOCATION-GRP COMPANY ALLOC-TYPE STEP ALLOC-NAME LINE-NBR |
|
| ||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| All Cod Hdr | ACHEADER |
Not Required
| |||||||||
| Allocation | CAHEADER |
Required
| |||||||||
| Company | GLSYSTEM |
Required
| |||||||||
| Compute | CMPUTE |
Not Required
| |||||||||
| From Chart Dtl | GLCHARTDTL |
Not Required
| |||||||||
| Glchart | GLCHART |
Not Required
| |||||||||
| Glchartsum | GLCHARTSUM |
Not Required
| |||||||||
| Mxlisthdr | MXLISTHDR |
Not Required
| |||||||||
| Post Fr Au | GLNAMES |
Required
| |||||||||
| Post To Au | GLNAMES |
Not Required
| |||||||||
| Post To Comp | GLSYSTEM |
Not Required
| |||||||||
| Pst To Company | GLSYSTEM |
Not Required
| |||||||||
| To Chart Dtl | GLCHARTDTL |
Not Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Acct Grp Det | RWGRPDET |
| |||||||||
| All Cod Det | ACDETAIL |
| |||||||||
| Lvl Grp Det | RWGRPDET |
| |||||||||
| Sub Grp Det | RWGRPDET |
|
All trademarks and registered trademarks are the property of their
respective owners.