EXD_REG_AMT_AET

(SQL Table)
Index Back

State Record

This is the State Record in the Register Abstract AE Program. (EXD_REG_ABS)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EXD_DUTY_DEBIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Opening Balance
3 EXD_DUTY_CREDIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Opening Balance
4 EXD_CODE_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL AED Amount
5 EXD_CODE_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL BED Amount
6 EXD_CODE_AMT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL SED Amount
7 EXD_CODE_AMT4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise CESS Amount
8 EXD_CODE_AMT5 Signed Number(28,3) DECIMAL(26,3) NOT NULL Additional Duty Amount
9 EXD_CODE_AMT6 Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Duty Amount
10 EXD_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Excise Tax Transaction Type. This field will have various translate values for the transaction types.
BOE=Bill of Entry
DEXB=Deemed Export with Bond
DEXP=Deemed Export
DOMR=Domestic Receipt
DOMS=Domestic Sales
EXP=Export without bond
EXPB=Export with bond
IBUS=Inter-Unit Sale
IUT=InterUnit Receipt
MEIN=Manual
STFR=Stock Transfer
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_CHAPTER_ID Character(7) VARCHAR2(7) NOT NULL Excise Chapter ID
13 EXD_UOM Character(3) VARCHAR2(3) NOT NULL Excise Unit Of Measure
14 EXD_DISP_QTY Signed Number(29,4) DECIMAL(27,4) NOT NULL Display Quantity
15 EXD_DISP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
16 EXD_DISP_DUTY Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
17 EXD_OTH_RECEIPTS Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Receipts
18 EXD_TOT_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Tax Amount
19 EXD_RG23AII_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise RG23AII Amount
20 EXD_RG23CII_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise RG23CII Amount
21 EXD_PLA_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise PLA Amount