PO_COLL_SCH_DET(SQL Table) |
Index Back |
---|---|
PO Supplier Collab Details04/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 |