EXD_VND_INV_IUT

(SQL View)
 Index Back

IUT Receipt view - Excise Inv


SELECT L.BUSINESS_UNIT , L.RECEIVER_ID , L.RECV_LN_NBR , L.BUSINESS_UNIT_IN , H.BILL_OF_LADING , B.BASE_CURRENCY , B.BASE_CURRENCY , I.DESCR , L.INV_ITEM_ID , T.SETID , %Round(%DecMult(E.NET_UNIT_PRICE, E.QTY_EXD), 2) , %Round(%DecMult(E.NET_UNIT_PRICE, E.QTY_EXD), 2) , L.PACKSLIP_NO , %Round(%DecDiv(%DecMult(E.NET_UNIT_PRICE, E.QTY_EXD), L.QTY_STD), 4) , %Round(%DecDiv(%DecMult(E.NET_UNIT_PRICE, E.QTY_EXD), L.QTY_STD), 4) , L.QTY_STD , L.QTY_INV_RECV , L.UNIT_OF_MEASURE , L.UNIT_MEASURE_STD , L.SOURCE_BUS_UNIT , L.INTERUNIT_ID , L.INTERUNIT_LINE , S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO FROM PS_INV_RECV_LN L , PS_INV_RECV_HDR H , PS_BUS_UNIT_TBL_IN B , PS_MASTER_ITEM_TBL I , PS_IN_DEMAND S , PS_EXD_SHP_INV_LN E , PS_EXD_SHP_INV_HDR EH , PS_SET_CNTRL_REC T WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.RECEIVER_ID = H.RECEIVER_ID AND L.SOURCE_BUS_UNIT = B.BUSINESS_UNIT AND L.BUSINESS_UNIT = T.SETCNTRLVALUE AND T.RECNAME = 'MASTER_ITEM_TBL' AND T.SETID = I.SETID AND L.INV_ITEM_ID = I.INV_ITEM_ID AND S.DESTIN_BU = L.BUSINESS_UNIT_IN AND S.SOURCE_BUS_UNIT = L.SOURCE_BUS_UNIT AND S.INTERUNIT_ID = L.INTERUNIT_ID AND S.INTERUNIT_LINE = L.INTERUNIT_LINE AND S.BUSINESS_UNIT = E.BUSINESS_UNIT AND S.ORDER_NO = E.ORDER_NO AND S.ORDER_INT_LINE_NO = E.ORDER_INT_LINE_NO AND E.BUSINESS_UNIT = EH.BUSINESS_UNIT AND E.EXD_DOC_NBR_SER = EH.EXD_DOC_NBR_SER AND E.EXD_INVOICE_NO = EH.EXD_INVOICE_NO AND EH.EXD_INV_STATUS IN ('P', 'R') AND NOT EXISTS ( SELECT 'X' FROM PS_EXD_VND_INV_LN IV WHERE L.BUSINESS_UNIT = IV.BUSINESS_UNIT_RECV AND L.RECEIVER_ID = IV.RECEIVER_ID AND L.RECV_LN_NBR = IV.RECV_LN_NBR AND L.BUSINESS_UNIT_IN =IV.BUSINESS_UNIT_IN )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
5 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

10 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
11 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
12 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
13 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
14 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
15 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
16 QTY_SH_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Accepted Quantity
17 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
18 RECEIPT_UM Character(3) VARCHAR2(3) NOT NULL Receiving UOM

Default Value: EA

Prompt Table: UNITS_TBL

19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
21 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
22 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
23 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
24 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
25 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line