| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 5 |
RUNDATE |
Date(10) |
DATE |
Process Scheduler Run Date
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 7 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 8 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 9 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 10 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 11 |
EXD_REG_RG1_ABS |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Quantity Rgstr Abstract
|
| 12 |
EXD_REG_PLA_ABS |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise PLA Register Abstract
|
| 13 |
EXD_REG_AC2_ABS |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise CENVAT Rgstr Abstract
|
| 14 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 15 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 16 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 17 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 18 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 19 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 20 |
EXD_BALANCE_DATE |
Date(10) |
DATE |
Balance Date
|
| 21 |
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
|
| 22 |
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
|
| 23 |
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
|
| 24 |
EXD_CHAPTER_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Excise Chapter ID
|
| 25 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 26 |
PRODUCTION_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Production Qty
|
| 27 |
EXD_OTH_RECEIPTS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Receipts
|
| 28 |
EXD_DISP_QTY |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Display Quantity
|
| 29 |
EXD_TOT_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amount
|
| 30 |
EXD_RG23AII_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise RG23AII Amount
|
| 31 |
EXD_RG23CII_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise RG23CII Amount
|
| 32 |
EXD_PLA_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise PLA Amount
|
| 33 |
EXD_TAX_CMPNT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
AED Component Code
|
| 34 |
EXD_CODE_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
AED Amount
|
| 35 |
EXD_TAX_CMPNT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
BED Componet Code
|
| 36 |
EXD_CODE_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
BED Amount
|
| 37 |
EXD_TAX_CMPNT3 |
Character(10) |
VARCHAR2(10) NOT NULL |
SED Component Code
|
| 38 |
EXD_CODE_AMT3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SED Amount
|
| 39 |
EXD_TAX_CMPNT4 |
Character(10) |
VARCHAR2(10) NOT NULL |
CESS Component Code
|
| 40 |
EXD_CODE_AMT4 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise CESS Amount
|
| 41 |
EXD_TAX_CMPNT5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Addl Component Code
|
| 42 |
EXD_CODE_AMT5 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional Duty Amount
|
| 43 |
EXD_TAX_CMPNT6 |
Character(10) |
VARCHAR2(10) NOT NULL |
Other Component Code
|
| 44 |
EXD_CODE_AMT6 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Duty Amount
|
| 45 |
EXD_DISP_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 46 |
EXD_DISP_DUTY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch Duty Amount
|
| 47 |
EXD_DISP_NDUTY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch No Duty Amount
|
| 48 |
EXD_DUTY_DEBIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 49 |
EXD_DAY_DUTY_DR |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 50 |
EXD_DUTY_DEBIT1 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 51 |
EXD_DUTY_DEBIT2 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 52 |
EXD_DUTY_DEBIT3 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 53 |
EXD_DUTY_DEBIT4 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 54 |
EXD_DUTY_DEBIT5 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 55 |
EXD_DUTY_DEBIT6 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 56 |
EXD_DUTY_CREDIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 57 |
EXD_DAY_DUTY_CR |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 58 |
EXD_DUTY_CREDIT1 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 59 |
EXD_DUTY_CREDIT2 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 60 |
EXD_DUTY_CREDIT3 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 61 |
EXD_DUTY_CREDIT4 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 62 |
EXD_DUTY_CREDIT5 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 63 |
EXD_DUTY_CREDIT6 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 64 |
EXD_OPEN_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 65 |
EXD_DAY_OPEN_BAL |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 66 |
EXD_OPEN_BALANCE1 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 67 |
EXD_OPEN_BALANCE2 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 68 |
EXD_OPEN_BALANCE3 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 69 |
EXD_OPEN_BALANCE4 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 70 |
EXD_OPEN_BALANCE5 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 71 |
EXD_OPEN_BALANCE6 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 72 |
EXD_CLOSE_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Opening Balance
|
| 73 |
EXD_DAY_CLOSE_BAL |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 74 |
EXD_CLOSE_BALANCE1 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 75 |
EXD_CLOSE_BALANCE2 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 76 |
EXD_CLOSE_BALANCE3 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 77 |
EXD_CLOSE_BALANCE4 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 78 |
EXD_CLOSE_BALANCE5 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 79 |
EXD_CLOSE_BALANCE6 |
Signed Number(27,2) |
DECIMAL(25,2) NOT NULL |
Opening Balance
|
| 80 |
EXD_DUTY_TOT_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch Duty Total Quantity
|
| 81 |
EXD_NDUTY_TOT_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NoDuty Total Quantity
|
| 82 |
EXD_NDUTY_DEXP_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty DEXP Qty
|
| 83 |
EXD_NDUTY_DOMS_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty DOMS Qty
|
| 84 |
EXD_NDUTY_EADJ_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty EADJ Qty
|
| 85 |
EXD_NDUTY_EXP_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty EXP Qty
|
| 86 |
EXD_NDUTY_EXPB_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty EXPB Qty
|
| 87 |
EXD_NDUTY_IBUS_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty IBUS Qty
|
| 88 |
EXD_NDUTY_MEIN_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty MEIN Qty
|
| 89 |
EXD_NDUTY_MISC_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty MISC Qty
|
| 90 |
EXD_NDUTY_STFR_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty STFR Qty
|
| 91 |
EXD_NDUTY_STRF_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty STRF Qty
|
| 92 |
EXD_NDUTY_OTH_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty OTHER Qty
|
| 93 |
EXD_NDUTY_DEXB_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty DEXB Qty
|
| 94 |
WRK_EXD_TAX_CMPNT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code 1
|
| 95 |
WRK_EXD_TAX_CMPNT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code 2
|
| 96 |
WRK_EXD_TAX_CMPNT3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code 3
|
| 97 |
WRK_EXD_TAX_CMPNT4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code 4
|
| 98 |
WRK_EXD_TAX_CMPNT5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code 5
|
| 99 |
WRK_EXD_TAX_CMPNT6 |
Character(10) |
VARCHAR2(10) NOT NULL |
tax Component Code 6
|
| 100 |
EXD_INV_DATE |
Date(10) |
DATE |
Date Invoice Created
|