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

TABLE: OKS.OKS_BILL_TRANSACTIONS

Object Details
Object Name: OKS_BILL_TRANSACTIONS
Object Type: TABLE
Owner: OKS
FND Design Data: TableOKS.OKS_BILL_TRANSACTIONS
Subobject Name:
Status: VALID


This table stores the billing transaction information like 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 date, transaction amount (tax + billed amount) and transaction class columns are updated by 'Service Contracts Fetch Receivables Info For Billing' concurrent program after completion of Auto Invoice import program.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKS_BILL_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
OKS_BILL_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_NUMBER
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column.
CURRENCY_CODE VARCHAR2 (45) Yes Currency code of the contract. References OKC_K_HEADERS_B.CURRENCY_CODE.
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
TRX_DATE DATE

Invoice date received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_ALL.TRX_DATE.
TRX_NUMBER VARCHAR2 (60)
Invoice number received from Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_ALL.TRX_NUMBER.
TRX_AMOUNT NUMBER

Invoice amount, which includes tax added by Oracle Receivables. It is updated by fetch program from RA_CUSTOMER_TRX_LINES_ALL.EXTENDED_AMOUNT
TRX_CLASS VARCHAR2 (60)
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.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT ID
,      CURRENCY_CODE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      TRX_DATE
,      TRX_NUMBER
,      TRX_AMOUNT
,      TRX_CLASS
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM OKS.OKS_BILL_TRANSACTIONS;

Dependencies

[top of page]

OKS.OKS_BILL_TRANSACTIONS does not reference any database object

OKS.OKS_BILL_TRANSACTIONS is referenced by following:

SchemaAPPS
SynonymOKS_BILL_TRANSACTIONS