Interface: ORDE - Stocktaking Version 2012.00

This documentation describes the AbaConnect Interface Stocktaking for the ORDE Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :ORDE
Interface Name :Stocktaking
ID :Inventur ( IV )
Version :2012.00
Status:Expiring (Available until Abacus V2024)


Displays the possible import and export features for this interface.

Export / Import Modus
Export :XML
Import :XML


Displays additional information for this interface.

Additional Information

                                  Highest field Revision for this interface : 0



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :Stocktaking
Description :



Example AbaConnect XML Structure

The following is an example of an XML Header structure. This information is also visible in an AbaConnect XML Export file, that has been exported via the Abacus AbaConnect User Interface.

AbaConnect XML Struktur
<?xml version='1.0' encoding='UTF-8'?>
<AbaConnectContainer>
  <TaskCount>1</TaskCount>
  <Task>
    <Parameter>
      <Application>ORDE</Application>
      <Id>Inventur</Id>
      <MapId>AbaDefault</MapId>
      <Version>2012.00</Version>
      <!-- Attention : The client number (Mandant) is optional and implies that the data can only be imported into specified client (Mandant) -->
      <!-- The Client Option (Mandant) only has an influence when importing data. It can be configured in the AbaConnect Export Settings. -->
      <!-- By default, the client number (Mandant) is not written to the export file -->
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <StocktakingHeader mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </StocktakingHeader>
    </Transaction>
  </Task>
</AbaConnectContainer>



Example AbaConnect Command Line

The following includes examples of AbaConnect Command Line. The AbaConnect Command Line is executed with the abaconnectexportconsole.exe and abaconnectimportconsole.exe programmes. The AbaConnect Command Line must be run direct on the Abacus server. More detailed information about AbaConnect Command Line is available on the Abacus Homepage. The following examples serve as starting point for creating a simple command line.

AbaConnect Command Line
Export :
abaconnectexportconsole.exe "/USRuser" "/PWxxx"  "-aORDE"  "-version2012.00"  "-M7777"  "-acidInventur"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aORDE"  "-version2012.00"  "-M7777"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-importfileX:\data.xml"

N.B. : For importing XML data, it is not necessary to specify the Interface ID and Mapping on the Command Line. This information is contained in the XML Import file.



Mapping Structure

The following displays a simplified mapping structure for this interface.
The XML-Element and Parent-Name are always in english. Click on the row to display additional information.

XML Element Name Field Name Parent Name Type Length Mandatory
StocktakingHeaderInventory header data---No
    StocktakingHeaderFieldsFieldsStocktakingHeader--No
        - StocktakingNumberInventory no. (INV_NR)
StocktakingHeaderFieldsNumber10No
        - StocktakingDateInventory date (INV_DATUM)
StocktakingHeaderFieldsDate-No
        - StocktakingDesignationInventory designation (INV_BEZ)
StocktakingHeaderFieldsText30No
        - UserNumberUser no. (INV_USER)
StocktakingHeaderFieldsNumber4No
        - StocktakingInitialStockFlagSelection inventory opening balance (RB_INV_ANF)
StocktakingHeaderFieldsNumber2No
        - StocktakingQuantityBookedFlagEntered inventory quantities (CB_MENGENBUCH)
StocktakingHeaderFieldsBoolean-No
        - BookingDateQuantityEntry date quantity (BUCHDAT_MENGE)
StocktakingHeaderFieldsDate-No
        - UserNumberQuantityBookingUser no. update quantities (USER_MENGENBUCH)
StocktakingHeaderFieldsNumber4No
        - StocktakingValueBookedEntered inventory values (CB_WERTBUCH)
StocktakingHeaderFieldsBoolean-No
        - BookingDateValueEntry date value (BUCHDAT_WERT)
StocktakingHeaderFieldsDate-No
        - UserNumberValueBookingUser no. value entry (USER_WERTBUCH)
StocktakingHeaderFieldsNumber4No
        - ValuationRateFlagTake over valuation rate (INV_BEWERTUNG)
StocktakingHeaderFieldsNumber4No
        - SelectionNumberSelection no. (SEL_NR)
StocktakingHeaderFieldsNumber12No
        - ProductNumberFromProduct no. from (ART_NRA_V)
StocktakingHeaderFieldsText30No
        - ProductNumberToProduct no. to (ART_NRA_B)
StocktakingHeaderFieldsText30No
        - ProductGroupFromProduct group From (ART_GRP_V)
StocktakingHeaderFieldsNumber8No
        - ProductGroupToProduct group to (ART_GRP_B)
StocktakingHeaderFieldsNumber8No
        - StockLocationFromStorage location from (LAO_V)
StocktakingHeaderFieldsText8No
        - BinLocationFromStorage place from (LAP_V)
StocktakingHeaderFieldsText8No
        - StockLocationToStorage location to (LAO_B)
StocktakingHeaderFieldsText8No
        - BinLocationToStorage place to (LAP_B)
StocktakingHeaderFieldsText8No
        - StocktakingLockFlagInventory blocked (REC_LOCK)
StocktakingHeaderFieldsNumber2No
        - ProvisionalStocktakingProvisional inventory (CBPROVINV)
StocktakingHeaderFieldsBoolean-No
        - MainStockLocationProposalRecommend main storage location (CBDEFLAGORT)
StocktakingHeaderFieldsBoolean-No
        - VariantIDFromVar. ID from (VAR_ID_VON)
StocktakingHeaderFieldsNumber8No
        - VariantIDToVar. ID to (VAR_ID_BIS)
StocktakingHeaderFieldsNumber8No
        - DivisionDivision no. (GSB_NR)
StocktakingHeaderFieldsNumber8No
        - StocktakingStatusStocktaking state (INV_STATUS)
StocktakingHeaderFieldsNumber2No
        - StocktakingTypeStocktaking type (INV_TYP)
StocktakingHeaderFieldsNumber2No
        - ProvisionalDefinitiveFlagprovisional/definitive (INV_PRO_DEV)
StocktakingHeaderFieldsNumber8No
    ItemInventory itemsStocktakingHeader--No
        ItemFieldsFieldsItem--No
            - StocktakingNumberInventory no. (INV_NR)
ItemFieldsNumber10No
            - StocktakingDateInventory date (INV_DATUM)
ItemFieldsDate-No
            - ItemNumberItem no. (INV_POS)
ItemFieldsNumber8No
            - StocktakingQuantityBookedFlagEntered inventory quantities (CB_MENGENBUCH)
ItemFieldsBoolean-No
            - StocktakingValueBookedEntered inventory values (CB_WERTBUCH)
ItemFieldsBoolean-No
            - StockLocationStorage location (LAGER_ORT)
ItemFieldsText8No
            - BinLocationStorage place (LAGER_PLATZ)
ItemFieldsText8No
            - ProductNumberProduct No. (ART_NRA)
ItemFieldsText30No
            - WarehouseStockWarehouse stock (LAGERBEST)
ItemFieldsNumber12No
            - StocktakingQuantityInventory quantity (INV_MENGE)
ItemFieldsNumber12No
            - StocktakingDifferenceInventory difference (INV_ABWEICHUNG)
ItemFieldsNumber12No
            - ValuationRateFlagValuation record (INV_BEWERTUNG)
ItemFieldsNumber4No
            - AverageCostPriceAverage cost price (DURCH_EP)
ItemFieldsNumber12No
            - LastCostPriceLast cost price (LETZTER_EP)
ItemFieldsNumber12No
            - LowestCostPriceLowest cost price (TIEFST_EP)
ItemFieldsNumber12No
            - ValuationPriceValuation price (BEWERT_EP)
ItemFieldsNumber12No
            - AccountExpenseACT Expense (KTO_AUFWAND)
ItemFieldsNumber12No
            - AccountStocktakingACT inventory (KTO_INVENTAR)
ItemFieldsNumber12No
            - CostCentre1ExpenseCC1 Expense (KST_AUFWAND)
ItemFieldsNumber12No
            - CostCentre2ExpenseCC2 Expense (KST2_AUFWAND)
ItemFieldsNumber12No
            - AverageCostPriceOldAverage cost price (old) (DURCH_EP_ALT)
ItemFieldsNumber12No
            - LastCostPriceOldLast cost price (old) (LETZTER_EP_ALT)
ItemFieldsNumber12No
            - LowestCostPriceOldLowest cost price (old) (TIEFST_EP_ALT)
ItemFieldsNumber12No
            - ValuationPriceOldValuation price (old) (BEWERT_EP_ALT)
ItemFieldsNumber12No
            - GeneralLedgerInterfaceDoneG/L interface flag (CBFIBUGEN)
