Intro into CT2 DB

From UG

(Difference between revisions)
Jump to: navigation, search
(Remaining tables)
(Remaining tables)
Line 144: Line 144:
| tblGenericShipment                    |
| tblGenericShipment                    |
-
| tblGenericUser                        |
+
 
| tblGroupObjectPermission              |
| tblGroupObjectPermission              |
Line 158: Line 158:
| tblJaguarOpsGroupCompanyRelation      |
| tblJaguarOpsGroupCompanyRelation      |
-
| tblJaguarUser                          |
 
-
| tblJaguarUserBCCList                  |
 
-
| tblJaguarUserGroup                    |
 
-
 
-
| tblJaguarUserType                      |
 
| tblLoose                              |
| tblLoose                              |
Line 188: Line 183:
| tblOceanShipment                      |
| tblOceanShipment                      |
-
| tblOffice                              |
+
 
| tblOnPallets                          |
| tblOnPallets                          |
Line 255: Line 250:
| tblUploadedFiles                      |
| tblUploadedFiles                      |
-
 
-
| tblUserGroup                          |
 
-
 
-
| tblUserGroupObject                    |
 
-
 
-
| tblUserRole                            |
 
== Views ==
== Views ==

Revision as of 22:33, 18 December 2009


Contents

Acc tables

  • CC:
    • tblChargeCode
  • tblChargeBackInvoice - discontinued?

Admin Users and Companies

Remaining tables

| mymfavorites |

| tblAddressBillToParty |

| tblAddressCompanyCity |

| tblAddressJaguarVendor |

| tblAddressTransportation |

| tblAirShipment |

| tblAirline |

| tblAirport |

| tblAlwaysBCCEmails |

| tblAuthorizationMethod |

| tblAuthorizationMethodSettings |

| tblBusiestSeaPort |

| tblChargeBackInvoice |


| tblClient |

| tblClientCompany |

| tblClientCompanyGroup |

| tblClientCompanyGroupRelation |


| tblClientMode |

| tblClientUser |

| tblClientUser2AddressTransportation |

| tblClientUser2Region |

| tblClientUserWatchList |

| tblClientsGroup |

| tblClientsGroupRelation |

| tblCommentsMailedTo |

| tblCommodity |

| tblCommodityDisplaySettings |

| tblCommodityItem |

| tblContainer |

| tblContainer2Master |

| tblContainer2Shipment |

| tblContainerSize |

| tblContainerType |

| tblCountry |


| tblCurrencyExchangeRate |

| tblCurrencyExchangeRateChange |

| tblCustomer |

| tblCustomsStatus |

| tblDailyQuotes |

| tblDefaults |

| tblDeliveryDateTypes |

| tblDeliveryLocation |

| tblDropClientTops |

| tblDropCountryTops |

| tblEmailQueryHistory |

| tblEmailQueryHistoryCCAddresses |

| tblEstimatedTransitTime |


| tblFDAStatus |

| tblGenericShipment |


| tblGroupObjectPermission |

| tblHandlingRemark |

| tblHandlingUnit |

| tblJaguarOpsGroup |

| tblJaguarOpsGroupClientRelation |

| tblJaguarOpsGroupCompanyRelation |



| tblLoose |

| tblMailTemplates |

| tblMaster |

| tblMasterComments |

| tblMasterCommentsMailedTo |

| tblMasterOcean |

| tblMasterPDFReports |

| tblMasterTransportMode |

| tblMoveType |

| tblOceanModeType |

| tblOceanShipment |


| tblOnPallets |

| tblPDFReports |

| tblPackagingCommodityType |

| tblPackagingPalletType |

| tblPackagingType |


| tblRSSNewsFeeds |

| tblRegion |

| tblReport |

| tblReportRecipient |

| tblSeaPort |

| tblSecuredUrl |

| tblShipline |

| tblShipment2ClientCompanyGroupRelation |

| tblShipment2ClientCompanyRelation |


| tblShipmentComments |

| tblShipmentDateHistory |

| tblShipmentGroup |


| tblShipmentLog |

| tblShipmentTemplate |

| tblShippingTerm |

| tblStandardComments |

| tblSteamshipline |

| 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

Personal tools