DW_AR_AGING_RECEIPT_CA

This table contains the aging information for each open payment schedule(PMT schedules) and currency used in Receivables.

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.    
SNAPSHOT_CAPTURED_DATE DATE       Date when the snapshot is captured.    
RECEIPT_ID NUMBER 38 0   Receipt Id    
RECEIPT_NUMBER VARCHAR2 32     Receipt number.    
RECEIPT_METHOD_CODE NUMBER 38 0   Receipt method id. DW_CODE_VALUES_LKP_TL CODE
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
TRANSACTION_CLASS_CODE VARCHAR2 256     Lookup code for the class of the payment schedule    
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_PAYING_LOCATION_ID NUMBER 38 0   Dimension Identifier DW_CUSTOMER_LOCATION_D CUSTOMER_LOCATION_ID
RECEIPT_BU_ORG_ID NUMBER 38 0   Receipt business unit organization identifier. DW_INTERNAL_ORG_D ORGANIZATION_ID
RECEIPT_DOCUMENT_NUMBER NUMBER 38 0   Document number for the Receipt    
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
RECEIPT_DATE DATE       Receipt Date. DW_FISCAL_DAY_D FISCAL_DAY_DATE
CHECK_CLEARED_DATE DATE       Date when check got cleared.(Receipt status changed to cleared)    
RECEIPT_ACTUAL_CLOSED_DATE DATE       Date when payment schedule was actually closed.    
RECEIPT_EFFECTIVE_CLOSED_DATE DATE       Max of check cleared and schedule closed date in order to determine till when the snapshot to be created. Null when schedule is Open or the check is not cleared.    
RECEIPT_RISK_FLAG VARCHAR2 16     Identifies if the receipt is at risk or not (Y or N)    
ELAPSED_DAYS_OPEN NUMBER 38 0   Number of days elapsed since Receipt Date.    
RECEIPT_CURRENCY_CODE VARCHAR2 16     Invoice currency code.    
LEDGER_CURRENCY_CODE VARCHAR2 16     Ledger currency code.    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global currency code.    
RECEIPT_AMOUNT NUMBER       Receipt amount in Receipt currency.    
RECEIPT_LEDGER_AMOUNT NUMBER       Receipt amount in ledger currency.    
RECEIPT_GLOBAL_AMOUNT NUMBER       Receipt Amount in Global Currency.    
CURRENT_REMAINING_RCPT_AMOUNT NUMBER       Current Remaining Receipt amount in Receipt currency.    
CURRENT_REMAINING_LED_AMOUNT NUMBER       Current Remaining Receipt amount in ledger currency.    
CURRENT_REMAINING_GBL_AMOUNT NUMBER       Current Remaining Receipt amount in Global currency.    
NET_ACTIVITY_AMOUNT NUMBER       Net activity amount in receipt currency for Status not in (UNAPP & ACC)    
NET_ACTIVITY_LEDGER_AMOUNT NUMBER       Net activity amount in ledger currency for Status not in (UNAPP & ACC)    
NET_ACTIVITY_GLOBAL_AMOUNT NUMBER       Net activity amount in Global currency for Status not in (UNAPP & ACC)    
ONACC_AMOUNT NUMBER       On Account amount in Receipt currency.    
ONACC_LEDGER_AMOUNT NUMBER       On Account amount in ledger currency.    
ONACC_GLOBAL_AMOUNT NUMBER       On Account Amount in Global Currency.    
UNAPP_AMOUNT NUMBER       Unapplied amount in Receipt currency.    
UNAPP_LEDGER_AMOUNT NUMBER       Unapplied amount in ledger currency.    
UNAPP_GLOBAL_AMOUNT NUMBER       Unapplied Amount in Global Currency.    
REMAINING_RECEIPT_AMOUNT NUMBER       Remaining Receipt amount in Receipt currency.    
REMAINING_LEDGER_AMOUNT NUMBER       Remaining Receipt amount in ledger currency.    
REMAINING_GLOBAL_AMOUNT NUMBER       Remaining Receipt amount in Global currency.    
FISCAL_PERIOD_NAME VARCHAR2 64     FISCAL_PERIOD_NAME