PO_SSSUPPCO_WS1

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DUE_DATE Date(10) DATE Delivery Due Date from PO

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 PLANNED_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Planned Quantity

4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

5 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved
Y/N Table Edit

6 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process

7 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	PLANNED_QUANTITY	Number(16,4)	DECIMAL(15,4) NOT NULL	Planned Quantity
4	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
5	APPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approved by Auditor D=Denied N=Not Approved Y=Approved Y/N Table Edit
6	PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Plan Processed Flag C=Complete E=Errors N=Initialize P=In Process
7	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor