HDG_POO_PROMPT(SQL View) |
Index Back |
---|---|
Prompt record for PurchasingPurchase 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 |