DW_AR_AGING_ACCNTD_RECEIPT_FUTURE_ACTIVITIES_CA

This table contains the Future aging information for each Receipt and currency .

Details

Module: Receivables

Key Columns

FISCAL_PERIOD_END_DATE_ID, CASH_RECEIPT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FISCAL_PERIOD_END_DATE_ID NUMBER 38 0 True Snapshot Date (Fiscal Calendar Period End Date) (YYYYMMDD)    
CASH_RECEIPT_ID NUMBER 38 0 True Cash receipt identifier.    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Source record identifier. Value is same as the payment schedule identifier.    
PAYMENT_SCHEDULE_ID NUMBER 38 0   Payment schedule identifier.    
RECEIPT_NUMBER VARCHAR2 32          
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.    
TRANSACTION_CLASS_CODE VARCHAR2 32          
LEDGER_ID NUMBER 38 0   Ledger identifier.    
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier.    
CUSTOMER_ID NUMBER 38 0   Customer identifier.    
CUSTOMER_ACCOUNT_ID NUMBER 38 0   Customer account identifier.    
CUSTOMER_PAYING_LOCATION_ID NUMBER 38 0   Customer paying location identifier.    
RECEIPT_BU_ORG_ID NUMBER 38 0   Receipt business unit organization identifier.    
RECEIPT_DOCUMENT_NUMBER NUMBER 38 0        
RECEIPT_DATE DATE            
TRANSACTION_DATE DATE            
RECEIPT_ACCOUNTING_DATE DATE            
CHECK_CLEARED_DATE DATE       Date on which the check was cleared    
RECEIPT_CURRENCY_CODE VARCHAR2 16     Receipt currency code    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
GLOBAL_CURRENCY_EXCH_RATE NUMBER            
RECEIPT_AMOUNT NUMBER            
RECEIPT_LEDGER_AMOUNT NUMBER            
RECEIPT_GLOBAL_AMOUNT NUMBER            
NET_ACTIVITY_AMOUNT NUMBER            
NET_ACTIVITY_LEDGER_AMOUNT NUMBER            
NET_ACTIVITY_GLOBAL_AMOUNT NUMBER            
NET_ONACC_AMOUNT NUMBER            
NET_ONACC_LEDGER_AMOUNT NUMBER            
NET_ONACC_GLOBAL_AMOUNT NUMBER            
FISCAL_PERIOD_SET_NAME VARCHAR2 16     Accounting calendar name.    
FISCAL_PERIOD_TYPE VARCHAR2 16     Accounting period type.    
GL_CODE_COMBINATION_ID NUMBER 38 0   Accounting code combination identifier.    
GL_BALANCING_SEGMENT VARCHAR2 32     Balancing segment.    
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64     Balancing segment value set code.    
COST_CENTER_SEGMENT VARCHAR2 32     Cost center segment.    
COST_CENTER_VALUESET_CODE VARCHAR2 64     Cost center value set code.    
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32     Natural account segment.    
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64     Natural account value set code.    
GL_SEGMENT1 VARCHAR2 32     Accounting segment 1.    
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64     Accounting segment 1 value set code.    
GL_SEGMENT2 VARCHAR2 32     Accounting segment 2.    
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64     Accounting segment 2 value set code.    
GL_SEGMENT3 VARCHAR2 32     Accounting segment 3.    
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64     Accounting segment 3 value set code.    
GL_SEGMENT4 VARCHAR2 32     Accounting segment 4.    
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64     Accounting segment 4 value set code.    
GL_SEGMENT5 VARCHAR2 32     Accounting segment 5.    
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64     Accounting segment 5 value set code.    
GL_SEGMENT6 VARCHAR2 32     Accounting segment 6.    
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64     Accounting segment 6 value set code.    
GL_SEGMENT7 VARCHAR2 32     Accounting segment 7.    
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64     Accounting segment 7 value set code.    
GL_SEGMENT8 VARCHAR2 32     Accounting segment 8.    
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64     Accounting segment 8 value set code.    
GL_SEGMENT9 VARCHAR2 32     Accounting segment 9.    
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64     Accounting segment 9 value set code.    
GL_SEGMENT10 VARCHAR2 32     Accounting segment 10.    
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64     Accounting segment 10 value set code.    
FISCAL_PERIOD_NAME VARCHAR2 64     FISCAL_PERIOD_NAME    
SHIP_TO_CUSTOMER_ID NUMBER 38 0   Ship to Customer Identifier    
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Ship To customer account identifier.    
SHIP_TO_CUST_ACCT_SITE_ID NUMBER 38 0   Ship to Customer Account Site Identifier    
PAYING_TO_CUST_ACCT_SITE_ID NUMBER 38 0   Paying to Customer Account Site Identifier    
RECEIPT_CUST_ACCT_SITE_ID NUMBER 38 0   Receipt Customer Account Site Identifier    
CUSTOMER_SITE_USE_ID NUMBER 38 0   Bill to customer site use Identifier    
SHIP_TO_SITE_USE_ID NUMBER 38 0   Ship to site use Identifier    
PAYING_SITE_USE_ID NUMBER 38 0   Paying site use Identifier    
CUSTOMER_SITE VARCHAR2 256     Site Location    

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