| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
UPC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Uniform Product Code ID
|
| 5 |
POTENCY_RATING |
Character(4) |
VARCHAR2(4) NOT NULL |
Potency Code
Prompt Table:
POTENCY_CD_INV
|
| 6 |
INV_ITEM_TEMPLATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Template ID
Prompt Table:
INV_ITEM_TEMPL
|
| 7 |
INV_ITEM_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Type
Default Value: INV_ITEM_DEFLT.INV_ITEM_TYPE
Prompt Table:
TYPE_ITEM_INV
|
| 8 |
RECYCLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Recycle Flag
Y/N Table Edit
Default Value: N
|
| 9 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
Y/N Table Edit
Default Value: N
|
| 10 |
DISPOSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Disposable Flag
Y/N Table Edit
Default Value: N
|
| 11 |
INV_STOCK_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Stock Type
Prompt Table:
STOCK_TYPE_INV
|
| 12 |
PACKING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packing Code
Prompt Table:
PACK_CODE_INV
|
| 13 |
STOR_RULES_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Rule ID
Prompt Table:
STOR_RULES_INV
|
| 14 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 15 |
RECOM_STOR_TEMP |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Temp
|
| 16 |
RECOM_HUMIDITY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Humidity
|
| 17 |
INV_PROD_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Grade
Prompt Table:
INV_ITEM_GRADE
|
| 18 |
MAX_CAPACITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Max Capacity
|
| 19 |
HAZ_CLASS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Hazard Code
Prompt Table:
HAZ_TBL_INV
|
| 20 |
INTL_HAZARD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Intl Hazard ID
|
| 21 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
Prompt Table:
CHARGE_CODE_INV
|
| 22 |
SHELF_LIFE |
Number(4,0) |
SMALLINT NOT NULL |
Shelf Life (Days)
|
| 23 |
AVAIL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected
|
| 24 |
INV_ITEM_HEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Height
|
| 25 |
INV_ITEM_LENGTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Length
|
| 26 |
INV_ITEM_WIDTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Width
|
| 27 |
INV_ITEM_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Weight
|
| 28 |
INV_ITEM_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Volume
|
| 29 |
INV_ITEM_SIZE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Size
|
| 30 |
INV_ITEM_COLOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Color
|
| 31 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table:
UNITS_TBL
|
| 32 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 33 |
UNIT_MEASURE_TEMP |
Character(3) |
VARCHAR2(3) NOT NULL |
Temperature UOM
Prompt Table:
UNITS_TBL
|
| 34 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 35 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 36 |
HARMONIZED_CD |
Character(14) |
VARCHAR2(14) NOT NULL |
Harmonized Code
Prompt Table:
HRMN_TARIFF_CD
|
| 37 |
MSDS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
MSDS ID
Prompt Table:
MSDS_ID_INV
|
| 38 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 39 |
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.
|
| 40 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 41 |
COMMODITY_CD_EU |
Character(10) |
VARCHAR2(10) NOT NULL |
EU Commodity Code
Prompt Table:
COMMOD_CODE_EU
|
| 42 |
AVAIL_LEAD_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Availability Lead Time (Days)
|
| 43 |
RETEST_LEAD_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Retest Lead Time (Days)
|
| 44 |
CHARGE_MARKUP_PCNT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Charge Markup %
|
| 45 |
CHARGE_MARKUP_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Charge Markup Amt
|
| 46 |
CONSUMABLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A Consumable part is a part that will not be considered as an Installed Product record. Types of consumables are rages, tie ends, screws, and other inexpensive parts.
Y/N Table Edit
Default Value: N
|
| 47 |
RETURNABLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Repairable Items are those items that can be returned to the Depot, or a Vendor for repair.
Y/N Table Edit
Default Value: N
|
| 48 |
SERVICEABLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
The Master Inventory Item will be created, updated, and maintained from the PS/Inventory; and since the EIP the Item Sync will only be from PeopleSoft Inventory to CRM Inventory this will enable the service company to only download "service" inventory.
For example, if we did not have this flag and the user could have 300,000 parts that were all encompassing for manufacturing and service; therefore we are simplifying the parts list with only parts that the service company would want to be concerned with.
Y/N Table Edit
Default Value: N
|
| 49 |
SERVICE_PRICE |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Service Price
|
| 50 |
SERVICE_EXCH_AMT |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Service Exchange Amount
|
| 51 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|