| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 3 |
BUS_UNIT_SOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Business Unit
|
| 4 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 5 |
SEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
|
| 6 |
PL_ROW_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Row Exist
|
| 7 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 8 |
TRANSFER_MIN_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/26/02: Added label PL_TRANS_MIN_ORDER
|
| 9 |
TRANSFER_MAX_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Max Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/26/02: Added label PL_TRANS_MAX_ORDER
|
| 10 |
TRANS_ORD_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
|
| 11 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
|
| 12 |
TRANSIT_COST |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Transportation Cost
|