FO_PO_HDR (SQL Table)	Index Back
PBM PO Header PO Header

FO_PO_HDR

(SQL Table)

PBM PO Header

PO Header

Related Language Record: FO_PO_HDR_LANG

# 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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: FO_CUST_BI_VW2

4 START_DT Date(10) DATE NOT NULL Start Date

5 END_DATE Date(10) DATE NOT NULL End Date

6 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

7 CA_PO_STATUS Character(1) VARCHAR2(1) NOT NULL PO Status
A=Active
H=Exhausted
N=New
P=Expired
Default Value: N

8 REMAINING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount

9 COMMITTED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Committed Assets

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: CNTCT_CUST_VW2

13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
Prompt Table: FO_CNTCT_PHN_VW

14 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

15 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: FO_CUST_BI_VW2
4	START_DT	Date(10)	DATE NOT NULL	Start Date
5	END_DATE	Date(10)	DATE NOT NULL	End Date
6	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
7	CA_PO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Status A=Active H=Exhausted N=New P=Expired Default Value: N
8	REMAINING_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remaining Amount
9	COMMITTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Committed Assets
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: CNTCT_CUST_VW2
13	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone Prompt Table: FO_CNTCT_PHN_VW
14	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
15	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance