PL_TRANS_IT_OPT(SQL Table) |
Index Back |
---|---|
Item Transfer Options08/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 |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | BUS_UNIT_SOURCE | Character(5) | VARCHAR2(5) NOT NULL | Source Business Unit |
4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
5 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
6 | 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 |
7 | INTRANSIT_DAYS | Number(16,4) | DECIMAL(15,4) NOT NULL | Intransit Days |
8 | INTRANSIT_HOURS | Number(16,4) | DECIMAL(15,4) NOT NULL | Intransit Hours |
9 | 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 |
10 | 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 |
11 | 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 |
12 | TRANSFER_YIELD | Number(5,1) | DECIMAL(4,1) NOT NULL | Transfer Yield |
13 | PL_UNIT_COST | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | 09/27/02 EGS (CN#PL880-1): Changed to 13.4 |
14 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |