FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
GHX-UNIQUE-I-D Element: Unique I D | Bad Type 36
|
|
GHX-COMPANY Element: Company | Numeric 4
|
|
GHX-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthad
notation representing the variable level
number. The accounting unit must be
defined in the General Ledger Names file
as a posting accounting unit.
|
|
GHX-ACCOUNT Element: Account | Numeric 6 This field along with the accounting
unit and subaccount make up the location
where amounts and other account
information is stored.
|
|
GHX-SUB-ACCOUNT Element: Sub Account | Numeric 4 This field along with the accounting
unit and account make up the location
where amounts and other account
information is stored.
|
|
GHX-YEAR Element: Year | Numeric 4 This is the year for the record.
|
|
GHX-PERIOD Element: Period | Numeric 2 this is the period for the record.
|
|
GHX-SYSTEM Element: System | Alpha 2 A two-character code representing the
system in which the commitment is held.
|
|
GHX-VAR-LEVELS Element: Var Levels | Alpha 30
|
|
GHX-AMOUNT Element: Intl Amt | Signed 18.2 The amount is in the company currency
|
|
GHX-UNIT Element: Unit | Signed 15.2
|
|
GHX-CURRENCY-CODE Element: Currency Code | Alpha 5
|
|
GHX-BASERATE Element: Baserate | Signed 14.7
|
|
GHX-TRAN-AMOUNT Element: Intl Amt | Signed 18.2
|
|
GHX-TRAN-ND Element: Acct Nd | Numeric 1
|
|
GHX-INVOICE Element: Invoice | Alpha 22
|
|
GHX-ITEM Element: Item | Alpha 32
|
|
GHX-RESOURCE-COMP Element: Resource Comp | Numeric 4
|
|
GHX-RESOURCE-CODE Element: Resource Code | Alpha 10
|
|
GHX-RESOURCE-TYPE Element: Resource Type | Alpha 1
|
|
GHX-RESOURCE-DESC Element: Description | Alpha 30 (Lower Case)
|
|
GHX-ACTION Element: Action | Alpha 1
A = Add D = Delete or reverse |
|
GHX-TRANS-DATE Element: Trans Date | Numeric 8 (yyyymmdd)
|
|
GHX-SOURCE-CODE Element: Source Code | Alpha 2
|
|
GHX-PROGRAM Element: Program | Alpha 5
|
|
GHX-SYS-OBJ-TYPE Element: Record Type | Alpha 1
|
|
GHX-SYS-OBJ-ID Element: Obj Id | Numeric 12
|
|
GHX-DOC-ID Element: Document Id | Alpha 55 This is the document ID.
|
|
GHX-DOC-ID-DTL Element: Doc Id Dtl | Alpha 15
|
|
GHX-PARENT-DOC-ID Element: Document Id | Alpha 55
|
|
GHX-PAR-DOC-ID-DTL Element: Doc Id Dtl | Alpha 15
|
|
GHX-API-OBJ-ID Element: Obj Id | Numeric 12
|
|
GHX-DIST-SEQ-NBR Element: Dist Seq Nbr | Numeric 6
|
|
GHX-FROM-COMPANY Element: Company | Numeric 4
|
|
GHX-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified)
|
|
GHX-PO-RELEASE Element: Po Release | Numeric 4
|
|
GHX-PO-CODE Element: Po Code | Alpha 4
|
|
GHX-LINE-NBR Element: Line Nbr | Numeric 6
|
|
GHX-REQ-NUMBER Element: Req Number | Numeric 7
|
|
GHX-FBY-OBJ-ID Element: Obj Id | Numeric 12
|
|
GHX-CREATED-YEAR Element: Created Year | Numeric 4
|
|
GHX-CREATED-PERIOD Element: Created Period | Numeric 2
|
|
GHX-ACTIVITY Element: Activity | Alpha 15
|
|
GHX-ACCT-CATEGORY Element: Acct Category | Alpha 5
|
|
GHX-MAINT-DATE Element: Date | Numeric 8 (yyyymmdd)
|
|
GHX-MAINT-TIME Element: Time | Numeric 8
|
|
RELATION NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
Account |
GLMASTER |
Required
GHX-COMPANY | -> | GLM-COMPANY |
GHX-ACCT-UNIT | -> | GLM-ACCT-UNIT |
GHX-ACCOUNT | -> | GLM-ACCOUNT |
GHX-SUB-ACCOUNT | -> | GLM-SUB-ACCOUNT |
|
Apdistrib |
APDISTRIB |
Required
GHX-API-OBJ-ID | -> | APD-API-OBJ-ID |
GHX-DIST-SEQ-NBR | -> | APD-DIST-SEQ-NBR |
|
Glamounts |
GLAMOUNTS |
Required
GHX-COMPANY | -> | GAM-COMPANY |
GHX-YEAR | -> | GAM-FISCAL-YEAR |
GHX-ACCT-UNIT | -> | GAM-ACCT-UNIT |
GHX-ACCOUNT | -> | GAM-ACCOUNT |
GHX-SUB-ACCOUNT | -> | GAM-SUB-ACCOUNT |
|
Glcommitx |
GLCOMMITX |
Required
GHX-SYS-OBJ-ID | -> | GOX-GLT-OBJ-ID |
|
Gltrans |
GLTRANS |
Required
GHX-SYS-OBJ-ID | -> | GLT-OBJ-ID |
|
Paencumber |
PAENCUMBER |
Required
GHX-SYS-OBJ-ID | -> | PEN-GLT-OBJ-ID |
|
Poline |
POLINE |
Required
GHX-FROM-COMPANY | -> | PLI-COMPANY |
GHX-PO-NUMBER | -> | PLI-PO-NUMBER |
GHX-PO-RELEASE | -> | PLI-PO-RELEASE |
GHX-PO-CODE | -> | PLI-PO-CODE |
GHX-LINE-NBR | -> | PLI-LINE-NBR |
|
Povadist |
POVADIST |
Not Required
GHX-SYS-OBJ-ID | -> | PVD-GLT-OBJ-ID |
|
Reqline |
REQLINE |
Required
GHX-FROM-COMPANY | -> | RLN-COMPANY |
GHX-REQ-NUMBER | -> | RLN-REQ-NUMBER |
GHX-LINE-NBR | -> | RLN-LINE-NBR |
|
Rjencumb |
RJENCUMB |
Required
GHX-SYS-OBJ-ID | -> | RJE-GLT-OBJ-ID |
|
RELATION NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
Actrans |
ACTRANS |
GHX-SYS-OBJ-ID | -> | ATN-GLT-OBJ-ID |
| | ATN-OBJ-ID |
|
Apapdhist |
APAPDHIST |
GHX-SYS-OBJ-ID | -> | AH2-GLT-OBJ-ID |
| | AH2-API-OBJ-ID |
| | AH2-DIST-SEQ-NBR |
|
Apdrftdist |
APDRFTDIST |
GHX-COMPANY | -> | DDT-DIST-COMPANY |
GHX-ACCT-UNIT | -> | DDT-DST-ACCT-UNIT |
GHX-ACCOUNT | -> | DDT-DST-ACCOUNT |
GHX-SUB-ACCOUNT | -> | DDT-DST-SUB-ACCT |
| | DDT-POST-DATE |
| | DDT-GLT-OBJ-ID |
| | DDT-BANK-INST-CODE |
| | DDT-TRANS-IDENT |
| | DDT-SEQ-NBR |
|
Cbdistrib |
CBDISTRIB |
GHX-COMPANY | -> | CBD-DIST-COMPANY |
GHX-ACCT-UNIT | -> | CBD-DIS-ACCT-UNIT |
GHX-ACCOUNT | -> | CBD-DIS-ACCOUNT |
GHX-SUB-ACCOUNT | -> | CBD-DIS-SUB-ACCT |
GHX-SYS-OBJ-ID | -> | CBD-GLT-OBJ-ID |
| | CBD-CASH-CODE |
| | CBD-TRANS-NBR |
| | CBD-BANK-INST-CODE |
| | CBD-DIST-TYPE |
| | CBD-SEQ-NBR |
| | CBD-TRANS-IDENT |
|
Eedistrib |
EEDISTRIB |
GHX-SYS-OBJ-ID | -> | EED-GLT-OBJ-ID |
| | EED-COMPANY |
| | EED-VENDOR |
| | EED-EXPENSE-NBR |
| | EED-SEQ-NBR |
|
Fbdetail |
FBDETAIL |
GHX-COMPANY | -> | FBD-COMPANY |
GHX-ACCT-UNIT | -> | FBD-ACCT-UNIT |
GHX-ACCOUNT | -> | FBD-ACCOUNT |
GHX-SUB-ACCOUNT | -> | FBD-SUB-ACCOUNT |
| | FBD-BUDGET-NBR |
| | FBD-FISCAL-YEAR |
|
Pommdist |
MMDIST |
Valid When | | GHX-SYSTEM | = | "PO" | |
GHX-SYS-OBJ-ID | -> | MMD-GLT-OBJ-ID |
| | MMD-COMPANY |
| | MMD-SYSTEM-CD |
| | MMD-LOCATION |
| | MMD-DOC-TYPE |
| | MMD-DOC-NUMBER |
| | MMD-DOC-NBR-NUM |
| | MMD-LINE-NBR |
| | MMD-COMPONENT-SEQ |
| | MMD-LINE-SEQ |
|
Povacommit |
POVACOMMIT |
Valid When | | GHX-SYSTEM | = | "PO" | |
GHX-SYS-OBJ-ID | -> | PVC-GLT-OBJ-ID |
| | PVC-PROCURE-GROUP |
| | PVC-VEN-AGRMT-REF |
| | PVC-LINE-NBR |
| | PVC-SYSTEM |
| | PVC-LINE-SEQ |
| | PVC-COMMIT-DATE |
|
Povagrmthd |
POVAGRMTHD |
Valid When | | GHX-SYSTEM | = | "PO" | |
GHX-SYS-OBJ-ID | -> | PVH-GLT-OBJ-ID |
| | PVH-PROCURE-GROUP |
| | PVH-VEN-AGRMT-REF |
|
Prdistrib |
PRDISTRIB |
GHX-COMPANY | -> | PRD-DIST-COMPANY |
GHX-SYS-OBJ-ID | -> | PRD-GLT-OBJ-ID |
GHX-ACCT-UNIT | -> | PRD-DST-ACCT-UNIT |
GHX-ACCOUNT | -> | PRD-DST-ACCOUNT |
GHX-SUB-ACCOUNT | -> | PRD-DST-SUB-ACCT |
| | PRD-OBJ-ID |
|
Rqmmdist |
MMDIST |
Valid When | | GHX-SYSTEM | = | "RQ" | |
GHX-SYS-OBJ-ID | -> | MMD-GLT-OBJ-ID |
| | MMD-COMPANY |
| | MMD-SYSTEM-CD |
| | MMD-LOCATION |
| | MMD-DOC-TYPE |
| | MMD-DOC-NUMBER |
| | MMD-DOC-NBR-NUM |
| | MMD-LINE-NBR |
| | MMD-COMPONENT-SEQ |
| | MMD-LINE-SEQ |
|