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_TRX_AR_INVOICES_B

Object Details

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

Collection of all OKL transaction which generate Receivables invoices
normal periodic billing of a contract
This entity holds Cure Payment information that have been made by the Vendor on behalf the delinquent Lessee.
This holds the Cure Payment details.
This the details of repurchasing an asset.
Product related fees for performing various services
a miscellaneous manually entered receivable invoice line
Charges applied to delayed customer payments
DEFINITION
A veritable interest charge entity to hold the detail of variable interest charges for transaction
EXAMPLE
MISCELLANEOUS
Defination
This is a place holder for storing the interests calculated on the contract funding amount for the contracts that are still inactive.
Example
Interest on contracts that has prior funding are stored here.
DEFINITION
the transaction to bill for the repair cost of a damaged asset. The associated lines is ASSET REPAIR BILL LINES.
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.
Customer charges associated with termination quote
DEFINITION
The transaction to bill for a repurchase sale.
EXAMPLE
MISCELLANEOUS
DEFINITION
The transaction to bill for a receivable amount in relation to a principal paydown.
EXAMPLE
MISCELLANEOUS
Biling transaction associated with rebooking
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
super type entity for headers of internal contracts transactions
EXAMPLE
MISCELLANEOUS
DEFINITION
The supertype of OKL transactions.
EXAMPLE
MISCELLANEOUS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TRX_AR_INVOICES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_TRX_AR_INVOICES_B_CPY_1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CPY_ID
TAI_CRA_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CRA_ID
TAI_FND_CURRENCIES_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE
TAI_IBT_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IBT_ID
TAI_IPY_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IPY_ID
TAI_IRM_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IRM_ID
TAI_IRT_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IRT_ID
TAI_ISOB_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID
TAI_IXX_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IXX_ID
TAI_KHR_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID
TAI_QTE_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTE_ID
TAI_SVF_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SVF_ID
TAI_TAI_REVERSES_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAI_ID_REVERSES
TAI_TAP_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAP_ID
TAI_TCN_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TCN_ID
TAI_TRX_NUMBER_NU01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_NUMBER
TAI_TRY_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRY_ID
TAI_TSU_FK_I	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
TRX_STATUS_CODE	VARCHAR2	(30)	Yes	Transaction status
CURRENCY_CODE	VARCHAR2	(15)		Currency code
SET_OF_BOOKS_ID	NUMBER			Accounting books defining column
TRY_ID	NUMBER		Yes	Foreign key to table OKL_TRX_TYPES_B
IBT_ID	NUMBER			Foreign Key to view OKX_CUST_SITE_USES_V
IXX_ID	NUMBER			Foreign Key to view OKX_CUSTOMER_ACCOUNTS_V
KHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
IRM_ID	NUMBER			Foreign Key to view OKX_RECEIPT_METHODS_V
IRT_ID	NUMBER			Foreign Key to view OKX_RECEIVABLES_TERMS_V
CRA_ID	NUMBER			Foreign key to table OKL_CURE_REPORT_AMOUNTS
CLG_ID	NUMBER			Foreign key to table OKL_CNTR_LVLNG_GRPS_B
SVF_ID	NUMBER			Foreign key to table OKL_SERVICE_FEES_B
CPY_ID	NUMBER			Foreign key to table OKL_CURE_PAYMENTS_B
TAP_ID	NUMBER			Foreign key to table OKL_TRX_AP_INVOICES_B
QTE_ID	NUMBER			Foreign key to table OKL_TRX_QUOTES_B
TCN_ID	NUMBER			Foreign key to table OKL_TRX_CONTRACTS
IPY_ID	NUMBER			Foreign key to table OKL_INS_POLICIES_B
TAI_ID_REVERSES	NUMBER			Foreign Key to table OKL_TRX_AR_INVOICES_B
TRX_NUMBER	VARCHAR2	(240)		Invoice number if required
DATE_ENTERED	DATE		Yes	Creation date
DATE_INVOICED	DATE		Yes	Date when transaction should be invoiced
AMOUNT	NUMBER	(14)	Yes	Amount
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
AMOUNT_APPLIED	NUMBER	(14)		Amount paid by customer for the invoice
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
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency Conversion Type
CURRENCY_CONVERSION_DATE	DATE			Currency Conversion Date
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
POX_ID	NUMBER			Foreign Key to table OKL_POOL_TRANSACTIONS
SOURCE_TABLE	VARCHAR2	(90)		Source Table Name
LEGAL_ENTITY_ID	NUMBER			Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES
INF_ID	NUMBER			Foreign key of okl_invoice_formats_b.ID
INVOICE_PULL_YN	VARCHAR2	(3)		Foreign key of OKL_CNSLD_AR_HDRS_B.invoice_pull_yn
DUE_DATE	DATE			Foreign key of OKL_CNSLD_AR_HDRS_B.due_date
ISI_ID	NUMBER			Foreign key of RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID
RECEIVABLES_INVOICE_ID	NUMBER			Foreign key of ra_customer_trx_all.trx_number
CUST_TRX_TYPE_ID	NUMBER	(15)		Foreign key of ra_customer_trx_lines_all.cust_trx_type_id
CUSTOMER_BANK_ACCOUNT_ID	NUMBER	(15)		Foreign key of AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID
TAX_EXEMPT_FLAG	VARCHAR2	(1)		Tax exempt flag
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Foreign key: lookup_code of fnd_lookups.lookup_type = 'OKL_TAX_EXEMPT'
REFERENCE_LINE_ID	NUMBER	(15)		For credit memos, to point to original invoice
PRIVATE_LABEL	VARCHAR2	(4000)		Private Label to be displayed on the invoice
CONSOLIDATED_INVOICE_NUMBER	VARCHAR2	(90)		OKL Consolidated bill number
OKL_SOURCE_BILLING_TRX	VARCHAR2	(30)		Source of OKL billing transaction.
INVESTOR_AGREEMENT_NUMBER	VARCHAR2	(120)		Foreign key of okc_k_headers_b.contract_number
INVESTOR_NAME	VARCHAR2	(360)		foreign key of hz_parties.party_name
TRANSACTION_DATE	DATE			Stores the date on which the transaction occurred. Equivalent of the the creation date column and is used in reconciliation reports.

