PO_SSCOLLGRP_VW

(SQL View)
 Index Back

PO Supplier Collab Grp Dtl

04/01/01 CEL CN#WV802-1.0: Supplier Collaboration

SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , ' ' , A.ITM_SETID , ' ' , A.SCHED_GROUP_CD , ' ' , A.UNIT_MEASURE_STD , ' ' , ' ' , A.COLLAB_SCH_STATUS , A.DATETIME_COLLAB , A.DATETIME_DISPATCH , A.DATETIME_CREATE , A.SCHEDULE_START_DT , A.SCHEDULE_END_DT , ' ' , B.DATETIME_APPLY , B.INCLUDE_PO , B.DAYOFTHEWEEK , C.BUYER_ID FROM PS_PO_COLL_SCH_DET A , PS_PO_COLL_HDR B , PS_ITM_SCH_GRP_TBL C WHERE A.VENDOR_SETID=B.VENDOR_SETID AND A.VENDOR_ID=B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.ITM_SETID=B.ITM_SETID AND A.SCHED_GROUP_CD=B.SCHED_GROUP_CD AND A.DATETIME_CREATE=B.DATETIME_CREATE AND B.PO_WB_TYPE='B' AND A.SCHED_GROUP_CD <> ' ' AND A.VENDOR_SETID = C.SETID AND A.SCHED_GROUP_CD = C.SCHED_GROUP_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: %EDIT_BU_IN

5 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
8 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
9 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
10 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
11 PO_SCHED_PRIORITY Character(2) VARCHAR2(2) NOT NULL Schedule Priority
10=High
20=Medium
30=Low
12 COLLAB_SCH_STATUS Character(2) VARCHAR2(2) NOT NULL 02/2001 cel WV-802-1.0 - Status of the supplier schedule
01=New
10=Current
20=Dispatched
30=Supplier Approved
40=Previous
50=History
13 DATETIME_COLLAB DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
14 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
15 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
16 SCHEDULE_START_DT Date(10) DATE 02/2001 cel WV-802-1.0
17 SCHEDULE_END_DT Date(10) DATE 02/2001 cel WV-802-1.0
18 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
19 DATETIME_APPLY DateTime(26) TIMESTAMP 08/27/01 SCC CN#WV840-1.0: Supplier Collaboration - New Field
20 INCLUDE_PO Character(1) VARCHAR2(1) NOT NULL Include PO Data
N=No
Y=Yes
21 DAYOFTHEWEEK Character(2) VARCHAR2(2) NOT NULL Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
22 BUYER_ID_SEL Character(30) VARCHAR2(30) NOT NULL Buyer