SUP_OB_ADT_TL_V(SQL View) |
Index Back |
|---|---|
Strat Sourcing Bidder HeaderUsed to store Strat Sourcing Bidder Header info |
| SELECT A.SETID , A.BIDDER_ID , A.SUP_OB_REG_ID , A.EFF_STATUS , B.SUP_OB_APR_STATUS , A.REASON_CD , A.EMAIL_FLG , A.EMAILID , A.BID_CONTACT_TYPE , A.AUC_COMPANY_NAME , A.ADDL_COMP_LBL , A.URL , A.MAIN_ADDR_SEQ_NUM , A.BILL_ADDR_SEQ_NUM , A.SHIP_ADDR_SEQ_NUM , A.INV_ADDR_SEQ_NUM , A.CREATEOPRID , A.CREATE_DTTM , A.LASTUPDOPRID , A.LAST_UPDATE_DTTM ,D.VENDOR_SETID ,D.VENDOR_ID , SUPOB_REG_OPT_TYPE ,C.FIRST_NAME %Concat ' ' %Concat C.LAST_NAME FROM PS_SUP_OB_REG_DEF B , PS_AUC_BIDDER_HDR A LEFT OUTER JOIN PS_AUC_CONTACT_HDR C ON a.setid = c.setid AND a.bidder_id = c.bidder_id AND C.PRIMARY_FLG ='Y' LEFT OUTER JOIN PS_AUC_BIDDER_XREF D ON a.setid = D.bidder_setid AND a.bidder_id = D.bidder_id WHERE A.SETID = B.SETID AND A.BIDDER_ID =B.BIDDER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BIDDER_SETID | Character(5) | VARCHAR2(5) NOT NULL | Bidder Setid |
| 2 |  BIDDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 3 | SUP_OB_REG_ID | Character(10) | VARCHAR2(10) NOT NULL | * Registration ID |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | SUP_OB_APR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
0=OFAC Checked A=Approved B=Request Editor More Info.. C=Dup supplier checked D=Draft E=Pending Editor Review F=Failed Dup supplier checking I=Request More Information P=Pending Approval R=Rejected W=Withdrawn X=Failed OFAC Checking |
| 6 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 7 | EMAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
When the email flag is checked, the user will notified a specific user regarding an activity.
N=No Y=Yes |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | BID_CONTACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Business I=Individual |
| 10 | AUC_COMPANY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Company ID - Company Tax ID |
| 11 | ADDL_COMP_LBL | Character(40) | VARCHAR2(40) NOT NULL | Additional Name |
| 12 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 13 | MAIN_ADDR_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Address Sequence Number |
| 14 | BILL_ADDR_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Address Sequence Number |
| 15 | SHIP_ADDR_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Address Sequence Number |
| 16 | INV_ADDR_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Address Sequence Number |
| 17 | CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 18 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |
| 19 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 20 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 21 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 22 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 23 | SUPOB_REG_OPT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
On boarding manage invite options
AD=Ad-hoc Tasks NB=Register New Bidders NS=Register New Suppliers NU=Register New User Accounts PC=Profile Change Request RB=Request Change for Bidder RS=Request Supplier Change |
| 24 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |