DW_AR_AGING_ACCNTD_INVOICE_CA (Preview)

This table requires activation of Receivable Aging functional area. This table contains the aging information for each payment schedule and currency used in Receivables. It supports aging analysis at Payment schedule level.

Details

Module: Receivables

Key Columns

SNAPSHOT_PERIOD_END_DATE_ID, PAYMENT_SCHEDULE_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
PAYMENT_SCHEDULE_ID NUMBER 38 0 True Payment schedule identifier.    
SOURCE_RECORD_ID VARCHAR2 128     Source record identifier. Value is same as the payment schedule identifier.    
SNAPSHOT_CAPTURED_DATE DATE       Date when the snapshot is captured.    
CUSTOMER_TRX_ID NUMBER 38 0   Attribute    
TRANSACTION_NUMBER VARCHAR2 32     Transaction number.    
RECEIPT_METHOD_CODE VARCHAR2 32     Receipt method code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AR_RECEIPT_METHOD_CODE. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_SPECL_INSTRCTIONS VARCHAR2 256     Transaction special instructions.    
TRANSACTION_COMMENTS VARCHAR2 999     Transaction comments.    
TRANSACTION_COMPLETE_FLAG VARCHAR2 16     Indicates a completed transaction.    
TRANSACTION_CLASS_CODE VARCHAR2 32     Transaction class. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AR_TRANSACTION_TYPE_CODE. Possible values are INV, CM, DM, or CB. DW_CODE_VALUES_LKP_TL CODE
TRANSACTION_TYPE_NAME VARCHAR2 32     Transaction type name. Possible values are AR_TransType_19, Credit Memo_32, and so on.    
TRANSACTION_TYPE_DESCRIPTION VARCHAR2 128     Transaction type description. Possible values are Regular Debit Memo, Regular Credit Memo, and so on.    
TRANSACTION_SOURCE VARCHAR2 64     Transaction source. Possible values are SERVICE, LEGACY, and so on.    
TRANSACTION_SOURCE_DESC VARCHAR2 256     Transaction source description.    
PAYMENT_SCHEDULE_STATUS_CODE VARCHAR2 32     Payment schedule status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=PAYMENT_SCHEDULE_STATUS. Possible values are OP for Open and CL for Closed. DW_CODE_VALUES_LKP_TL CODE
OVERDUE_FLAG VARCHAR2 16     Indicates that the invoice is overdue.    
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
CUSTOMER_ID NUMBER 38 0   Customer identifier. DW_PARTY_D PARTY_ID
CUSTOMER_ACCOUNT_ID NUMBER 38 0   Customer account identifier. DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
CUSTOMER_CONTACT_ID NUMBER 38 0   Customer contact identifier. DW_PARTY_D PARTY_ID
BILL_TO_CONTACT_ID NUMBER 38 0   Bill-to contact identifier. DW_PARTY_D PARTY_ID
SHIP_TO_CONTACT_ID NUMBER 38 0   Ship-to contact identifier. DW_PARTY_D PARTY_ID
PAYING_CUSTOMER_ID NUMBER 38 0   Paying Customer ID DW_PARTY_D PARTY_ID
PAYING_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Paying Customer Account ID DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
CUSTOMER_PAYING_SITE VARCHAR2 256     Customer Paying Site    
CUSTOMER_SITE_USE_ID NUMBER 38 0   Customer site usage identifier.    
CUSTOMER_BILL_TO_SITE VARCHAR2 256     Customer bill-to site.    
CUSTOMER_SHIP_TO_SITE VARCHAR2 32     Customer ship-to site.    
CUSTOMER_BILL_TO_LOCATION_ID NUMBER 38 0   Customer bill-to location identifier. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
CUSTOMER_PAYING_LOCATION_ID NUMBER 38 0   Customer paying location identifier. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
CUSTOMER_SHIP_TO_LOCATION_ID NUMBER 38 0   Customer ship-to location identifier. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
CUSTOMER_SOLD_TO_LOCATION_ID NUMBER 38 0   Customer sold-to location identifier. DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
PAYMENT_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AR_PAYMENT_TERMS_D PAYMENT_TERM_ID
RECEIVABLES_BU_ORG_ID NUMBER 38 0   Receivables business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
RECEIVABLES_CODE_COMB_ID NUMBER 38 0   Receivables code combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
GL_CODE_COMBINATION_ID NUMBER 38 0   Accounting code combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
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
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
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
ACCOUNTING_DATE DATE       Accounting date.    
TRANSACTION_DATE DATE       Transaction date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
PAYMENT_DUE_DATE DATE       Payment due date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
SCHEDULE_ACTUAL_CLOSED_DATE DATE       Date when payment schedule was actually closed.    
ELAPSED_DAYS_DUE NUMBER 38 0   Number of days elapsed since payment due date.    
ELAPSED_DAYS_OPEN NUMBER 38 0   Number of days elapsed since payment schedule was opened.    
TRANSACTION_CURRENCY_CODE VARCHAR2 16     Invoice currency code.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code.    
TRANSACTION_ORIGINAL_AMOUNT NUMBER       Due amount in invoice currency.    
TRANSACTION_AMOUNT NUMBER       Due amount in transaction currency. This will be deprecated in future releases. TRANSACTION_ORIGINAL_AMOUNT can be used to get this information.    
LEDGER_AMOUNT NUMBER       Due amount in ledger currency.    
REMAINING_TRANSACTION_AMOUNT NUMBER       Remaining amount in invoice currency.    
REMAINING_LEDGER_AMOUNT NUMBER       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 amount in global currency.    
REMAINING_GLOBAL_AMOUNT NUMBER       Remaining amount in global currency.    
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    
TRANSACTION_PAYMENT_STATUS VARCHAR2 32     Payment status for the transaction    
SALESPERSON_PARTY_ID NUMBER 38 0   Party identifier of salesrep DW_PARTY_D PARTY_ID
TRANSACTION_DOCUMENT_NUMBER NUMBER 38 0   Document number for the transaction    
INSTALLMENT_SEQUENCE_NUMBER NUMBER 38 0   Installment sequence number    
POST_SLA_CCID_FLAG VARCHAR2 32     Indicates if it is a Default AR (Pre SLA Account) or Post SLA Account.Values 'Y' or 'N'    
CUST_TRX_TYPE_SEQ_ID NUMBER 38 0   Transaction type sequence identifier.    
BATCH_SOURCE_SEQ_ID NUMBER 38 0   Batch source sequence identifier.    
SOLD_TO_CUSTOMER_ID NUMBER 38 0   Identifier    
FISCAL_PERIOD_NAME VARCHAR2 64     FISCAL_PERIOD_NAME    
CUST_ACCT_SITE_ID NUMBER 38 0   Customer Account Site Identifier    
SHIP_TO_CUSTOMER_ID NUMBER 38 0   Identifier DW_PARTY_D PARTY_ID
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SHIP_TO_CUST_ACCT_SITE_ID NUMBER 38 0   Attribute    
PAYING_TO_CUST_ACCT_SITE_ID NUMBER 38 0   Attribute    
SHIP_TO_SITE_USE_ID NUMBER 38 0   Attribute    
PAYING_SITE_USE_ID NUMBER 38 0   Attribute    
TRANSACTION_REASON_CODE VARCHAR2 32     Code DW_AR_TRXN_REASON_LKP_TL  

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