Positions

1 to n positions can be transmitted in a single transmission. A position is distinguished by the following attributes:

• Item number of the customer (foreign part number FPN)
• Customer factory (CF)
• Unloading point (UP)
• Order number (ON)
• Changing index (CI)
  

The scheduling agreement of a position can be reached via the position’s context menu (right click on a position and select ‘Position data’):

• Position data

# (@IAG_HSV3.LineID):
Contains a ongoing number within the history.

Customer factory (@IAG_HSV3.U_Wrk):
Contains the customer’s factory (CF).

Unloading point (@IAG_HSV3.U_Abl):
Contains the customer’s unloading point (UP).

Order number (@IAG_HSV3.U_ABS):
Contains the contract number which underlies the partner sales order.

Changing index (@IAG_HSV3.U_Aix):
Contains the customer’s changing index.

Foreign part number (@IAG_HSV3.U_Fsn):
Contains the customer’s item number – also called foreign part number (FPN). Since the leading whitespaces are not saved in Business One, a “~” is automatically put in front of the FPN if it begins with a whitespace. Item numbers with whitespaces are mainly used by the VW group.

Status (@IAG_HSV3.U_Hsvsts):
Contains the processing status. The following options are possible:

Value	Meaning	Description
1	created	Means that the position was not further processed.
2	Transfer failed	Means that the position was not inherited properly. This status is assigned only to the business processes LSR and GUT.
9	done	The position was processed successfully

Order number (@IAG_HSV3.U_Docnum):
Contains the partner sales order number which was found via the feature processing. The link-button (yellow arrow) points to the partner sales order.

Item ID from PO (@IAG_HSV3.U_Itemcode):
Contains the item ID which was assigned to the partner sales order. The link-button (yellow arrow) points to the item master data.

Item name (@IAG_HSV3.U_Itemname):
Contains the item description out of the partner sales order.

Limiting date (@IAG_HSV3.U_Agrdat):
Contains the “date of last delivery”. It is also called “limiting date”, because this date separates the past from the future in this scheduling agreement. Basically the allocations in the scheduling agreement are situated in the future.

Cumulative received quantity (@IAG_HSV3.U_EFZ):
Contains the cumulative quantity received (CQR) of the customer. It is the total of all engrossed deliveries of the customer in the period between date of zero position and the limiting date.

Cumulative outgoing quantity

Residue (@IAG_HSV3.U_Rst):
Contains the amount of residue of the customer. Per definition, the amount of residue should have been transmitted to the vendor once before. As the amount of residue is not assigned to any date (as in an allocation), it should be satisfied as fast as possible.

Instant stock (@IAG_HSV3.U_Sst):
Contains the immediate requirement (instant stock) of the customer. Per definition, the immediate requirement is a new demand of the customer. As the immediate requirement is not assigned to any date (as in an allocation), it should be satisfied as fast as possible.

last collected dn (@IAG_HSV3.U_Ltzlsn):
Contains the last engrossed delivery note of the customer. The link-button (yellow arrow) points to the delivery note.

!The delivery note number of the ESP withdrawal is saved in the business process “withdrawal at the external service provider (ESP)” (LSR 36). This number is also known as the external delivery note number. The business process GUT (Credit Note) refers to this number.

!In the business process GUT (Credit Note) the delivery note number, which the credit memo refers to, is saved here. If it is a normal delivery, it is the delivery note number of the vendor. If it is a ESP (external service provider) withdrawal, this delivery note number also refers to the ESP withdrawal.

Quantity of last coll. dn (@IAG_HSV3.U_Ltzlsm):
Contains the delivery note quantity of the last engrossed delivery note at the customer’s. This quantity is included in the CQR (cumulative quantity received).

! The delivery note quantity of the ESP withdrawal is saved in the business process “withdrawal at the external service provider (ESP)” (LSR 36).

!In the business process GUT (Credit Note) the delivery note quantity, which the credit memo refers to, is saved here.

