| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SUP_OB_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier On boarding template Id
|
| 2 |
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
|
| 3 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 4 |
DEFAULT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Default SetID
Prompt Table:
SETID_TBL
|
| 5 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 7 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 8 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 9 |
SUP_DUP_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate TIN
N=Do not Check
R=Reject
W=Warning
|
| 10 |
SUP_OB_ACCESS_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Access Code
|
| 11 |
EXPIRATION_DATE |
Date(10) |
DATE |
Expiration Date
|
| 12 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
SUP_TPL_USR_VW
|
| 13 |
STD_ID_NUM_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard ID Number
|
| 14 |
TREE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Tree SetID
Prompt Table:
SUP_TREESETIDVW
|
| 15 |
TREE_ID |
Character(36) |
VARCHAR2(36) NOT NULL |
Tree ID
Prompt Table:
SUP_TREEIDVW
|
| 16 |
INV_EMAILTEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Template
Prompt Table:
SUP_MNG_EMAIL_V
|
| 17 |
DUP_EMAILTEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Template
Prompt Table:
SUP_MNG_EMAIL_V
|
| 18 |
SAVE_EMAILTEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Template
Prompt Table:
SUP_MNG_EMAIL_V
|
| 19 |
CONT_EMAILTEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Template
Prompt Table:
WL_TEMPL_GEN_VW
|
| 20 |
SAVE_FOR_LATER |
Character(1) |
VARCHAR2(1) NOT NULL |
Save for Later
Y/N Table Edit
|
| 21 |
CONT_USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Contact User ID
Prompt Table:
SUP_CONTACT_VW
|
| 22 |
UPD_EMAILTEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Master Update Failed
Prompt Table:
SUP_MNG_EMAIL_V
|
| 23 |
SCR_TS_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Trainstop
Y/N Table Edit
Default Value: Y
|
| 24 |
SCR_TS_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Categorization Trainstop
Y/N Table Edit
Default Value: Y
|
| 25 |
SCR_TS_CNTCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact Trainstop
Y/N Table Edit
Default Value: Y
|
| 26 |
SCR_TS_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Company Profile Trainstop
Y/N Table Edit
Default Value: Y
|
| 27 |
SCR_TS_PYMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Profile Trainstop
Y/N Table Edit
Default Value: Y
|
| 28 |
SCR_TS_WELCOME |
Character(1) |
VARCHAR2(1) NOT NULL |
Welcome Trainstop Selection
Y/N Table Edit
Default Value: Y
|
| 29 |
SUP_OB_TMPL_USAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Usage
B=Both
E=External
I=Internal
N=Not Available
Default Value: B
|
| 30 |
BID_CONTACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bidder Type
B=Business
I=Individual
Default Value: B
|
| 31 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|