| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 2 |
TSE_TRIGGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Perform Validation
Y/N Table Edit
Default Value: Y
|
| 3 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_AREA_VW2
|
| 4 |
STOR_LEVEL_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table:
STOR_LEV1_VW2
|
| 5 |
STOR_LEVEL_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table:
STOR_LEV2_VW2
|
| 6 |
STOR_LEVEL_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table:
STOR_LEV3_VW2
|
| 7 |
STOR_LEVEL_4 |
Character(4) |
VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table:
STOR_LEV4_VW2
|
| 8 |
PRINT_BARCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Code on Report Flag
Y/N Table Edit
Default Value: N
|
| 9 |
PRINT_BARCD_CTLFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bar Coded Control Flags
Y/N Table Edit
Default Value: N
|
| 10 |
PTWYPLAN_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Putaway Plan Selection Option
0=All Staging IDs
1=Specific Staging ID
Default Value: 0
|
| 11 |
PTWYPLAN_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Putaway Plan Sort Order
0=Item ID
1=Receiver ID
2=Storage Location
Default Value: 2
|
| 12 |
DIRECT_PTWY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Directed Putaway
Y/N Table Edit
Default Value: N
|
| 13 |
INCL_NON_NET_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Nettable Locations
Y/N Table Edit
Default Value: Y
|
| 14 |
INCL_SUSPEND_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Suspended Locations
Y/N Table Edit
Default Value: Y
|
| 15 |
INCL_HOLD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Locations
Y/N Table Edit
Default Value: Y
|
| 16 |
INCL_WIP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
WIP Locations
Y/N Table Edit
Default Value: Y
|
| 17 |
INCL_PHYS_CYC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Cyclic Locations
Y/N Table Edit
Default Value: Y
|
| 18 |
INCL_SHIP_STG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Ship Staging Location
Y/N Table Edit
Default Value: Y
|
| 19 |
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.
|