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 |