| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 4 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 5 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 6 |
STAGED_DATE |
Date(10) |
DATE |
Staged Date
Prompt Table:
%EDITTABLE9
|
| 7 |
INV_LOT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lot ID
Prompt Table:
%EDITTABLE
|
| 8 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
Prompt Table:
%EDITTABLE7
|
| 9 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
%EDITTABLE2
|
| 10 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
%EDITTABLE3
|
| 11 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
%EDITTABLE4
|
| 12 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
%EDITTABLE5
|
| 13 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
%EDITTABLE6
|
| 14 |
CONTAINER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Container ID
Prompt Table:
%EDITTABLE8
|
| 15 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 16 |
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
|
| 17 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 18 |
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
|
| 19 |
FIRST_ROW |
Character(1) |
VARCHAR2(1) NOT NULL |
First Row
|
| 20 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 21 |
INV_ITEM_ID_LAST |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 22 |
COMMIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Reservations for Commits
|
| 23 |
ROWS_RETRIEVED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Rows Retrieved
|
| 24 |
TOTAL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Total Row Count
|
| 25 |
COMMIT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count based on Commit Level used to determine the size of a unit of work to commit to the database. A value of zero indicates include all updates in the same unit of work and do one commit at the end of each Processing Group. This count can be used to help tune at a site that is running into issues with large runs causing blocking and deadlocks on the base tables updated by the process.
|
| 26 |
ROWS_IN_STAGE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Total Rows in Staging Table
|
| 27 |
PICK_UOM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Picking Unit of Measure Flag
1=Std UOM
2=Loc UOM
|
| 28 |
CAP_CHK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capital Plan Check Switch
|
| 29 |
NEGATIVE_INV |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Inventory
|
| 30 |
NEG_BAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Balances
N=No negative balances
Y=Negative supplier balance(s)
|
| 31 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 32 |
TRANSACTION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Issue/Receipt Flag
1=Issue Material from Stock
2=Return Material to Stock
Y/N Table Edit
Default Value: N
|
| 33 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 34 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 35 |
MESSAGE_PARM2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 2
|
| 36 |
MESSAGE_PARM3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 3
|
| 37 |
NEXT_SHIP_LINE |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Next Ship Line
|
| 38 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 39 |
SHIP_LINE_NO |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Ship Line No
|
| 40 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|