|
|
GLSUBACDTL FILE
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 Alpha 12 GL13.1
Element: Sub Acct TmpltThis field contains name of the
subaccont template to which the
subaccount belongs.
GSD-SUB-ACCOUNT Numeric 4 GL13.1
Element: Sub Acct This field contains the subaccount
number.
GSD-DESCRIPTION Alpha 30 (Lower Case) GL13.1
Element: Description This field contains the subaccount
description.
GSD-SPACE-CODE Numeric 1 GL13.1
Element: Space Code 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 Alpha 1 GL13.1
Element: Sign Code 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 Alpha 1 GL13.1
Element: Units Code 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 Alpha 1 GL13.1
Element: Activity Req 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 Alpha 1 GL13.1
Element: Posting Level 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 Alpha 5 GL13.1
Element: Currency Code This field contains the company base
currency code.
GSD-CURR-CONTROL Alpha 1 GL13.1
Element: Curr Control This field lets you limit all
transactions to one currency.
0 = No
1 = Yes
GSD-TRANSL-CODE Alpha 2 GL13.1
Element: Transl Code This field identifies the translation
rate applied against the subaccount
balance to calculate the translation
value.
GSD-REVALUE Alpha 1 GL13.1
Element: Revalue This field indicates whether to revalue
non-base transactions of an account into
the company base currency..
0 = No
1 = Yes
GSD-ACTIVE-STATUS Alpha 1 GL13.1
Element: Active Status 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 Alpha 12 GL13.1
Element: Matrix List This field defines a list of accounting
units to which the account is
automatically assigned..
GSD-RESTRICT-SYS Alpha 1 GL13.1
Element: Restrict Sys 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 Alpha 5 GL13.1
Element: Acct Category 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 Alpha 1 GL13.1
Element: All Flag This field indicates whether
transactions can be viewed on a daily
basis.
Valid values are:
Y = Yes
N = No
GSD-RELATION Alpha 15 GL13.1
Element: Relation 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 Alpha 1 GL13.1
Element: Unary Oper 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 Alpha 1 GL13.1
Element: Nat Balance 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 Alpha 1 GL13.1
Element: Sl Acct Flag 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 Alpha 15 GL13.1
Element: Ledger Group
GSD-GL-BUD-FL Alpha 1 GL13.1
Element: Gl Bud Fl
GLSUBACDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSDSET1 SUB-ACCOUNT
SUB-ACCT-TMPLT
GSDSET2 SUB-ACCT-TMPLT GL02.3 GL13.1
SUB-ACCOUNT GL13.2 GL13.4
GL160 GL213
GL60.1
GLSUBACDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsubacvld GLSUBACVLD
GSD-SUB-ACCT-TMPLT -> GSV-SUB-ACCT-TMPLT
GSD-SUB-ACCOUNT -> GSV-SUB-ACCOUNT
GSV-SYSTEM
|
