| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
UPC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Uniform Product Code ID
|
| 7 |
POTENCY_RATING |
Character(4) |
VARCHAR2(4) NOT NULL |
Potency Code
Prompt Table:
POTENCY_CD_INV
|
| 8 |
INV_ITEM_TEMPLATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Template ID
Prompt Table:
INV_ITEM_TEMPL
|
| 9 |
INV_ITEM_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Type
Default Value: INV_ITEM_DEFLT.INV_ITEM_TYPE
Prompt Table:
TYPE_ITEM_INV
|
| 10 |
RECYCLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Recycle Flag
Y/N Table Edit
Default Value: N
|
| 11 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
Y/N Table Edit
Default Value: N
|
| 12 |
DISPOSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Disposable Flag
Y/N Table Edit
Default Value: N
|
| 13 |
INV_STOCK_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Stock Type
Prompt Table:
STOCK_TYPE_INV
|
| 14 |
PACKING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packing Code
Prompt Table:
PACK_CODE_INV
|
| 15 |
STOR_RULES_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Rule ID
Prompt Table:
STOR_RULES_INV
|
| 16 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 17 |
RECOM_STOR_TEMP |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Temp
|
| 18 |
RECOM_HUMIDITY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Humidity
|
| 19 |
INV_PROD_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Grade
Prompt Table:
INV_ITEM_GRADE
|
| 20 |
MAX_CAPACITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Max Capacity
|
| 21 |
HAZ_CLASS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Hazard Code
Prompt Table:
HAZ_TBL_INV
|
| 22 |
INTL_HAZARD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Intl Hazard ID
|
| 23 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
Prompt Table:
CHARGE_CODE_INV
|
| 24 |
SHELF_LIFE |
Number(4,0) |
SMALLINT NOT NULL |
Shelf Life (Days)
|
| 25 |
AVAIL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected
Default Value: 1
|
| 26 |
INV_ITEM_HEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Height
|
| 27 |
INV_ITEM_LENGTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Length
|
| 28 |
INV_ITEM_WIDTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Width
|
| 29 |
INV_ITEM_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Weight
|
| 30 |
INV_ITEM_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Volume
|
| 31 |
INV_ITEM_SIZE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Size
|
| 32 |
INV_ITEM_COLOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Color
|
| 33 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table:
UNITS_TBL
|
| 34 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 35 |
UNIT_MEASURE_TEMP |
Character(3) |
VARCHAR2(3) NOT NULL |
Temperature UOM
Prompt Table:
UNITS_TBL
|
| 36 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 37 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 38 |
HARMONIZED_CD |
Character(14) |
VARCHAR2(14) NOT NULL |
Harmonized Code
Prompt Table:
HRMN_TARIFF_CD
|
| 39 |
MSDS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
MSDS ID
Prompt Table:
MSDS_ID_INV
|
| 40 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 41 |
LAST_DTTM_UPDATE |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 42 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 43 |
COMMODITY_CD_EU |
Character(10) |
VARCHAR2(10) NOT NULL |
EU Commodity Code
Prompt Table:
COMMOD_CODE_EU
|