Date of last coll. dn (@IAG_HSV3.U_Ltzlsd):
Contains the date of the last engrossed delivery note at the customer’s.

! The date of the ESP withdrawal is saved in the business process “withdrawal at the external service provider (ESP)” (LSR 36).

!In the business process GUT (Credit Note) the delivery note date, which the credit memo refers to, is saved here.

penultimate coll. dn (@IAG_HSV3.U_Ltzlsn2):
Contains the penultimate engrossed delivery note of the customer. This information is not transmitted with the forecast delivery schedule of the VDA (automobile association) message. The link-button (yellow arrow) points to the delivery note.

!The original delivery note number (used by the vendor to send the goods to the external service provider (ESP)) is saved in the business process “withdrawal at the ESP” (LSR 36).

Quantity of penultimate coll. dn (@IAG_HSV3.U_Ltzlsm2):
Contains the delivery note quantity of the penultimate engrossed delivery note at the customer’s.

!The original delivery note quantity (the quantity of the delivery note used by the vendor to send the goods to the external service provider (ESP)) is saved in the business process “withdrawal at the ESP” (LSR 36).

Date of penultimate coll. dn (@IAG_HSV3.U_Ltzlsd2):
Contains the date of the penultimate engrossed delivery note at the customer’s. This information is not transmitted with the forecast delivery schedule of the VDA (automobile association) message.

!The original delivery note date (the date of the delivery note used by the vendor to send the goods to the external service provider (ESP)) is saved in the business process “withdrawal at the ESP” (LSR 36).

antepenultimate coll. dn (@IAG_HSV3.U_Ltzlsn3):
Contains the antepenultimate engrossed delivery note of the customer. This information is not transmitted with the forecast delivery schedule of the VDA (automobile association) message. The link-button (yellow arrow) points to the delivery note.

!The delivery note number generated through the feature processing is saved in the business process “withdrawal at the ESP” (LSR 36).

Quantity of antepenultimate coll. dn (@IAG_HSV3.U_Ltzlsm3):
Contains the delivery note quantity of the antepenultimate engrossed delivery note at the customer’s.

!The quantity of the delivery note generated through the feature processing is saved in the business process “withdrawal at the ESP” (LSR 36).

Date of antepenultimate coll. dn (@IAG_HSV3.U_Ltzlsd3):
Contains the date of the antepenultimate engrossed delivery note at the customer’s. This information is not transmitted with the forecast delivery schedule of the VDA (automobile association) message.

!The date of the delivery note generated through the feature processing is saved in the business process “withdrawal at the ESP” (LSR 36).

Material handling code (@IAG_HSV3.U_Mhdcod):
Contains the “material handling code” transmitted by the customer. This information is generally transmitted by GM.

Kanban complementing item code (@IAG_HSV3.U_Kanban):
Contains the KANBAN number or a complementary item code number transmitted by the customer. This information is generally transmitted by GM.

PUS-Number (@IAG_HSV3.U_Pusnr):
Contains the “pick up shit” number transmitted by the customer. This information is generally transmitted by GM.

Point of consumption (@IAG_HSV3.U_Verbrs):
Contains the point of consumption at the customer’s.

Usage Key (@IAG_HSV3.U_Vrwkey):
Contains the usage key (e.g. “S” for serial items, “R” for replacement part,…).

Handelspräferenzschlüssel / trade preference key (@IAG_HSV3.U_Hprkey):
Contains the trade preference.

Country of origin (@IAG_HSV3.U_Urslnd):
Contains the country of origin of the goods (e.g. for Germany 004).

Obligatory taking date (@IAG_HSV3.U_Abndat):
Contains the date until the customer is obliged to receive the goods.

Comparison date for cprcq (@IAG_HSV3.U_Vrgdat):
Contains the date for the comparison CQR (cumulative quantity received).

min. delivery (@IAG_HSV3.U_Lifmin):
Contains the minimum delivery quantity.

