EXD_SHP_CNVT_WS

#	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
4	EXD_INV_DATE	Date(10)	DATE	Date Invoice Created
5	EXD_INV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Excise Invoice Status C=Cancel N=New P=Post R=Ready
6	TOT_EXD_AMT_RPT	Number(27,3)	DECIMAL(26,3) NOT NULL	Total Excise Duty
7	EXD_TAX_SEQ1	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence 1
8	EXD_TAX_CMPNT1	Character(10)	VARCHAR2(10) NOT NULL	AED Component Code
9	EXD_CODE_AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	AED Amount
10	EXD_CODE_RATE1	Number(8,4)	DECIMAL(7,4) NOT NULL	AED Rate
11	EXD_TAX_SEQ2	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence 1
12	EXD_TAX_CMPNT2	Character(10)	VARCHAR2(10) NOT NULL	BED Componet Code
13	EXD_CODE_AMT2	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	BED Amount
14	EXD_CODE_RATE2	Number(8,4)	DECIMAL(7,4) NOT NULL	BED Rate
15	EXD_TAX_SEQ3	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence 3
16	EXD_TAX_CMPNT3	Character(10)	VARCHAR2(10) NOT NULL	SED Component Code
17	EXD_CODE_AMT3	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SED Amount
18	EXD_CODE_RATE3	Number(8,4)	DECIMAL(7,4) NOT NULL	SED Rate
19	EXD_TAX_SEQ4	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence 4
20	EXD_TAX_CMPNT4	Character(10)	VARCHAR2(10) NOT NULL	CESS Component Code
21	EXD_CODE_AMT4	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise CESS Amount
22	EXD_CODE_RATE4	Number(8,4)	DECIMAL(7,4) NOT NULL	Excise CESS Rate
23	EXD_TAX_SEQ5	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence 5
24	EXD_TAX_CMPNT5	Character(10)	VARCHAR2(10) NOT NULL	Addl Component Code
25	EXD_CODE_AMT5	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Additional Duty Amount
26	EXD_CODE_RATE5	Number(8,4)	DECIMAL(7,4) NOT NULL	Additional Duty Rate
27	EXD_TAX_SEQ6	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence 6
28	EXD_TAX_CMPNT6	Character(10)	VARCHAR2(10) NOT NULL	Other Component Code
29	EXD_CODE_AMT6	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Other Duty Amount
30	EXD_CODE_RATE6	Number(8,4)	DECIMAL(7,4) NOT NULL	Other Duty Rate
31	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Y/N Table Edit Default Value: Y
32	DETAILS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Details Exist for Engagement Planning