Config / Data/Buffer Tables / ANVEDI Document Line

ANVEDI Document Line

This table stores line data for an EDI Document. With a few exceptions, fields in this table does not have a table relation or validation logic. The main idea is to be able to import data, even if there is no corresponding master data. The few fields with validation logic are build in a way, that they do not throw errors.

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

Special Fields

The fields in this section have at least some logic or special meaning. In the following section we will document all other fields.

Document Type

This field is part of the primary key of this table. This is a foreign key and should contain the document type of the EDI Document header.

Document No.

This field is part of the primary key of this table. This is a foreign key and should contain the document number of the EDI Document header.

Document Version No.

This field is part of the primary key of this table. This is a foreign key and should contain the document version of the EDI Document header.

Line No.

This field is part of the primary key of this table. We recommend assigning this number automatically from the mapping, by using the auto increment field. There is a field External Line No. that can be used to store a separate line number for the EDI partner.

Type

Sets the type of the line. This will affect how the field No. is interpreted. To be able to use the lookup from the No. field, you have to set the type.

The number has no special meaning. (The integer value of this option in the database is 0)

G/L Account

The number represents a G/L Account. (The integer value in the database is 1)

Item

The number is a item number. (The integer value in the database is 2)

Resource

The number contains a resource. (The integer value in the database is 3)

Fixed Asset

The number contains a fixed asset. (The integer value in the database is 4)

Charge (Item)

The number contains an item charge. (The integer value in the database is 5)

EDI Document

The number field contains another EDI Document. In case you change the status of an EDI Document the status will be transferred to all lines of type EDI Document.

(The integer value in the database is 12)

No.

Is used to store an number, that can further be defined by the Type.

GTIN/EAN

Use Ext. Item No. instead, if possible.

GTIN/EAN Cross Reference Type

If a cross-reference is set the module tries to set the No. for incoming documents from the EAN and vice versa for outgoing ones. If there is no match found, the fields remain unchanged.

System Document Source

This field can be used together with the next fields to specify the source for an outgoing EDI Document Lines. This field has to be set from the mapping manually.

There is no special source table. (The integer value for this option in the database is 0)

Sales

The EDI Document is created from a sales header.
(The integer value for this option in the database is 1)

Purchase

The EDI Document is created from a purchase header.
(The integer value for this option in the database is 2)

Sales Archive

The EDI Document is created from a sales archive header.
(The integer value for this option in the database is 3)

Purchase Archive

The EDI Document is created from a purchase archive header.
(The integer value for this option in the database is 4)

Sales Shipment

The EDI Document is created from a sales shipment header.
(The integer value for this option in the database is 10)

Sales Invoice

The EDI Document is created from a sales invoice header.
(The integer value for this option in the database is 11)

Sales Cr.Memo

The EDI Document is created from a sales credit memo header.
(The integer value for this option in the database is 12)

Sales Return

The EDI Document is created from a sales return header.
(The integer value for this option in the database is 13)

Purchase Receipt

The EDI Document is created from a purchase receipt.
(The integer value for this option in the database is 18)

Purchase Invoice

The EDI Document is created from a purchase invoice header.
(The integer value for this option in the database is 19)

Purchase Cr. Memo

The EDI Document is created from a purchase credit memo header.
(The integer value for this option in the database is 20)

Return Shipment

The EDI Document is created from a return shipment header.
(The integer value for this option in the database is 21)

Warehouse Receipt Header

The EDI Document is created from a warehouse receipt header.
(The integer value for this option in the database is 26)

Warehouse Shipment Header

The EDI Document is created from a warehouse shipment header.
(The integer value for this option in the database is 27)

Warehouse Activity Header

The EDI Document is created from a warehouse activity header.
(The integer value for this option in the database is 28)

System Document Type

Can be used to store the system document type, if applicable.

System Document No.

Can be used to store the source system document number. This field has a lookup defined to the system tables specified above.

System Document Line No.

Can be used to store the source system document line number.

External Line No.

This field can be used to store the partner’s line number.

Ext. Item No.

Used to store the item number transferred by the EDI partner.

Ext. Item No. Cross.Ref. Type

If a cross-reference is set the module tries to set the No. for incoming documents from the Ext. Item No. and vice versa for outgoing ones. If there is no match found, the fields remain unchanged.

Linked Document Type

This field can be used if the line identifies an EDI Document, to specify the document type

Linked Version No.

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

General Purpose Fields

Please be aware that not all fields are available in the page. If the information is important, please make sure that the field is available and visible to the end-user.

Buyer Item No.

