EXD_REG_AMT_AET(SQL Table) |
Index Back |
---|---|
State RecordThis 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 |