Diagrams


Table

G/L - Item Ledger Relation

DynamicsDocs.comG/L - Item Ledger Relation«Table 5823»G/L - Item Ledger RelationG/L Entry No. [PK,NN]Value Entry No. [PK,NN]G/L Register No.«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«Table 5802»Value EntryEntry No. [PK]Item No.Posting DateItem Ledger Entry Type; [Purchase,Sale...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupItem Ledger Entry No.Valued QuantityItem Ledger Entry QuantityInvoiced QuantityCost per UnitSales Amount [Actual]Salespers./Purch. CodeDiscount AmountUser IDSource CodeApplies-to EntryGlobal Dimension 1 CodeGlobal Dimension 2 CodeSource Type; [,Customer,Vendor,Item]Cost Amount [Actual]Cost Posted to G/LReason CodeDrop ShipmentJournal Batch NameGen. Bus. Posting GroupGen. Prod. Posting Group...«Table 45»G/L RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom VAT Entry No.To VAT Entry No.Reversed<G/L Entry No.><Value Entry No.><G/L Register No.><Reversed by Entry No.><Reversed Entry No.><From Entry No.><To Entry No.>

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

Fields

# Name Type
1 G/L Entry No. Integer NotBlank: Yes
2 Value Entry No. Integer NotBlank: Yes
3 G/L Register No. Integer

Keys

# Fields
0 G/L Entry No.,Value Entry No. Clustered: Yes
1 Value Entry No.
2 G/L Register No.

Table Relations To Other Tables

Field Related Table Related Field
G/L Entry No. G/L Entry Entry No. 1..n
G/L Register No. G/L Register No. 1..n
Value Entry No. Value Entry Entry No. 1..n

Table Relations From Other Tables

From Table From Field