| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EIP_CTL_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Enterprise Components EIP (enterprise integration point) control field
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITM_INV_VW
|
| 4 |
PTWY_RULE |
Character(2) |
VARCHAR2(2) NOT NULL |
Putaway Rule
01=Default Location
02=Fixed Picking
03=Empty
04=Find Existing Item
05=Random
06=Containers
|
| 5 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
Default Value: 1
|
| 6 |
SPLIT_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Split Quantity
Y/N Table Edit
Default Value: N
|
| 7 |
MIX_DATE_LOT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mix Stage Dates and Lots
Y/N Table Edit
Default Value: N
|
| 8 |
MAX_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Maximum Capacity Available
Y/N Table Edit
Default Value: N
|
| 9 |
MIN_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Capacity Available
Y/N Table Edit
Default Value: N
|
| 10 |
ZONE_CHK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Zone
Y/N Table Edit
Default Value: N
|
| 11 |
DFLT_RULE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Rule Flag
Y/N Table Edit
Default Value: N
|
| 12 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|
| 13 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|