BUSINESS_UNITDefault Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV
Prompt Table: SP_BU_PM_NONVW
RECEIVER_IDN=No
Y=Yes
A=Amount
Q=Quantity
MIN_DELIVERY_VW(SQL View) |
Index Back |
|---|---|
MIN_DELIVERY_VWCreated to increase and improve performance. |
| SELECT HDR.BUSINESS_UNIT , HDR.RECEIVER_ID , SHP.RECV_LN_NBR , PRO.PRO_NUMBER , SHP.RECV_SHIP_SEQ_NBR , HDR.RECEIPT_DT , DST.DISTRIB_LINE_NUM , DST.ATTN_TO , SHP.BUSINESS_UNIT_PO , SHP.CONFIG_CODE , '' , SHP.DESCR254_MIXED , SHP.DUE_DT , SHP.AMT_ONLY_FLG , SHP.DISTRIB_MTHD_FLG , SHP.INV_ITEM_ID , SHP.ITM_ID_VNDR , SHP.MFG_ID , SHP.MFG_ITM_ID , SHP.PO_ID , SHP.QTY_SH_ACCPT_VUOM , SHP.RECEIPT_UM , SHP.RECV_STOCK_UOM , SHP.SHIPTO_ID , DST.DELIVERED_DT , DST.DELIVERED_TM , DST.DELIVERED_FLG , DST.DELIVERED_TO , DST.DELIVERED_OPRID , DST.DELIVERY_FEEDBACK , DST.LOCATION , DST.QTY_DS_ACCPT_VUOM , DST.DELIVERY_CART_ID , CASE WHEN REQ.REQUESTOR_ID IS NOT NULL AND REQ.REQUESTOR_ID <> ' ' THEN REQ.REQUESTOR_ID ELSE CASE WHEN PO.BUYER_ID IS NOT NULL AND PO.BUYER_ID <> ' ' THEN PO.BUYER_ID ELSE '' END END , '' , '' , '' , '' FROM %Table(RECV_HDR) HDR , %Table(RECV_LN_SHIP) SHP LEFT OUTER JOIN %Table(RECV_LN_PRO) PRO ON %Join(COMMON_KEYS, RECV_LN_SHIP SHP, RECV_LN_PRO PRO) , %Table(RECV_LN_DISTRIB) DST LEFT OUTER JOIN %Table(REQ_HDR) REQ ON DST.BUSINESS_UNIT_PO = REQ.BUSINESS_UNIT AND DST.REQ_ID = REQ.REQ_ID , %Table(RECV_LN_DISTRIB) DS2 LEFT OUTER JOIN %Table(PO_HDR) PO ON DS2.BUSINESS_UNIT_PO = PO.BUSINESS_UNIT AND DS2.PO_ID = PO.PO_ID , PS_VENDOR VND WHERE %Join(COMMON_KEYS, RECV_HDR HDR, RECV_LN_SHIP SHP) AND %Join(COMMON_KEYS, RECV_LN_SHIP SHP, RECV_LN_DISTRIB DST) AND %Join(COMMON_KEYS, RECV_LN_DISTRIB DST, RECV_LN_DISTRIB DS2) AND HDR.RECV_STATUS NOT IN ('C', 'X') AND HDR.VENDOR_SETID = VND.SETID AND HDR.VENDOR_ID = VND.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV Prompt Table: SP_BU_PM_NONVW |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 4 | PRO_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Pro Number |
| 5 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 6 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 7 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 8 | ATTN_TO | Character(30) | VARCHAR2(30) NOT NULL | Attention |
| 9 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 10 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 11 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 12 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 13 | 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. |
| 14 | AMT_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes |
| 15 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 16 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 17 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 18 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 19 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 20 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 21 | QTY_SH_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accept QTY in Supplier UOM |
| 22 | RECEIPT_UM | Character(3) | VARCHAR2(3) NOT NULL | Receiving UOM |
| 23 | RECV_STOCK_UOM | Character(3) | VARCHAR2(3) NOT NULL | Stock UOM |
| 24 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 25 | DELIVERED_DT | Date(10) | DATE | Delivered Date |
| 26 | DELIVERED_TM | Time(15) | TIMESTAMP | Delivered Time |
| 27 | DELIVERED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Delivered Flag |
| 28 | DELIVERED_TO | Character(30) | VARCHAR2(30) NOT NULL | Delivered To |
| 29 | DELIVERED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Deliverer |
| 30 | DELIVERY_FEEDBACK | Character(240) | VARCHAR2(240) NOT NULL | Delivery Feedback |
| 31 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 32 | QTY_DS_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Distributed Qty in Supp UOM |
| 33 | DELIVERY_CART_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 34 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 35 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 36 | BUILDING | Character(10) | VARCHAR2(10) NOT NULL | Building # |
| 37 | FLOOR | Character(10) | VARCHAR2(10) NOT NULL | Floor # |
| 38 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |