| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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
|
| 2 |
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
|
| 3 |
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
|
| 4 |
ADJUST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
|
| 5 |
RECNAME_TRANS |
Character(18) |
VARCHAR2(18) NOT NULL |
Selected Transactions
|
| 6 |
EXD_ACCT_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Account Source
|
| 7 |
DR_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Excise Distribution Account Type. This field is used to assign chart fields for a particular tax location and will have various translate values.
|
| 8 |
CR_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Excise Distribution Account Type. This field is used to assign chart fields for a particular tax location and will have various translate values.
|
| 9 |
EXD_DR_CR_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Debit Credit Field
|
| 10 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
|
| 11 |
EXD_DR_TMP |
Character(16) |
VARCHAR2(16) NOT NULL |
The field provides translate values on distinctive account types
|
| 12 |
EXD_CR_TMP |
Character(16) |
VARCHAR2(16) NOT NULL |
Credit Temp Field
|