Diagrams


Table

Source Code Setup

DynamicsDocs.comSource Code Setup«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 230»Source CodeCode [PK,NN]Description<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 Sales Entry Appln.><Unapplied Purch. Entry Appln.><Reversal><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>

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

Fields

# Name Type
1 Primary Key (Primary Key) Code10
2 Sales (Sales) Code10
3 Purchases (Purchases) Code10
4 Inventory Post Cost (Inventory Post Cost) Code10
5 Exchange Rate Adjmt. (Exchange Rate Adjmt.) Code10
6 Post Recognition (Post Recognition) Code10
7 Post Value (Post Value) Code10
8 Close Income Statement (Close Income Statement) Code10
9 Consolidation (Consolidation) Code10
10 General Journal (General Journal) Code10
11 Sales Journal (Sales Journal) Code10
12 Purchase Journal (Purchase Journal) Code10
13 Cash Receipt Journal (Cash Receipt Journal) Code10
14 Payment Journal (Payment Journal) Code10
16 Item Journal (Item Journal) Code10
19 Resource Journal (Resource Journal) Code10
20 Job Journal (Job Journal) Code10
21 Sales Entry Application (Sales Entry Application) Code10
22 Purchase Entry Application (Purchase Entry Application) Code10
23 VAT Settlement (VAT Settlement) Code10
24 Compress G/L (Compress G/L) Code10
25 Compress VAT Entries (Compress VAT Entries) Code10
26 Compress Cust. Ledger (Compress Cust. Ledger) Code10
27 Compress Vend. Ledger (Compress Vend. Ledger) Code10
28 Compress Item Ledger (Compress Item Ledger) Code10
31 Compress Res. Ledger (Compress Res. Ledger) Code10
32 Compress Job Ledger (Compress Job Ledger) Code10
33 Item Reclass. Journal (Item Reclass. Journal) Code10
34 Phys. Inventory Journal (Phys. Inventory Journal) Code10
35 Compress Bank Acc. Ledger (Compress Bank Acc. Ledger) Code10
36 Compress Check Ledger (Compress Check Ledger) Code10
37 Financially Voided Check (Financially Voided Check) Code10
38 Finance Charge Memo (Finance Charge Memo) Code10
39 Reminder (Reminder) Code10
40 Deleted Document (Deleted Document) Code10
41 Adjust Add. Reporting Currency (Adjust Add. Reporting Currency) Code10
42 Trans. Bank Rec. to Gen. Jnl. (Trans. Bank Rec. to Gen. Jnl.) Code10
43 IC General Journal (IC General Journal) Code10
45 Unapplied Sales Entry Appln. (Unapplied Sales Entry Appln.) Code10
46 Unapplied Purch. Entry Appln. (Unapplied Purch. Entry Appln.) Code10
47 Reversal (Reversal) Code10
49 Payment Reconciliation Journal (Payment Reconciliation Journal) Code10
840 Cash Flow Worksheet (Cash Flow Worksheet) Code10
900 Assembly (Assembly) Code10
1000 Job G/L Journal (Job G/L Journal) Code10
1001 Job G/L WIP (Job G/L WIP) Code10
1100 G/L Entry to CA (G/L Entry to CA) Code10
1102 Cost Journal (Cost Journal) Code10
1104 Cost Allocation (Cost Allocation) Code10
1105 Transfer Budget to Actual (Transfer Budget to Actual) Code10
5400 Consumption Journal (Consumption Journal) Code10
5402 Output Journal (Output Journal) Code10
5403 Flushing (Flushing) Code10
5404 Capacity Journal (Capacity Journal) Code10
5500 Production Journal (Production Journal) Code10
5600 Fixed Asset Journal (Fixed Asset Journal) Code10
5601 Fixed Asset G/L Journal (Fixed Asset G/L Journal) Code10
5602 Insurance Journal (Insurance Journal) Code10
5603 Compress FA Ledger (Compress FA Ledger) Code10
5604 Compress Maintenance Ledger (Compress Maintenance Ledger) Code10
5605 Compress Insurance Ledger (Compress Insurance Ledger) Code10
5700 Transfer (Transfer) Code10
5800 Revaluation Journal (Revaluation Journal) Code10
5801 Adjust Cost (Adjust Cost) Code10
5900 Service Management (Service Management) Code10
7139 Compress Item Budget (Compress Item Budget) Code10
7300 Whse. Item Journal (Whse. Item Journal) Code10
7302 Whse. Phys. Invt. Journal (Whse. Phys. Invt. Journal) Code10
7303 Whse. Reclassification Journal (Whse. Reclassification Journal) Code10
7304 Whse. Put-away (Whse. Put-away) Code10
7305 Whse. Pick (Whse. Pick) Code10
7306 Whse. Movement (Whse. Movement) Code10
7307 Compress Whse. Entries (Compress Whse. Entries) Code10

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Compress Whse. Entries (Compress Whse. Entries) Source Code Code (Code) 1..n

Table Relations From Other Tables

From Table From Field