SAC_ERP_SS_STS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	AUC_ID	Character(10)	VARCHAR2(10) NOT NULL	Event ID
3	AUC_ROUND	Number(5,0)	INTEGER NOT NULL	Event Round
4	AUC_VERSION	Number(5,0)	INTEGER NOT NULL	Event Version
5	BIDNUM	Signed Number(6,0)	DECIMAL(5) NOT NULL	Bid ID
6	BIDDER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Bidder Setid
7	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
8	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
9	BIDDER_LOC	Character(10)	VARCHAR2(10) NOT NULL	Bidder Location
10	AUC_AWARD_NBR	Number(3,0)	SMALLINT NOT NULL	Award Number
11	AUC_AWARD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Award Type C=PO Contract E=Procurement Contract G=General Contract P=Purchase Order S=Single Release PO Contract V=Recurring Voucher Contract Default Value: P
12	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
13	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
14	EXTERNAL_PO_ID	Character(55)	VARCHAR2(55) NOT NULL	External System PO ID
15	EXTERNAL_PO_DATE	Date(10)	DATE	External PO Date
16	SAC_SYNC_STS	Character(1)	VARCHAR2(1) NOT NULL	Sync Sts flag C=Change N=New U=Update
17	SAC_INTG_PO_STS	Character(1)	VARCHAR2(1) NOT NULL	PO sts C=Change E=Error N=New P=Published R=Rejected S=Synched U=Update
18	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
19	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	SYNC_STS_DESCR	Long Character(32700)	CLOB	More Information