PO_HDR_A

(SQL Table)
Index Back

PO Activity Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 DUE_DT Date(10) DATE NOT NULL Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
5 ENTERED_DT Date(10) DATE Entered on
6 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
7 SIGNED_OFF Character(1) VARCHAR2(1) NOT NULL Signed Off

Y/N Table Edit

Default Value: N

8 SIGNED_DT Date(10) DATE Signed Date
9 OPRID_SIGNED_BY Character(30) VARCHAR2(30) NOT NULL Signed By
10 COMMENTS_LONG Long Character CLOB NOT NULL Comment Text