[Home] [Help] [Dependency Information]
Object Name: | OKL_TXD_AR_LN_DTLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_TXD_AR_LN_DTLS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Transaction line details to be included into Receivables invoices
normal periodic billing of a stream
Charges applied to delayed customer payments
Upon reversing of a contract, all billing transactions associated with the contract need to be reversed. It is accomplished by creating a transaction with opposite amount for every existing contract transaction.
DEFINITION
A subtype of "transaction", but a supertype of all OKL transaction line details.
EXAMPLE
MISCELLANEOUS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
BCH_ID | NUMBER | Foreign key to table OKL_BILLING_CHARGES_B | ||
BGH_ID | NUMBER | Foreign key to table OKL_BLLNG_CHRG_HDRS_B | ||
IDX_ID | NUMBER | Foreign key to table OKL_INDICES | ||
TLD_ID_REVERSES | NUMBER | Foreign Key to table OKL_TXD_AR_LN_DTLS_B | ||
STY_ID | NUMBER | Foreign key to table OKL_STRM_TYPE_B | ||
SEL_ID | NUMBER | Foreign key to table OKL_STRM_ELEMENTS | ||
TIL_ID_DETAILS | NUMBER | Foreign Key to table OKL_TXL_AR_INV_LNS_B | ||
BCL_ID | NUMBER | Foreign Key to table OKS_BILL_CONT_LINES | ||
BSL_ID | NUMBER | Foreign Key to table OKS_BILL_SUB_LINES | ||
AMOUNT | NUMBER | (14) | Amount | |
LINE_DETAIL_NUMBER | NUMBER | Line number | ||
RECEIVABLES_INVOICE_ID | NUMBER | Surrogate key used for primary unique identifiers | ||
LATE_CHARGE_YN | VARCHAR2 | (3) | Yes or No | |
DESCRIPTION | VARCHAR2 | (1995) | General description | |
ERROR_MESSAGE | VARCHAR2 | (3000) | Error Message | |
AMOUNT_APPLIED | NUMBER | (14) | Monetary amount | |
DATE_CALCULATION | DATE | Date of charge application | ||
FIXED_RATE_YN | VARCHAR2 | (3) | Yes or No | |
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
ORG_ID | NUMBER | (15) | Operating unit identifier | |
INVENTORY_ORG_ID | NUMBER | Inventory item org id | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
TXL_AR_LINE_NUMBER | NUMBER | Foreign key of OKL_TXL_AR_INV_LNS_B.txl_ar_line_number | ||
INVOICE_FORMAT_LINE_TYPE | VARCHAR2 | (150) | Foreign key of okl_invc_line_types_tl.name | |
INVOICE_FORMAT_TYPE | VARCHAR2 | (150) | Foreign key of okl_invoice_types_tl.name | |
LATE_CHARGE_ASSESS_DATE | DATE | Late charge assess date | ||
LATE_INT_ASSESS_DATE | DATE | Late Interest Assess Date | ||
LATE_CHARGE_ASS_YN | VARCHAR2 | (3) | Late charge assess Yes/No | |
LATE_INT_ASS_YN | VARCHAR2 | (3) | Late interest assess Yes/No | |
INVESTOR_DISB_STATUS | VARCHAR2 | (30) | Investor disbursement status | |
INVESTOR_DISB_ERR_MG | VARCHAR2 | (3000) | Investor disbursement error message | |
DATE_DISBURSED | DATE | Date Disbursed | ||
PAY_STATUS_CODE | VARCHAR2 | (240) | Status of invoice payment | |
TAX_AMOUNT | NUMBER | (14) | Tax amount | |
LSM_ID | NUMBER | Foreign key of OKL_CNSLD_AR_STRMS_B.id | ||
RBK_ORI_INVOICE_NUMBER | VARCHAR2 | (20) | Foreign key of ra_customer_trx_all.trx_number | |
RBK_ORI_INVOICE_LINE_NUMBER | VARCHAR2 | (30) | Foreign key of ra_customer_trx_lines_all.line_number | |
RBK_ADJUSTMENT_DATE | DATE | Rebook Adjustment date | ||
KHR_ID | NUMBER | Foreign key of okc_k_headers_b.id | ||
KLE_ID | NUMBER | Foreign key of okl_k_headers.id |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, BCH_ID
, BGH_ID
, IDX_ID
, TLD_ID_REVERSES
, STY_ID
, SEL_ID
, TIL_ID_DETAILS
, BCL_ID
, BSL_ID
, AMOUNT
, LINE_DETAIL_NUMBER
, RECEIVABLES_INVOICE_ID
, LATE_CHARGE_YN
, DESCRIPTION
, ERROR_MESSAGE
, AMOUNT_APPLIED
, DATE_CALCULATION
, FIXED_RATE_YN
, INVENTORY_ITEM_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, INVENTORY_ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TXL_AR_LINE_NUMBER
, INVOICE_FORMAT_LINE_TYPE
, INVOICE_FORMAT_TYPE
, LATE_CHARGE_ASSESS_DATE
, LATE_INT_ASSESS_DATE
, LATE_CHARGE_ASS_YN
, LATE_INT_ASS_YN
, INVESTOR_DISB_STATUS
, INVESTOR_DISB_ERR_MG
, DATE_DISBURSED
, PAY_STATUS_CODE
, TAX_AMOUNT
, LSM_ID
, RBK_ORI_INVOICE_NUMBER
, RBK_ORI_INVOICE_LINE_NUMBER
, RBK_ADJUSTMENT_DATE
, KHR_ID
, KLE_ID
FROM APPS.OKL_TXD_AR_LN_DTLS_V;
|
|
|