PO_DISPATCHED

(SQL Table)
Index Back

PO Dispatched Information

# 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
8 DISP_METHOD Character(3) VARCHAR2(3) NOT NULL Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
9 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 FAX_SERVER_DIR Character(80) VARCHAR2(80) NOT NULL Fax Server Directory
12 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
13 EMAIL_SERVER_DIR Character(80) VARCHAR2(80) NOT NULL E-Mail Server Directory
14 PATHNAME Character(254) VARCHAR2(254) NOT NULL PATHNAME
15 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
16 TO_EMAILIDS Character(254) VARCHAR2(254) NOT NULL To EMAILIDs