IN_SDA_PO_VW2(SQL View) |
Index Back |
|---|---|
Sup/Dmd Dbrd: NoPO, not stagedQty received without a purchase order and hasn't been staged to Inventory. (Not used for PAR analytic) |
| SELECT D.BUSINESS_UNIT_IN , D.BUSINESS_UNIT_IN , D.BUSINESS_UNIT_PO , S.INV_ITEM_ID , S.INV_ITEM_ID , S.DUE_DT , S.RECEIPT_DTTM , H.VENDOR_ID , V.NAME1 , D.MERCHANDISE_AMT , D.MERCH_AMT_BSE , D.CURRENCY_CD , D.CURRENCY_CD_BASE , D.QTY_DS_ACCPT_VUOM , D.QTY_DS_ACCPT_SUOM , S.RECEIVER_ID , S.RECV_LN_NBR , S.RECV_SHIP_SEQ_NBR , S.RECV_SHIP_STATUS , M.INV_ITEM_GROUP , M.INV_PROD_FAM_CD , M.UNIT_MEASURE_STD , '40' , '20' , 'R' FROM PS_RECV_LN_DISTRIB D , PS_RECV_LN_SHIP S , PS_VENDOR V , PS_RECV_HDR H , PS_MASTER_ITEM_TBL M , PS_SET_CNTRL_REC C WHERE H.PO_RECEIPT_FLG = 'N' AND V.SETID = H.VENDOR_SETID AND V.VENDOR_ID = H.VENDOR_ID AND S.MOVE_STAT_INV <> 'M' AND S.BUSINESS_UNIT = H.BUSINESS_UNIT AND S.RECEIVER_ID = H.RECEIVER_ID AND D.DST_ACCT_TYPE = 'DST' AND D.BUSINESS_UNIT_IN <> ' ' AND D.BUSINESS_UNIT = S.BUSINESS_UNIT AND D.RECEIVER_ID = S.RECEIVER_ID AND D.RECV_LN_NBR = S.RECV_LN_NBR AND D.RECV_SHIP_SEQ_NBR = S.RECV_SHIP_SEQ_NBR AND M.SETID = C.SETID AND C.SETCNTRLVALUE = S.BUSINESS_UNIT AND C.RECNAME = 'MASTER_ITEM_TBL' AND M.INV_ITEM_ID = S.INV_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 3 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | INV_ITEM_ID_PO | Character(18) | VARCHAR2(18) NOT NULL | Item Number PO |
| 6 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 7 | RECEIPT_DTTM | DateTime(26) | TIMESTAMP | Receipt Datetime |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 11 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 12 | CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 14 | QTY_DS_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Distributed Qty in Supp UOM |
| 15 | QTY_RECV_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Received |
| 16 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 17 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 18 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 19 | RECV_SHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Schedule Status
C=Closed H=Hold O=Open R=Received X=Canceled Default Value: O |
| 20 | INV_ITEM_GROUP2 | Character(15) | VARCHAR2(15) NOT NULL | Item Group |
| 21 | INV_PROD_FAM_CD2 | Character(10) | VARCHAR2(10) NOT NULL | Item Family |
| 22 | UNIT_MEASURE_STD2 | Character(3) | VARCHAR2(3) NOT NULL | Standard UOM |
| 23 | PEG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
07/21/04 EGS: Created
10=Open 20=Completed 30=Canceled 40=Not Pegged |
| 24 | SUPPLY_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Supply Source
10=PO, Not Received 20=No PO, Recvd, Not Staged 30=Staged in Staged_inf_inv 40=Staged in Staged_item_inv IN=Inventory - MSRs PO=Purchase Orders PR=Requisitions |
| 25 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |