NBR_SER_VW

(SQL View)

SELECT DISTINCT A.SETID ,B.ORG_TAX_LOC_CD , A.EXD_DOC_NBR_SER , A.DESCR1 FROM PS_ORG_DOC_NBR_SER A , PS_ORG_DOC_NBR_RNG B WHERE A.SETID = B.SETID AND A.EXD_DOC_NBR_SER = B.EXD_DOC_NBR_SER AND A.EXD_TXN_TYPE = 'MEIN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.

3 EXD_DOC_NBR_SER Character(6) VARCHAR2(6) NOT NULL Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.

4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
3	EXD_DOC_NBR_SER	Character(6)	VARCHAR2(6) NOT NULL	Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
4	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr