Diagrams

Table

Invt. Post to G/L Test Buffer

DynamicsDocs.comInvt. Post to G/L Test Buffer«Table 5822»Invt. Post to G/L Test BufferLine No. [PK]Account No.Posting DateDocument No.DescriptionAmountSource CodeSystem-Created EntryGen. Bus. Posting GroupGen. Prod. Posting GroupAdditional-Currency Posting; [None,Amo...Source Currency CodeSource Currency AmountValue Entry No.Location CodeInvt. Posting Group CodeInventory Account Type; [Inventory <In...Dimension Set ID«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 230»Source CodeCode [PK,NN]Description«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«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 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Account No.><Source Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Source Currency Code><Value Entry No.><Location Code><Invt. Posting Group Code><Dimension Set ID><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Source Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Location Code><Inventory Posting Group><Source Posting Group><Dimension Set ID>

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

Fields

# Name Type
1 Line No. (Line No.) Integer
2 Account No. (Account No.) Code20
3 Posting Date (Posting Date) Date [ClosingDates:Yes]
4 Document No. (Document No.) Code20
5 Description (Description) Text50
6 Amount (Amount) Decimal
8 Source Code (Source Code) Code10 Editable: No
9 System-Created Entry (System-Created Entry) Boolean Editable: No
10 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code20
11 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code20
13 Additional-Currency Posting (Additional-Currency Posting) Option Editable: No
14 Source Currency Code (Source Currency Code) Code10 Editable: No
15 Source Currency Amount (Source Currency Amount) Decimal Editable: No
16 Value Entry No. (Value Entry No.) Integer Editable: No
17 Location Code (Location Code) Code10
18 Invt. Posting Group Code (Invt. Posting Group Code) Code20
19 Inventory Account Type (Inventory Account Type) Option
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Line No. (Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Source Currency Code (Source Currency Code) Currency Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Account No. (Account No.) G/L Account No. (No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Invt. Posting Group Code (Invt. Posting Group Code) Inventory Posting Group Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
Value Entry No. (Value Entry No.) Value Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field