GLCLSAUDIT

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
Element: Company
Numeric 4
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.
GL199 GL500
GCA-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Contains the fiscal year for the data stored on this record.
GL199 GL500
GCA-ACCT-PERIOD
Element: Accounting Period
Numeric 2
This is the current accounting period. This field is updated by GL199 (Period Closing).
GL199 GL500
GCA-CLOSE-SEQ
Element: Close Sequence
Numeric 2
The General Ledger close sequence.
GL199 GL500
GCA-CLOSE-DATE
Element: Close Date
Numeric 8 (yyyymmdd)
The General Ledger period close date.
GL199 GL500
GCA-CLOSE-TIME
Element: Close Time
Numeric 6 (hhmmss)
The General Ledger period close time.
GL199 GL500
GCA-PER-END-CODE
Element: Period End Code
Alpha 1
The General Ledger period closing option.
L = Limited
F = Final
GL199 GL500


GLCLSAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCASET1 COMPANY
FISCAL-YEAR
ACCT-PERIOD
CLOSE-SEQ
GL110 GL199
GL500


GLCLSAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GCA-COMPANY->GLS-COMPANY


GLCLSAUDIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:13:09 2016

Home
Contact Us



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