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 Code10 NotBlank: Yes
2 Description Text50

Keys

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