Intro into CT2 DB

From UG

Revision as of 20:06, 18 December 2009 (edit) Alex (Talk | contribs) (→DB Tables related to Acc component) ← Older edit		Revision as of 21:46, 18 December 2009 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
	[[Category:DB]]		[[Category:DB]]
		+
		+	== DB Tables related to Acc component ==
		+
		+	* Curr and Exch Rates:
		+	** [[tbl Currency]]
		+	** [[tbl Currency Exchange Rate]]
		+	** [[tbl Currency Exchange Rate Change]]
		+	** [[tbl Client Exchange Rate]]    - discontinued?
		+
		+	* CC:
		+	** tblChargeCode
		+
		+	* Purchase Inv:
		+	** tblPurchaseInvoice
		+	** tblPurchaseInvoiceChargeCode
		+
		+	* Sales and Internal Inv:
		+	** tblShipmentInvoices
		+	** tblShipmentInvoice2ContainersRelation
		+	** tblShipmentInvoiceChargeCodes
		+	** tblShipmentInvoiceContainers
		+
		+	* TOC table (Air, Ocean; Imp Tab)
		+	** tblShipmentChargeCodes
		+
		+	* Client accounting properties:
		+	** tblCreditLimit
		+	** tblCreditStatus
		+	** tblCreditTerm
		+
		+	* tblChargeBackInvoice - discontinued?
		+
	== All CT2 tables ==		== All CT2 tables ==
Line 169:		Line 201:
	</pre>		</pre>
-
-	== DB Tables related to Acc component ==
-
-	* Curr and Exch Rates:
-	** [[tbl Currency]]
-	** [[tbl Currency Exchange Rate]]
-	** [[tbl Currency Exchange Rate Change]]
-	** [[tbl Client Exchange Rate]]    - discontinued?
-
-	* CC:
-	** tblChargeCode
-
-	* Purchase Inv:
-	** tblPurchaseInvoice
-	** tblPurchaseInvoiceChargeCode
-
-	* Sales and Internal Inv:
-	** tblShipmentInvoices
-	** tblShipmentInvoice2ContainersRelation
-	** tblShipmentInvoiceChargeCodes
-	** tblShipmentInvoiceContainers
-
-	* TOC table (Air, Ocean; Imp Tab)
-	** tblShipmentChargeCodes
-
-	* Client accounting properties:
-	** tblCreditLimit
-	** tblCreditStatus
-	** tblCreditTerm
-
-	* tblChargeBackInvoice - discontinued?

---

Revision as of 21:46, 18 December 2009

DB Tables related to Acc component

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

• CC:
  • tblChargeCode

• Purchase Inv:
  • tblPurchaseInvoice
  • tblPurchaseInvoiceChargeCode

• Sales and Internal Inv:
  • tblShipmentInvoices
  • tblShipmentInvoice2ContainersRelation
  • tblShipmentInvoiceChargeCodes
  • tblShipmentInvoiceContainers

• TOC table (Air, Ocean; Imp Tab)
  • tblShipmentChargeCodes

• Client accounting properties:
  • tblCreditLimit
  • tblCreditStatus
  • tblCreditTerm

• 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