PL_TRANS_OPT

(SQL Table)
Index Back

Generic Transfer Options

08/16/01 EGS (CN#PL900-1.0): Added

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

Prompt Table: SP_PRBINS_NONVW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: PL_PI_BU_IN_VW

3 BUS_UNIT_SOURCE Character(5) VARCHAR2(5) NOT NULL Source Business Unit

Prompt Table: PL_PI_BU_IN_VW

4 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
5 PL_TRANSFER_TYPE Character(1) VARCHAR2(1) NOT NULL 10/04/01 EGS (CN#PL900-1): Added.
1=Double Sided
2=Single Sided Supply
3=Single Sided Demand

Default Value: 1

6 INTRANSIT_DAYS Number(16,4) DECIMAL(15,4) NOT NULL Intransit Days
7 INTRANSIT_HOURS Number(16,4) DECIMAL(15,4) NOT NULL Intransit Hours
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 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference