DW_AP_SLA_AGING_INVOICE_CA

This table contains the historical aging and current aging information for each Payment schedule in Payables along with global currency support. It supports aging analysis at Payment schedule level.

Details

Module: Payables

Key Columns

INVOICE_ID, INVOICE_SCHEDULE_NUMBER, SNAPSHOT_PERIOD_END_DATE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SNAPSHOT_PERIOD_END_DATE_ID NUMBER 38 0 True Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD) DW_FISCAL_DAY_D FISCAL_PERIOD_END_DATE_ID
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.    
SNAPSHOT_CAPTURED_DATE DATE       Date when the snapshot is captured (Note for a current snapshot this will point to the actual date and not the month end date)    
INVOICE_NUMBER VARCHAR2 64     Invoice number.    
INVOICE_GROUP VARCHAR2 64     Invoice Group or Invoice batch name    
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 schedule due date.    
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
OVERDUE_FLAG VARCHAR2 16     Indicates that the invoice is overdue. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
ELAPSED_DAYS_DUE NUMBER 38 0   Number of days elapsed since invoice due date.    
ELAPSED_DAYS_OPEN NUMBER 38 0   Number of days elapsed since invoice was created.    
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. 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. 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. 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. 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
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Invoice currency code.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code.    
TRANSACTION_AMOUNT NUMBER       Invoice schedule amount in invoice currency.    
LEDGER_AMOUNT NUMBER       Invoice schedule amount in ledger currency.    
REMAINING_TRANSACTION_AMOUNT NUMBER       Invoice schedule remaining amount in invoice currency.    
REMAINING_LEDGER_AMOUNT NUMBER       Invoice schedule remaining 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.    
INVC_SCHEDULE_CLEARED_DATE TIMESTAMP       Date when invoice schedule was paid    
INVOICE_SCHEDULE_STATUS_CODE VARCHAR2 32     Invoice Schedule Status.For translation refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='INVOICE PAYMENT STATUS' DW_CODE_VALUES_LKP_TL CODE
INVOICE_ACCOUNTING_DATE DATE       Date when invoice was accounted    
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.    
NET_ACTIVITY_AMOUNT NUMBER       Net activity amount in invoice currency    
NET_ACTIVITY_LEDGER_AMOUNT NUMBER       Net activity amount in ledger currency    
NET_ACTIVITY_GLOBAL_AMOUNT NUMBER       Net activity amount in global currency    
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'    
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
CURRENT_REMAINING_TRX_AMOUNT NUMBER       Current Remaining amount in invoice currency.    
CURRENT_REMAINING_LED_AMOUNT NUMBER       Current Remaining amount in ledger currency.    
CURRENT_REMAINING_GBL_AMOUNT NUMBER       Current Remaining amount in global currency.    
ACTIVITY_PMT_TRX_AMOUNT NUMBER       Payment Activity amount in invoice currency.    
ACTIVITY_PMT_LED_AMOUNT NUMBER       Payment Activity amount in ledger currency.    
ACTIVITY_PMT_GBL_AMOUNT NUMBER       Payment Activity amount in global currency.    
ACTIVITY_PPAY_TRX_AMOUNT NUMBER       Prepayment Activity amount in invoice currency.    
ACTIVITY_PPAY_LED_AMOUNT NUMBER       Prepayment Activity amount in ledger currency.    
ACTIVITY_PPAY_GBL_AMOUNT NUMBER       Prepayment Activity amount in global currency.    
ACTIVITY_AWT_TRX_AMOUNT NUMBER       Withholding Tax Activity amount in invoice currency.    
ACTIVITY_AWT_LED_AMOUNT NUMBER       Withholding Tax Activity amount in ledger currency.    
ACTIVITY_AWT_GBL_AMOUNT NUMBER       Withholding Tax Activity amount in global currency.    
SNAPSHOT_TYPE_FLAG VARCHAR2 64     Indicates which job loaded the data.    
FISCAL_PERIOD_NAME VARCHAR2 64     Accounting period name.