| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 5 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 6 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 7 |
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
|
| 8 |
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
|
| 9 |
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
|
| 10 |
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
|
| 11 |
RECNAME_TRANS |
Character(18) |
VARCHAR2(18) NOT NULL |
Selected Transactions
|
| 12 |
EXD_ACCT_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Account Source
|
| 13 |
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.
|
| 14 |
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.
|
| 15 |
EXD_DR_CR_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Debit Credit Field
|
| 16 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
|
| 17 |
EXD_DR_TMP |
Character(16) |
VARCHAR2(16) NOT NULL |
The field provides translate values on distinctive account types
|
| 18 |
EXD_CR_TMP |
Character(16) |
VARCHAR2(16) NOT NULL |
Credit Temp Field
|
| 19 |
CHNG_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor
|
| 20 |
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.
|
| 21 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|