AUC_BFH_HIST_VW(SQL View) |
Index Back |
|---|
| SELECT a.business_unit , a.auc_id , a.auc_round , a.auc_version , b.bid_factor_nbr , a.bidnum , a.bidder_setid , a.bidder_id , a.bidder_type , a.bidder_loc , c.bid_factor_cd , c.bid_factor_type , a.auc_bid_version , a.auc_bid_status , a.resp_dttm_post , a.bid_cntr_action , b.bid_resp_qty , b.bid_resp_dt , b.bid_resp_yn , b.auc_bf_list_line , b.bid_list_item , %DecMult(b.bid_score , 100) , b.comments_254 , c.min_qty , c.min_dt , c.max_qty , c.max_dt , c.ideal_qty , c.ideal_dt , c.ideal_txt , c.ideal_yn , c.weighting , b.bid_resp_txt FROM PS_RESP_HDR a , PS_RESP_HDR_factor b , ps_auc_hdr_factors c WHERE a.business_unit = b.business_unit AND a.auc_id = b.auc_id AND a.auc_round = b.auc_round AND a.auc_version = b.auc_version AND a.bidnum = b.bidnum AND a.bidder_setid = b.bidder_setid AND a.bidder_id = b.bidder_id AND a.bidder_type = b.bidder_type AND a.bidder_loc = b.bidder_loc AND b.business_unit = c.business_unit AND b.auc_id = c.auc_id AND b.auc_round = c.auc_round AND b.auc_version = c.auc_version AND b.bid_factor_nbr = c.bid_factor_nbr AND a.auc_bid_status = 'P' |
| # | 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 | BID_FACTOR_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number |
| 6 | BIDNUM |
Signed Number(6,0) | DECIMAL(5) NOT NULL | Bid ID |
| 7 | BIDDER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 8 | BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 9 | BIDDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 10 | BIDDER_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Bidder Location |
| 11 | BID_FACTOR_CD | Character(18) | VARCHAR2(18) NOT NULL |
Bid Factor Code
Prompt Table: BID_FACTOR_VW |
| 12 | BID_FACTOR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment C=Monetary D=Date L=List N=Numeric S=Separator T=Text Y=Yes/No |
| 13 | AUC_BID_VERSION | Number(5,0) | INTEGER NOT NULL | Event Bid Version |
| 14 | AUC_BID_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Bid Status
D=Disqualified P=Posted S=Saved W=Disallowed X=Cancelled |
| 15 | RESP_DTTM_POST | DateTime(26) | TIMESTAMP | Response Date Time |
| 16 | BID_CNTR_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Bid Counter Action
A=Accept C=Counter W=Withdrawal |
| 17 | BID_RESP_QTY | Number(19,6) | DECIMAL(18,6) NOT NULL | Bid Response Quantity |
| 18 | BID_RESP_DT | Date(10) | DATE | Bid Response Date |
| 19 | BID_RESP_YN | Character(1) | VARCHAR2(1) NOT NULL |
Bid Response Yes/No
N=No Y=Yes |
| 20 | AUC_BF_LIST_LINE | Signed Number(6,0) | DECIMAL(5) NOT NULL | List Line number |
| 21 | BID_LIST_ITEM | Character(60) | VARCHAR2(60) NOT NULL | List Item |
| 22 | BID_SCORE | Number(8,4) | DECIMAL(7,4) NOT NULL | Score |
| 23 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |
| 24 | MIN_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 25 | MIN_DT | Date(10) | DATE | Minimum Date |
| 26 | MAX_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Maximum Quantity |
| 27 | MAX_DT | Date(10) | DATE | Max Date |
| 28 | IDEAL_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Ideal Quantity |
| 29 | IDEAL_DT | Date(10) | DATE | Ideal DateTime |
| 30 | IDEAL_TXT | Character(254) | VARCHAR2(254) NOT NULL | Ideal Text |
| 31 | IDEAL_YN | Character(1) | VARCHAR2(1) NOT NULL |
Ideal Yes/No
Y/N Table Edit |
| 32 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 33 | BID_RESP_TXT | Long Character(2000) | VARCHAR2(2000) | Bid Response Text |