VRBT_DISPATCH

(SQL Table)
Index Back

Rebate Dispatched Information

Rebate Dispatched Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
5 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 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
8 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 FAX_SERVER_DIR Character(80) VARCHAR2(80) NOT NULL Fax Server Directory
11 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
12 EMAIL_SERVER_DIR Character(80) VARCHAR2(80) NOT NULL E-Mail Server Directory
13 PATHNAME Character(254) VARCHAR2(254) NOT NULL PATHNAME