[Home] [Help] [Dependency Information]
Object Name: | IEX_DUNNING_TRANSACTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_SCHEDULE_ID | NUMBER | (15) | Yes | Identifies the delinquent payment schedule |
TRX_NUMBER | VARCHAR2 | (30) | The transaction number of the item. | |
CASH_RECEIPT_ID | NUMBER | (15) | Identifies the payment (cash receipt) | |
TERMS_SEQUENCE_NUMBER | NUMBER | (15) | The sequence number given to each installment for multiple payment terms | |
DUE_DATE | DATE | Yes | Due date of this installment | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Lookup code for the currency of the invoice |
AMOUNT_DUE_ORIGINAL | NUMBER | Yes | The original amount due | |
AMOUNT_DUE_REMAINING | NUMBER | Yes | The current amount due remaining | |
ACCTD_AMOUNT_DUE_REMAINING | NUMBER | Yes | Open amount of transaction in functional currency | |
CUST_TRX_STATUS_CODE | VARCHAR2 | (30) | Yes | Lookup code for the status of the item |
CUST_TRX_STATUS_NAME | VARCHAR2 | (4000) | Lookup code for the class of the payment schedule | |
CUST_TRX_CLASS_CODE | VARCHAR2 | (20) | Yes | Lookup code for the status of the item |
CUST_TRX_CLASS_NAME | VARCHAR2 | (4000) | Lookup code for the class of the payment schedule | |
CUST_TRX_TYPE_ID | NUMBER | (15) | Identifies the transaction type of the item | |
CUSTOMER_ID | NUMBER | (15) | Identifies the customer associated with the item | |
CUSTOMER_SITE_USE_ID | NUMBER | (15) | Yes | Identifies the customer site associated with the customer. This must be a 'BILL_TO' site. |
CUSTOMER_TRX_ID | NUMBER | (15) | Identifier of the customer trx id associated with this dunned record | |
ORG_ID | NUMBER | (15) | Organization identifier | |
CUSTOMER_NAME | VARCHAR2 | (50) | Name of this party | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
BILL_TO_LOCATION | VARCHAR2 | (40) | Yes | Name of Bill to Location |
DELINQUENCY_ID | NUMBER | Identifier for Delinquency. | ||
DELINQUENCY_STATUS | VARCHAR2 | (30) | Delinquency Status Code | |
DEL_STATUS_DSP | VARCHAR2 | (4000) | Delinquency Status meaning | |
DAYS_PAST_DUE | NUMBER | Number of days past due. | ||
DISPUTED_FLAG | VARCHAR2 | (1) | Dispute or not. | |
DISPUTE_DATE | DATE | Disputed Date. | ||
AMOUNT_IN_DISPUTE | NUMBER | Amount Disputed | ||
GL_DATE | DATE | Yes | General Ledger date | |
PARTY_ID | NUMBER | (15) | Yes | Party identifier |
PARTY_SITE_NUMBER | VARCHAR2 | (30) | Yes | Party site number |
CONS_INV_ID | NUMBER | (15) | Consolidated invoice ID that contains this transaction | |
OPERATING_UNIT | VARCHAR2 | (240) | Operating Unit name. | |
UWQ_STATUS | VARCHAR2 | (4000) | Status in UWQ | |
UNPAID_REASON_MEANING | VARCHAR2 | (4000) | Unpaid Reason | |
STAGED_DUNNING_LEVEL | NUMBER | Dunning level of the item as printed on the dunning correspondence | ||
DUNNING_TRX_ID | NUMBER | Yes | Primary key in IEX_DINNING_TRANSACTIONS table | |
DUNNING_ID | NUMBER | Foreign key to IEX_DUNNINGS table |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_SCHEDULE_ID
, TRX_NUMBER
, CASH_RECEIPT_ID
, TERMS_SEQUENCE_NUMBER
, DUE_DATE
, INVOICE_CURRENCY_CODE
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, ACCTD_AMOUNT_DUE_REMAINING
, CUST_TRX_STATUS_CODE
, CUST_TRX_STATUS_NAME
, CUST_TRX_CLASS_CODE
, CUST_TRX_CLASS_NAME
, CUST_TRX_TYPE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, CUSTOMER_TRX_ID
, ORG_ID
, CUSTOMER_NAME
, ACCOUNT_NUMBER
, BILL_TO_LOCATION
, DELINQUENCY_ID
, DELINQUENCY_STATUS
, DEL_STATUS_DSP
, DAYS_PAST_DUE
, DISPUTED_FLAG
, DISPUTE_DATE
, AMOUNT_IN_DISPUTE
, GL_DATE
, PARTY_ID
, PARTY_SITE_NUMBER
, CONS_INV_ID
, OPERATING_UNIT
, UWQ_STATUS
, UNPAID_REASON_MEANING
, STAGED_DUNNING_LEVEL
, DUNNING_TRX_ID
, DUNNING_ID
FROM APPS.IEX_DUNNING_TRANSACTIONS_V;
APPS.IEX_DUNNING_TRANSACTIONS_V is not referenced by any database object
|
|
|