SUP_REG_HDRINFO(SQL Table) |
Index Back |
---|---|
Supplier Onboard Reg SetupSupplier Onboarding Registration Template Setup |
# | 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 | SUP_HDR_INFO_CD | Character(3) | VARCHAR2(3) NOT NULL |
Supplier Header Information
ADN=Additional ID Numbers ATT=Attachments CLS=Classification DUP=Duplicate Invoice Settings GOV=Government Classifications LOG=Logos NAM=Additional Name OPO=Open for PO PRT=Persistence RAT=Supplier Rating RPT=Additional Reporting Elements SIC=SIC Codes SNA=Short Name SRE=Supplier Relationships STA=Supplier Status VAT=VAT Registration WTH=Withholding |
4 | SUP_HDR_INFO_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Attribute Description |
5 | SUP_DATA_ENTRY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Data Entry Option
N=Do Not Display Y=Allow User Entry Default Value: N |
6 | SUP_USER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
User Type
I=Internal P=Public |
7 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes Y/N Table Edit Default Value: N |