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: FV_OPAC_BILLDATA_V

Product:	FV - Federal Financials
Description:	FV_OPAC_BILLDATA_V is the main view used by the OPAC process to generate invoices.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT OB.CUSTOMER_TRX_ID
, OB.CUSTOMER_ID
, OB.PO_NUMBER
, OB.CONTRACT_NO
, OB.CLIN
, OB.BATCH_NO
, OB.SET_OF_BOOKS_ID
, RAC.TAX_REFERENCE
, RAC.CUSTOMER_NAME
, OB.PROCESSED_FLAG
, OB.ORG_ID
, RACTRX.TRX_DATE
, RACTRX.TRX_NUMBER
, RACTRXL.EXTENDED_AMOUNT
, RACTRXL.QUANTITY_INVOICED
, RACTRXL.UNIT_SELLING_PRICE
, RACTRXL.UOM_CODE
, RACTRXGL.CODE_COMBINATION_ID
, RACTRXL.DESCRIPTION
FROM FV_OPAC_BILLING OB
, RA_CUSTOMERS RAC
, RA_CUSTOMER_TRX RACTRX
, RA_CUSTOMER_TRX_LINES RACTRXL
, RA_CUST_TRX_LINE_GL_DIST RACTRXGL
, GL_CODE_COMBINATIONS GL
WHERE OB.CUSTOMER_TRX_ID = RACTRX.CUSTOMER_TRX_ID
AND RACTRXL.EXTENDED_AMOUNT > 0
AND RACTRX.BILL_TO_CUSTOMER_ID = RAC.CUSTOMER_ID
AND RACTRX.CUSTOMER_TRX_ID = RACTRXL.CUSTOMER_TRX_ID
AND RACTRXL.CUSTOMER_TRX_LINE_ID = RACTRXGL.CUSTOMER_TRX_LINE_ID
AND OB.SET_OF_BOOKS_ID = RACTRX.SET_OF_BOOKS_ID
AND RACTRX.SET_OF_BOOKS_ID = RACTRXL.SET_OF_BOOKS_ID
AND RACTRXL.SET_OF_BOOKS_ID = RACTRXGL.SET_OF_BOOKS_ID
AND RACTRX.COMPLETE_FLAG = 'Y'
AND RACTRXGL.CODE_COMBINATION_ID = GL.CODE_COMBINATION_ID

Columns

Name
CUSTOMER_TRX_ID
CUSTOMER_ID
PO_NUMBER
CONTRACT_NO
CLIN
BATCH_NO
SET_OF_BOOKS_ID
TAX_REFERENCE
CUSTOMER_NAME
PROCESSED_FLAG
ORG_ID
TRX_DATE
TRX_NUMBER
EXTENDED_AMOUNT
QUANTITY_INVOICED
UNIT_SELLING_PRICE
UOM_CODE
CODE_COMBINATION_ID
DESCRIPTION