Diagrams

Table

No. Series

DynamicsDocs.comNo. Series«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 206»Res. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 209»Job Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 2110»O365 Sales Initial SetupPrimary Key [PK]Payment Reg. Template NamePayment Reg. Batch NameIs initializedDefault Customer TemplateDefault Item TemplateDefault Payment Terms CodeDefault Payment Method CodeSales Invoice No. SeriesPosted Sales Inv. No. Series«Table 233»Item Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesTemplate Type; [Item,Transfer,Phys. In...Recurring«Table 236»Res. Journal BatchJournal Template Name [PK]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«Table 237»Job Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 310»No. Series RelationshipCode [PK,NN]Series Code [PK,NN]DescriptionSeries Description«Table 311»Sales & Receivables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Credit Warnings; [Both Warnings,Credit...Stockout WarningShipment on InvoiceInvoice RoundingExt. Doc. No. MandatoryCustomer Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Shipment Nos.Reminder Nos.Issued Reminder Nos.Fin. Chrg. Memo Nos.Issued Fin. Chrg. M. Nos.Posted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to Shpt.Allow VAT DifferenceCalc. Inv. Disc. per VAT IDLogo Position on Documents; [No Logo,L...Check Prepmt. when Posting...«Table 312»Purchases & Payables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Receipt on InvoiceInvoice RoundingExt. Doc. No. MandatoryVendor Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Receipt Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to ReceiptAllow VAT DifferenceCalc. Inv. Disc. per VAT IDPosted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Check Prepmt. when PostingDefault Posting Date; [Work Date,No Da...Default Qty. to Receive; [Remainder,Bl...Archive Quotes and OrdersPost with Job QueueJob Queue Category CodeJob Queue Priority for PostPost & Print with Job Queue...«Table 313»Inventory SetupPrimary Key [PK]Automatic Cost PostingLocation MandatoryItem Nos.Automatic Cost Adjustment; [Never,Day,...Prevent Negative InventoryTransfer Order Nos.Posted Transfer Shpt. Nos.Posted Transfer Rcpt. Nos.Copy Comments Order to Shpt.Copy Comments Order to Rcpt.Nonstock Item Nos.Outbound Whse. Handling TimeInbound Whse. Handling TimeExpected Cost Posting to G/LAverage Cost Calc. Type; [,Item,Item &...Average Cost Period; [,Day,Week,Month,...Item Group Dimension CodeInventory Put-away Nos.Inventory Pick Nos.Posted Invt. Put-away Nos.Posted Invt. Pick Nos.Inventory Movement Nos.Registered Invt. Movement Nos.Internal Movement Nos.«Table 314»Resources SetupPrimary Key [PK]Resource Nos.Time Sheet Nos.Time Sheet First Weekday; [Monday,Tues...Time Sheet by Job Approval; [Never,Mac...«Table 315»Jobs SetupPrimary Key [PK]Job Nos.Apply Usage Link by DefaultDefault WIP MethodDefault Job Posting GroupDefault WIP Posting Method; [Per Job,P...Allow Sched/Contract Lines DefLogo Position on Documents; [No Logo,L...Job WIP Nos.Automatic Update Job Item Cost«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«Table 5079»Marketing SetupPrimary Key [PK]Contact Nos.Campaign Nos.Segment Nos.To-do Nos.Opportunity Nos.Bus. Rel. Code for CustomersBus. Rel. Code for VendorsBus. Rel. Code for Bank Accs.Inherit Salesperson CodeInherit Territory CodeInherit Country/Region CodeInherit Language CodeInherit Address DetailsInherit Communication DetailsDefault Salesperson CodeDefault Territory CodeDefault Country/Region CodeDefault Language CodeDefault Sales Cycle CodeAttachment Storage Type; [Embedded,Dis...Attachment Storage LocationAutosearch for DuplicatesSearch Hit % [NN]Maintain Dupl. Search Strings [NN]Mergefield Language IDDef. Company Salutation CodeDefault Person Salutation CodeDefault Correspondence Type; [,Hard Co...Queue Folder PathQueue Folder UID...«Table 5080»To-doNo. [PK]Team CodeSalesperson CodeCampaign No.Contact No.Opportunity No.Segment No.Type; [,Meeting,Phone Call]Date [NN]Status; [Not Started,In Progress,Compl...Priority; [Low,Normal,High]DescriptionClosedDate ClosedNo. SeriesCommentCanceledContact NameTeam NameSalesperson NameCampaign DescriptionContact Company No.Contact Company NameRecurringRecurring Date IntervalCalc. Due Date From; [,Due Date,Closin...Opportunity DescriptionStart TimeDurationOpportunity Entry No.Last Date Modified...«Table 5092»OpportunityNo. [PK]DescriptionSalesperson CodeCampaign No.Contact No.Contact Company No.Sales Cycle CodeSales Document No.Creation DateStatus; [Not Started,In Progress,Won,L...Priority; [Low,Normal,High]ClosedDate ClosedNo. SeriesCommentCurrent Sales Cycle StageEstimated Value [LCY]Probability %Calcd. Current Value [LCY]Chances of Success %Completed %Contact NameContact Company NameSalesperson NameCampaign DescriptionSegment No.Estimated Closing DateSales Document Type; [,Quote,Order,Pos...No. of InteractionsWizard Step; [,1,2,3,4,5,6]Activate First Stage...«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 5218»Human Resources SetupPrimary Key [PK]Employee Nos.Base Unit of Measure«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 5603»FA SetupPrimary Key [PK]Allow Posting to Main AssetsDefault Depr. BookAllow FA Posting FromAllow FA Posting ToInsurance Depr. BookAutomatic Insurance PostingFixed Asset Nos.Insurance Nos.«Table 5619»FA Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionMaint. Posting Report IDMaint. Posting Report CaptionNo. SeriesPosting No. Series«Table 5620»FA Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series«Table 5633»Insurance Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 5634»Insurance Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. Series«Table 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Template CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5769»Warehouse SetupPrimary Key [PK]Whse. Receipt Nos.Whse. Put-away Nos.Whse. Pick Nos.Whse. Ship Nos.Registered Whse. Pick Nos.Registered Whse. Put-away Nos.Require ReceiveRequire Put-awayRequire PickRequire ShipmentLast Whse. Posting Ref. No.Receipt Posting Policy; [Posting error...Shipment Posting Policy; [Posting erro...Posted Whse. Receipt Nos.Posted Whse. Shipment Nos.Whse. Internal Put-away Nos.Whse. Internal Pick Nos.Whse. Movement Nos.Registered Whse. Movement Nos.«Table 5911»Service Mgt. SetupPrimary Key [PK]Fault Reporting Level; [None,Fault,Fau...Link Service to Service ItemSalesperson MandatoryWarranty Disc. % [Parts]Warranty Disc. % [Labor]Contract Rsp. Time MandatoryService Order Starting FeeRegister Contract ChangesContract Inv. Line Text CodeContract Line Inv. Text CodeContract Inv. Period Text CodeContract Credit Line Text CodeSend First Warning ToSend Second Warning ToSend Third Warning ToFirst Warning Within [Hours]Second Warning Within [Hours]Third Warning Within [Hours]Next Service Calc. Method; [Planned,Ac...Service Order Type MandatoryService Zones Option; [Code Shown,Warn...Service Order Start MandatoryService Order Finish MandatoryResource Skills Option; [Code Shown,Wa...One Service Item Line/OrderUnit of Measure MandatoryFault Reason Code MandatoryContract Serv. Ord. Max. DaysLast Contract Service DateWork Type Code Mandatory...«Table 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 5968»Service Contract TemplateNo. [PK]DescriptionInvoice Period; [Month,Two Months,Quar...Max. Labor Unit PriceCombine InvoicesPrepaidService Zone CodeLanguage CodeDefault Response Time [Hours]Contract Lines on InvoiceDefault Service PeriodInvoice after ServiceAllow Unbalanced AmountsContract Group CodeService Order TypeAutomatic Credit MemosNo. SeriesPrice Update PeriodPrice Inv. Increase CodeServ. Contract Acc. Gr. Code«Table 7309»Warehouse Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDRegistering Report IDForce Registering ReportType; [Item,Physical Inventory,Reclass...Source CodeReason CodeTest Report CaptionPage CaptionRegistering Report CaptionNo. SeriesRegistering No. Series«Table 7310»Warehouse Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesRegistering No. SeriesLocation Code [PK,NN]Template Type; [Item,Physical Inventor...Assigned User ID«Table 743»VAT Report SetupPrimary key [PK]No. SeriesModify Submitted Reports«Table 82»Item Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [Item,Transfer,Phys. Inventory,R...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. SeriesWhse. Register Report IDWhse. Register Report Caption«Table 840»Cash Flow ForecastNo. [PK]Search NameDescriptionDescription 2Consider DiscountCreation DateCreated ByManual Payments ToCommentNo. SeriesManual Payments FromG/L Budget FromG/L Budget ToConsider CF Payment TermsConsider Pmt. Disc. Tol. DateConsider Pmt. Tol. AmountAccount No. FilterSource Type Filter; [,Receivables,Paya...Cash Flow Date FilterAmount [LCY]Positive FilterOverdue CF Dates to Work DateDefault G/L Budget Name«Table 843»Cash Flow SetupPrimary Key [PK]Cash Flow Forecast No. SeriesReceivables CF Account No.Payables CF Account No.Sales Order CF Account No.Purch. Order CF Account No.FA Budget CF Account No.FA Disposal CF Account No.Service CF Account No.CF No. on Chart in Role CenterJob CF Account No.Automatic Update Frequency; [Never,Dai...Tax CF Account No.Taxable Period; [Monthly,Quarterly,Acc...Tax Payment WindowTax Bal. Account Type; [,Vendor,G/L Ac...Tax Bal. Account No.API KeyAPI URLVariance %Historical PeriodsHorizonPeriod Type; [Day,Week,Month,Quarter,Y...TimeOutService Pass API Key IDCortana Intelligence EnabledShow Cortana Notification«Table 905»Assembly SetupPrimary Key [PK]Stockout WarningAssembly Order Nos.Assembly Quote Nos.Blanket Assembly Order Nos.Posted Assembly Order Nos.Copy Component Dimensions from; [Item/...Default Location for OrdersCopy Comments when PostingCreate Movements Automatically«Table 98»General Ledger SetupPrimary Key [PK]Allow Posting FromAllow Posting ToRegister TimePmt. Disc. Excl. VATDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterCust. Balances DueVendor Balances DueUnrealized VATAdjust for Payment Disc.Mark Cr. Memos as CorrectionsLocal Address Format; [Post Code+City,...Inv. Rounding Precision [LCY]Inv. Rounding Type [LCY]; [Nearest,Up,...Local Cont. Addr. Format; [First,After...Bank Account Nos.Summarize G/L EntriesAmount Decimal PlacesUnit-Amount Decimal PlacesAdditional Reporting CurrencyVAT Tolerance %EMU CurrencyLCY CodeVAT Exchange Rate Adjustment; [No Adju...Amount Rounding PrecisionUnit-Amount Rounding PrecisionAppln. Rounding PrecisionGlobal Dimension 1 CodeGlobal Dimension 2 Code...«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 99000765»Manufacturing SetupPrimary Key [PK]Normal Starting TimeNormal Ending TimeDoc. No. Is Prod. Order No.Cost Incl. SetupDynamic Low-Level CodePlanning WarningSimulated Order Nos.Planned Order Nos.Firm Planned Order Nos.Released Order Nos.Work Center Nos.Machine Center Nos.Production BOM Nos.Routing Nos.Current Production ForecastUse Forecast on LocationsCombined MPS/MRP CalculationComponents at LocationDefault Dampener PeriodDefault Dampener %Default Safety Lead TimeBlank Overflow Level; [Allow Default C...Show Capacity InPreset Output Quantity; [Expected Quan...«Table 99000779»Production BOM VersionProduction BOM No. [PK,NN]Version Code [PK]DescriptionStarting DateUnit of Measure CodeLast Date ModifiedStatus; [New,Certified,Under Developme...No. Series«Table 99000786»Routing VersionRouting No. [PK,NN]Version Code [PK]DescriptionStarting DateStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Last Date ModifiedNo. Series«Table 99000875»Order Promising SetupPrimary Key [PK]Offset [Time]Order Promising Nos.Order Promising TemplateOrder Promising Worksheet<No. Series><No. Series><No. Series><No. Series><No. Series><Posting No. Series><No. Series><Posting No. Series><Sales Invoice No. Series><Posted Sales Inv. No. Series><No. Series><Posting No. Series><No. Series><Posting No. Series><No. Series><Posting No. Series><No. Series><No. Series><Credit Transfer Msg. Nos.><Direct Debit Msg. Nos.><No. Series><Serial Nos.><Lot Nos.><Code><Series Code><Customer Nos.><Quote Nos.><Order Nos.><Invoice Nos.><Posted Invoice Nos.><Credit Memo Nos.><Posted Credit Memo Nos.><Posted Shipment Nos.><Reminder Nos.><Issued Reminder Nos.><Fin. Chrg. Memo Nos.><Issued Fin. Chrg. M. Nos.><Posted Prepmt. Inv. Nos.><Posted Prepmt. Cr. Memo Nos.><Blanket Order Nos.><Direct Debit Mandate Nos.><Posted Return Receipt Nos.><Return Order Nos.><Vendor Nos.><Quote Nos.><Order Nos.><Invoice Nos.><Posted Invoice Nos.><Credit Memo Nos.><Posted Credit Memo Nos.><Posted Receipt Nos.><Blanket Order Nos.><Posted Prepmt. Inv. Nos.><Posted Prepmt. Cr. Memo Nos.><Posted Return Shpt. Nos.><Return Order Nos.><Item Nos.><Transfer Order Nos.><Posted Transfer Shpt. Nos.><Posted Transfer Rcpt. Nos.><Nonstock Item Nos.><Inventory Put-away Nos.><Inventory Pick Nos.><Posted Invt. Put-away Nos.><Posted Invt. Pick Nos.><Inventory Movement Nos.><Registered Invt. Movement Nos.><Internal Movement Nos.><Resource Nos.><Time Sheet Nos.><Job Nos.><Job WIP Nos.><No. Series><No. Series><Contact Nos.><Campaign Nos.><Segment Nos.><To-do Nos.><Opportunity Nos.><No. Series><No. Series><No. Series><Employee Nos.><No. Series><No. Series><Fixed Asset Nos.><Insurance Nos.><No. Series><Posting No. Series><No. Series><Posting No. Series><No. Series><No. Series><Posting No. Series><No. Series><Posting No. Series><No. Series><Whse. Receipt Nos.><Whse. Put-away Nos.><Whse. Pick Nos.><Whse. Ship Nos.><Registered Whse. Pick Nos.><Registered Whse. Put-away Nos.><Posted Whse. Receipt Nos.><Posted Whse. Shipment Nos.><Whse. Internal Put-away Nos.><Whse. Internal Pick Nos.><Whse. Movement Nos.><Registered Whse. Movement Nos.><Service Invoice Nos.><Contract Invoice Nos.><Service Item Nos.><Service Order Nos.><Service Contract Nos.><Contract Template Nos.><Troubleshooting Nos.><Prepaid Posting Document Nos.><Loaner Nos.><Service Quote Nos.><Posted Service Invoice Nos.><Posted Serv. Credit Memo Nos.><Posted Service Shipment Nos.><Service Credit Memo Nos.><Contract Credit Memo Nos.><No. Series><No. Series><No. Series><No. Series><Registering No. Series><No. Series><Registering No. Series><No. Series><No. Series><Posting No. Series><No. Series><Cash Flow Forecast No. Series><Assembly Order Nos.><Assembly Quote Nos.><Blanket Assembly Order Nos.><Posted Assembly Order Nos.><Bank Account Nos.><No. Series><No. Series><Simulated Order Nos.><Planned Order Nos.><Firm Planned Order Nos.><Released Order Nos.><Work Center Nos.><Machine Center Nos.><Production BOM Nos.><Routing Nos.><No. Series><No. Series><Order Promising Nos.><Customer No.><Vendor No.><Person Responsible><Resource Filter><Resource No.><Preferred Resource><Bill-to Customer No.><Bill-to Customer No.><Primary Contact No.><Customer No.><Journal Template Name><Journal Template Name><Journal Template Name><Pay-to Vendor No.><Primary Contact No.><Vendor No.><Vendor No.><Maintenance Vendor No.><Insurance Vendor No.><Vendor No.><Vendor No.><Tax Bal. Account No.><Subcontractor No.><Alternative Item No.><Source No.><Item No.><Item No.><Item No.><Item Filter><Company No.><Lookup Contact No.><Campaign Filter><Contact Filter><Contact Company Filter><Contact No.><Contact Company No.><Contact No.><Contact Company No.><Campaign No.><Campaign No.><Opportunity No.><Organizer To-do No.><Manager No.><Employee No. Filter><Responsible Employee><Work Center Filter><Capacity No. Filter><Capacity No. Filter><Component of Main Asset><Journal Template Name><Journal Template Name><Journal Template Name><Alternate Work Center><Work Center No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50
3 Default Nos. (Default Nos.) Boolean
4 Manual Nos. (Manual Nos.) Boolean
5 Date Order (Date Order) Boolean

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Assembly Header Posting No. Series (Posting No. Series) 1..n
Assembly Setup Posted Assembly Order Nos. (Posted Assembly Order Nos.) 1..n
Bank Account Direct Debit Msg. Nos. (Direct Debit Msg. Nos.) 1..n
CV Ledger Entry Buffer No. Series (No. Series) 1..n
Campaign No. Series (No. Series) 1..n
Cash Flow Forecast No. Series (No. Series) 1..n
Cash Flow Setup Cash Flow Forecast No. Series (Cash Flow Forecast No. Series) 1..n
Config. Template Header Instance No. Series (Instance No. Series) 1..n
Contact No. Series (No. Series) 1..n
Cust. Ledger Entry No. Series (No. Series) 1..n
Customer No. Series (No. Series) 1..n
Employee No. Series (No. Series) 1..n
FA Journal Batch Posting No. Series (Posting No. Series) 1..n
FA Journal Line Posting No. Series (Posting No. Series) 1..n
FA Journal Template Posting No. Series (Posting No. Series) 1..n
FA Ledger Entry No. Series (No. Series) 1..n
FA Setup Insurance Nos. (Insurance Nos.) 1..n
Filed Service Contract Header No. Series (No. Series) 1..n
Finance Charge Memo Header Issuing No. Series (Issuing No. Series) 1..n
Fixed Asset No. Series (No. Series) 1..n
G/L Entry No. Series (No. Series) 1..n
Gen. Journal Batch Posting No. Series (Posting No. Series) 1..n
Gen. Journal Line Posting No. Series (Posting No. Series) 1..n
Gen. Journal Template Posting No. Series (Posting No. Series) 1..n
General Ledger Setup Bank Account Nos. (Bank Account Nos.) 1..n
Human Resources Setup Employee Nos. (Employee Nos.) 1..n
Ins. Coverage Ledger Entry No. Series (No. Series) 1..n
Insurance No. Series (No. Series) 1..n
Insurance Journal Batch Posting No. Series (Posting No. Series) 1..n
Insurance Journal Line Posting No. Series (Posting No. Series) 1..n
Insurance Journal Template Posting No. Series (Posting No. Series) 1..n
Internal Movement Header No. Series (No. Series) 1..n
Inventory Setup Internal Movement Nos. (Internal Movement Nos.) 1..n
Issued Fin. Charge Memo Header Pre-Assigned No. Series (Pre-Assigned No. Series) 1..n
Issued Reminder Header Pre-Assigned No. Series (Pre-Assigned No. Series) 1..n
Item Lot Nos. (Lot Nos.) 1..n
Item Journal Batch Posting No. Series (Posting No. Series) 1..n
Item Journal Line Posting No. Series (Posting No. Series) 1..n
Item Journal Template Posting No. Series (Posting No. Series) 1..n
Item Ledger Entry No. Series (No. Series) 1..n
Job No. Series (No. Series) 1..n
Job Journal Batch Posting No. Series (Posting No. Series) 1..n
Job Journal Line Posting No. Series (Posting No. Series) 1..n
Job Journal Template Posting No. Series (Posting No. Series) 1..n
Job Ledger Entry No. Series (No. Series) 1..n
Jobs Setup Job WIP Nos. (Job WIP Nos.) 1..n
Loaner No. Series (No. Series) 1..n
Machine Center No. Series (No. Series) 1..n
Maintenance Ledger Entry No. Series (No. Series) 1..n
Manufacturing Setup Routing Nos. (Routing Nos.) 1..n
Marketing Setup Opportunity Nos. (Opportunity Nos.) 1..n
No. Series Line Series Code (Series Code) 1..n
No. Series Relationship Series Code (Series Code) 1..n
Nonstock Item No. Series (No. Series) 1..n
O365 Sales Initial Setup Posted Sales Inv. No. Series (Posted Sales Inv. No. Series) 1..n
Opportunity No. Series (No. Series) 1..n
Order Promising Setup Order Promising Nos. (Order Promising Nos.) 1..n
Phys. Inventory Ledger Entry No. Series (No. Series) 1..n
Posted Assembly Header Posting No. Series (Posting No. Series) 1..n
Posted Invt. Pick Header No. Series (No. Series) 1..n
Posted Invt. Put-away Header No. Series (No. Series) 1..n
Posted Whse. Receipt Header No. Series (No. Series) 1..n
Posted Whse. Shipment Header No. Series (No. Series) 1..n
Production BOM Header No. Series (No. Series) 1..n
Production BOM Version No. Series (No. Series) 1..n
Production Order No. Series (No. Series) 1..n
Purch. Cr. Memo Hdr. Return Order No. Series (Return Order No. Series) 1..n
Purch. Inv. Header Prepayment No. Series (Prepayment No. Series) 1..n
Purch. Rcpt. Header Order No. Series (Order No. Series) 1..n
Purchase Header Return Shipment No. Series (Return Shipment No. Series) 1..n
Purchase Header Archive Return Shipment No. Series (Return Shipment No. Series) 1..n
Purchases & Payables Setup Return Order Nos. (Return Order Nos.) 1..n
Registered Invt. Movement Hdr. No. Series (No. Series) 1..n
Registered Whse. Activity Hdr. No. Series (No. Series) 1..n
Reminder Header Issuing No. Series (Issuing No. Series) 1..n
Requisition Line No. Series (No. Series) 1..n
Res. Journal Batch Posting No. Series (Posting No. Series) 1..n
Res. Journal Line Posting No. Series (Posting No. Series) 1..n
Res. Journal Template Posting No. Series (Posting No. Series) 1..n
Res. Ledger Entry No. Series (No. Series) 1..n
Resource No. Series (No. Series) 1..n
Resources Setup Time Sheet Nos. (Time Sheet Nos.) 1..n
Return Receipt Header Return Order No. Series (Return Order No. Series) 1..n
Return Shipment Header Return Order No. Series (Return Order No. Series) 1..n
Routing Header No. Series (No. Series) 1..n
Routing Version No. Series (No. Series) 1..n
SEPA Direct Debit Mandate No. Series (No. Series) 1..n
Sales & Receivables Setup Return Order Nos. (Return Order Nos.) 1..n
Sales Cr.Memo Header Return Order No. Series (Return Order No. Series) 1..n
Sales Header Return Receipt No. Series (Return Receipt No. Series) 1..n
Sales Header Archive Return Receipt No. Series (Return Receipt No. Series) 1..n
Sales Invoice Header Prepayment No. Series (Prepayment No. Series) 1..n
Sales Shipment Header Order No. Series (Order No. Series) 1..n
Segment Header No. Series (No. Series) 1..n
Service Contract Header No. Series (No. Series) 1..n
Service Contract Template No. Series (No. Series) 1..n
Service Cr.Memo Header No. Series (No. Series) 1..n
Service Header Shipping No. Series (Shipping No. Series) 1..n
Service Invoice Header Order No. Series (Order No. Series) 1..n
Service Item No. Series (No. Series) 1..n
Service Mgt. Setup Contract Credit Memo Nos. (Contract Credit Memo Nos.) 1..n
Service Shipment Header Order No. Series (Order No. Series) 1..n
Standard General Journal Line Posting No. Series (Posting No. Series) 1..n
Standard Item Journal Line Posting No. Series (Posting No. Series) 1..n
To-do No. Series (No. Series) 1..n
Transfer Header No. Series (No. Series) 1..n
Transfer Receipt Header No. Series (No. Series) 1..n
Transfer Shipment Header No. Series (No. Series) 1..n
Troubleshooting Header No. Series (No. Series) 1..n
VAT Entry No. Series (No. Series) 1..n
VAT Report Setup No. Series (No. Series) 1..n
Vendor No. Series (No. Series) 1..n
Vendor Ledger Entry No. Series (No. Series) 1..n
Warehouse Activity Header Registering No. Series (Registering No. Series) 1..n
Warehouse Entry No. Series (No. Series) 1..n
Warehouse Journal Batch Registering No. Series (Registering No. Series) 1..n
Warehouse Journal Line Registering No. Series (Registering No. Series) 1..n
Warehouse Journal Template Registering No. Series (Registering No. Series) 1..n
Warehouse Receipt Header Receiving No. Series (Receiving No. Series) 1..n
Warehouse Setup Registered Whse. Movement Nos. (Registered Whse. Movement Nos.) 1..n
Warehouse Shipment Header Shipping No. Series (Shipping No. Series) 1..n
Whse. Internal Pick Header No. Series (No. Series) 1..n
Whse. Internal Put-away Header No. Series (No. Series) 1..n
Work Center No. Series (No. Series) 1..n