Processing approval in months (@IAG_HSV3.U_Frtfrm):
Contains the number of months for the processing approval.

Processing approval date from (@IAG_HSV3.U_Frtfrdv):
Contains the date when the processing approval becomes effective.

Processing approval date to (@IAG_HSV3.U_Frtfrdb):
Contains the date until the processing approval is effective.

Material approval in months (@IAG_HSV3.U_Matfrm):
Contains the number of months for the material approval.

Material approval date from (@IAG_HSV3.U_Matfrdv):
Contains the date when the material approval is effective.

Material approval date to (@IAG_HSV3.U_Matfrdb):
Contains the date until the material approval is effective.

Shipping address (@IAG_HSV3.U_Shiptocd):
Contains the shipping address.

Payment address (@IAG_HSV3.U_Paytocd):
Contains the payment address.

New delivery schedule number (@IAG_HSV3.U_Labnrn):
Contains the forecast delivery schedule number for this scheduling agreement. The customer operates one delivery schedule number per position.

*Please do not confuse this with the EDI number.

New delivery schedule date (@IAG_HSV3.U_Labdtn):
Contains the date of the forecast delivery schedule.

EDI sequence No. (@IAG_HSV3.U_Dfseqnr):
Contains the ongoing number out of the EDI transmission.

Old delivery schedule number (@IAG_HSV3.U_Labnra):
Contains the last forecast delivery schedule number.

Old delivery schedule date (@IAG_HSV3.U_Labdta):
Contains the date of the last forecast delivery schedule.

Ordered quantity (Sum) (@IAG_HSV3.U_Abnmng):
Contains the ordered quantity.

Comp. cum. rec. quantity (@IAG_HSV3.U_Vrgefz):
Comparison cumulated received quantity. Contains the CQR (cumulated quantity received) attained at the “null position date”.

Compare timeframe in cal. days (@IAG_HSV3.U_Vrgzrm):
Contains the number of calendar days between the “null position date” […]

Delivery multiples (@IAG_HSV3.U_Lifvlf):
Contains delivery multiples.

Null position date (@IAG_HSV3.U_Nstdat):
Contains the null position date / date of zero position. Sadly this date is rarely transmitted.

Customer reference number ext. (@IAG_HSV3.U_Extref):
Contains a reference number of the customer.

Price per unit (@IAG_HSV3.U_Gutep):
Contains the individual price which the customer is willing to pay for the delivery. This information is transmitted only in the business process “GUT” (credit note).

VAT sum (@IAG_HSV3.U_Gmwbtr):
Contains the VAT for this position. This information is transmitted only in the business process “GUT” (credit note).

Net amount (@IAG_HSV3.U_Gntbtr):
Contains the net amount of the position. This information is transmitted only in the business process “GUT” (credit note).

Gross amount (@IAG_HSV3.U_Gbtbtr):
Contains the gross amount of the position. This information is transmitted only in the business process “GUT” (credit note).

Cashback amount (@IAG_HSV3.U_Gskbtr):
Contains the amount of cashback of the position. This information is transmitted only in the business process “GUT” (credit note).

Warehouse customer (@IAG_HSV3.U_Lgokd):
Contains the customer’s storage location (warehouse).

Production number (@IAG_HSV3.U_Prodnr):
Contains the production number. Is generally transmitted with the forecast delivery schedule.

Creation user (@IAG_HSV3.U_Anlusr):
Contains the user who handled the transmission.

Creation date (@IAG_HSV3.U_Anldat):
Contains the creation date of the position.

Creation time (@IAG_HSV3.U_Anlzet):
Contains the creation time of the position.

Update user (@IAG_HSV3.U_Updusr):
Contains the user who was the last to update the position.

Update date (@IAG_HSV3.U_Upddat):
Contains the date when the position was last updated.

Update time (@IAG_HSV3.U_Updzet):
Contains the time when the position was last updated.

Copyright © 2018 init consulting AG