This table contains the aging information for each open payment schedule(PMT schedules) and currency used in Receivables.
Module: Receivables
SNAPSHOT_PERIOD_END_DATE_ID, PAYMENT_SCHEDULE_ID
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 | ||||
CUST_ACCT_SITE_ID | NUMBER | 38 | 0 | Customer Account Site Identifier |
Copyright © 2019, 2023, Oracle and/or its affiliates.