Diagrams


Table

VAT Clause

DynamicsDocs.comVAT Clause«Table 560»VAT ClauseCode [PK,NN]DescriptionDescription 2Last Modified DateTimeId«Table 113»Sales Invoice LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeShipment No....«Table 115»Sales Cr.Memo LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeBill-to Customer No....«Table 290»VAT Amount LineVAT %VAT BaseVAT AmountAmount Including VATVAT Identifier [PK]Line AmountInv. Disc. Base AmountInvoice Discount AmountVAT Calculation Type; [Normal VAT,Reve...Tax Group Code [PK]QuantityModifiedUse Tax [PK]Calculated VAT AmountVAT DifferencePositive [PK]Includes PrepaymentVAT Clause CodeTax Category«Table 296»Reminder LineReminder No. [PK]Line No. [PK,NN]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.No. of RemindersPosting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Reminder Line,Not Due,Begi...VAT Clause CodeApplies-to Document Type; [,Payment,In...Applies-to Document No.System-Created Entry«Table 298»Issued Reminder LineReminder No. [PK]Line No. [PK]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.No. of RemindersPosting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Reminder Line,Not Due,Begi...VAT Clause CodeApplies-To Document Type; [,Payment,In...Applies-To Document No.System-Created Entry«Table 303»Finance Charge Memo LineFinance Charge Memo No. [PK]Line No. [PK,NN]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.Posting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Finance Charge Memo Line,B...VAT Clause CodeSystem-Created Entry«Table 305»Issued Fin. Charge Memo LineFinance Charge Memo No. [PK]Line No. [PK]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.Posting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierVAT Clause CodeSystem-Created Entry«Table 325»VAT Posting SetupVAT Bus. Posting Group [PK]VAT Prod. Posting Group [PK]VAT Calculation Type; [Normal VAT,Reve...VAT %Unrealized VAT Type; [,Percentage,Firs...Adjust for Payment DiscountSales VAT AccountSales VAT Unreal. AccountPurchase VAT AccountPurch. VAT Unreal. AccountReverse Chrg. VAT Acc.Reverse Chrg. VAT Unreal. Acc.VAT IdentifierEU ServiceVAT Clause CodeCertificate of Supply RequiredTax CategoryDescriptionUsed in Ledger Entries«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 561»VAT Clause TranslationVAT Clause Code [PK]Language Code [PK]DescriptionDescription 2«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«Table 5993»Service Invoice LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Shipment Line No.Bill-to Customer No....«Table 5995»Service Cr.Memo LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Bill-to Customer No.Inv. Discount AmountGen. Bus. Posting Group...<VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><VAT Clause Code><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Description Text250
3 Description 2 Text250
10 Last Modified DateTime DateTime Editable: No
8000 Id GUID

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
Finance Charge Memo Line VAT Clause Code 1..n
Issued Fin. Charge Memo Line VAT Clause Code 1..n
Issued Reminder Line VAT Clause Code 1..n
Reminder Line VAT Clause Code 1..n
Sales Cr.Memo Line VAT Clause Code 1..n
Sales Invoice Line VAT Clause Code 1..n
Sales Line VAT Clause Code 1..n
Service Cr.Memo Line VAT Clause Code 1..n
Service Invoice Line VAT Clause Code 1..n
Service Line VAT Clause Code 1..n
VAT Amount Line VAT Clause Code 1..n
VAT Clause Translation VAT Clause Code 1..n
VAT Posting Setup VAT Clause Code 1..n