| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GTIN |
Character(14) |
VARCHAR2(14) NOT NULL |
EAN/UCC Global Trade Item Number
|
| 3 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
MANUFACTURER
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 5 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
|
| 6 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
MST_ITM_PRPT_VW
|
| 7 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 8 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
CUSTOMER
|
| 9 |
ORDERABLE_UOM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator identifying that the information provider considers this trade item to be at a hierarchy level where they will accept orders from customers. This may be different from what the information provider identifies as a dispatch unit.
N=Not Orderable
Y=Orderable
Y/N Table Edit
|
| 10 |
SHIPPING_UOM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator identifying that the information provider considers the trade item as a dispatch (shipping) unit.
N=Not Shippable
Y=Shippable
Y/N Table Edit
|
| 11 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 12 |
QTY_PRECISION |
Character(1) |
VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal
W=Whole Nbr
|
| 13 |
ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
|
| 14 |
DFLT_UOM_STOCK |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Stocking UOM
Y/N Table Edit
|
| 15 |
PACKING_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Packing Weight
|
| 16 |
PACKING_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Packing Volume
|
| 17 |
SHIPPING_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Weight
|
| 18 |
SHIPPING_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Shipping Volume
|
| 19 |
UNIT_MEASURE_WT |
Character(3) |
VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table:
UNITS_WT_VW
|
| 20 |
UNIT_MEASURE_VOL |
Character(3) |
VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table:
UNITS_VOL_VW
|
| 21 |
PACKING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packing Code
Prompt Table:
PACK_CODE_INV
|
| 22 |
PACKAGING_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Packaging Code
Prompt Table:
PACKAGNG_CD_INV
|
| 23 |
CONTAINER_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Container Type
Prompt Table:
CNTR_TYPE_INV
|
| 24 |
ITM_STATUS_EFFDT |
Date(10) |
DATE |
Item Status Date
|
| 25 |
ITM_STATUS_CURRENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Current
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
|
| 26 |
ITM_STAT_DT_FUTURE |
Date(10) |
DATE |
Item Date Future
|
| 27 |
ITM_STATUS_FUTURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
|
| 28 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 29 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 30 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 31 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard Unit of Measure
Prompt Table:
UNITS_TBL
|
| 32 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 33 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
INV_ITEM_FAM
|
| 34 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 35 |
CATEGORY_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Category Code
Prompt Table:
ITM_CAT_VW
|
| 36 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 37 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 38 |
APPROVAL_DATE |
Date(10) |
DATE |
Approval Date
|
| 39 |
CHANGE_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Change Reason
|
| 40 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
Y/N Table Edit
|
| 41 |
LOT_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Control
N=N
Y=Y
Y/N Table Edit
|
| 42 |
SERIAL_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial Control
N=N
Y=Y
Y/N Table Edit
|
| 43 |
SHIP_SERIAL_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Serial Control
Y/N Table Edit
|
| 44 |
NON_OWN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
Y/N Table Edit
|
| 45 |
APPROV_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Required for Demand
Y/N Table Edit
|
| 46 |
APPROV_SUBMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a treasury deal review and/or confirmation transac
Y/N Table Edit
|
| 47 |
DENIAL_REASON |
Character(250) |
VARCHAR2(250) NOT NULL |
Item Denial Reason
|
| 48 |
STAGED_DATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON
|
| 49 |
DIST_CFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Configuration
Y/N Table Edit
|
| 50 |
PRDN_CFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Configuration
Y/N Table Edit
|
| 51 |
CFG_CODE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Code Generation
B=Both
N=No
Y=Yes
|
| 52 |
CFG_COST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Costing
Y/N Table Edit
|
| 53 |
CFG_LOT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Configured Lot
Y/N Table Edit
|
| 54 |
CP_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID Field
Prompt Table:
%EDITTABLE
|
| 55 |
CP_TREE_DIST |
Character(18) |
VARCHAR2(18) NOT NULL |
Distribution Model Field
Prompt Table:
CP_TREE_DIST_VW
|
| 56 |
CP_TREE_PRDN |
Character(18) |
VARCHAR2(18) NOT NULL |
Production Model Field
Prompt Table:
CP_TREE_PRDN_VW
|
| 57 |
CM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table:
CM_GROUP_DEFN
|
| 58 |
MATERIAL_RECON_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Material Reconciliation Flag
Y/N Table Edit
|
| 59 |
USG_TRCKNG_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Usage Tracking Method
01=None
02=Billing
03=Costing
|
| 60 |
CONSIGNED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consigned Flag
Y/N Table Edit
|
| 61 |
PL_PRIO_FAMILY |
Character(10) |
VARCHAR2(10) NOT NULL |
Demand Priority Family
Prompt Table:
PL_PRIO_FAMILY
|
| 62 |
ITEM_FIELD_C30_A |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 63 |
ITEM_FIELD_C30_B |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 64 |
ITEM_FIELD_C30_C |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 65 |
ITEM_FIELD_C30_D |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 66 |
ITEM_FIELD_C30_E |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 67 |
ITEM_FIELD_C30_F |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 68 |
ITEM_FIELD_C30_G |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 69 |
ITEM_FIELD_C30_H |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 70 |
ITEM_FIELD_C30_I |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 71 |
ITEM_FIELD_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 72 |
ITEM_FIELD_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 73 |
ITEM_FIELD_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 74 |
ITEM_FIELD_C1_D |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 75 |
ITEM_FIELD_C1_E |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 76 |
ITEM_FIELD_C1_F |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 77 |
ITEM_FIELD_C1_G |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 78 |
ITEM_FIELD_C1_H |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 79 |
ITEM_FIELD_C10_A |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 80 |
ITEM_FIELD_C10_B |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 81 |
ITEM_FIELD_C10_C |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 82 |
ITEM_FIELD_C10_D |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 83 |
ITEM_FIELD_C10_E |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 84 |
ITEM_FIELD_C10_F |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 85 |
ITEM_FIELD_C10_G |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 86 |
ITEM_FIELD_C10_H |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 87 |
ITEM_FIELD_C10_I |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 88 |
ITEM_FIELD_C2 |
Character(2) |
VARCHAR2(2) NOT NULL |
User-defined item field - Character 2
|
| 89 |
ITEM_FIELD_C2_B |
Character(2) |
VARCHAR2(2) NOT NULL |
User-defined item field - Character 2
|
| 90 |
ITEM_FIELD_C4 |
Character(4) |
VARCHAR2(4) NOT NULL |
User-defined item field - Character 4
|
| 91 |
ITEM_FIELD_C4_B |
Character(4) |
VARCHAR2(4) NOT NULL |
User-defined item field - Character 4
|
| 92 |
ITEM_FIELD_C4_C |
Character(4) |
VARCHAR2(4) NOT NULL |
User-defined item field - Character 4
|
| 93 |
ITEM_FIELD_C6 |
Character(6) |
VARCHAR2(6) NOT NULL |
User-defined item field - Character 6
|
| 94 |
ITEM_FIELD_C6_B |
Character(6) |
VARCHAR2(6) NOT NULL |
User-defined item field - Character 6
|
| 95 |
ITEM_FIELD_C8 |
Character(8) |
VARCHAR2(8) NOT NULL |
User-defined item field - Character 8
|
| 96 |
ITEM_FIELD_C8_B |
Character(8) |
VARCHAR2(8) NOT NULL |
User-defined item field - Character 8
|
| 97 |
ITEM_FIELD_C8_C |
Character(8) |
VARCHAR2(8) NOT NULL |
User-defined item field - Character 8
|
| 98 |
ITEM_FIELD_N12_A |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 99 |
ITEM_FIELD_N12_B |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 100 |
ITEM_FIELD_N12_C |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 101 |
ITEM_FIELD_N12_D |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 102 |
ITEM_FIELD_N12_E |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 103 |
ITEM_FIELD_N12_F |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 104 |
ITEM_FIELD_N12_G |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
User-defined item field - Unsigned Decimal 12.3
|
| 105 |
ITEM_FIELD_N15_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 106 |
ITEM_FIELD_N15_B |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 107 |
ITEM_FIELD_N15_C |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 108 |
ITEM_FIELD_N15_D |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 109 |
ITEM_FIELD_N15_E |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 110 |
ITEM_FIELD_N15_F |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 111 |
ITEM_FIELD_N15_G |
Number(15,0) |
DECIMAL(15) NOT NULL |
User-defined item field - Unsigned Decimal 15.0
|
| 112 |
PROMISE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Promise Option
2=Perform ATP Reservations
|
| 113 |
DEVICE_TRACKING |
Character(1) |
VARCHAR2(1) NOT NULL |
Device Tracking Indicator
Y/N Table Edit
|
| 114 |
SERIAL_IN_PRDN |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial in Production
Y/N Table Edit
|
| 115 |
TRACE_USAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Usage
0=None
1=Serial Trace
2=Lot Trace
|
| 116 |
TRACE_CHANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Changes
|
| 117 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 118 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 119 |
UPC_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Uniform Product Code ID
|
| 120 |
POTENCY_RATING |
Character(4) |
VARCHAR2(4) NOT NULL |
Potency Code
Prompt Table:
POTENCY_CD_INV
|
| 121 |
INV_ITEM_TEMPLATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Template ID
Prompt Table:
INV_ITEM_TEMPL
|
| 122 |
INV_ITEM_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Type
Prompt Table:
TYPE_ITEM_INV
|
| 123 |
RECYCLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Recycle Flag
Y/N Table Edit
|
| 124 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
Y/N Table Edit
|
| 125 |
DISPOSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Disposable Flag
Y/N Table Edit
|
| 126 |
INV_STOCK_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Stock Type
Prompt Table:
STOCK_TYPE_INV
|
| 127 |
STOR_RULES_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Rule ID
Prompt Table:
STOR_RULES_INV
|
| 128 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 129 |
RECOM_STOR_TEMP |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Temp
|
| 130 |
RECOM_HUMIDITY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Storage Humidity
|
| 131 |
INV_PROD_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Grade
Prompt Table:
INV_ITEM_GRADE
|
| 132 |
MAX_CAPACITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Max Capacity
|
| 133 |
HAZ_CLASS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Hazard Code
Prompt Table:
HAZ_TBL_INV
|
| 134 |
INTL_HAZARD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Intl Hazard ID
|
| 135 |
CHARGE_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Charge Code
Prompt Table:
CHARGE_CODE_INV
|
| 136 |
SHELF_LIFE |
Number(4,0) |
SMALLINT NOT NULL |
Shelf Life (Days)
|
| 137 |
AVAIL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected
|
| 138 |
INV_ITEM_HEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Height
|
| 139 |
INV_ITEM_LENGTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Length
|
| 140 |
INV_ITEM_WIDTH |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Width
|
| 141 |
INV_ITEM_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Item Weight
|
| 142 |
INV_ITEM_VOLUME |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Volume
|
| 143 |
INV_ITEM_SIZE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Size
|
| 144 |
INV_ITEM_COLOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Color
|
| 145 |
UNIT_MEASURE_DIM |
Character(3) |
VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table:
UNITS_TBL
|
| 146 |
UNIT_MEASURE_TEMP |
Character(3) |
VARCHAR2(3) NOT NULL |
Temperature UOM
Prompt Table:
UNITS_TBL
|
| 147 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 148 |
HARMONIZED_CD |
Character(14) |
VARCHAR2(14) NOT NULL |
Harmonized Code
Prompt Table:
HRMN_TARIFF_CD
|
| 149 |
MSDS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
MSDS ID
Prompt Table:
MSDS_ID_INV
|
| 150 |
COMMODITY_CD_EU |
Character(10) |
VARCHAR2(10) NOT NULL |
EU Commodity Code
Prompt Table:
COMMOD_CODE_EU
|
| 151 |
AVAIL_LEAD_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Availability Lead Time (Days)
|
| 152 |
RETEST_LEAD_TIME |
Number(4,0) |
SMALLINT NOT NULL |
Retest Lead Time (Days)
|
| 153 |
CHARGE_MARKUP_PCNT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Charge Markup %
|
| 154 |
CHARGE_MARKUP_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Charge Markup Amt
|
| 155 |
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
|
| 156 |
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
|
| 157 |
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
|
| 158 |
SERVICE_PRICE |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Service Price
|
| 159 |
SERVICE_EXCH_AMT |
Signed Number(22,5) |
DECIMAL(20,5) NOT NULL |
Service Exchange Amount
|
| 160 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 161 |
DFLT_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Default UOM
Y/N Table Edit
|
| 162 |
MIN_ORDER_QTY |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Minimum Order Quantity
|
| 163 |
MAX_ORDER_QTY |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Maximum Order Quantity
|
| 164 |
PRODUCT_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for distinguishing which products can use a product definition.
1=General Use Excluding Contract
2=Contracts Only
3=General Use Including Contract
|
| 165 |
MODEL_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Model Number
|
| 166 |
CATALOG_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Catalog Number
|
| 167 |
TAX_PRODUCT_NBR |
Character(18) |
VARCHAR2(18) NOT NULL |
Tax Product Number
|
| 168 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 169 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 170 |
PRODUCT_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Kit
Y/N Table Edit
|
| 171 |
DROP_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drop Ship
N=No
Y=Yes
Y/N Table Edit
|
| 172 |
COMM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commissionable
Y/N Table Edit
|
| 173 |
COMM_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Commission %
|
| 174 |
UPPER_MARGIN_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Upper Margin %
|
| 175 |
LOWER_MARGIN_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Lower Margin %
|
| 176 |
HOLD_UPDATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Update Switch
Y/N Table Edit
|
| 177 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 178 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJID_BUGL_VW
|
| 179 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 180 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table:
CM_ELEMENT
|
| 181 |
EXPORT_LIC_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Export License Required
NO=No
YES=Yes
|
| 182 |
FORECAST_ITEM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Demand Planning Item
Y/N Table Edit
|
| 183 |
RETURN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be returned
Y/N Table Edit
|
| 184 |
CFG_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configured Kit
Y/N Table Edit
|
| 185 |
PRICE_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Kit Flag
C=Price Kit at Component Level
T=Price Kit at Top Level
|
| 186 |
PROD_BRAND |
Character(15) |
VARCHAR2(15) NOT NULL |
Product Brand
Prompt Table:
PROD_BRAND_TBL
|
| 187 |
PROD_CATEGORY |
Character(15) |
VARCHAR2(15) NOT NULL |
Product Category
Prompt Table:
PROD_CATGRY_TBL
|
| 188 |
THIRD_PARTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Third Party Flag
Y/N Table Edit
|
| 189 |
RENEWABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewable
Y/N Table Edit
|
| 190 |
RENEWAL_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Renewal Action
AUTO=Automatic
MANL=Manual
|
| 191 |
PRICING_STRUCTURE |
Character(4) |
VARCHAR2(4) NOT NULL |
Price Type
AMT=Amount
PCT=Percent
RATE=Rate
RCR=Recurring
|
| 192 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 193 |
APPLIES_TO |
Character(4) |
VARCHAR2(4) NOT NULL |
PSIRS-KK
HDR=% of Total Contract Amount
LINE=% of Contract Lines
|
| 194 |
REV_RECOG_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue
|
| 195 |
CA_BP_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Template
Prompt Table:
CA_BP_TMPL_VW
|
| 196 |
BP_DTL_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Detail Template ID
Prompt Table:
CA_BP_DTL_TMPL
|
| 197 |
RNW_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Renewal Plan Template
Prompt Table:
CA_RNW_TEMPLATE
|
| 198 |
CA_AP_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Plan Template
Prompt Table:
CA_AP_TMPL_VW
|
| 199 |
PROD_FIELD_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Char1 A
|
| 200 |
PROD_FIELD_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Char1 B
|
| 201 |
PROD_FIELD_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Char1 C
|
| 202 |
PROD_FIELD_C1_D |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Char1 D
|
| 203 |
PROD_FIELD_C10_A |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Char 10 A
|
| 204 |
PROD_FIELD_C10_B |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Char 10 B
|
| 205 |
PROD_FIELD_C10_C |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Char 10 C
|
| 206 |
PROD_FIELD_C10_D |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Char 10 D
|
| 207 |
PROD_FIELD_C2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Product Char 2
|
| 208 |
PROD_FIELD_C30_A |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Char 30 A
|
| 209 |
PROD_FIELD_C30_B |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Char 30 B
|
| 210 |
PROD_FIELD_C30_C |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Char 30 C
|
| 211 |
PROD_FIELD_C30_D |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Char 30 D
|
| 212 |
PROD_FIELD_C4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Product Char 8
|
| 213 |
PROD_FIELD_C6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Product Char 6
|
| 214 |
PROD_FIELD_C8 |
Character(8) |
VARCHAR2(8) NOT NULL |
Product Char 8
|
| 215 |
PROD_FIELD_N12_A |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Product Nbr 12.3 A
|
| 216 |
PROD_FIELD_N12_B |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Product Nbr 12.3 B
|
| 217 |
PROD_FIELD_N12_C |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Product Nbr 12.3 C
|
| 218 |
PROD_FIELD_N12_D |
Number(16,3) |
DECIMAL(15,3) NOT NULL |
Product Nbr 12.3 D
|
| 219 |
PROD_FIELD_N15_A |
Number(15,0) |
DECIMAL(15) NOT NULL |
Prod Field Nbr 15 A
|
| 220 |
PROD_FIELD_N15_B |
Number(15,0) |
DECIMAL(15) NOT NULL |
Prod Field Nbr 15 B
|
| 221 |
PROD_FIELD_N15_C |
Number(15,0) |
DECIMAL(15) NOT NULL |
Prod Field Nbr 15 C
|
| 222 |
PROD_FIELD_N15_D |
Number(15,0) |
DECIMAL(15) NOT NULL |
Prod Field Nbr 15 D
|
| 223 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
|
| 224 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 225 |
CUST_GLN |
Character(13) |
VARCHAR2(13) NOT NULL |
EAN/UCC Global Location Number for the customer
|
| 226 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 227 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|