Generic tbl

From UG

(Difference between revisions)
Jump to: navigation, search
Line 166: Line 166:
   CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblShippingTerm` (`Id`)
   CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblShippingTerm` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=251003 DEFAULT CHARSET=latin1;
) ENGINE=InnoDB AUTO_INCREMENT=251003 DEFAULT CHARSET=latin1;
-
 
-
 
-
 
-
 
</pre>
</pre>
-
== Related Business Object and Fields ==
+
== Fields ==
-
 
+
-
 
+
-
=== Id ===                           
+
-
 
+
-
* '''properties:'''
+
-
 
+
-
=== ClientCompanyId ===
+
-
 
+
-
* '''properties:'''
+
-
             
+
-
=== ShipperAddressId  === 
+
-
       
+
-
* '''properties:'''
+
-
 
+
-
=== ShipperAddressDescription  ===
+
-
 
+
-
* '''properties:'''  varchar(1500) 
+
-
 
+
-
=== ConsigneeAddressId  ===
+
-
 
+
-
* '''properties:'''    int(10)   
+
-
 
+
-
=== ConsigneeAddressDescription    ===
+
-
 
+
-
* '''properties:'''    | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== NotifyAddressId  ===
+
-
 
+
-
* '''properties:'''                  | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== NotifyAddressDescription ===
+
-
 
+
-
* '''properties:'''          | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== PickupAddressId    ===
+
-
 
+
-
* '''properties:'''                | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== PickupAddressDescription  ===
+
-
 
+
-
* '''properties:'''        | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== GeneralDeliveryToAddressId  ===
+
-
 
+
-
* '''properties:'''      | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== GeneralDeliveryToAddressDescription ===
+
-
 
+
-
* '''properties:''' | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== PickupComments  ===
+
-
 
+
-
* '''properties:'''                  | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== PickupTruckerId  ===
+
-
 
+
-
* '''properties:'''                  | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== EstimatedPickupDate  ===
+
-
 
+
-
* '''properties:'''              | date          | YES  |    | NULL    |                |
+
-
 
+
-
=== ActualPickupDate  ===
+
-
 
+
-
* '''properties:'''| date          | YES  |    | NULL    |                |
+
-
 
+
-
=== OriginPoint  ===
+
-
 
+
-
* '''properties:'''                      | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
=== DestinationPoint    ===
+
-
 
+
-
* ''properties:''              | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
=== TransportModeId    ===
+
-
 
+
-
* ''properties:''                | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== ClientModeId      ===
+
-
 
+
-
* ''properties:''                | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== ShippingTermId  ===
+
-
 
+
-
* ''properties:''                  | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== ShippingTermLocation  ===
+
-
 
+
-
* ''properties:''            | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
=== CommodityDescription  ===
+
-
 
+
-
* ''properties:''            | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== MarksOrNumber          ===
+
-
 
+
-
* ''properties:''            | varchar(1500) | YES  |    | NULL    |                |
+
-
 
+
-
=== AuthorizedBy      ===
+
-
 
+
-
* ''properties:''                | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
=== AuthorizedDate    ===
+
-
 
+
-
* ''properties:''                | date          | YES  |    | NULL    |                |
+
-
 
+
-
=== EstimatedDeliveryDate    ===
+
-
 
+
-
* ''properties:''          | date          | YES  |    | NULL    |                |
+
-
 
+
-
=== AuthorizationMethodId  ===
+
-
 
+
-
* ''properties:''            | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
=== ExportRef ===
+
-
+
-
* ''properties:''    varchar(30)  | YES  |    | NULL    |         
+
-
 
+
-
=== ImportRef    ===
+
-
 
+
-
* ''properties:''                      | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
=== CustomerRef  ===
+
-
 
+
-
* ''properties:''                      | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
=== Jaguar3rdRef  ===
+
-
 
+
-
* ''properties:''                      | varchar(30)  | YES  |    | NULL    |                |
+
-
 
