eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_TXL_AR_INV_LNS_B

Object Details

Object Name:	OKL_TXL_AR_INV_LNS_B
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TXL_AR_INV_LNS_B
Subobject Name:
Status:	VALID

Transaction lines to be included into Receivables invoices
normal periodic billing of an asset
the particular asset line within an invoice
The particular line within the cure and its payment.
This the details of repurchasing an asset.
a miscellaneous manually entered receivable invoice line
Charges applied to delayed customer payments
DEFINITION
A veritable interest charge line entity to hold the detail of variable interest charges for transaction lines
EXAMPLE
MISCELLANEOUS
DEFINITION
Will be holding line level detail for interim interest.
EXAMPLE
MISCELLANEOUS

Product related fees for performing various services
DEFINITION
the transaction lines to bill for the repair costs of a damaged asset. The associated header is ASSET REPAIR BILL.
EXAMPLE
MISCELLANEOUS
Negative vendor charges means that a vendor ows us money.
If the vendor is active and allows netting, a negative charge becomes a Payables debit note and is used to offset vendor invoices.
However, if the vendor is no longer active or the vendor does not allow netting, negative charge is sent to Receivables and billed to the customer corresponding to the vendor.
DEFINITION
The transaction to bill for a repurchase sale.
EXAMPLE
MISCELLANEOUS
Customer charges associated with termination quote
DEFINITION
The transaction to bill for a receivable amount in relation to a principal paydown.
EXAMPLE
MISCELLANEOUS
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.
Biling transaction associated with rebooking
DEFINITION
A subtype of "transaction", but a supertype of all OKL transaction lines.
EXAMPLE
MISCELLANEOUS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TXL_AR_INV_LNS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
TIL_ACN_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACN_ID_COST
TIL_IRL_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INV_RECEIV_LINE_CODE
TIL_ISL_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ISL_ID
TIL_KLE_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KLE_ID
TIL_QTE_LN_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTE_LINE_ID
TIL_STY_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STY_ID
TIL_TAI_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAI_ID
TIL_TIL_REVERSES_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIL_ID_REVERSES
TIL_TPL_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TPL_ID
TIL_TXS_TRX_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TXS_TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
INV_RECEIV_LINE_CODE	VARCHAR2	(30)		Line types are: line, tax, freight, or charges
TAI_ID	NUMBER		Yes	Foreign key to table OKL_TRX_AR_INVOICES_B
KLE_ID	NUMBER			Foreign key to table OKL_K_LINES
ISL_ID	NUMBER			Foreign Key to view OKL_AM_SALES_ORDERS_V
IBT_ID	NUMBER			Not currently used; Bill_To site
TPL_ID	NUMBER			Foreign key to table OKL_TXL_AP_INV_LNS_B
STY_ID	NUMBER			Foreign key to table OKL_STRM_TYPE_B
CLL_ID	NUMBER			Foreign key to table OKL_CNTR_LVLNG_LNS_B
ACN_ID_COST	NUMBER			Foreign Key to table OKL_ASSET_CNDTN_LNS_B
TIL_ID_REVERSES	NUMBER			Foreign Key to table OKL_TXL_AR_INV_LNS_B
LINE_NUMBER	NUMBER			Line number
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
AMOUNT	NUMBER	(14)		Amount
QUANTITY	NUMBER			Number of units shipped
RECEIVABLES_INVOICE_ID	NUMBER			Surrogate key used for primary unique identifiers
LATE_CHARGE_REC_ID	NUMBER			Late Charge Record ID
AMOUNT_APPLIED	NUMBER	(14)		monetary amount
DATE_BILL_PERIOD_START	DATE			Start date for bill period
DATE_BILL_PERIOD_END	DATE			End date for bill period
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
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
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
INVENTORY_ORG_ID	NUMBER			Inventory item org id
INVENTORY_ITEM_ID	NUMBER			Inventory Item identifier
QTE_LINE_ID	NUMBER			Quote line identifier
TXS_TRX_ID	NUMBER			Transaction identifier
BANK_ACCT_ID	NUMBER			Bank account identifier
TXL_AR_LINE_NUMBER	NUMBER			Parent key to identify the children records of OKL internal billing details (OKL_TXD_AR_LN_DTLS_B) within the same OKL internal billing header (OKL_TRX_AR_INVOICES_B).
TXS_TRX_LINE_ID	NUMBER			Foreign key of OKL_TAX_SOURCES.trx_line_id
UPGRADE_FROM_TWO_LEVEL_YN	VARCHAR2	(1)		Upgrade from two level Yes/No flag
TAX_LINE_ID	NUMBER			ID of zx_lines table

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      INV_RECEIV_LINE_CODE
,      TAI_ID
,      KLE_ID
,      ISL_ID
,      IBT_ID
,      TPL_ID
,      STY_ID
,      CLL_ID
,      ACN_ID_COST
,      TIL_ID_REVERSES
,      LINE_NUMBER
,      OBJECT_VERSION_NUMBER
,      AMOUNT
,      QUANTITY
,      RECEIVABLES_INVOICE_ID
,      LATE_CHARGE_REC_ID
,      AMOUNT_APPLIED
,      DATE_BILL_PERIOD_START
,      DATE_BILL_PERIOD_END
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INVENTORY_ORG_ID
,      INVENTORY_ITEM_ID
,      QTE_LINE_ID
,      TXS_TRX_ID
,      BANK_ACCT_ID
,      TXL_AR_LINE_NUMBER
,      TXS_TRX_LINE_ID
,      UPGRADE_FROM_TWO_LEVEL_YN
,      TAX_LINE_ID
FROM OKL.OKL_TXL_AR_INV_LNS_B;

Dependencies

[top of page]

OKL.OKL_TXL_AR_INV_LNS_B does not reference any database object

OKL.OKL_TXL_AR_INV_LNS_B is referenced by following:

APPS: OKL_TXL_AR_INV_LNS_B