ItemFieldsBoolean-No
            - GeneralLedgerCollectiveNumberG/L Coll.-No. (FIBUSAMNR)
ItemFieldsNumber8No
            - LastGeneralLedgerPriceOldLast G/L price (old) (LAST_FIBU_PREIS_ALT)
ItemFieldsNumber12No
            - ProcurementAverageCostPriceProcurement costs average PP (DURCH_EP_BEZKO)
ItemFieldsNumber12No
            - ProcurementLastCostPriceProcurement costs last PP (LETZTER_EP_BEZKO)
ItemFieldsNumber12No
            - ProcurementLowestCostPriceProcurement costs lowest PP (TIEFST_EP_BEZKO)
ItemFieldsNumber12No
            - ProcurementAverageCostPriceOldProcurement costs average PP (old) (DURCH_EP_ALT_BEZKO)
ItemFieldsNumber12No
            - ProcurementLastCostPriceOldProcurement costs last PP (old) (LETZTER_EP_ALT_BEZKO)
ItemFieldsNumber12No
            - ProcurementLowestCostPriceOldProcurement costs lowest PP (old) (TIEFST_EP_ALT_BEZKO)
ItemFieldsNumber12No
            - VariantNumberVariant no. (VAR_ID)
ItemFieldsNumber8No
            - DivisionDivision no. (GSB_NR)
ItemFieldsNumber8No
            - AccountSetNumberExpenseAcct set no. expenses (KONTOSETNR_AUFWAND)
ItemFieldsNumber6No
            - ItemBookingEnter item (POSITIONEN_VERBUCHT)
ItemFieldsBoolean-No
            - StockValueCurrentStock value actual (LAGERWERT)
ItemFieldsNumber12No
            - StockValueNewStock value new (LAGERWERT_NEU)
ItemFieldsNumber12No
            - StockValueDifferenceStock value difference (LAGERWERT_DIFFERENZ)
ItemFieldsNumber12No
            - ProductTypeProduct-Type (PROD_TYP)
ItemFieldsText3No
        BatchDataChargen-BuchungsdatenItem--No
            BatchDataFieldsFieldsBatchData--No
                - BatchNumberChargennummer (CHARGEN_NR)
BatchDataFieldsText30No
                - BatchSequenceNumberChargen/SNR-Folge-Nr. (CHARGEN_FNR)
BatchDataFieldsNumber4No
                - QuantityQuantity (MENGE)
BatchDataFieldsNumber12No
                - QuantityReservedMenge reserviert (MENGE_RESERV)
BatchDataFieldsNumber12No
                - OrderedQuantityQuantity ordered (MENGE_BESTELLT)
BatchDataFieldsNumber12No
                - StockQuantityWarehouse stock (LAGERBESTAND)
BatchDataFieldsNumber12No
                - DateOfReceiptEingangsdatum (EINGDAT)
BatchDataFieldsDate-No
                - ExpirationDate1Verfalldatum 1 (VERFALLDAT)
BatchDataFieldsDate-No
                - ExpirationDate2Verfalldatum 2 (VERFALLDAT2)
BatchDataFieldsDate-No
                - CertificateZeugnis (ZEUGNIS)
BatchDataFieldsText30No
                - CountryOfOriginHerkunftsland (HERKUNFT_LAND)
BatchDataFieldsText4No
                - OriginCodeHerkunft-Cd (HERKUNFT_CD)
BatchDataFieldsNumber4No
                - QualityCodeHerkunft-Cd (QUALITAET_CD)
BatchDataFieldsNumber4No
                - Remark1Remark 1 (BEMERKUNG)
BatchDataFieldsText40No
                - Remark2Remark 2 (BEMERKUNG2)
BatchDataFieldsText40No
                - Remark3Remark 3 (BEMERKUNG3)
BatchDataFieldsText40No
                - Remark4Remark 4 (BEMERKUNG4)
BatchDataFieldsText40No
                - IndividualNumeric1Ind. Benutzerfeld numerisch 1 (BENNUM1)
BatchDataFieldsNumber12No
                - IndividualNumeric2Ind. Benutzerfeld numerisch 2 (BENNUM2)
BatchDataFieldsNumber12No
                - IndividualNumeric3Ind. Benutzerfeld numerisch 3 (BENNUM3)
BatchDataFieldsNumber12No



Field Information

