Intro into CT2 DB
From UG
(→Admin Carriers) |
|||
(3 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:Data_Model]] |
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | == CT profile tables == | ||
+ | |||
+ | * [[tbl Undefined Shipment]] | ||
+ | * [[Tbl Generic Shipment]] | ||
+ | * [[Tbl Ocean Shipment]] | ||
+ | * [[Tbl Air Shipment]] | ||
+ | * [[Tbl Trucking Shipment]] | ||
+ | |||
== Acc tables == | == Acc tables == | ||
Line 32: | Line 45: | ||
* tblChargeBackInvoice - discontinued? | * tblChargeBackInvoice - discontinued? | ||
- | == | + | == OpsAdmin == |
+ | |||
+ | === Users and Offices (component) === | ||
| tblGenericUser | | | tblGenericUser | | ||
Line 56: | Line 71: | ||
| tblJaguarOpsGroup | | | tblJaguarOpsGroup | | ||
- | == Client == | + | === Client Companies (component) === |
- | + | ||
Line 85: | Line 99: | ||
- | == | + | === Addressbook (component) === |
| tblAddressBillToParty | | | tblAddressBillToParty | | ||
Line 95: | Line 109: | ||
| tblAddressTransportation | | | tblAddressTransportation | | ||
- | |||
- | |||
- | == | + | === Carriers (component) === |
+ | |||
* [[tbl Airline]] | | * [[tbl Airline]] | | ||
Line 107: | Line 120: | ||
* [[tbl Shipline]] | | * [[tbl Shipline]] | | ||
- | == Remaining tables == | + | |
+ | |||
+ | == Remaining tables TO BE SORTED OUT == | ||
Line 279: | Line 294: | ||
| tblUSAstate | | | tblUSAstate | | ||
- | | | + | | | |
| tblUnitType | | | tblUnitType | | ||
Line 328: | Line 343: | ||
154 rows in set | 154 rows in set | ||
+ | </pre> | ||
+ | |||
+ | == All tables and Views == | ||
+ | |||
+ | |||
+ | <pre> | ||
+ | mysql> show tables; | ||
+ | +----------------------------------------+ | ||
+ | | Tables_in_cybertrax | | ||
+ | +----------------------------------------+ | ||
+ | | mymfavorites | | ||
+ | | tblAddressBillToParty | | ||
+ | | tblAddressCompanyCity | | ||
+ | | tblAddressJaguarVendor | | ||
+ | | tblAddressTransportation | | ||
+ | | tblAirShipment | | ||
+ | | tblAirline | | ||
+ | | tblAirport | | ||
+ | | tblAlwaysBCCEmails | | ||
+ | | tblAuthorizationMethod | | ||
+ | | tblAuthorizationMethodSettings | | ||
+ | | tblBusiestSeaPort | | ||
+ | | tblChargeBackInvoice | | ||
+ | | tblChargeCode | | ||
+ | | tblClient | | ||
+ | | tblClientCompany | | ||
+ | | tblClientCompanyGroup | | ||
+ | | tblClientCompanyGroupRelation | | ||
+ | | tblClientExchangeRate | | ||
+ | | tblClientMode | | ||
+ | | tblClientUser | | ||
+ | | tblClientUser2AddressTransportation | | ||
+ | | tblClientUser2Region | | ||
+ | | tblClientUserWatchList | | ||
+ | | tblClientsGroup | | ||
+ | | tblClientsGroupRelation | | ||
+ | | tblCommentsMailedTo | | ||
+ | | tblCommodity | | ||
+ | | tblCommodityDisplaySettings | | ||
+ | | tblCommodityItem | | ||
+ | | tblContainer | | ||
+ | | tblContainer2Master | | ||
+ | | tblContainer2Shipment | | ||
+ | | tblContainerSize | | ||
+ | | tblContainerType | | ||
+ | | tblCountry | | ||
+ | | tblCreditLimit | | ||
+ | | tblCreditStatus | | ||
+ | | tblCreditTerm | | ||
+ | | tblCurrency | | ||
+ | | tblCurrencyExchangeRate | | ||
+ | | tblCurrencyExchangeRateChange | | ||
+ | | tblCustomer | | ||
+ | | tblCustomsStatus | | ||
+ | | tblDailyQuotes | | ||
+ | | tblDeliveryDateTypes | | ||
+ | | tblDeliveryLocation | | ||
+ | | tblDropClientTops | | ||
+ | | tblDropCountryTops | | ||
+ | | tblEmailQueryHistory | | ||
+ | | tblEmailQueryHistoryCCAddresses | | ||
+ | | tblEstimatedTransitTime | | ||
+ | | tblExchangeRate | | ||
+ | | tblFDAStatus | | ||
+ | | tblGenericShipment | | ||
+ | | tblGenericUser | | ||
+ | | tblGroupObjectPermission | | ||
+ | | tblHandlingRemark | | ||
+ | | tblHandlingUnit | | ||
+ | | tblJaguarOpsGroup | | ||
+ | | tblJaguarOpsGroupClientRelation | | ||
+ | | tblJaguarOpsGroupCompanyRelation | | ||
+ | | tblJaguarUser | | ||
+ | | tblJaguarUserBCCList | | ||
+ | | tblJaguarUserGroup | | ||
+ | | tblJaguarUserType | | ||
+ | | tblLoose | | ||
+ | | tblMailTemplates | | ||
+ | | tblMaster | | ||
+ | | tblMasterComments | | ||
+ | | tblMasterCommentsMailedTo | | ||
+ | | tblMasterOcean | | ||
+ | | tblMasterPDFReports | | ||
+ | | tblMasterTransportMode | | ||
+ | | tblMoveType | | ||
+ | | tblOceanModeType | | ||
+ | | tblOceanShipment | | ||
+ | | tblOffice | | ||
+ | | tblOnPallets | | ||
+ | | tblPDFReports | | ||
+ | | tblPackagingCommodityType | | ||
+ | | tblPackagingPalletType | | ||
+ | | tblPackagingType | | ||
+ | | tblPurchaseInvoice | | ||
+ | | tblPurchaseInvoiceChargeCode | | ||
+ | | tblRSSNewsFeeds | | ||
+ | | tblRegion | | ||
+ | | tblReport | | ||
+ | | tblReportRecipient | | ||
+ | | tblSeaPort | | ||
+ | | tblSecuredUrl | | ||
+ | | tblShipline | | ||
+ | | tblShipment2ClientCompanyGroupRelation | | ||
+ | | tblShipment2ClientCompanyRelation | | ||
+ | | tblShipmentChargeCodes | | ||
+ | | tblShipmentComments | | ||
+ | | tblShipmentDateHistory | | ||
+ | | tblShipmentGroup | | ||
+ | | tblShipmentInvoice2ContainersRelation | | ||
+ | | tblShipmentInvoiceChargeCodes | | ||
+ | | tblShipmentInvoiceContainers | | ||
+ | | tblShipmentInvoices | | ||
+ | | tblShipmentLog | | ||
+ | | tblShipmentTemplate | | ||
+ | | tblShippingTerm | | ||
+ | | tblStandardComments | | ||
+ | | tblSteamshipline | | ||
+ | | tblTableOfCharges | | ||
+ | | tblTestimonials | | ||
+ | | tblTransportMode | | ||
+ | | tblTruckingShipment | | ||
+ | | tblUSAstate | | ||
+ | | tblUndefinedShipment | | ||
+ | | tblUnitType | | ||
+ | | tblUpdateLogRecord | | ||
+ | | tblUploadedFiles | | ||
+ | | tblUserGroup | | ||
+ | | tblUserGroupObject | | ||
+ | | tblUserRole | | ||
+ | | viewArchivedShipmentId | | ||
+ | | viewClientAirShipmentDetails | | ||
+ | | viewClientGenericShipment | | ||
+ | | viewClientGenericShipmentId | | ||
+ | | viewClientOceanShipmentDetails | | ||
+ | | viewClientShipmentCommodities | | ||
+ | | viewClientShipmentCommodityItems | | ||
+ | | viewClientShipmentContainers | | ||
+ | | viewClientTruckingShipmentDetails | | ||
+ | | viewClientUndefinedShipmentDetails | | ||
+ | | viewClientUserConsignees | | ||
+ | | viewClientUserDeliveryLocations | | ||
+ | | viewClientUserDestinationRegions | | ||
+ | | viewClientUserOriginRegions | | ||
+ | | viewClientUserPickUpLocations | | ||
+ | | viewClientUserShippers | | ||
+ | | viewClientUserShippingTerms | | ||
+ | | viewClientWatchList | | ||
+ | | viewGenericShipment | | ||
+ | | viewGenericShipment_new | | ||
+ | | viewPurchaseInvoice | | ||
+ | | viewPurchaseInvoiceChargeCode | | ||
+ | | viewPurchaseInvoiceExtended | | ||
+ | | viewPurchaseInvoiceStatus | | ||
+ | | viewPurchaseInvoiceWithStatus | | ||
+ | | viewPurchaseInvoiceWithStatusExtended | | ||
+ | | viewReport | | ||
+ | | viewShipment | | ||
+ | | viewShipmentContainersInfo | | ||
+ | | viewShipmentInvoice | | ||
+ | | viewShipmentTemplateInfo | | ||
+ | | viewTransportationCompanyCity | | ||
+ | | viewVendorCompanyCity | | ||
+ | | viewVisibilityClientCompany | | ||
+ | | viewVisibilityClientCompanyGroup | | ||
+ | | viewVisibilityClientCopmany | | ||
+ | +----------------------------------------+ | ||
+ | 155 rows in set | ||
</pre> | </pre> |
Current revision as of 08:38, 31 January 2010
Contents |
[edit] CT profile tables
- tbl Undefined Shipment
- Tbl Generic Shipment
- Tbl Ocean Shipment
- Tbl Air Shipment
- Tbl Trucking Shipment
[edit] Acc tables
- Curr and Exch Rates:
- CC:
- tblChargeCode
- Purchase Inv:
- Sales and Internal Inv:
- TOC table (Air, Ocean; Imp Tab)
- Client accounting properties:
- tblChargeBackInvoice - discontinued?
[edit] OpsAdmin
[edit] Users and Offices (component)
| tblGenericUser |
| tblJaguarUser |
| tblJaguarUserBCCList |
| tblJaguarUserGroup |
| tblJaguarUserType |
| tblOffice |
| tblUserGroup |
| tblUserGroupObject |
| tblUserRole |
| tblJaguarOpsGroup |
[edit] Client Companies (component)
| tblClient |
| tblClientCompany |
| tblClientCompanyGroup |
| tblClientCompanyGroupRelation |
| tblClientMode |
| tblClientUser |
| tblClientUser2AddressTransportation |
| tblClientUser2Region |
| tblClientUserWatchList |
| tblClientsGroup |
| tblClientsGroupRelation |
[edit] Addressbook (component)
| tblAddressBillToParty |
| tblAddressCompanyCity |
| tblAddressJaguarVendor |
| tblAddressTransportation |
[edit] Carriers (component)
[edit] Remaining tables TO BE SORTED OUT
| mymfavorites |
| tblAirShipment |
| tblAirport |
| tblAlwaysBCCEmails |
| tblAuthorizationMethod |
| tblAuthorizationMethodSettings |
| tblBusiestSeaPort |
| tblCommentsMailedTo |
| tblCommodity |
| tblCommodityDisplaySettings |
| tblCommodityItem |
| tblContainer |
| tblContainer2Master |
| tblContainer2Shipment |
| tblContainerSize |
| tblContainerType |
| tblCountry |
| tblCustomer |
| tblCustomsStatus |
| tblDailyQuotes |
| tblDefaults |
| tblDeliveryDateTypes |
| tblDeliveryLocation |
| tblDropClientTops |
| tblDropCountryTops |
| tblEmailQueryHistory |
| tblEmailQueryHistoryCCAddresses |
| tblEstimatedTransitTime |
| tblFDAStatus |
| tblGenericShipment |
| tblGroupObjectPermission |
| tblHandlingRemark |
| tblHandlingUnit |
| tblJaguarOpsGroupClientRelation |
| tblJaguarOpsGroupCompanyRelation |
| tblLoose |
| tblMailTemplates |
| tblMaster |
| tblMasterComments |
| tblMasterCommentsMailedTo |
| tblMasterOcean |
| tblMasterPDFReports |
| tblMasterTransportMode |
| tblMoveType |
| tblOceanModeType |
| tblOceanShipment |
| tblOnPallets |
| tblPDFReports |
| tblPackagingCommodityType |
| tblPackagingPalletType |
| tblPackagingType |
| tblRSSNewsFeeds |
| tblRegion |
| tblReport |
| tblReportRecipient |
| tblSeaPort |
| tblSecuredUrl |
| tblShipment2ClientCompanyGroupRelation |
| tblShipment2ClientCompanyRelation |
| tblShipmentComments |
| tblShipmentDateHistory |
| tblShipmentGroup |
| tblShipmentLog |
| tblShipmentTemplate |
| tblShippingTerm |
| tblStandardComments |
| tblTableOfCharges |
| tblTestimonials |
| tblTransportMode |
| tblTruckingShipment |
| tblUSAstate |
| |
| tblUnitType |
| tblUpdateLogRecord |
| tblUploadedFiles |
[edit] Views
| viewArchivedShipmentId | | viewClientGenericShipment | | viewClientGenericShipmentId | | viewClientOceanShipmentDetails | | viewClientShipmentCommodities | | viewClientShipmentCommodityItems | | viewClientShipmentContainers | | viewClientTruckingShipmentDetails | | viewClientUndefinedShipmentDetails | | viewClientUserConsignees | | viewClientUserDeliveryLocations | | viewClientUserDestinationRegions | | viewClientUserOriginRegions | | viewClientUserPickUpLocations | | viewClientUserShippers | | viewClientUserShippingTerms | | viewClientWatchList | | viewGenericShipment | | viewGenericShipment_new | | viewPurchaseInvoice | | viewPurchaseInvoiceChargeCode | | viewPurchaseInvoiceExtended | | viewPurchaseInvoiceStatus | | viewPurchaseInvoiceWithStatus | | viewPurchaseInvoiceWithStatusExtended | | viewReport | | viewShipment | | viewShipmentContainersInfo | | viewShipmentInvoice | | viewShipmentTemplateInfo | | viewTransportationCompanyCity | | viewVendorCompanyCity | | viewVisibilityClientCompany | | viewVisibilityClientCompanyGroup | +----------------------------------------+ 154 rows in set
[edit] All tables and Views
mysql> show tables; +----------------------------------------+ | Tables_in_cybertrax | +----------------------------------------+ | mymfavorites | | tblAddressBillToParty | | tblAddressCompanyCity | | tblAddressJaguarVendor | | tblAddressTransportation | | tblAirShipment | | tblAirline | | tblAirport | | tblAlwaysBCCEmails | | tblAuthorizationMethod | | tblAuthorizationMethodSettings | | tblBusiestSeaPort | | tblChargeBackInvoice | | tblChargeCode | | tblClient | | tblClientCompany | | tblClientCompanyGroup | | tblClientCompanyGroupRelation | | tblClientExchangeRate | | tblClientMode | | tblClientUser | | tblClientUser2AddressTransportation | | tblClientUser2Region | | tblClientUserWatchList | | tblClientsGroup | | tblClientsGroupRelation | | tblCommentsMailedTo | | tblCommodity | | tblCommodityDisplaySettings | | tblCommodityItem | | tblContainer | | tblContainer2Master | | tblContainer2Shipment | | tblContainerSize | | tblContainerType | | tblCountry | | tblCreditLimit | | tblCreditStatus | | tblCreditTerm | | tblCurrency | | tblCurrencyExchangeRate | | tblCurrencyExchangeRateChange | | tblCustomer | | tblCustomsStatus | | tblDailyQuotes | | tblDeliveryDateTypes | | tblDeliveryLocation | | tblDropClientTops | | tblDropCountryTops | | tblEmailQueryHistory | | tblEmailQueryHistoryCCAddresses | | tblEstimatedTransitTime | | tblExchangeRate | | tblFDAStatus | | tblGenericShipment | | tblGenericUser | | tblGroupObjectPermission | | tblHandlingRemark | | tblHandlingUnit | | tblJaguarOpsGroup | | tblJaguarOpsGroupClientRelation | | tblJaguarOpsGroupCompanyRelation | | tblJaguarUser | | tblJaguarUserBCCList | | tblJaguarUserGroup | | tblJaguarUserType | | tblLoose | | tblMailTemplates | | tblMaster | | tblMasterComments | | tblMasterCommentsMailedTo | | tblMasterOcean | | tblMasterPDFReports | | tblMasterTransportMode | | tblMoveType | | tblOceanModeType | | tblOceanShipment | | tblOffice | | tblOnPallets | | tblPDFReports | | tblPackagingCommodityType | | tblPackagingPalletType | | tblPackagingType | | tblPurchaseInvoice | | tblPurchaseInvoiceChargeCode | | tblRSSNewsFeeds | | tblRegion | | tblReport | | tblReportRecipient | | tblSeaPort | | tblSecuredUrl | | tblShipline | | tblShipment2ClientCompanyGroupRelation | | tblShipment2ClientCompanyRelation | | tblShipmentChargeCodes | | tblShipmentComments | | tblShipmentDateHistory | | tblShipmentGroup | | tblShipmentInvoice2ContainersRelation | | tblShipmentInvoiceChargeCodes | | tblShipmentInvoiceContainers | | tblShipmentInvoices | | tblShipmentLog | | tblShipmentTemplate | | tblShippingTerm | | tblStandardComments | | tblSteamshipline | | tblTableOfCharges | | tblTestimonials | | tblTransportMode | | tblTruckingShipment | | tblUSAstate | | tblUndefinedShipment | | tblUnitType | | tblUpdateLogRecord | | tblUploadedFiles | | tblUserGroup | | tblUserGroupObject | | tblUserRole | | viewArchivedShipmentId | | viewClientAirShipmentDetails | | viewClientGenericShipment | | viewClientGenericShipmentId | | viewClientOceanShipmentDetails | | viewClientShipmentCommodities | | viewClientShipmentCommodityItems | | viewClientShipmentContainers | | viewClientTruckingShipmentDetails | | viewClientUndefinedShipmentDetails | | viewClientUserConsignees | | viewClientUserDeliveryLocations | | viewClientUserDestinationRegions | | viewClientUserOriginRegions | | viewClientUserPickUpLocations | | viewClientUserShippers | | viewClientUserShippingTerms | | viewClientWatchList | | viewGenericShipment | | viewGenericShipment_new | | viewPurchaseInvoice | | viewPurchaseInvoiceChargeCode | | viewPurchaseInvoiceExtended | | viewPurchaseInvoiceStatus | | viewPurchaseInvoiceWithStatus | | viewPurchaseInvoiceWithStatusExtended | | viewReport | | viewShipment | | viewShipmentContainersInfo | | viewShipmentInvoice | | viewShipmentTemplateInfo | | viewTransportationCompanyCity | | viewVendorCompanyCity | | viewVisibilityClientCompany | | viewVisibilityClientCompanyGroup | | viewVisibilityClientCopmany | +----------------------------------------+ 155 rows in set