RECV_HDR_ACT

(SQL Table)
Index Back

Receiver Activity Header

Receiver Activity Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
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 ENTERED_DT Date(10) DATE Entered on

Default Value: %date

5 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
6 SIGNED_OFF Character(1) VARCHAR2(1) NOT NULL Signed Off

Y/N Table Edit

Default Value: N

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