Generic tbl

From UG

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'