[Home] [Help] [Dependency Information]
Object Name: | OKL_CS_BPD_INV_DTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_CS_BPD_INV_DTL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | Invoice header id | ||
CHR_ID | NUMBER | Foreign key to view OKL_K_HEADERS_V | ||
LSM_ID | NUMBER | Foreign key to view OKL_CNSLD_AR_STRMS_V for old invoices and ltd_id for new invoices | ||
INVOICE_NUMBER | VARCHAR2 | (90) | Combination of consolidated and AR invoice numbers | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
DUE_DATE | DATE | Invoice due date | ||
INVOICE_AMOUNT | NUMBER | Header Invoice amount | ||
AR_INVOICE_ID | NUMBER | AR invoice id | ||
INVOICE_DATE | DATE | Invoice date | ||
BILL_TO_SITE_USE_ID | NUMBER | Foreign Key to table OKX_CUST_SITE_USES_V | ||
CUSTOMER_ACCT_ID | NUMBER | Foreign Key to table OKX_CUSTOMER_ACCOUNTS_V | ||
ORG_ID | NUMBER | (15) | Operating unit id | |
INVOICE_TYPE | VARCHAR2 | (12) | Invoice type identifier | |
CONTRACT_NUMBER | VARCHAR2 | (150) | Contract Number | |
PAYMENT_TERM | CHAR | (9) | Payment term | |
STY_ID | NUMBER | Foreign key to view OKL_STRM_TYPE_V | ||
KLE_ID | NUMBER | Foreign key to view OKL_K_LINES_V | ||
LINE_AMOUNT | NUMBER | Invoice line original amount due | ||
TAX_AMOUNT | NUMBER | Original tax amount | ||
TAX_REMAINING | NUMBER | Tax remaining | ||
LINE_IDENTIFIER | NUMBER | Combination of AR invoice numbers and line number | ||
AMOUNT_ORIGINAL | NUMBER | Invoice line amount including tax | ||
INVOICE_LINE_ID | NUMBER | (15) | AR invoice line id | |
AMOUNT_APPLIED | NUMBER | Applied amount | ||
AMOUNT_CREDITED | NUMBER | Amount Credited | ||
AMOUNT_REMAINING | NUMBER | Remaining amount | ||
AMOUNT_ADJUSTED | NUMBER | Amount Adjusted from Invloce | ||
TRX_STATUS | VARCHAR2 | (80) | Transaction status | |
INVOICE_PULL_YN | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, CHR_ID
, LSM_ID
, INVOICE_NUMBER
, INVOICE_CURRENCY_CODE
, DUE_DATE
, INVOICE_AMOUNT
, AR_INVOICE_ID
, INVOICE_DATE
, BILL_TO_SITE_USE_ID
, CUSTOMER_ACCT_ID
, ORG_ID
, INVOICE_TYPE
, CONTRACT_NUMBER
, PAYMENT_TERM
, STY_ID
, KLE_ID
, LINE_AMOUNT
, TAX_AMOUNT
, TAX_REMAINING
, LINE_IDENTIFIER
, AMOUNT_ORIGINAL
, INVOICE_LINE_ID
, AMOUNT_APPLIED
, AMOUNT_CREDITED
, AMOUNT_REMAINING
, AMOUNT_ADJUSTED
, TRX_STATUS
, INVOICE_PULL_YN
FROM APPS.OKL_CS_BPD_INV_DTL_V;
|
|
|