GL Subaccount Detail
This file maintains the subaccount number and details of each subaccount within a subaccount template.
REFERENCED BY
GL02.3 | GL160 | GL213 | GL60.1 |
GL13.1 | GL13.4 | GL13.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
GSD-SUB-ACCT-TMPLT Element: Sub Acct Tmplt | Alpha 12 This field contains name of the subaccont template to which the subaccount belongs. |
|
||
GSD-SUB-ACCOUNT Element: Sub Acct | Numeric 4 This field contains the subaccount number. |
|
||
GSD-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field contains the subaccount description. |
|
||
GSD-SPACE-CODE Element: Space Code | Numeric 1 This field indicates the number of spaces to advance after the account appears on a report. 1 = Advance One Line 2 = Advance Two Lines 3 = Advance Three Lines 9 = Advance To Next Page |
|
||
GSD-SIGN-CODE Element: Sign Code | Alpha 1 This field determines if the system prints a negative sign next to a positive amount. Reversing the sign only affects report printing, not account totaling. Valid values are: Y = Yes N = No N = No If you leave this field blank, No defaults and the system prints a negative sign for a negative amount. |
|
||
GSD-UNITS-CODE Element: Units Code | Alpha 1 This field determines if units are allowed in the subaccount. Valid values are: Y= Yes (Allow both) N = No (Allow only amounts) O = Only (Allow only units) Y = Yes |
|
||
GSD-ACTIVITY-REQ Element: Activity Req | Alpha 1 This field indicates if an activity is required. Valid values are: Y = Yes N = No B = Blank Blank means that the field takes on the value assigned for this field to the account that this subaccount is attached to. |
|
||
GSD-POSTING-LEVEL Element: Posting Level | Alpha 1 This field determines if transactions are interfaced to the Lawson General Ledger system in summary or detail form. Valid values are: S = Summary D = Detail |
|
||
GSD-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code. |
|
||
GSD-CURR-CONTROL Element: Curr Control | Alpha 1 This field lets you limit all transactions to one currency. 0 = No 1 = Yes |
|
||
GSD-TRANSL-CODE Element: Transl Code | Alpha 2 This field identifies the translation rate applied against the subaccount balance to calculate the translation value. |
|
||
GSD-REVALUE Element: Revalue | Alpha 1 This field indicates whether to revalue non-base transactions of an account into the company base currency.. 0 = No 1 = Yes |
|
||
GSD-ACTIVE-STATUS Element: Active Status | Alpha 1 This field determines the status of the account. If Inactive, no posting can be done to the account. A = Active I = Inactive |
|
||
GSD-DYNAMIC-LIST Element: Matrix List | Alpha 12 This field defines a list of accounting units to which the account is automatically assigned.. |
|
||
GSD-RESTRICT-SYS Element: Restrict Sys | Alpha 1 This field indicates whether account usage is restricted to specified system codes. Valid values are: Y = Yes (Restrict to systems specified) N = No (no restriction) Blank (inherits the restrictions defined for the summary account it is associated with) " " = Sum Acct Default |
|
||
GSD-ACCT-CATEGORY Element: Acct Category | Alpha 5 This field contains the default account category to be used, if you use the Activity system. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. |
|
||
GSD-DAILY-BALANCE Element: All Flag | Alpha 1 This field indicates whether transactions can be viewed on a daily basis. Valid values are: Y = Yes N = No |
|
||
GSD-RELATION Element: Relation | Alpha 15 This field defines a user analysis value relation to associate with the subaccount. The relation must exist in User Analysis Value Relation (SL02.1). |
|
||
GSD-UNARY-OPER Element: Unary Oper | Alpha 1 This field contains the mathematical operation to consolidate amounts for a natural balance. Valid values are: + = Add - = Subtract * = Multiply / = Divide % = Percentile ~ = Do nothing The default is Add. Only used by the OLAP environment. " " = Do Nothing |
|
||
GSD-NAT-BALANCE Element: Nat Balance | Alpha 1 This field determines whether the natural balance is a Debit (D) or Credit (C). This field is not required. This is only used by the OLAP environment. D = Debit C = Credit |
|
||
GSD-SL-ACCT-FLAG Element: Sl Acct Flag | Alpha 1 This flag determines whether user analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection. Y = Yes N = No " " = Sum Acct Default |
|
||
GSD-LEDGER-GROUP Element: Ledger Group | Alpha 15 |
|
||
GSD-GL-BUD-FL Element: Gl Bud Fl | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GSDSET1 |
SUB-ACCOUNT SUB-ACCT-TMPLT |
|
|||||||||||||||
GSDSET2 |
SUB-ACCT-TMPLT SUB-ACCOUNT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Mxlisthdr | MXLISTHDR |
Not Required
| ||||||
Trcodes | TRCODES |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Glsubacvld | GLSUBACVLD |
|
All trademarks and registered trademarks are the property of their
respective owners.