Query Text

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


SELECT ID
,      TRX_STATUS_CODE
,      CURRENCY_CODE
,      SET_OF_BOOKS_ID
,      TRY_ID
,      IBT_ID
,      IXX_ID
,      KHR_ID
,      IRM_ID
,      IRT_ID
,      CRA_ID
,      CLG_ID
,      SVF_ID
,      CPY_ID
,      TAP_ID
,      QTE_ID
,      TCN_ID
,      IPY_ID
,      TAI_ID_REVERSES
,      TRX_NUMBER
,      DATE_ENTERED
,      DATE_INVOICED
,      AMOUNT
,      OBJECT_VERSION_NUMBER
,      AMOUNT_APPLIED
,      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
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      POX_ID
,      SOURCE_TABLE
,      LEGAL_ENTITY_ID
,      INF_ID
,      INVOICE_PULL_YN
,      DUE_DATE
,      ISI_ID
,      RECEIVABLES_INVOICE_ID
,      CUST_TRX_TYPE_ID
,      CUSTOMER_BANK_ACCOUNT_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_REASON_CODE
,      REFERENCE_LINE_ID
,      PRIVATE_LABEL
,      CONSOLIDATED_INVOICE_NUMBER
,      OKL_SOURCE_BILLING_TRX
,      INVESTOR_AGREEMENT_NUMBER
,      INVESTOR_NAME
,      TRANSACTION_DATE
FROM OKL.OKL_TRX_AR_INVOICES_B;

Dependencies

[top of page]

OKL.OKL_TRX_AR_INVOICES_B does not reference any database object

OKL.OKL_TRX_AR_INVOICES_B is referenced by following:

OKL: OKL_TRX_AR_INVOICES_B#