The following is a detailed description of the fields used in this interface.

Fields
XML Element Name:StocktakingHeaderFields
Parent Element:StocktakingHeader
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Inventory no.
XML Element Name:StocktakingNumber
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Every inventory gets a unique number
(The internal field ID for this element is "INV_NR")

Inventory date
XML Element Name:StocktakingDate
Parent Element:StocktakingHeaderFields
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Inventory date
(The internal field ID for this element is "INV_DATUM")

Inventory designation
XML Element Name:StocktakingDesignation
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Import und Export
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Inventory short description / designation
(The internal field ID for this element is "INV_BEZ")

User no.
XML Element Name:UserNumber
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
User no.
(The internal field ID for this element is "INV_USER")

Selection inventory opening balance
XML Element Name:StocktakingInitialStockFlag
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Determines whether it is an inventory or an opening balance.
Possible values:
1 = Inventory
2 = Opening balance
(The internal field ID for this element is "RB_INV_ANF")

Entered inventory quantities
XML Element Name:StocktakingQuantityBookedFlag
Parent Element:StocktakingHeaderFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
States whether an entry on a quantity basis has already been effected.
Possible values:
0 = Inventory is not entered yet on a quantity basis
1 = Inventory is entered on a quantity basis
(The internal field ID for this element is "CB_MENGENBUCH")

Entry date quantity
XML Element Name:BookingDateQuantity
Parent Element:StocktakingHeaderFields
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Date on which the entering on a quantity basis has been executed.
(The internal field ID for this element is "BUCHDAT_MENGE")

User no. update quantities
XML Element Name:UserNumberQuantityBooking
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
User number of user who initiated entering on a quantity basis.
(The internal field ID for this element is "USER_MENGENBUCH")

Entered inventory values
XML Element Name:StocktakingValueBooked
Parent Element:StocktakingHeaderFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
States whether an entry on a value basis has already been effected.
Possible values:
0 = Inventory is not entered yet on a value basis
1 = Inventory is entered on a value basis
(The internal field ID for this element is "CB_WERTBUCH")

Entry date value
XML Element Name:BookingDateValue
Parent Element:StocktakingHeaderFields
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Date on which the entering on a value basis has been executed.
(The internal field ID for this element is "BUCHDAT_WERT")

User no. value entry
XML Element Name:UserNumberValueBooking
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
User number of user who initiated entering on a value basis.
(The internal field ID for this element is "USER_WERTBUCH")

Take over valuation rate
XML Element Name:ValuationRateFlag
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Determines whether the old (up to now) valuation rate will be taken over or a new valuation rate has to be entered generally.
Possible values:
0 = Take over old valuation rate
1 = Enter new valuation rate
(The internal field ID for this element is "INV_BEWERTUNG")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Selection no.
XML Element Name:SelectionNumber
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Number of product selection for which an inventory shall be entered.
(The internal field ID for this element is "SEL_NR")

Product no. from
XML Element Name:ProductNumberFrom
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "ART_NRA_V")
                    

Product no. to
XML Element Name:ProductNumberTo
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "ART_NRA_B")
                    

Product group From
XML Element Name:ProductGroupFrom
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "ART_GRP_V")
                    

Product group to
XML Element Name:ProductGroupTo
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "ART_GRP_B")
                    

Storage location from
XML Element Name:StockLocationFrom
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAO_V")
                    

Storage place from
XML Element Name:BinLocationFrom
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAP_V")
                    

Storage location to
XML Element Name:StockLocationTo
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAO_B")
                    

Storage place to
XML Element Name:BinLocationTo
Parent Element:StocktakingHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAP_B")
                    

Inventory blocked
XML Element Name:StocktakingLockFlag
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "REC_LOCK")
                    

Provisional inventory
XML Element Name:ProvisionalStocktaking
Parent Element:StocktakingHeaderFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "CBPROVINV")
                    

Recommend main storage location
XML Element Name:MainStockLocationProposal
Parent Element:StocktakingHeaderFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "CBDEFLAGORT")
                    

Var. ID from
XML Element Name:VariantIDFrom
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "VAR_ID_VON")
                    

Var. ID to
XML Element Name:VariantIDTo
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "VAR_ID_BIS")
                    

Division no.
XML Element Name:Division
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "GSB_NR")
                    

Stocktaking state
XML Element Name:StocktakingStatus
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "INV_STATUS")
                    

