S360_VND_AUC_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT c.setid ,b.bidder_id , a.business_unit ,a.auc_status ,a.auc_dttm_start , a.auc_dttm_finish , a.auc_id ,a.auc_type , a.auc_name , a.auc_format ,a.auc_round ,a.auc_version ,'SSE' FROM PS_AUC_HDR a ,PS_AUC_DISP_HDR b ,PS_VENDOR c WHERE a.auc_id=b.auc_id AND b.bidder_id=c.vendor_id AND b.BIDDER_TYPE='V' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | STATUS_FIELD | Character(30) | VARCHAR2(30) NOT NULL | Payment Status |
| 5 | AUC_DTTM_START | DateTime(26) | TIMESTAMP | Date Time Start |
| 6 | AUC_DTTM_FINISH | DateTime(26) | TIMESTAMP | Date Time Finish |
| 7 | PRCR_DOC_ID | Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 8 | AUC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
E=Auction S=RFx |
| 9 | AUC_NAME | Character(50) | VARCHAR2(50) NOT NULL | Event Name |
| 10 | AUC_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Event Format
F=Sell I=RFI R=Buy S=Service |
| 11 | AUC_ROUND | Number(5,0) | INTEGER NOT NULL | Event Round |
| 12 | AUC_VERSION | Number(5,0) | INTEGER NOT NULL | Event Version |
| 13 | PRCR_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Document Type
CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order |