GLSUBACDTL

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


UPDATED BY
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.
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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSDSET1 SUB-ACCOUNT
SUB-ACCT-TMPLT
GSDSET2 SUB-ACCT-TMPLT
SUB-ACCOUNT
GL02.3 GL13.1
GL13.2 GL13.4
GL160 GL213
GL60.1


GLSUBACDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxlisthdr MXLISTHDR Not Required
"ACCTU"->MLH-OBJ-TYPE
GSD-DYNAMIC-LIST->MLH-MATRIX-LIST
Trcodes TRCODES Not Required
GSD-TRANSL-CODE->TRC-TRANSL-CODE


GLSUBACDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsubacvld GLSUBACVLD
GSD-SUB-ACCT-TMPLT->GSV-SUB-ACCT-TMPLT
GSD-SUB-ACCOUNT->GSV-SUB-ACCOUNT
  GSV-SYSTEM


File created: Thu Jun 09 02:14:10 2016

Home
Contact Us



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