Generic tbl

From UG

Revision as of 19:48, 22 February 2010 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 21:42, 21 May 2010 (edit) (undo) Alex (Talk | contribs) (→ShipperAddressId)
(2 intermediate revisions not shown)
Line 4:		Line 4:
	[[CT bo]]		[[CT bo]]
-	== MySQL table ==	+	== 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 44:		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 64:		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		-- Table structure for tblGenericShipment
-
	-- ----------------------------		-- ----------------------------
	DROP TABLE IF EXISTS `tblGenericShipment`;		DROP TABLE IF EXISTS `tblGenericShipment`;
-
	CREATE TABLE `tblGenericShipment` (		CREATE TABLE `tblGenericShipment` (
-	`Id` int(10) NOT NULL auto_increment,	+	`Id` int(10) NOT NULL AUTO_INCREMENT,
	`ClientCompanyId` int(10) NOT NULL,		`ClientCompanyId` int(10) NOT NULL,
-	`ShipperAddressId` int(10) default NULL,	+	`ShipperAddressId` int(10) DEFAULT NULL,
-	`ShipperAddressDescription` varchar(1500) default NULL,	+	`ShipperAddressDescription` varchar(1500) DEFAULT NULL,
-	`ConsigneeAddressId` int(10) default NULL,	+	`ConsigneeAddressId` int(10) DEFAULT NULL,
-	`ConsigneeAddressDescription` varchar(1500) default NULL,	+	`ConsigneeAddressDescription` varchar(1500) DEFAULT NULL,
-	`NotifyAddressId` int(10) default NULL,	+	`NotifyAddressId` int(10) DEFAULT NULL,
-	`NotifyAddressDescription` varchar(1500) default NULL,	+	`NotifyAddressDescription` varchar(1500) DEFAULT NULL,
-	`PickupAddressId` int(10) default NULL,	+	`PickupAddressId` int(10) DEFAULT NULL,
-	`PickupAddressDescription` varchar(1500) default NULL,	+	`PickupAddressDescription` varchar(1500) DEFAULT NULL,
-	`GeneralDeliveryToAddressId` int(10) default NULL,	+	`GeneralDeliveryToAddressId` int(10) DEFAULT NULL,
-	`GeneralDeliveryToAddressDescription` varchar(1500) default NULL,	+	`GeneralDeliveryToAddressDescription` varchar(1500) DEFAULT NULL,
-	`PickupComments` varchar(1500) default NULL,	+	`PickupComments` varchar(1500) DEFAULT NULL,
-	`PickupTruckerId` int(10) default NULL,	+	`PickupTruckerId` int(10) DEFAULT NULL,
-	`EstimatedPickupDate` date default NULL,	+	`EstimatedPickupDate` date DEFAULT NULL,
-	`ActualPickupDate` date default NULL,	+	`ActualPickupDate` date DEFAULT NULL,
-	`OriginPoint` varchar(30) default NULL,	+	`OriginPoint` varchar(30) DEFAULT NULL,
-	`DestinationPoint` varchar(30) default NULL,	+	`DestinationPoint` varchar(30) DEFAULT NULL,
-	`TransportModeId` int(10) default NULL,	+	`TransportModeId` int(10) DEFAULT NULL,
-	`ClientModeId` int(10) default NULL,	+	`ClientModeId` int(10) DEFAULT NULL,
-	`ShippingTermId` int(10) default NULL,	+	`ShippingTermId` int(10) DEFAULT NULL,
-	`ShippingTermLocation` varchar(30) default NULL,	+	`ShippingTermLocation` varchar(30) DEFAULT NULL,
-	`CommodityDescription` varchar(1500) default NULL,	+	`CommodityDescription` varchar(1500) DEFAULT NULL,
-	`MarksOrNumber` varchar(1500) default NULL,	+	`MarksOrNumber` varchar(1500) DEFAULT NULL,
-	`AuthorizedBy` varchar(30) default NULL,	+	`AuthorizedBy` varchar(30) DEFAULT NULL,
-	`AuthorizedDate` date default NULL,	+	`AuthorizedDate` date DEFAULT NULL,
-	`EstimatedDeliveryDate` date default NULL,	+	`EstimatedDeliveryDate` date DEFAULT NULL,
-	`AuthorizationMethodId` int(10) default NULL,	+	`AuthorizationMethodId` int(10) DEFAULT NULL,
-	`ExportRef` varchar(30) default NULL,	+	`ExportRef` varchar(30) DEFAULT NULL,
-	`ImportRef` varchar(30) default NULL,	+	`ImportRef` varchar(30) DEFAULT NULL,
-	`CustomerRef` varchar(30) default NULL,	+	`CustomerRef` varchar(30) DEFAULT NULL,
-	`Jaguar3rdRef` varchar(30) default NULL,	+	`Jaguar3rdRef` varchar(30) DEFAULT NULL,
-	`MasterId` int(10) default NULL,	+	`MasterId` int(10) DEFAULT NULL,
-	`IsDeleted` bit(1) NOT NULL default '\0',	+	`IsDeleted` bit(1) NOT NULL DEFAULT b'0',
-	`LastModifiedUserId` int(10) default NULL,	+	`LastModifiedUserId` int(10) DEFAULT NULL,
-	`CreatedOnDate` datetime default NULL,	+	`CreatedOnDate` datetime DEFAULT NULL,
-	`IsDimsMode` tinyint(1) NOT NULL default '0',	+	`IsDimsMode` tinyint(1) NOT NULL DEFAULT '0',
-	`TotalHUInCubicMeters` double default '0',	+	`TotalHUInCubicMeters` double DEFAULT '0',
-	`TotalHUInCubicFeets` double default '0',	+	`TotalHUInCubicFeets` double DEFAULT '0',
-	`OriginPointCountryId` int(10) default NULL,	+	`OriginPointCountryId` int(10) DEFAULT NULL,
-	`DestinationPointCountryId` int(10) default NULL,	+	`DestinationPointCountryId` int(10) DEFAULT NULL,
-	`ShipmentGroupId` int(10) default NULL,	+	`ShipmentGroupId` int(10) DEFAULT NULL,
-	`NotificationDate` date default NULL,	+	`NotificationDate` date DEFAULT NULL,
-	`EnabledTransShipment` tinyint(1) default '0',	+	`EnabledTransShipment` tinyint(1) DEFAULT '0',
-	`EnabledOriginTerminal` tinyint(1) default '0',	+	`EnabledOriginTerminal` tinyint(1) DEFAULT '0',
-	`EnabledDestinationTerminal` tinyint(1) default '0',	+	`EnabledDestinationTerminal` tinyint(1) DEFAULT '0',
-	`ShowPickupAddress` tinyint(1) default '0',	+	`ShowPickupAddress` tinyint(1) DEFAULT '0',
-	`ShowDeliveryToAddress` tinyint(1) default '0',	+	`ShowDeliveryToAddress` tinyint(1) DEFAULT '0',
-	`ShowOriginPointCountry` tinyint(1) default '0',	+	`ShowOriginPointCountry` tinyint(1) DEFAULT '0',
-	`ShowDestinationPointCountry` tinyint(1) default '0',	+	`ShowDestinationPointCountry` tinyint(1) DEFAULT '0',
-	`AuthorizedMOT` int(10) default NULL,	+	`AuthorizedMOT` int(10) DEFAULT NULL,
-	`TableOfChargesId` int(10) default NULL,	+	`TableOfChargesId` int(10) DEFAULT NULL,
-	`SalesPersonId` int(10) default NULL,	+	`SalesPersonId` int(10) DEFAULT NULL,
-	PRIMARY KEY (`Id`),	+	`CreatedByOfficeId` int(10) NOT NULL DEFAULT '1',
		+	PRIMARY KEY (`Id`),
	KEY `GenericShipment_ClientCompanyId` (`ClientCompanyId`),		KEY `GenericShipment_ClientCompanyId` (`ClientCompanyId`),
	KEY `GenericShipment_ShipperAddressId` (`ShipperAddressId`),		KEY `GenericShipment_ShipperAddressId` (`ShipperAddressId`),
Line 149:		Line 148:
	KEY `SalesPersonId` (`SalesPersonId`),		KEY `SalesPersonId` (`SalesPersonId`),
	KEY `TableOfChargesId` (`TableOfChargesId`),		KEY `TableOfChargesId` (`TableOfChargesId`),
-	CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES `tblTableOfCharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,	+	KEY `CreatedByOfficeId` (`CreatedByOfficeId`),
-	CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES `tblShipmentGroup` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,	+	CONSTRAINT `fkCreatedByOfficeId` FOREIGN KEY (`CreatedByOfficeId`) REFERENCES `tbloffice` (`Id`) ON UPDATE CASCADE,
-	CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblAuthorizationMethod` (`Id`),	+	CONSTRAINT `tblGenericShipment_fk` FOREIGN KEY (`TableOfChargesId`) REFERENCES `tbltableofcharges` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
-	CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tblJaguarUser` (`Id`) ON UPDATE CASCADE,	+	CONSTRAINT `tblGenericShipment_ibfk_1` FOREIGN KEY (`ShipmentGroupId`) REFERENCES `tblshipmentgroup` (`Id`) ON DELETE SET NULL ON UPDATE CASCADE,
-	CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES `tblAddressTransportation` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_10` FOREIGN KEY (`AuthorizationMethodId`) REFERENCES `tblauthorizationmethod` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblMasterOcean` (`Id`) ON DELETE SET NULL,	+	CONSTRAINT `tblGenericShipment_ibfk_11` FOREIGN KEY (`SalesPersonId`) REFERENCES `tbljaguaruser` (`Id`) ON UPDATE CASCADE,
-	CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tblJaguarUser` (`Id`) ON DELETE SET NULL,	+	CONSTRAINT `tblGenericShipment_ibfk_2` FOREIGN KEY (`ShipperAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblClientMode` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_25` FOREIGN KEY (`MasterId`) REFERENCES `tblmasterocean` (`Id`) ON DELETE SET NULL,
-	CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tblAddressJaguarVendor` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_26` FOREIGN KEY (`LastModifiedUserId`) REFERENCES `tbljaguaruser` (`Id`) ON DELETE SET NULL,
-	CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblClientCompany` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_27` FOREIGN KEY (`ClientModeId`) REFERENCES `tblclientmode` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tblAddressTransportation` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_28` FOREIGN KEY (`PickupTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tblAddressTransportation` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_29` FOREIGN KEY (`ClientCompanyId`) REFERENCES `tblclientcompany` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tblAddressTransportation` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_3` FOREIGN KEY (`ConsigneeAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tblAddressTransportation` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_4` FOREIGN KEY (`NotifyAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_8` FOREIGN KEY (`TransportModeId`) REFERENCES `tblTransportMode` (`Id`),	+	CONSTRAINT `tblGenericShipment_ibfk_5` FOREIGN KEY (`GeneralDeliveryToAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-	CONSTRAINT `tblGenericShipment_ibfk_9` FOREIGN KEY (`ShippingTermId`) REFERENCES `tblShippingTerm` (`Id`)	+	CONSTRAINT `tblGenericShipment_ibfk_6` FOREIGN KEY (`PickupAddressId`) REFERENCES `tbladdresstransportation` (`Id`),
-	) ENGINE=InnoDB AUTO_INCREMENT=251003 DEFAULT CHARSET=latin1;	+	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>
Line 172:		Line 174:
	==  Fields ==		==  Fields ==
-	===Id===	+	=== Id ===
-	` int(10) NOT NULL auto_increment	+	` int(10) NOT NULL AUTO_INCREMENT
-	===ClientCompanyId===	+	=== ClientCompanyId ===
	` int(10) NOT NULL		` int(10) NOT NULL
-	===ShipperAddressId===	+	=== ShipperAddressId ===
-	` int(10) default NULL	+	` 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
-	`ShipperAddressDescription` varchar(1500) default NULL,	+	=== CreatedByOfficeId ===
-	`ConsigneeAddressId` int(10) default NULL,	+	` int(10) NOT NULL DEFAULT '1'
-	`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,	+

---

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'