This field is part of the primary key. This field can be used in any way. This is a Text field of length 30.

Buyer Order No.

This field is part of the primary key. This field can be used in any way. This is a Text field of length 30.

Buyer Order Line No.

This field is part of the primary key. This field can be used in any way. This is a Integer field.

Description

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

Description 2

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

Unit of Measure

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

Quantity

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

Unit Price

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

Unit Price Incl. Charge/Disc

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

VAT %

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

VAT Amount

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

Line Discount %

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

Line Discount Amount

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

Amount

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

Amount Including VAT

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

Allow Invoice Disc.

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

Gross Weight

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

Net Weight

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

Units per Parcel

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

Unit Volume

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

Action Request/Notification

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

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

Added

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

Deleted

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

Changed

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

No Action

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

Accepted Without Amendment

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

Accepted With Amendment

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

Not Accepted

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

Schedule Only

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

Amendments

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

Not Found

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

Not Amended

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

Line Item Number Changed

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

Shortcut Dimension 1 Code

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

Shortcut Dimension 2 Code

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

Job No.

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

Tariff No.

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

Outstanding Amount

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

Quantity Shipped

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

Quantity Invoiced

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

Shipment No.

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

Shipment Line No.

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

Inv. Discount Amount

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

Drop Shipment

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

Transaction Type

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

Transport Method

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

Exit Point

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

Area

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

Transaction Specification

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

Currency Code

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

VAT Base Amount

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

Unit Cost

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

Recommended Sales Price

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

Recommended Cost Price

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

Line 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.

Line Amount Excl. Charg./Disc.

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

Application Key

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

Dutiable Goods

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

Height

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

Width

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

Depth

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

Variant Code

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

Bin Code

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

Qty. per Unit of Measure

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

Unit of Measure Code

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

Quantity (Base)

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

Originally Ordered No.

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

Originally Ordered Var. Code

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

Item Category Code

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

Completely Shipped

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

Requested Delivery Time

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

Requested Delivery Date

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

Promised Delivery Date

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

Planned Delivery Date

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

Planned Shipment Date

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

Shipping Agent Code

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

Shipping Agent Service Code

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

Release Date

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

Expiration Date

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

Return Qty. Received

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

Return Qty. Received (Base)

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

BOM Item No.

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

Unit of Measure Code 2

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

Unit of Measure Code 3

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

Serial No.

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

Lot No.

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

Warranty Date

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

External Lot No.

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

Return Reason Code

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

Shipment Date

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

Outstanding Quantity

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

Qty. to Invoice

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

Qty. to Ship

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

Quantity Confirmed

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

Quantity Declined

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

Auto No.

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

Desired Unit Price

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

Parent Line No.

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

Indent

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

Deprecated Fields

The following fields are removed in version 5.00 of the module and are not available anymore. If you want to update an existing system and you’re using the FOB-Version of the module, you can keep the old buffer tables. If you’re using the Extension you might want to add some of the fields back using a custom extension.

In new projects we recommend to use the EDI Adress/Contact and EDI Additional Information to store the information.

Status Icon

Used internally. Do not use.

Status

Used internally. Do not use.

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

Information

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

Warning

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

Error

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

Base Unit of Measure Code

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

Price Difference Warning

Deprecated.

Desired Unit Price Type

Deprecated.

Unit Price Diff. Type

Deprecated.

Allowed Unit Price Diff.

Deprecated.

Customer Price Group

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

Work Type Code

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

Qty. Shipped Not Invoiced

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

Shipped Not Invoiced

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

Profit %

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

Bill-to Customer No.

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

Purchase Order No.

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

Purch. Order Line No.

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

Gen. Bus. Posting Group

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

Gen. Prod. Posting Group

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

VAT Calculation Type

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

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)

Tax Area Code

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

Tax Liable

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

Tax Group Code

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

VAT Bus. Posting Group

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

VAT Prod. Posting Group

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

Reserve

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

Never

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

Optional

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

Always

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

Blanket Order No.

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

Blanket Order Line No.

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

VAT Identifier

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

Planned

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

Nonstock

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

Purchasing Code

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

Product Group Code

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

Special Order

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

Special Order Purchase No.

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

Special Order Purch. Line No.

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

Shipping Time

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

Outbound Whse. Handling Time

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

Allow Item Charge Assignment

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

Return Qty. to Receive

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

Return Qty. Rcd. Not Invd.

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

Return Rcd. Not Invd.

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

Return Receipt No.

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

Return Receipt Line No.

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

Allow Line Disc.

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

Customer Disc. Group

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

Basis of Unit Price Code

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

Sell-to Customer No.

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