+
-
===  MasterId  ===                         
+
-
 
+
-
* ''properties:''      | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
===  IsDeleted  ===                       
+
-
 
+
-
* ''properties:''        | bit(1)        | NO  |    |
+
-
 
+
-
===  LastModifiedUserId  ===               
+
-
 
+
-
* ''properties:''    | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
===  CreatedOnDate    ===                 
+
-
 
+
-
* ''properties:''    | datetime      | YES  |    | NULL    |                |
+
-
 
+
-
===  IsDimsMode      ===                   
+
-
 
+
-
* ''properties:''  | tinyint(1)    | NO  |    | 0      |                |
+
-
 
+
-
===  TotalHUInCubicMeters    ===           
+
-
 
+
-
* ''properties:''  | double        | YES  |    | 0      |                |
+
-
 
+
-
===  TotalHUInCubicFeets    ===             
+
-
 
+
-
* ''properties:''    | double        | YES  |    | 0      |                |
+
-
 
+
-
===  OriginPointCountryId  ===             
+
-
 
+
-
* ''properties:''    | int(10)      | YES  |    | NULL    |                |
+
-
 
+
-
 
+
-
===  DestinationPointCountryId  ===       
+
-
 
+
-
* ''properties:''    | int(10)      | YES  |    | NULL    |                |
+
-
 
+
-
===  ShipmentGroupId    ===               
+
-
 
+
-
* ''properties:''    | int(10)      | YES  | MUL | NULL    |                |
+
-
 
+
-
===  NotificationDate    ===               
+
-
 
+
-
* ''properties:''  | date          | YES  |    | NULL    |                |
+
-
 
+
-
===  EnabledTransShipment    ===           
+
-
 
+
-
* ''properties:'' | tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  EnabledOriginTerminal    ===         
+
-
 
+
-
* ''properties:'' | tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  EnabledDestinationTerminal  ===     
+
-
 
+
-
* ''properties:'' | tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  ShowPickupAddress    ===             
+
-
 
+
-
* ''properties:'' | tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  ShowDeliveryToAddress  ===           
+
-
 
+
-
* ''properties:''| tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  ShowOriginPointCountry  ===           
+
-
 
+
-
* ''properties:''| tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  ShowDestinationPointCountry  ===     
+
-
 
+
-
* ''properties:'' | tinyint(1)    | YES  |    | 0      |                |
+
-
 
+
-
===  AuthorizedMOT  ===                   
+
-
 
+
-
* ''properties:''| int(10)      | YES  |    | NULL    |                |
+
-
=== TableOfChargesId    ===                
+
===Id===
 +
` int(10) NOT NULL auto_increment
-
* ''properties:''| int(10)       | YES  | MUL | NULL   |                |
+
===ClientCompanyId===
 +
` int(10) NOT NULL  
-
=== SalesPersonId  ===                    
+
===ShipperAddressId===
 +
` int(10) default NULL
-
* ''properties:''| int(10)      | YES  | MUL | NULL    |                |
 
-
+-------------------------------------+---------------+------+-----+---------+----------------+
+
  `ShipperAddressDescription` varchar(1500) default NULL,
 +
  `ConsigneeAddressId` int(10) default NULL,
 +
  `ConsigneeAddressDescription` varchar(1500) default NULL,
 +
  `NotifyAddressId` int(10) default NULL,
 +
  `NotifyAddressDescription` varchar(1500) default NULL,
 +
  `PickupAddressId` int(10) default NULL,
 +
  `PickupAddressDescription` varchar(1500) default NULL,
 +
  `GeneralDeliveryToAddressId` int(10) default NULL,
 +
  `GeneralDeliveryToAddressDescription` varchar(1500) default NULL,
 +
  `PickupComments` varchar(1500) default NULL,
 +
  `PickupTruckerId` int(10) default NULL,
 +
  `EstimatedPickupDate` date default NULL,
 +
  `ActualPickupDate` date default NULL,
 +
  `OriginPoint` varchar(30) default NULL,
 +
  `DestinationPoint` varchar(30) default NULL,
 +
  `TransportModeId` int(10) default NULL,
 +
  `ClientModeId` int(10) default NULL,
 +
  `ShippingTermId` int(10) default NULL,
 +
  `ShippingTermLocation` varchar(30) default NULL,
 +
  `CommodityDescription` varchar(1500) default NULL,
 +
  `MarksOrNumber` varchar(1500) default NULL,
 +
  `AuthorizedBy` varchar(30) default NULL,
 +
  `AuthorizedDate` date default NULL,
 +
  `EstimatedDeliveryDate` date default NULL,
 +
  `AuthorizationMethodId` int(10) default NULL,
 +
  `ExportRef` varchar(30) default NULL,
 +
  `ImportRef` varchar(30) default NULL,
 +
  `CustomerRef` varchar(30) default NULL,
 +
  `Jaguar3rdRef` varchar(30) default NULL,
 +
  `MasterId` int(10) default NULL,
 +
  `IsDeleted` bit(1) NOT NULL default '\0',
 +
  `LastModifiedUserId` int(10) default NULL,
 +
  `CreatedOnDate` datetime default NULL,
 +
  `IsDimsMode` tinyint(1) NOT NULL default '0',
 +
  `TotalHUInCubicMeters` double default '0',
 +
  `TotalHUInCubicFeets` double default '0',
 +
  `OriginPointCountryId` int(10) default NULL,
 +
  `DestinationPointCountryId` int(10) default NULL,
 +
  `ShipmentGroupId` int(10) default NULL,
 +
  `NotificationDate` date default NULL,
 +
  `EnabledTransShipment` tinyint(1) default '0',
 +
  `EnabledOriginTerminal` tinyint(1) default '0',
 +
  `EnabledDestinationTerminal` tinyint(1) default '0',
 +
  `ShowPickupAddress` tinyint(1) default '0',
 +
  `ShowDeliveryToAddress` tinyint(1) default '0',
 +
  `ShowOriginPointCountry` tinyint(1) default '0',
 +
  `ShowDestinationPointCountry` tinyint(1) default '0',
 +
  `AuthorizedMOT` int(10) default NULL,
 +
  `TableOfChargesId` int(10) default NULL,
 +
  `SalesPersonId` int(10) default NULL,

Revision as of 19:49, 3 February 2010


Contents

Related bo wiki

CT bo

MySQL table

mysql> describe tblGenericShipment;
+-------------------------------------+---------------+------+-----+---------+----------------+
| Field                               | Type          | Null | Key | Default | Extra          |
+-------------------------------------+---------------+------+-----+---------+----------------+
| Id                                  | int(10)       | NO   | PRI | NULL    | auto_increment |
| ClientCompanyId                     | int(10)       | NO   | MUL | NULL    |                |
| ShipperAddressId                    | int(10)       | YES  | MUL | NULL    |                |
| ShipperAddressDescription           | varchar(1500) | YES  |     | NULL    |                |
| ConsigneeAddressId                  | int(10)       | YES  | MUL | NULL    |                |
| ConsigneeAddressDescription         | varchar(1500) | YES  |     | NULL    |                |
| NotifyAddressId                     | int(10)       | YES  | MUL | NULL    |                |
| NotifyAddressDescription            | varchar(1500) | YES  |     | NULL    |                |
| PickupAddressId                     | int(10)       | YES  | MUL | NULL    |                |
| PickupAddressDescription            | varchar(1500) | YES  |     | NULL    |                |
| GeneralDeliveryToAddressId          | int(10)       | YES  | MUL | NULL    |                |
| GeneralDeliveryToAddressDescription | varchar(1500) | YES  |     | NULL    |                |
| PickupComments                      | varchar(1500) | YES  |     | NULL    |                |
| PickupTruckerId                     | int(10)       | YES  | MUL | NULL    |                |
| EstimatedPickupDate                 | date          | YES  |     | NULL    |                |
| ActualPickupDate                    | date          | YES  |     | NULL    |                |
| OriginPoint                         | varchar(30)   | YES  |     | NULL    |                |
| DestinationPoint                    | varchar(30)   | YES  |     | NULL    |                |
| TransportModeId                     | int(10)       | YES  | MUL | NULL    |                |
| ClientModeId                        | int(10)       | YES  | MUL | NULL    |                |
| ShippingTermId                      | int(10)       | YES  | MUL | NULL    |                |
| ShippingTermLocation                | varchar(30)   | YES  |     | NULL    |                |
| CommodityDescription                | varchar(1500) | YES  |     | NULL    |                |
| MarksOrNumber                       | varchar(1500) | YES  |     | NULL    |                |
| AuthorizedBy                        | varchar(30)   | YES  |     | NULL    |                |
| AuthorizedDate                      | date          | YES  |     | NULL    |                |
| EstimatedDeliveryDate               | date          | YES  |     | NULL    |                |
| AuthorizationMethodId               | int(10)       | YES  | MUL | NULL    |                |
| ExportRef                           | varchar(30)   | YES  |     | NULL    |                |
| ImportRef                           | varchar(30)   | YES  |     | NULL    |                |
| CustomerRef                         | varchar(30)   | YES  |     | NULL    |                |
| Jaguar3rdRef                        | varchar(30)   | YES  |     | NULL    |                |
| MasterId                            | int(10)       | YES  | MUL | NULL    |                |
| IsDeleted                           | bit(1)        | NO   |     | 
| LastModifiedUserId                  | int(10)       | YES  | MUL | NULL    |                |
| CreatedOnDate                       | datetime      | YES  |     | NULL    |                |
| IsDimsMode                          | tinyint(1)    | NO   |     | 0       |                |
| TotalHUInCubicMeters                | double        | YES  |     | 0       |                |
| TotalHUInCubicFeets                 | double        | YES  |     | 0       |                |
| OriginPointCountryId                | int(10)       | YES  |     | NULL    |                |
| DestinationPointCountryId           | int(10)       | YES  |     | NULL    |                |
| ShipmentGroupId                     | int(10)       | YES  | MUL | NULL    |                |
| NotificationDate                    | date          | YES  |     | NULL    |                |
| EnabledTransShipment                | tinyint(1)    | YES  |     | 0       |                |
| EnabledOriginTerminal               | tinyint(1)    | YES  |     | 0       |                |
| EnabledDestinationTerminal          | tinyint(1)    | YES  |     | 0       |                |
| ShowPickupAddress                   | tinyint(1)    | YES  |     | 0       |                |
| ShowDeliveryToAddress               | tinyint(1)    | YES  |     | 0       |                |
| ShowOriginPointCountry              | tinyint(1)    | YES  |     | 0       |                |
| ShowDestinationPointCountry         | tinyint(1)    | YES  |     | 0       |                |
| AuthorizedMOT                       | int(10)       | YES  |     | NULL    |                |
| TableOfChargesId                    | int(10)       | YES  | MUL | NULL    |                |
| SalesPersonId                       | int(10)       | YES  | MUL | NULL    |                |
+-------------------------------------+---------------+------+-----+---------+----------------+
53 rows in set




-- ----------------------------

-- Table structure for tblGenericShipment

-- ----------------------------

DROP TABLE IF EXISTS `tblGenericShipment`;

CREATE TABLE `tblGenericShipment` (
  `Id` int(10) NOT NULL auto_increment,
  `ClientCompanyId` int(10) NOT NULL,
  `ShipperAddressId` int(10) default NULL,
  `ShipperAddressDescription` varchar(1500) default NULL,
  `ConsigneeAddressId` int(10) default NULL,
  `ConsigneeAddressDescription` varchar(1500) default NULL,
  `NotifyAddressId` int(10) default NULL,
  `NotifyAddressDescription` varchar(1500) default NULL,
  `PickupAddressId` int(10) default NULL,
  `PickupAddressDescription` varchar(1500) default NULL,
  `GeneralDeliveryToAddressId` int(10) default NULL,
  `GeneralDeliveryToAddressDescription` varchar(1500) default NULL,
  `PickupComments` varchar(1500) default NULL,
  `PickupTruckerId` int(10) default NULL,
  `EstimatedPickupDate` date default NULL,
  `ActualPickupDate` date default NULL,
  `OriginPoint` varchar(30) default NULL,
  `DestinationPoint` varchar(30) default NULL,
  `TransportModeId` int(10) default NULL,
  `ClientModeId` int(10) default NULL,
  `ShippingTermId` int(10) default NULL,
  `ShippingTermLocation` varchar(30) default NULL,
  `CommodityDescription` varchar(1500) default NULL,
  `MarksOrNumber` varchar(1500) default NULL,
  `AuthorizedBy` varchar(30) default NULL,
  `AuthorizedDate` date default NULL,
  `EstimatedDeliveryDate` date default NULL,
  `AuthorizationMethodId` int(10) default NULL,
  `ExportRef` varchar(30) default NULL,
  `ImportRef` varchar(30) default NULL,
  `CustomerRef` varchar(30) default NULL,
  `Jaguar3rdRef` varchar(30) default NULL,
  `MasterId` int(10) default NULL,
  `IsDeleted` bit(1) NOT NULL default '\0',
  `LastModifiedUserId` int(10) default NULL,
  `CreatedOnDate` datetime default NULL,
  `IsDimsMode` tinyint(1) NOT NULL default '0',
  `TotalHUInCubicMeters` double default '0',
  `TotalHUInCubicFeets` double default '0',
  `OriginPointCountryId` int(10) default NULL,
  `DestinationPointCountryId` int(10) default NULL,
  `ShipmentGroupId` int(10) default NULL,
  `NotificationDate` date default NULL,
  `EnabledTransShipment` tinyint(1) default '0',
  `EnabledOriginTerminal` tinyint(1) default '0',
  `EnabledDestinationTerminal` tinyint(1) default '0',
  `ShowPickupAddress` tinyint(1) default '0',
  `ShowDeliveryToAddress` tinyint(1) default '0',
  `ShowOriginPointCountry` tinyint(1) default '0',
  `ShowDestinationPointCountry` tinyint(1) default '0',
  `AuthorizedMOT` int(10) default NULL,
  `TableOfChargesId` int(10) default NULL,
  `SalesPersonId` int(10) default NULL,
  PRIMARY KEY  (`Id`),
  KEY `GenericShipment_ClientCompanyId` (`ClientCompanyId`),
  KEY `GenericShipment_ShipperAddressId` (`ShipperAddressId`),
  KEY `GenericShipment_ConsigneeAddressId` (`ConsigneeAddressId`),
  KEY `GenericShipment_NotifyAddressId` (`NotifyAddressId`),
  KEY `GenericShipment_PickupAddressId` (`PickupAddressId`),
  KEY `GenericShipment_GeneralDeliveryToAddressId` (`GeneralDeliveryToAddressId`),
  KEY `GenericShipment_PickupTruckerId` (`PickupTruckerId`),
  KEY `GenericShipment_TransportModeId` (`TransportModeId`),
  KEY `GenericShipment_ShippingTermId` (`ShippingTermId`),
  KEY `GenericShipment_AuthorizationMethodId` (`AuthorizationMethodId`),
  KEY `GenericShipment_MasterId` (`MasterId`),
  KEY `GenericShipment_LastModifiedUserId` (`LastModifiedUserId`),
  KEY `tblGenericShipment_ibfk_27` (`ClientModeId`),
  KEY `ShipmentGroupId` (`ShipmentGroupId`),
  KEY `SalesPersonId` (`SalesPersonId`),
  KEY `TableOfChargesId` (`TableOfChargesId`),
  CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES `tblTableOfCharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES `tblShipmentGroup` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblAuthorizationMethod` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tblJaguarUser` (`Id`) ON UPDATE CASCADE,
  CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblMasterOcean` (`Id`) ON DELETE SET NULL,
  CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tblJaguarUser` (`Id`) ON DELETE SET NULL,
  CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblClientMode` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tblAddressJaguarVendor` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblClientCompany` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tblAddressTransportation` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_8` FOREIGN KEY (`TransportModeId`) REFERENCES `tblTransportMode` (`Id`),
  CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblShippingTerm` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=251003 DEFAULT CHARSET=latin1;


