GLCOMTRANS

UPDATED BY
GL276 GL76.1 GL76.2

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 GL76.2
GCT-UNIT
Element: Unit
Signed 15.2
GL76.1
GCT-ACTIVITY
Element: Activity
Alpha 15
GL76.1
GCT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
GL76.1
GCT-MIX-OBJ-ID
Element: Obj Id
Numeric 12
GL76.1 GL76.2


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
KeyChange, Subset
WhereGOX-OBJ-ID !=Zeroes
GL76.1
GCTSET3 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-PERIOD
CONTROL-GROUP
LINE-NBR
KeyChange
GCTSET4 MIX-OBJ-ID
KeyChange, Subset
WhereMIX-OBJ-ID !=Zeroes


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: Thu Jun 09 11:13:13 2016

Home
Contact Us



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