GL Subaccount Detail

This file maintains the subaccount number and details of each subaccount within a subaccount template.
UPDATED BY

GL13.1	GL13.4	GL13.2	GL02.3	GL160	GL213
GL60.1

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.	GL13.1
GSD-SUB-ACCOUNT Element: Sub Acct	Numeric 4 This field contains the subaccount number.	GL13.1
GSD-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field contains the subaccount description.	GL13.1
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	GL13.1
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.	GL13.1
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	GL13.1
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.	GL13.1
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	GL13.1
GSD-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code.	GL13.1
GSD-CURR-CONTROL Element: Curr Control	Alpha 1 This field lets you limit all transactions to one currency. 0 = No 1 = Yes	GL13.1
GSD-TRANSL-CODE Element: Transl Code	Alpha 2 This field identifies the translation rate applied against the subaccount balance to calculate the translation value.	GL13.1
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	GL13.1
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	GL13.1
GSD-DYNAMIC-LIST Element: Matrix List	Alpha 12 This field defines a list of accounting units to which the account is automatically assigned..	GL13.1
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	GL13.1
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.	GL13.1
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	GL13.1
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).	GL13.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	GL13.1
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	GL13.1
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	GL13.1
GSD-LEDGER-GROUP Element: Ledger Group	Alpha 15	GL13.1
GSD-GL-BUD-FL Element: Gl Bud Fl	Alpha 1	GL13.1

GLSUBACDTL FILE INDEX

GLSUBACDTL FILE RELATIONS

ONE TO ONE RELATIONS

GLSUBACDTL FILE RELATIONS

ONE TO MANY RELATIONS

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