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)