The General Ledger Commitx file contains the detail encumbrance and commitment
records created by sub systems.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
GOX-COMPANY
Element: Company | Numeric 4
The company number represents an
established company and is maintained on
GL10.
|
|
GOX-ACCT-UNIT
Element: Accounting Unit | Alpha 15
The accounting unit is a shorthand
notation representing the variable level
number. The accounting unit must be
defined in the General Ledger Names file
as a posting accounting unit.
|
|
GOX-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.
|
|
GOX-SUB-ACCOUNT
Element: Subaccount | Numeric 4
This field along with the accounting
unit and account make up the location
where amounts and other account
information is stored.
|
|
GOX-FISCAL-YEAR
Element: Fiscal Year | Numeric 4
This is the fiscal year for the record.
|
|
GOX-PERIOD
Element: Period | Numeric 2
This is the period for the record.
|
|
GOX-SYSTEM
Element: System | Alpha 2
A two-character code representing the
system in which the commitment is held.
|
|
GOX-GLT-OBJ-ID
GL Transaction
Object ID | Numeric 12
This is the object ID sequence number.
|
|
GOX-VAR-LEVELS
Element: Variable Levels | Alpha 30
A level that represents the location of
an accounting unit in an organization's
level structure.
|
|
GOX-AMOUNT
Element: Amount | Signed 18.2
The base amount for the record.
|
|
GOX-UNIT
Element: Unit | Signed 15.2
The units for the record.
|
|
GOX-CURRENCY-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
GOX-BASERATE
Element: Base Rate | Signed 14.7
The exchange rate at the time the record
was created.
|
|
GOX-TRAN-AMOUNT
Element: Transaction Amount | Signed 18.2
This is the amount in transaction
currency.
|
|
GOX-TRAN-ND
Transaction Number
of Decimals | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
GOX-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice number.
|
|
GOX-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
GOX-RESOURCE-COMP
Element: Resource Company | Numeric 4
Required if resource type is employee;
capture HR company.
|
|
GOX-RESOURCE-CODE
Element: Resource Code | Alpha 10
This field contains the subsystem
resource number.
|
|
GOX-RESOURCE-TYPE
Element: Resource Type | Alpha 1
This field contains the resource type.
|
|
GOX-RESOURCE-DESC
Element: Resource Description | Alpha 30 (Lower Case)
This field contains the resource
description. (Required if resource is
entered).
|
|
GOX-CREATED-YEAR
Element: Created Year | Numeric 4
This is the fiscal year the record was
created in.
|
|
GOX-CREATED-PERIOD
Element: Created Period | Numeric 2
This is the period that the record was
created in.
|
|
GOX-TRANS-DATE
Element: Transaction Date | Numeric 8 (yyyymmdd)
Commitment transaction date.
For payroll commitments created during
salary encumbrance, this is the pay
period end date.
|
|
GOX-SOURCE-CODE
Element: Source Code | Alpha 2
A two character code assigned to a
transaction to identify where the
transaction was created.
|
|
GOX-FBY-OBJ-ID
Element: Obj Id | Numeric 12
|
|
GOX-ACTIVITY
Element: Activity | Alpha 15
|
|
GOX-ACCT-CATEGORY
Element: Acct Category | Alpha 5
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Actrans |
ACTRANS |
| GOX-GLT-OBJ-ID | -> | ATN-GLT-OBJ-ID |
| | | ATN-OBJ-ID |
|
| Apapdhist |
APAPDHIST |
| GOX-GLT-OBJ-ID | -> | AH2-GLT-OBJ-ID |
| | | AH2-API-OBJ-ID |
| | | AH2-DIST-SEQ-NBR |
|
| Apdistrib |
APDISTRIB |
| GOX-GLT-OBJ-ID | -> | APD-GLT-OBJ-ID |
| | | APD-API-OBJ-ID |
| | | APD-DIST-SEQ-NBR |
|
| Apdrftdist |
APDRFTDIST |
| GOX-COMPANY | -> | DDT-DIST-COMPANY |
| GOX-ACCT-UNIT | -> | DDT-DST-ACCT-UNIT |
| GOX-ACCOUNT | -> | DDT-DST-ACCOUNT |
| GOX-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 |
| GOX-COMPANY | -> | CBD-DIST-COMPANY |
| GOX-ACCT-UNIT | -> | CBD-DIS-ACCT-UNIT |
| GOX-ACCOUNT | -> | CBD-DIS-ACCOUNT |
| GOX-SUB-ACCOUNT | -> | CBD-DIS-SUB-ACCT |
| GOX-GLT-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 |
| GOX-GLT-OBJ-ID | -> | EED-GLT-OBJ-ID |
| | | EED-COMPANY |
| | | EED-VENDOR |
| | | EED-EXPENSE-NBR |
| | | EED-SEQ-NBR |
|
| Fbdetail |
FBDETAIL |
| GOX-COMPANY | -> | FBD-COMPANY |
| GOX-ACCT-UNIT | -> | FBD-ACCT-UNIT |
| GOX-ACCOUNT | -> | FBD-ACCOUNT |
| GOX-SUB-ACCOUNT | -> | FBD-SUB-ACCOUNT |
| | | FBD-BUDGET-NBR |
| | | FBD-FISCAL-YEAR |
|
| Gltrans |
GLTRANS |
| GOX-COMPANY | -> | GLT-COMPANY |
| GOX-FISCAL-YEAR | -> | GLT-FISCAL-YEAR |
| GOX-PERIOD | -> | GLT-ACCT-PERIOD |
| | | GLT-CONTROL-GROUP |
| | | GLT-SYSTEM |
| | | GLT-JE-TYPE |
| | | GLT-JE-SEQUENCE |
| | | GLT-LINE-NBR |
|
| Pommdist |
MMDIST |
| Valid When | | GOX-SYSTEM | = | "PO" | |
| GOX-GLT-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 | | GOX-SYSTEM | = | "PO" | |
| GOX-GLT-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 | | GOX-SYSTEM | = | "PO" | |
| GOX-GLT-OBJ-ID | -> | PVH-GLT-OBJ-ID |
| | | PVH-PROCURE-GROUP |
| | | PVH-VEN-AGRMT-REF |
|
| Prdistrib |
PRDISTRIB |
| GOX-COMPANY | -> | PRD-DIST-COMPANY |
| GOX-GLT-OBJ-ID | -> | PRD-GLT-OBJ-ID |
| GOX-ACCT-UNIT | -> | PRD-DST-ACCT-UNIT |
| GOX-ACCOUNT | -> | PRD-DST-ACCOUNT |
| GOX-SUB-ACCOUNT | -> | PRD-DST-SUB-ACCT |
| | | PRD-OBJ-ID |
|
| Rqmmdist |
MMDIST |
| Valid When | | GOX-SYSTEM | = | "RQ" | |
| GOX-GLT-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 |
|
