SDK_UPS_COST(SQL Table) |
Index Back |
|---|---|
SDK UPS CostSDK UPS Cost |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDK_ORIGIN_CNTRY | Character(1) | VARCHAR2(1) NOT NULL |
SDK Country of Origin
P=Puerto Rico U=United States |
| 2 | SDK_FROM_POST_CODE | Character(10) | VARCHAR2(10) NOT NULL | SDK From Postal Code |
| 3 | SDK_COUNTRY_DEST | Character(3) | VARCHAR2(3) NOT NULL |
SDK Country Destination
Prompt Table: SDK_COUNTRY_TBL |
| 4 | SDK_TO_POST_CODE | Character(10) | VARCHAR2(10) NOT NULL | SDK To Post Code - Post/Zip Code of the To Location |
| 5 | SDK_ADDRESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | SDK Address Type |
| 6 | SDK_DROP_PICKUP | Character(1) | VARCHAR2(1) NOT NULL |
SDK Drop / Pickup
A=On Call Air L=Letter O=One Time Pickup R=Regular Daily |
| 7 | SDK_UPS_PACKAGING | Character(1) | VARCHAR2(1) NOT NULL |
SDK UPS Packaging
E=UPS Express Box L=UPS Letter Envelope T=UPS Tube Y=Your Packaging |
| 8 | SDK_UPS_WEIGHT | Number(3,0) | SMALLINT NOT NULL | SDK UPS Weight - Package Weight |
| 9 | SDK_UPS_LENGTH | Number(3,0) | SMALLINT NOT NULL | SDK UPS Length |
| 10 | SDK_UPS_WIDTH | Number(3,0) | SMALLINT NOT NULL | SDK UPS Width |
| 11 | SDK_UPS_HEIGHT | Number(3,0) | SMALLINT NOT NULL | SDK UPS Height |
| 12 | SDK_UPS_TRACK_BTN | Character(1) | VARCHAR2(1) NOT NULL | SDK UPS Track Button |