FO_PO_HDR_ADDVW

(SQL View)
Index Back

PBM PO Header

PO Header Add View

SELECT BUSINESS_UNIT , CA_PO_ID , CUST_ID , DESCR FROM %Table(FO_PO_HDR)

# 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

Default Value: NEXT

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description