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.

[Home] [Help]

View: OKI_BILL_HIST_V

Product:	OKI - Contracts Intelligence (Obsolete)
Description:	The billing history for service contracts.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SIL.CHR_ID CONTRACT_ID
, SIL.CLE_ID CONTRACT_LINE_ID
, SIL.CONTRACT_NUMBER CONTRACT_NUMBER
, SIL.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, SIL.LINE_NUMBER LINE_NUMBER
, BTN.TRX_DATE INVOICE_DATE
, BTN.TRX_NUMBER INVOICE_NUMBER
, BTN.TRX_AMOUNT INVOICE_AMOUNT
, BTN.CURRENCY_CODE CURRENCY_CODE
, BTN.TRX_CLASS INVOICE_CLASS
, BCL.AMOUNT LINE_AMOUNT
, BCL.DATE_BILLED_FROM DATE_BILLED_FROM
, BCL.DATE_BILLED_TO DATE_BILLED_TO
, BCL.BILL_ACTION
FROM OKI_SOLD_ITM_LINES SIL
, OKS_BILL_CONT_LINES BCL
, OKS_BILL_TRANSACTIONS BTN
WHERE BTN.ID = BCL.BTN_ID
AND BCL.CLE_ID = SIL.CLE_ID

Columns

Name
CONTRACT_ID
CONTRACT_LINE_ID
CONTRACT_NUMBER
CONTRACT_NUMBER_MODIFIER
LINE_NUMBER
INVOICE_DATE
INVOICE_NUMBER
INVOICE_AMOUNT
CURRENCY_CODE
INVOICE_CLASS
LINE_AMOUNT
DATE_BILLED_FROM
DATE_BILLED_TO
BILL_ACTION