Allocation Transactions
The Allocation Transaction file contains the allocations transactions to be posted to the Lawson General Ledger system.
REFERENCED BY
GLRV.1 | MLRV.1 | CA15.1 | CA15.2 | CA210 | CA215 |
CA10.1 | CA10.2 | CA10.4 | CA10.5 | CA10.7 | CA110 |
CA190 | CA195 | CA290 | GL110 | GL500 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
CAT-COMPANY Element: Company | Numeric 4 The company number you are defining the allocation for. |
|
||
CAT-ALLOC-NAME Element: Allocation | Alpha 12 The allocation name represents an allocation as defined in CA10.1 (Allocation). |
|
||
CAT-ALLOC-TYPE Element: Allocation Type | Alpha 1 This field defines what the allocation affects: actual amounts, current year budget, or next year's budget. A = Actual C = Current Year Budget N = Next Year Budget |
|
||
CAT-LINE-NBR Element: Line Number | Numeric 6 This field contains the allocation detail line number. |
|
||
CAT-ALLOCATION-GRP Element: Allocation Group | Alpha 12 The allocation group where the allocation is stored. |
|
||
CAT-SEQ-NUMBER Element: Sequence Number | Numeric 6 The sequence number is a unique number assigned to each transaction. |
|
||
CAT-FISCAL-YEAR Element: Fiscal Year | Numeric 4 This is the fiscal year for the transaction. |
|
||
CAT-ACCT-PERIOD Element: Accounting Period | Numeric 2 This is the accounting period for the transaction. |
|
||
CAT-TRANS-TYPE Element: Transaction Type | Alpha 1 This field determines whether amounts or units are processed for the transaction. A = Amounts U = Units |
|
||
CAT-STEP Element: Step | Numeric 3 This field determines when in a series of steps an allocation detail line gets processed. Lower-numbered steps are processed before higher steps. |
|
||
CAT-ACCOUNT Element: Account | Numeric 6 This field and the accounting unit and subaccount define the location (account) where amounts and other account information are stored. |
|
||
CAT-SUB-ACCOUNT Element: Subaccount | Numeric 4 This field and the accounting unit and account define the location (account) where amounts and other account information are stored. |
|
||
CAT-GLT-COMPANY Element: Company | Numeric 4 This is the company the transactions are for. |
|
||
CAT-ACCT-UNIT Element: Accounting Unit | Alpha 15 The accounting unit is a shorthand notation representing a location (variable level) in the company structure. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||
CAT-TO-BUDGET Element: To Budget | Numeric 3 This is the budget allocated to. |
|
||
CAT-BKPST-FLAG Element: Backposting Flag | Alpha 1 This field determines whether the transaction is to be back-posted. Y = Yes N = No |
|
||
CAT-RECORD-TYPE Element: Record Type | Alpha 1 This field indicates the type of record defined: To or From. F = From T = To |
|
||
CAT-AMOUNT-UNITS Element: Amounts or Units | Signed 18.2 Occurs 13 Times This field indicates the amounts or units to be posted to an account for the period. |
|
||
CAT-RPT-AMOUNT-1 Element: Report One Amount | Signed 18.2 Occurs 13 Times This field stores the amounts calculatd by CA110 in Report Currency 1. |
|
||
CAT-RPT-AMOUNT-2 Element: Report Two Amount | Signed 18.2 Occurs 13 Times This field stores the amounts calculated by CA110 in Report Currency 2. |
|
||
CAT-TRAN-ND Element: Transaction Number | Numeric 1 This is the number of decimal positions used for the transaction. |
|
||
CAT-JE-NBR Element: Journal Entry Number | Numeric 8 This is the journal entry number in the Lawson General Ledger system. |
|
||
CAT-JE-TYPE Element: Journal Entry Type | Alpha 1 The type of the journal entry: normal or intercompany. N = Normal I = Intercompany |
|
||
CAT-JE-DESC Journal Entry Description | Alpha 30 This is the journal entry description. |
|
||
CAT-ACTIVITY Element: Activity | Alpha 15 The activity associated with the allocation. |
|
||
CAT-ACCT-CATEGORY Element: Account Category | Alpha 5 The account category associated with the allocation. Account categories are the Activity Management accounts by which activity transactions are grouped for budgeting and reporting. Set up account categories for an activity before you do any budgeting or transaction processing. Using account categories, you can sort and combine incoming amounts into groups for reporting and inquiry on activities. You can tie account categories to general ledger accounts using AC07.1 (Account Assignment). You can also streamline your maintenance of changes to general ledger accounts; use AC04.1 (GL Code) to define GL codes to represent general ledger accounts. |
|
||
CAT-AUTO-REV Element: Auto Reversal | Alpha 1 When the Auto Reversal field is Yes, GL199 (Period Closing) creates an opposite entry for this transaction in the next period. Y = Yes N = No |
|
||
CAT-TRANS-DATE Element: Transaction Date | Numeric 8 (yyyymmdd) The date of the transaction. |
|
||
CAT-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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CATSET1 |
COMPANY ALLOC-NAME ALLOC-TYPE LINE-NBR SEQ-NUMBER |
|
| ||||||||||||||||||
CATSET2 |
COMPANY ALLOC-TYPE STEP ALLOC-NAME SEQ-NUMBER |
|
| ||||||||||||||||||
CATSET3 |
COMPANY FISCAL-YEAR ACCT-PERIOD ALLOC-TYPE ALLOC-NAME STEP GLT-COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT SEQ-NUMBER |
|
| ||||||||||||||||||
CATSET4 |
FISCAL-YEAR ACCT-PERIOD ALLOC-TYPE TRANS-TYPE GLT-COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT STEP SEQ-NUMBER COMPANY ALLOC-NAME |
|
| ||||||||||||||||||
CATSET5 |
ALLOCATION-GRP COMPANY FISCAL-YEAR ACCT-PERIOD ALLOC-TYPE ALLOC-NAME STEP GLT-COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT SEQ-NUMBER |
|
| ||||||||||||||||||
CATSET6 |
ALLOCATION-GRP FISCAL-YEAR ACCT-PERIOD ALLOC-TYPE TRANS-TYPE GLT-COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT STEP SEQ-NUMBER COMPANY ALLOC-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Account | GLMASTER |
Required
| ||||||||||||
Acct Unit | GLNAMES |
Required
| ||||||||||||
Alloc Name | CAHEADER |
Not Required
| ||||||||||||
Chart Detail | GLCHARTDTL |
Not Required
| ||||||||||||
Company | GLSYSTEM |
Required
| ||||||||||||
To Company | GLSYSTEM |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.