| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Automatic Withholding Tax Flag | Flag to indicate if automatic withholding tax has been calculated or not. | Invoices.Automatic Withholding Tax Flag | AWT_FLAG | AWT_FLAG | 118770 |
| Batch Id | Invoice batch unique identifier. | Invoices.Batch Id | BATCH_ID | BATCH_ID | 119369 |
| CAI_DUE_DATE | | Invoices.CAI_DUE_DATE | GLBL_CAI_DUE_DATE_13 | GLBL_CAI_DUE_DATE_13 | 266360 |
| CAI_NUMBER | | Invoices.CAI_NUMBER | GLBL_CAI_NUMBER_13 | GLBL_CAI_NUMBER_13 | 266359 |
| Check VAT Amount Paid | | Invoices.Check VAT Amount Paid | GLBL_CHECK_VAT_AMOUNT_PAID_3 | GLBL_CHECK_VAT_AMOUNT_PAID_3 | 266322 |
| Check VAT Amount Paid 1 | | Invoices.Check VAT Amount Paid 1 | GLBL_CHECK_VAT_AMOUNT_PAID_22 | GLBL_CHECK_VAT_AMOUNT_PAID_22 | 266377 |
| Class | | Invoices.Class | GLBL_CLASS_12 | GLBL_CLASS_12 | 266345 |
| Collection Document Association | | Invoices.Collection Document Association | GLBL_COLLECTION_DOCUMENT_AS_12 | GLBL_COLLECTION_DOCUMENT_AS_12 | 266342 |
| Consolidated Invoice Number | | Invoices.Consolidated Invoice Number | GLBL_CONSOLIDATED_INVOICE_12 | GLBL_CONSOLIDATED_INVOICE_12 | 266350 |
| Context | | Invoices.Context | CONTEXT | CONTEXT | 266313 |
| Context Value | | Invoices.Context Value | GLBL_CONTEXT_VALUE | GLBL_CONTEXT_VALUE | 266317 |
| Correction Period | | Invoices.Correction Period | GLBL_CORRECTION_PERIOD_6 | GLBL_CORRECTION_PERIOD_6 | 266327 |
| Correction Year | | Invoices.Correction Year | GLBL_CORRECTION_YEAR_6 | GLBL_CORRECTION_YEAR_6 | 266326 |
| Country Code | | Invoices.Country Code | GLBL_JEDK_EDI_COUNTRY_CODE_9 | GLBL_JEDK_EDI_COUNTRY_CODE_9 | 266335 |
| Created By | Standard WHO column. | Invoices.Created By | CREATED_BY | CREATED_BY | 124515 |
| Creation Date | Standard WHO column. | Invoices.Creation Date | CREATION_DATE | CREATION_DATE | 125947 |
| Customs Codes | | Invoices.Customs Codes | GLBL_CUSTOMS_CODE_13 | GLBL_CUSTOMS_CODE_13 | 266354 |
| Customs Issue Date | | Invoices.Customs Issue Date | GLBL_CUSTOMS_ISSUE_DATE_13 | GLBL_CUSTOMS_ISSUE_DATE_13 | 266355 |
| Customs Issue Numbers | | Invoices.Customs Issue Numbers | GLBL_CUSTOMS_ISSUE_NUMBER_13 | GLBL_CUSTOMS_ISSUE_NUMBER_13 | 266356 |
| DESTINATION_CODE | | Invoices.DESTINATION_CODE | GLBL_DESTINATION_CODE_13 | GLBL_DESTINATION_CODE_13 | 266361 |
| Deductible Type | | Invoices.Deductible Type | GLBL_DEDUCTIBLE_TYPE_17 | GLBL_DEDUCTIBLE_TYPE_17 | 266370 |
| Deduction Tax Rule | | Invoices.Deduction Tax Rule | GLBL_DEDUCTION_TAX_RULE_14 | GLBL_DEDUCTION_TAX_RULE_14 | 266362 |
| Document Types | | Invoices.Document Types | GLBL_DOCUMENT_TYPE_11 | GLBL_DOCUMENT_TYPE_11 | 266341 |
| Dummy | | Invoices.Dummy | GLBL_JEDK_EDI_DUMMY_9 | GLBL_JEDK_EDI_DUMMY_9 | 266334 |
| GUI Type | | Invoices.GUI Type | GLBL_GUI_TYPE_17 | GLBL_GUI_TYPE_17 | 266368 |
| ICMS Amount | | Invoices.ICMS Amount | GLBL_ICMS_AMOUNT_12 | GLBL_ICMS_AMOUNT_12 | 266348 |
| ICMS Base Amount | | Invoices.ICMS Base Amount | GLBL_ICMS_BASE_AMOUNT_12 | GLBL_ICMS_BASE_AMOUNT_12 | 266346 |
| ICMS Name | | Invoices.ICMS Name | GLBL_ICMS_NAME_12 | GLBL_ICMS_NAME_12 | 266347 |
| IMPORT_DOC_DATE | | Invoices.IMPORT_DOC_DATE | GLBL_IMPORT_DOC_DATE_2 | GLBL_IMPORT_DOC_DATE_2 | 266320 |
| IMPORT_DOC_NUM | | Invoices.IMPORT_DOC_NUM | GLBL_IMPORT_DOC_NUM_2 | GLBL_IMPORT_DOC_NUM_2 | 266319 |
| IPI Amount | | Invoices.IPI Amount | GLBL_IPI_AMOUNT_12 | GLBL_IPI_AMOUNT_12 | 266349 |
| Import Code | | Invoices.Import Code | GLBL_JEDK_EDI_IMPORT_CODE_9 | GLBL_JEDK_EDI_IMPORT_CODE_9 | 266338 |
| Import Code Specification | | Invoices.Import Code Specification | GLBL_JEDK_EDI_IMPORT_TEXT_9 | GLBL_JEDK_EDI_IMPORT_TEXT_9 | 266339 |
| Insurance Premium Type | | Invoices.Insurance Premium Type | GLBL_INSURANCE_PREMIUM_TYPE_23 | GLBL_INSURANCE_PREMIUM_TYPE_23 | 266378 |
| Invoice Approved Amount | Invoice amount approved through manual authorization of payment (used for reference purposes only). | Invoices.Invoice Approved Amount | INVOICE_APPROVED_AMOUNT | INVOICE_APPROVED_AMOUNT | 137378 |
| Invoice Canceled Amount | Original amount of canceled invoice. | Invoices.Invoice Canceled Amount | INVOICE_CANCELED_AMOUNT | INVOICE_CANCELED_AMOUNT | 137383 |
| Invoice Canceled Date | Invoice canceled date. | Invoices.Invoice Canceled Date | INVOICE_CANCELED_DATE | INVOICE_CANCELED_DATE | 137384 |
| Invoice Canceled Date Day | | Invoices.Invoice Canceled Date | | INVOICE_CANCELED_DATE_DAY | 181626 |
| Invoice Canceled Date Month | | Invoices.Invoice Canceled Date | | INVOICE_CANCELED_DATE_MONTH | 181628 |
| Invoice Canceled Date Quarter | | Invoices.Invoice Canceled Date | | INVOICE_CANCELED_DATE_QUARTER | 181630 |
| Invoice Canceled Date Year | | Invoices.Invoice Canceled Date | | INVOICE_CANCELED_DATE_YEAR | 181632 |
| Invoice Currency Code | Currency code of the invoice. | Invoices.Invoice Currency Code | INVOICE_CURRENCY_CODE | INVOICE_CURRENCY_CODE | 137404 |
| Invoice Date | Date of invoice. | Invoices.Invoice Date | INVOICE_DATE | INVOICE_DATE | 137415 |
| Invoice Date Day | | Invoices.Invoice Date | | INVOICE_DATE_DAY | 181638 |
| Invoice Date Month | | Invoices.Invoice Date | | INVOICE_DATE_MONTH | 181648 |
| Invoice Date Quarter | | Invoices.Invoice Date | | INVOICE_DATE_QUARTER | 181658 |
| Invoice Date Year | | Invoices.Invoice Date | | INVOICE_DATE_YEAR | 181676 |
| Invoice Description | Description of invoice. | Invoices.Invoice Description | INVOICE_DESCRIPTION | INVOICE_DESCRIPTION | 137423 |
| Invoice Discountable Amount | Amount of invoice applicable to a discount. | Invoices.Invoice Discountable Amount | INVOICE_DISCOUNTABLE_AMOUNT | INVOICE_DISCOUNTABLE_AMOUNT | 137424 |
| Invoice Entered Amount | Invoice amount in the invoice (entered) currency. | Invoices.Invoice Entered Amount | INVOICE_ENTERED_AMOUNT | INVOICE_ENTERED_AMOUNT | 137429 |
| Invoice Freight Amount | Freight amount used to calculate invoice amount available for discount. | Invoices.Invoice Freight Amount | INVOICE_FREIGHT_AMOUNT | INVOICE_FREIGHT_AMOUNT | 137431 |
| Invoice Functional Amount | Invoice amount in functional currency. Only used for foreign currency invoices. | Invoices.Invoice Functional Amount | INVOICE_FUNCTIONAL_AMOUNT | INVOICE_FUNCTIONAL_AMOUNT | 137433 |
| Invoice Id | Invoice unique identifier. | Invoices.Invoice Id | INVOICE_ID | INVOICE_ID | 137436 |
| Invoice Number | Invoice number. | Invoices.Invoice Number | INVOICE_NUMBER | INVOICE_NUMBER | 137460 |
| Invoice Posting Status | Status that indicates if invoice has been transferred to general ledger. | Invoices.Invoice Posting Status | INVOICE_POSTING_STATUS | INVOICE_POSTING_STATUS | 137477 |
| Invoice Received Date | Date invoice is received. | Invoices.Invoice Received Date | INVOICE_RECEIVED_DATE | INVOICE_RECEIVED_DATE | 137480 |
| Invoice Received Date Day | | Invoices.Invoice Received Date | | INVOICE_RECEIVED_DATE_DAY | 181686 |
| Invoice Received Date Month | | Invoices.Invoice Received Date | | INVOICE_RECEIVED_DATE_MONTH | 181688 |
| Invoice Received Date Quarter | | Invoices.Invoice Received Date | | INVOICE_RECEIVED_DATE_QUARTER | 181690 |
| Invoice Received Date Year | | Invoices.Invoice Received Date | | INVOICE_RECEIVED_DATE_YEAR | 181692 |
| Invoice Sequence Number | Voucher number which is either validated (sequential numbering enabled) or non-validated (sequential numbering not enabled). | Invoices.Invoice Sequence Number | INVOICE_SEQUENCE_NUMBER | INVOICE_SEQUENCE_NUMBER | 137482 |
| Invoice Source | Source of imported invoice. | Invoices.Invoice Source | INVOICE_SOURCE | INVOICE_SOURCE | 137483 |
| Invoice To Functional Exchange Date | Date exchange rate is effective; usually the accounting date of a transaction. | Invoices.Invoice To Functional Exchange Date | INV_TO_FUNCTIONAL_EXCH_DATE | INV_TO_FUNCTIONAL_EXCH_DATE | 137555 |
| Invoice To Functional Exchange Rate | Exchange rate for foreign currency invoice. | Invoices.Invoice To Functional Exchange Rate | INV_TO_FUNCTIONAL_EXCH_RATE | INV_TO_FUNCTIONAL_EXCH_RATE | 137556 |
| Invoice To Functional Exchange Type | Exchange rate type for foreign currency invoice. | Invoices.Invoice To Functional Exchange Type | INV_TO_FUNCTIONAL_EXCH_TYPE | INV_TO_FUNCTIONAL_EXCH_TYPE | 137557 |
| Invoice To Payment Rate | Exchange rate between invoice and payment. | Invoices.Invoice To Payment Rate | INV_TO_PMT_RATE | INV_TO_PMT_RATE | 137558 |
| Invoice To Payment Rate Date | Cross currency payment rate date. | Invoices.Invoice To Payment Rate Date | INV_TO_PMT_RATE_DATE | INV_TO_PMT_RATE_DATE | 137559 |
| Invoice To Payment Rate Date Day | | Invoices.Invoice To Payment Rate Date | | INV_TO_PMT_RATE_DATE_DAY | 181694 |
| Invoice To Payment Rate Date Month | | Invoices.Invoice To Payment Rate Date | | INV_TO_PMT_RATE_DATE_MONTH | 181696 |
| Invoice To Payment Rate Date Quarter | | Invoices.Invoice To Payment Rate Date | | INV_TO_PMT_RATE_DATE_QUARTER | 181698 |
| Invoice To Payment Rate Date Year | | Invoices.Invoice To Payment Rate Date | | INV_TO_PMT_RATE_DATE_YEAR | 181700 |
| Invoice To Payment Rate Type | Cross currency payment rate type. | Invoices.Invoice To Payment Rate Type | INV_TO_PMT_RATE_TYPE | INV_TO_PMT_RATE_TYPE | 137560 |
| Invoice Type | | Invoices.Invoice Type | GLBL_INVOICE_TYPE_5 | GLBL_INVOICE_TYPE_5 | 266324 |
| Invoice Type 1 | | Invoices.Invoice Type 1 | GLBL_INVOICE_TYPE_6 | GLBL_INVOICE_TYPE_6 | 266325 |
| Invoice Type 2 | | Invoices.Invoice Type 2 | GLBL_INVOICE_TYPE_7 | GLBL_INVOICE_TYPE_7 | 266328 |
| Invoice Type 3 | | Invoices.Invoice Type 3 | GLBL_INVOICE_TYPE_8 | GLBL_INVOICE_TYPE_8 | 266329 |
| Invoice Type 4 | | Invoices.Invoice Type 4 | GLBL_INVOICE_TYPE_19 | GLBL_INVOICE_TYPE_19 | 266373 |
| Invoice Type 5 | | Invoices.Invoice Type 5 | GLBL_INVOICE_TYPE_20 | GLBL_INVOICE_TYPE_20 | 266374 |
| Invoice Type 6 | | Invoices.Invoice Type 6 | GLBL_INVOICE_TYPE_21 | GLBL_INVOICE_TYPE_21 | 266375 |
| Invoice Type Code | | Invoices.Invoice Type Code | INVOICE_TYPE_CODE | INVOICE_TYPE_CODE | 137519 |
| Invoice Type Description | | Invoices.Invoice Type Description | INVOICE_TYPE_DESCRIPTION | INVOICE_TYPE_DESCRIPTION | 266311 |
| Last Update Date | Standard WHO column. | Invoices.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140478 |
| Last Updated By | Standard WHO column. | Invoices.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139139 |
| Legal Transaction Categories | | Invoices.Legal Transaction Categories | GLBL_LEGAL_TRANSACTION_CATE_13 | GLBL_LEGAL_TRANSACTION_CATE_13 | 266351 |
| MES Permit Number | | Invoices.MES Permit Number | MES_PERMIT_NUMBER | MES_PERMIT_NUMBER | 266314 |
| Manually Approved Description | Description of manual authorization invoice approval (used for reference purposes only). | Invoices.Manually Approved Description | MANUALLY_APPROVED_DESCRIPTION | MANUALLY_APPROVED_DESCRIPTION | 146129 |
| Manually Approved Status | Status of manual authorization invoice approval (used for reference purposes only). | Invoices.Manually Approved Status | MANUALLY_APPROVED_STATUS | MANUALLY_APPROVED_STATUS | 146130 |
| Operation Fiscal Code | | Invoices.Operation Fiscal Code | GLBL_CFO_12 | GLBL_CFO_12 | 266343 |
| PA Expenditure Item Date | | Invoices.PA Expenditure Item Date | PA_EXPENDITURE_ITEM_DATE | PA_EXPENDITURE_ITEM_DATE | 152579 |
| PA Expenditure Type | | Invoices.PA Expenditure Type | PA_EXPENDITURE_TYPE | PA_EXPENDITURE_TYPE | 152583 |
| PA Quantity | | Invoices.PA Quantity | PA_QUANTITY | PA_QUANTITY | 152593 |
| PA Reference 1 | | Invoices.PA Reference 1 | PA_REFERENCE_1 | PA_REFERENCE_1 | 152597 |
| PA Reference 2 | | Invoices.PA Reference 2 | PA_REFERENCE_2 | PA_REFERENCE_2 | 152598 |
| Party ID | | Invoices.Party ID | GLBL_JEDK_EDI_PARTY_ID_9 | GLBL_JEDK_EDI_PARTY_ID_9 | 266336 |
| Pay Alone Flag | Flag indicating whether or not to pay invoice on separate payment document. | Invoices.Pay Alone Flag | PAY_ALONE_FLAG | PAY_ALONE_FLAG | 152453 |
| Pay Group | Name of pay group. | Invoices.Pay Group | PAY_GROUP | PAY_GROUP | 152512 |
| Payment Category | | Invoices.Payment Category | GLBL_JEDK_EDI_PAYMENT_CATEGO_9 | GLBL_JEDK_EDI_PAYMENT_CATEGO_9 | 266330 |
| Payment Channel | | Invoices.Payment Channel | GLBL_JEDK_EDI_PAYMENT_CHANNE_9 | GLBL_JEDK_EDI_PAYMENT_CHANNE_9 | 266333 |
| Payment Currency Code | Currency code of the payment. | Invoices.Payment Currency Code | PAYMENT_CURRENCY_CODE | PAYMENT_CURRENCY_CODE | 152194 |
| Payment Currency Invoice Amount | Invoice amount in the payment currency. | Invoices.Payment Currency Invoice Amount | PAYMENT_CURRENCY_INVOICE_AMT | PAYMENT_CURRENCY_INVOICE_AMT | 152197 |
| Payment Means | | Invoices.Payment Means | GLBL_JEDK_EDI_PAYMENT_MEANS_9 | GLBL_JEDK_EDI_PAYMENT_MEANS_9 | 266332 |
| Payment Method | Name of payment method. | Invoices.Payment Method | PAYMENT_METHOD | PAYMENT_METHOD | 152217 |
| Payment Status | Flag that indicates if invoice has been paid. | Invoices.Payment Status | PAYMENT_STATUS | PAYMENT_STATUS | 152254 |
| Payment Terms Date | Date used with payment terms to calculate payment schedule of invoice. | Invoices.Payment Terms Date | PAYMENT_TERMS_DATE | PAYMENT_TERMS_DATE | 152261 |
| Payment Terms Date Day | | Invoices.Payment Terms Date | | PAYMENT_TERMS_DATE_DAY | 187617 |
| Payment Terms Date Month | | Invoices.Payment Terms Date | | PAYMENT_TERMS_DATE_MONTH | 187619 |
| Payment Terms Date Quarter | | Invoices.Payment Terms Date | | PAYMENT_TERMS_DATE_QUARTER | 187621 |
| Payment Terms Date Year | | Invoices.Payment Terms Date | | PAYMENT_TERMS_DATE_YEAR | 187623 |
| Payment categoryID | | Invoices.Payment categoryID | GLBL_JEDK_EDI_SEQUENCE_NUMBE_9 | GLBL_JEDK_EDI_SEQUENCE_NUMBE_9 | 266331 |
| Pmt Status Description | | Invoices.Pmt Status Description | PMT_STATUS_DESCRIPTION | PMT_STATUS_DESCRIPTION | 266312 |
| Po Header Id | | Invoices.Po Header Id | PO_HEADER_ID | PO_HEADER_ID | 155028 |
| Print Date | | Invoices.Print Date | GLBL_PRINT_DATE_17 | GLBL_PRINT_DATE_17 | 266371 |
| Project Id | | Invoices.Project Id | PROJECT_ID | PROJECT_ID | 156421 |
| Project Task Id | | Invoices.Project Task Id | PROJECT_TASK_ID | PROJECT_TASK_ID | 156708 |
| SHIP_TO_LOCATION | | Invoices.SHIP_TO_LOCATION | GLBL_SHIP_TO_LOCATION_13 | GLBL_SHIP_TO_LOCATION_13 | 266358 |
| SHIP_TO_LOCATION 1 | | Invoices.SHIP_TO_LOCATION 1 | GLBL_SHIP_TO_LOCATION_18 | GLBL_SHIP_TO_LOCATION_18 | 266372 |
| Series | | Invoices.Series | GLBL_SERIES_12 | GLBL_SERIES_12 | 266344 |
| Settlement Code | | Invoices.Settlement Code | GLBL_JEDK_EDI_SETTLEMENT_COD_9 | GLBL_JEDK_EDI_SETTLEMENT_COD_9 | 266340 |
| Source Descripton | | Invoices.Source Descripton | SOURCE_DESCRIPTON | SOURCE_DESCRIPTON | 266310 |
| Supplier Exchange Rate | | Invoices.Supplier Exchange Rate | GLBL_SUPPLIER_EXCHANGE_RATE_15 | GLBL_SUPPLIER_EXCHANGE_RATE_15 | 266363 |
| Supplier Message | | Invoices.Supplier Message | GLBL_JEDK_EDI_SUPPLIER_MESSA_9 | GLBL_JEDK_EDI_SUPPLIER_MESSA_9 | 266337 |
| Supplier Tax Invoice Number | | Invoices.Supplier Tax Invoice Number | GLBL_SUPPLIER_TAX_INVOICE_N_16 | GLBL_SUPPLIER_TAX_INVOICE_N_16 | 266366 |
| TAX_DATE | | Invoices.TAX_DATE | GLBL_TAX_DATE_2 | GLBL_TAX_DATE_2 | 266318 |
| TAX_DATE 1 | | Invoices.TAX_DATE 1 | GLBL_TAX_DATE_3 | GLBL_TAX_DATE_3 | 266321 |
| Tax Accounting Period | | Invoices.Tax Accounting Period | GLBL_TAX_ACCOUNTING_PERIOD_16 | GLBL_TAX_ACCOUNTING_PERIOD_16 | 266367 |
| Tax Amount | Amount of tax for the invoice. | Invoices.Tax Amount | TAX_AMOUNT | TAX_AMOUNT | 164693 |
| Tax Calculation Level | Flag that indicates if tax amount is automatically calculated, and if so, at what level the calculation is performed. | Invoices.Tax Calculation Level | TAX_CALCULATION_LEVEL | TAX_CALCULATION_LEVEL | 164705 |
| Tax Date | | Invoices.Tax Date | GLBL_TAX_DATE_4 | GLBL_TAX_DATE_4 | 266323 |
| Tax Date 1 | | Invoices.Tax Date 1 | GLBL_TAX_DATE_22 | GLBL_TAX_DATE_22 | 266376 |
| Tax Inclusive | | Invoices.Tax Inclusive | GLBL_TAX_INCLUSIVE_WITH_NOT_13 | GLBL_TAX_INCLUSIVE_WITH_NOT_13 | 266357 |
| Tax Invoice Date | | Invoices.Tax Invoice Date | GLBL_TAX_INVOICE_DATE_16 | GLBL_TAX_INVOICE_DATE_16 | 266365 |
| Tax Invoice Number | | Invoices.Tax Invoice Number | GLBL_TAX_INVOICE_NUMBER_16 | GLBL_TAX_INVOICE_NUMBER_16 | 266364 |
| Tax authority transaction types | | Invoices.Tax authority transaction types | GLBL_TAX_AUTHORITY_TRANSACT_13 | GLBL_TAX_AUTHORITY_TRANSACT_13 | 266353 |
| Terms Id | Payment terms unique identifier. | Invoices.Terms Id | TERMS_ID | TERMS_ID | 164966 |
| Total GST tax in SGD | | Invoices.Total GST tax in SGD | TOTAL_GST_TAX_IN_SGD | TOTAL_GST_TAX_IN_SGD | 266316 |
| Transaction Letters | | Invoices.Transaction Letters | GLBL_TRANSACTION_LETTER_13 | GLBL_TRANSACTION_LETTER_13 | 266352 |
| US Standard GL Transaction Code | Default transaction code for creating US standard general ledger journal entries (Oracle Public Sector Payables). | Invoices.US Standard GL Transaction Code | USSGL_TRANSACTION_CODE | USSGL_TRANSACTION_CODE | 167040 |
| Vendor Id | | Invoices.Vendor Id | VENDOR_ID | VENDOR_ID | 167426 |
| Vendor Invoice Tax Amt | | Invoices.Vendor Invoice Tax Amt | VENDOR_INVOICE_TAX_AMT | VENDOR_INVOICE_TAX_AMT | 266315 |
| Vendor Site Id | Vendor site unique identifier. | Invoices.Vendor Site Id | VENDOR_SITE_ID | VENDOR_SITE_ID | 167476 |
| Wine/Cigarette | | Invoices.Wine/Cigarette | GLBL_WINE/CIGARETTE_17 | GLBL_WINECIGARETTE_17 | 266369 |