Diagrams


Table

Source Code

DynamicsDocs.comSource Code«Table 230»Source CodeCode [PK,NN]Description«Table 1100»Cost Journal TemplateName [PK,NN]DescriptionReason CodeSource CodePosting Report IDPosting Report Caption«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 242»Source Code SetupPrimary Key [PK]SalesPurchasesInventory Post CostExchange Rate Adjmt.Post RecognitionPost ValueClose Income StatementConsolidationGeneral JournalSales JournalPurchase JournalCash Receipt JournalPayment JournalItem JournalResource JournalJob JournalSales Entry ApplicationPurchase Entry ApplicationVAT SettlementCompress G/LCompress VAT EntriesCompress Cust. LedgerCompress Vend. LedgerCompress Item LedgerCompress Res. LedgerCompress Job LedgerItem Reclass. JournalPhys. Inventory JournalCompress Bank Acc. LedgerCompress Check Ledger...«Table 354»Default Dimension PrioritySource Code [PK]Table ID [PK,NN]Table CaptionPriority«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 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 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 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<Source Code><Source Code><Source Code><Sales><Purchases><Inventory Post Cost><Exchange Rate Adjmt.><Post Recognition><Post Value><Close Income Statement><Consolidation><General Journal><Sales Journal><Purchase Journal><Cash Receipt Journal><Payment Journal><Item Journal><Resource Journal><Job Journal><Sales Entry Application><Purchase Entry Application><VAT Settlement><Compress G/L><Compress VAT Entries><Compress Cust. Ledger><Compress Vend. Ledger><Compress Item Ledger><Compress Res. Ledger><Compress Job Ledger><Item Reclass. Journal><Phys. Inventory Journal><Compress Bank Acc. Ledger><Compress Check Ledger><Financially Voided Check><Finance Charge Memo><Reminder><Deleted Document><Adjust Add. Reporting Currency><Trans. Bank Rec. to Gen. Jnl.><IC General Journal><Unapplied Empl. Entry Appln.><Unapplied Sales Entry Appln.><Unapplied Purch. Entry Appln.><Reversal><Employee Entry Application><Payment Reconciliation Journal><Cash Flow Worksheet><Assembly><Job G/L Journal><Job G/L WIP><G/L Entry to CA><Cost Journal><Cost Allocation><Transfer Budget to Actual><Consumption Journal><Output Journal><Flushing><Capacity Journal><Production Journal><Fixed Asset Journal><Fixed Asset G/L Journal><Insurance Journal><Compress FA Ledger><Compress Maintenance Ledger><Compress Insurance Ledger><Transfer><Revaluation Journal><Adjust Cost><Service Management><Compress Item Budget><Whse. Item Journal><Whse. Phys. Invt. Journal><Whse. Reclassification Journal><Whse. Put-away><Whse. Pick><Whse. Movement><Compress Whse. Entries><Source Code><Source Code><Source Code><Source Code><Source Code>

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

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
Bank Account Ledger Entry Source Code (Source Code) 1..n
CV Ledger Entry Buffer Source Code (Source Code) 1..n
Cost Budget Entry Source Code (Source Code) 1..n
Cost Entry Source Code (Source Code) 1..n
Cost Journal Line Source Code (Source Code) 1..n
Cost Journal Template Source Code (Source Code) 1..n
Cust. Ledger Entry Source Code (Source Code) 1..n
Date Compr. Register Source Code (Source Code) 1..n
Default Dimension Priority Source Code (Source Code) 1..n
Detailed CV Ledg. Entry Buffer Source Code (Source Code) 1..n
Detailed Cust. Ledg. Entry Source Code (Source Code) 1..n
Detailed Employee Ledger Entry Source Code (Source Code) 1..n
Detailed Vendor Ledg. Entry Source Code (Source Code) 1..n
Employee Ledger Entry Source Code (Source Code) 1..n
FA Journal Line Source Code (Source Code) 1..n
FA Journal Template Source Code (Source Code) 1..n
FA Ledger Entry Source Code (Source Code) 1..n
FA Register Source Code (Source Code) 1..n
G/L Entry Source Code (Source Code) 1..n
G/L Register Source Code (Source Code) 1..n
Gen. Journal Line Source Code (Source Code) 1..n
Gen. Journal Template Source Code (Source Code) 1..n
Ins. Coverage Ledger Entry Source Code (Source Code) 1..n
Insurance Journal Line Source Code (Source Code) 1..n
Insurance Journal Template Source Code (Source Code) 1..n
Insurance Register Source Code (Source Code) 1..n
Invt. Post to G/L Test Buffer Source Code (Source Code) 1..n
Issued Fin. Charge Memo Header Source Code (Source Code) 1..n
Issued Reminder Header Source Code (Source Code) 1..n
Item Journal Line Source Code (Source Code) 1..n
Item Journal Template Source Code (Source Code) 1..n
Item Register Source Code (Source Code) 1..n
Job Journal Line Source Code (Source Code) 1..n
Job Journal Template Source Code (Source Code) 1..n
Job Ledger Entry Source Code (Source Code) 1..n
Job Register Source Code (Source Code) 1..n
Maintenance Ledger Entry Source Code (Source Code) 1..n
Phys. Inventory Ledger Entry Source Code (Source Code) 1..n
Posted Assembly Header Source Code (Source Code) 1..n
Purch. Cr. Memo Hdr. Source Code (Source Code) 1..n
Purch. Inv. Header Source Code (Source Code) 1..n
Purch. Rcpt. Header Source Code (Source Code) 1..n
Res. Journal Line Source Code (Source Code) 1..n
Res. Journal Template Source Code (Source Code) 1..n
Res. Ledger Entry Source Code (Source Code) 1..n
Resource Register Source Code (Source Code) 1..n
Return Receipt Header Source Code (Source Code) 1..n
Return Shipment Header Source Code (Source Code) 1..n
Reversal Entry Source Code (Source Code) 1..n
Sales Cr.Memo Header Source Code (Source Code) 1..n
Sales Invoice Header Source Code (Source Code) 1..n
Sales Shipment Header Source Code (Source Code) 1..n
Service Cr.Memo Header Source Code (Source Code) 1..n
Service Invoice Header Source Code (Source Code) 1..n
Service Register Source Code (Source Code) 1..n
Service Shipment Header Source Code (Source Code) 1..n
Source Code Setup Compress Whse. Entries (Compress Whse. Entries) 1..n
Standard General Journal Line Source Code (Source Code) 1..n
Standard Item Journal Line Source Code (Source Code) 1..n
VAT Entry Source Code (Source Code) 1..n
VAT Report Line Source Code (Source Code) 1..n
Value Entry Source Code (Source Code) 1..n
Vendor Ledger Entry Source Code (Source Code) 1..n
Warehouse Entry Source Code (Source Code) 1..n
Warehouse Journal Line Source Code (Source Code) 1..n
Warehouse Journal Template Source Code (Source Code) 1..n
Warehouse Register Source Code (Source Code) 1..n