|
|
GLCLSAUDIT FILE
GL Closing Audit
The General Ledger Closing Audit file contains the company general ledger
closing information for a specific period and fiscal year.
UPDATED BY
GL110 GL199 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCA-COMPANY Numeric 4 GL199 GL500
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
GCA-FISCAL-YEAR Numeric 4 GL199 GL500
Element: Fiscal Year Contains the fiscal year for the data
stored on this record.
GCA-ACCT-PERIOD Numeric 2 GL199 GL500
Element: Accounting PerThis is the current accounting period.
This field is updated by GL199 (Period
Closing).
GCA-CLOSE-SEQ Numeric 2 GL199 GL500
Element: Close SequenceThe General Ledger close sequence.
GCA-CLOSE-DATE Numeric 8 (yyyymmdd) GL199 GL500
Element: Close Date The General Ledger period close date.
GCA-CLOSE-TIME Numeric 6 (hhmmss) GL199 GL500
Element: Close Time The General Ledger period close time.
GCA-PER-END-CODE Alpha 1 GL199 GL500
Element: Period End CodThe General Ledger period closing
option.
L = Limited
F = Final
GLCLSAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCASET1 COMPANY GL110 GL199
FISCAL-YEAR GL500
ACCT-PERIOD
CLOSE-SEQ
GLCLSAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GCA-COMPANY -> GLS-COMPANY
GLCLSAUDIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glcontrol GLCONTROL
GCA-COMPANY -> GLC-COMPANY
GCA-FISCAL-YEAR -> GLC-FISCAL-YEAR
GCA-ACCT-PERIOD -> GLC-ACCT-PERIOD
GCA-CLOSE-SEQ -> GLC-CLOSE-SEQ
GLC-SYSTEM
GLC-JE-TYPE
GLC-CONTROL-GROUP
GLC-JE-SEQUENCE
|
