| # |
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
|
| 3 |
OVRRIDE_LEVEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
indicates whether to allow a user to override the pass-through level from a page.
|
| 4 |
OVRRIDE_COMMIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to allow a user to override the processing and commit levels and counts from a page.
|
| 5 |
OVRRIDE_STATES_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether the user can override the default states from a page.
|
| 6 |
PASS_THROUGH_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line
|
| 7 |
PROCESSING_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count based on Processing Level used to determine the Processing Group. A value of zero indicates include all data into one 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. When processing, if Commit Count is greater than the specified Processing Count and the Processing Level is the same as the Commit Level, the Processing Count should be set to the Commit Count.
|
| 8 |
PROCESSING_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies the level for the Processing Count. When Processing Count is not zero, Processing Level must be greater than or equal to Commit Level.
10=Request
20=Order
30=Line
|
| 9 |
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.
|
| 10 |
COMMIT_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies the level for the Commit Count. When Commit Count is not zero, Commit Level must be less than or equal to Processing Level.
10=Request
20=Order
30=Line
40=Item
|
| 11 |
SELECT_UNFULFILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit
Default Value: N
|
| 12 |
SELECT_RELEASABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit
Default Value: N
|
| 13 |
SELECT_CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit
Default Value: N
|
| 14 |
SELECT_RELEASED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Released state.
|
| 15 |
SELECT_SHIPPED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the Fulfillment Engine should include data in an Picked state.
|
| 16 |
SELECT_DEPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
|
| 17 |
SETID_CARRIER |
Character(5) |
VARCHAR2(5) NOT NULL |
Carrier Setid
|
| 18 |
SETID_MST_ITEM |
Character(5) |
VARCHAR2(5) NOT NULL |
Master Item SETID
|
| 19 |
SETID_INV_ITEM |
Character(5) |
VARCHAR2(5) NOT NULL |
Inv Items SETID
|
| 20 |
SETID_INV_ITEMS |
Character(5) |
VARCHAR2(5) NOT NULL |
Inv Items SETID
|
| 21 |
SETID_SHIP_METHOD |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship Method SetID
|
| 22 |
SETID_FREIGHT |
Character(5) |
VARCHAR2(5) NOT NULL |
Freight Terms SETID
|
| 23 |
SETID_DISTRIB_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Distribution Type SetID
|
| 24 |
SETID_DEPTID |
Character(20) |
VARCHAR2(20) NOT NULL |
Concatenated SETID, seperator and DEPTID
|
| 25 |
SETID_REASON_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Reason CD SetID
|
| 26 |
SETID_CM_TRANS |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 27 |
SETID_FERC |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 28 |
SETID_HOLD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 29 |
SETID_INV_ORDER |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 30 |
SETID_PACK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 31 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 32 |
SETID_SETUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Setup SetID
|
| 33 |
SETID_BU_ATTRIBUTE |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID BU Attributes
|
| 34 |
SETID_PRODUCT |
Character(5) |
VARCHAR2(5) NOT NULL |
Product SetID
|
| 35 |
SETID_CUSTOMER |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 36 |
SETID_CONTAINER |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 37 |
SETID_CUST_OPTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 38 |
SETID_CUST_SHIPTO |
Character(5) |
VARCHAR2(5) NOT NULL |
Shipto Cust SetID
|
| 39 |
SETID_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier Setid
|
| 40 |
USE_CLOSE_CAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Closure Calendar
|
| 41 |
ADHOC_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Adhoc Requisitions
|
| 42 |
FRT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Rule Code
|
| 43 |
FRT_CHRG_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
|
| 44 |
FRT_CHRG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Charge Override
|
| 45 |
DFLT_SHP_LOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Ship Location Option
1=Default Ship Staging Location
2=Default Cross Docking Location
3=Default Putaway Location
4=Default Inspection Location
5=Default Fixed Picking Bin Loc
6=Manually Entered Location
7=Default Pegging Location
Default Value: 1
|
| 46 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 47 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 48 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 49 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 50 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
|
| 51 |
AUTO_BCK_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Backorder Approval
|
| 52 |
UOM_CONV_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
UOM Conversion Flag
0=Use Entered UOM
1=Convert to Standard UOM
2=Convert to Default Stock UOM
|
| 53 |
LOG_ERROR_OPTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Log Errors Option
BT=Transaction Error Log
ML=Message Log
|
| 54 |
ALLOC_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Sort Option
D=Date
O=Order Nbr
P=Priority
|
| 55 |
ALLOW_NEG_INV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Negative Inventory
|
| 56 |
INCL_QUAR_AVAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Incl Non-Open in Avail Qty
|
| 57 |
RELEASE_LOCKS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
When selected this option allows locks to be released on all but the first processing group of data once the processing groups are determined.
|
| 58 |
INTERUNIT_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interunit BackOrders
|
| 59 |
AUTO_DEPL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Depletion
|
| 60 |
ALLOC_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Reservation Lead Days
|
| 61 |
ATP_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field determines the window in which an order line can be ATP-reserved. If the scheduled shipment date is within today + ATP lead days, then the order line may be ATP-reserved; if the scheduled shipment date is outside this window, the order line cannot be ATP-reserved.
|
| 62 |
AUTO_PRT_APPROVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Partial Qty Approval
|
| 63 |
MAX_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Lead Days
|
| 64 |
ALLOW_OVERRIDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override of Lead Days
|
| 65 |
OVERRIDE_RLS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override AutoRls Options
|
| 66 |
PTWY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Putaway Option
1=Stage for Putaway
2=Putaway at Save
|
| 67 |
AUTO_RELEASE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Auto Release Option
00=No Auto-Processing
10=Use Auto-Processing Default
20=Advance to Reserved
30=Advance to Releasable
40=Advance to Released
50=Advance to Confirmed
60=Advance to Shipped
70=Advance to Depleted
|
| 68 |
RLS_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 69 |
OPRID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 70 |
IN_VRFY_SHP_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Ship Date
|
| 71 |
IN_VRFY_SHP_TM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Verify Ship Time
|
| 72 |
COMPLETE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complete Flag
0=Process Location
1=Pick Line Complete
2=Pick Batch Complete
3=Pick Line as Planned
4=Pick Batch as Planned
5=Process Location - Incomplete
6=Complete Pick - Zero Quantity
7=Complete Pick - Leave Alone
8=Complete Pick - Dft Ship Loc
A=Use Defaults
B=No Action
|
| 73 |
IN_NEG_AVL_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Available Qty Allowed
|
| 74 |
SHIP_DOC_WARNING |
Character(1) |
VARCHAR2(1) NOT NULL |
Alert User if Shipment Changes
|
| 75 |
SHIP_DOC_EARLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Printing Before Shipping
|
| 76 |
CLR_TRK_AT_DEPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Clear Tracking Info at Deplete
|
| 77 |
IN_RLS_KMULT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether kits should be released as whole multiples
|
| 78 |
IN_DFR_DPL_BU_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Defer Depletions Default
1=Default Defer Depletions to Y
2=Default Defer Depletions to N
3=Do not use this feature
|