[Home] [Help] [Dependency Information]
Object Name: | CSC_INV_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 payment schedule |
TRX_NUMBER | VARCHAR2 | (20) | Yes | The transaction number of the item |
PURCHASE_ORDER | VARCHAR2 | (50) | Purchase Order | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
DUE_DATE | DATE | Yes | Due date of this installment | |
TRX_DATE | DATE | Yes | Transaction date of the Invoice | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of the Invoice |
AMOUNT_DUE_ORIGINAL | NUMBER | Yes | The original amount due | |
AMOUNT_DUE_REMAINING | NUMBER | Yes | The current amount due remaining | |
CUST_TRX_STATUS_CODE | VARCHAR2 | (30) | Yes | Lookup Code for the Status of the Invoice |
CUST_TRX_STATUS_NAME | VARCHAR2 | (80) | Yes | Lookup Code meaning for the Status of the Invoice |
CUST_TRX_CLASS_CODE | VARCHAR2 | (20) | Yes | Lookup code for the class of the payment schedule |
CUST_TRX_CLASS_NAME | VARCHAR2 | (80) | Yes | Lookup code meaning for the class of the payment schedule |
CUST_TRX_TYPE_ID | NUMBER | (15) | Identifies the transaction type of the item | |
CUST_TRX_TYPE_NAME | VARCHAR2 | (20) | Transaction type name | |
CUSTOMER_ID | NUMBER | (15) | Account ID | |
CUSTOMER_TRX_ID | NUMBER | (15) | Identifies the item itself | |
ORG_ID | NUMBER | (15) | Organization identifier | |
OPERATING_UNIT | VARCHAR2 | (240) | Yes | Name of this organization |
CUSTOMER_NAME | VARCHAR2 | (50) | Account Name | |
ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Account Number |
DELINQUENCY_ID | NUMBER | Primary key | ||
DELINQUENCY_STATUS | VARCHAR2 | (30) | What is the delinquency status | |
DEL_STATUS_DSP | VARCHAR2 | (80) | Delinquency status meaning | |
DAYS_PAST_DUE | NUMBER | Days due for payment | ||
DISPUTE_DATE | DATE | This column stores the last date that was inserted into the AR_DISPUTE_HISTORY table. It basically serves as a placeholder so that the database trigger knows what date to insert. | ||
AMOUNT_IN_DISPUTE | NUMBER | The amount in dispute against the item | ||
SALES_ORDER | VARCHAR2 | (0) | Sales Order number | |
GL_DATE | DATE | Yes | General Ledger date | |
AMOUNT_APPLIED | NUMBER | Amount applied to the item | ||
LAST_CHARGE_DATE | DATE | This column is reserved for future use. RA_SITE_USES.LAST_CHARGE_DATE is being moved down to this level. | ||
COMMENTS | VARCHAR2 | (1760) | Stores comments entered in the Transactions workbench. Value can be printed on an invoice using the Print Invoice view. | |
TERM_ID | NUMBER | (15) | Payment term identifier | |
TERM_NAME | VARCHAR2 | (15) | Payment term meaning | |
PRIMARY_SALESREP_ID | NUMBER | (15) | Sale rep given primary credit for the transaction | |
PRIMARY_SALESREP_NAME | VARCHAR2 | (240) | Sale rep name given primary credit for the transaction | |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
COMPLETE_FLAG | VARCHAR2 | (1) | Yes | Shows Invoice is complete or not |
PARTY_ID | NUMBER | (15) | Yes | Party ID |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_SCHEDULE_ID
, TRX_NUMBER
, PURCHASE_ORDER
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DUE_DATE
, TRX_DATE
, INVOICE_CURRENCY_CODE
, AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING
, CUST_TRX_STATUS_CODE
, CUST_TRX_STATUS_NAME
, CUST_TRX_CLASS_CODE
, CUST_TRX_CLASS_NAME
, CUST_TRX_TYPE_ID
, CUST_TRX_TYPE_NAME
, CUSTOMER_ID
, CUSTOMER_TRX_ID
, ORG_ID
, OPERATING_UNIT
, CUSTOMER_NAME
, ACCOUNT_NUMBER
, DELINQUENCY_ID
, DELINQUENCY_STATUS
, DEL_STATUS_DSP
, DAYS_PAST_DUE
, DISPUTE_DATE
, AMOUNT_IN_DISPUTE
, SALES_ORDER
, GL_DATE
, AMOUNT_APPLIED
, LAST_CHARGE_DATE
, COMMENTS
, TERM_ID
, TERM_NAME
, PRIMARY_SALESREP_ID
, PRIMARY_SALESREP_NAME
, BILL_TO_CUSTOMER_ID
, COMPLETE_FLAG
, PARTY_ID
FROM APPS.CSC_INV_TRANSACTIONS_V;
APPS.CSC_INV_TRANSACTIONS_V is not referenced by any database object
|
|
|