| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 3 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 4 |
RUNDATE |
Date(10) |
DATE NOT NULL |
Process Scheduler Run Date
|
| 5 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 6 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 7 |
FROM_DATE |
Date(10) |
DATE NOT NULL |
From Date
|
| 8 |
TO_DATE |
Date(10) |
DATE NOT NULL |
To Date
|
| 9 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 10 |
EXD_CHAPTER_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Excise Chapter ID
|
| 11 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 12 |
PRODUCTION_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Production Qty
|
| 13 |
EXD_OTH_RECEIPTS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Other Receipts
|
| 14 |
EXD_DISP_DUTY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch Duty Amount
|
| 15 |
EXD_DISP_NDUTY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch No Duty Amount
|
| 16 |
EXD_TOT_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amount
|
| 17 |
EXD_RG23AII_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise RG23AII Amount
|
| 18 |
EXD_RG23CII_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise RG23CII Amount
|
| 19 |
EXD_PLA_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise PLA Amount
|
| 20 |
EXD_DUTY_TOT_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch Duty Total Quantity
|
| 21 |
EXD_NDUTY_TOT_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NoDuty Total Quantity
|
| 22 |
EXD_NDUTY_DEXP_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty DEXP Qty
|
| 23 |
EXD_NDUTY_DOMS_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty DOMS Qty
|
| 24 |
EXD_NDUTY_EADJ_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty EADJ Qty
|
| 25 |
EXD_NDUTY_EXP_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty EXP Qty
|
| 26 |
EXD_NDUTY_EXPB_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty EXPB Qty
|
| 27 |
EXD_NDUTY_STRF_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty STRF Qty
|
| 28 |
EXD_NDUTY_DEXB_QTY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Dispatch NDuty DEXB Qty
|