PO_COLL_SCH_DET

(SQL Table)
Index Back

PO Supplier Collab Details

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

Default Value: 1

5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

Default Value: 1

6 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
7 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: ITM_IBU_GRP_VW

8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
9 SEQ_NBR_PARENT Number(15,0) DECIMAL(15) NOT NULL Sequence Number - Parent Item
10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
13 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_SCH_GRP_VW

15 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: CP_CONFIG_VW2

16 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
17 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
18 DUE_DT Date(10) DATE NOT NULL 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.
19 DUE_TIME Time(15) TIMESTAMP Due Time
20 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
21 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
22 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
23 ORDER_SOURCE Character(2) VARCHAR2(2) NOT NULL 02/2001 cel WV-802-1.0
10=Existing Purchase Order
20=Planned Purchase Order
24 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
25 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
26 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

27 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
28 SCHEDULE_START_DT Date(10) DATE 02/2001 cel WV-802-1.0
29 SCHEDULE_END_DT Date(10) DATE 02/2001 cel WV-802-1.0
30 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
31 DATETIME_COLLAB DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
32 DATETIME_MODIFIED DateTime(26) TIMESTAMP Datetime Modified
33 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
34 YES_INDICATOR Number(1,0) SMALLINT NOT NULL Yes Indicator for PO Lookup
35 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
36 EXIST_PO Number(1,0) SMALLINT NOT NULL 02/20/01 SCC CN#WV802-1.0: New Field
37 EXIST_PP Number(1,0) SMALLINT NOT NULL 02/20/01 SCC CN#WV802-1.0: New Field
38 RESCHEDULE Character(1) VARCHAR2(1) NOT NULL 01/13/02 pwf added new label for rescheduling

Default Value: N

39 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
40 CURRENT_QTY Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the build/snapshot current requested qty on the Supplier and Schedulers Schedule Workbench. (in std uom)
41 COLLAB_TEMPQTY Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier pending approval qty on the Supplier Schedule Workbench. (in std uom)
42 CONFIRM_QTY Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier confirmed/approvedl qty on the Supplier and Schedulers Schedule Workbench. (in std uom)
43 UNIT_MEASURE_ORD Character(3) VARCHAR2(3) NOT NULL Ordering UOM
44 CURRENT_QTY_ORD Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the build/snapshot current requested qty on the Supplier and Schedulers Schedule Workbench. (in ordering uom)
45 COLLAB_TEMPQTY_ORD Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier pending approval qty on the Supplier Schedule Workbench. (in the ordering uom)
46 CONFIRM_QTY_ORD Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier confirmed/approvedl qty on the Supplier and Schedulers Schedule Workbench. (in ordering uom)
47 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
48 CURRENT_QTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the build/snapshot current requested qty on the Supplier and Schedulers Schedule Workbench. (in vendor's default uom
49 COLLAB_TEMPQTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier pending approval qty on the Supplier Schedule Workbench. (in vendor's default uom)
50 CONFIRM_QTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the supplier confirmed/approvedl qty on the Supplier and Schedulers Schedule Workbench. (in vendor's default uom)
51 PL_PO_TYPE Character(1) VARCHAR2(1) NOT NULL Purchase Order Type
E=Existing Orders
N=Planned Order