Fields

Id

` int(10) NOT NULL auto_increment

ClientCompanyId

` int(10) NOT NULL

ShipperAddressId

` int(10) default NULL


 `ShipperAddressDescription` varchar(1500) default NULL,
 `ConsigneeAddressId` int(10) default NULL,
 `ConsigneeAddressDescription` varchar(1500) default NULL,
 `NotifyAddressId` int(10) default NULL,
 `NotifyAddressDescription` varchar(1500) default NULL,
 `PickupAddressId` int(10) default NULL,
 `PickupAddressDescription` varchar(1500) default NULL,
 `GeneralDeliveryToAddressId` int(10) default NULL,
 `GeneralDeliveryToAddressDescription` varchar(1500) default NULL,
 `PickupComments` varchar(1500) default NULL,
 `PickupTruckerId` int(10) default NULL,
 `EstimatedPickupDate` date default NULL,
 `ActualPickupDate` date default NULL,
 `OriginPoint` varchar(30) default NULL,
 `DestinationPoint` varchar(30) default NULL,
 `TransportModeId` int(10) default NULL,
 `ClientModeId` int(10) default NULL,
 `ShippingTermId` int(10) default NULL,
 `ShippingTermLocation` varchar(30) default NULL,
 `CommodityDescription` varchar(1500) default NULL,
 `MarksOrNumber` varchar(1500) default NULL,
 `AuthorizedBy` varchar(30) default NULL,
 `AuthorizedDate` date default NULL,
 `EstimatedDeliveryDate` date default NULL,
 `AuthorizationMethodId` int(10) default NULL,
 `ExportRef` varchar(30) default NULL,
 `ImportRef` varchar(30) default NULL,
 `CustomerRef` varchar(30) default NULL,
 `Jaguar3rdRef` varchar(30) default NULL,
 `MasterId` int(10) default NULL,
 `IsDeleted` bit(1) NOT NULL default '\0',
 `LastModifiedUserId` int(10) default NULL,
 `CreatedOnDate` datetime default NULL,
 `IsDimsMode` tinyint(1) NOT NULL default '0',
 `TotalHUInCubicMeters` double default '0',
 `TotalHUInCubicFeets` double default '0',
 `OriginPointCountryId` int(10) default NULL,
 `DestinationPointCountryId` int(10) default NULL,
 `ShipmentGroupId` int(10) default NULL,
 `NotificationDate` date default NULL,
 `EnabledTransShipment` tinyint(1) default '0',
 `EnabledOriginTerminal` tinyint(1) default '0',
 `EnabledDestinationTerminal` tinyint(1) default '0',
 `ShowPickupAddress` tinyint(1) default '0',
 `ShowDeliveryToAddress` tinyint(1) default '0',
 `ShowOriginPointCountry` tinyint(1) default '0',
 `ShowDestinationPointCountry` tinyint(1) default '0',
 `AuthorizedMOT` int(10) default NULL,
 `TableOfChargesId` int(10) default NULL,
 `SalesPersonId` int(10) default NULL,
Personal tools