DW_AR_AGING_ACCT_INV_RCPT_CUST_CA (Preview)

This table requires activation of Receivable Aging functional area. This view contains information about both the accounted invoice aging data as well as the receipt aging data.

Details

Module: Receivables

Key Columns

TRANSACTION_CURRENCY_CODE, CUSTOMER_SITE_USE_ID, CUSTOMER_ACCOUNT_ID, RECEIPT_BU_ORG_ID, RECEIVABLES_BU_ORG_ID, PAYMENT_SCHEDULE_STATUS_CODE, POST_SLA_CCID_FLAG, LEDGER_ID, RECEIVABLES_CODE_COMB_ID, SNAPSHOT_PERIOD_END_DATE_ID, FISCAL_PERIOD_TYPE, CUSTOMER_ID, GL_CODE_COMBINATION_ID, LEGAL_ENTITY_ID, FISCAL_PERIOD_SET_NAME

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
CUSTOMER_ID NUMBER 38 0 True Customer identifier. DW_PARTY_D PARTY_ID
CUSTOMER_ACCOUNT_ID NUMBER 38 0 True Customer account identifier. DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
RECEIPT_BU_ORG_ID NUMBER 38 0 True Receipt business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 True Ledger identifier. DW_LEDGER_D LEDGER_ID
LEGAL_ENTITY_ID NUMBER 38 0 True Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
FISCAL_PERIOD_SET_NAME VARCHAR2 16   True Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16   True Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
PAYMENT_SCHEDULE_STATUS_CODE VARCHAR2 32   True 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
CUSTOMER_SITE_USE_ID NUMBER 38 0 True Third party payee identifier. DW_PARTY_D SUPPLIER_ID
RECEIVABLES_BU_ORG_ID NUMBER 38 0 True Receivables business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
RECEIVABLES_CODE_COMB_ID NUMBER 38 0 True Receivables code combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
GL_CODE_COMBINATION_ID NUMBER 38 0 True Accounting code combination identifier. DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
TRANSACTION_CURRENCY_CODE VARCHAR2 16   True Invoice currency code or Receipt currency    
POST_SLA_CCID_FLAG VARCHAR2 32   True Indicates if it is a Default AR (Pre SLA Account) or Post SLA Account.Values 'Y' or 'N'    
SOURCE_RECORD_ID VARCHAR2 999     Source record identifier.    
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)    
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
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
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency 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
COMMON_BU_ORG_ID NUMBER 38 0   common business unit organization identifier for invoice and receipt DW_INTERNAL_ORG_D ORGANIZATION_ID
GLOBAL_AMOUNT NUMBER       Receipt Amoun or Total Invoice schedule amount in Global Currency.    
LEDGER_AMOUNT NUMBER       Receipt amount or Total Invoice schedule amount in ledger currency.    
TRANSACTION_AMOUNT NUMBER       Total Invoice schedule amount in invoice currency or Receipt amount in Receipt currency.    
NET_ACTIVITY_AMOUNT NUMBER       Total Net activity amount in invoice currency or Net activity amount in receipt currency    
NET_ACTIVITY_GLOBAL_AMOUNT NUMBER       Net activity amount in Global currency    
NET_ACTIVITY_LEDGER_AMOUNT NUMBER       Net activity amount in ledger currency    
REMAINING_GLOBAL_AMOUNT NUMBER       Remaining Receipt amount in Global currency or Total Invoice schedule remaining amount in global currency.    
REMAINING_LEDGER_AMOUNT NUMBER       Remaining Receipt amount in Ledger currency or Total Invoice schedule remaining amount in Ledger currency.    
REMAINING_TRANSACTION_AMOUNT NUMBER       Remaining Receipt amount in receipt currency or Total Invoice schedule remaining amount in invoice currency.    
RISK_AMOUNT NUMBER       Risk Amount in Receipt Currency    
RISK_LEDGER_AMOUNT NUMBER       Risk Amount in Ledger Currency    
RISK_GLOBAL_AMOUNT NUMBER       Risk Amount in Global Currency    
FISCAL_PERIOD_NAME VARCHAR2 64     FISCAL_PERIOD_NAME    
BILL_TO_CUSTOMER_ID NUMBER 38 0   Bill to Customer identifier. DW_PARTY_D PARTY_ID
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Bill to Customer account identifier. DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
PAYING_CUSTOMER_ID NUMBER 38 0   Paying Customer identifier. DW_PARTY_D PARTY_ID
PAYING_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Paying Customer account identifier. DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID

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