| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
TEMPLATE_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Template Code
|
| 3 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 4 |
EFFDT_USED |
Date(10) |
DATE |
Effective Date
Default Value: %DATE
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 6 |
TMPL_TABLE_NAME |
Character(2) |
VARCHAR2(2) NOT NULL |
Field Used to store table that item template will be updating
1=Master Item Group
10=Item Cost Method
11=Product Attributes Group
12=BU Item Substitutes
13=Purchasing Attributes Group
14=Inventory Management Group
15=Inventory Fulfillment Group
16=Picking/Putaway Zones
17=Fixed Picking Location
18=Default Putaway Location
19=Item Putaway Rules
2=Inventory Items
20=Planning Attributes
21=Replenishment Attributues
22=Automatic Serial Numbering
23=PO BU Item Attributes
24=Item Supplier Attributes Group
3=Inv Item UOM
30=Manufactured Item Group
31=UPN Attributes
32=GPO Attributes
36=Replenishment Location
4=Item UOM Type
5=Substitute Items
6=Business Unit Item Group
7=BU Items Config
8=BU Items Util CD
9=BU Items WtVol
Default Value: 2
|
| 7 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 8 |
UPC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Uniform Product Code ID
|
| 9 |
POTENCY_RATING |
Character(4) |
VARCHAR2(4) NOT NULL |
Potency Code
Prompt Table:
POTENCY_CD_INV
|
| 10 |
INV_ITEM_TEMPLATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Template ID
Prompt Table:
INV_ITEM_TEMPL
|
| 11 |
INV_ITEM_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Type
Default Value: INV_ITEM_DEFLT.INV_ITEM_TYPE
Prompt Table:
TYPE_ITEM_INV
|
| 12 |
RECYCLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Recycle Flag
Y/N Table Edit
Default Value: N
|
| 13 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
Y/N Table Edit
Default Value: N
|
| 14 |
DISPOSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Disposable Flag
Y/N Table Edit
Default Value: N
|
| 15 |
INV_STOCK_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Stock Type
Prompt Table:
STOCK_TYPE_INV
|
| 16 |
PACKING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packing Code
Prompt Table:
PACK_CODE_INV
|
| 17 |
STOR_RULES_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Rule ID
Prompt Table:
STOR_RULES_INV
|
| 18 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 19 |
RECOM_STOR_TEMP |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Temp
|
| 20 |
RECOM_HUMIDITY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Humidity
|
| 21 |
INV_PROD_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Grade
Prompt Table:
INV_ITEM_GRADE
|
| 22 |
MAX_CAPACITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Max Capacity
|
| 23 |
HAZ_CLASS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Hazard Code
Prompt Table:
HAZ_TBL_INV
|
| 24 |
INTL_HAZARD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Intl Hazard ID
|
| 25 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
Prompt Table:
CHARGE_CODE_INV
|
| 26 |
SHELF_LIFE |
Number(4,0) |
SMALLINT NOT NULL |
Shelf Life (Days)
|
| 27 |
AVAIL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected
|
| 28 |
INV_ITEM_HEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Height
|
| 29 |
INV_ITEM_LENGTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Length
|
| 30 |
INV_ITEM_WIDTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Width
|
| 31 |
INV_ITEM_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Weight
|
| 32 |
INV_ITEM_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Volume
|
| 33 |
INV_ITEM_SIZE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Size
|
| 34 |
INV_ITEM_COLOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Color
|
| 35 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table:
UNITS_TBL
|
| 36 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_TBL
|
| 37 |
UNIT_MEASURE_TEMP |
Character(3) |
VARCHAR2(3) NOT NULL |
Temperature UOM
Prompt Table:
UNITS_TBL
|
| 38 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_TBL
|
| 39 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 40 |
HARMONIZED_CD |
Character(14) |
VARCHAR2(14) NOT NULL |
Harmonized Code
Prompt Table:
HRMN_TARIFF_CD
|
| 41 |
MSDS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
MSDS ID
Prompt Table:
MSDS_ID_INV
|
| 42 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 43 |
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.
|
| 44 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 45 |
COMMODITY_CD_EU |
Character(10) |
VARCHAR2(10) NOT NULL |
EU Commodity Code
Prompt Table:
COMMOD_CODE_EU
|
| 46 |
AVAIL_LEAD_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Availability Lead Time (Days)
|
| 47 |
RETEST_LEAD_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Retest Lead Time (Days)
|
| 48 |
CHARGE_MARKUP_PCNT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Charge Markup %
|
| 49 |
CHARGE_MARKUP_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Charge Markup Amt
|
| 50 |
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
|
| 51 |
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
|
| 52 |
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
|
| 53 |
SERVICE_PRICE |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Service Price
|
| 54 |
SERVICE_EXCH_AMT |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Service Exchange Amount
|
| 55 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|