| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 4 |
PRICE_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Price List ID
Prompt Table:
EOEP_PRLSTID_VW
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 6 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 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 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 9 |
BREAK_QTY_LOW |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Low Quantity/Amount
Default Value: 0
|
| 10 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 11 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
|
| 12 |
CM_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
8/20/02 lee: added xlate 9 for retroactive perp average
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost
1=Actual Cost
6=Perpetual Weighted Average
7=Periodic Weighted Average
8=Value at Current Standard
9=Retroactive Perpetual Average
|
| 13 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 14 |
BREAK_QTY_HIGH |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Upper Quantity/Amount
|
| 15 |
TO_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency
|
| 16 |
UNIT_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Unit Cost
|
| 17 |
COST_EFFDT |
Date(10) |
DATE |
Effective date for Order Management Cost extract
|
| 18 |
LIST_PRICE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
List Price
|
| 19 |
ALTERNATE_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Alternate Cost for Mass Pricing.
|
| 20 |
ADJUST_ALTCOST_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Alternate Cost Adjust Percent
|
| 21 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 23 |
PRICE_PROTECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Protected
Y/N Table Edit
|
| 24 |
DATE_SEL_DT |
Date(10) |
DATE |
03/23/2004 SFC Added PROD_COST_EFF_DT label
|
| 25 |
PRICE_LIST_ID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Price List ID Flag
N=All Price Lists
Y=Single Price List
Default Value: N
|
| 26 |
CURRENCY_PLST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
03/23/2004 SFC Deleted SELECTCURRENCYCODE
Modified XLAT
N=All Currencies
Y=Single Currency Code
Default Value: N
|
| 27 |
UNIT_COST_OLD |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 28 |
ALT_UNIT_COST_OLD |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 29 |
LIST_PRICE_OLD |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 30 |
BREAK_QTY_LOW_OLD |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 31 |
BREAK_QTY_HIGH_OLD |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 32 |
START_DATE_OLD |
Date(10) |
DATE |
06/01/2014 Price Mass Maintenance
|
| 33 |
END_DATE_OLD |
Date(10) |
DATE |
06/01/2014 Price Mass Maintenance
|
| 34 |
OM_MCP_LINE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
06/01/2014 Price Mass Maintenance
10=New
20=Changed
30=Validated
40=Validate Error
50=Uploaded
60=Upload Error
|
| 35 |
OM_MCP_HIDE_ROWS |
Character(1) |
VARCHAR2(1) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 36 |
PRICE_PROTECT_OLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Protected
Y/N Table Edit
|
| 37 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 38 |
ERROR_LABEL |
Character(100) |
VARCHAR2(100) NOT NULL |
Error Label
|
| 39 |
INSERT_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
06/01/2014 Price Mass Maintenance
N=Insert Row No
Y=Insert Row Yes
|
| 40 |
OM_MCP_LASTOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
06/01/2014 Price Mass Maintenance
|
| 41 |
OM_MCP_LAST_DTTM |
DateTime(26) |
TIMESTAMP |
06/01/2014 Price Mass Maintenance
|