FO_PO_HDR_VW2

(SQL View)
Index Back

PBM PO Header

PO Header

SELECT CUST_ID , BUSINESS_UNIT , CA_PO_ID , PO_AMT1 , DESCR , CA_PO_STATUS , REMAINING_AMOUNT FROM PS_FO_PO_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

3 CA_PO_ID Character(10) VARCHAR2(10) NOT NULL Internal PO ID
4 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
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 CA_PO_STATUS Character(1) VARCHAR2(1) NOT NULL PO Status
A=Active
H=Exhausted
N=New
P=Expired

Default Value: N

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