RMA_BI_LINE_VW(SQL View) |
Index Back |
|---|---|
Invoice Line ViewInvoice Line View |
| SELECT L.BUSINESS_UNIT , L.INVOICE , L.LINE_SEQ_NUM , L.INVOICE_LINE , H.PAYMENT_METHOD , L.QTY , L.UNIT_OF_MEASURE , ID.QTY_SHIPPED , ID.UNIT_MEASURE_SHIP , ID.PARENT_PROD_ID , ID.PRODUCT_ID , ID.QTY_CODE , ID.QTY_PER FROM PS_BI_LINE L JOIN PS_BI_HDR H ON L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.INVOICE = H.INVOICE LEFT OUTER JOIN PS_IN_DEMAND_BI IB ON L.BUSINESS_UNIT = IB.BUSINESS_UNIT_BI AND L.INVOICE = IB.INVOICE AND L.LINE_SEQ_NUM = IB.LINE_SEQ_NUM LEFT OUTER JOIN PS_IN_DEMAND ID ON %Join(COMMON_KEYS, IN_DEMAND_BI IB, IN_DEMAND ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 4 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 5 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 6 | QTY_BILL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity in Billing UOM |
| 7 | UOM_BILL | Character(3) | VARCHAR2(3) NOT NULL | Bill Unit of Measure |
| 8 | QTY_SHIPPED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Shipped |
| 9 | UNIT_MEASURE_SHIP | Character(3) | VARCHAR2(3) NOT NULL | Shipment Unit of Measure |
| 10 | PARENT_PROD_ID | Character(18) | VARCHAR2(18) NOT NULL | Parent Product Id |
| 11 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 12 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 13 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |