EXD_ADJ_HDR (SQL Table)	Index Back
This is the Excise Adj Header

EXD_ADJ_HDR

(SQL Table)

This is the Excise Adj Header

# 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_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.
Prompt Table: ORG_RGSTN_DTL

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

4 EXD_REGISTER_CD Character(4) VARCHAR2(4) NOT NULL Excise Register Code. This code is unique to the Excise Tax Location and it is issued by the Excise authority
DSA=Daily Stock Account
ICGH=CENVAT Register - CG Onhold
ICGQ=Qty Register - Capital Goods
ICGV=CENVAT Register -Capital Goods
IRMQ=Qty Register - Raw Material
IRMV=CENVAT Register - Raw Material
PLA=Personal Ledger Account

5 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: NBR_SER_VW

6 EXD_ADJUST_NO Character(10) VARCHAR2(10) NOT NULL Adjustment Excise Invoice Nbr

7 EXD_ADJUST_DT Date(10) DATE NOT NULL Adjustment Date

8 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: EXD_REASONCD_VW

9 POSTING_DATE Date(10) DATE NOT NULL Posting Date

10 EXD_ADJ_INC_DEC Character(4) VARCHAR2(4) NOT NULL Inc/Dec
D=Decrease
I=Increase

11 EXD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Excise Adjustment Type
CAP=Capital Goods CENVAT
INV=Inventory Adjustments
OTH=Other Transaction
PAD=Price Adjustment Dispatch
PAP=Price Adjustment Purchase
PLA=PLA Register Update
PLD=PLA Register Deposit
PRD=Daily Stock Account
RMA=Return Material Authorization
RTV=Return To Vendor (Supplier)
SUB=SubContracting

12 EXD_INVOICE_STATUS Character(1) VARCHAR2(1) NOT NULL Excise Invoice Status
0=New
1=Ready To Post
3=Posted

#	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_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization. Prompt Table: ORG_RGSTN_DTL
3	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes. Prompt Table: ORG_TAX_LOC
4	EXD_REGISTER_CD	Character(4)	VARCHAR2(4) NOT NULL	Excise Register Code. This code is unique to the Excise Tax Location and it is issued by the Excise authority DSA=Daily Stock Account ICGH=CENVAT Register - CG Onhold ICGQ=Qty Register - Capital Goods ICGV=CENVAT Register -Capital Goods IRMQ=Qty Register - Raw Material IRMV=CENVAT Register - Raw Material PLA=Personal Ledger Account
5	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: NBR_SER_VW
6	EXD_ADJUST_NO	Character(10)	VARCHAR2(10) NOT NULL	Adjustment Excise Invoice Nbr
7	EXD_ADJUST_DT	Date(10)	DATE NOT NULL	Adjustment Date
8	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: EXD_REASONCD_VW
9	POSTING_DATE	Date(10)	DATE NOT NULL	Posting Date
10	EXD_ADJ_INC_DEC	Character(4)	VARCHAR2(4) NOT NULL	Inc/Dec D=Decrease I=Increase
11	EXD_ADJUST_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Excise Adjustment Type CAP=Capital Goods CENVAT INV=Inventory Adjustments OTH=Other Transaction PAD=Price Adjustment Dispatch PAP=Price Adjustment Purchase PLA=PLA Register Update PLD=PLA Register Deposit PRD=Daily Stock Account RMA=Return Material Authorization RTV=Return To Vendor (Supplier) SUB=SubContracting
12	EXD_INVOICE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Excise Invoice Status 0=New 1=Ready To Post 3=Posted