SUP_REG_TERMS_C (SQL Table)	Index Back
Terms & Condition Child Terms & Condition Child

SUP_REG_TERMS_C

(SQL Table)

Terms & Condition Child

Related Language Record: SUP_REG_TERM_LN

# 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

6 DESCRLONG Long Character CLOB Long Description

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
6	DESCRLONG	Long Character	CLOB	Long Description