Diagrams


Table

IC G/L Account

DynamicsDocs.comIC G/L Account«Table 410»IC G/L AccountNo. [PK,NN]NameAccount Type; [Posting,Heading,Total,B...Income/Balance; [Income Statement,Bala...BlockedMap-to G/L Acc. No.Indentation«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«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 415»IC Outbox Jnl. LineTransaction No. [PK]IC Partner Code [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.AmountDescriptionVAT AmountCurrency CodeDue DatePayment Discount %Payment Discount DateQuantityTransaction Source; [Rejected by Curre...Document No.«Table 417»Handled IC Outbox Jnl. LineTransaction No. [PK]IC Partner Code [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.AmountDescriptionVAT AmountCurrency CodeDue DatePayment Discount %Payment Discount DateQuantityTransaction Source; [Rejected by Curre...Document No.«Table 419»IC Inbox Jnl. LineTransaction No. [PK]IC Partner Code [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.AmountDescriptionVAT AmountCurrency CodeDue DatePayment Discount %Payment Discount DateQuantityTransaction Source; [Returned by Partn...Document No.«Table 421»Handled IC Inbox Jnl. LineTransaction No. [PK]IC Partner Code [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.AmountDescriptionVAT AmountCurrency CodeDue DatePayment Discount %Payment Discount DateQuantityTransaction Source; [Returned by Partn...Document No.«Table 427»IC Outbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Shipment No.Shipment Line No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Delivery DatePromised Delivery DateReturn Receipt No.Return Receipt Line No.«Table 429»IC Outbox Purchase LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Receipt DatePromised Receipt Date«Table 431»Handled IC Outbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Shipment No.Shipment Line No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Delivery DatePromised Delivery DateReturn Receipt No.Return Receipt Line No.«Table 433»Handled IC Outbox Purch. LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Receipt DatePromised Receipt Date«Table 435»IC Inbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Delivery DatePromised Delivery Date«Table 437»IC Inbox Purchase LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Receipt No.Receipt Line No.Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Receipt DatePromised Receipt DateReturn Shipment No.Return Shipment Line No.«Table 439»Handled IC Inbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Delivery DatePromised Delivery Date«Table 441»Handled IC Inbox Purch. LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Receipt No.Receipt Line No.Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Unit of Measure CodeRequested Receipt DatePromised Receipt DateReturn Shipment No.Return Shipment Line No.«Table 751»Standard General Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Account Type; [G/L Account,Customer,Ve...Account No.Document Type; [,Payment,Invoice,Credi...DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Payment Discount %Job No.QuantityVAT AmountPayment Terms Code...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...<Map-to G/L Acc. No.><Default IC Partner G/L Acc. No><IC Partner Purch. G/L Acc. No.><Account No.><Account No.><Account No.><Account No.><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner G/L Acc. No.><IC Partner G/L Acc. No.><Account No.><Bal. Account No.><Account No.><Bal. Account No.><Account Id>

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

Fields

# Name Type
1 No. Code20 NotBlank: Yes
2 Name Text50
3 Account Type Option
4 Income/Balance Option
5 Blocked Boolean
6 Map-to G/L Acc. No. Code20
7 Indentation Integer

Keys

# Fields
0 No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Map-to G/L Acc. No. G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field
G/L Account Default IC Partner G/L Acc. No 1..n
Gen. Journal Line IC Partner G/L Acc. No. 1..n
Handled IC Inbox Jnl. Line Account No. 1..n
Handled IC Inbox Purch. Line IC Partner Reference 1..n
Handled IC Inbox Sales Line IC Partner Reference 1..n
Handled IC Outbox Jnl. Line Account No. 1..n
Handled IC Outbox Purch. Line IC Partner Reference 1..n
Handled IC Outbox Sales Line IC Partner Reference 1..n
IC Inbox Jnl. Line Account No. 1..n
IC Inbox Purchase Line IC Partner Reference 1..n
IC Inbox Sales Line IC Partner Reference 1..n
IC Outbox Jnl. Line Account No. 1..n
IC Outbox Purchase Line IC Partner Reference 1..n
IC Outbox Sales Line IC Partner Reference 1..n
Resource IC Partner Purch. G/L Acc. No. 1..n
Standard General Journal Line IC Partner G/L Acc. No. 1..n