EXD_HDR_VW

(SQL View)

SELECT DISTINCT a.BUSINESS_UNIT , a.EXD_DOC_NBR_SER , a.EXD_INVOICE_NO , a.EXD_INV_STATUS FROM PS_EXD_SHP_INV_HDR a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUEXD_NONVW

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.
Prompt Table: ORG_DOC_NBR_SER

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

4 EXD_INV_STATUS Character(1) VARCHAR2(1) NOT NULL Excise Invoice Status
C=Cancel
N=New
P=Post
R=Ready

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUEXD_NONVW
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. Prompt Table: ORG_DOC_NBR_SER
3	EXD_INVOICE_NO	Character(10)	VARCHAR2(10) NOT NULL	Excise Invoice Number
4	EXD_INV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Excise Invoice Status C=Cancel N=New P=Post R=Ready