FO_PO_EXTENSION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW
2	CA_PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Internal PO ID
3	EXTENSION_NBR	Signed Number(4,0)	DECIMAL(3) NOT NULL	Extension Number
4	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
5	EXTENSION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Extension Type Xlat Values C=Customer Extension I=Internal Extension Default Value: I
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	CA_PO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Status A=Active H=Exhausted N=New P=Expired Default Value: N
8	PO_AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
9	REMAINING_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remaining Amount
10	COMMITTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Committed Assets
11	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: CNTCT_CUST_VW2
12	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone Prompt Table: FO_CNTCT_PHN_VW
13	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
14	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
15	EXHAUSTION_DATE	Date(10)	DATE	Exhaustion Date
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code