| # |
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 |
SUP_OB_REG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
* Registration ID
|
| 3 |
BIDDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Bidder ID
|
| 4 |
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
|
| 5 |
SUP_OB_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier On boarding template Id
|
| 6 |
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
|
| 7 |
VENDOR_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Classification
A=Attorney
E=Employee
H=HCM
R=Outside Party
|
| 8 |
VNDR_NAME_SHRT_USR |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Vendor Name
|
| 9 |
VNDR_STATUS_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Open For Ordering
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
CORPORATE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 11 |
CORPORATE_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Corporate Vendor
Prompt Table:
VNDR_VALCORP_VW
|
| 12 |
CORP_VNDR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Corporate Vendor
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 13 |
SUP_INITIATED_BY |
Character(2) |
VARCHAR2(2) NOT NULL |
Ordered by
BU=Buyer
EX=External
IN=Internal
|
| 14 |
SOB_DUP_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicates Exist
N=Not Found
Y=Found
Default Value: N
|
| 15 |
PASSCODE |
Character(254) |
VARCHAR2(254) NOT NULL |
password
2022/12/26 KAJ 34912027 8.60 Crypto Uptake
|
| 16 |
STD_ID_NUM_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard ID Number
|
| 17 |
PASSCD_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Password Access
1=No Password Required
2=Supplier Specified Password
3=System Generated Password
Default Value: 1
|
| 18 |
PASSCODE_ENC |
Character(254) |
VARCHAR2(254) NOT NULL |
password
2022/12/26 KAJ 34912027 8.60 Crypto Uptake
|
| 19 |
EEO_CERTIF_DT |
Date(10) |
DATE |
EEO Certification Date
|
| 20 |
HUB_ZONE |
Character(1) |
VARCHAR2(1) NOT NULL |
HUB Zone
N=No
Y=Yes
|