[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_TXD_AR_LN_DTLS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| FND Design Data: |  OKL.OKL_TXD_AR_LN_DTLS_B
|
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKL_TXD_AR_LN_DTLS_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ID
|
| TLD_BCH_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BCH_ID
|
| TLD_BCL_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BCL_ID
|
| TLD_BGH_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BGH_ID
|
| TLD_BSL_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BSL_ID
|
| TLD_IDX_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
IDX_ID
|
| TLD_KHR_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
KHR_ID
KLE_ID
|
| TLD_SEL_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SEL_ID
|
| TLD_STY_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STY_ID
|
| TLD_TIL_DETAILS_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TIL_ID_DETAILS
|
| TLD_TLD_REVERSES_FK_I | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TLD_ID_REVERSES
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | Primary key column | |
| BCH_ID | NUMBER | Foreign key to table OKL_BILLING_CHARGES_B | ||
| BCL_ID | NUMBER | Foreign Key to table OKS_BILL_CONT_LINES | ||
| BSL_ID | NUMBER | Foreign Key to table OKS_BILL_SUB_LINES | ||
| BGH_ID | NUMBER | Foreign key to table OKL_BLLNG_CHRG_HDRS_B | ||
| IDX_ID | NUMBER | Foreign key to table OKL_INDICES | ||
| SEL_ID | NUMBER | Foreign key to table OKL_STRM_ELEMENTS | ||
| STY_ID | NUMBER | Foreign key to table OKL_STRM_TYPE_B | ||
| TIL_ID_DETAILS | NUMBER | Foreign Key to table OKL_TXL_AR_INV_LNS_B | ||
| TLD_ID_REVERSES | NUMBER | Foreign Key to table OKL_TXD_AR_LN_DTLS_B | ||
| LINE_DETAIL_NUMBER | NUMBER | Line number | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| LATE_CHARGE_YN | VARCHAR2 | (3) | Yes or No | |
| DATE_CALCULATION | DATE | Date of charge application | ||
| FIXED_RATE_YN | VARCHAR2 | (3) | Yes or No | |
| AMOUNT | NUMBER | (14) | Amount | |
| RECEIVABLES_INVOICE_ID | NUMBER | Surrogate key used for primary unique identifiers | ||
| AMOUNT_APPLIED | NUMBER | (14) | Monetary amount | |
| 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 | ||
| 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 ID
, BCH_ID
, BCL_ID
, BSL_ID
, BGH_ID
, IDX_ID
, SEL_ID
, STY_ID
, TIL_ID_DETAILS
, TLD_ID_REVERSES
, LINE_DETAIL_NUMBER
, OBJECT_VERSION_NUMBER
, LATE_CHARGE_YN
, DATE_CALCULATION
, FIXED_RATE_YN
, AMOUNT
, RECEIVABLES_INVOICE_ID
, 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
, INVENTORY_ORG_ID
, INVENTORY_ITEM_ID
, 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 OKL.OKL_TXD_AR_LN_DTLS_B;
OKL.OKL_TXD_AR_LN_DTLS_B does not reference any database object
OKL.OKL_TXD_AR_LN_DTLS_B is referenced by following:
OKL
OKL_TXD_AR_LN_DTLS_B#
|
|
|
|