PO_AUC_AWARD_VW(SQL View) |
Index Back |
|---|---|
PO Auc Contracts+AwardLn ViewPO : View that joins AUC_AWD_PO_LIST and AWARD_LN to get the corresponding Auction Award Line Info for a give PO.BUSINESS_UNIT PO.CNTRCT_SETID, CNTRCT_ID, CNTRCT_LINE Nbr. |
| SELECT XREF.BUSINESS_UNIT , XREF.AUC_ID , XREF.AUC_ROUND , XREF.AUC_VERSION , XREF. BIDNUM , XREF.BIDDER_SETID , XREF.BIDDER_ID , XREF.BIDDER_TYPE , XREF.BIDDER_LOC , XREF.AUC_AWARD_NBR , XREF.AUC_AWARD_BUSETID , XREF.CNTRCT_ID , LN.AUC_CNTRCT_LN_NBR , LN.PHYSICAL_NATURE , LN.VAT_SVC_PERFRM_FLG FROM PS_AUC_AWD_PO_LST XREF , PS_AUC_AWARD_LN LN WHERE XREF.BUSINESS_UNIT = LN.BUSINESS_UNIT AND XREF.AUC_ID = LN.AUC_ID AND XREF.AUC_ROUND = LN.AUC_ROUND AND XREF.AUC_VERSION = LN.AUC_VERSION AND XREF.BIDNUM = LN.BIDNUM AND XREF.BIDDER_SETID = LN.BIDDER_SETID AND XREF.BIDDER_ID = LN.BIDDER_ID AND XREF.BIDDER_TYPE = LN.BIDDER_TYPE AND XREF.BIDDER_LOC = LN.BIDDER_LOC AND XREF.AUC_AWARD_NBR = LN.AUC_AWARD_NBR |
| # | 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 | BIDNUM |
Signed Number(6,0) | DECIMAL(5) NOT NULL | Bid ID |
| 6 | BIDDER_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 7 | BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 8 | BIDDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |
| 9 | BIDDER_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Bidder Location |
| 10 | AUC_AWARD_NBR |
Number(3,0) | SMALLINT NOT NULL | Award Number |
| 11 | AUC_AWARD_BUSETID |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 12 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 13 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 14 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 15 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |