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.
Module: Receivables
PAYMENT_SCHEDULE_ID, SNAPSHOT_PERIOD_END_DATE_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. 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 |
Copyright © 2019, 2022, Oracle and/or its affiliates.