Generic tbl

From UG

Revision as of 00:12, 9 December 2009 (edit) Alex (Talk | contribs) (Created page with ' <pre> mysql> describe tblGenericShipment; +-------------------------------------+---------------+------+-----+---------+----------------+ | Field |…') ← Older edit		Current revision as of 21:42, 21 May 2010 (edit) (undo) Alex (Talk | contribs) (→ShipperAddressId)
(22 intermediate revisions not shown)
Line 1:		Line 1:
		+	[[Category:Shipment Data Objects]]
		+
		+	== Related bo wiki ==
		+	[[CT bo]]
		+
		+	== MySQL Table Definitions ==
		+
		+	on 08-Apr-2010
	<pre>		<pre>
	mysql> describe tblGenericShipment;		mysql> describe tblGenericShipment;
		+
	+-------------------------------------+---------------+------+-----+---------+----------------+		+-------------------------------------+---------------+------+-----+---------+----------------+
	| Field                              | Type          | Null | Key | Default | Extra          |		| Field                              | Type          | Null | Key | Default | Extra          |
Line 38:		Line 47:
	| Jaguar3rdRef                        | varchar(30)  | YES  |    | NULL    |                |		| Jaguar3rdRef                        | varchar(30)  | YES  |    | NULL    |                |
	| MasterId                            | int(10)      | YES  | MUL | NULL    |                |		| MasterId                            | int(10)      | YES  | MUL | NULL    |                |
-	| IsDeleted                          | bit(1)        | NO  |    |	+	| IsDeleted                          | bit(1)        | NO  |    | b'0'    |                |
	| LastModifiedUserId                  | int(10)      | YES  | MUL | NULL    |                |		| LastModifiedUserId                  | int(10)      | YES  | MUL | NULL    |                |
	| CreatedOnDate                      | datetime      | YES  |    | NULL    |                |		| CreatedOnDate                      | datetime      | YES  |    | NULL    |                |
Line 58:		Line 67:
	| TableOfChargesId                    | int(10)      | YES  | MUL | NULL    |                |		| TableOfChargesId                    | int(10)      | YES  | MUL | NULL    |                |
	| SalesPersonId                      | int(10)      | YES  | MUL | NULL    |                |		| SalesPersonId                      | int(10)      | YES  | MUL | NULL    |                |
		+	| CreatedByOfficeId                  | int(10)      | NO  | MUL | 1      |                |
	+-------------------------------------+---------------+------+-----+---------+----------------+		+-------------------------------------+---------------+------+-----+---------+----------------+
-	53 rows in set	+	54 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 b'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,
		+	`CreatedByOfficeId` int(10) NOT NULL DEFAULT '1',
		+	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`),
		+	KEY `CreatedByOfficeId` (`CreatedByOfficeId`),
		+	CONSTRAINT `fkCreatedByOfficeId` FOREIGN KEY (`CreatedByOfficeId`) REFERENCES `tbloffice` (`Id`) ON UPDATE CASCADE,
		+	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=300054 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci'
		+	COMMENT='InnoDB free: 9216 kB; (`ShipmentGroupId`) REFER `cybertrax/t';
		+
	</pre>		</pre>
-	[[Category:DB]]	+	==  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 b'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
		+
		+	=== CreatedByOfficeId ===
		+	` int(10) NOT NULL DEFAULT '1'

---

Current revision as of 21:42, 21 May 2010

Contents 1 Related bo wiki 2 MySQL Table Definitions 3 Fields 3.1 Id 3.2 ClientCompanyId 3.3 ShipperAddressId 3.4 ShipperAddressDescription 3.5 ConsigneeAddressId 3.6 ConsigneeAddressDescription 3.7 NotifyAddressId 3.8 NotifyAddressDescription 3.9 PickupAddressId 3.10 PickupAddressDescription 3.11 GeneralDeliveryToAddressId 3.12 GeneralDeliveryToAddressDescription 3.13 PickupComments 3.14 PickupTruckerId 3.15 EstimatedPickupDate 3.16 ActualPickupDate 3.17 OriginPoint 3.18 DestinationPoint 3.19 TransportModeId 3.20 ClientModeId 3.21 ShippingTermId 3.22 ShippingTermLocation 3.23 CommodityDescription 3.24 MarksOrNumber 3.25 AuthorizedBy 3.26 AuthorizedDate 3.27 EstimatedDeliveryDate 3.28 AuthorizationMethodId 3.29 ExportRef 3.30 ImportRef 3.31 CustomerRef 3.32 Jaguar3rdRef 3.33 MasterId 3.34 IsDeleted 3.35 LastModifiedUserId 3.36 CreatedOnDate 3.37 IsDimsMode 3.38 TotalHUInCubicMeters 3.39 TotalHUInCubicFeets 3.40 OriginPointCountryId 3.41 DestinationPointCountryId 3.42 ShipmentGroupId 3.43 NotificationDate 3.44 EnabledTransShipment 3.45 EnabledOriginTerminal 3.46 EnabledDestinationTerminal 3.47 ShowPickupAddress 3.48 ShowDeliveryToAddress 3.49 ShowOriginPointCountry 3.50 ShowDestinationPointCountry 3.51 AuthorizedMOT 3.52 TableOfChargesId 3.53 SalesPersonId 3.54 CreatedByOfficeId

[edit] Related bo wiki

CT bo

[edit] MySQL Table Definitions

on 08-Apr-2010

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   |     | b'0'    |                |
| 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    |                |
| CreatedByOfficeId                   | int(10)       | NO   | MUL | 1       |                |
+-------------------------------------+---------------+------+-----+---------+----------------+
54 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 b'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,
  `CreatedByOfficeId` int(10) NOT NULL DEFAULT '1',
  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`),
  KEY `CreatedByOfficeId` (`CreatedByOfficeId`),
  CONSTRAINT `fkCreatedByOfficeId` FOREIGN KEY (`CreatedByOfficeId`) REFERENCES `tbloffice` (`Id`) ON UPDATE CASCADE,
  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=300054 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci'
