Return to Home
Wonach suchst Du?
What are you looking for?
SQL and Data Modell
Data Migration
I_BPartner
I_Flatrate_Term
I_Product
I_Request
Data Model
Application Dictionary
AD_Changelog
AD_Menu
AD_Migrationscript
AD_SCHEDULER
AD_Table and AD_Column
AD_UI_Element
AD_Window
Translation Tables (_trl)
Dispo Framework
M_Shipmentschedule
MD_Candidate
Documents
AD_Archive
C_Doc_Outbound_Log (Outbound Documents, Invoice, Printing Queue)
C_Dunning (Dunning Candidates, Level, Documents, Print Items)
C_Flatrate_Term (Contract Management / Subscriptions)
C_Invoice / C_Invoice_Candidate
C_Order (Sales and Purchase Order)
C_Payment (Payment)
M_Inventory (Inventory)
Master Data
C_BPartner (Business Partner)
C_CountryArea (EU Area)
C_UOM_Conversion (UOM,Product)
M_DiscountSchemaBreak (Discount Breaks)
M_Pricelist (Pricing,Product,Category,Unit,Tax)
M_Product_Category
M_ProductPrice (Pricing,Product)
PP_Product_BOM (Bill of Material)
PP_Product_Planning (Product Planning Data)
System Data
AD_Eventlog (Event Bus)
AD_Pinstance (Process Log)
C_Queue_Element
C_Queue_Workpackage
Views
md_stock_from_hus_v (Qty on Hand, Stock)
Maintenance
Danger Zone
Cleanup fast growing tables on big systems
Tips
Asses Record Quantities Quickly
Set next value of ID Column when Inserting
Create smart migration scripts
find ad_table_id for a table name
Import CSV directly via Postgres
Common Postgres Snippets for metasfresh
Reopen a processed document
Translation
Export Field Translations (AD_Field)
Export Document Action Translations (Reference List)
Export Element Translations (AD_Element)
Export Menu Folder and Node Translations (AD_Menu)
Export Message Translations (AD_Message)
Export Window and Tab Translations (AD_Window, AD_Tab)
View source file on GitHub.com