Intro into CT2 DB

From UG

Revision as of 22:17, 18 December 2009 (edit) Alex (Talk | contribs) (→All CT2 tables) ← Older edit		Revision as of 22:30, 18 December 2009 (edit) (undo) Alex (Talk | contribs) (→Remaining tables) Newer edit →
Line 64:		Line 64:
	| tblChargeBackInvoice                  |		| tblChargeBackInvoice                  |
-	| tblChargeCode                          |	+
	| tblClient                              |		| tblClient                              |
Line 74:		Line 74:
	| tblClientCompanyGroupRelation          |		| tblClientCompanyGroupRelation          |
-	| tblClientExchangeRate                  |	+
	| tblClientMode                          |		| tblClientMode                          |
Line 110:		Line 110:
	| tblCountry                            |		| tblCountry                            |
-	| tblCreditLimit                        |
-	| tblCreditStatus                        |
-
-	| tblCreditTerm                          |
-
-	| tblCurrency                            |
	| tblCurrencyExchangeRate                |		| tblCurrencyExchangeRate                |
Line 144:		Line 138:
	| tblEstimatedTransitTime                |		| tblEstimatedTransitTime                |
-	| tblExchangeRate                        |	+
	| tblFDAStatus                          |		| tblFDAStatus                          |
Line 205:		Line 199:
	| tblPackagingType                      |		| tblPackagingType                      |
-		+
-	| tblPurchaseInvoice                    |	+
-		+
-	| tblPurchaseInvoiceChargeCode          |	+
	| tblRSSNewsFeeds                        |		| tblRSSNewsFeeds                        |
Line 228:		Line 219:
	| tblShipment2ClientCompanyRelation      |		| tblShipment2ClientCompanyRelation      |
-	| tblShipmentChargeCodes                |	+
	| tblShipmentComments                    |		| tblShipmentComments                    |
Line 235:		Line 226:
	| tblShipmentGroup                      |		| tblShipmentGroup                      |
-		+
-	| tblShipmentInvoice2ContainersRelation |	+
-		+
-	| tblShipmentInvoiceChargeCodes          |	+
-		+
-	| tblShipmentInvoiceContainers          |	+
-		+
-	| tblShipmentInvoices                    |	+
	| tblShipmentLog                        |		| tblShipmentLog                        |

---

Revision as of 22:30, 18 December 2009

Contents 1 Acc tables 2 Admin Users and Companies 3 Remaining tables 4 Views

Acc tables

• Curr and Exch Rates:
  • tbl Currency
  • tbl Currency Exchange Rate
  • tbl Currency Exchange Rate Change
  • tbl Client Exchange Rate - discontinued?

• CC:
  • tblChargeCode

• Purchase Inv:
  • tbl Purchase Invoice
  • tbl Purchase Invoice Charge Code

• Sales and Internal Inv:
  • tbl Shipment Invoices
  • tbl Shipment Invoice 2 Containers Relation
  • tbl Shipment Invoice Charge Codes
  • tbl Shipment Invoice Containers

• TOC table (Air, Ocean; Imp Tab)
  • tbl Shipment Charge Codes

• Client accounting properties:
  • tbl Credit Limit
  • tbl Credit Status
  • tbl Credit Term

• 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 |

| 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 |

| 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 |

| tblUserGroup |

| tblUserGroupObject |

| tblUserRole |

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