| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
GHX-UNIQUE-I-D
Element: Unique I D | Bad Type 36
|
|
GHX-COMPANY
Element: Company | Numeric 4
The company number represents an
established company and is maintained on
GL10.
|
|
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
A level that represents the location of
an accounting unit in an organization's
level structure.
|
|
GHX-AMOUNT
Element: Intl Amt | Signed 18.2
The amount is in the company currency
|
|
GHX-UNIT
Element: Unit | Signed 15.2
The units for the record.
|
|
GHX-CURRENCY-CODE
Element: Currency Code | Alpha 5
Currency code for the commitment
|
|
GHX-BASERATE
Element: Baserate | Signed 14.7
The exchange rate at the time the record
was created.
|
|
GHX-TRAN-AMOUNT
Element: Intl Amt | Signed 18.2
This is the amount in transaction
currency.
|
|
GHX-TRAN-ND
Element: Acct Nd | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
GHX-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice number.
|
|
GHX-ITEM
Element: Item | Alpha 32
This field contains the item identifier.
|
|
GHX-RESOURCE-COMP
Element: Resource Comp | Numeric 4
This field contains the resource
company.
|
|
GHX-RESOURCE-CODE
Element: Resource Code | Alpha 10
This field contains the subsystem
resource number.
|
|
GHX-RESOURCE-TYPE
Element: Resource Type | Alpha 1
This field contains the resource type.
|
|
GHX-RESOURCE-DESC
Element: Description | Alpha 30 (Lower Case)
This field contains the resource
description.
|
|
GHX-ACTION
Element: Action | Alpha 1
A = Add
D = Delete or reverse |
|
GHX-TRANS-DATE
Element: Trans Date | Numeric 8 (yyyymmdd)
Commitment transaction date.
|
|
GHX-SOURCE-CODE
Element: Source Code | Alpha 2
A two character code assigned to a
transaction to identify where the
transaction was created.
|
|
GHX-PROGRAM
Element: Program | Alpha 5
|
|
GHX-SYS-OBJ-TYPE
Element: Record Type | Alpha 1
This is the system object type.
Blank = GLCOMMITX
Y = GLTRANS
|
|
GHX-SYS-OBJ-ID
Element: Obj Id | Numeric 12
This is the system object ID sequence
number.
|
|
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
Object identified number for the GL
history commitment document ID records.
|
|
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 |
|
