SUPOB_APRLST_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID , A.BIDDER_ID , A.SUP_OB_REG_ID , A.AUC_COMPANY_NAME , B.SUPOB_REG_OPT_TYPE , B.SUP_OB_APR_STATUS , A.CREATE_DTTM , A.LAST_UPDATE_DTTM , B.SUP_INITIATED_BY , C.OPRID FROM PS_AUC_BIDDER_HDR A ,PS_SUP_OB_REG_DEF B , PS_SOB_AW_ACTN_VW C WHERE A.SETID=B.SETID AND A.SUP_OB_REG_ID=B.SUP_OB_REG_ID AND A.BIDDER_ID=B.BIDDER_ID AND B.SETID=C.SETID AND B.SUP_OB_REG_ID=C.SUP_OB_REG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 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 | AUC_COMPANY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Company ID - Company Tax ID |
| 5 | 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 |
| 6 | 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 |
| 7 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |
| 8 | 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. |
| 9 | SUP_INITIATED_BY | Character(2) | VARCHAR2(2) NOT NULL |
Ordered by
BU=Buyer EX=External IN=Internal |
| 10 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |