| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LINE_NO |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 2 |
RESP_RETURN_CD |
Number(5,0) |
INTEGER NOT NULL |
Return code when call to an EIP was unsuccessful.
|
| 3 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 4 |
INTERUNIT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to store the interunit id associated with material that was ordered.
|
| 5 |
INTERUNIT_LINE |
Number(5,0) |
INTEGER NOT NULL |
InterUnit Order Line
|
| 6 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
|
| 7 |
SOURCE_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Bus Unit
|
| 8 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 9 |
LOT_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Lot Control
|
| 10 |
SERIAL_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Serial Control
|
| 11 |
SHIP_SERIAL_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Shipping Serial Control
|
| 12 |
TOTAL_QTY_SHIPPED |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total quantity shipped - returned from Inventory request.
|
| 13 |
TOTAL_QTY_OPEN |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Total quantity open on an order - returned from Inventory request.
|
| 14 |
UNIT_MEASURE_STD |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to store the unit of measure for an item.
|