[Home] [Help]
View: BIC_INVLINE_DETAIL_V
| Product: | BIC - Customer Intelligence (obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CT.BILL_TO_CUSTOMER_ID CUSTOMER_ID
, CT.TRX_NUMBER INVOICE_NUMBER
, CTL.DESCRIPTION ITEM
, CTL.QUANTITY_ORDERED ORDERED
, CTL.DESCRIPTION DESCRIPTION
, CTL.QUANTITY_ORDERED QUANTITY_ORDERED
, CTL.QUANTITY_CREDITED QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED QUANTITY_INVOICED
, CTL.TAX_RATE TAX_RATE
, CTL.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, CTL.EXTENDED_AMOUNT EXTENDED_AMOUNT
FROM BIC_PARTIES_V PARTY
, RA_CUSTOMER_TRX_ALL CT
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUST_TRX_TYPES CTT
WHERE PARTY.CUST_ACCOUNT_ID = CT.BILL_TO_CUSTOMER_ID
AND CT.CUSTOMER_TRX_ID = CTL.CUSTOMER_TRX_ID WITH READ ONLY
Columns
| Name |
| CUSTOMER_ID |
| INVOICE_NUMBER |
| ITEM |
| ORDERED |
| DESCRIPTION |
| QUANTITY_ORDERED |
| QUANTITY_CREDITED |
| QUANTITY_INVOICED |
| TAX_RATE |
| UNIT_SELLING_PRICE |
| EXTENDED_AMOUNT |