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_SCHEDULE_NUMBER, INVOICE_ID, SNAPSHOT_PERIOD_END_DATE_ID
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 | This column is for Oracle Internal use only. 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_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 | ||
| OVERDUE_FLAG | VARCHAR2 | 16 | Indicates that the invoice is overdue. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | YESNO_LKP_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_AP_PAYMENT_METHOD_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. | 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. | 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. | DW_AP_INVOICE_SOURCE_LKP_TL | AP_INVOICE_SOURCE_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. | 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 | ||
| 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_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_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. | ||||
| 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. | |||||
| INVOICE_DESCRIPTION | VARCHAR2 | 256 | Invoice description. | ||||
| INVOICE_CANCELLED_DATE | DATE | Date when the invoice was canceled. | |||||
| INVOICE_CANCELLED_FLAG | VARCHAR2 | 16 | Flag to identify cancelled invoice. |