Generic tbl

From UG

Revision as of 00:56, 26 January 2010 (edit) Alex (Talk | contribs) (→links to fields) ← Older edit		Current revision as of 21:42, 21 May 2010 (edit) (undo) Alex (Talk | contribs) (→ShipperAddressId)
(17 intermediate revisions not shown)
Line 1:		Line 1:
-	== My sql table ==	+	[[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 39:		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 59:		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
-	</pre>	+
-	== links to fields ==	+	-- ----------------------------
		+	-- Table structure for tblGenericShipment
		+	-- ----------------------------
-	+-------------------------------------+---------------+------+-----+---------+----------------+	+	DROP TABLE IF EXISTS `tblGenericShipment`;
-	| Field                              | Type          | Null | Key | Default | Extra          |	+	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';
-	| Id                                  | int(10)      | NO  | PRI | NULL    | auto_increment |	+	</pre>
-	| ClientCompanyId                    | int(10)      | NO  | MUL | NULL    |                |	+	==  Fields ==
-	| ShipperAddressId                    | int(10)       | YES  | MUL | NULL   |                |	+	=== Id ===
		+	` int(10) NOT NULL AUTO_INCREMENT
-	| ShipperAddressDescription          | varchar(1500) | YES  |    | NULL   |                |	+	=== ClientCompanyId ===
		+	` int(10) NOT NULL
-	| ConsigneeAddressId                  | int(10)       | YES  | MUL | NULL   |                |	+	=== ShipperAddressId ===
		+	` int(10) DEFAULT NULL
-	| ConsigneeAddressDescription        | varchar(1500) | YES  |    | NULL   |                |	+	=== ShipperAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| NotifyAddressId                    | int(10)       | YES  | MUL | NULL   |                |	+	=== ConsigneeAddressId ===
		+	` int(10) DEFAULT NULL
-	| NotifyAddressDescription            | varchar(1500) | YES  |    | NULL   |                |	+	=== ConsigneeAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| PickupAddressId                    | int(10)       | YES  | MUL | NULL   |                |	+	=== NotifyAddressId ===
		+	` int(10) DEFAULT NULL
-	| PickupAddressDescription            | varchar(1500) | YES  |    | NULL   |                |	+	=== NotifyAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| GeneralDeliveryToAddressId          | int(10)       | YES  | MUL | NULL   |                |	+	=== PickupAddressId ===
		+	` int(10) DEFAULT NULL
-	| GeneralDeliveryToAddressDescription | varchar(1500) | YES  |    | NULL   |                |	+	=== PickupAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| PickupComments                      | varchar(1500) | YES  |    | NULL   |                |	+	=== GeneralDeliveryToAddressId ===
		+	` int(10) DEFAULT NULL
-	| PickupTruckerId                    | int(10)       | YES  | MUL | NULL   |                |	+	=== GeneralDeliveryToAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| EstimatedPickupDate                | date          | YES  |    | NULL   |                |	+	=== PickupComments ===
		+	` varchar(1500) DEFAULT NULL
-	| ActualPickupDate                    | date          | YES  |    | NULL   |                |	+	=== PickupTruckerId ===
		+	` int(10) DEFAULT NULL
-	| OriginPoint                        | varchar(30)  | YES  |    | NULL   |                |	+	=== EstimatedPickupDate ===
		+	` date DEFAULT NULL
-	| DestinationPoint                    | varchar(30)  | YES  |    | NULL   |                |	+	=== ActualPickupDate ===
		+	` date DEFAULT NULL
-	| TransportModeId                    | int(10)       | YES  | MUL | NULL   |                |	+	=== OriginPoint ===
		+	` varchar(30) DEFAULT NULL
-	| ClientModeId                        | int(10)       | YES  | MUL | NULL   |                |	+	=== DestinationPoint ===
		+	` varchar(30) DEFAULT NULL
-	| ShippingTermId                      | int(10)       | YES  | MUL | NULL   |                |	+	=== TransportModeId ===
		+	` int(10) DEFAULT NULL
-	| ShippingTermLocation                | varchar(30)   | YES  |    | NULL   |                |	+	=== ClientModeId ===
		+	` int(10) DEFAULT NULL
-	| CommodityDescription                | varchar(1500) | YES  |    | NULL   |                |	+	=== ShippingTermId ===
		+	` int(10) DEFAULT NULL
-	| MarksOrNumber                      | varchar(1500) | YES  |    | NULL   |                |	+	=== ShippingTermLocation ===
		+	` varchar(30) DEFAULT NULL
-	| AuthorizedBy                        | varchar(30)   | YES  |    | NULL   |                |	+	=== CommodityDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| AuthorizedDate                      | date          | YES  |    | NULL   |                |	+	=== MarksOrNumber ===
		+	` varchar(1500) DEFAULT NULL
-	| EstimatedDeliveryDate              | date          | YES  |    | NULL   |                |	+	=== AuthorizedBy ===
		+	` varchar(30) DEFAULT NULL
		+	=== AuthorizedDate ===
		+	` date DEFAULT NULL
-	| AuthorizationMethodId              | int(10)      | YES  | MUL | NULL   |                |	+	=== EstimatedDeliveryDate ===
		+	` date DEFAULT NULL
-	* ExportRef || [[Ct#Export ref]]	+	=== AuthorizationMethodId ===
		+	` int(10) DEFAULT NULL
-	| ImportRef                          | varchar(30)   | YES  |    | NULL   |                |	+	=== ExportRef ===
		+	` varchar(30) default NULL,
-	| CustomerRef                        | varchar(30)   | YES  |    | NULL   |                |	+	=== ImportRef ===
		+	` varchar(30) default NULL,
-	| Jaguar3rdRef                        | varchar(30)   | YES  |    | NULL   |                |	+	=== CustomerRef ===
		+	` varchar(30) default NULL,
-	| MasterId                            | int(10)       | YES  | MUL | NULL   |                |	+	=== Jaguar3rdRef ===
		+	` varchar(30) default NULL,
-	| IsDeleted                          | bit(1)       | NO  |    |	+	=== MasterId ===
		+	` int(10) DEFAULT NULL
-	| LastModifiedUserId                  | int(10)       | YES  | MUL | NULL   |                |	+	=== IsDeleted ===
		+	` bit(1) NOT NULL DEFAULT b'0'
-	| CreatedOnDate                      | datetime      | YES  |    | NULL   |                |	+	=== LastModifiedUserId ===
		+	` int(10) DEFAULT NULL
-	| IsDimsMode                          | tinyint(1)    | NO  |    | 0      |                |	+	=== CreatedOnDate ===
		+	` datetime DEFAULT NULL
-	| TotalHUInCubicMeters                | double        | YES  |    | 0       |                |	+	=== IsDimsMode ===
		+	` tinyint(1) NOT NULL DEFAULT '0'
-	| TotalHUInCubicFeets                | double       | YES  |    | 0       |                |	+	=== TotalHUInCubicMeters ===
		+	` double DEFAULT '0'
-	| OriginPointCountryId                | int(10)      | YES  |    | NULL    |                |	+	=== TotalHUInCubicFeets ===
		+	` double DEFAULT '0'
		+	=== OriginPointCountryId ===
		+	` int(10) DEFAULT NULL
-	| DestinationPointCountryId           | int(10)       | YES  |    | NULL   |                |	+	=== DestinationPointCountryId ===
		+	` int(10) DEFAULT NULL
-	| ShipmentGroupId                     | int(10)       | YES  | MUL | NULL   |                |	+	=== ShipmentGroupId ===
		+	` int(10) DEFAULT NULL
-	| NotificationDate                   | date         | YES  |    | NULL   |                |	+	=== NotificationDate ===
		+	` date DEFAULT NULL
-	| EnabledTransShipment               | tinyint(1)   | YES  |    | 0       |                |	+	=== EnabledTransShipment ===
		+	` tinyint(1) DEFAULT '0'
-	| EnabledOriginTerminal               | tinyint(1)   | YES  |    | 0       |                |	+	=== EnabledOriginTerminal ===
		+	` tinyint(1) DEFAULT '0'
-	| EnabledDestinationTerminal         | tinyint(1)   | YES  |    | 0       |                |	+	=== EnabledDestinationTerminal ===
		+	` tinyint(1) DEFAULT '0'
-	| ShowPickupAddress                   | tinyint(1)   | YES  |    | 0       |                |	+	=== ShowPickupAddress ===
		+	` tinyint(1) DEFAULT '0'
-	| ShowDeliveryToAddress               | tinyint(1)   | YES  |    | 0       |                |	+	=== ShowDeliveryToAddress ===
		+	` tinyint(1) DEFAULT '0'
-	| ShowOriginPointCountry             | tinyint(1)   | YES  |    | 0       |                |	+	=== ShowOriginPointCountry ===
		+	` tinyint(1) DEFAULT '0'
-	| ShowDestinationPointCountry         | tinyint(1)   | YES  |    | 0       |                |	+	=== ShowDestinationPointCountry ===
		+	` tinyint(1) DEFAULT '0'
-	| AuthorizedMOT                       | int(10)       | YES  |    | NULL   |                |	+	=== AuthorizedMOT ===
		+	` int(10) DEFAULT NULL
-	| TableOfChargesId                   | int(10)       | YES  | MUL | NULL   |                |	+	=== TableOfChargesId ===
		+	` int(10) DEFAULT NULL
-	| SalesPersonId                       | int(10)       | YES  | MUL | NULL   |                |	+	=== SalesPersonId ===
-		+	` int(10) DEFAULT NULL
-	+-------------------------------------+---------------+------+-----+---------+----------------+	+
-	[[Category:DB]]	+	=== 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'