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 |
|