EXD_ALLINV_VW

(SQL View)

SELECT A.BUSINESS_UNIT ,A.EXD_DOC_NBR_SER ,A.EXD_INVOICE_NO FROM PS_EXD_SHP_INV_HDR A WHERE A.EXD_INV_STATUS IN ('R','P') AND A.EXD_PRT_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 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.

3 EXD_INVOICE_NO Character(10) VARCHAR2(10) NOT NULL Excise Invoice Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	EXD_INVOICE_NO	Character(10)	VARCHAR2(10) NOT NULL	Excise Invoice Number