Stocktaking type
XML Element Name:StocktakingType
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "INV_TYP")
                    

provisional/definitive
XML Element Name:ProvisionalDefinitiveFlag
Parent Element:StocktakingHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "INV_PRO_DEV")
                    

Inventory items
XML Element Name:Item
Parent Element:StocktakingHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Fields
XML Element Name:ItemFields
Parent Element:Item
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Inventory no.
XML Element Name:StocktakingNumber
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Reference to inventory header file.
(The internal field ID for this element is "INV_NR")

Inventory date
XML Element Name:StocktakingDate
Parent Element:ItemFields
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Inventory date
(The internal field ID for this element is "INV_DATUM")

Item no.
XML Element Name:ItemNumber
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Item no. within inventory
(The internal field ID for this element is "INV_POS")

Entered inventory quantities
XML Element Name:StocktakingQuantityBookedFlag
Parent Element:ItemFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
States whether an entry on a quantity basis has already been effected.
Possible values:
0 = Inventory is not entered yet on a quantity basis
1 = Inventory is entered on a quantity basis
(The internal field ID for this element is "CB_MENGENBUCH")

Entered inventory values
XML Element Name:StocktakingValueBooked
Parent Element:ItemFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
States whether an entry on a value basis has already been effected.
Possible values:
0 = Inventory is not entered yet on a value basis
1 = Inventory is entered on a value basis
(The internal field ID for this element is "CB_WERTBUCH")

Storage location
XML Element Name:StockLocation
Parent Element:ItemFields
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGER_ORT")
                    

Storage place
XML Element Name:BinLocation
Parent Element:ItemFields
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGER_PLATZ")
                    

Product No.
XML Element Name:ProductNumber
Parent Element:ItemFields
Field Type:Text
Action Type:Import und Export
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "ART_NRA")
                    

Warehouse stock
XML Element Name:WarehouseStock
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGERBEST")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Inventory quantity
XML Element Name:StocktakingQuantity
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "INV_MENGE")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Inventory difference
XML Element Name:StocktakingDifference
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Difference between warehouse stock and inventory quantity
(The internal field ID for this element is "INV_ABWEICHUNG")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Valuation record
XML Element Name:ValuationRateFlag
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Percentage that can be considered for the valuation of an inventory. Default will be taken over from inventory header.
(The internal field ID for this element is "INV_BEWERTUNG")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Average cost price
XML Element Name:AverageCostPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Average cost price
(The internal field ID for this element is "DURCH_EP")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Last cost price
XML Element Name:LastCostPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LETZTER_EP")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Lowest cost price
XML Element Name:LowestCostPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "TIEFST_EP")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Valuation price
XML Element Name:ValuationPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BEWERT_EP")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

ACT Expense
XML Element Name:AccountExpense
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "KTO_AUFWAND")
                    

ACT inventory
XML Element Name:AccountStocktaking
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "KTO_INVENTAR")
                    

CC1 Expense
XML Element Name:CostCentre1Expense
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "KST_AUFWAND")
                    

CC2 Expense
XML Element Name:CostCentre2Expense
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "KST2_AUFWAND")
                    

Average cost price (old)
XML Element Name:AverageCostPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Average cost price (status before inventory)
(The internal field ID for this element is "DURCH_EP_ALT")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Last cost price (old)
XML Element Name:LastCostPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Last cost price (status before inventory)
(The internal field ID for this element is "LETZTER_EP_ALT")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Lowest cost price (old)
XML Element Name:LowestCostPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Lowest cost price (status before inventory)
(The internal field ID for this element is "TIEFST_EP_ALT")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Valuation price (old)
XML Element Name:ValuationPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Valuation price (status before inventory)
(The internal field ID for this element is "BEWERT_EP_ALT")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

G/L interface flag
XML Element Name:GeneralLedgerInterfaceDone
Parent Element:ItemFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Flag G/L interface created
Possible values:
0 = G/L interface was not created
1 = G/L interface created
(The internal field ID for this element is "CBFIBUGEN")

G/L Coll.-No.
XML Element Name:GeneralLedgerCollectiveNumber
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Collective no. G/L interface
(The internal field ID for this element is "FIBUSAMNR")