COMMENT='InnoDB free: 9216 kB; (`ShipmentGroupId`) REFER `cybertrax/t';

[edit] Fields

[edit] Id

` int(10) NOT NULL AUTO_INCREMENT

[edit] ClientCompanyId

` int(10) NOT NULL

[edit] ShipperAddressId

` int(10) DEFAULT NULL

[edit] ShipperAddressDescription

` varchar(1500) DEFAULT NULL

[edit] ConsigneeAddressId

` int(10) DEFAULT NULL

[edit] ConsigneeAddressDescription

` varchar(1500) DEFAULT NULL

[edit] NotifyAddressId

` int(10) DEFAULT NULL

[edit] NotifyAddressDescription

` varchar(1500) DEFAULT NULL

[edit] PickupAddressId

` int(10) DEFAULT NULL

[edit] PickupAddressDescription

` varchar(1500) DEFAULT NULL

[edit] GeneralDeliveryToAddressId

` int(10) DEFAULT NULL

[edit] GeneralDeliveryToAddressDescription

` varchar(1500) DEFAULT NULL

[edit] PickupComments

` varchar(1500) DEFAULT NULL

[edit] PickupTruckerId

` int(10) DEFAULT NULL

[edit] EstimatedPickupDate

` date DEFAULT NULL

[edit] ActualPickupDate

` date DEFAULT NULL

[edit] OriginPoint

` varchar(30) DEFAULT NULL

[edit] DestinationPoint

` varchar(30) DEFAULT NULL

[edit] TransportModeId

` int(10) DEFAULT NULL

[edit] ClientModeId

` int(10) DEFAULT NULL

[edit] ShippingTermId

` int(10) DEFAULT NULL

[edit] ShippingTermLocation

` varchar(30) DEFAULT NULL

[edit] CommodityDescription

` varchar(1500) DEFAULT NULL

[edit] MarksOrNumber

` varchar(1500) DEFAULT NULL

[edit] AuthorizedBy

` varchar(30) DEFAULT NULL

[edit] AuthorizedDate

` date DEFAULT NULL

[edit] EstimatedDeliveryDate

` date DEFAULT NULL

[edit] AuthorizationMethodId

` int(10) DEFAULT NULL

[edit] ExportRef

` varchar(30) default NULL,

[edit] ImportRef

` varchar(30) default NULL,

[edit] CustomerRef

` varchar(30) default NULL,

[edit] Jaguar3rdRef

` varchar(30) default NULL,

[edit] MasterId

` int(10) DEFAULT NULL

[edit] IsDeleted

` bit(1) NOT NULL DEFAULT b'0'

[edit] LastModifiedUserId

` int(10) DEFAULT NULL

[edit] CreatedOnDate

` datetime DEFAULT NULL

[edit] IsDimsMode

` tinyint(1) NOT NULL DEFAULT '0'

[edit] TotalHUInCubicMeters

` double DEFAULT '0'

[edit] TotalHUInCubicFeets

` double DEFAULT '0'

[edit] OriginPointCountryId

` int(10) DEFAULT NULL

[edit] DestinationPointCountryId

` int(10) DEFAULT NULL

[edit] ShipmentGroupId

` int(10) DEFAULT NULL

[edit] NotificationDate

` date DEFAULT NULL

[edit] EnabledTransShipment

` tinyint(1) DEFAULT '0'

[edit] EnabledOriginTerminal

` tinyint(1) DEFAULT '0'

[edit] EnabledDestinationTerminal

` tinyint(1) DEFAULT '0'

[edit] ShowPickupAddress

` tinyint(1) DEFAULT '0'

[edit] ShowDeliveryToAddress

` tinyint(1) DEFAULT '0'

[edit] ShowOriginPointCountry

` tinyint(1) DEFAULT '0'

[edit] ShowDestinationPointCountry

` tinyint(1) DEFAULT '0'

[edit] AuthorizedMOT

` int(10) DEFAULT NULL

[edit] TableOfChargesId

` int(10) DEFAULT NULL

[edit] SalesPersonId

` int(10) DEFAULT NULL

[edit] CreatedByOfficeId

` int(10) NOT NULL DEFAULT '1'