HDG_POO_PROMPT

(SQL View)
Index Back

Prompt record for Purchasing

Purchase Orders as a Hedged Item in a FAS133 hedge.

SELECT BUSINESS_UNIT ,PO_ID ,PO_DT ,PO_REF ,VENDOR_ID FROM PS_PO_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Default Value: NEXT

3 PO_DT Date(10) DATE NOT NULL Date

Default Value: %date

4 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW