[Home] [Help]
View: BIC_INVLINE_V
Product: | BIC - Customer Intelligence (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CTL.CUSTOMER_TRX_ID
, CTL.CUSTOMER_TRX_LINE_ID
, CTL.LINE_NUMBER ITEM
, CTL.QUANTITY_ORDERED QUANTITY_ORDERED
, CTL.QUANTITY_CREDITED QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED QUANTITY_INVOICED
, CTL.UNIT_SELLING_PRICE UNIT_PRICE
, CTL.EXTENDED_AMOUNT EXTENDED_AMOUNT
, CTL.TAX_RATE TAX
, CTL.INTERFACE_LINE_ATTRIBUTE6 ORDER_NUMBER
FROM RA_CUSTOMER_TRX_LINES_ALL CTL
Columns
Name |
CUSTOMER_TRX_ID |
CUSTOMER_TRX_LINE_ID |
ITEM |
QUANTITY_ORDERED |
QUANTITY_CREDITED |
QUANTITY_INVOICED |
UNIT_PRICE |
EXTENDED_AMOUNT |
TAX |
ORDER_NUMBER |