# DW_AP_SLA_INVOICE_SCHEDULE_CF

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.

## Details

Module: Payables

## Key Columns

INVOICE_SCHEDULE_NUMBER, INVOICE_ID

## Columns

Columns
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 |  |  | This column is for Oracle Internal use only. 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_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_CODE
HOLD_STATUS_FLAG | VARCHAR2 | 16 |  |  | Indicates that the invoice is on hold. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_CODE
INVOICE_SCH_HOLD_STATUS_FLAG | VARCHAR2 | 16 |  |  | Flag that indicates if scheduled payment is on hold .Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_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_AP_PAYMENT_METHOD_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. | DW_AP_PAYMENT_METHOD_LKP_TL | AP_PAYMENT_METHOD_LKP_CODE
INVOICE_TYPE_CODE | VARCHAR2 | 32 |  |  | Invoice type. Values are from the table DW_AP_INVOICE_TYPE_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_AP_INVOICE_TYPE_LKP_TL | AP_INVOICE_TYPE_LKP_CODE
INVOICE_SOURCE_CODE | VARCHAR2 | 32 |  |  | Invoice source. Values are from the table DW_AP_INVOICE_SOURCE_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_AP_INVOICE_SOURCE_LKP_TL | AP_INVOICE_SOURCE_LKP_CODE
INVOICE_SCHEDULE_STATUS_CODE | VARCHAR2 | 32 |  |  | Invoice schedule status. Values are from the table DW_AP_INV_SCH_STATUS_LKP_TL with CODE_TYPE=INVOICE PAYMENT STATUS. | DW_AP_INV_SCH_STATUS_LKP_TL | AP_INV_SCH_STATUS_LKP_CODE
INVOICE_APPROVAL_STATUS_CODE | VARCHAR2 | 64 |  |  | Invoice approval status. Values are from the table DW_AP_INV_APPR_STATUS_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_AP_INV_APPR_STATUS_LKP_TL | AP_INV_APPR_STATUS_LKP_CODE
INVOICE_VALIDATION_STATUS_CODE | VARCHAR2 | 32 |  |  | Invoice validation status. Values are from the table DW_AP_INV_VAL_STATUS_LKP_TL with CODE_TYPE=AP_INVOICE_VALIDATION_STATUS_CODE. | DW_AP_INV_VAL_STATUS_LKP_TL | AP_INV_VAL_STATUS_LKP_CODE
INVOICE_ACCOUNTING_STATUS_CODE | VARCHAR2 | 32 |  |  | Invoice accounting status. Values are from the table DW_AP_ACCOUNTING_STATUS_LKP_TL with CODE_TYPE=AP_ACCOUNTING_STATUS. | DW_AP_ACCOUNTING_STATUS_LKP_TL | AP_ACCOUNTING_STATUS_LKP_CODE
INVOICE_CANCELLED_FLAG | VARCHAR2 | 32 |  |  | Indicates a cancelled invoice. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_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. |  |
INVOICE_UPDATE_DATE | TIMESTAMP |  |  |  | Date when invoice row was updated in the table. |  |
INVOICE_UPDATE_DATE_1 | DATE |  |  |  | Date when invoice row was updated in the table. |  |
APPROVAL_DESCRIPTION | VARCHAR2 | 256 |  |  | Description of manual authorization invoice approval (used for reference purposes only). |  |
APPROVAL_READY_FLAG | VARCHAR2 | 16 |  |  | Indicates whether invoice is ready for the Invoice Approval Workflow process (Y or N) |  |
APPROVAL_ITERATION | NUMBER |  |  |  | Count of times invoice has passed through the Invoice Approval Workflow process |  |
REQUESTER_ID | NUMBER | 38 | 0 |  | Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers |  |
ROUTING_STATUS_LOOKUP_CODE | VARCHAR2 | 32 |  |  | This value indicates the routing status of the invoice. The invoice can be in the process of routing or complete. |  |
SCH_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
INVOICE_CANCELLED_DATE | DATE |  |  |  | Date when the invoice was canceled. |  |
INV_VOUCHER_NUM | VARCHAR2 | 64 |  |  | Voucher number - validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled) |  |
INV_CREATION_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting Period Name based on Invoice creation date |  |
INV_SCH_DATE_FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting Period Name based on Invoice schedule due date |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.