CADETAIL – Allocation Detail
- System
- General Ledger (GL)
- Prefix
CAD- Primary key
COMPANY,ALLOC-NAME,ALLOC-TYPE,LINE-NBR- Fields
- 44
- Updated by
- 9 programs
- Referenced by
- 66 programs
CADETAIL is the Allocation Detail table in Lawson General Ledger (prefix CAD). It is indexed by COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR (CADSET1); alternate indexes: CADSET2, CADSET3 and CADSET4. It is related 1:1 to ACHEADER, CAHEADER, GLSYSTEM, CMPUTE, GLCHARTDTL, GLCHART, GLCHARTSUM, MXLISTHDR and 1 more and 1:M to RWGRPDET, ACDETAIL and CADETAILAU. It is updated by CA10.1, CA10.2, CA10.4, CA10.6, CA10.7, CA190, CA195, CA210 and 1 more and referenced by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 58 more. The table has 44 fields, 4 indexes and 18 documented relations.
About CADETAIL
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.
Fields (44)
Column = COBOL field name without the CAD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CAD-COMPANY PKCOMPANY | Numeric 4 | The company number related to the allocation detail line. | CA10.1, CA10.4, CA10.7, CA210, GL110, RW298 |
CAD-ALLOC-NAME PKALLOC_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 PKALLOC_TYPE | Alpha 1 | This field defines where the allocation will take place. The values are:
| CA10.1, CA10.4, CA10.6, CA10.7, CA210, RW298 |
CAD-ALLOC-TYPE-1ALLOC_TYPE_1 | Derived | This field, used for drill around, displays the Allocation Type field values. | — |
CAD-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the allocation detail line number. | CA10.1, CA10.4, CA10.7, CA15.1, CA15.2, CA210, RW298 |
CAD-ALLOCATION-GRPALLOCATION_GRP | Alpha 12 | The allocation group where an allocation is stored. | CA10.1, CA10.2, CA10.4, CA10.6, CA10.7, CA210 |
CAD-STEPSTEP | 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-TYPETRANS_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).
| CA10.1, CA10.6, CA10.7, CA210 |
CAD-TRANS-TYPE-1TRANS_TYPE_1 | Derived | This field, used for drill around, displays the Transaction Type field values. | — |
CAD-ALLOC-PERCENTALLOC_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-REVAUTO_REV | 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.
| CA10.1, CA10.6, CA10.7, CA210 |
CAD-AUTO-REV-1AUTO_REV_1 | Derived | This field, used for drill around, displays the auto reversal sign. | — |
CAD-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-COMPANYPT_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-UNITPT_ACCT_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-CODEPT_ALLOC_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-ACCOUNTPT_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-ACCTPT_SUB_ACCT | 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-OPTPT_DETAIL_OPT | 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.
| CA10.1, CA10.7, CA210 |
CAD-PT-DET-OPT-1PT_DET_OPT_1 | Derived | This field, used for drill around, displays the Posting-To Detail Option field values. | — |
CAD-PF-ACCT-UNITPF_ACCT_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-ACCOUNTPF_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-ACCTPF_SUB_ACCT | 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-OPTPF_DETAIL_OPT | 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.
| CA10.1, CA10.7, CA210 |
CAD-PF-DET-OPT-1PF_DET_OPT_1 | Derived | This field, used for drill around, displays the Posting-From Detail Option field values. | — |
CAD-COMPUTE-NAMECOMPUTE_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-UNITACCT_UNIT | Alpha 15 Occurs 3 Times ×3 | The override accounting unit. | CA10.1, CA10.7, CA210 |
CAD-FR-ACCOUNTFR_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-ACCOUNTTH_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-ACCTFR_SUB_ACCT | 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-ACCTTH_SUB_ACCT | Numeric 4 | The override through subaccount range. You cannot select a subaccount range and a subaccount group. | CA10.1, CA10.7, CA210 |
CAD-LEVEL-GROUPLEVEL_GROUP | Alpha 12 | The override level group. | CA10.1, CA10.7, CA210 |
CAD-ACCOUNT-GROUPACCOUNT_GROUP | Alpha 12 | The override account group. | CA10.1, CA10.7, CA210 |
CAD-SUB-ACCT-GRPSUB_ACCT_GRP | Alpha 12 | The override subaccount group. You cannot select a subaccount group and an override subaccount range. | CA10.1, CA10.7, CA210 |
CAD-JE-DESCJE_DESC | 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-LISTMATRIX_LIST | Alpha 12 | The override accounting unit list. | CA10.1, CA10.7, CA210 |
CAD-CHART-NAMECHART_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-IDSUMRY_ACCT_ID | Numeric 6 | The identifier for the summary account. | CA10.1, CA10.7, CA210 |
CAD-SEGMENT-BLOCKSEGMENT_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-LISTACCOUNT_LIST | Alpha 12 | The override account List. | CA10.1, CA10.7, CA210 |
CAD-POOL-ACCT-UNITPOOL_ACCT_UNIT | Alpha 15 Occurs 4 Times ×4 | 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-LISTPOOL_AU_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-GRPPOOL_LVL_GRP | 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 |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
CADSET1 | COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR | Primary | AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source) | |
CADSET2 | COMPANY, ALLOC-TYPE, STEP, ALLOC-NAME, LINE-NBR | KeyChange | CA110 | |
CADSET3 | COMPANY, ALLOC-TYPE, ALLOC-NAME, STEP, LINE-NBR | KeyChange | CA110 | |
CADSET4 | ALLOCATION-GRP, COMPANY, ALLOC-TYPE, STEP, ALLOC-NAME, LINE-NBR | KeyChange | CA110, CA190 |
Relations
One to one (13) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (5) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 | ||
| Cadetailau | CADETAILAU | CAD-COMPANY → CIT-COMPANY, CAD-ALLOC-NAME → CIT-ALLOC-NAME, CAD-ALLOC-TYPE → CIT-ALLOC-TYPE, CAD-LINE-NBR → CIT-LINE-NBR, CIT-ACTION, CIT-DATE, CIT-TIME, CIT-UNIQUE-I-D | ||
| 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 |
Programs
Updated by (9)
- CA10.1 Allocation
- CA10.2 Define Allocation
- CA10.4 Line Copy
- CA10.6 Allocation Copy
- CA10.7 Allocation Detail
- CA190 Allocation Interface
- CA195 Budget Allocation Interface
- CA210 Allocation Edit Listing
- GL110 Company Copy Delete
Referenced by (66)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- CA00.1 Allocation Group
- CA00.2 Allocation Groups
- CA05.1 Allocation Code
- CA05.2 Define Allocation Code
- CA110 Allocation Calculation
- CA15.1 Allocation Control
- CA15.2 Allocation Group Control
- CA160 Allocation Code Interface
- CA215 Allocation Control Listing
- CA240 Allocation Comparison
- GL145 Journal Entry Hold Release
- GL146 Batch Journal Control
- GL148 Zone Rebalancing
- GL167 Balance Interface
- GL170 Recurring Journal Interface
- GL190 Journal Posting
- GL191 Currency Revaluation
- GL196 Report Currency Translation
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL300 General Ledger History Delete
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.3 Speed Entry
- GL40.6 Journal Copy
- GL40.7 Totals
- GL40.8 Journal Entry
- GL41.4 Workflow Journal Entry Update
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- GL500 Fiscal Year Change
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- GL70.6 Recurring Copy
- GL75.1 Recurring Journal Control
- IFGT.1 GLTRANS Interface
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA61.1 Match Invoice Approval
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MAI1.1 Invoke for MAMATCH Object
- RW298 Usage Report