GLCOMTRANS

UPDATED BY
GL76.1 GL76.2 GL276

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCT-COMPANY
Element: Company		Numeric 4
GL76.1 GL76.2
GCT-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
GL76.1 GL76.2
GCT-ACCT-PERIOD
Element: Acct Period		Numeric 2
GL76.1 GL76.2
GCT-CONTROL-GROUP
Element: Control Group		Numeric 8
GL76.1 GL76.2
GCT-LINE-NBR
Element: Line Nbr		Numeric 6
GL76.1
GCT-ACCT-UNIT
Element: Acct Unit		Alpha 15
GL76.1
GCT-ACCOUNT
Element: Account		Numeric 6
GL76.1
GCT-SUB-ACCOUNT
Element: Sub Account		Numeric 4
GL76.1
GCT-ENTRY-DATE
Element: Date		Numeric 8 (yyyymmdd)
GL76.1
GCT-ENTRY-CODE
Element: Auth Code		Alpha 3
GCT-OPERATOR
Element: Operator		Alpha 10
GCT-GOX-OBJ-ID
Element: Obj Id		Numeric 12
GL76.1 GL76.2
GCT-TRANS-AMOUNT
Element: Intl Amt		Signed 18.2
GL76.1
GCT-UNIT
Element: Unit		Signed 15.2
GL76.1


GLCOMTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCTSET1 COMPANY
FISCAL-YEAR
ACCT-PERIOD
CONTROL-GROUP
LINE-NBR
GL276 GL76.1
GL76.2
GCTSET2 GOX-OBJ-ID
Subset
WhereGOX-OBJ-ID !=Zeroes
GL76.1
GCTSET3 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-PERIOD
CONTROL-GROUP
LINE-NBR


GLCOMTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GCT-COMPANY->GLS-COMPANY (GLSSET1)
Glcomcntrl GLCOMCNTRL Required
GCT-COMPANY->GCL-COMPANY
GCT-FISCAL-YEAR->GCL-FISCAL-YEAR
GCT-ACCT-PERIOD->GCL-ACCT-PERIOD
GCT-CONTROL-GROUP->GCL-CONTROL-GROUP

File created: Wed Jun 08 20:48:39 2016

Home
Contact Us



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