BUYER_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: PO_OPRDEFN_VW
2	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active Default Value: Y
3	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 Default Value: O
4	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
5	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIP_SHIPSET_VW
6	SUBSTITUTE_BUYER	Character(30)	VARCHAR2(30) NOT NULL	Substitute Buyer Prompt Table: BUYER_SUBS_VW
7	LOCATION_SETID	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOC_LOCSET_VW
9	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
10	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
11	ORIGIN_PO_SETID	Character(5)	VARCHAR2(5) NOT NULL	PO Origin Setid Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
12	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORGN_ORGNSET_VW
13	DEPTID_SETID	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
14	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_DEPTSET_VW
15	OVERRIDE_SUGG_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Override Suggested Vendor Y/N Table Edit Default Value: Y
16	CC_SECURITY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Procurement Card Number
17	CC_USE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Procurement Card Y/N Table Edit Default Value: N
18	PO_IMAGE_SIG_PATH	Character(100)	VARCHAR2(100) NOT NULL	PO Dispatch Signature Location