PO_SSCOLLSCH2VW(SQL View) |
Index Back |
---|---|
PO Supplier Collab Details04/01/01 CEL CN#WV802-1.0: Supplier Collaboration |
SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUSINESS_UNIT_IN , A.ITM_SETID , A.INV_ITEM_ID , A.SCHED_GROUP_CD , A.CATEGORY_CD , A.UNIT_MEASURE_STD , B.ITM_ID_VNDR , A.PO_SCHED_PRIORITY , A.COLLAB_SCH_STATUS , A.DATETIME_COLLAB , A.DATETIME_DISPATCH , A.DATETIME_CREATE , A.SCHEDULE_START_DT , A.SCHEDULE_END_DT , A.UNIT_MEASURE_VNDR , A.DATETIME_APPLY , A.INCLUDE_PO , A.DAYOFTHEWEEK , A.BUYER_ID_SEL FROM PS_PO_SSCOLLSCH_VW A , PS_ITM_VENDOR B WHERE A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.ITM_SETID = B.SETID AND B.ITM_ID_VNDR <> ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location | |
4 | Character(5) | VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table: %EDIT_BU_IN |
|
5 | Character(5) | VARCHAR2(5) NOT NULL | Item SetID | |
6 | Character(18) | VARCHAR2(18) NOT NULL | Item ID | |
7 | 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 | 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 |