This table contains details of Payables invoice payment schedules and the currency used for transactions.This table supports the post SLA account details coming from the subledger accounting module in case of 1:1 liability account relationship.
Module: Payables
INVOICE_SCHEDULE_NUMBER, INVOICE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
INVOICE_ID | NUMBER | 38 | 0 | True | Invoice identifier. | ||
INVOICE_SCHEDULE_NUMBER | NUMBER | 38 | 0 | True | Invoice schedule number. | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source record identifier. Values are derived from combination of invoice identifier and invoice schedule number. | ||||
INVOICE_NUMBER | VARCHAR2 | 64 | Invoice number. | ||||
INVOICE_GROUP | VARCHAR2 | 64 | Invoice Group or Invoice batch name | ||||
INVOICE_DESCRIPTION | VARCHAR2 | 256 | Invoice description. | ||||
PAYMENT_REASON_COMMENTS | VARCHAR2 | 256 | Payment reason comments. | ||||
SUPPLIER_PARTY_ID | NUMBER | 38 | 0 | Supplier identifier. | DW_PARTY_D | PARTY_ID | |
SUPPLIER_SITE_ID | NUMBER | 38 | 0 | Supplier site identifier. | DW_SUPPLIER_SITE_D | SUPPLIER_SITE_ID | |
THIRD_PARTY_ID | NUMBER | 38 | 0 | Third party payee identifier. | DW_PARTY_D | SUPPLIER_ID | |
PAYABLES_BU_ID | NUMBER | 38 | 0 | Payables invoicing business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
PAYABLES_CODE_COMB_ID | NUMBER | 38 | 0 | Payables liability account identifier. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
GL_CODE_COMBINATION_ID | NUMBER | 38 | 0 | GL account identifier or Payables liability account identifier itself. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID | |
COST_CENTER_SEGMENT | VARCHAR2 | 32 | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | ||
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | ||
GL_BALANCING_SEGMENT | VARCHAR2 | 32 | Balancing segment. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT | ||
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE | ||
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT | ||
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE | ||
GL_SEGMENT1 | VARCHAR2 | 32 | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT2 | VARCHAR2 | 32 | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT3 | VARCHAR2 | 32 | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT4 | VARCHAR2 | 32 | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT5 | VARCHAR2 | 32 | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT6 | VARCHAR2 | 32 | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT7 | VARCHAR2 | 32 | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT8 | VARCHAR2 | 32 | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT9 | VARCHAR2 | 32 | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
GL_SEGMENT10 | VARCHAR2 | 32 | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE | ||
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE | ||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
INVOICED_ON_DATE | DATE | Date when invoiced is created. | |||||
INVOICE_RECEIVED_DATE | DATE | Date when invoice is received. | |||||
INVOICE_SCHEDULE_DUE_DATE | DATE | Invoice due date. | |||||
INVC_SCHEDULE_CLEARED_DATE | TIMESTAMP | Date when invoice is paid. | |||||
FIRST_DISCOUNT_DATE | DATE | Date when first discount is available. | |||||
SECOND_DISCOUNT_DATE | DATE | Date when second discount is available. | |||||
THIRD_DISCOUNT_DATE | DATE | Date when third discount is available. | |||||
INVOICE_HOLD_FLAG | VARCHAR2 | 16 | Indicates if invoice had any hold in the past. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
HOLD_STATUS_FLAG | VARCHAR2 | 16 | Indicates that the invoice is on hold. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_SCH_HOLD_STATUS_FLAG | VARCHAR2 | 16 | Flag that indicates if scheduled payment is on hold .Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment terms identifier. | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
PAYMENT_METHOD_CODE | VARCHAR2 | 32 | Payment method. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_TYPE_CODE | VARCHAR2 | 32 | Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_SOURCE_CODE | VARCHAR2 | 32 | Invoice source. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SOURCE. Possible values are INVOICE GATEWAY, Recurring Invoice, SelfService, Confirm PaymentBatch, LOANS, Manual Invoice Entry, QuickCheck, and so on. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_SCHEDULE_STATUS_CODE | VARCHAR2 | 32 | Invoice schedule status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_APPROVAL_STATUS_CODE | VARCHAR2 | 64 | Invoice approval status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_WFAPPROVAL_STATUS. Possible values are INITIATED, MANUALLY APPROVED, NOT REQUIRED, REJECTED, REMOVED FROM APPROVAL, REQUIRED, WFAPPROVED, and so on. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_VALIDATION_STATUS_CODE | VARCHAR2 | 32 | Invoice validation status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_ACCOUNTING_STATUS_CODE | VARCHAR2 | 32 | Invoice accounting status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. | DW_CODE_VALUES_LKP_TL | CODE | ||
INVOICE_CANCELLED_FLAG | VARCHAR2 | 32 | Indicates a cancelled invoice. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. | DW_CODE_VALUES_LKP_TL | CODE | ||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 | Invoice currency code. | ||||
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Ledger currency code. | ||||
TRANSACTION_AMOUNT | NUMBER | Invoice amount in invoice currency. | |||||
LEDGER_AMOUNT | NUMBER | Invoice amount in ledger currency. | |||||
REMAINING_TRANSACTION_AMOUNT | NUMBER | Remaining amount in invoice currency. | |||||
REMAINING_LEDGER_AMOUNT | NUMBER | Remaining amount in ledger currency. | |||||
FIRST_DISCOUNT_AMOUNT | NUMBER | Discount amount available at first discount date. | |||||
FIRST_DISCOUNT_LEDGER_AMOUNT | NUMBER | First discount amount in ledger currency. | |||||
SECOND_DISCOUNT_AMOUNT | NUMBER | Discount amount available at second discount date. | |||||
SECOND_DISCOUNT_LEDGER_AMOUNT | NUMBER | Second discount amount in ledger currency. | |||||
THIRD_DISCOUNT_AMOUNT | NUMBER | Discount amount available at third discount date. | |||||
THIRD_DISCOUNT_LEDGER_AMOUNT | NUMBER | Third discount amount in ledger currency. | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | ||||
GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency conversion rate. | |||||
GLOBAL_AMOUNT | NUMBER | Invoice schedule amount in global currency. | |||||
REMAINING_GLOBAL_AMOUNT | NUMBER | Invoice schedule remaining amount in global currency. | |||||
FIRST_DISCOUNT_GLOBAL_AMOUNT | NUMBER | First discount amount in global currency. | |||||
SECOND_DISCOUNT_GLOBAL_AMOUNT | NUMBER | Second discount amount in global currency. | |||||
THIRD_DISCOUNT_GLOBAL_AMOUNT | NUMBER | Third discount amount in global currency. | |||||
CREATED_BY_USER_ID | VARCHAR2 | 128 | User who created the record. | DW_USER_D | USERNAME | ||
UPDATED_BY_USER_ID | VARCHAR2 | 128 | User who updated the record. | DW_USER_D | USERNAME | ||
HEADER_CREATED_BY_USER_ID | VARCHAR2 | 128 | User who created the invoice. | DW_USER_D | USERNAME | ||
HEADER_UPDATED_BY_USER_ID | VARCHAR2 | 128 | User who updated the invoice. | DW_USER_D | USERNAME | ||
INVOICE_CREATION_DATE | TIMESTAMP | Date when invoice row was created in the table. | |||||
INVOICE_CREATION_DATE_1 | DATE | Date when invoice row was created in the table. | |||||
INVOICE_ACCOUNTING_DATE | DATE | Date when invoice was accounted | |||||
PRE_POST_SLA_FLAG | VARCHAR2 | 32 | Indicates if it is a Default AP (Pre SLA Account) or Post SLA Account.Values 'PRE' or 'POST' | ||||
POST_SLA_CCID_FLAG | VARCHAR2 | 32 | Indicates if it is a Default AP (Pre SLA Account) or Post SLA Account.Values 'N' or 'Y' | ||||
INVOICE_VOUCHER_NUMBER | NUMBER | Voucher number (Sequential Numbering) for invoice | |||||
INVOICE_ROUTING_ATTR_1 | VARCHAR | 512 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
INVOICE_ROUTING_ATTR_2 | VARCHAR | 512 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
INVOICE_ROUTING_ATTR_3 | VARCHAR | 512 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
INVOICE_ROUTING_ATTR_4 | VARCHAR | 512 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
INVOICE_ROUTING_ATTR_5 | VARCHAR | 512 | Captures additional attributes information that may have been used for routing payables invoice images. | ||||
FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. |