View of valid number types that can be specified in SCM's auto number master db page.

OM_MSTDB_TYPLVW

(SQL View)

SELECT A.FIELDVALUE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDNAME = 'NUM_TYPE' AND A.FIELDVALUE IN ('CUST','CID') AND A.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, A, %CurrentDateIn) AND %Join(COMMON_KEYS, PSXLATITEM A, PSXLATITEMLANG B)

Related Language Record for OM_MSTDB_TYP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 NUM_TYPE Character(4) VARCHAR2(4) NOT NULL AUTO_NUM_INSTAL. To enable a value in the Auto NUmber by Installation you need to add the value to the Record SearchInit Peoplecode in record AUTO_NUM_INSTAL

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	NUM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	AUTO_NUM_INSTAL. To enable a value in the Auto NUmber by Installation you need to add the value to the Record SearchInit Peoplecode in record AUTO_NUM_INSTAL
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description