[Home] [Help] [Dependency Information]
Object Name: | OKS_BILL_TXN_LINES |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_BILL_TXN_LINES |
Subobject Name: | |
Status: | VALID |
This stores the billing transaction details like bill instance number, invoice number, invoice date, invoice amount and tax amount. The table is populated from 'Service Contracts Main Billing', 'Service Contracts Usage Averaging' and 'Service Contracts Usage Settlement' concurrent programs.
The transaction number, transaction line tax amount, transaction amount and transaction class columns are updated from 'Service Contracts Fetch Receivables Info For Billing' concurrent program after completion of Auto Invoice import program.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_BILL_TXN_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKS_BILL_TXN_LINES_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BSL_ID
BCL_ID |
OKS_BILL_TXN_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BTN_ID |
OKS_BILL_TXN_LINES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BCL_ID |
OKS_BILL_TXN_LINES_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BILL_INSTANCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column. | |
BTN_ID | NUMBER | Yes | ID of the transaction parent record. References OKS_BILL_TRANSACTIONS.ID | |
BSL_ID | NUMBER | ID of the contract sub line billing transaction record. References OKS_BILL_SUB_LINES.ID. It will be populated only for detail transactions. | ||
BCL_ID | NUMBER | ID of the contract line billing transaction record. References OKS_BILL_CONT_LINES.ID | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
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 | |
BILL_INSTANCE_NUMBER | NUMBER | (30) | Yes | Unique Identifier generated by sequence. The value is sent in Oracle Receivables interface table. It is used to map billing history records with its corresponding invoice records in Oracle Receivables |
TRX_LINE_AMOUNT | VARCHAR2 | (240) | Obsolete | |
TRX_LINE_TAX_AMOUNT | NUMBER | Stores the Invoice line tax amount received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Flex field attribute category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Flex field attribute value column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Flex field attribute value column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
TRX_DATE | DATE | Stores the Invoice date received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_ALL.TRX_DATE. | ||
TRX_NUMBER | VARCHAR2 | (60) | Stores the Invoice Number received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_ALL.TRX_NUMBER. | |
TRX_CLASS | VARCHAR2 | (60) | Stores the Invoice class. Valid values for this column are INV - Invoice, CM - Credit Memo. It is updated by fetch program from RA_CUST_TRX_TYPES_ALL.TYPE. | |
MANUAL_CREDIT | NUMBER | Obsolete | ||
TRX_AMOUNT | NUMBER | Stores the Invoice amount received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT. | ||
SPLIT_FLAG | VARCHAR2 | (1) | ||
CYCLE_REFRENCE | VARCHAR2 | (120) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, BTN_ID
, BSL_ID
, BCL_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, BILL_INSTANCE_NUMBER
, TRX_LINE_AMOUNT
, TRX_LINE_TAX_AMOUNT
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, TRX_DATE
, TRX_NUMBER
, TRX_CLASS
, MANUAL_CREDIT
, TRX_AMOUNT
, SPLIT_FLAG
, CYCLE_REFRENCE
FROM OKS.OKS_BILL_TXN_LINES;
OKS.OKS_BILL_TXN_LINES does not reference any database object
OKS.OKS_BILL_TXN_LINES is referenced by following:
|
|
|