Last G/L price (old)
XML Element Name:LastGeneralLedgerPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAST_FIBU_PREIS_ALT")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Procurement costs average PP
XML Element Name:ProcurementAverageCostPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "DURCH_EP_BEZKO")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Procurement costs last PP
XML Element Name:ProcurementLastCostPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LETZTER_EP_BEZKO")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Procurement costs lowest PP
XML Element Name:ProcurementLowestCostPrice
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "TIEFST_EP_BEZKO")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Procurement costs average PP (old)
XML Element Name:ProcurementAverageCostPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "DURCH_EP_ALT_BEZKO")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Procurement costs last PP (old)
XML Element Name:ProcurementLastCostPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LETZTER_EP_ALT_BEZKO")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Procurement costs lowest PP (old)
XML Element Name:ProcurementLowestCostPriceOld
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "TIEFST_EP_ALT_BEZKO")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Variant no.
XML Element Name:VariantNumber
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "VAR_ID")
                    

Division no.
XML Element Name:Division
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "GSB_NR")
                    

Acct set no. expenses
XML Element Name:AccountSetNumberExpense
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "KONTOSETNR_AUFWAND")
                    

Enter item
XML Element Name:ItemBooking
Parent Element:ItemFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "POSITIONEN_VERBUCHT")
                    

Stock value actual
XML Element Name:StockValueCurrent
Parent Element:ItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   6Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGERWERT")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Stock value new
XML Element Name:StockValueNew
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   6Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGERWERT_NEU")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Stock value difference
XML Element Name:StockValueDifference
Parent Element:ItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   6Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGERWERT_DIFFERENZ")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Product-Type
XML Element Name:ProductType
Parent Element:ItemFields
Field Type:Text
Action Type:Export only
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "PROD_TYP")
                    

Chargen-Buchungsdaten
XML Element Name:BatchData
Parent Element:Item
Field Type:ID
Action Type:Import only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Fields
XML Element Name:BatchDataFields
Parent Element:BatchData
Field Type:Type[ 15 ]
Action Type:Import only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Chargennummer
XML Element Name:BatchNumber
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "CHARGEN_NR")
                    

Chargen/SNR-Folge-Nr.
XML Element Name:BatchSequenceNumber
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "CHARGEN_FNR")
                    

Quantity
XML Element Name:Quantity
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "MENGE")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Menge reserviert
XML Element Name:QuantityReserved
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "MENGE_RESERV")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Quantity ordered
XML Element Name:OrderedQuantity
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "MENGE_BESTELLT")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Warehouse stock
XML Element Name:StockQuantity
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "LAGERBESTAND")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Eingangsdatum
XML Element Name:DateOfReceipt
Parent Element:BatchDataFields
Field Type:Datum (2000-03-20)
Action Type:Import only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "EINGDAT")
                    

Verfalldatum 1
XML Element Name:ExpirationDate1
Parent Element:BatchDataFields
Field Type:Datum (2000-03-20)
Action Type:Import only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "VERFALLDAT")
                    

Verfalldatum 2
XML Element Name:ExpirationDate2
Parent Element:BatchDataFields
Field Type:Datum (2000-03-20)
Action Type:Import only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "VERFALLDAT2")
                    

Zeugnis
XML Element Name:Certificate
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "ZEUGNIS")
                    

Herkunftsland
XML Element Name:CountryOfOrigin
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "HERKUNFT_LAND")
                    

Herkunft-Cd
XML Element Name:OriginCode
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "HERKUNFT_CD")
                    

Herkunft-Cd
XML Element Name:QualityCode
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "QUALITAET_CD")
                    

Remark 1
XML Element Name:Remark1
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   40Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BEMERKUNG")
                    

Remark 2
XML Element Name:Remark2
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   40Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BEMERKUNG2")
                    

Remark 3
XML Element Name:Remark3
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   40Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BEMERKUNG3")
                    

Remark 4
XML Element Name:Remark4
Parent Element:BatchDataFields
Field Type:Text
Action Type:Import only
Field Length:   40Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BEMERKUNG4")
                    

Ind. Benutzerfeld numerisch 1
XML Element Name:IndividualNumeric1
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BENNUM1")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Ind. Benutzerfeld numerisch 2
XML Element Name:IndividualNumeric2
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BENNUM2")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Ind. Benutzerfeld numerisch 3
XML Element Name:IndividualNumeric3
Parent Element:BatchDataFields
Field Type:Nummer
Action Type:Import only
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                                  (The internal field ID for this element is "BENNUM3")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.