EXD_SHP_SRCH_VW (SQL View)	Index Back
Ship Inv View

EXD_SHP_SRCH_VW

(SQL View)

Ship Inv View

SELECT DISTINCT H.ORG_SETID , H.ORG_CODE , H.ORG_TAX_LOC_CD , H.EXD_DOC_NBR_SER , H.EXD_INV_DATE , H.EXD_INVOICE_NO FROM PS_EXD_SHP_INV_HDR H WHERE H.EXD_INV_STATUS = 'R' AND H.EXD_QTY_REG_UPD = 'Y' AND EXISTS ( SELECT 'X' FROM PS_EXD_SHP_INV_LN L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.EXD_DOC_NBR_SER = L.EXD_DOC_NBR_SER AND H.EXD_INVOICE_NO = L.EXD_INVOICE_NO AND L.TOT_EXD_AMT_RPT > 0 AND L.EXD_CENVAT_FLG <> 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.

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

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

5 EXD_INV_DATE Date(10) DATE Date Invoice Created

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
3	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
4	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.
5	EXD_INV_DATE	Date(10)	DATE	Date Invoice Created
6	EXD_INVOICE_NO	Character(10)	VARCHAR2(10) NOT NULL	Excise Invoice Number