| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 5 |
PROCESS_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Control
1=Create Replenishment Requests
2=Process Reviewed Requests
3=Create and Process Requests
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
DOWNTIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prohibit Material Movements
|
| 8 |
SL_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table:
SP_BUVM_NONVW
|
| 9 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table:
SP_BUVM_NONVW
|
| 10 |
ALL_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit
Y=All Business Units
|
| 11 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 12 |
VMI_OM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
OM Business Unit Related to VMI
|
| 13 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 14 |
ALL_OM_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
All OM Business Units
|
| 15 |
SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
|
| 16 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SOLDTO_VW
|
| 17 |
TO_SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SOLDTO_VW
|
| 18 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
IN_VMI_SHCST_VW
|
| 19 |
TO_SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
IN_VMI_SHCST_VW
|
| 20 |
SETID2 |
Character(5) |
VARCHAR2(5) NOT NULL |
2nd SetId
|
| 21 |
SETID_CUST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Concatenated SETID, seperator and CUST_ID
|
| 22 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 23 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 24 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 25 |
WHERE_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 26 |
WHERE_CLAUSE5 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 27 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 28 |
WHERE_OPER |
Character(12) |
VARCHAR2(12) NOT NULL |
Operator
|
| 29 |
RANGE_PCT |
Number(2,0) |
SMALLINT NOT NULL |
Range Checking Percentage
|
| 30 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 31 |
REORD_QTY_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Reorder Point Order Quantities
1=EOQ
2=Min/Max
3=AOQ
4=Static Reorder Qty
5=Demand Quantity
99=Use Business Unit Default
|
| 32 |
FIELD2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Fieldname 2
|
| 33 |
REPLENISH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Replenish ID
|
| 34 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 35 |
PROCESS_DTTM |
DateTime(26) |
TIMESTAMP |
Process Date Time
|
| 36 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 37 |
PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
|
| 38 |
REPLENISH_CLASS |
Character(4) |
VARCHAR2(4) NOT NULL |
Replenish Class
|
| 39 |
INCL_CANCELLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Cancelled Orders
Y/N Table Edit
Default Value: Y
|
| 40 |
ROP_REPLENISH |
Character(1) |
VARCHAR2(1) NOT NULL |
Reorder Point Replenishment
|
| 41 |
FIXED_LOC_REPLEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Fixed Bin Replenishment
|
| 42 |
VENDOR_RANGE_PCT |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Range Checking Pct
|
| 43 |
INCL_REQ_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Requisition Quantities
|
| 44 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 45 |
UPDATE_STATISTICS |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Statistic
|
| 46 |
COMMIT_BATCH |
Number(6,0) |
INTEGER NOT NULL |
Commit Batch
|
| 47 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 48 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 49 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 50 |
QTY_1 |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
QTY1
|
| 51 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 52 |
TO_INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
IN_VMI_ITEMS_VW
|
| 53 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 54 |
VMI_ORDER_CONSOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Replenishment Consolidation
1=Sold To Customer
2=Ship To Customer
3=None
|
| 55 |
EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 56 |
NUM_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
AUTO_NUM_INSTAL. To enable a value in the Auto NUmber by Installation you need to add the value to the Record SearchInit Peoplecode in record AUTO_NUM_INSTAL
|
| 57 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 58 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 59 |
ORDER_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Line Count
|
| 60 |
LINE_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Line Count
|
| 61 |
CUST_ID2 |
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.
|
| 62 |
INV_ITEM_ID2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 63 |
SHIPTO_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 64 |
SOLDTO_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 65 |
PRODUCT_ID_TEMP |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Id Temp
|
| 66 |
REORDER_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Reorder Qty
|
| 67 |
VMI_REPLEN_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Replenishment UOM
|
| 68 |
REORDER_QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Reorder Qty
|
| 69 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 70 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|