Generic tbl

From UG

Revision as of 06:52, 31 January 2010 (edit) Alex (Talk | contribs) m ← Older edit		Current revision as of 21:42, 21 May 2010 (edit) (undo) Alex (Talk | contribs) (→ShipperAddressId)
(12 intermediate revisions not shown)
Line 1:		Line 1:
-	== MySQL 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
-		+
-		+
-		+
	-- ----------------------------		-- ----------------------------
-
	-- 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 144:		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>
-	== Related Business Object and Fields ==	+	== Fields ==
-		+
-	=== <Example> ===	+
-	* ''meaning:'' Airline 2 Letter unique Code	+
-	* ''type/format:''  [[Datatypes#alpha]]; exactly 2 chars; all caps	+
-	* ''example:'' CA	+
-		+
-	* ''meaning:''	+
-	* ''type/format:''	+
-	* ''example:''	+
-		+
-	=== Id ===	+
-	* ''meaning:'' PRI key	+	=== Id ===
		+	` int(10) NOT NULL AUTO_INCREMENT
	=== ClientCompanyId ===		=== ClientCompanyId ===
		+	` int(10) NOT NULL
-	* ''meaning:'' FRN key, see [[tbl Client Company#Id]]	+	=== ShipperAddressId ===
-		+	` int(10) DEFAULT NULL
-	=== ShipperAddressId   ===	+
-	* ''meaning:''	+	=== ShipperAddressDescription ===
-	* ''type/format:''	+	` varchar(1500) DEFAULT NULL
-	* ''example:''	+
-	=== ShipperAddressDescription  ===	+	=== ConsigneeAddressId ===
		+	` int(10) DEFAULT NULL
-	* ''meaning:''	+	=== ConsigneeAddressDescription ===
-	* ''type/format:''	+	` varchar(1500) DEFAULT NULL
-	* ''example:''	+
-	| varchar(1500) | YES  |    | NULL    |                |	+	=== NotifyAddressId ===
-		+	` int(10) DEFAULT NULL
-	=== ConsigneeAddressId  ===	+
-		+
-	| int(10)      | YES  | MUL | NULL    |                |	+
-		+
-	=== ConsigneeAddressDescription    ===	+
-		+
-	| varchar(1500) | YES  |    | NULL    |                |	+
-		+
-	=== NotifyAddressId ===	+
-		+
-	| int(10)       | YES  | MUL | NULL   |                |	+
	=== NotifyAddressDescription ===		=== NotifyAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| varchar(1500) | YES  |    | NULL    |                |	+	=== PickupAddressId ===
-		+	` int(10) DEFAULT NULL
-	=== PickupAddressId   ===	+
-		+
-	| int(10)       | YES  | MUL | NULL    |                |	+
-		+
-	=== PickupAddressDescription  ===	+
-		+
-	| varchar(1500) | YES  |    | NULL   |                |	+
-	=== GeneralDeliveryToAddressId  ===	+	=== PickupAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| int(10)       | YES  | MUL | NULL   |                |	+	=== GeneralDeliveryToAddressId ===
		+	` int(10) DEFAULT NULL
	=== GeneralDeliveryToAddressDescription ===		=== GeneralDeliveryToAddressDescription ===
		+	` varchar(1500) DEFAULT NULL
-	| varchar(1500) | YES  |    | NULL   |                |	+	=== PickupComments ===
		+	` varchar(1500) DEFAULT NULL
-	=== PickupComments  ===	+	=== PickupTruckerId ===
		+	` int(10) DEFAULT NULL
-	| varchar(1500) | YES  |    | NULL   |                |	+	=== EstimatedPickupDate ===
		+	` date DEFAULT NULL
-	=== PickupTruckerId  ===	+	=== ActualPickupDate ===
		+	` date DEFAULT NULL
-	| int(10)       | YES  | MUL | NULL   |                |	+	=== OriginPoint ===
		+	` varchar(30) DEFAULT NULL
-	=== EstimatedPickupDate  ===	+	=== DestinationPoint ===
		+	` varchar(30) DEFAULT NULL
-	| date          | YES  |    | NULL   |                |	+	=== TransportModeId ===
		+	` int(10) DEFAULT NULL
-	=== ActualPickupDate  ===	+	=== ClientModeId ===
		+	` int(10) DEFAULT NULL
-	| date          | YES  |    | NULL   |                |	+	=== ShippingTermId ===
		+	` int(10) DEFAULT NULL
-	=== OriginPoint  ===	+	=== ShippingTermLocation ===
		+	` varchar(30) DEFAULT NULL
-	| varchar(30)   | YES  |    | NULL   |                |	+	=== CommodityDescription ===
		+	` varchar(1500) DEFAULT NULL
-	=== DestinationPoint    ===	+	=== MarksOrNumber ===
		+	` varchar(1500) DEFAULT NULL
-	| varchar(30)   | YES  |    | NULL   |                |	+	=== AuthorizedBy ===
		+	` varchar(30) DEFAULT NULL
-	=== TransportModeId    ===	+	=== AuthorizedDate ===
		+	` date DEFAULT NULL
-	| int(10)      | YES  | MUL | NULL   |                |	+	=== EstimatedDeliveryDate ===
		+	` date DEFAULT NULL
-	=== ClientModeId      ===	+	=== AuthorizationMethodId ===
-		+	` int(10) DEFAULT NULL
-	| 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 ===		=== ExportRef ===
-		+	` varchar(30) default NULL,
-	varchar(30)   | YES  |    | NULL   |	+
-	=== ImportRef   ===	+	=== ImportRef ===
-	| varchar(30)   | YES  |    | NULL   |                |	+	` varchar(30) default NULL,
-	=== CustomerRef ===	+	=== CustomerRef ===
-	| varchar(30)   | YES  |    | NULL   |                |	+	` varchar(30) default NULL,
-	=== Jaguar3rdRef ===	+	=== Jaguar3rdRef ===
-	| varchar(30)   | YES  |    | NULL   |                |	+	` varchar(30) default NULL,
-	=== MasterId   ===	+	=== MasterId ===
		+	` int(10) DEFAULT NULL
-	| int(10)       | YES  | MUL | NULL   |                |	+	=== IsDeleted ===
		+	` bit(1) NOT NULL DEFAULT b'0'
-	=== IsDeleted  ===	+	=== LastModifiedUserId ===
		+	` int(10) DEFAULT NULL
-	| bit(1)        | NO  |    |	+	=== CreatedOnDate ===
		+	` datetime DEFAULT NULL
-	=== LastModifiedUserId  ===	+	=== IsDimsMode ===
		+	` tinyint(1) NOT NULL DEFAULT '0'
-	| int(10)      | YES  | MUL | NULL    |                |	+	=== TotalHUInCubicMeters ===
		+	` double DEFAULT '0'
-	=== CreatedOnDate    ===	+	=== TotalHUInCubicFeets ===
		+	` double DEFAULT '0'
-	| datetime      | YES  |    | NULL   |                |	+	=== OriginPointCountryId ===
		+	` int(10) DEFAULT NULL
-	=== IsDimsMode      ===	+	=== DestinationPointCountryId ===
		+	` int(10) DEFAULT NULL
-	| tinyint(1)   | NO  |    | 0      |                |	+	=== ShipmentGroupId ===
		+	` int(10) DEFAULT NULL
-	=== TotalHUInCubicMeters    ===	+	=== NotificationDate ===
		+	` date DEFAULT NULL
-	| double        | YES  |    | 0       |                |	+	=== EnabledTransShipment ===
		+	` tinyint(1) DEFAULT '0'
-	=== TotalHUInCubicFeets    ===	+	=== EnabledOriginTerminal ===
		+	` tinyint(1) DEFAULT '0'
-	| double        | YES  |    | 0       |                |	+	=== EnabledDestinationTerminal ===
		+	` tinyint(1) DEFAULT '0'
-	=== OriginPointCountryId  ===	+	=== ShowPickupAddress ===
		+	` tinyint(1) DEFAULT '0'
-	| int(10)       | YES  |    | NULL    |                |	+	=== ShowDeliveryToAddress ===
		+	` tinyint(1) DEFAULT '0'
		+	=== ShowOriginPointCountry ===
		+	` tinyint(1) DEFAULT '0'
-	=== DestinationPointCountryId  ===	+	=== ShowDestinationPointCountry ===
		+	` tinyint(1) DEFAULT '0'
-	| int(10)       | YES  |    | NULL   |                |	+	=== AuthorizedMOT ===
		+	` int(10) DEFAULT NULL
-	=== ShipmentGroupId    ===	+	=== TableOfChargesId ===
		+	` int(10) DEFAULT NULL
-	| int(10)      | YES  | MUL | NULL    |                |	+	=== SalesPersonId ===
-		+	` int(10) DEFAULT 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   |                |	+
-		+
-	+-------------------------------------+---------------+------+-----+---------+----------------+	+
-	[[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'