SHIP_METHOD(SQL Table) |
Index Back |
|---|---|
Shipping Method TableThis record stores the shipping methods or carriers any shipment. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SHIP_TYPE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | CUST_PICKUP | Character(1) | VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No Y=Yes Default Value: N |
| 6 | MAX_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Max Weight Capacity |
| 7 | MAX_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Ship Maximum Volume |
| 8 | MIN_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Minimum Weight |
| 9 | MIN_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Minimum Volume |
| 10 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_WT_VW |
| 11 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_VOL_VW |
| 12 | IST_TRANSPORT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Mode of Transport for Intrastat Reporting
1=Transport by Sea 2=Transport by Rail 3=Transport by Road 4=Transport by Air 5=Consignments by Post 7=Fixed Transport Installations 8=Transport by Inland Waterway 9=Own Propulsion |