[Home] [Help] [Dependency Information]
Object Name: | IEX_CS_BILLINGTRX_UV1 |
---|---|
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 |
---|---|---|---|---|
LSM_ID | NUMBER | |||
CONTRACT_NUMBER | VARCHAR2 | (150) | ||
TRANSACTION_TYPE | VARCHAR2 | (150) | ||
INVOICE_NUMBER | VARCHAR2 | (90) | ||
INVOICE_AMOUNT | NUMBER | |||
LINE_IDENTIFIER | NUMBER | |||
ASSET_NUMBER | VARCHAR2 | (4000) | ||
INVOICE_DATE | DATE | |||
DUE_DATE | DATE | |||
TRANSACTION_AMOUNT | NUMBER | |||
AMOUNT_APPLIED | NUMBER | |||
AMOUNT_REMAINING | NUMBER | |||
CUSTOMER_ACCOUNT_ID | NUMBER | |||
CONTRACT_AUTHORING_ORG_ID | NUMBER | (15) | ||
KHR_ID | NUMBER | |||
KLE_ID | NUMBER | |||
ASSET_ID | NUMBER | |||
INVOICE_ID | NUMBER | |||
STY_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
AR_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
AR_EXCHANGE_RATE | NUMBER | |||
AR_EXCHANGE_DATE | DATE | |||
AR_TRX_DATE | DATE | |||
AMOUNT_LINE_ITEMS_ORIGINAL | NUMBER | |||
AMOUNT_LINE_ITEMS_REMAINING | NUMBER | |||
TAX_ORIGINAL | NUMBER | |||
TAX_REMAINING | NUMBER | |||
AMOUNT_CREDITED | NUMBER | |||
CUSTOMER_TRX_ID | NUMBER | |||
INVOICE_LINE_ID | NUMBER | (15) | ||
PAYMENT_TERM | CHAR | (9) | ||
INVOICE_TYPE | VARCHAR2 | (12) | ||
TRX_NUMBER | VARCHAR2 | (30) | ||
DEL_STATUS | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT LSM_ID
, CONTRACT_NUMBER
, TRANSACTION_TYPE
, INVOICE_NUMBER
, INVOICE_AMOUNT
, LINE_IDENTIFIER
, ASSET_NUMBER
, INVOICE_DATE
, DUE_DATE
, TRANSACTION_AMOUNT
, AMOUNT_APPLIED
, AMOUNT_REMAINING
, CUSTOMER_ACCOUNT_ID
, CONTRACT_AUTHORING_ORG_ID
, KHR_ID
, KLE_ID
, ASSET_ID
, INVOICE_ID
, STY_ID
, CURRENCY_CODE
, AR_EXCHANGE_RATE_TYPE
, AR_EXCHANGE_RATE
, AR_EXCHANGE_DATE
, AR_TRX_DATE
, AMOUNT_LINE_ITEMS_ORIGINAL
, AMOUNT_LINE_ITEMS_REMAINING
, TAX_ORIGINAL
, TAX_REMAINING
, AMOUNT_CREDITED
, CUSTOMER_TRX_ID
, INVOICE_LINE_ID
, PAYMENT_TERM
, INVOICE_TYPE
, TRX_NUMBER
, DEL_STATUS
FROM APPS.IEX_CS_BILLINGTRX_UV1;
|
|
|