Generic tbl

From UG

Revision as of 21:29, 26 January 2010 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 06:51, 31 January 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
-	== My sql table ==	+
		+	== MySQL table ==
	<pre>		<pre>
Line 169:		Line 170:
	</pre>		</pre>
-	== links to fields ==	+	== Related Business Object and Fields ==
-	+-------------------------------------+---------------+------+-----+---------+----------------+	+	=== <Example> ===
-	| Field                              | Type          | Null | Key | Default | Extra          |	+	* ''meaning:'' Airline 2 Letter unique Code
-	+-------------------------------------+---------------+------+-----+---------+----------------+	+	* ''type/format:''  [[Datatypes#alpha]]; exactly 2 chars; all caps
		+	* ''example:'' CA
-	| Id                                  | int(10)      | NO   | PRI | NULL    | auto_increment |	+	* ''meaning:''
		+	* ''type/format:''
		+	* ''example:''
-	| ClientCompanyId                    | int(10)      | NO  | MUL | NULL    |                |	+	=== Id ===
-	| ShipperAddressId                    | int(10)      | YES  | MUL | NULL    |                |	+	* ''meaning:'' PRI key
-	| ShipperAddressDescription          | varchar(1500) | YES  |    | NULL    |                |	+	=== ClientCompanyId ===
-	| ConsigneeAddressId                  | int(10)      | YES  | MUL | NULL   |               |	+	* ''meaning:'' FRN key, see [[tbl Client Company#Id]]
		+
		+	=== ShipperAddressId  ===
-	| ConsigneeAddressDescription        | varchar(1500) | YES |    | NULL    |                |	+	* ''meaning:''
		+	* ''type/format:''
		+	* ''example:''
-	| NotifyAddressId                    | int(10)      | YES | MUL | NULL    |                |	+	=== ShipperAddressDescription ===
-	| NotifyAddressDescription            | varchar(1500) | YES |    | NULL    |                |	+	* ''meaning:''
		+	* ''type/format:''
		+	* ''example:''
-	| PickupAddressId                    | int(10)       | YES  | MUL | NULL    |                |	+	| varchar(1500) | YES  |     | NULL    |                |
-	| PickupAddressDescription            | varchar(1500) | YES |    | NULL    |                |	+	=== ConsigneeAddressId ===
-	| GeneralDeliveryToAddressId          | int(10)      | YES  | MUL | NULL    |                |	+	| int(10)      | YES  | MUL | NULL    |                |
-	| GeneralDeliveryToAddressDescription | varchar(1500) | YES  |    | NULL   |                |	+	=== ConsigneeAddressDescription   ===
-	| PickupComments                      | varchar(1500) | YES  |    | NULL    |                |	+	| varchar(1500) | YES  |    | NULL    |                |
-	| PickupTruckerId                    | int(10)      | YES | MUL | NULL    |                |	+	=== NotifyAddressId ===
-	| EstimatedPickupDate                | date          | YES  |     | NULL    |                |	+	| int(10)      | YES  | MUL | NULL    |                |
-	| ActualPickupDate                    | date          | YES  |    | NULL    |                |	+	=== NotifyAddressDescription ===
-	| OriginPoint                        | varchar(30)   | YES  |    | NULL    |                |	+	| varchar(1500) | YES  |    | NULL    |                |
-	| DestinationPoint                    | varchar(30)  | YES  |    | NULL   |                |	+	=== PickupAddressId   ===
-	| TransportModeId                    | int(10)      | YES  | MUL | NULL    |                |	+	| int(10)      | YES  | MUL | NULL    |                |
-	| ClientModeId                        | int(10)      | YES  | MUL | NULL    |                |	+	=== PickupAddressDescription  ===
-	| ShippingTermId                      | int(10)       | YES  | MUL | NULL    |                |	+	| varchar(1500) | YES  |     | NULL    |                |
-	| ShippingTermLocation                | varchar(30)   | YES  |    | NULL    |                |	+	=== GeneralDeliveryToAddressId   ===
-	| CommodityDescription                | varchar(1500) | YES  |     | NULL    |                |	+	| int(10)       | YES  | MUL | NULL    |                |
-	| MarksOrNumber                      | varchar(1500) | YES  |    | NULL    |                |	+	=== GeneralDeliveryToAddressDescription ===
-	| AuthorizedBy                        | varchar(30)   | YES  |    | NULL    |                |	+	| varchar(1500) | YES  |    | NULL    |                |
-	| AuthorizedDate                      | date          | YES  |    | NULL    |                |	+	=== PickupComments  ===
-	| EstimatedDeliveryDate              | date          | YES  |    | NULL    |                |	+	| varchar(1500) | YES  |    | NULL    |                |
		+	=== PickupTruckerId  ===
-	| AuthorizationMethodId               | int(10)      | YES  | MUL | NULL    |                |	+	| 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 ===		=== ExportRef ===
-	* [[Ct#Export ref]]	+
-	* varchar(30)  | YES  |    | NULL    |	+	varchar(30)  | YES  |    | NULL    |
	=== ImportRef    ===		=== ImportRef    ===
Line 245:		Line 312:
	| varchar(30)  | YES  |    | NULL    |                |		| varchar(30)  | YES  |    | NULL    |                |
-	| MasterId                           | int(10)      | YES  | MUL | NULL    |                |	+	===  MasterId   ===                          | int(10)      | YES  | MUL | NULL    |                |
-	| IsDeleted                           | bit(1)        | NO  |    |	+	===  IsDeleted   ===                        | bit(1)        | NO  |    |
-	| LastModifiedUserId                 | int(10)      | YES  | MUL | NULL    |                |	+	===  LastModifiedUserId   ===                | int(10)      | YES  | MUL | NULL    |                |
-	| CreatedOnDate                       | datetime      | YES  |    | NULL    |                |	+	===  CreatedOnDate     ===                  | datetime      | YES  |    | NULL    |                |
-	| IsDimsMode                         | tinyint(1)    | NO  |    | 0      |                |	+	===  IsDimsMode       ===                    | tinyint(1)    | NO  |    | 0      |                |
-	| TotalHUInCubicMeters               | double        | YES  |    | 0      |                |	+	===  TotalHUInCubicMeters   ===            | double        | YES  |    | 0      |                |
-	| TotalHUInCubicFeets                 | double        | YES  |    | 0      |                |	+	===  TotalHUInCubicFeets   ===              | double        | YES  |    | 0      |                |
-	| OriginPointCountryId               | int(10)      | YES  |    | NULL    |                |	+	===  OriginPointCountryId   ===              | int(10)      | YES  |    | NULL    |                |
-	| DestinationPointCountryId           | int(10)      | YES  |    | NULL    |                |	+	===  DestinationPointCountryId   ===        | int(10)      | YES  |    | NULL    |                |
-	| ShipmentGroupId                     | int(10)      | YES  | MUL | NULL    |                |	+	===  ShipmentGroupId     ===                | int(10)      | YES  | MUL | NULL    |                |
-	| NotificationDate                   | date          | YES  |    | NULL    |                |	+	===  NotificationDate     ===                | date          | YES  |    | NULL    |                |
-	| EnabledTransShipment               | tinyint(1)    | YES  |    | 0      |                |	+	===  EnabledTransShipment   ===            | tinyint(1)    | YES  |    | 0      |                |
-	| EnabledOriginTerminal               | tinyint(1)    | YES  |    | 0      |                |	+	===  EnabledOriginTerminal   ===            | tinyint(1)    | YES  |    | 0      |                |
-	| EnabledDestinationTerminal         | tinyint(1)    | YES  |    | 0      |                |	+	===  EnabledDestinationTerminal   ===        | tinyint(1)    | YES  |    | 0      |                |
-	| ShowPickupAddress                   | tinyint(1)    | YES  |    | 0      |                |	+	===  ShowPickupAddress   ===                | tinyint(1)    | YES  |    | 0      |                |
-	| ShowDeliveryToAddress               | tinyint(1)    | YES  |    | 0      |                |	+	===  ShowDeliveryToAddress   ===            | tinyint(1)    | YES  |    | 0      |                |
-	| ShowOriginPointCountry             | tinyint(1)    | YES  |    | 0      |                |	+	===  ShowOriginPointCountry   ===            | tinyint(1)    | YES  |    | 0      |                |
-	| ShowDestinationPointCountry         | tinyint(1)    | YES  |    | 0      |                |	+	===  ShowDestinationPointCountry   ===      | tinyint(1)    | YES  |    | 0      |                |
-	| AuthorizedMOT                       | int(10)      | YES  |    | NULL    |                |	+	===  AuthorizedMOT   ===                    | int(10)      | YES  |    | NULL    |                |
-	| TableOfChargesId                   | int(10)      | YES  | MUL | NULL    |                |	+	===  TableOfChargesId   ===                | int(10)      | YES  | MUL | NULL    |                |
-	| SalesPersonId                       | int(10)      | YES  | MUL | NULL    |                |	+	===  SalesPersonId   ===                    | int(10)      | YES  | MUL | NULL    |                |
	+-------------------------------------+---------------+------+-----+---------+----------------+		+-------------------------------------+---------------+------+-----+---------+----------------+
	[[Category:DB]]		[[Category:DB]]

---

Revision as of 06:51, 31 January 2010

Contents 1 MySQL table 2 Related Business Object and Fields 2.1 <Example> 2.2 Id 2.3 ClientCompanyId 2.4 ShipperAddressId 2.5 ShipperAddressDescription 2.6 ConsigneeAddressId 2.7 ConsigneeAddressDescription 2.8 NotifyAddressId 2.9 NotifyAddressDescription 2.10 PickupAddressId 2.11 PickupAddressDescription 2.12 GeneralDeliveryToAddressId 2.13 GeneralDeliveryToAddressDescription 2.14 PickupComments 2.15 PickupTruckerId 2.16 EstimatedPickupDate 2.17 ActualPickupDate 2.18 OriginPoint 2.19 DestinationPoint 2.20 TransportModeId 2.21 ClientModeId 2.22 ShippingTermId 2.23 ShippingTermLocation 2.24 CommodityDescription 2.25 MarksOrNumber 2.26 AuthorizedBy 2.27 AuthorizedDate 2.28 EstimatedDeliveryDate 2.29 AuthorizationMethodId 2.30 ExportRef 2.31 ImportRef 2.32 CustomerRef 2.33 Jaguar3rdRef

MySQL table

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




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

-- Table structure for tblGenericShipment

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

DROP TABLE IF EXISTS `tblGenericShipment`;

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

Related Business Object and 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

ClientCompanyId

• meaning: FRN key, see tbl Client Company#Id

ShipperAddressId

• meaning:
• type/format:
• example:

ShipperAddressDescription

• meaning:
• type/format:
• example:

        | varchar(1500) | YES  |     | NULL    |                |

ConsigneeAddressId

               | int(10)       | YES  | MUL | NULL    |                |

ConsigneeAddressDescription

    | varchar(1500) | YES  |     | NULL    |                |

NotifyAddressId

                  | int(10)       | YES  | MUL | NULL    |                |

NotifyAddressDescription

          | varchar(1500) | YES  |     | NULL    |                |

PickupAddressId

                | int(10)       | YES  | MUL | NULL    |                |

PickupAddressDescription

        | varchar(1500) | YES  |     | NULL    |                |

GeneralDeliveryToAddressId

      | int(10)       | YES  | MUL | NULL    |                |

GeneralDeliveryToAddressDescription

| varchar(1500) | YES  |     | NULL    |                |

PickupComments

                  | varchar(1500) | YES  |     | NULL    |                |

PickupTruckerId

                  | int(10)       | YES  | MUL | NULL    |                |

EstimatedPickupDate

              | date          | YES  |     | NULL    |                |

ActualPickupDate

                 | date          | YES  |     | NULL    |                |

OriginPoint

                      | varchar(30)   | YES  |     | NULL    |                |

DestinationPoint

              | varchar(30)   | YES  |     | NULL    |                |

TransportModeId

               | int(10)       | YES  | MUL | NULL    |                |

ClientModeId

                | int(10)       | YES  | MUL | NULL    |                |

ShippingTermId

                  | int(10)       | YES  | MUL | NULL    |                |

ShippingTermLocation

            | varchar(30)   | YES  |     | NULL    |                |

CommodityDescription

            | varchar(1500) | YES  |     | NULL    |                |

MarksOrNumber

            | varchar(1500) | YES  |     | NULL    |                |

AuthorizedBy

                | varchar(30)   | YES  |     | NULL    |                |

AuthorizedDate

                | date          | YES  |     | NULL    |                |

EstimatedDeliveryDate

         | date          | YES  |     | NULL    |                |

AuthorizationMethodId

           | int(10)       | YES  | MUL | NULL    |                |

ExportRef

varchar(30)   | YES  |     | NULL    |          

ImportRef

                      | varchar(30)   | YES  |     | NULL    |                |

CustomerRef

                     | varchar(30)   | YES  |     | NULL    |                |

Jaguar3rdRef

                     | varchar(30)   | YES  |     | NULL    |                |

=== MasterId === | int(10) | YES | MUL | NULL | |

=== IsDeleted === | bit(1) | NO | |

=== LastModifiedUserId === | int(10) | YES | MUL | NULL | |

=== CreatedOnDate === | datetime | YES | | NULL | |

=== IsDimsMode === | tinyint(1) | NO | | 0 | |

=== TotalHUInCubicMeters === | double | YES | | 0 | |

=== TotalHUInCubicFeets === | double | YES | | 0 | |

=== OriginPointCountryId === | int(10) | YES | | NULL | |

=== DestinationPointCountryId === | int(10) | YES | | NULL | |

=== ShipmentGroupId === | int(10) | YES | MUL | NULL | |

=== NotificationDate === | date | YES | | NULL | |

=== EnabledTransShipment === | tinyint(1) | YES | | 0 | |

=== EnabledOriginTerminal === | tinyint(1) | YES | | 0 | |

=== EnabledDestinationTerminal === | tinyint(1) | YES | | 0 | |

=== ShowPickupAddress === | tinyint(1) | YES | | 0 | |

=== ShowDeliveryToAddress === | tinyint(1) | YES | | 0 | |

=== ShowOriginPointCountry === | tinyint(1) | YES | | 0 | |

=== ShowDestinationPointCountry === | tinyint(1) | YES | | 0 | |

=== AuthorizedMOT === | int(10) | YES | | NULL | |

=== TableOfChargesId === | int(10) | YES | MUL | NULL | |

=== SalesPersonId === | int(10) | YES | MUL | NULL | |

+-------------------------------------+---------------+------+-----+---------+----------------+