AUC_DISP_EXT_VW

(SQL View)
 Index Back

External Dispatch Header

Dispatch Header

SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , BIDDER_SETID , BIDDER_ID , BIDDER_TYPE , BIDDER_LOC , AUC_DISPATCH_MTHD , AUC_INVITE_ALL , BID_INV_SOURCE , BID_INV_RESPONSE , BID_INV_SEND_EMAIL , AUC_RENOTIFY_FLG , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_AUC_DISP_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
8 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
9 AUC_DISPATCH_MTHD Character(1) VARCHAR2(1) NOT NULL Dispatch Method
E=Email
F=Fax
P=Print
10 AUC_INVITE_ALL Character(1) VARCHAR2(1) NOT NULL Invite to Event

Default Value: Y

11 BID_INV_SOURCE Character(1) VARCHAR2(1) NOT NULL Invitation Source
S=Self Invited
U=Invited by User

Default Value: U

12 BID_INV_RESPONSE Character(1) VARCHAR2(1) NOT NULL Invite Status
A=Accepted
D=Declined
N=---

Default Value: N

13 BID_INV_SEND_EMAIL Character(1) VARCHAR2(1) NOT NULL Receive Updates to Event
N=Don't send updates
Y=Send updates

Default Value: Y

14 AUC_RENOTIFY_FLG Character(1) VARCHAR2(1) NOT NULL Renotify Bidders

Y/N Table Edit

Default Value: Y

15 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
17 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
18 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
19 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
20 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
21 CITY Character(30) VARCHAR2(30) NOT NULL City
22 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
23 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
24 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State
27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
29 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
30 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
31 AUC_EXT_BDRID Character(80) VARCHAR2(80) NOT NULL External System Bidder Id