Intro into CT2 DB
From UG
(→Remaining tables) |
(→Admin Carriers) |
||
Line 99: | Line 99: | ||
== Admin Carriers == | == Admin Carriers == | ||
+ | |||
+ | | tblAirline | | ||
+ | |||
+ | | tblSteamshipline | | ||
+ | |||
+ | | tblShipline | | ||
+ | |||
+ | |||
+ | == Remaining tables == | ||
+ | |||
| mymfavorites | | | mymfavorites | | ||
Line 104: | Line 114: | ||
| tblAirShipment | | | tblAirShipment | | ||
- | + | ||
| tblAirport | | | tblAirport | | ||
Line 178: | Line 188: | ||
| tblHandlingUnit | | | tblHandlingUnit | | ||
- | + | ||
| tblJaguarOpsGroupClientRelation | | | tblJaguarOpsGroupClientRelation | | ||
Line 234: | Line 244: | ||
| tblSecuredUrl | | | tblSecuredUrl | | ||
- | + | ||
| tblShipment2ClientCompanyGroupRelation | | | tblShipment2ClientCompanyGroupRelation | | ||
Line 257: | Line 267: | ||
| tblStandardComments | | | tblStandardComments | | ||
- | + | ||
| tblTableOfCharges | | | tblTableOfCharges | |
Revision as of 22:42, 18 December 2009
Contents |
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?
Admin Users and Companies
| tblGenericUser |
| tblJaguarUser |
| tblJaguarUserBCCList |
| tblJaguarUserGroup |
| tblJaguarUserType |
| tblOffice |
| tblUserGroup |
| tblUserGroupObject |
| tblUserRole |
Client
| tblClient |
| tblClientCompany |
| tblClientCompanyGroup |
| tblClientCompanyGroupRelation |
| tblClientMode |
| tblClientUser |
| tblClientUser2AddressTransportation |
| tblClientUser2Region |
| tblClientUserWatchList |
| tblClientsGroup |
| tblClientsGroupRelation |
Admin Address Book
| tblAddressBillToParty |
| tblAddressCompanyCity |
| tblAddressJaguarVendor |
| tblAddressTransportation |
Admin Geography
Admin Transportation
Admin Carriers
| tblAirline |
| tblSteamshipline |
| tblShipline |
Remaining tables
| 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 |
| tblUndefinedShipment |
| tblUnitType |
| tblUpdateLogRecord |
| tblUploadedFiles |
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