Config / Data/Buffer Tables / ANVEDI Document Summary

ANVEDI Document Summary

This table can be used to store footer information, like the totals, of an EDI document. This is especially useful for the export of invoice data, as Microsoft Dynamics NAV 2013R2 does calculate the totals on the fly. Storing this data before exporting will help to simplify your export mappings.

The table name has changed in version 5.00 of the module. The table was previously named EDI Document Summary Line.

Fields

Document Type

This field is part of the foreign key to table EDI Document.

Document No.

This field is part of the foreign key to table EDI Document.

Document Version No.

This field is part of the foreign key to table EDI Document.

Type

This field is part of the primary key. You can use this field, as you like, but we suggest to use the values like described below.

Sum

This summary represents a total sum of the document. (The integer value of this option in the database is 0)

Vat Entry

This summary represents a sum grouped by the VAT %. (The integer value of this option in the database is 1)

Tax

This value represents a general tax, described by the Code field. (The integer value of this option in the database is 2)

Other

This line is used to sum any other information. (The integer value of this option in the database is 5)

VAT %

This field is part of the primary key. This is intended to be used in combination with the Type field option VAT. This way you can group the information on the VAT percentage.

Code

Part of the primary key. Can be used in any way you like to. The field length is 20.

VAT Base

VAT base amount.

VAT Amount

VAT amount.

Amount Including VAT

Total amount including VAT.

Line Amount

This field can be used in any way. This is a Decimal field.

Inv. Disc. Base Amount

This field can be used in any way. This is a Decimal field.

Invoice Discount Amount

This field can be used in any way. This is a Decimal field.

Quantity

This field can be used in any way. This is a Decimal field.

Calculated VAT Amount

This field can be used in any way. This is a Decimal field.

VAT Difference

This field can be used in any way. This is a Decimal field.

Allowance Amount

This field can be used in any way. This is a Decimal field.

Charge Amount

This field can be used in any way. This is a Decimal field.

Description

This field can be used in any way. This is a Text field of length 50.

Prepaid Amount

This field can be used in any way. This is a Decimal field.

Due Payable Amount

This field can be used in any way. This is a Decimal field.

Deprecated Fields

The following fields are available, but will be removed in version 5.00. We recommend not to use them anymore. You can use the EDI Contact or EDI Additional information tables instead.

VAT Identifier

This field can be used in any way. This is a Code field of length 20.

VAT Calculation Type

This field can be used in any way. This is a Option field. The value does not affect any logic of the module.

Normal VAT

(The integer value of this option in the database is 0)

Reverse Charge VAT

(The integer value of this option in the database is 1)

Full VAT

(The integer value of this option in the database is 2)

Sales Tax

(The integer value of this option in the database is 3)

Use Tax

This field can be used in any way. This is a Boolean field.

WordPress Cookie Notice by Real Cookie Banner