Intro into CT2 DB
From UG
DB Tables related to Acc component
- Curr and Exch Rates:
- CC:
- tblChargeCode
- Purchase Inv:
- Sales and Internal Inv:
- TOC table (Air, Ocean; Imp Tab)
- Client accounting properties:
- tblChargeBackInvoice - discontinued?
All CT2 tables
mysql> show tables; +----------------------------------------+ | Tables_in_cybertraxStaging24 | +----------------------------------------+ | 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 | | tblDefaults | | 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 | | 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