Report Layouts-und-Variablen

2 Plant Protection Certificate Report (Phyto Certificate)

**Ported by Claude** · translated to English from WikiPat on 02.10.2026

2.1 Plant protection certificate / phyto certificate

Reports PFLSCHUTZ.QRP, PFLSCHUTZ2.QRP.

2.1.1 Input items

<thead></thead><tbody></tbody>

Name	Type	Content
`siKNDGRP`	String	Customer group
`FIRMNR`	String	Company
`sGATGRP`	String	Group
`FORM`	String	Variety
`ARTNR`	String	Article no.
`ARTKBZ`	String	Article short name
`SORTE`	String	Variety
`nMENGE`	Number	Quantity
`PRDHLFNR`	String	Production device
`BEZ`	String	Company name
`VERPACKMENGE`	String	All production devices of a tour or customer
`GESVERPACKMENGE`	String	All production devices
`KNDVERPACKMENGE`	String	All production devices of a customer
`TEXT`	String	`B_ZRECHNUNGCOL.TEXT`
`GATGRPBEZ`	String	Group, longer name
`MCODE`	String	`B_ARTIKEL.MCODE`
`nVE`	Number	Sum of the tray quantity of a customer or tour
`nKNDVE`	Number	Sum of the tray quantity of a customer
`nGESVE`	Number	Sum of the tray quantity
`sVARIANTENBEZ`	String	Name of the variety
`sRECHNR`	String	Customs invoice number
`nLFTAG`	Number	Delivery day
`nPFLANZAHL`	Number	`B_ARTEIGEN.PFLANZ`
`sARTIKELBOTANISCH`	String	`B_ARTIKEL.ALTERNAME`
`sGATGRPBOTAN`	String	`B_GATGRP.ANDBEZ`
`nPFLANZENMENGE`	Number	Quantity \* `B_ARTEIGEN.PFLANZ`
`nTRAYMENGE`	Number	Tray quantity
`sPFLPASSNR`	String	Plant passport number
`sABTEILUNG`	String	Department
`sSTUECK`	String	Contains + if BOM
`sWARENGRP`	String	`B_ARTFORM.WARENGRP`
`nGEWICHTPRDHLF`	Number	`B_ZRECHNUNGCOL.SUMGEWPRDHLF`
`nGEWICHTARTIKEL`	Number	`B_ZRECHNUNGCOL.GEWICHT`
`nVOLUMEN`	Number	`B_ZRECHNUNGCOL.SUMVOLUMEN`
`sINTRASTAT`	String	`B_ARTFORM.INTRASTAT`
`nSTDVKPREIS`	Number	`B_ZRECHNUNGCOL.STDVKPREIS`
`nFIRVKPREIS`	Number	`B_ZRECHNUNGCOL.FIRVKPREIS`
`nPMENGE`	Number	`B_ZRECHNUNGCOL.PMENGE`
`sSTDWAEHR`	String	`B_ZRECHNUNGCOL.STDWAEHR`
`sFIRWAEHR`	String	`B_ZRECHNUNGCOL.FIRWAEHR`
`nGATGRPMENGE`	Number	Sum of the quantity per genus group
`siAUFTRNR`	String	Order number

2.1.2 Variables

These variables are new since Nov. 2012; the list is not complete (updated 15.05.2019).

If a customs invoice is summarised per GATGRP, the tour information is lost.

<thead></thead><tbody></tbody>

Name	Type	Content
`svTRANSMBEZ`	String	Name of the means of transport of the tour (also: transport aid name)
`svTOURINFO`	String	Tour information from `B_TOURID`
`svTOURID`	String	`TOURID` from `B_ZRECHNUNGCOL`
`nvEXTERNAL_NUMBER`	Number	Number from `B_EXTERNAL_NUMBERS`
`nvANZ_BOXEN`	Number	Number of boxes
`nvGESAMT`	Number	Total quantity
`svAWBNO`	String	Airway bill number
`svTEXT`	String	Text from `B_HAFTUNGSAUSSCHLUSS_MATRIX`
`svFLIEFKBZ`	String	Supplier abbreviation of the company (`B_FIRMA.LIEFNR`)
`svFSTRASSE`, `svFORT`, `svFPLZ`, `svFLAND`	String	Street, city, postal code and country of the company (`B_FIRMA.LIEFNR`)
`svKNDNR`, `svKNDKBZ`	String	Delivery customer number and short name
`svANREDE`, `svNAME1`, `svNAME2`, `svNAME3`	String	Delivery customer salutation and names 1 to 3
`svSTRASSE`, `svLAND`, `svLANDNAME`, `svPLZ`, `svORT`	String	Delivery customer street, country (short and full name), postal code, city
`svZH`, `svPOSTFACH`, `svORTSTEIL`, `svPLZ_PFACH`	String	Delivery customer attention of, P.O. box, district, P.O. box postal code
`svTELEFON`, `svHANDY`, `svFAX`, `svEMAIL`	String	Delivery customer phone, mobile, fax, e-mail
`svBUNDESSTAAT`, `svUIDNR`	String	Delivery customer state, VAT ID
`svR_...` (same set)	String	The same fields for the **invoice customer**: `svR_KNDNR`, `svR_KNDKBZ`, `svR_ANREDE`, `svR_NAME1` to `svR_NAME3`, `svR_STRASSE`, `svR_LAND`, `svR_PLZ`, `svR_ORT`, `svR_ZH`, `svR_POSTFACH`, `svR_ORTSTEIL`, `svR_TELEFON`, `svR_HANDY`, `svR_FAX`, `svR_EMAIL`, `svR_PLZ_PFACH`, `svR_BUNDESSTAAT`, `svR_UIDNR`
`sDEPOTNR`, `sDKNDKBZ`, ...	String	The same fields for the **depot customer**: `sDEPOTNR`, `sDKNDKBZ`, `sDANREDE`, `sDNAME1`, `sDNAME2`, `sDSTRASSE`, `sDLAND`, `sDPLZ`, `sDORT`, `sDZH`, `sDPOSTFACH`, `sDORTSTEIL`, `sDTELEFON`, `sDHANY`, `sDFAX`, `sDEMAIL`
`nvLFJAHR`	Number	`LFJAHR` of the first line (without sorting)
`nvLFKW`	Number	`LFKW` of the first line (without sorting)
`svGEWEH`	String	Weight unit name from `B_ZRECHNUNGCOL.SUMGEWEH`
`svGRUNDEINHEIT`	String	Unit name from `B_ZRECHNUNGCOL.LFMEEH`
`svMASTER_AWBNO`	String	Master airway bill number

2.1.3 Batch information

Information about the related batches can be printed. The number of the batch 1..X is appended to the variable name.

<thead></thead><tbody></tbody>

Name	Type	Content
`svRES_CHARGENNR`	String	Batch number
`svRES_STANDORT`	String	Location
`svRES_TEXT`	String	Text
`nvRES_MENGE`	Number	Quantity
`nvRES_TRAYANZ`	Number	Number of trays
`svRES_QUALITAET`	String	Quality identifier
`svRES_IDENTNR`	String	Ident number
`nRES_PRKW`	Number	`PRKW`
`dRES_PRDATUM`	Date	Production date
`svRES_URLAND`	String	Country of origin
`nvRES_PROZSAATAUFSCHLAG`	Number	Seed surcharge
`nvRES_KEIMLIEF`	Number	Germination rate
`svRES_REGISTRATION_NUMBER`	String	Registration number (`B_PROD_REGISTRATION`)
`svRES_INITIAL_REGISTRATION_NUMBER`	String	Initial registration number (`B_PROD_REGISTRATION`)

3 Customs Report with Box Number (ZOLL_BOXNR.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

3.1 Customs Report with Box Number (ZOLL_BOXNR.QRP)

Under Tour administration / button Print or Further lists / Customs box no. a listing of the selected tour by botanical genus description and box number can be shown.

The report is ZOLL_BOXNR.QRP; it can also be set under Settings / Workstation / Forms as Customs form box no.

3.1.1 Input items

• siANDBEZ (B_GATGRP.ANDBEZ): botanical description
• niLFKW (B_AUFTRCOL.LFKW): first delivery week found for this tour ID
• niLFJAHR (B_AUFTRCOL.LFJAHR): first delivery year found for this tour ID
• niANZAHLBOXEN: total number of boxes
• siBOXEN (B_VERSANDCOL.TOURBOXNR): summary of the box numbers for the tour, for example 1-3,5,7,8,12
• niSUMME (SUM(B_VERSANDCOL.MENGE)): sum per article group
• niSUMMEBOXEN (SUM(B_VERSANDCOL.MENGE)): summed total quantity of the tour
• siBOXEN: inner boxes
• siAUSSENBOXEN: outer boxes
• siFORM: product form

3.1.2 Input variables

• svTOURINFO (B_TRANSMITTEL.BEZ): description of the means of transport

There are no break groups on this report. The box numbers are also printed on the carton labels (see the page on packing / writing the box numbers in the packaging system).

3.1.3 Internal: queries

Main select:

<syntaxhighlight lang="sql">SELECT b.andbez, b.gatgrp, sum(a.menge) FROM B_VERSANDCOL a, B_GATGRP b

WHERE a.TOURID = :sTourID AND a.menge IS NOT NULL AND a.gatgrp = b.gatgrp
GROUP BY b.ANDBEZ, b.GATGRP ORDER BY b.ANDBEZ;

</syntaxhighlight> Select for the box numbers:

<syntaxhighlight lang="sql">SELECT substr(tourboxnr,0,instr(tourboxnr,'/')-1) AS nummer FROM b_versandcol INTO :sBoxNr

WHERE gatgrp = :sGATGRPBEZ AND tourid = :sTourID AND tourboxnr IS NOT NULL AND superkart != 'leer'
ORDER BY nummer;

</syntaxhighlight> Select for the total number of boxes:

<syntaxhighlight lang="sql">SELECT count(*) AS anzahl FROM b_versandcol INTO :nAnzahlBoxen

WHERE tourid = :spTourID AND tourboxnr IS NOT NULL AND superkart != 'leer';

</syntaxhighlight> Select for LFKW:

<syntaxhighlight lang="sql">SELECT LFKW FROM b_auftrcol INTO :nLFKW WHERE tourid = :spTourID </syntaxhighlight>

4 Report Notes: Plant Overview and Production Order List

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

4.1 Report Notes: Plant Overview and Production Order List

• Plant overview (Pflanzübersicht): a special report that needs the procedure CALCULATE_ORDER_MATRIX to work.
• Production order: production list: the variable svHEADARTNRHINWEIS contains the note of the article to be produced (table B_ARTFORM, column Note).

5 Report Variables: Control Slip (A_PRUEFUNG.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

5.1 Report Variables: Control Slip (A_PRUEFUNG.QRP)

Company setting Settings orders -> Control print: do not insert e-mail address automatically: if FALSE, the customer e-mail address is not entered as recipient when sending by e-mail.

5.1.1 Input items

sKARTNR, sKARTKBZ, sMCODE

<thead></thead><tbody></tbody>

Name	Type	Content
`siGEBART`	String	Packaging type from `B_AUFTRCOL`: C = container, P = pallets
`niANZGEB`	Number	Number of packaging units recalculated to the order position (`B_AUFTRCOL`)
`siARTEINGANG`	String	Type of order entry from `B_AUFTRAG`
`niVPANZ`	Number	Number of packages
`siFL_HANDVPANZ`	String	Flag manual number of packages
`niVPELAGE`	Number	from `B_AUFTRCOL`
`niLAGEWAG`	Number	from `B_AUFTRCOL`
`nFIRZUSCHL`	Number	from `B_AUFTRCOL`
`sPRDHLFNR`	String	Production aid

5.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svEROEFFNUNG`	String	Either + or empty, to control an information per position
`nvBETRAG_ETIKETTE`	Number	Label amount in the line
`nvPOSSUM_ETIKETTE`	Number	Label grand total
`nvETPREIS`	Number	Label price
`nvETPMENGE`	Number	Label price quantity
`nvETMENGE`	Number	Label quantity
`nvETMWST`	Number	Label VAT
`sMATERIALNR`	String	Material number from `B_ARTFORM`
`sFL_BIO`	String	Flag organic from `B_ARTFORM`
`svARTICLE_COLOUR`	String	Article color from `B_ARTIKEL` or translation from `B_KONVERT`
`svPRODUCT_TYPE`	String	Product type from `B_ARTIKEL` or translation from `B_KONVERT`
`svKNDSTEUERCODE`	String	Customer master: company tax number
`svKNDHANDY`	String	Customer master: mobile phone

Further variables: svLNAME3 (name 3 from the customer master), sAC_STATUS (status of the order: RE/ST/PR), KNDUIDNR (customer VAT ID from the customer master).

5.1.3 Corrected turnover, gross profit and turnover

• KORRUMSATZ (corrected turnover): comes from B_AUFTRCOL.VIRTFRGEBKOST if B_VERSART.VIRTFRGEBKOST = J, otherwise it is calculated through the price.
• BRUTTOGEWINN (gross profit): results from corrected turnover minus goods value.
• UMSATZ (turnover): a somewhat more complicated formula that results from the prices and other values.

For all three variables the default setting EK price determination for control slip must be TRUE.

Formula:

nWarenwert = ( Menge / PMenge ) * EKPreis
nUmsatz    = ( Menge / PMenge ) * STDVKPREIS   (rounded)

If default setting switch PRTRENRAB:
    nA = nWarenwert * ( ( RABATT + RABATT2 ) / 100 )
Else:
    nA2 = nWarenwert * ( RABATT2 / 100 )
    If nA2 = 0:  nA = nWarenwert * ( RABATT / 100 )
    Else:        nA = ( nWarenwert - nA2 ) * ( RABATT / 100 )
nA = nA + nA2
nUmsatz = nUmsatz - nA   (rounded)

If B_VERSART.FL_PREISMFRACHT = J:
    nKorrUmsatz = nUmsatz - B_AUFTRCOL.VIRTFRGEBKOST
Else:
    nKorrUmsatz = nUmsatz

nBruttoGewinn = nKorrUmsatz - nWarenwert

6 Report Variables: Order Confirmation

**Ported by Claude** · translated to English from WikiPat on 02.10.2026

6.1 Order confirmation (AB_NEU.QRP)

6.1.1 Input items

Items without a description or type are listed with their name only; the wiki gives no explanation for them.

<thead></thead><tbody></tbody>

Name	Type	Content	Table
`ARTKBZ`	String	Article short name	`B_AUFTRCOL`
`ARTNR`	String	Article number	`B_AUFTRCOL`
`AUFTRDAT`
`AUFTRNR`
`FIRVKPREIS`	Number	Sales price per ?? (group currency)
`FIRWAEHR`		Group currency
`FIRZUSCHL`	Number	State surcharge per line (group currency)
`FORM`
`FRACHTPREIS`	Number	Freight price per order line
`FRACHTZ`		Freight zone
`GATGRP`
`GATGRPBEZ`		(can also be translated through `Artland`)
`KARTKBZ`, `KARTNR`, `KBESTNR`, `KNDNR`, `LANDBEZ`, `LFDATUM`, `LFJAHR`
`LFKW`		Delivery week of the order line
`LIZPREIS`		Licence price per line
`LIZPROSTK`		Reference quantity for the licence price (per .. pieces)
`LLAND`		Delivery country
`LNAME1`, `LNAME2`, `LORT`
`LPLZ`		Delivery postal code
`LPO`		Delivery P.O. box
`MCODE`
`niGEW_PRDHLF`		Weight of the production device
`niGEWICHT`		Weight
`niMENGENFAKTOR`, `niRABATT2`, `niVOLUMEN`
`nMENGE`		Quantity (per line)
`nMWST`
`nRABATT`		Discount (per line)
`nVPEH`		Packing unit
`nZUSCHLAG`
`ORTSTEIL`		District (customer)
`PEH`		Production unit (per line)
`PMENGE`		Price quantity (reference quantity for the sales price)
`PRDHLFNR`		Production device (short name)
`PRODHMITTELBEZ`		(can also be translated through *Translations*)
`RKNDNR`, `sFIRMNR`, `siABTEILUNG`, `siARTPREISGRP`, `siEINHEIT`
`siEINHEIT_KEY`		Key (short name) of the unit
`siFL_ERSATZ`		Flag substitute article
`siFL_GRATIS`
`siFL_LEIHART`		Flag loan article
`siFL_NEUART`		Flag new article
`siFL_PRAESKART`		Flag presentation carton
`siGEWICHT_EH`		Weight unit
`siGEWICHT_EH_KEY`		Key (short name) of the weight unit
`sINFOTEXT`, `sKNDFAX`, `sKNDKBZ`, `sKOMMISSION`, `sKOMMISSION1`, `sKOPFTEXT`
`sLAND`		Country abbreviation (customer)
`sLANDPOSTORT`		Postal code and city (customer)
`sLANREDE`
`sLFINFO`		Entry order / delivery note information footer (in order administration / texts)
`sLZH`, `sNAME1`, `sNAME2`, `sORT`
`SORTE`		Variety name (company)
`sPLZ`, `sPOSTFACH`
`sPRDHLFNRBEZ`		Long name of the production device (does not work in the report! Use `PRODHMITTELBEZ` instead)
`sSTRASSE`
`STAFFMENGE`		Agreed scale quantity
`STDVKPREIS`		Sales price per price quantity (order currency)
`STDVKSUM`		Sales price per line (order currency)
`STDWAEHR`		Order currency per line
`sTEL_LANDCODE`, `sTEL_VORWAHL`, `sTELEFON`, `sTELNR`
`sZH`		Attention of (customer)
`TEXT`		Text per article from the article entry
`TOURBEZ`
`TOURNR`		Tour number
`VERSART`		Shipping method
`VERTBEZ`		Sales representative name
`VERTFAX`, `VERTNAME1`, `VERTNAME2`, `VERTRNR`
`VERTTEL`		Sales representative phone number
`ZAHLART`		Payment method (short name)
`ZAHLARTBEZ`		Payment method name
`siARTIKELFAMILIE`		Short name of the article family from the article master
`siVERSARTBEZ`		Shipping method name
`siKNDLANDBEZ`		Country of the customer
`sNAME3`, `LNAME3`
`siLPOSTFACH`		P.O. box of the customer or delivery address
`siAUFTRTIMEST`, `siWARENGRP`
`siFL_PRIVAT1`	String	`FL_PRIVAT1` from `B_AUFTRCOL`	`B_AUFTRCOL`
`siFL_PRIVAT2`	String	`FL_PRIVAT2` from `B_AUFTRCOL`	`B_AUFTRCOL`
`siORDERNR`	String	`ORDERNR` from `B_AUFTRCOL`	`B_AUFTRCOL`
`siKKBESTNR`	String	`KKBESTNR` from `B_AUFTRAG`	`B_AUFTRAG`
`LNAME3`	String	`LNAME3` from `B_AUFTRCOL`	`B_AUFTRCOL`
`siVARIANTENBEZ`	String	`KBZ` from `B_FORM`
`niARTHOEHE`	Number	Height from `B_ARTEIGEN`	`B_ARTEIGEN`
`siFLOWID_KUNDE`	String	Flow ID customer from `B_AUFTRAG`	`B_AUFTRAG`
`siFLOWID_HAENDLER`	String	Flow ID dealer from `B_AUFTRAG`	`B_AUFTRAG`
`siFLOWID_PRODUZENT`	String	Flow ID producer from `B_AUFTRAG`	`B_AUFTRAG`
`siFL_FAIRTRADE`	String	Flag Fairtrade from `B_AUFTRCOL`	`B_AUFTRCOL`
`siROYALTY_PERIODE`	String	Royalty period, for example 2015, M1 or 2015, W3 or 2015, Q1 + Q2, from `B_AUFTRAG`	`B_AUFTRAG`
`siKNDGRP`	String	Delivery customer group	`B_AUFTRAG`
`siGEBART`	String	Container type	`B_AUFTRCOL`
`niANZGEBINDE`	Number	Number of containers	calculated
`niANZVERPACK`	Number	Number of packagings	calculated
`siKNDLOC`	String	Customer location	`B_AUFTRCOL.KNDLOC`
`siWARENGRP_BEZEICHNUNG`	String	Name of the product group	`B_WARENGRP`
`siWEBORDER_ID`	String	Web order ID	`B_AUFTRAG.WEBORDER_ID`
`siTEXT2`	String	Text 2 -> delivery text	`B_AUFTRCOL.TEXT2`
`niGNDMENGE`	Number	Initial quantity	`B_AUFTRCOL.GNDMENGE`
`siARCHIV`	String	Flag that shows whether it is an archive print (then = J, otherwise empty)
`niLFTAG`	Number	Delivery day	`B_AUFTRCOL.LFTAG`
`niVPANZ`	Number	Packaging count	`B_AUFTRCOL.VPANZ`
`siFL_HANDVPANZ`	String	Flag manual packaging count	`B_AUFTRCOL.FL_HANDVPANZ`
`siPRODUCT_TYPE`	String	Product type	`B_ARTIKEL.PRODUCT_TYPE` or the related translation from `B_KONVERT`
`siSORTNR`	String	Assortment	`B_ARTIKEL.SORTNR`
`siARTICLE_COLOR`	String	Article colour	`B_ARTIKEL.COLOR`
`siFL_GPREIS`	String	Flag manual price	`B_AUFTRCOL.FL_GPREIS`
`siFL_GPREIS_HEADER`	String	Flag manual price header: H if at least one line has H	`B_AUFTRCOL.FL_GPREIS`
`niMENGE_GEH_ARTFORM`	Number	Quantity in weight units	`B_ARTFORM.MENGE_GEH`
`siGEWICHT_EH_ARTFORM`	String	Weight unit	`B_ARTFORM.GEWICHT_EH`
`siFL_BIO`	String	Flag organic from the article master (there is also the variable `sFL_BIO`)	`B_ARTFORM.FL_BIO`
`siSPRACHE`	String	Customer language	`B_KNDSTAMM.SPRACHE` or from `B_LAND.SPRACHE`
`siGATGRPBEZ_TRANS`	String	Genus group name translation (from the translations table)
`siGATGRPBOT_TRANS`	String	Genus group botanical name translation (from the translations table)
`siFL_PRIVAT2_TEXT`	String	`B_AUFTRCOL.FL_Privat2` text from the text block

6.1.3 Variables

<thead></thead><tbody></tbody>

Name	Type	Content	Table
`A_DATUM`	String	Name for order date (Maintenance / report texts)
`A_FUSS1` to `A_FUSS4`	String	Order footer text 1 to 4 (Maintenance / report texts)
`A_INFO`	String	Order information
`A_TITEL`	String	Name for order confirmation (Maintenance / report texts)
`Anrede1` to `Anrede4`	String	Marker for the formula to print address header salutation 1 to 4
`AUFTRAGNR`	String	Name for order number (Maintenance / report texts)
`dvDRUCKDATUM`	Date	Print date
`dvPRDATUM`	Date	Production date
`dvVALUTADATUM`	Date	Value date
`KNDUIDNR`	String	VAT ID of the customer
`KNDVDATUM`	String	Name customer proposal date	`B_REPORTTEXTE2`
`KNDVFUSS1` to `KNDVFUSS4`	String	Footer text 1 to 4 for the customer proposal	`B_REPORTTEXTE2`
`KNDVINFO`	String	Name customer proposal info	`B_REPORTTEXTE2`
`KNDVKOPF1`, `KNDVKOPF2`	String	Header text 1 and 2 for the customer proposal	`B_REPORTTEXTE2`
`KNDVNR`	String	Name customer proposal no.	`B_REPORTTEXTE2`
`KNDVTITEL`	String	Name of the customer proposal	`B_REPORTTEXTE2`
`Lname1_1` to `Lname1_3`, `Lname2_1`, `Lname2_2`	String	Formula for printing the address header
`nBETRAG_FRACHT`	Number	Amount of the freight costs per line
`nBETRAG_LIZENZ`	Number	Amount of the licence costs per line
`nBETRAG_VERPACK`	Number	Amount of the packaging costs per line
`nvEKPREIS`	Number	Purchase price	`B_AUFTRCOL`
`nFRACHTMWST`	Number	VAT rate of the freight costs
`nFRACHTPAUSCHALE`	Number	Transport flat rate (order header)
`nLIZMWST`	Number	VAT rate of the licence fees
`nMINMEZSWERT`	Number	Value of the special surcharge
`nPOSSUM_VERPACK`	Number
`nSUM_FRACHT`	Number	Sum of the freight costs from the lines
`nSUM_LIZENZ`	Number	Sum of the licence costs from the lines
`nSUM_VERPACK`	Number	Sum of the packaging costs from the lines
`nvAF_MINDERWERT`	Number	Low-value surcharge in the order
`nvAF_MINDERWERT_LIMIT`	Number	Limit for the low-value surcharge in the order
`nvANZLEITKARTEN`	Number	Number of run cards
`nvBETRAG`	Number
`nvBETRAG_ETIKETTE`	Number	Sum of the label costs per line
`nvBETRAG_MINDERMENGE`	Number	Sum of the special surcharge per line
`nvEKPMENGE`	Number	Price quantity of the purchase price
`nVERPACKMWST`	Number	VAT rate of the packaging (per line)
`nVERPACKPREIS`	Number	Price of the packaging (per line)
`nvETMENGE`	Number	Label quantity
`nvETMWST`	Number	VAT of the labels
`nvETPMENGE`	Number	Price quantity of the labels
`nvETPREIS`	Number	Price of the labels per line
`nvKVKPREIS`	Number	The sales price of the customer (to its own customers), from the order item; if 0, it is searched in the customer article properties
`nvPOSSUM_ETIKETTE`	Number	Sum of the label prices from the lines
`nvPRKW`	Number	Production week
`nvVALUTATAGE`	Number	Value days
`nZUSCHLAGPREISMENGE`	Number	Price quantity of the special surcharge
`dvPartnerLieferDatum`	Date	Delivery date of the partner
`nvPartnerLieferTag`	Number	Delivery day of the partner
`nvPartnerLieferWoche`	Number	Delivery week of the partner
`sAUFTRAGBEAAEN`	String	User who changed the order
`sAUFTRAGBEAANG`	String	User who created the order
`sDANREDE`, `sDBUNDESSTAAT`, `sDEPOTNR`, `sDKNDKBZ`, `sDLAND`, `sDNAME1`, `sDNAME2`, `sDORT`, `sDORTSTEIL`, `sDPLZ`, `sDPOSTFACH`, `sDSTRASSE`, `sDZH`	String	Depot salutation, state, number, customer short name, country, name 1, name 2, city, district, postal code, P.O. box, street, attention of
`sKNDHANDY`		Mobile number of the customer
`sLBUNDESSTAAT`, `sLORTSTEIL`	String	State and district of the delivery customer
`sRANREDE`, `sRBUNDESSTAAT`, `sRBUNDESSTAATBEZ`, `sRKNDKBZ`, `sRLAND`, `sRLANDBEZ`, `sRNAME1` to `sRNAME3`, `sRORT`, `sRORTSTEIL`, `sRPLZ`, `sRPOSTFACH`, `sRSTRASSE`, `sRZH`	String	Invoice customer: salutation, state (also written out), short name, country abbreviation, country name, names 1 to 3, city, district of the invoice recipient, postal code, P.O. box, street, attention of
`sSACH_EMAIL`, `sSACH_HANDY`, `sSACH_KBEZ`, `sSACH_NAME1`, `sSACH_NAME2`, `sSACH_TELEFON`	String	Clerk: e-mail address, mobile number, short name, name 1, name 2, phone number
`svABTEILUNG`	String	Department
`sVARIANTEBEZ`	String	Article variety name (can also be translated through *Translations*)
`svARTIKELBOTAN`	String	Botanical name of the article
`svAVISIEREN`	String	Flag notify
`svBARCODE`	String	Barcode
`sVERPACK`	String	Packaging short name	`B_AUFTRCOL`
`sVERPACKBEZ`	String	Packaging name
`svFAXNUMMER`	String
`svFL_AB`	String	Flag order confirmation
`svFL_AB_GEDRUCKT`	String	Flag order confirmation printed
`svFL_AVISIERT`	String	Flag notified
`svFL_FIXIERNE`, `svFL_MINDERWERTOK`	String
`svGATGRPBOTAN`	String	Botanical name of the genus group (can also be translated through `Artland`)
`svHALTBGRP`	String	Shelf life group
`svKND_BARCODE`	String	Barcode of the customer
`svLNAME3`	String	Name 3 of the delivery customer
`svNAME3`	String	Name 3 of the customer
`svPOSTFAX`	String	Character string AFTER the fax number for faxing from PAT (depends on the fax driver)
`svPREFAX`	String	Character string BEFORE the fax number for faxing from PAT (depends on the fax driver)
`svSTANDORT`	String	Location short name
`svSTANDORTNAME`	String	Location name
`svVERTHANDY`	String	Mobile number of the sales representative
`ZeigePostfach`, `ZeigeStrasse`	String	Formula for address printing
`svMATERIALNR`	String	Material number	`B_ARTFORM`
`svFRACHTZONENBEZ`	String	Freight zone name	`B_FRACHTZ`
`svARTIKELFAMILIEBEZ`	String	Plant family name	`B_PFLFAM`
`dvAUFTRCOLDATUM`	String	Timestamp of the order line as a date	`B_AUFTRCOL`
`svKUNDENTEXT`	String	`B_KNDSTAMM.KTEXT`	`B_KNDSTAMM`
`svAUFTRAGANGNAME`	String	Name of the user who created it	`CDS_BENUTZER`
`sKndBUNDESSTAAT`	String	State of the customer (long)
`svAUFTRAGAENNAME`	String	Name of the user who changed it	`CDS_BENUTZER`
`svLINFO`	String	Additional information about the article (max. 2000 characters)	`B_ARTIKEL`
`sFL_BIO`	String	Flag organic from `B_ARTFORM`	`B_ARTFORM`
`svBUGRUPPE`	String	Booking group from `B_AUFTRCOL`	`B_AUFTRCOL`
`svKNDMAIL`	String	E-mail addresses from the customer master	`B_KNDSTAMM`
`svLADEMAIL`	String	E-mail address from the delivery address	`B_KNDLAD`
`svLADUIDNR`	String	VAT ID from the delivery address	`B_KNDLAD`
`svARTFORM_HINWEIS`	String	`HINWEIS`, `INFO` from `B_ARTFORM`	`B_ARTFORM`
`sKndladBUNDESSTAAT`	String	State of the delivery address (long)	`B_KNDLAD`
`svLADTELEFON`	String	Phone from `Kndlad`	`B_KNDLAD`
`svARTICLE_COLOUR`	String	Article colour or its translation	`B_ARTIKEL` or translation from `B_KONVERT`
`svPRODUCT_TYPE`	String	Product type or its translation	`B_ARTIKEL` or translation from `B_KONVERT`
`svSORTIMENTBEZ`	String	Assortment name	`B_SORTIMENT.BEZ`
`svVATERAUFTRNR`	String	Parent order number	from `B_AUFTRAG.VATERAUFTRNR`
`svREMAIL`	String	E-mail of the invoice customer
`svKNDEMAIL`, `svKNDEMAILCC`, `svKNDEMAILBCC`	String	E-mail, CC e-mail and BCC e-mail of the customer
`svKND_LFMAIL`, `svKND_LFMAILCC`, `svKND_LFMAILBCC`	String	E-mail, CC and BCC for mail merge delivery note
`svKND_REMAIL`, `svKND_REMAILCC`, `svKND_REMAILBCC`	String	E-mail, CC and BCC for mail merge invoices
`svREMAILCC`	String	CC e-mail of the invoice customer

7 Report Variables: Container Slip (CC_REPORT.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

7.1 Report Variables: Container Slip (CC_REPORT.QRP)

• Report name: CC_REPORT.QRP; it can also be named differently per company number, for example CC_REPORT_01.QRP or CC_REPORT_04.QRP.
• The report can be printed from the tour administration through the TLP or from the container administration.
• The search parameters are always at least the company number and the CC_ID. If the TOURID and the Wagerl number(s) are available, they are also used for the search.

7.1.1 Input items on the report

B_WAGERL: siWAGERL_NR, siWAGERLSTATUS, siGEBART, siGEBTYP, siTOURNR, siPFLPASNR, siFP_AUFTRNR, siFP_ART, siCC_ID, siFL_MITAUFSETZER, siFL_COVER, siFL_NODELINE, siSTPL_GRP_ID, niLINE_ID, niSTELLPLATZ, siGEB_SUBTYPE, siLINE_NAME, niWAGGROUP

B_LAGE: siWAGTIMEST, niLAGE, siARTNR, siGATGRP, siFORM, siPRDHLFNR, siORDERNR, siSTANDORT, siLIEFNR, siLAND, niVPEH, niMENGE, niTRAYANZ, siLFMEEH, siAUFTRNR, siAUFTRTIMEST, siTOURID, siKARTNR, siKARTBEZ, siTEXT, niTOPFGR, niHOEHE, niLFKW, diLFDATUM, siDT_GEDRUCKT, siLAUFNR, niSORT, niVPELAGE, siKDNLAD, niTOURPOS, siCHARGENNR, siKNDNR, siLAGESTATUS, niPROCESSING_DEVICE, diDATE_PROCESSED, niPOS, siCHECKING_STATUS, niCHECKING_PROCESSING_DEVICE, diDT_CHECKING_STATECHANGE, diDT_STATECHANGE, siSTACKABLE, siKNDKBZ, niREIHE, siKOMMISSION, siVERS_TYP, siFL_ET_GEDR, siROTATE, niHEADROOM, niPRINT1, niPRINT2, siAFC_ARTKBZ, siMBSCANID

<thead></thead><tbody></tbody>

Table	Item	Remarks
`B_GATGRP`	`siGATGRPBEZ`	`B_GATGRP.TEXT`
`B_TOURID`	`siTOUR_STATUS`, `siTOUR_INFO`
`B_TOURID`	`siAWB_ID`	contains `TRUCK_NO` from `E_ORDER_POSITION` if coming from import, otherwise `AWB_ID`
`B_TRANSMITTEL`	`siTRANSM_BEZ`	`B_TRANSMITTEL.BEZ`
`B_TRANSMITTEL`	`niTRANSM_REIHE`	`B_TRANSMITTEL.REIHE`
`B_TRANSMITTEL`	`siTRANSM_ABTEIL`	`B_TRANSMITTEL.ABTEIL`
`B_ARTIKEL`	`siARTKBZ`, `siSORTE`
`B_AUFTRAG`	`siLNAME1`, `siLNAME2`, `siLNAME3`, `siLORT`, `siLSTRASSE`, `siLPLZ`, `siLLAND`, `siRKNDNR`, `siRKNDKBZ`, `siKNDGRP`, `siWAEHR`, `diAUFTRDAT`
`B_AUFTRAG`	`niAUFTR_LFKW`, `niAUFTR_LFJAHR`, `diAUFTR_LFDATUM`, `siKBESTNR`, `siKKBESTNR`	`B_AUFTRAG.LFKW`, `.LFJAHR`, `.LFDATUM`, `.KBESTNR`, `.KKBESTNR`

General items:

<thead></thead><tbody></tbody>

Item	Content
`siCONTAINER_PRO_AUFTRAG`	Containers per order, depending on which order no. is active. Format (1/9 = total number of containers)
`siCONTAINER_PRO_KOMMISSION`	Containers per consignment, depending on which consignment is active. Format as above
`siCONTAINER_PRO_KUNDE`	Containers per customer, depending on which customer is active. Format as above
`siCONTAINER_PRO_TOUR`	Containers per tour ID, depending on which tour ID is active. Format as above
`siCONTAINER_PRO_DEPOT`	Containers per depot no., depending on which depot no. is active. Format as above
`niCONTAINER_PRO_TLP`	Total number of containers (if printed from the TLP), otherwise per Wagerl (selected row) or tour ID if printed from the container administration

7.1.2 Input variables

The well-known variables of the report texts are not listed here again; see Report Variables: Common Variables.

QR codes:

<thead></thead><tbody></tbody>

Variable	Content
`ovQRC_WAGTIMEST`	`B_LAGE.WAGTIMEST`, sent to the report as a QR code
`ovQRC_CCIDWAGNR`	`B_WAGERL.CC_ID + ' - ' + B_WAGERL.WAGERL_NR`, sent to the report as a QR code
`ovQRC_TOURWAGNR`	`B_LAGE.TOURID + ' - ' + B_WAGERL.WAGERL_NR`, sent to the report as a QR code

Variables from B_AUFTRCOL and others: svKOMMISSION (B_AUFTRCOL.KOMMISSION), sVERPACK (.VERPACK), nvANZLEITKARTEN (.ANZLEITKARTEN), nvPRKW (.PRKW), dvPRDATUM (.PRDATUM), svHALTBGRP (.HALTBGRP), nvEKPREIS (.EKPREIS), nvEKPMENGE (.EKPMENGE), nvKVKPREIS (.KVKPREIS), svSTANDORT (.STANDORT), svSTATUS (.STATUS), svAFC_URLAND (.URLAND), dvAFC_STARTPRDATUM (.STARTPRDATUM), nvVIRTFRGEBKOST (.VIRTFRGEBKOST), svBUGRUPPE (.BUGRUPPE), sWARNUNG (.WARNUNG), nvAFC_MENGE (.MENGE), nvAFC_LFKW (.LFKW), nvAFC_LFJAHR (.LFJAHR), dvAFC_LFDATUM (.LFDATUM), svLADEMAIL (B_KNDLAD.EMAIL), svLADUIDNR (B_KNDLAD.UIDNR)

Depot address: sDANREDE (salutation), sDBUNDESSTAAT (federal state), sDEPOTNR (depot no.), sDKNDKBZ (customer short name), sDLAND (country), sDNAME1, sDNAME2, sDNAME3, sDORT (city), sDORTSTEIL (district), sDPLZ (postal code), sDPOSTFACH (P.O. box), sDSTRASSE (street), sDZH (attention), sDLANDBEZ (country name)

Invoice customer: svRUIDNR (VAT ID), sRBUNDESSTAAT (federal state), sRANREDE (salutation), sRBUNDESSTAATBEZ (federal state written out), sRKNDKBZ (customer short name), sRLAND (country code), sRLANDBEZ (country name), sRNAME1, sRNAME2, sRNAME3, sRORT (city), sRORTSTEIL (district), sRPLZ (postal code), sRPOSTFACH (P.O. box), sRSTRASSE (street), sRZH (attention), svRSTEUERCODE (tax code), svRHANDY (mobile phone), svRFAX (fax), svRTELEFON (phone)

7.1.3 Structure of the select statement

Select:

<syntaxhighlight lang="sql">SELECT A.WAGERL_NR, A.STATUS, A.GEBART, a.gebtyp, A.TOURNR, A.PFLPASNR, A.FP_AUFTRNR, A.FP_ART, A.CC_ID,

      A.FL_MITAUFSETZER, A.FL_COVER, A.FL_NODELINE, A.STPL_GRP_ID, A.LINE_ID, A.STELLPLATZ, A.GEB_SUBTYPE,
      A.LINE_NAME, A.WAGGROUP,
      B.WAGTIMEST, B.LAGE, B.ARTNR, B.GATGRP, B.FORM, B.PRDHLFNR, B.ORDERNR, B.STANDORT, B.LIEFNR, B.LAND,
      B.VPEH, B.MENGE, B.TRAYANZ, B.LFMEEH, B.AUFTRNR, B.AUFTRTIMEST, B.TOURID, B.KARTNR, B.KARTKBZ, B.TEXT,
      B.TOPFGR, B.HOEHE, B.LFKW, B.LFDATUM, B.DT_GEDRUCKT, B.LAUFNR, B.SORT, B.VPELAGE, B.KNDLAD, B.TOURPOS,
      B.CHARGENNR, B.KNDNR, B.STATUS, B.PROCESSING_DEVICE, B.DATE_PROCESSED, B.POS, B.CHECKING_STATUS,
      B.CHECKING_PROCESSING_DEVICE, B.DT_CHECKING_STATECHANGE, B.DT_STATECHANGE, B.STACKABLE, B.KNDKBZ,
      B.REIHE, B.KOMMISSION, B.VERS_TYP, B.FL_ET_GEDR, B.ROTATE, B.HEADROOM, B.PRINT1, B.PRINT2,
      C.TEXT, D.TOUR_STATUS, D.INFO, E.BEZ, E.REIHE, E.ABTEIL, F.ARTKBZ,
      G.LNAME1, G.LNAME2, G.LNAME3, G.LORT, G.LSTRASSE, G.LPLZ, G.LLAND, G.RKNDNR, G.RKNDKBZ, G.KNDGRP,
      G.WAEHR, G.LFKW, G.LFJAHR, G.AUFTRDAT, G.LFDATUM
 FROM B_WAGERL A
INNER JOIN B_LAGE B ON B.CC_ID = A.CC_ID AND B.FIRMNR = A.FIRMNR AND B.WAGTIMEST = A.TIMEST AND A.WAGERL_NR = B.WAGERL_NR
 LEFT OUTER JOIN B_GATGRP C ON B.GATGRP = C.GATGRP
 LEFT OUTER JOIN B_TOURID D ON B.TOURID = D.TOURID
 LEFT OUTER JOIN B_TRANSMITTEL E ON D.TRANSM_ID = E.TRANSM_ID
 LEFT OUTER JOIN B_ARTIKEL F ON B.ARTNR = F.ARTNR AND C.GATGRP = F.GATGRP
 LEFT OUTER JOIN B_AUFTRAG G ON B.AUFTRNR = G.AUFTRNR AND B.KNDNR = G.KNDNR AND A.FIRMNR = G.FIRMNR

</syntaxhighlight> Where clause options:

• WHERE A.FIRMNR = (company no.) AND A.CC_ID = (TLP ID or CC_ID)
• If a TOURID exists: additionally AND B.TOURID = (tour ID)
• If specific Wagerl numbers are selected (one or more): for one Wagerl AND A.WAGERL_NR = (Wagerl no. of the selected row); for several Wagerl AND A.WAGERL_NR IN (Wagerl numbers of the selected rows)

Default order by: A.WAGERL_NR, A.CC_ID, B.ARTNR, B.FORM, B.TOURID, B.REIHE, B.KNDNR, B.KNDLAD. It can be overridden through the table B_REPORT with the key REP_CCSCHEIN_ORDER.

8 Report Variables: Cutting List

**Ported by Claude** · translated to English from WikiPat on 02.10.2026

8.1 Cutting list with location (Schneideliste.qrp)

8.1.1 Input items

<thead></thead><tbody></tbody>

Name	Type	Content
`diSCHNEIDETAG`	Date/Time	Date on which it was cut
`niKW`	Number	Calendar week
`niMENGE`	Number	Quantity
`niSCHNITTMENGE`	Number	Cutting quantity
`niVPEH`	Number	Packing unit
`niZUSMENGE`	Number	Additional cutting quantity
`siARTKBZ`	String	Article short name
`siARTNR`	String	Article no.
`siAUFTRTIMEST`	String	Order timestamp
`siBEET`	String	Location of the bed
`siCOLTEXT`	String	Text from `B_SCHNEIDECOL.TEXT`
`siFIRMNR`	String	Company no.
`siFORM`	String	Product form
`siGATGRP`	String	Genus group
`siGatGrpName`	String	Genus group name
`siHAUS`	String	House
`siHinweis`	String	Note
`siHormon`	String	Hormone treatment varieties / product
`siKNDKBZ`	String	Customer short name
`siKNDLAD`	String	Customer country (as given in the wiki)
`siKNDNAME1` to `siKNDNAME3`	String	Customer name 1 to 3
`siKNDNR`	String	Customer no.
`siKOMMISSION`	String	Commission
`siLOCATION`	String	Area / place
`siLOCGRP`	String	Area group
`siPOOL`	String	Pool
`siPRDHLFNR`, `siROOTFORM`, `siSEKTOR`	String	(no description in the wiki)
`siRootPowCode`	String	Hormone powder short name
`siSLNR`	String	Cutting list no.
`siSTATUS`	String	Status
`siTEXT`	String	Text from the cutting list
`siTOURID`	String	Tour ID
`siWARENGRP`	String	Product group

8.2 Cutting list with / without customers (SchneidelisteSum.qrp or SchneidelisteSumK.qrp)

8.2.1 Input items

<thead></thead><tbody></tbody>

Name	Type	Content
`diSCHNEIDETAG`	Date/Time	Date on which it was cut
`niGESMENGE`	Number	Total quantity
`niKW`	Number	Calendar week
`niMENGE`	Number	Quantity
`niSCHNITTMENGE`	Number	Cutting quantity
`niVPEH`	Number	Packing unit
`niZUSMENGE`	Number	Additional cutting quantity
`siARTKBZ`	String	Article short name
`siARTNR`	String	Article no.
`siCOLTEXT`	String
`siFIRMNR`	String	Company no.
`siFORM`	String	Product form
`siFORMKBZ`	String	`FORM` short name
`siGATGRP`	String	Genus group
`siGATGRPKBZ`	String	Genus group name
`siHormon`	String	Hormone
`siKNDKBZ`	String	Customer short name
`siKNDLAD`	String	Customer country (as given in the wiki)
`siKNDNAME1` to `siKNDNAME3`	String	Customer name 1 to 3
`siKNDNR`	String	Customer no.
`siKOMMISSION`	String	Commission
`siRootPowCode`	String	Hormone powder short name
`siSLNR`	String	Cutting list no.
`siSORTE`	String	Variety
`siSTATUS`	String	Status
`siTEXT`	String	Text
`siTOURID`	String	Tour ID
`siTransMittel`	String	Means of transport
`siPRDHLFNR`	String	Production device
`siKARTNR`	String	Customer article number

8.2.2 Input variables

<thead></thead><tbody></tbody>

Name	Type	Content
`nvPVPEH`	Number	`B_ARTEIGEN.PVPEH`
`nvPFLANZ`	Number	`B_ARTEIGEN.PFLANZ`

8.3 Cutting list quality check (SchneidelisteQualityCheck.qrp)

8.3.1 Input items

<thead></thead><tbody></tbody>

Name	Type	Content
`biLine1`	Number	Boolean variable that shows whether the 1st empty line is displayed
`biLine2`	Number	Boolean variable that shows whether the 2nd empty line is displayed
`biLine3`	Number	Boolean variable that shows whether the 4th empty line is displayed (as given in the wiki)
`biLine4`	Number	Boolean variable that shows whether the 4th empty line is displayed
`diSCHNEIDETAG`	Date/Time	Date on which it was cut
`niGESMENGE`	Number	Total quantity (= `MENGE` + `ZUSMENGE` == cutting quantity)
`niKW`	Number	Calendar week
`niMENGE`	Number	Quantity to cut
`niSCHNITTMENGE`	Number	Cutting quantity = quantity + additional quantity (`ZUSMENGE`)
`niVPEH`	Number	Packing unit
`niZUSMENGE`	Number	Additional quantity (how much more is to be cut)
`siARTKBZ`, `siARTNR`, `siCOLTEXT`, `siFIRMNR`, `siFORM`, `siFORMKBZ`, `siGATGRP`, `siGATGRPKBZ`, `siKNDKBZ`, `siKNDLAD`, `siKNDNAME1` to `siKNDNAME3`, `siKNDNR`, `siKOMMISSION`, `siRootPowCode`, `siSLNR`, `siSORTE`, `siSTATUS`, `siTEXT`, `siTOURID`, `siTransMittel`	String	As in the cutting list above (`siCOLTEXT` = text from `B_SCHNEIDECOL.TEXT`, `siTEXT` = text from the cutting list)
`siHormon`	String	Hormone powder
`siQuality`	String	Quality identifier from `B_ARTEIGEN`
`siQuality2`	String	Quality identifier 2 from `B_ARTEIGEN`

8.4 Cutting list quality check cold store (SchneidelisteQCColdStore.qrp)

8.4.1 Input items

The same items as in the quality check above, with these differences in the descriptions: niGESMENGE = total quantity (= MENGE + ZUSMENGE == cutting quantity); niSCHNITTMENGE = cutting quantity (quantity + additional quantity); niZUSMENGE = how much more is to be cut; niMENGE = quantity. The items biLine1 to biLine4 do not exist; siQuality and siQuality2 exist.

8.7 Cutting list labels

8.7.1 Input items

<thead></thead><tbody></tbody>

Name	Type	Content
`sFIRMNR`	String	Company number
`sTEST`, `sREPHEADER`	String
`nMENGE`	Number	Quantity
`sARTNR`	String	Article number
`sGATGRP`	String	Genus group
`sKNDNR`	String	Customer number
`sKOMMISSION`	String	Commission
`sKNDLAD`	String	Customer delivery address
`sFORM`	String	Variety
`sPRDHLFNR`	String	Production device
`sLAUFNR`, `sKISTENNR`	String
`sSLNR`	String	Cutting list number
`nVPEH`	Number	Packing unit
`nSLKW`	Number
`dSLDATUM`	Date
`sARTKBZ`	String	Article short name
`sSORTE`	String
`sFORMKBZ`	String	Variety short name
`sGATGRPKBZ`	String	Genus group short name
`sPRDHLFNRKBZ`	String	Production device short name
`sBARCODE39PRUEFZ`	String

8.7.2 Input variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svSLTEXT`	String	Text from the cutting list header
`svLORT`, `svLSTRASSE`, `svLNAME1` to `svLNAME3`, `svLPLZ`, `svSEKTOR`, `svHAUS`, `svBEET`	String	(no description in the wiki)
`svKARTNR`	String	Customer article number

9 Report Variables: Common Variables

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

9.1 Report Variables: Common Variables

9.1.2 Report texts 2

(Reportvariablen2) (Reportvariablen 2)

TIMEST, FIRMNR, SPRACHE, FIRMA, FIRMENTYP, VTRTELEFON, VTRMOBIL, VTREMAIL, VTRFAX, KNDADRESSE, DEPOTADRESSE, KONZERNSORTE, PORTO, GESGEW, ETPREIS, ZAHLUNGSZIEL, VALUTA, BELASTUNGSNR, FILIALNR, PACKDATUM, STEUERNR, WARENGRP, BUNDESSTAAT, ARANR, VEREINBSTAFFELMENGE, BARCODE, PROVISION, STANDORT, TOPFGROESSE, HOEHE, KNDVKPREIS, NETTOGEW, BRUTTOGEW, BESTELLNR, URSPRUNGSLAND, LIEFERANT, PRDHLFM, EINHEIT, TRANSPORTKOSTEN, RECHNUNGSADR, UEBERTRAGVON, BEARBEITER, ABTEILUNG, VERSANDABTEILUNG, ANG, SACHBEARBEITER, REFNR, CHARGENNR, LGUEBERSICHT, LGARTNR, LGARTBEZ, SALDO, ANZVERP, GEBINDEART, VOLUMEN, ANZCC, ANZBRETTER, ANZPALETTEN, ANZKARTON, FRTEXT1, FRTEXT2, FRTEXT3, FRTEXT4, FRTEXT5, FRTEXT6, FRTEXT7, FRTEXT8, FRTEXT9, FRTEXT10, FRTEXT11, FRTEXT12, FRTEXT13, FRTEXT14, FRTEXT15, FRTEXT16, FRTEXT17, FRTEXT18, FRTEXT19, FRTEXT20, FRTEXT21, FRTEXT22, FRTEXT23, FRTEXT24, FRTEXT25, FRTEXT26, FRTEXT27, FRTEXT28, FRTEXT29, FRTEXT30, FRTEXT31, FRTEXT32, FRTEXT33, FRTEXT34, FRTEXT35, FRTEXT36, FRTEXT37, FRTEXT38, FRTEXT39, FRTEXT40, SERIENNR, DEBITORENGRP, ANSPRECHPARTNER, MBLISTE, SCHNEIDELISTE, AUSBUCH, DYNREPLAGER, DYNREPSCHNEIDE, DYNREPBESTAND, AVISTITEL, AVISINFO, AVISNR, AVISDATUM, AVISFUSS1, AVISFUSS2, AVISFUSS3, AVISFUSS4, KNDINFOTITEL, KNDINFOINFO, KNDINFONR, KNDINFODATUM, KNDINFOFUSS1, KNDINFOFUSS2, KNDINFOFUSS3, KNDINFOFUSS4, FRACHTZONE, EINGANG, KONTAKT, RKTEL, RKFAX, RKMOBIL, RKEMAIL, LFHANDY, LFEMAIL, LFFAX, ILNNR, KNDILNNR, ZENTRALEILNNR, GELIEFERT, GEBRACHT, ZAHLTEXTGUTSCHRIFT, ZAHLTEXTABBUCHUNGSAF, EWG, EDISTATUS, MINDERWERTZUSCHLAG, NA1, NA2, NA3, NA4, NA5

• NA6 (n.a. from Allgem. Bez.)
• NA7 Description Montag
• NA8 Description Dienstag
• NA9 Description Mittwoch
• NA10 Description Donnerstag
• NA11 Description Freitag
• NA12 Description Samstag
• NA13 Description Sonntag NA14, NA15, NA16, NA17, NA18, NA19, NA20, BEAANG, ANGELEGT, BEAAEN, GEAENDERT

9.1.2.1 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`A_DATUM`	Date	Label for Order date
`A_FUSS1`	String	Label for Footer text 1
`A_FUSS2`	String	Label for Footer text 2
`A_FUSS3`	String	Label for Footer text 3
`A_FUSS4`	String	Label for Footer text 4
`A_INFO`	String
`A_TITEL`	String	Label for order confirmation
`ABGEZ_WERD`	String
`ALTKNDNR`	String
`ANB_DATUM`	String
`ANB_FUSS1`	String
`ANB_FUSS2`	String
`ANB_FUSS3`	String
`ANB_FUSS4`	String
`ANB_INFO`
`ANB_NR`
`ANB_TITEL`
`AP_TITEL`
`ARTIKELBEZ`	String	Label for Article description
`ARTIKELNR`	String	Label for Article number
`String`
`AUFTRAGNR`	String	Label for Order number
`AUFTRAGSINFO`	String
`B_DATUM`
`B_FUSS1`
`B_FUSS2`
`B_FUSS3`
`B_FUSS4`
`B_INFO`
`B_TITEL`
`B_Z_E`
`BANKBLZ1`	String	Bank code 1
`BANKBLZ2`	String	Bank code 2
`BANKBLZ3`	String	Bank code 3
`BANKBLZ4`	String	Bank code 4
`BANKBLZ5`	String	Bank code 5
`BANKBLZ6`	String	Bank code 6
`BANKIBAN1`	String	IBAN number 1
`BANKIBAN2`	String	IBAN number 2
`BANKIBAN3`	String	IBAN number 3
`BANKIBAN4`	String	IBAN number 4
`BANKIBAN5`	String	IBAN number 5
`BANKIBAN6`	String	IBAN number 6
`BANKKONTO1`	String	Account number 1
`BANKKONTO2`	String	Account number 2
`BANKKONTO3`	String	Account number 3
`BANKKONTO4`	String	Account number 4
`BANKKONTO5`	String	Account number 5
`BANKKONTO6`	String	Account number 6
`BANKNAME1`	String	Bank name 1
`BANKNAME2`	String	Bank name 2
`BANKNAME3`	String	Bank name 3
`BANKNAME4`	String	Bank name 4
`BANKNAME5`	String	Bank name 5
`BANKNAME6`	String	Bank name 6
`BANKSWIFT1`	String	SWIFT number 1
`BANKSWIFT2`	String	SWIFT number 2
`BANKSWIFT3`	String	SWIFT number 3
`BANKSWIFT4`	String	SWIFT number 4
`BANKSWIFT5`	String	SWIFT number 5
`BANKSWIFT6`	String	SWIFT number 6
`BANKTITEL`	String	Label for Bank name
`BESTELLNR`
`BETRAG`	String	Label for amount
`BEZ_FIRMA`
`BEZ_ORDERNR`
`BEZ_PFLANZEN`
`BLZ`	String	Label for Bank code
`CCCON`	String	Label for CC-Container
`CCCON_BRETT`	String	Label for CC-Container-Bretter
`DATUM`	String	Label for Date
`EMAIL`	String	E-mail address of the company
`ENDBETRAG`	String	Label for Endbetrag
`EXCL`	String	Label for Exklusive
`FAX`	String	Company fax number
`FIRMA`	String	Company name
`FIRMENTYP`	String	Firmentyp
`FIRMNR`	String	Company number
`FRACHT`	String	Label for Freight
`FRACHTPAUSCHALE`	String	Label for Freight lump sum
`FUSS1`	String	Footer text 1
`FUSS2`	String	Footer text 2
`FUSS3`	String	Footer text 3
`FUSS4`	String	Footer text 4
`G_TITELDUPLIKAT`
`GATGRP`	String
`TEXT_GATGRP`	String	in addition to GATGRP, same value
`GEDR_AM`
`GEPACKT`
`GESAMTMENGE`	String	Label for Total quantity
`GESAMTPREIS`	String	Label for Total price
`GESAMTSUMME`	String	Label for Grand total
`GEW_W`	String	Label for "we grant"
`GUTSCHRIFTNR`
`HANREGNR`	String	Commercial register of the company
`IBAN`
`INTERNET`	String	Description for Internet
`JAHR`
`KNDKBZ`	String	Label for customers
`KNDSUMME`
`KOMMISSION`	String	Label for Consignment
`KONTONR`	String	Label for Account number
`KUNDE`
`KUNDEN_BESTELLNR`	String	Label for customer order number
`KUNDEN_FAX`	String	Label for customer fax number
`KUNDEN_TEL`	String	Label for customer phone number
`KUNDENNR`	String	Label for Customer number
`KW`	String	Label for Kalenderwoche
`L_DATUM`	String	Label for Delivery date
`L_FUSS1`	String	Footer text 1 for the delivery note
`L_FUSS2`	String	Footer text 2 for the delivery note
`L_FUSS3`	String	Footer text 3 for the delivery note
`L_FUSS4`	String	Footer text 4 for the delivery note
`L_INFO`	String	Label for delivery note information
`L_TITEL`	String	Label for delivery note
`LF_DATUM`
`LIEFERADRESSE`	String	Label for Lieferadresse
`LIEFERSCHEINNR`	String	Label for delivery note number
`LIEFERTERMIN`
`LIZENZPREIS`	String	Label for License price
`LL_INFO`
`LL_TITEL`
`MENGE`	String	Label for Quantity
`MWST`	String	Label for VAT
`NETTO`	String	Label for Net
`NETTOBETRAG`	String	Label for Nettobetrag
`PFLANZENPASS`	String	EWB plant passport number of the company
`PL_INFO`
`PL_TITEL`
`PLZ_ORT`	String	Postal code and city of the company
`POSITION`	String	Label for Position
`POSTFACH`	String	Label for P.O. box
`PREIS`	String	Label for price
`PRO`	String	Label for "Pro"
`R_DATUM`	String	Label for Invoice date
`R_FUSS1`	String	Label for Footer text 1 for the invoice
`R_FUSS2`	String	Label for Footer text 2 for the invoice
`R_FUSS3`	String	Label for Footer text 3 for the invoice
`R_FUSS4`	String	Label for Footer text 4 for the invoice
`R_GUTTITEL`
`R_INFO`	String	Label for Invoice information
`R_KNDKBZ`	String	Label for invoice customers
`R_KUNDENNR`	String	Label for Invoice customer number
`R_MENG`
`R_N_Z`	String	Label for "Net Zahlbar"
`R_TITEL`	String	Label for invoice
`R_TITELDUPLIKAT`	String	Label for Duplikat invoice
`RABATT`	String	Label for Rebate
`RECHNUNGNR`
`RECHNUNGSADRESSE`
`SEITE`	String	Label for Page
`SKONTO`	String	Label for Cash discount
`STAATZUSCHL`	String	Label for Staatszuschlag
`STRASSE1`	String	Street 1 company
`STRASSE2`	String	Street 2 company
`SUMME`
`SWIFT`
`T_INFO`
`T_TITEL`
`TELEFON`	String	Phone number of the company
`TEXT_EMAIL`	String	Text "EMAIL"
`TEXT_INTERNET`	String	Homepage of the company
`TIMEST`
`TITEL`
`TITELKLEIN`	String	Company address as sender
`TOUR`
`TRANSMIT`
`TRAYS_BEZ`
`UEBBETRAG`	String	Label for transfer amount
`UHRZEIT`	String	Label for Uhrzeit
`UID_BEZ`	String	Label for VAT ID
`UIDNR`	String	VAT ID company
`VARIANTE`	String	Label for Product form
`VERPACKUNG`	String	Label for packaging
`VERSANDART`	String	Label for Shipping type
`VERTRETERNR`	String	Label for Vertreternummer
`VPEH`	String	Label for Packing unit
`W_O_E`	String	Label for "Ware erhalten"
`WAEHRUNG`	String	Label for Currency
`WARENWERT`	String	Label for Goods value
`ZAHLUNGSART`	String	Label for payment method
`ZH`	String	Label for "attention (c/o)"
`ZUSCHLAG`	String	Label for Surcharge

10 Report Variables: Labels (Etiketten)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

10.1 Report Variables: Labels (Etiketten)

10.1.1 ETIKETTEN

10.1.1.1 Variables

sPRDHLFNR_LANG

<thead></thead><tbody></tbody>

Name	Type	Content
`sARTNR`
`sARTKBZ1`
`sARTKBZ2`
`sARTKBZ3`
`sVARIANTE`
`sAUSVARIANTE`
`sPRDHLFM`
`sLFKW`
`sPRKW`
`sGRUPPE`
`sGATGRP`
`sSORTE1`
`sSORTE2`
`sSORTE3`
`sORDERNR`
`sCHARGENNR`
`sKNDNR`
`sKNDKBZ`
`sMENGE`
`sVPEH`
`sKNDARTNR`
sKNDARTKBZ'
sKNDBARCODE'
`sBARCODE`
`sPRDATE`
`sLFDATE`
`sSTANDORT`
`sTOUR`
`sTOURID`
`sTRANSMITTEL`
`sTOURINFO`
`sABLADEREIHE`
`sVKPREIS`
`sPFLANZENPASS`
`sETIKETTENMENGE`
`sFIRMNR`
`sFIRMBEZ`
`sLIEFERANT`
`sANLNR`
`sANLDATUM`
`sSTDEKPREIS`
`sSTDWAEHR`
`sFIREKPREIS`
`sFIRWAEHR`
`sPMENGE`
`sTEXT`
`sTOPFGR`
`sHOEHE`
`sSPMIN`
`sVKMIN`
`sGEWICHT`
`sSTDVKIKALK`
`sSTDVKIIKALK`
`sPEH`
`sVPELAGE`
`sMWST`
`sKNDANREDE`
`sKNDNAME1`
`sKNDNAME2`
`sKNDSTRASSE`
`sKNDPLZ`
`sKNDORT`
`sKNDLAND`
`sKNDPOSTFACH`
`sKNDZH`
`sKNDORTSTEIL`
`sFIRVKIKALK`
`sFIRVKIIKALK`
`sVARIANTE_LANG`
`sAUSVARIANTE_LANG`
`sARTIKEL_BOTANISCH`
`sGRUPPE_BOTANISCH`
`sANZ_VPEH`
`sIDENTNR`		Reference number in deliveries
`sAUS_LIEFNR`
`sTEXT_1`
`sTEXT_2`
`sTEXT_3`
`sTEXT_4`
`sTEXT_5`
`sTEXT_6`
`sTEXT_7`
`sTEXT_8`
`sTEXT_9`
`sTEXT_10`
`sGESAMTMENGE`
`sETIKETTNUMMER`
`sGATGRP_LANG`
`sWARENGRP`
`sBEIZUNG`
`sVERTRNR`
`sKNDNAME3`
`sKNDLAND_LANG`
`sDEPNR`
`sDEPKBZ`
`sDEPNAME1`
`sDEPNAME2`
`sDEPNAME3`
`sDEPSTRASSE`
`sDEPPLZ`
`sDEPORT`
`sDEPORTSTEIL`
`sDEPLAND`
`sDEPLAND_LANG`
`sKNDLAD`
`sLADNAME1`
`sLADNAME2`
`sLADNAME3`
`sLADSTRASSE`
`sLADPLZ`
`sLADORT`
`sLADORTSTEIL`
`sLADLAND`
`sLADLAND_LANG`
`sKATALOGKENNZ`
`sLIEFNAME`
`sLIEFLAND`
`sLIEFLAND_LANG`
`sLIEFCHARGE`
`sETIKETT_BEZ`
`sLOGO1`
`sLOGO2`
`sLOGO3`
`sKEIMZAHL`
`sABTEILUNG`
`sVERSANDABTEILUNG`
`sPRODABTEILUNG`
`sMENGENFAKTOR`
`sFL_KEIM`
`sTEXT_1`
`sTEXT_2`
`sMATERIALNR`
`sAUSCHARGENNR`
`sAUFTRAGNR`
`sCC`
`sLAGEN`
`sPALETTEN`
`sTRAYS`
`sKENNUNG`		Identifier from B\_ARTIKEL
`sKKBESTNR`
`sTOURPOS`
`sVPANZ`		VPANZ from B\_AUFTRCOL (only on order -> shipping labels 2, not in the printer profile
`sTEXT2_1`
`sTEXT2_2`
`sTEXT2_3`
`sTEXT2_4`
`sTEXT2_5`
`sTEXT2_6`
`sTEXT2_7`
`sTEXT2_8`
`sTEXT2_9`
`sTEXT2_10`
`sTEXT2_11`		For production label EXTERN\_INFO1 - also with print profile without report under printer profiles 2 - additional texts
`sTEXT2_12`		For production label EXTERN\_INFO2 - also with print profile without report under printer profiles 2 - additional texts
`sTEXT2_13`		For production label EXTERN\_INFO3 - also with print profile without report under printer profiles 2 - additional texts
`sTEXT2_14`		For production label EXTERN\_INFO4 - also with print profile without report under printer profiles 2 - additional texts
`sTEXT2_15`
`sTEXT2_16`
`sTEXT2_17`
`sTEXT2_18`
`sTEXT2_19`
`sTEXT2_20`

11 Report Variables: Packing List (PACK_NEU.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

11.1 Report Variables: Packing List (PACK_NEU.qrp)

11.1.1 packing list (PACK_NEU.qrp)

11.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`ARTKBZ`	String	Article description
`ARTNR`	String	Article number
`BEZ`	String	name of the company
`FIRMNR`	String	Company number
`FORM`	String	Product form
`GATGRPBEZ`	String	Article group name
`GESVERPACKMENGE`	String	Type and number of packages in total
`KNDVERPACKMENGE`	String	Type and number of packages per customer
`KW`	String
`LFDATUM`	Date/Time
`LFJAHR`	Number
`LFKW`	Number
`LIEFERDAT`	Date/Time
`MCODE`	String
`nGESVE`	Number
`nKNDVE`	Number
`nMENGE`	Number
`NVE`	Number
`PRDHLFNR`	String
`sGATGRP`	String
`sKNDKBZ`	String
`sKNDNR`	String
`sKOMMISSION`	String
`sKOPFTEXT`	String
`sLADLISTINFO`	String
`sLFINFO`	String
`sLLAND`	String
`sLNAME1`	String
`sLORT`	String
`sLPLZ`	String
`sLSTRASSE`	String
`SORTE`	String
`TOURBEZ`	String
`TOURID`	String
`TOURNR`	String
`TRANSMITTEL`	String
`VERPACKMENGE`	String
`VPEH`	Number
`siKNDLAD`	String	Kundenlieferadresse
`KNDLADVERPACKMENGE`	String	Type and number of packages per Kndlad
`nKNDLADVE`	Number	Number of packages per Kndlad

11.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`ARTIKELBEZ`	String
`ARTIKELNR`	String
`BEZ_FIRMA`	String
`BEZ_PFLANZEN`	String
`GATGRP`	String
`GEDR_AM`	String
`GEPACKT`	String
`GESAMTSUMME`	String
`KNDSUMME`	String
`KOMMISSION`	String
`KUNDE`	String
`LF_DATUM`	String
`MENGE`	String	Label for Quantity (Wartung/Reporttexte)
`PL_INFO`	String
`PL_TITEL`	String
`R_MENGE`	String
`SEITE`	String
`sSTANDORT`	String
`sTOURINFO`	String
`SUMME`	String
`sWARENGRP`	String
`TOUR`	String
`TRANSMIT`	String
`VARIANTE`	String
`VERPACKUNG`	String
`svBARCODE`	String
`svMATERIALNR`	String
`svLIEFNR`	String
`svGATGRPBOTNAME`	String	Botanical name of the article group
`svARTIKELBOTNAME`	String	Botanical name of the article
`svTOURSERVICE`	string
`svTOURLADEHILFSMITTEL`	string
`svTOURABHOLTAG`	string
`svTOURANLIEFERTAG`	string
`dvTOURABHOLZEIT`	date
`dvTOURANLIEFERZEIT`	date
`dVERSANDTAG`	date
`svABHOLZEIT`	String
`svANLIEFERZEIT`	String

svLOCATION_STR

11.1.2 List Article/customer (PACK_ART_KND.qrp)

11.1.2.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`nLFTAG`	Number	Liefertag
`sVARIANTEBEZ`	String	Product form short name

11.1.2.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svKARTNR`	String	Customer article number
`svKARTKBZ`	String	Kundenartikelbezeichnung

12 Report Variables: Delivery List by Customer and Product Form (LFKNDFM.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

12.1 Report Variables: Delivery List by Customer and Product Form (LFKNDFM.qrp)

12.1.1 LFKNDFM.qrp

12.1.1.1 Input Items

FORM, GATGRPBEZ, KNDKBZ, KNDNR, KOMMISION, LFJAHR, LFKW, nGESVE, nPRDMENGE, sBEZ, sFIRMNR, sGESVERPACKMENGE, sJAHRKWText, SORTE

12.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`bDEBUG`	String
`sANREDE`	String
`sDANREDE`	String
`sDEPOTNR`	String
`sDKNDKBZ`	String
`sDLAND`	String
`sDNAME1`	String
`sDNAME2`	String
`sDORT`	String
`sDPLZ`	String
`sDPOSTFACH`	String
`sDSTRASSE`	String
`sDZH`	String
`sEMAIL`	String
`sFAX`	String
`sHANDY`	String
`sKNDKBZ`	String
`sLAND`	String
`sNAME1`	String
`sNAME2`	String
`sORT`	String
`sORTSTEIL`	String
`sPLZ`	String
`sPOSTFACH`	String
`sSTRASSE`	String
`sTELEFON`	String
`sVARIANTENBEZ`	String
`sZH`	String
`svZAHLART`	String	Table: B\_ZAHLART Column: ZAHLART
`svZAHLART_BEZ`	String	Table: B\_ZAHLART Column: BEZ

13 Report Variables: Delivery Summary by Article (LFARTSUM.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

13.1 Report Variables: Delivery Summary by Article (LFARTSUM.qrp)

13.1.1 LFARTSUM.qrp

13.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`ARTKBZ`	String
`ARTNR`	String
`FORM`	String
`GATGRP`	String
`GATGRPBEZ`	String
`LFJAHR`	Number
`LFKW`	Number
`MCODE`	String
`MENGE`	Number
`nGESVE`	Number
`nKNDVE`	Number
`nPRDMENGE`	Number
`nVE`	Number
`nVPEH`	Number
`PRDHLFNR`	String
`sBEZ`	String
`sFIRMNR`	String
`sGESVERPACKMENGE`	String
`sJAHRKWText`	String
`diLFDATUM`	Date/Time	Delivery date
`SORTE`	String
`siALTERNAME`	String	Botanical name

13.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`bDEBUG`	String
`sHeader`	String
`sVARIANTENBEZ`	String
`sWARENGRP`	String
`svZAHLART`	String	Table: B\_ZAHLART Column: ZAHLART
`svZAHLART_BEZ`	String	Table: B\_ZAHLART Column: BEZ

14 Report Variables: Customer Account Balance (KundeKontostand.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

14.1 Report Variables: Customer Account Balance (KundeKontostand.qrp)

14.1.1 KundeKontostand.qrp

14.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`siRECHNR`	String	Invoice number
`diRECHDATUM`	Date/Time	Invoice date
`niKNDNR`	Number	Customer number
`siKNDKBZ`	String	Customer short name, name
`niRKNDNR`	Number	Customer number, recipient
`siRKNDKBZ`	String	Customer short name, recipient
`niRPLZ`	Number	Postal code, recipient
`siRORT`	String	City, recipient
`siRSTRASSE`	String	Street, recipient
`niRECHNUNGBRUTTO`	Number	Invoice amount, Gross €
`niFIRRECHNUNGBRUTTO`	Number	Gross invoice amount in "real" local currency
`niZAHLUNGBRUTTO`	Number	Payment, Gross €
`niFIRZAHLUNGBRUTTO`	Number	Payment, gross, in "real" local currency
`diZAHLUNGDATUM`	Date/Time	Payment date
`siRECHART`	String	Invoice type
`siRECHSTATUS`	String	Invoice status
`niRECHNUNGBRUTTOHEADER`	Number	Gross invoice amount in EUR, per customer number
`niFIRRECHNUNGBRUTTOHEADER`	Number	Gross invoice amount in "real" local currency, per customer number
`niKREDITLIMIT`	Number	Credit limit of the customer from B\_KNDFIRMA
`diZAHLUNGSZIEL`	Date/Time	Payment target of the customer from B\_RECHNUNG

15 Report Variables: Customer Info (Kundeninfo.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

15.1 Report Variables: Customer Info (Kundeninfo.qrp)

15.1.1 Kundeninfo.qrp

15.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`siKNDNR`	String	The customer number
`siFIRMNR`	String	Company number (currently selected)
`siVERTRNR`	String	Sales representative number (determined through customer number and company number)
`siHEADER`	String	Header (TextBaustein => HEADERKNDINFO)
`siINFO`	String	Actually customer information
`dtiDATUM`	Date/Time	Date
`siANGELEGT`	String	Record created on
`siGEAENDERT`	String	Record changed on
`siBEAANG`	String	Record created by
`siBEAAEN`	String	Record changed by
`siVERTRBEZ`	String	name of the sales representative
`siVERTRNAME1`	String	1st name of the sales representative
`siVERTRNAME2`	String	2nd name of the sales representative
`siVERTRPLZ`	String	Postal code of the sales representative
`siVERTRORT`	String	City of the sales representative
`siVERTRLAND`	String	Country of the sales representative
`siVERTRSTRASSE`	String	Street of the sales representative
`siVERTRPOSTFACH`	String	P.O. box of the sales representative
`siVERTRFAX`	String	Fax number of the sales representative
`siVERTRTELEFON`	String	Phone number of the sales representative
`siVERTREMAIL`	String	E-mail address of the sales representative
`siVERTRHANDY`	String	Mobile number of the sales representative
`siRKNDNR`	String	Invoice customer number
`siKNDKBZ`	String	name of the customer
`siRKNDKBZ`	String	name of the invoice customer
`siKNDGRP`	String	Customer group
`siANREDE`	String	Salutation of the customer
`siZH`	String	Zu Handen
`siNAME1`	String	1st name of the customer
`siNAME2`	String	2nd name of the customer
`siNAME3`	String	3rd name of the customer
`siPLZ`	String	Postal code of the customer
`siORT`	String	City of the customer
`siLAND`	String	Country of the customer
`siSTRASSE`	String	Street of the customer
`siTELFON`	String	Phone number of the customer
`siVERKAUFER`	String	Number of the seller
`siTOURNR`	String	Tour number
`siLPO`	String	Country, postal code and city concatenated, of the customer
`siVERTRLPO`	String	Country, postal code and city concatenated, of the sales representative
`siALTERNAME`	String	Botanical name of the article

16 Report Variables: Shipping Assignment (VERSZU.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

16.1 Report Variables: Shipping Assignment (VERSZU.qrp)

16.1.1 VERSZU.qrp

Report for the Versandzuordnung: offene Scan-List :

Aufruf: dlgRepVERSZUORD

16.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`sKNDNR`	String	Customer number
`sFIRMNR`	String	Company number (currently selected)
`sARTKBZ`
`sLAUFNR`	Running number

16.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svKBARCODE`	String	KundenBarcode / cKUNDENARTIKEL.sBARCODE
`svKARTNR`	String	customer article number / cKUNDENARTIKEL.sKARTNR
`svKARTKBZ`	String	KundenArtikelKbz / cKUNDENARTIKEL.sKARTKBZ

17 Report Variables: Invoice Collective List (RECH_SAMMELLISTE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

17.1 Report Variables: Invoice Collective List (RECH_SAMMELLISTE.QRP)

17.1.1 RECH_SAMMELLISTE.QRP

Report for the Versandzuordnung: offene ScanListe :

Aufruf: dlgRepAUSGANGSBUCH

17.1.1.1 Input items (from B_RECHNUNG)

<thead></thead><tbody></tbody>

Name	Type	Content
`sRKNDNR`	String	Invoice customer number
`sRKNDKBZ`	String	Rechnungskundenbezeichnung
`sRECHNR`	String	Invoice number
`sWAEHR`	String	Currency
`nNETTO`	Number	Nettobetrag
`nBRUTTO`	Number	Bruttobetrag
`nMWSTSATZ`	Number	Mehrwertsteuersatz
`nMWSTBETRAG`	Number	Mehrwertsteuerbetrag
`DtRECHDATUM`	Date/Time	Invoice date
`sKNDNR`	String	Customer number
`sKNDKBZ`	String	Customer short name

17.1.1.2 Variables (from B_KNDSTAMM)

<thead></thead><tbody></tbody>

Name	Type	Content
`sSTRASSE`	String	Street of the invoice customer
`sLAND`	String	Country of the invoice customer
`sPLZ`	String	Postal code of the invoice customer
`sORT`	String	City of the invoice customer
`sZH`	String	Attention of the invoice customer
`sPLZ_KUNDE`	String	Postal code of the customer
`sORT_KUNDE`	String	City of the customer
`sILN`	String	ILN number of the customer
`sNAME_FIRMA`	String	name 1 of the customer of the active company
`sSTRASSE_FIRMA`	String	Street of the customer of the active company
`sLAND_FIRMA`	String	Country of the customer of the active company
`sPLZ_FIRMA`	String	Postal code of the customer of the active company
`sSTEUERCODE_FIRMA`	String	Tax code of the customer of the active company
`sORT_FIRMA`	String	City of the customer of the active company
`sDateVon`	String	Invoice date from, from the input mask
`sDateBis`	String	Invoice date to, from the input mask
`sSUMMEN`	String	Composed string from the report dialog containing the totals split by VAT rates
`sKBESTNR`	String	Customer order number / (from B\_RECHNUNGCOL)

18 Report Variables: Carrier List (FRAECHTERLISTE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

18.1 Report Variables: Carrier List (FRAECHTERLISTE.QRP)

18.1.1 Carrier list (FRAECHTERLISTE.QRP)

18.1.1.1 Input Items

siFRACHTNR, siFIRMNR, siTOURID, siKNDNR, siDEPOTNR, siAUFTRNR, siKNDLAD, siSTANDORT, siTOURNR, siWAEHR, siVERSART, siLFNR, siFL_LFSCHEIN, siTEXT, siANGELEGT, siGEAENDERT, siBEAANG, siLNAME1, siBEAAEN, siLNAME2, siLLAND, siLPLZ, siLORT, siLORTSTEIL, siLSTRASSE, siLBUNDESSTAAT, siLPOSTFACH, siLPLZ_PFACH, siTNAME1, siTNAME2, siTLAND, siTPLZ, siTORT, siTORTSTEIL, siTSTRASSE, siTBUNDESSTAAT, siTPOSTFACH, siLIEFERDATUM, siSTATUS, siTPLZ_PFACH, niWARENWERT, niNACHNAMEWERT, siLNAME3, siLANREDE, siLZH, siLUIDNR, siTNAME3, siTANREDE, siTZH, siOVER, siTUIDNR, siPRTSENDINGTYP, siPRTSERVICE, siPROTOKOLL, siFRANKATUR, niPFRACHTPR, niPOSITION, siCOLTEXT, niMENGE, siGEBART, niGEWICHT, siARTNR, siFORM, siPRDHLFNR, niVPEH, niVOLUMEN, siEH, siPEH, niPREIS, siLEERGUTSTATUS, niSTDVKPREIS, siVERRECHNEN, niPMENGE, niFRACHTPREIS, niFRPMENGE, siCOLSTATUS, siLIEFER_KNDNR, siLIEFER_ANREDE, siLIEFER_NAME1, siLIEFER_NAME2, siLIEFER_NAME3, siLIEFER_STRASSE, siLIEFER_LAND, siLIEFER_PLZ, siLIEFER_ORT, siLIEFER_ZH, siLIEFER_POSTFACH, siLIEFER_ORTSTEIL, siLIEFER_TELEFON, siLIEFER_HANDY, siLIEFER_FAX, siKUNDE_KNDNR, siKUNDE_ANREDE, siKUNDE_NAME1, siKUNDE_NAME2, siKUNDE_NAME3, siKUNDE_STRASSE, siKUNDE_LAND, siKUNDE_PLZ, siKUNDE_ORT, siKUNDE_ZH, siKUNDE_POSTFACH, siKUNDE_ORTSTEIL, siKUNDE_TELEFON, siKUNDE_HANDY, siKUNDE_FAX, siFIRMABEZ, siPFLPASSNR, siFIRMALAND, diTOUR_LIEFDAT, siTOUR_STATUS, siTOUR_INFO, diTOUR_VERSANDTAG, siTRANSMITTELBEZ, siKUNDE_LLADELISTINFO, siAUFTRAG_LADELISTINFO, siAUFTRAG_AUFTRINFO, siLIEFER_LANDBEZ, siKUNDE_LANDBEZ, siKUNDE_UIDNR, siLIEFER_UIDNR, siFIRMA_LANDBEZ

18.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`bPAGEBREAKTOUR`
`bPAGEBREAKVERSART`
`bPAGEBREAKVERSTYP`
`bPAGEBREAKSERVICE`

19 Report Variables: Carton Label

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

19.1 Report Variables: Carton Label

19.1.1 Carton label (KARTONETXXX.QRP)

(BLP, Verpackung, Kartonetikett)

19.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Label (German)	Label (English)	Label (Dutch)	Table
siFIRMNR
siFIRMBEZ
siFIRMLAND
siKNDNR
siKNDKBZ
siSTRASSE
siLAND
siPLZ
siORT
siNAME1
siNAME2
siARTNR
siARTKBZ
siFORM
siFORM\_BEZ
siPRDHLFNR
niMENGE
siBOTNAME
siKARTONNR
siAUFTRNR
siARTLAUFNR
siSORTE
siNAME3
siORTSTEIL
siBUNDESSTAAT
siSORTNR
siSORTBEZ
siKARTNR
siKARTKBZ
siTRADEMARK
siKOMMISSIONBOXNR
siTOURID
siCLPDATA
niANZAHLINNENBOXEN
niSTARTKW
siSIZEOFPLANT
siMP\_INFOTEXT	Mutterpflanzen Infotext	Mother plant info text
siTOURBOXNR
siKNDBOXNR
siKENNUNG1	Kennung1 aus B\_ARTFORM	Identifier 1 from B\_ARTFORM
siORDERBOXNR
siKUNDENINFO
siKOMMISSION
niTIMEKUEHL	aus B\_ARTFORM	from variety master data pd. forms

19.1.1.2 Input variables

<thead></thead><tbody></tbody>

Name	Label (German)	Label (English)	Label (Dutch)	Table
svKOMMISSION
nvVPEH
svGATGRP
svGATGRPKBZ				can be translated via the ArtLand genus group text
svGATGRPBOTAN
svGATGRPEMPFOHLEN
svKNDTELEFON
svGESAMTMENGE
svETIKETTNUMMER
svAUFTRNR
svRKNDNR
svRKNDKBZ
svRLAND
svRLANDBEZ
sTOURINFO
svVERSANDARTBEZ
svVATERORDER
svKBESTNR
sv\_TOUR\_BEZ
sv\_TOUR\_STATION1
sv\_TOUR\_STATION2
sv\_TOUR\_ANREDE
sv\_TOUR\_ZH
sv\_TOUR\_NAME1
sv\_TOUR\_NAME2
sv\_TOUR\_NAME3
sv\_TOUR\_LAND
sv\_TOUR\_PLZ
sv\_TOUR\_ORT
sv\_TOUR\_STRASSE
sv\_TOUR\_ORTSTEIL
sv\_TOUR\_POSTFACH
sv\_TOUR\_BUNDESSTAAT
sv\_TOUR\_PLZ\_PFACH
sv\_TOUR\_UIDNR
sv\_TOUR\_NR
svLLANDBEZ
svLANREDE /
svLZH /
svLNAME1
svLNAME2
svLNAME3
svLPLZ
svLORT
svLORTSTEIL
svLSTRASSE
svLPOSTFACH
svLBUNDESSTAAT
svLUIDNR
svKKBESTNR
svVATERTAGESBOXNR
svART\_IN\_INNER	In welchen inner boxen kommt der artikel vor (nur wenn aus 3.letzter Ebene gedruckt)	which inner boxes contain the variety
svINNER\_BOXES	Alle Inner Boxen (nur wenn aus 3.letzter Ebene gedruckt)	All inner boxes
svCONSIGNMENT\_INNER	Die Kommissionen der inner boxen oder Artikel	The consignments of the inner boxes
svTRANSMITTELBEZ	Transportmittelbezeichnung	means of transportation
svORDERNO\_INNER	Auftragsnummern der Inner Boxes	Order numbers of inner boxes
svFATHERORDERNO\_INNER	Vaterauftragsnummern der Inner Boxes	Father order numbers of inner boxes
svTAGESBOX\_INNER	Tagesboxnummern der Inner Boxes	Daily box numbers of inner boxes
svKBESTNR\_INNER	Kundenbestellnummern der Inner Boxes	Cust. o. numbers of inner boxes
svKKBESTNR\_INNER	Kundenkundenbestellnummern der Inner Boxes	Cust. Cust. o. numbers of inner boxes
svGROUPSAMOUNT	Mengen pro Gattungsgruppen der Artikel	Amounts per group of varieties
nvCUTTINGS	Menge der Stecklinge	Amount of cuttings
svWEEK\_AND\_DAY	Schneidetag im Woche(Tag) Format	Cutting Day in Week(Day) Format
svCUSTOMER\_INNER	Kunden der Inner Boxes	Customers of the inner boxes
dvVERSANDTAG	B\_TOURID.VERSANDTAG	Shipping day from B\_TOURID
svVERSANDJAHR	Jahr von B\_TOURID.VERSANDTAG	Year of shipping day from B\_TOURID
svVERSANDTAG	Wochentag von B\_TOURID.VERSANDTAG (1=Montag)	Weekday of shipping day from B\_TOURID (1=monday)
svVERSANDWOCHE	Kalenderwoche von B\_TOURID.VERSANDTAG	Yearweek of shipping day from B\_TOURID
ovQRCODE	QR-Code der Spalte B\_VERSANDCOL.NUMMER	QR-Code of the column B\_VERSANDCOL.NUMMER
svFRACHTZONE	Feld FRACHTZ aus B\_AUFTRAG	Field FRACHTZ from table B\_AUFTRAG
svDEPOTNR	Feld DEPOTNR aus B\_AUFTRAG	Field DEPOTNR from Table B\_AUFTRAG (Depot no.)
svDEPOTKBZ	Feld DEPKBZ aus B\_AUFTRAG	Field DEPKBZ from Table B\_AUFTRAG (Depot name)
svDEPOTPLZ	Feld DEPPLZ aus B\_AUFTRAG	Field DEPPLZ from Table B\_AUFTRAG (Depot zipcode)
svFRACHTZBEZ	Feld BEZ aus B\_FRACHTZ	Field BEZ from Table B\_FRACHTZ (Freightzone name)
svABHOLTAG	B\_TOURID.ABHOLTAG	B\_TOURID.ABHOLTAG
svANLIEFERTAG	B\_TOURID.ANLIEFERTAG	B\_TOURID.ANLIEFERTAG
dvABHOLZEIT	B\_TOURID.ABHOLZEIT	B\_TOURID.ABHOLZEIT
dvANLIEFERZEIT	B\_TOURID.ANLIEFERZEIT	B\_TOURID.ANLIEFERZEIT
dvANLIEFERDATUM	B\_TOURID.ANLIEFERDATUM	B\_TOURID.ANLIEFERDATUM
svBOX\_STANDORT	B\_VERSANDCOL.BOX\_STANDORT	B\_VERSANDCOL.BOX\_STANDORT
nvANLIEFERJAHR	Jahr von B\_TOURID.ANLIEFERDATUM	Year of B\_TOURID.ANLIEFERDATUM
nvANLIEFERWOCHE	Kalenderwoche von B\_TOURID.ANLIEFERDATUM	Calendar week of B\_TOURID.ANLIEFERDATUM
nvANLIEFERTAG	Wochentag von B\_TOURID.ANLIEFERDATUM	Weekday of B\_TOURID.ANLIEFERDATUM
svFLIP\_TAGESBOX	Tagesboxnummer rückwärts geschrieben --> mit dem Font UpsideDown.ttf kann der wert dann auf dem Kopf dargestellt werden	daily boxnumber backwards --> use Font UpsideDown.ttf to display
svFLIP\_TAGESBOX\_INNER	Innere Tagesboxnummern rückwärts geschrieben	list of inner daily boxnumbers backwards
svALLEGATGRPBOTANISCH	Die botanischen Namen aller Gattungsgruppen	List of botanical names of all variety groups
svPZ\_CODES	Haftungsausschlussmatrix Daten	Date of disclaimer matrix
svPFLPASSNR	Pflanzenpassnummer über Service aus B\_KONVERT oder aus B\_FIRMA	Plantpassno. through service from B\_KONVERT, else from B\_FIRMA (company)
svLIEFALLELAENDERISO	Die ISO Codes der Lieferantenländer der Auftragszeilen	ISO codes of supplier countries of order lines
svAWB\_ID	Flugrechnungsnummer aus B\_TOURID	Airway Bill No. from b\_TOURID
svMASTER\_AWB\_ID	Master Flugrechnungsnummer aus B\_TOURID	Master Airway Bill No. from b\_TOURID

20 Report Variables: Offer

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

20.1 Report Variables: Offer

20.1.1 Offer (RECH_ANGEBOT.QRP)

Incomplete in the source wiki.

20.1.1.1 Input Items

• String: siALTERNAME ( Botanical name eines Artikels )

20.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`Lieferdatum`	String
`sPage`	String
`MwStText0`	String
`MwStText1`	String
`MwStText2`	String
`MwStText3`	String
`MwSt0`	Number
`MwSt1`	Number
`MwSt2`	Number
`MwSt3`	Number
`Netto0`	Number
`Netto1`	Number
`Netto2`	Number
`Netto3`	Number
`FIRMNR`	String	Company number
`TIMEST`	String
`FIRMA`	String
`FIRMENTYP`	String
`TITEL`	String
`TITELKLEIN`	String
`PLZ_ORT`	String
`STRASSE1`	String
`STRASSE2`	String
`TELEFON`	String
`FAX`	String
`TEXT_EMAIL`	String
`EMAIL`	String
`TEXT_INTERNET`	String
`INTERNET`	String
`UIDNR`	String
`PFLANZENPASS`	String
`BANKTITEL`	String
`BLZ`	String
`KONTONR`	String
`BANKNAME1`	String
`BANKKONTO1`	String
`BANKBLZ1`	String
`BANKNAME2`	String
`BANKKONTO2`	String
`BANKBLZ2`	String
`BANKNAME3`	String
`BANKKONTO3`	String
`BANKBLZ3`	String
`BANKNAME4`	String
`BANKKONTO4`	String
`BANKBLZ4`	String
`BANKNAME5`	String
`BANKKONTO5`	String
`BANKBLZ5`	String
`BANKNAME6`	String
`BANKKONTO6`	String
`BANKBLZ6`	String
`ZH`	String
`KUNDENNR`	String
`AUFTRAGNR`	String
`LIEFERSCHEINNR`	String
`RECHNUNGNR`	String
`WAEHRUNG`	String
`VERSANDART`	String
`KOMMISSION`	String
`R_KUNDENNR`	String
`KNDKBZ`	String
`R_KNDKBZ`	String
`AUFTRAGSINFO`	String
`VERTRETERNR`	String
`FRACHTPAUSCHALE`	String
`ZAHLUNGSART`	String
`DATUM`	String
`A_DATUM`	String
`L_DATUM`	String
`R_DATUM`	String
`POSITION`	String
`ARTIKELNR`	String
`VARIANTE`	String
`ARTIKELBEZ`	String
`MENGE`	String
`GESAMTMENGE`	String
`PREIS`	String
`EXCL`	String
`MWST`	String
`VPEH`	String
`PRO`	String
`LIZENZPREIS`	String
`KW`	String
`JAHR`	String
`GESAMTSUMME`	String
`L_FUSS1`	String
`L_FUSS2`	String
`L_FUSS3`	String
`L_FUSS4`	String
`nBETRAG_ETIKETTE`	Number	Etikettenbetrag in the line
`nPOSSUM_ETIKETTE`	Number	Labels Grand total
`nETPREIS`	Number	Label price
`nvETPMENGE`	Number	Label price quantity
`nvETMENGE`	Number	Label quantity
`nvETMWST`	Number	EtikettenMWST
`nvLFKW_BIS`	Number	Delivery week to
`nvLFJAHR_BIS`	Number	Delivery year to
`nvLFKW_VON`	Number	Delivery week
`nvLFJAHR_VON`	Number	Lieferjahr
`dvLFDATUM_BIS`	Date	Delivery date to
`dvLFDATUM_VON`	Date	Delivery date
`nvBISMENGE`	Number	To quantity
`sFUSSTEXT`	String	Offer footer
`sKOPFTEXT`	String	Angebotskopf
`ANB_FUSS`	String	General texts / offer footer 1
`ANB_FUSS2`	String	General texts / offer footer 2
`ANB_FUSS3`	String	General texts / offer footer 3
`ANB_FUSS4`	String	General texts / offer footer 4
`svUSER`	String	Windows user
`sANB_KOPF1`	String	Header text 1 for offer
`sANB_KOPF2`	String	Header text 2 for offer
`Picture`	Object	contains a JPG (image file)
`svKUNDE_ARANR`	String	Aranr of the delivery customer

21 Report Variables: Order Statistics (auftragsinfo.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

21.1 Report Variables: Order Statistics (auftragsinfo.qrp)

21.1.1 Order statistics (auftragsinfo.qrp)

21.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Label (German)	Label (English)	Label (Dutch)	Table
sFIRMNR	FirmNr	Comp.id.		B\_AUFTRAG.FIRMNR
sKNDNR	KndNr.	Cust. no.		B\_AUFTRAG.KNDNR
sKNDKBZ	Kurzbezeichnung	Code		B\_AUFTRAG.KNDKBZ
sKNDGRP	Knd. Gruppe	Customer group		B\_AUFTRAG.KNDGRP
sKNDLAD	Lieferadresse	Shipping to		B\_AUFTRAG.KNDLAD
sAUFTRNR	AuftragsNr.	Order no.		B\_AUFTRAG.AUFTRNR
dAUFTRDAT	Auftrags-Datum	Date of order		B\_AUFTRAG.AUFTRDAT
sFL\_AFGEDR	AF (AB gedruckt)	Order		B\_AUFTRAG.FL\_AFGEDR
sCOLSTATUS	ST (Status der Auftragsposition)	Status		B\_AUFTRCOL.STATUS
nLFJAHR	LF Jahr	Del.year		B\_AUFTRCOL.LFJAHR
nLFKW	LF KW	Del.week		B\_AUFTRCOL.LFKW
dLFDATUM	LF Tag	Del.day		B\_AUFTRCOL.LFDATUM
dAUSGDAT	Warenausgangsdatum	Date of dispatch		B\_AUFTRCOL.AUSGDAT
sGATGRP	Gruppe	Group		B\_AUFTRCOL.GATGRP
sGATGRPKBZ	Gruppe Name	Group name		B\_GATGRP.TEXT
sARTNR	Artikel	Variety		B\_AUFTRCOL.ARTNR
sFORM	VK-Variante	Sales PF		B\_AUFTRCOL.FORM
sFORMKBZ	VK-Variante Name	Sales PF text		B\_FORM.KBZ
sPRDHLFNR	Prdhlfnr.	Pd. dev.no.		B\_AUFTRCOL.PRDHLFNRv
nMENGE	Menge	Amount		B\_AUFTRCOL.MENGE
nMENGE\_2	Menge2	Amount 2		B\_AUFTRCOL.MENGE
nSTDVKPREIS	Warenwert	Goods value		B\_AUFTRCOL.STDVKPREIS
nSTDVKPREIS\_2	Warenwert2	Goods value2		B\_AUFTRCOL.STDVKPREIS
nSTDVKPREIS2	Stückpreis keine Summe	Unit price no sum		B\_AUFTRCOL.STDVKPREIS/B\_AUFTRCOL.PMENGE
nSTDVKPREIS3	Preis keine Summe	Price no sum		B\_AUFTRCOL.STDVKPREIS
sSTDWAEHR	Währ.	Curr.		B\_AUFTRCOL.STDWAEHR
sARTKBZ	Bezeichnung	Name		B\_AUFTRCOL.ARTKBZ
nSTDVKSUM	Gesamtpreis	Total price		B\_AUFTRCOL.STDVKSUM
nSTDVKSUM\_2	Gesamtpreis2	Total price2		B\_AUFTRCOL.STDVKSUM
nFIRVKPREIS	Warenwert Konzern	Goods value GP		B\_AUFTRCOL.FIRVKPREIS
nFIRVKPREIS\_2	Warenwert Konzern2	Goods value GP2		B\_AUFTRCOL.FIRVKPREIS
nFIRVKSUM	Gesamtpreis Konzern	Total price GP		B\_AUFTRCOL.FIRVKSUM
nFIRVKSUM\_2	Gesamtpreis Konzern2	Total price GP 2		B\_AUFTRCOL.FIRVKSUM
nGNDPREIS	Warenwert Grundpreis	Goods value base price		B\_AUFTRCOL.GNDPREIS
nGNDPREIS\_2	Warenwert Grundpreis2	Goods valuebase price2		B\_AUFTRCOL.GNDPREIS
nGNDPREIS2	GrundStückpreis keine Summe	Basic part price, no sum		B\_AUFTRCOL.GNDPREIS/B\_AUFTRCOL.PMENGE
sFIRWAEHR	Währ. Konzern	Curr. GP		B\_AUFTRCOL.FIRWAEHR
sVONFIRMNR	Von Firma	From company		B\_AUFTRCOL.VONFIRMNR
sSTANDORT	Prod. Standort	Production location		B\_AUFTRCOL.STANDORT
sVERTRNR	Vertreter	Sales representative		B\_AUFTRAG.VERTRNR
sVERTRBEZ	Vertreter Bezeichnung	Name of sales represent.		B\_VERTRETER.BEZ
sLIEFNR	Lieferant	Supplier		B\_AUFTRCOL.LIEFNR
nTRAYANZ	Tray Anzahl	Tray quantity		B\_AUFTRCOL.MENGE/B\_AUFTRCOL.VPEH
nTRAYANZ\_2	Tray Anzahl2	Tray quantity2		B\_AUFTRCOL.MENGE/B\_AUFTRCOL.VPEH
sTRANSMITTEL	Transportmittel	Means of transportation		B\_TRANSMITTEL.BEZ
sINFO	Tour-Info	Tour info		B\_TOURID.INFO
sLFNR	LF-Nr.	Del. no.		B\_AUFTRCOL.LFNR
sRECHNR	RE-Nr.	Inv.no.		B\_AUFTRCOL.RECHNR
sKBESTNR	K-BestNr.	C del. no.		B\_AUFTRAG.KBESTNR
nEP	EP	CP		B\_AUFTRCOL.EP
nEP\_2	EP2	CP2		B\_AUFTRCOL.EP
nEINZELPREIS	MW Stückpreis	Median parts price
nEINZELPREIS\_2	MW Stückpreis2	Median parts price2
nMWPREIS	MW Preis	Median price
nMWPREIS\_2	MW Preis2	Median price2
nPMENGE	Pro Menge	Per amount		B\_AUFTRCOL.PMENGE
nPRJAHR	PR Jahr	Pd. year		B\_AUFTRCOL.PRJAHR
nPRKW	PR KW	Pd. week		B\_AUFTRCOL.PRKW
dPRDATUM	PR Tag	Pd. day		B\_AUFTRCOL.PRDATUM
sAUSFORM	Ausg. Variante	Basic PF		B\_AUFTRCOL.AUSFORM
nAUSMENGE	Ausg. Menge	Basic amount		B\_AUFTRCOL.AUSMENGE
nAUSMENGE\_2	Ausg. Menge2	Basic amount2		B\_AUFTRCOL.AUSMENGE
sTEXT	Text	Text		B\_AUFTRCOL.TEXT
sKOMMISION	Kommission	Picking		B\_AUFTRCOL.KOMMISION
sWARENGRP	Warengruppe	Product group		B\_ARTFORM.WARENGRP
sWARGRPBEZEICHNUNG	Warengruppe Bezeichnung	Name of product group		B\_WARENGRP.BEZEICHNUNG
sORDERNR	OrderNr.	System o. no.		B\_AUFTRCOL.ORDERNR
sKARTNR	Kunden-ArtikelNr.	Customer V no.		B\_AUFTRCOL.KARTNR
sKARTKBZ	Kundenartikel Bezeichnung	Customer variety name		B\_AUFTRCOL.KARTKBZ
sBEAANG	Bearbeiter (angelegt)	User (installed)		B\_AUFTRCOL.BEAANG
sBEAAEN	Bearbeiter (geändert)	User (changed)		B\_AUFTRCOL.BEAAEN
sLNAME1	LF Name1	Del.name1		B\_AUFTRAG.LNAME1
sLNAME2	LF Name2	Del.name2		B\_AUFTRAG.LNAME2
sLSTRASSE	LF Strasse	Del. street		B\_AUFTRAG.LSTRASSE
sLLAND	LF Land	Del. country		B\_AUFTRAG.LLAND
sLBUNDESSTAAT	LF Bundesstaat	Delivery federal state		B\_AUFTRAG.LBUNDESSTAAT
sLPLZ	LF PLZ	Del. zipcode		B\_AUFTRAG.LPLZ
sLORT	LF Ort	Del. city		B\_AUFTRAG.LORT
sLORTSTEIL	LF Ortsteil	Del.district		B\_AUFTRAG.LORTSTEIL
sSTATUS	Status	Status		B\_AUFTRCOL.STATUS
sBAUSTEINNR	Baustein	Sales mix		B\_AUFTRCOL.BAUSTEINNR
sBESTTIMEST	Bestell Datum	Date of purch. order		B\_AUFTRCOL.BESTTIMEST
sVERKAUFSLEITER	Verkaufsleiter	Sales manager		B\_KNDFIRMA.VERKAUFSLEITER
sVERKLBEZ	Verkaufsleiter Bezeichnung	Sales manager name		VERKFL.BEZ
sZUSBARCODE	Barcode	Barcode		B\_ARTFORM.ZUSBARCODE
sARTEINGANG	Eingang	Incoming		B\_AUFTRAG.ARTEINGANG
nMENGENFAKTOR	Mengenfaktor	Amount factor		B\_AUFTRCOL.MENGENFAKTOR
nETMENGE	Etikette Menge	Label amount		B\_AUFTRCOL.ETMENGE
nETVPEH	Etikette VPEH	Label pack. u.		B\_AUFTRCOL.ETVPEH
nETPREIS	Etikette Preis	Label price		B\_AUFTRCOL.ETPREIS
nETPMENGE	Etikette pro ME	Label per am.u.		B\_AUFTRCOL.ETPMENGE
sLFMEEH	EH	Unit		B\_EINHEITEN.BEZ
sARTKBZD	Bezeichnung Druck	Name of print		B\_ARTLAND.ARTKBZ
nVPEH	VPEH	Pack. unit		B\_AUFTRCOL.VPEH
sMAGRP	Maschinengruppe	Group of machines		B\_ARTEIGEN.MAGRP
nGNDMENGE	Grund Menge	Basic amount		B\_AUFTRCOL.GNDMENGE
sLFSTAT	LF Schein erzeugt	Del. note created		B\_AUFTRCOL.LFSTAT
sTOURNR	TourNr.	Tour no.		B\_AUFTRCOL.TOURNR
sRKNDNR	RE KndNr.	Inv. C no.		B\_AUFTRAG.RKNDNR
sRKNDKBZ	RE Kurzbezeichnung	Invoice code		B\_AUFTRAG.RKNDKBZ
nFRACHTPREIS	Frachtpreis	Freight price		B\_AUFTRCOL.FRACHTPREIS
sSACHBEARBEITER	B\_AUFTRCOL.FRACHTPREIS	Person in charge		B\_AUFTRAG.SACHBEARBEITER
sTELEFON	Telefon	Telephone		B\_KNDSTAMM.TELEFON
sFAX	Fax	Fax		B\_KNDSTAMM.FAX
sEMAIL	Email	Email		B\_KNDSTAMM.EMAIL
nEKPREIS	Einkaufspreis	Purchase price		B\_AUFTRCOL.EKPREIS
nLIZPREIS	Lizenzpreis	License fee		B\_AUFTRCOL.LIZPREIS
nFIRLIZPREIS	Lizenzpreis Konzern	License fee GP		B\_AUFTRCOL.FIRLIZPREIS
nLIZPROSTK	Lizenz pro Stück	Licence per part		B\_AUFTRCOL.LIZPROSTK
nVERTBERPROV	Provision \[%\]	Commission \[%\]		B\_AUFTRCOL.VERTBERPROV
nVERTBERPROV2	Provision \[%\]	Commission \[%\]		B\_AUFTRCOL.VERTBERPROV
nPROVISION	Provision	Commission
nPROVISION2	Provision	Commission
sSORTE	Sorte	Sort		B\_ARTIKEL.SORTE
sLANGTEXT	Artikel Beschreibung	Variety sales text		B\_ARTIKEL.LANGTEXT
sBE\_STATUS	BE-Status	PO status		B\_AUFTRCOL.BE\_STATUS
sTOURID	Tour ID	Tour ID		B\_AUFTRCOL.TOURID
sGEBART	Gebindeart	Del.u. type		B\_AUFTRCOL.GEBART
nANZGEB	Anzahl Gebinde	Qty. del. unit		B\_AUFTRCOL.ANZGEB
nCALC\_ANZGEB	Kalk. Anzahl Gebinde	Calc. qty. del. u.
sTRANSM\_ID	Transmittel ID	M.transport ID		B\_AUFTRCOL.TRANSM\_ID
nANZ\_LAGEN\_KARTONS	alk. Anzahl Lagen/Kartons	Calc. qty. shelf/box
sFL\_LIEFDIREKT	Direkte Lieferung	Direct delivery		B\_AUFTRCOL.FL\_LIEFDIREKT
sINFOTEXT	Info Text	Info Text
sHANDY	Handy	Mobile phone		B\_KNDSTAMM.HANDY

22 Report Variables: Production Plan (PRODPLAN.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

22.1 Report Variables: Production Plan (PRODPLAN.QRP)

22.1.1 production plan (PRODPLAN.QRP)

22.1.1.1 Input Items

nPRKW, dPRDATUM, nLFKW, sGATGRP, sARTNR, sARTKBZ, nAUSMENGE, sFORM, sFIRMNR, sSHOW, sORDERNR, sROOTFORM, sPRDHLFNR, sCHARGENNR, sSTANDORT, sTEXT, nG_MENGE, nE_MENGE

• nP_MENGE (contains the init quantity if company settings -> settings production 2 -> start with quantity = 0) sGATGRPBEZ, sIDENTNR, nLFJAHR, nPRJAHR, dLFDATUM, nG_TRAY_MENGE, nE_TRAY_MENGE
• nP_TRAY_MENGE (calculated from the init quantity if the setting applies, see item nP_MENGE) sMAGRP, sWARENGRP, siAUSFORM, siPRODGRP, siPRODGRPNAME, niAUSMENGANZ, siPRODTEXT, niVPEH, niPVPEH, dPLANDATUM, nSEEDBUFFER, nMENGE_MEH, nMENGE_GEH, sGEWICHT_EH, sMENGEN_EH, sGRUND_EH, nWEB_VK_EH_CC, nWEB_VK_EH_BOX, sPLC, sMACHINE_ATTRIBUTE, sSEPERATOR_CODE, nVACUUM, nDRUM_SPEED, nBLOW_PIPE1, nBLOW_PIPE2, nBLOW_PIPE3, nBLOW_PIPE4, nSEED_OFF_BLOWER, sMACHINE_ATTRIBUTE_TEXT, sSEPERATOR_CODE_TEXT, sPLC_TEXT, sCOVMAT, sCOVQUANT, sCOVMAT_TEXT, sCOVQUANT_TEXT, sWATERTYPE, sWATERTYPE_TEXT, sSPRINKLERSET, sSPRINKLERSET_TEXT, nKEIMZEIT, nKEIMTEMP, nKORNANZAHL, sMULDENTIEFE, sKEIMZUSATZ, sLEVELCODE, sROOTPOWCODE, sLEVELCODE_TEXT, sROOTPOWCODE_TEXT, sSOIL_TYPE, sSOIL_TYPE_TEXT, sQUALITAETKENNZ, sQUALITAET_TEXT, sMACHINE_BEZ, nPE_MENGE, nPE_TRAY_MENGE, sKENNUNG, nLIEFVPEH, sLIEFNR
• niPFLANZ --> (B_ARTEIGEN.PFLANZ = Inhalt)
• niPPFLANZ --> (B_ARTEIGEN.PFLANZ = P-Inhalt) sEXTERN_INFO1, sEXTERN_INFO2, sEXTERN_INFO3, sEXTERN_INFO4, sTEXT2
• sSTATUS2 (from B_ARTIKEL - secondary status)
• sSTATUS3 (from B_ARTIKEL - tertiary status)

22.1.1.2 Variables

bMAGRP, bCHARGENNR, sSorte, sVARIANTEBEZ, bDEBUG, nvLFTAG, nvPRTAG, svABTEILUNG, svRESERVIERUNG, svKUNDEN, svKUNDENNR, svKUNDENKBZ

• svPRDHLFNRBEZ (long description of the production aid)

22.1.1.3 External report sorting

REP_MAGRP_ORDER c.MAGRP, a.GATGRP, a.ARTNR, b.ARTKBZ, a.FORM, a.AUSGFORM, a.PRJAHR, a.PRKW, a.PRDATUM, a.PRDHLFNR, a.LFJAHR, a.LFKW, a.LFDATUM, a.PRODGRP, a.PVPEH, a.VPEH, a.ORDERNR, a.ROOTFORM, a.FIRMNR, a.HALTBBIS, a.HATDATUM, a.HALTBTAGE,a.DAUERTAGE,d.HINWEIS, b.SORTE, d.WARENGRP,a.AUSMENGANZ,a.ABTEILUNG, a.PRODGRP, a.TEXT, a.PLANDATUM, a.SEEDBUFFER, d.MENGE_MEH, d.MENGE_GEH, d.GEWICHT_EH, d.MENGEN_EH, d.GRUND_EH, d.WEB_VK_EH_CC, d.WEB_VK_EH_BOX, d.PLC, e.COVMAT, e.COVQUANT, e.WATERTYPE, e.SPRINKLERSET, d.KEIMZEIT, d.KEIMTEMP, d.KORNANZAHL, d.MULDENTIEFE, d.KEIMZUSATZ, d.LEVELCODE, d.ROOTPOWCODE, a.EXTERN_INFO1, a.EXTERN_INFO2, a.EXTERN_INFO3, a.EXTERN_INFO4, a.TEXT2

REP_PRODEINTRAEGE_ORDER a.GATGRP, a.ARTNR, b.ARTKBZ, a.FORM, a.AUSGFORM, a.PRJAHR, a.PRKW, a.PRDATUM, a.PRDHLFNR, a.LFJAHR, a.LFKW, a.LFDATUM, a.PRODGRP, a.PVPEH, a.VPEH, a.ORDERNR, a.ROOTFORM, a.FIRMNR, a.HALTBBIS, a.HATDATUM, a.HALTBTAGE,a.DAUERTAGE,c.MAGRP, d.HINWEIS, b.SORTE, d.WARENGRP,a.AUSMENGANZ,a.ABTEILUNG, a.PRODGRP, a.TEXT, a.PLANDATUM, a.SEEDBUFFER, d.MENGE_MEH, d.MENGE_GEH, d.GEWICHT_EH, d.MENGEN_EH, d.GRUND_EH, d.WEB_VK_EH_CC, d.WEB_VK_EH_BOX, d.PLC, e.COVMAT, e.COVQUANT, e.WATERTYPE, e.SPRINKLERSET, d.KEIMZEIT, d.KEIMTEMP, d.KORNANZAHL, d.MULDENTIEFE, d.KEIMZUSATZ, d.LEVELCODE, d.ROOTPOWCODE, a.EXTERN_INFO1, a.EXTERN_INFO2, a.EXTERN_INFO3, a.EXTERN_INFO4, a.TEXT2

REP_PRODRES_ORDER a.GATGRP, a.ARTNR, b.ARTKBZ, a.FORM, a.AUSGFORM, a.PRJAHR, a.PRKW, a.PRDATUM, a.PRDHLFNR, a.LFJAHR, a.LFKW, a.LFDATUM, a.PRODGRP, a.PVPEH, a.VPEH, a.ORDERNR, a.ROOTFORM, a.FIRMNR, a.HALTBBIS, a.HATDATUM, a.HALTBTAGE, a.DAUERTAGE,c.MAGRP, d.HINWEIS, a.CHARGENNR, b.SORTE, d.WARENGRP,a.AUSMENGANZ,a.ABTEILUNG, a.PLANTIMEST, a.PRODGRP, a.TEXT, a.AKTKEIMUNG, a.PLANDATUM, a.SEEDBUFFER, d.MENGE_MEH, d.MENGE_GEH, d.GEWICHT_EH, d.MENGEN_EH, d.GRUND_EH, d.WEB_VK_EH_CC, d.WEB_VK_EH_BOX, d.PLC, e.COVMAT, e.COVQUANT, e.WATERTYPE, e.SPRINKLERSET, d.KEIMZEIT, d.KEIMTEMP, d.KORNANZAHL, d.MULDENTIEFE, d.KEIMZUSATZ, d.LEVELCODE, d.ROOTPOWCODE, a.EXTERN_INFO1, a.EXTERN_INFO2, a.EXTERN_INFO3, a.EXTERN_INFO4, a.TEXT2

23 Report Variables: Production Plan with Reservations (PRODPLAN_RES.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

23.1 Report Variables: Production Plan with Reservations (PRODPLAN_RES.QRP)

23.1.1 production plan (PRODPLAN.QRP)

23.1.1.1 Input Items

nPRKW, dPRDATUM, nLFKW, sGATGRP, sARTNR, sARTKBZ, nAUSMENGE, sFORM, sFIRMNR, sORDERNR, sROOTFORM, sPRDHLFNR, sCHARGENNR, sSTANDORT

• sTEXT = TEXT from B_ARTFORM nG_MENGE, nE_MENGE, nP_MENGE, nG_TRAY_MENGE, nE_TRAY_MENGE, nP_TRAY_MENGE, sGATGRPBEZ, sIDENTNR, nLFJAHR, nPRJAHR, dLFDATUM, sMAGRP, sWARENGRP, siAUSFORM, niAUSMENGANZ, siPRODTEXT, niAKTKEIMUNG, niVPEH, niPVPEH, dPLANDATUM, nSEEDBUFFER, nMENGE_MEH, nMENGE_GEH, sGEWICHT_EH, sMENGEN_EH, sGRUND_EH, nWEB_VK_EH_CC, nWEB_VK_EH_BOX, sPLC, sMACHINE_ATTRIBUTE, sSEPERATOR_CODE, nVACUUM, nDRUM_SPEED, nBLOW_PIPE1, nBLOW_PIPE2, nBLOW_PIPE3, nBLOW_PIPE4, nSEED_OFF_BLOWER, sMACHINE_ATTRIBUTE_TEXT, sSEPERATOR_CODE_TEXT, sPLC_TEXT, sCOVMAT, sCOVQUANT, sCOVMAT_TEXT, sCOVQUANT_TEXT, sWATERTYPE, sWATERTYPE_TEXT, sSPRINKLERSET, sSPRINKLERSET_TEXT, nKEIMZEIT, nKEIMTEMP, nKORNANZAHL, sMULDENTIEFE, sKEIMZUSATZ, sLEVELCODE, sROOTPOWCODE, sLEVELCODE_TEXT, sROOTPOWCODE_TEXT, sSOIL_TYPE, sSOIL_TYPE_TEXT, sQUALITAETKENNZ, sQUALITAET_TEXT, sMACHINE_BEZ, sKENNUNG
• niPFLANZ --> (B_ARTEIGEN.PFLANZ = Inhalt)
• niPPFLANZ --> (B_ARTEIGEN.PFLANZ = P-Inhalt) sEXTERN_INFO1, sEXTERN_INFO2, sEXTERN_INFO3, sEXTERN_INFO4, sTEXT2
• sSTATUS2 (from B_ARTIKEL - secondary status)
• sSTATUS3 (from B_ARTIKEL - tertiary status)

23.1.1.2 Variables

sSORTE, sVARIANTEBEZ, nvLFTAG, nvPRTAG, svABTEILUNG

• svRESERVIERUNG (batch numbers, quality of the reserved batches, location, production location, quantity, tray quantity, ident no., germination figure supplier, weight, 1000 grain weight)
• svKUNDEN (All customers Name1)
• svRESERVIERUNG_IDENT (batch numbers, ident numbers, quality of the reserved batches)
• svRESERVIERUNG_NUR_IDENT (ident numbers of the reserved batches)
• nvP_MENGE_GEH (Gesamtgewicht the reservierten Batches)
• svKUNDENKBZ (All customers Short name)
• svRESERVIERUNG_LAGERNR (storage number of the reserved batch from B_ARTFORM)
• svKUNDENNR (Customer numbers)
• nvRES_LFKW1..n: LFKW from the reservierten Prodplan Batch
• nvRES_LIEFVPEH1..n: Suppliers VPEH from the reservierten Prodplan Batch
• svRES_LIEFNR1..n: supplier number from the reserved Prodplan batch

23.1.1.3 External report sorting

REP_MAGRP_ORDER c.MAGRP, a.GATGRP, a.ARTNR, b.ARTKBZ, a.FORM, a.AUSGFORM, a.PRJAHR, a.PRKW, a.PRDATUM, a.PRDHLFNR, a.LFJAHR, a.LFKW, a.LFDATUM, a.PRODGRP, a.PVPEH, a.VPEH, a.ORDERNR, a.ROOTFORM, a.FIRMNR, a.HALTBBIS, a.HATDATUM, a.HALTBTAGE,a.DAUERTAGE,d.HINWEIS, b.SORTE, d.WARENGRP,a.AUSMENGANZ,a.ABTEILUNG, a.PRODGRP, a.TEXT, a.PLANDATUM, a.SEEDBUFFER, d.MENGE_MEH, d.MENGE_GEH, d.GEWICHT_EH, d.MENGEN_EH, d.GRUND_EH, d.WEB_VK_EH_CC, d.WEB_VK_EH_BOX, d.PLC, e.COVMAT, e.COVQUANT, e.WATERTYPE, e.SPRINKLERSET, d.KEIMZEIT, d.KEIMTEMP, d.KORNANZAHL, d.MULDENTIEFE, d.KEIMZUSATZ, d.LEVELCODE, d.ROOTPOWCODE, a.EXTERN_INFO1, a.EXTERN_INFO2, a.EXTERN_INFO3, a.EXTERN_INFO4, a.TEXT2

REP_PRODEINTRAEGE_ORDER a.GATGRP, a.ARTNR, b.ARTKBZ, a.FORM, a.AUSGFORM, a.PRJAHR, a.PRKW, a.PRDATUM, a.PRDHLFNR, a.LFJAHR, a.LFKW, a.LFDATUM, a.PRODGRP, a.PVPEH, a.VPEH, a.ORDERNR, a.ROOTFORM, a.FIRMNR, a.HALTBBIS, a.HATDATUM, a.HALTBTAGE,a.DAUERTAGE,c.MAGRP, d.HINWEIS, b.SORTE, d.WARENGRP,a.AUSMENGANZ,a.ABTEILUNG, a.PRODGRP, a.TEXT, a.PLANDATUM, a.SEEDBUFFER, d.MENGE_MEH, d.MENGE_GEH, d.GEWICHT_EH, d.MENGEN_EH, d.GRUND_EH, d.WEB_VK_EH_CC, d.WEB_VK_EH_BOX, d.PLC, e.COVMAT, e.COVQUANT, e.WATERTYPE, e.SPRINKLERSET, d.KEIMZEIT, d.KEIMTEMP, d.KORNANZAHL, d.MULDENTIEFE, d.KEIMZUSATZ, d.LEVELCODE, d.ROOTPOWCODE, a.EXTERN_INFO1, a.EXTERN_INFO2, a.EXTERN_INFO3, a.EXTERN_INFO4, a.TEXT2

REP_PRODRES_ORDER a.GATGRP, a.ARTNR, b.ARTKBZ, a.FORM, a.AUSGFORM, a.PRJAHR, a.PRKW, a.PRDATUM, a.PRDHLFNR, a.LFJAHR, a.LFKW, a.LFDATUM, a.PRODGRP, a.PVPEH, a.VPEH, a.ORDERNR, a.ROOTFORM, a.FIRMNR, a.HALTBBIS, a.HATDATUM, a.HALTBTAGE, a.DAUERTAGE,c.MAGRP, d.HINWEIS, a.CHARGENNR, b.SORTE, d.WARENGRP,a.AUSMENGANZ,a.ABTEILUNG, a.PLANTIMEST, a.PRODGRP, a.TEXT, a.AKTKEIMUNG, a.PLANDATUM, a.SEEDBUFFER, d.MENGE_MEH, d.MENGE_GEH, d.GEWICHT_EH, d.MENGEN_EH, d.GRUND_EH, d.WEB_VK_EH_CC, d.WEB_VK_EH_BOX, d.PLC, e.COVMAT, e.COVQUANT, e.WATERTYPE, e.SPRINKLERSET, d.KEIMZEIT, d.KEIMTEMP, d.KORNANZAHL, d.MULDENTIEFE, d.KEIMZUSATZ, d.LEVELCODE, d.ROOTPOWCODE, a.EXTERN_INFO1, a.EXTERN_INFO2, a.EXTERN_INFO3, a.EXTERN_INFO4, a.TEXT2

24 Report Variables: Customer Master (KUNDENSTAMM.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

24.1 Report Variables: Customer Master (KUNDENSTAMM.QRP)

24.1.1 customer master (KUNDENSTAMM.QRP)

24.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`siKNDINFOTYP`	String	B\_KNDSTAMM.KNDINFOTYP
`siKNDINFOSUBTYP`	String	B\_KNDSTAMM.KNDINFOSUBTYP
`siEK_VERHALTEN_QUAL`	String	B\_KNDSTAMM.EK\_VERHALTEN\_QUAL
`siEK_VERHALTEN_PREIS`	String	B\_KNDSTAMM.EK\_VERHALTEN\_PREIS
`siEK_VERHALTEN_LASTM`	String	B\_KNDSTAMM.EK\_VERHALTEN\_LASTM
`niFLAECHEHAUS`	Number	B\_KNDSTAMM.FLAECHEHAUS
`niFLAECHEFREILAND`	Number	B\_KNDSTAMM.FLAECHEFREILAND
`niABSWEGVERST`	Number	B\_KNDSTAMM.ABSWEGVERST
`niABSWEGGRABN`	Number	B\_KNDSTAMM.ABSWEGGRABN
`niABSWEGGRMARKT`	Number	B\_KNDSTAMM.ABSWEGGRMARKT
`niABSWEGVERSAND`	Number	B\_KNDSTAMM.ABSWEGVERSAND
`niABSWEGENDVERK`	Number	B\_KNDSTAMM.ABSWEGENDVERK
`siUMSATZPOT`	String	B\_KNDSTAMM.UMSATZPOT
`niUMSATZIST`	Number	B\_KNDSTAMM.UMSATZIST
`siUIDNR`	STRING	B\_KNDSTAMM.UIDNR
`siARANR`	String	B\_KNDSTAMM.ARANR
`niKREDITLIMIT`	Number	B\_KNDFIRMA.KREDITLIMIT
`siFL_MWST`	String	B\_KNDFIRMA.FL\_MWST
`siKNDLAD_NAME`	String	B\_KNDLAD.NAME
`siKNDLAD_KNDNR`	String	B\_KNDLAD.KNDNR
`siKNDLAD_KNDLAD`	String	B\_KNDLAD.KNDLAD
`siKNDLAD_ANREDE`	String	B\_KNDLAD.ANREDE
`siKNDLAD_NAME2`	String	B\_KNDLAD.NAME2
`siKNDLAD_LAND`	String	B\_KNDLAD.LAND
`siKNDLAD_NAME3`	String	B\_KNDLAD.NAME3
`siKNDLAD_TELEFON`	String	B\_KNDLAD.TELEFON
`siKNDLAD_ZH`	String	B\_KNDLAD.ZH
`siKNDLAD_PLZ`	String	B\_KNDLAD.PLZ
`siKNDLAD_FAX`	String	B\_KNDLAD.FAX
`siKNDLAD_STRASSE`	String	B\_KNDLAD.STRASSE
`siKNDLAD_ORTSTEIL`	String	B\_KNDLAD.ORTSTEIL
`siKNDLAD_ORT`	String	B\_KNDLAD.ORT
`siKNDLAD_POSTFACH`	String	B\_KNDLAD.POSTFACH
`siKNDLAD_HANDY`	String	B\_KNDLAD.HANDY
`siKNDLAD_BUNDESSTAAT`	String	B\_KNDLAD.BUNDESSTAAT
`siKNDLAD_PLZ_PFACH`	String	B\_KNDLAD.PLZ\_PFACH
`siKNDLAD_GEOX`	String	B\_KNDLAD.GEOX
`siKNDLAD_GEOY`	String	B\_KNDLAD.GEOY
`siKNDLAD_EMAIL`	String	B\_KNDLAD.EMAIL
`siANSPRECH_NAME`	String	B\_ANSPRECH.NAME
`siANSPRECH_KNDNR`	String	B\_ANSPRECH.KNDNR
`siANSPRECH_VORNAME`	String	B\_ANSPRECH.VORNAME
`siANSPRECH_TITEL`	String	B\_ANSPRECH.TITEL
`siANSPRECH_ABTEILUNG`	String	B\_ANSPRECH.ABTEILUNG
`siANSPRECH_TELEFON`	String	B\_ANSPRECH.TELEFON
`siANSPRECH_FAX`	String	B\_ANSPRECH.FAX
`siANSPRECH_HANDY`	String	B\_ANSPRECH.HANDY
`siANSPRECH_EMAIL`	String	B\_ANSPRECH.EMAIL

24.1.1.2 Formulas

Kundentyp anzeigen: if Kundentyp 1(Produzent), zeige Subtyp an(pot. customer, Neukunde, Stammkunde), otherwise the anderen vordefinierten.

StrIFF(StrCompare(siKNDINFOTYP,'1'),'test',StrTranslate( siKNDINFOSUBTYP , '1,2,3', 'potentieller Kunde,Neukunde,Stammkunde' ),StrTranslate( siKNDINFOTYP , '1,2,3,4,5,6,7' , 'Produzent,Mitbewerber, Außendienst/Agentur,Handel,Presse,Öffentliche Einrichtung,Sonstiges'))

25 Report Variables: Advance Notice (AVIS.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

25.1 Report Variables: Advance Notice (AVIS.QRP)

25.1.1 AVISIERUNG (AVIS.QRP)

25.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`AUFTRNR`
`sFIRMNR`
`AUFTRDAT`
`KBESTNR`
`ZAHLART`
`FRACHTZ`
`VERSART`
`TOURNR`
`STAFFMENGE`
`VERTRNR`
`KNDNR`
`sKNDKBZ`
`RKNDNR`
`LNAME1`
`LNAME2`
`LLAND`
`LPLZ`
`LORT`
`LSTRASSE`
`sLFINFO`
`sLANREDE`
`sLZH`
`sKOPFTEXT`
`sKOMMISSION1`
`sKOMMISSION`
`GATGRP`
`FORM`
`PRDHLFNR`
`ARTNR`
`ARTKBZ`
`nMENGE`
`STDVKPREIS`
`STDWAEHR`
`PMENGE`
`PEH`
`FIRVKPREIS`
`FIRWAEHR`
`STDVKSUM`
`nMWST`
`LIZPREIS`
`LIZPROSTK`
`nRABATT`
`nZUSCHLAG`
`KARTNR`
`KARTKBZ`
`LFKW`
`LFJAHR`
`LFDATUM`
`FRACHTPREIS`
`nVPEH`
`TEXT`
`FIRZUSCHL`
`MCODE`
`sANREDE`
`sZH`
`sNAME1`
`sNAME2`
`sPLZ`
`sORT`
`sLAND`
`sSTRASSE`
`sKNDFAX`
`sTELEFON`
`sLANDPOSTORT`
`LPO`
`sPOSTFACH`
`ORTSTEIL`
`TOURBEZ`
`ZAHLARTBEZ`
`VERTBEZ`
`VERTNAME1`
`VERTNAME2`
`VERTFAX`
`VERTTEL`
`PRODHMITTELBEZ`
`SORTE`
`GATGRPBEZ`
`LANDBEZ`
`niRABATT2`
`siABTEILUNG`
`siARTPREISGRP`
`siFL_NEUART`
`siFL_LEIHART`
`siFL_ERSATZ`
`siFL_NEUART`
`siFL_GRATIS`
`siFL_PRAESKART`
`niGEW_PRDHLF`
`niVOLUMEN`
`niGEWICHT`
`siGEWICHT_EH_KEY`
`siGEWICHT_EH`
`siEINHEIT_KEY`
`siEINHEIT`
`niMENGENFAKTOR`
`siAVISTEXT`
`siALTERNAME`	String	Botanical name of the article
`sKNDMAIL`	String	E-mail address of the customer
`siKNDGRP`	String	Customer group of the delivery customer
`diEST_DELIVERY_DATE`	Date	from B\_SHIPMENT\_TRACKING
`siTRACKING_NUMBER`	String	from B\_SHIPMENT\_TRACKING
`niTOURPOS`	Number	B\_AUFTRCOL.TOURPOS
`siEST_DELIVERY_TIME`	String	from B\_SHIPMENT\_TRACKING
`siFL_PRIVAT2`	String	from B\_AUFTRCOL - but then the text is fetched from TEXTBAUSTEIN
`siPRODUCT_TYPE`	String	from B\_ARTIKEL
`siARTICLE_COLOR`	String	from B\_ARTIKEL
`siSPRACHE`	String	Language of the reports from the customer master or the country
`siAVISTYP`	String	advance notice type (print type) from the customer-company master

25.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svTOURINFO`
`svTOURSERVICE`
`svTOURLADEHILFSMITTEL`
`svTOURABHOLTAG`
`svTOURANLIEFERTAG`
`dvTOURABHOLZEIT`
`dvTOURANLIEFERZEIT`
`dvTOURANLIEFERDATUM`	Date	Delivery date from the tour
`svAVISTEXTALLG`
`svAVISTEXT1`
`svAVISTEXT2`
`svAVISTEXT3`
`ZeigePostfach`
`ZeigeStrasse`
`KNDUIDNR`
`svPREFAX`
`svPOSTFAX`
`VARFAXKNDSTRING`
`svFAXNUMMER`
`svFAXNUMMER`
`sLORTSTEIL`
`svVERTHANDY`
`sVARIANTEBEZ`
`sRLANDBEZ`
`sKNDHANDY`
`nvBETRAG_MINDERMENGE`
`sVERPACK`
`nVERPACKPREIS`
`nLIZMWST`
`nVERPACKMWST`
`nFRACHTMWST`
`nMINMEZSWERT`
`nZUSCHLAGPREISMENGE`
`sVERPACKBEZ`
`nFRACHTPAUSCHALE`
`nBETRAG_VERPACK`
`nBETRAG_FRACHT`
`nBETRAG_LIZENZ`
`nSUM_VERPACK`
`nSUM_FRACHT`
`nSUM_LIZENZ`
`sAUFTRAGBEAANG`
`sARTEINGANG`
`sAUFTRAGBEAAEN`
`svBARCODE`
`svKND_BARCODE`
`sRKNDKBZ`
`sRANREDE`
`sRNAME1`
`sRNAME2`
`sRSTRASSE`
`sRLAND`
`sRPLZ`
`sRORT`
`sRORTSTEIL`
`sRZH`
`sRPOSTFACH`
`sRLANDBEZ`
`sDEPOTNR`
`sDKNDKBZ`
`sDANREDE`
`sDNAME1`
`sDNAME2`
`sDSTRASSE`
`sDLAND`
`sDPLZ`
`sDORT`
`sDORTSTEIL`
`sDZH`
`sDPOSTFACH`
`sSACH_KBEZ`
`sSACH_NAME1`
`sSACH_NAME2`
`sSACH_TELEFON`
`sSACH_HANDY`
`sSACH_EMAIL`
`nvAF_MINDERWERT`
`nvAF_MINDERWERT_LIMIT`
`svABTEILUNG`
`svLNAME3`
`svFL_MINDERWERTOK`
`dvDRUCKDATUM`
`svFL_AB`
`svFL_AB_GEDRUCKT`
`svFL_FIXTERMIN`
`svAVISIEREN`
`svFL_AVISIERT`
`dvVALUTADATUM`
`nvVALUTATAGE`
`nvANZLEITKARTEN`
`nvPRKW`
`dvPRDATUM`
`sAVISKOPF1`	String	Kopftext1 advance notice
`sAVISKOPF2`	String	Kopftext2 advance notice
`sFL_BIO`	String
`svTRANSPORTMITTEL`	String
`svRKNDNAME1`	String	Invoice customer name 1
`svRKNDSTRASSE`	String	Invoice customer street
`svRKNDPLZ`	String	Invoice customer postal code
`svRKNDORT`	String	Invoice customer city
`svRKNDBUNDESSTAAT`	String	Invoice customer federal state
`svRKNDBUNDESSTAATKURZ`	String	Invoice customer federal state code
`svRKNDLAND`	String	Invoice customer country
`svRKNDLANDKURZ`	String	Invoice customer country code
`svLadEMAIL`	String	E-mail of the delivery address
`svLadUIDNR`	String	VAT ID of the delivery address
`sKndladBUNDESSTAAT_LANG`	String	Federal state (long) of the delivery address
`svKNDEMAIL_AUTODOC`	String	E-mail address of the customer where all # were replaced by ;, independent of Blat or not
`svKNDLADEMAIL_AUTODOC`	String	E-mail address of Kndlad where all # were replaced by ;, independent of Blat or not
`svKUNDE_ARANR`	String	Aranr from the customer master of the delivery customer
`svAUFTRAGSNUMMERN`	String	all Order numbers (only on Report advance notice gruppiert per customer)

25.1.1.3 Variables

svUSER, AVISTITEL, AVISINFO, AVISNR, AVISDATUM, AVISFUSS1, AVISFUSS2, AVISFUSS3, AVISFUSS4, AVISKOPF1, AVISKOPF2, dvTOURVERSANDTAG, nvCC_COUNT, nvSHELF_COUNT, nvEXTENTION_COUNT, nvBOX_COUNT

26 Report Variables: Run Card / Pallet Slip (LAUFKARTE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

26.1 Report Variables: Run Card / Pallet Slip (LAUFKARTE.QRP)

26.1.1 Laufkarte / Palletbon (LAUFKARTE.QRP)

26.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`siLAUFKARTENNR`
`siPLANTIMEST`
`siFIRMNR`
`siAUFTRTIMEST`
`siFL_ART`
`siGATGRP`
`siARTNR`
`siFORM`
`siARTKBZ`
`niLFKW`
`niLFJAHR`
`niPRDMENGE`
`siPRDHLFNR`
`niPRKW`
`niPRJAHR`
`diLFDATUM`
`niMENGE`
`siAUSGFORM`
`niAUSMENGE`
`diPRDATUM`
`niHALTBBIS`
`diHATDATUM`
`siLIEFNR`
`siFL_BESTELLT`
`siLFMEEH`
`siPRMEEH`
`niDAUERTAGE`
`siANGELEGT`
`siGEAENDERT`
`siBEAANG`
`siBEAAEN`
`siGMTTIMEST`
`siBESTTIMEST`
`siPRODGRP`
`siMAGRP`
`niPVPEH`
`siCHARGENNR`
`siORDERNR`
`siKNDGRP`
`siKNDNR`
`siIDENTNR`
`siTEXT`
`siSTANDORT`
`siKENNUNG`
`niVPEH`
`siAUSPRDHLFNR`
`niPRKWBIS`
`diPRBISDATUM`
`niAUSFALL`
`niHALTBTAGE`
`niAUSMENGANZ`
`siVATERTIMEST`
`siSOHNTIMEST`
`siROOTFORM`
`siFL_PRODOK`
`niAUSHALTBTAGE`
`siBESTFORM`
`niLFTAG`
`niPRTAG`
`niMENGE_MEH`
`niMENGE_GEH`
`siGEWICHT_EH`
`siMENGEN_EH`
`niSTKMENGE`
`niAUSSTKMENGE`
`siQUALITAETKENNZ`
`siFL_ABFUELLUNG`
`siBEIZUNG`
`niMENGENFAKTOR`
`niEKPREIS`
`niPMENGE`
`siBUCHUNGSTYP`
`niGEWICHT`
`siGEH`
`siABTEILUNG`
`siFL_EXTERN`
`niKEIMLIEF`
`niKEIMINT1`
`niKEIMINT2`
`niKEIMINT3`
`siFL_SPERR`
`siPOOL`
`niERSTMENGE`
`niLETZTEINVMENGE`
`siFL_AUSGB`
`siAUSCHARGENNR`
`siSTUECKLISTE_TYP`
`niPPFLANZ`
`diPRODDATUM`
`niAKTKEIMUNG`
`siFL_HAND`
`siARTKBZ`
`siPRODSTANDORT`		Location from B\_PRODCHARGE
`niCELL_OUT_WEEK`		B\_PRODPLAN.PRODDATUM + NVL(B\_ARTEIGEN.KEIMZEIT,B\_ARTFORM.KEIMZEIT)/24

26.1.1.2 Variables

<thead></thead>

Name	Type	Content

27 Report Variables: Freight Row (FRACHTREIHE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

27.1 Report Variables: Freight Row (FRACHTREIHE.QRP)

27.1.1 Frachtreihe (FRACHTREIHE.QRP) RITTENLIJST

New variables:

• svAVISTEXT allgemeiner Text from the Avisierungsmaske

27.1.1.1 Input Items

sFIRMNR, sTYP, sSTATUS, sAUFTRNR, sKNDNR, sKNDKBZ, sKNDLAD, dDATUM, sTEXT1, sTEXT2, sTEXT3, sCODE, sKNDEMAIL, sKNDFAX, sKNDPLZ, sAVISTEXT, sTOURID, sGATGRP, sFORM, nMENGE, nTRAYANZAHL, sNAME, sNAME2, sNAME3, sLAND, sTELEFON, sPLZ, sFAX, sSTRASSE, sORT, sHANDY, sANREDE, sZH, sPOSTFACH, sORTSTEIL, sBUNDESSTAAT, sPLZ_PFACH, sVERSART, sVERSARTBEZ, dLIEFDAT, sSTOUR_STATUS, sINFO, sFL_WICHTIG, sSLNR, dVERSANDTAG, sSERVICE, sLADEHILFSMITTEL, sABHOLTAG, sANLIEFERTAG, dABHOLZEIT, dANLIEFERZEIT, sFIRSTFETCH, sTRANSMITTEL_BEZ, sLIEFER_LANDBEZ

27.1.2 Input variables

• svFRACHTBEZ Freight zone description ( order )

28 Report Variables: Outgoing Invoice Book (AUS_BUCH.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

28.1 Report Variables: Outgoing Invoice Book (AUS_BUCH.qrp)

28.1.1 AUS_BUCH.qrp

Report from the accounting transfer:

Aufruf: dlgRepAUSGANGSBUCH

28.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`sKNDNR`	String	Customer number
`sKNDKBZ`	String	Customer short name
`sRKNDNR`
`sRKNDKBZ`
`sRECHART`
`sRECHNR`
`dtRECHDATUM`
`nNETTO`
`nMWSTSATZ`
`nMWSTBETRAG`
`nMWSTBETRAG_KONZ`
`nBRUTTO`
`nNETTO_KONZ`
`nBRUTTO_KONZ`
`sWAEHR`
`sWAEHRUNG_KONZ`
`nFRACHTPAUSCHALE`
`sEDI_FILENAME`
`siVERSART`
`niSKONTO`
`niSKONTO_KONZ`
`niKASSENSKONTO`

28.1.1.2 Variables

sSUMMEN, svSUCHKRITERIUM, sRECHSTATUS, sFL_BEZAHLT, sFL_PROVISIONIERT, sEDISTATUS, sFL_SKONTO, nSKPROZ, sANREDE, sNAME1, sNAME2, sSTRASSE, sLAND, sPLZ, sORT, sZH, sPOSTFACH, sORTSTEIL, sTELEFON, sHANDY, sFAX, sEMAIL, sUIDNR, sBANK, sBANKLEITZ, sBANKKONTO

29 Report Variables: Production Bill of Materials (PROD_STKL.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

29.1 Report Variables: Production Bill of Materials (PROD_STKL.QRP)

Sorting for report PROD_STKL.QRP:

String: scREP_ABSTKL_ORDER = 'ABSTKL_ORDER'

Input Items:

AUFTRNR, sFIRMNR, AUFTRDAT, KBESTNR, ZAHLART, FRACHTZ, VERSART, TOURNR, STAFFMENGE, VERTRNR, KNDNR, sKNDKBZ, RKNDNR, LNAME1, LNAME2, LLAND, LPLZ, LORT, LSTRASSE, sLFINFO, sLANREDE, sLZH, sKOPFTEXT, sKOMMISSION1, sKOMMISSION, GATGRP, FORM, PRDHLFNR, ARTNR, ARTKBZ, nMENGE, STDVKPREIS, STDWAEHR, PMENGE, PEH, FIRVKPREIS, FIRWAEHR, STDVKSUM, nMWST, LIZPREIS, LIZPROSTK, nRABATT, nZUSCHLAG, KARTNR, KARTKBZ, LFKW, LFJAHR, LFDATUM, FRACHTPREIS, nVPEH, TEXT, FIRZUSCHL, MCODE, sANREDE, sZH, sNAME1, sNAME2, sPLZ, sORT, sLAND, sSTRASSE, sKNDFAX, sTELEFON, sLANDPOSTORT, LPO, sPOSTFACH, ORTSTEIL, TOURBEZ, ZAHLARTBEZ, VERTBEZ, VERTNAME1, VERTNAME2, VERTFAX, VERTTEL, PRODHMITTELBEZ, SORTE, GATGRPBEZ, LANDBEZ, niRABATT2, siABTEILUNG, siARTPREISGRP, siFL_NEUART, siFL_LEIHART, siFL_ERSATZ, siFL_NEUART, siFL_GRATIS, siFL_PRAESKART, niGEW_PRDHLF, niVOLUMEN, niGEWICHT, siGEWICHT_EH_KEY, siGEWICHT_EH, siEINHEIT_KEY, siEINHEIT, niMENGENFAKTOR, siVERSARTBEZ, siARTIKELFAMILIE, siBE_STATUS, siKNDLANDBEZ, LNAME3, sNAME3, siLPOSTFACH, siAUFTRTIMEST

Data from B_AFC_STKL

siAFC_TIMEST, siAFC_FIRMNR, siAFC_AUFTRNR, siAFC_STATUS, siAFC_KNDNR, siAFC_FL_ART, siAFC_GATGRP, siAFC_ARTKBZ, niAFC_MENGE, niAFC_STDVKPREIS, siAFC_STDWAEHR, niAFC_FIRVKPREIS, siAFC_ARTNR, siAFC_FIRWAEHR, niAFC_GNDMENGE, niAFC_STDVKSUM, niAFC_FIRVKSUM, siAFC_PRDHLFNR, niAFC_PMENGE, siAFC_PEH, siAFC_FORM, siAFC_AUSFORM, niAFC_LFKW, niAFC_MWST, niAFC_AUSMENGE, niAFC_LFJAHR, diAFC_WTERMIN, niAFC_AUSMENGANZ, siAFC_PRODGRP, siAFC_AUSPRDHLFNR, siAFC_LIEFNR, diAFC_LFDATUM, niAFC_PRKW, niAFC_PRJAHR, diAFC_PRDATUM, siAFC_HALTBGRP, niAFC_HALTBTAGE, niAFC_HALTBKW, niAFC_FRACHTPREIS, siAFC_VERPACK, niAFC_VERPACKPREIS, niAFC_VPEH, niAFC_FIRFRACHTPREIS, niAFC_VPELAGE, niAFC_LAGEWAG, niAFC_KARTPAL, niAFC_FIRVERPACKPREIS, niAFC_VPEKART, niAFC_PFLANZ, niAFC_DAUERKW, niAFC_DAUERTAGE, siAFC_ANGELEGT, siAFC_BEAANG, siAFC_BEAAEN, siAFC_GEAENDERT, siAFC_FL_GPREIS, siAFC_LFSTAT, niAFC_LFPOS, siAFC_FL_PRBUCHEN, siAFC_GEBART, niAFC_TOURPOS, siAFC_LFMEEH, siAFC_PRMEEH, niAFC_PVPEH, siAFC_ORDERNR, siAFC_CHARGENNR, niAFC_GNDPREIS, siAFC_MCODE, liAFC_LONGTEXT, siAFC_FL_GEANDERT, siAFC_FL_ZUKAUF, niAFC_AUSFALL, siAFC_MAGRP, niAFC_GEWICHT, niAFC_TOPFGR, niAFC_HOEHE, siAFC_STANDORT, siAFC_BESTTIMEST, niAFC_LFTAG, niAFC_PRTAG, niAFC_REIHE, siAFC_BESTUPKENN, siAFC_POSTF1, siAFC_POSTF2, siAFC_POSTF3, siAFC_POSTF4, siAFC_NSUMGEWEH, niAFC_STKMENGE, niAFC_AUSSTKMENGE, niAFC_VPANZ, niAFC_SUMGEWPRDHLF, niAFC_SUMVOLUMEN, siAFC_ABTEILUNG, siAFC_BAUSTEINNR, siAFC_VERSANDABT, siAFC_FL_PRIVAT1, siAFC_FL_HANDVPEH, siAFC_FL_PRIVAT2, niAFC_MENGENFAKTOR, niAFC_EKPREIS, niAFC_EKPMENGE, siAFC_POOL, siAFC_FL_HANDEKPREIS, siAFC_PACKGRP, niAFC_ANZGEB, siAFC_BE_STATUS, siAFC_FL_HANDKW, siAFC_STUECKLISTE_TYP, niAFC_STARTPRKW, diAFC_STARTPRDATUM, siAFC_PRODTEXT, siAFC_AUFTRTIMEST, siAFC_FREMDEH, siAFC_STATUSART

Input variables:

svPAGEBREAK (set to empty on the first fetch and then always to '+', so a page can be made per article)

svVARIANTE, svAUSGANGSVARIANTE, svCHARGENNR, STKL.QRP

30 Report Variables: Label Loading List (ETIKETTENMENGE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

30.1 Report Variables: Label Loading List (ETIKETTENMENGE.QRP)

Label loading list (Etikettenladeliste) report; report name ETIKETTENMENGE.QRP

General information: see the page on the label loading list.

• Input items:

FIRMNR, TOURNR, TOURID, LFJAHR, LFKW, LFDATUM, sGATGRP, FORM, ARTNR, ARTKBZ, SORTE, nMENGE, PRDHLFNR, sKOMMISSION, BEZ, TOURBEZ, KNDNR, KNDKBZ, LNAME1, LPLZ, LORT, LSTRASSE, LLAND, TEL_LANDCODE, TEL_VORWAHL, TELEFON, VERTRNR, nVPEH, VERPACKMENGE, GESVERPACKMENGE, KNDVERPACKMENGE, LIEFERDAT, TRANSMITTEL, KW1, AUFTRDAT, AUFTR_INFO, TEXT, GATGRPBEZ, MCODE, sORDERNR, nVE, nKNDVE, nGESVE, sKOPFTEXT, sLFINFO, sLADLISTINFO, niETMENGE, niANZLEITKARTEN, siBILDNAME, siLAGERNR, niETVPEH

• siAUFTRNR (for break for summing per order) siKBESTNR, siKNDLAD, KNDLADVERPACKMENGE, nKNDLADVE
• siAUFTRAG (order no. for standard summing or per consignment. Attention: this is not meant for a break, because there is actually no summing per order. It always contains only one order no., even if there were several, for example several orders of the same customer)
• Input variables:

sLNAME2, sDEPOTNR, sDKNDKBZ, sDANREDE, sDNAME1, sDNAME2, sDSTRASSE, sDLAND, sDPLZ, sDORT, sDZH, sDPOSTFACH, sTOURINFO, VARKOMMISSION, bPAGEBREAKKUNDE, bPAGEBREAKAUFTRAG, bBREAKGROUPKUNDE, bBREAKGROUPAUFTRAG, bPAGEBREAKKNDLAD, bBREAKGROUPKNDLAD

31 Report Variables: Goods Receipt (ANLIEFERUNG.qrp)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

31.1 Report Variables: Goods Receipt (ANLIEFERUNG.qrp)

31.1.1 goods receipt (ANLIEFERUNG.qrp)

31.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`sBESTNR`	String	Order no.
`sIDENTNR`	String	Reference number batch
`siKNDNR_LIEFERANT`	String	Customer number at the supplier (B\_LIEFERANT)

31.1.1.2 Input Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svLARTNR`	String	(HE, 23.10.2012, Ticket ID: 4316)
`svLARTKBZ`	String	(HE, 23.10.2012, Ticket ID: 4316)
`sQUALITAETKENNZ`	String	Quality mark
`sQUALITAETKENNZ_TEXT`	String	-

/

© 2013 Concept Data Systems - KR

32 Report Variables: Activity Reports

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

32.1 Report Variables: Activity Reports

32.1.1 Input items

Not all items are available on all reports!

siProductGroupBez (product group description) not Total_Sowing and Total_Sticking

sPrdhlfnr (not Total_Sowing and Total_Sticking)

sPrdhlfnrBez (not Total_Sowing and Total_Sticking)

sFlagProduziert (not Total_Sowing and Total_Sticking)

siVARIANTENBEZ (product form description)

siProductGroup (product group)

<thead></thead><tbody></tbody>

Name	Type	Content
`dTaetigkeitsdatum`	Date	Activity date / Activity Date
`sTaetigkeitscode`	String	Activity description / Activity Description
`sChargennummer`	String	Batch number / Batch Number
`nMenge`	Number	Quantity / Amount
`nTraymenge`	Number	Tray quantity / Amount of trays
`sStatus`	String	Status / Status
`sStandort`	String	Location / Product location
`sArtikelbezeichnung`	String	Article description / Variety name
`sFirmennummer`	String	Company number / company number
`sTaetigkeitsartikelnummer`	String	Activity number / Activity number
`sMovingStandort`	String	Move To Location / Move To Location
`nProduktionswoche`	Number	Production week / Production week
`sVerpackungseinheit`	String	Packing unit / Packing unit
`nPVerpackungseinheit`	Number	P Packing unit / PPacking unit
`sArtikelnummer`	String	Article number / Variety number
`dLieferdatum`	Date	Delivery date / Delivery date (B\_TAET\_CHARGE)
`dPrDatum`	Date	Production date / Production date (B\_TAET\_CHARGE)
`nWorkshift`	Number	Workshift
`nLieferwoche`	Number	Delivery week / Delivery Week
`sMagrp`	String	Machine group / machine group
`sFlagStackable`	String	Flag stackable / Flag Stackable
`sGattungsgruppe`	String	Article group / Product group
`nLieferwoche`	Number	Delivery week / Delivery Week
`sForm`	String	Product form / Product Form
`sProdChargeStandort`	String	Location / product location (B\_PROD\_CHARGE)
`siVariety`	String	Variety
`sPalletbonList`	String	List of Palletbon Numbers ( only available on Moving List )
`dGermOutTime`	Date/Time	Germination Out Time
`sAusgform`	String	Basic product form / Basic product form
`sFL_BLOWOUT`	String	Flag gapping up
`nAUSFALL`	Number	Loss from B\_PRODPLAN
`nKEIMZAHL`	Number	Most recent germination figure from B\_KEIMQUOTEN
`sTEXT`	String	B\_PRODPLAN.TEXT
`sGattungsgruppeBez`	String	Article group long description
`nTaetigkeitswoche`	Number	B\_TAET\_CHARGE.TAETIGKEIT\_KW

32.1.2 Input variables

Not all variables are available on all reports!

dProdDatum

<thead></thead><tbody></tbody>

Name	Type	Content
`sFirmenname`	String	Company name / company number
`sNextTaetigkeitscode`	String	Next activity code / Next Activity
`dNextTaetigkeitsdatum`	Date	Next activity date / Next Activity Date
`nTageVonPrDatumBisTaetDatum`	Number	Days from production date to activity date / Days from production date to activity date
`nLead_ProdBatch`	Number	lead time production batch
`nLeadScheduled`	Number	lead time scheduled
`nLead_AfterProduced`	Number	lead time after produced
`nLead_Difference`	Number	lead time difference between scheduled and produced
`dMinNextTaetigkeitsdatum`	Date	min. next activity date
`dMaxNextTaetigkeitsdatum`	Date	max. next activity date

32.1.4 Counting List

COUNTINGLISTTITEL, COUNTINGDATE, GAPPINGUPDATE, GAPPINGUPACTIVITY, DAYSPRODDATE, SEEN, NOGAPPINGUP, FREITEXT1, FREITEXT2, FREITEXT3, FREITEXT4

• niProzentKeimungLab - germination percentage (lab) - B_PRODPLAN
• niProzentKeimungLief - germination percentage (supplier) - B_PRODPLAN
• niZulassungsnummer - approval number - B_ARTFORM
• siSaison - season - B_ARTFORM

32.1.5 Moving List

MOVINGLISTTITEL, ACTIVITYDATE, ACTIVITY, NEXTACTIVITY, MOVETOLOCATION, BLOCK, FREITEXT5

32.1.6 Quality Check List

QUALITYCHECKLISTTITEL, ACTIVITYBEZ, NEXTACTIVITYBEZ, NEXTACTIVITYDATE, NEXTNEXTACTIVITY, MAINLOCATION, FREITEXT6

32.1.7 Quality Check List Transport

QCHECKTRANSPORTLISTTITEL, TOTALLEADBATCH, TOTALLEADSCHEDULED, TOTALLEADPRODUCED, TOTALLEADDIFFERENCE, ORIGINURC, FREITEXT7, FREITEXT8, FREITEXT9

32.1.8 Total Sowing

TOTALTRAYS, SUMMELISTTITEL, TOTALHOURS, nvTraysSunday, nvTraysMonday, nvTraysTuesday, nvTraysWednesday, nvTraysThursday, nvTraysFriday, nvTraysSaturday, nvHoursSunday, nvHourssMonday, nvHoursTuesday, nvHoursWednesday, nvHoursThursday, nvHoursFriday, nvHoursSaturday

32.1.9 Total Sticking

nvPlantsSunday, nvPlantsMonday, nvPlantsTuesday, nvPlantsWednesday, nvPlantsThursday, nvPlantsFriday, nvPlantsSaturday, nvTraysSunday, nvTraysMonday, nvTraysTuesday, nvTraysWednesday, nvTraysThursday, nvTraysFriday, nvTraysSaturday

32.1.10 Existing Report Text Variables

LIEFERWOCHE, TRAYMENGE, PRDGRP

• NA7 - Monday
• NA8 - Tuesday
• NA9 - Wednesday
• NA10 - Thursday
• NA11 - Friday
• NA12 - Saturday
• NA13 - Sunday
• NA14 - hours
• NA15 - Trays

32.1.11 Sorting

REP_AL_MOVING_ORDER, REP_AL_COUNTING_ORDER, REP_AL_QUALITY_CHECK_ORDER, REP_AL_QUALITY_CHECK_TRANSPORT_ORDER, REP_AL_SOWING_ORDER, REP_AL_STICKING_ORDER, REP_AL_TOTAL_STICKING_ORDER, REP_AL_SHIPPING_ORDER

33 Report Variables: Sum of Traced Trays per Main Location

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

33.1 Report Variables: Sum of Traced Trays per Main Location

33.1.1 sum traced trays / main location

Report name: SUM_MAIN_LOCATION.QRP

33.1.2 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`sSTANDORT`	String	Main location
`nTRACEDTRAYS`	Number	The traced trays per location

34 Report Variables: Uproot (UPROOT_FINAL.QRP, UPROOT_PARTIAL.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

34.1 Report Variables: Uproot (UPROOT_FINAL.QRP, UPROOT_PARTIAL.QRP)

34.1.1 Uproot (UPROOT_FINAL.QRP or UPROOT_PARTIAL.QRP)

The uproot report (Entwurzelung) is shown in the mother plant administration through the Print button and then selecting the report Uproot.

34.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`siARTNR`	String	Article number
`siFORM`	String	Product form
`niSTARTKW`	Number	Start week
`siCHARGENNR`	String	Batch no.
`niKW`	Number	Week
`siHAUS`	String	House
`siSEKTOR`	String	Sector
`siBEET`	String	Bed
`niMENGE`	Number	For partial: difference of quantity of week and quantity of week-1; for final: quantity of the week
`diUPROOT_DATE`	Date	Date that can be entered by the user
`siGATGRP`	String	Article group

35 Report Variables: Driver List (FAHRERLISTE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

35.1 Report Variables: Driver List (FAHRERLISTE.QRP)

35.1.1 Fahrerliste (FAHRERLISTE.QRP)

Setting: company settings -> settings tours -> driver list: do not group by row. B_LAGE.REIHE is left out of the grouping. This results in fewer lines and no duplicate lines per customer. That means the sums of containers, shelves and so on per tour are then calculated per customer and Kndlad.

35.1.1.1 Input Items

If it is a depot customer, customer name, address, phone and mobile phone are taken from the depot customer.

<thead></thead><tbody></tbody>

Name	Type	Content
`nTRAYANZAHL`	Number
`nKW`	Number	Week of B\_TOURID.VERSANDTAG
`sKNDNR`	String
`sNAME1`	String	B\_AUFTRAG.LNAME1
`sSTRASSE`	String	B\_AUFTRAG.LSTRASSE
`sPLZ`	String	B\_AUFTRAG.LPLZ
`sORT`	String	B\_AUFTRAG.LORT
`sLAND`	String	B\_AUFTRAG.LLAND
`sTOURID`	String	B\_TOURID.TOURID
`dVERSANDTAG`	Date	B\_TOURID.VERSANDTAG
`sANLIEFERTAG`	String	B\_TOURID.ANLIEFERTAG
`dANLIEFERZEIT`	Date	B\_TOURID.ANLIEFERZEIT
`sSERVICE`	String	B\_TOURID.SERVICE
`sLADEHILFSMITTEL`	String	B\_TOURID.LADEHILFSMITTEL
`sINFO`	String	B\_TOURID.INFO
`nTOURPOS`	Number	B\_LAGE.TOURPOS
`sTELEFON`	String	B\_KNDLAD.TELEFON if KNDLAD is not empty, otherwise B\_KNDSTAMM.TEL\_LANDCODE + B\_KNDSTAMM.TEL\_VORWAHL + B\_KNDSTAMM.TELEFON
`sHANDY`	String	B\_KNDLAD.HANDY if KNDLAD is not empty, otherwise B\_KNDSTAMM.HANDY
`sGEBART`	String	B\_WAGERL.GEBART
`sKNDLAD`	String	B\_LAGE.KNDLAD
`sNAME2`	String	B\_AUFTRAG.LNAME2
`sTOURNR`	String	B\_AUFTRAG.TOURNR
`sTRANSMBEZ`	String	B\_TRANSMITTEL.BEZ
`nLFKW`	Number	LFKW from B\_AUFTRCOL with the first TOURID found
`nLFJAHR`	Number	LWJAHR from B\_AUFTRCOL with the first TOURID found
`dLFDATUM`	Date	LFDATUM from B\_AUFTRCOL with the first TOURID found

35.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`sROUTINGCODE`	String	B\_LAGE.TOURPOS
`sVAK_CODE`	String	B\_LAGE.REIHE
`sWAGERLNR`	String	B\_LAGE.WAGERLNR concatenated
`sORDERNR`	String	B\_LAGE.AUFTRNR concatenated
`nCCS`	Number	Number of containers per tour and row, or per tour and customer and/or Kndlad depending on setting
`nPALLETS`	Number	Number of containers per tour and row, or per tour and customer and/or Kndlad depending on setting
`nAUFSETZER`	Number	Number of containers with top frame per tour and row, or per tour and customer and/or Kndlad depending on setting. number is multiplied by 4
`nLAGEN`	Number	Number of shelves with B\_LAGE.LAGE > 1 per tour and row, or per tour and customer and/or Kndlad depending on setting. If a cover exists on the container, 1 shelf per container is added.
`nCCSTOUR`	Number	Sum of containers per tour if packaging type is container
`nPALLETSTOUR`	Number	Sum of containers per tour if packaging type is pallet
`nLAGENTOUR`	Number	Sum of shelves per tour + possibly with cover
`nAUFSETZERTOUR`	Number	Sum of containers with top frame per tour
`nTRAYSTOUR`	Number	Total sum of trays per tour
`nAKTKW`	Number	Current week

36 Report Variables: RPL Reports

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

36.1 Report Variables: RPL Reports

36.1.1 Reports

This page refers to the RPL reports (RPL Report, RPL Report Alternative, RPL Wagerl - Tracing Info). They can be reached from tour administration -> container planning.

36.1.2 Input Items

Not all items are available on all reports! Input items: see also the page on the container calculation.

<thead></thead><tbody></tbody>

Name	Type	Content
`sWAGERLNR`	String	Wagerl no. from B\_WAGERL
`sCC_ID`	String	CC\_ID from B\_WAGERL
`sINFO`	String	Info from B\_TOURID
`nLAGE`	Number	B\_LAGE.LAGE
`nPOS`	Number	B\_LAGE.POS
`sARTNR`	String	B\_LAGE.ARTNR
`sPRDHLFNR`	String	B\_LAGE.PRDHLFNR
`sCHARGENNR`	String	B\_LAGE.CHARGENNR
`sSTANDORT`	String	B\_LAGE.STANDORT
`nTOURPOS`	Number	B\_LAGE.TOURPOS
`sSTATUS`	String	B\_LAGE.STATUS
`sAUFTRNR`	String	B\_LAGE.AUFTRNR
`sARTKBZ`	String	B\_ARTIKEL.ARTKBZ
`sMAIN`	String	B\_PRODPLAN.STANDORT
`nLFKW`	Number	B\_PRODPLAN.LFKW
`sTEXT`	String	B\_GATGRP.TEXT
`nTotalTraysAvailable`	Number	Sum of trays per batch no. and location
`nTRAYANZ`	Number	B\_LAGE.TRAYANZ (Sum for RPL Wagerl - Tracing Info)
`sGATGRP`	String	B\_LAGE.GATGRP
`sKNDNR`	String	B\_LAGE.KNDNR
`sKNDKBZ`	String	B\_LAGE.KNDKBZ
`sAF_STATUS`	String	B\_AUFTRCOL.STATUS
`sFORM`	String	B\_LAGE.FORM
`sVERS_TYP`	String	B\_LAGE.VERSTYP (only on RPL Alternative)
`sFL_NODELINE`	String	B\_WAGERL.FL\_NODELINE (only on RPL Alternative)
`nMENGE`	Number	Sum quantity (only on RPL Wagerl - Tracing Info)
`sCOLOR`	String	B\_ARTIKEL.COLOR (only on RPL Wagerl - Tracing Info)
`sCHARGENNR`	String	B\_LAGE.CHARGENNR (only on RPL Wagerl - Tracing Info)
`sSTANDORT_PRODCHARGE`	String	Location from B\_PROD\_CHARGE (only on RPL Wagerl - Tracing Info)
`sTEXT_PRODBEMERKUNG`	String	B\_PROD\_CHARGE.PRODBEMERKUNG\_CODE the text from the text block (only on RPL Wagerl - Tracing Info)

37 Report Variables: MB Scan List (MBSCANLISTE.QRP)

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

37.1 Report Variables: MB Scan List (MBSCANLISTE.QRP)

37.1.1 MB-Scan List (MBSCANLISTE.QRP)

37.1.1.1 Input Items

<thead></thead><tbody></tbody>

Name	Type	Content
`siTOURID`	String	Tourid
`siINFO`	String	B\_TOURID.INFO first four characters
`siSTANDORT`	String	B\_MBLISTE.STANDORT
`siSERVICE`	String	B\_TOURID.SERVICE
`siAUSLIEFSTANDORT`	String	B\_MBLISTE.AUSLIEFSTANDORT
`siMBSCANID`	String	B\_MBLISTE.MBSCANID
`siSTANDORTDETAIL`	String	B\_MBLISTE.STANDORT
`siPRDHLFNR`	String	B\_MBLISTE.PRDHLFNR
`siFORM`	String	B\_MBLISTE.FORM
`siGATGRP`	String	B\_MBLISTE.GATGRP
`siARTNR`	String	B\_MBLISTE.ARTNR
`siARTKBZ`	String	B\_MBLISTE.ARTKBZ
`niTRAYMYENGE`	Number	Sum of tray quantity from B\_MBLISTE
`siDETAILS`	String	if details are fetched, otherwise empty
`siBEZ`	String	B\_TRANSMITTEL.BEZ

37.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`svMBSCANID`	String	MB scan ID (filled before the first fetch)
`svAUSLIEFSTANDORT`	String	Delivery location from B\_MBLISTE (filled before the first fetch)
`nvTRAYMENGEGES`	Number	Total tray quantity per TLP

38 Report Variables: Delivery Note

**Ported by Claude** · merged from WikiPat (German and English versions) and translated to English on 05.10.2026 · Origin and original pages: Port overview

38.1 Report Variables: Delivery Note

**Note:** The variable descriptions were translated from the German wiki with a glossary (machine-assisted); where a description is unclear check the German variable name and the original wiki text.

38.1.1 delivery note (LFS_NEU.qrp)

38.1.1.1 Input Items

• sPRDHLFNRBEZ produktionshilfsmittel description (can also translated are through translations)
• siALTERNAME Botanical name of the article
• niGEWICHT in g (b_auftrcol.gewicht, kommt from the Gewichtsangaben from b_artform)
• niGEW_PRDHLF in kg (b_auftrcol.sumgewprdhlf, kommt from b_prodhlfm) | Name | Type | Content | | | |---|---|---|---|---| | ARTKBZ | String | Artikelkurzbezeichnung | | | | dLFDATUM | Date/Time | delivery date | | | | GATGRPBEZ | String | article group name (possible translate through Artland GatgrpText) | | | | LANDBEZ | String | country name | | | | MCODE | String | Matchcode | | | | nFIRVKPREIS | Number | sales price per ??(group currency) | | | | nFIRZUSCHL | Number | Staatzuschlag per line (group currency) | | | | nFRACHTPREIS | Number | freight price per order line | | | | nLFJAHR | Number | Lieferjahr | | | | nLFKW | Number | Delivery week | | | | nLIZPREIS | Number | license price per line | | | | nLIZPROSTK | Number | reference quantity for license price (per..Stk.) | | | | nMENGE | Number | Quantity (per line) | | | | nMWST | Number | VAT (per line) | | | | nPFRACHTPR | Number | Freight lump sum | | | | nPMENGE | Number | price quantity (reference quantity for the sales price) | | | | nRABATT | Number | Rebate (per line) | | | | nSTDVKPREIS | Number | sales price per Stk. (order currency) | | | | nSTDVKSUM | Number | sales price per line (order currency) | | | | nTRAYANZ | Number | Trayanzahl (per line) | | | | nVPEH | Number | number Verpackungseinheiten | | | | nZUSCHLAG | Number | Surcharge (per line) | | | | PRODHMITTEL | String | production aid (kurz) | | | | PRODHMITTELBEZ | String | production aid name | | | | sARTNR | String | Article number | | | | sAUFTRDAT | Date/ Time | Order date | | | | sAUFTRINFO | String | Auftragsinformation | | | | sAUFTRNR | String | Order number | | | | sFIRMNR | String | Company number | | | | sFIRWAEHR | String | group currency | | | | sFORM | String | Product form | | | | sGATGRP | String | Article group (short name) | | | | sKARTKBZ | String | Kundenartikelbezeichnung | | | | sKARTNR | String | Customer article number | | | | sKBESTNR | String | Customer order number | | | | sKNDFAX | String | customer fax number | | | | sKNDKBZ | String | Customer short name | | | | sKNDLAD | String | Lieferadressenname | | | | sKNDNR | String | Customer number | | | | sKOMMISSION | String | Kommissionsnummer | | | | sKOMMISSION1 | String | Kommissionsnummer 1 | | | | sKOPFTEXT | String | header text from order | | | | sLANREDE | String | salutation delivery customer | | | | sLFINFO | String | Lieferinformation | | | | sLFNR | String | Liefernummer | | | | sLFWAEHR | String | Currency delivery customer | | | | sLLAND | String | Lieferland | | | | sLNAME1 | String | name 1 delivery customer | | | | sLNAME2 | String | name 2 delivery customer | | | | sLNAME3 | String | name 3 delivery customer (is not printed - not use | | - sKNDNAME3 geht) | | sLORT | String | Lieferort | | | | sLPLZ | String | Lieferpostleitzahl | | | | sLPO | String | Lieferpostleitzahl and -ort | | | | sLPOSTFACH | String | Lieferpostfach | | | | sLSTRASSE | String | Lieferstraße | | | | sLZH | String | „zu attention" delivery customer | | | | sOLDKNDNR | String | old Customer number | | | | SORTE | String | Sortenname | | | | sPEH | String | price unit (Stk. etc.) | | | | sPRDHLFNR | String | production aid (short name) | | | | sRKNDKBZ | String | Rechnungskundenkurzbezeichnung | | | | sRKNDNR | String | Invoice customer number | | | | sSTDWAEHR | String | default currency (order currency) | | | | sTELEFON | String | Phone (customer) | | | | sTEXT | String | text from Artikelzeile | | | | sTRAYANZ | String | Tray quantity | | | | sUIDNR | String | UIDNR (customer) | | | | sVERSART | String | Shipping type | | | | sVERTRNR | String | sales representative number | | | | sZAHLART | String | payment method | | | | TOURBEZ | String | Tourname | | | | TOURNR | String | Tour number | | | | VERPACKMENGE | String | type and number the production aid/packages on the delivery note | | | | VERTBEZ | String | sales representative name | | | | VERTFAX | String | sales representative fax number | | | | VERTNAME1 | String | sales representative name 1 | | | | VERTNAME2 | String | sales representative name 2 | | | | VERTTEL | String | sales representative phone number | | | | ZAHLARTBEZ | String | Zahlartname | | | | siVERSARTBEZ | String | description of the Shipping type | | | | siMATERIALNR | String | Material number from B_ARTFORM | | | | siARTIKELFAMILIE | String | plant family from B_ARTIKEL | | | | siARTIKELFAMILIEBEZ | String | description of the plant family | | | | siPRKW | Number | Aus B_AUFTRCOL | | | | siPRKW | Number | Aus B_AUFTRCOL | | | | diPRDATUM | Date | Aus B_AUFTRCOL | | | | siFRACHTZ | String | Aus B_AUFTRAG | | | | siPARTNERLFNR | String | Aus B_AUFTRCOL | | | | siWARENGRP | String | Aus B_AUFTRCOL | | | | siTEXT2 | String | Aus B_AUFTRCOL | | | | siR_LANDBEZ | String | Aus B_KNDSTAMM | | | | siDLANDBEZ | String | Aus B_KNDSTAMM | | | | siLIEFER_LANDBEZ | String | Aus B_KNDLAD | | | | siFL_PRIVAT1 | String | Aus B_AUFTRCOL | | | | siFL_PRIVAT2 | String | Aus B_AUFTRCOL (if available text from Textbaustein) | | | | ni1000KornGewicht | Number | Berechneter Wert (is not mehr gesetzt, from nun an is the 1000KornGewicht for jede Saatcharge angezeigt, see Input variables) | | | | siKONTAKT | String | Aus B_AUFTRAG | | | | siRECHNR | String | Invoice number from B_AUFTRCOL | | | | siLIEFNR | String | Aus Lieferantennr. from B_AUFTRCOL | | | | siKKBESTNR | String | KKBESTNR from B_AUFTRAG | | | | siVARIANTENBEZ | String | KBZ from B_FORM | | | | siTRADEMARK | String | TRADEMARK from B_AUFTRCOL | | | | siFLOWID_KUNDE | String | Flow-ID customer from B_AUFTRAG | | | | siFLOWID_HAENDLER | String | Flow-ID Händler from B_AUFTRAG | | | | siFLOWID_PRODUZENT | String | FLow-ID Produzent from B_AUFTRAG | | | | siFL_FAIRTRADE | String | flag Trademark from B_AUFTRCOL | | | | siKNDLOC | String | customer location from B_AUFTRCOL.KNDLOC | | | | niVPANZ | Number | VPANZ from B_AUFTRCOL | | | | siBUGRUPPE | String | booking group from the order line | | | | niGNDMENGE | Number | Erstmenge from B_AUFTRCOL | | | | niPVPEH | Number | Produktionsverpackungseinheit | | | | siARCHIV | String | If Archivdruck = J, otherwise empty | | | | siARTIKELFAMILIEN | String | All Artikelfamilien in einem String comma-separated | | | | niVPANZ | Number | Number of packages | | | | siFL_HANDVPANZ | String | flag manuelle packaging | | | | siSORTIMENTBEZ | String | assortment description | | | | siSORTNR | String | assortment from B_ARTIKEL | | | | nEXTRAQUANTITYSON | Number | Quantity * (B_ARTFORM.EXTRAQUANTITYSON/100) | | | | (NICHT AUF DEM REPORT AKTUELL | !) siORDER_SHIPPINGDATE | String | Versand(tag)date from the Table B_AUFTRCOL (B_AUFTRCOL.SHIPPINGDATE) | | | siKENNUNG1 | String | Kennung1 from the Artikelvariantenstamm | | | | niMENGE_GEH_ARTFORM | Number | Quantity weight units from B_ARTFORM | | | | siGEWICHT_EH_ARTFORM | String | weight unit from B_ARTFORM | | | | siAUFTRCOL_STATUS | String | Status from B_AUFTRCOL | | | | siARTICLE_COLOUR | String | Artikelfarbe from B_ARTIKEL or the translation from B_KONVERT | | | | siPRODUCT_TYPE | String | Produkttyp from B_ARTIKEL or the translation from B_KONVERT | | | | siSORTIMENTBEZ | String | assortment description (B_SORTIMENT.BEZ) | | | | siSPRACHE | String | language the Berichte from the customer master or country | | | | siLFDRUCKART | String | Lieferscheindruckart from the customer master (Bereich bulk print) | | | | niAUSMENGE | Number | Ausgangsmenge the order line | | | | siGATGRPBEZ_TRANS | String | Gatgrp Bez. translation (from Translations Table) | | | | siGATGRPBOT_TRANS | String | Gatgrp botanischer name translation (from Translations Table) | | | | siVERPACKBEZ | String | Long description the packaging (es gives also the Variable svVERPACKUNGBEZ) | | |

38.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`Anrede1`	String
`Anrede2`	String
`Anrede3`	String
`Anrede4`	String
`Anzeige`	String
`dvAFCOLLFDAT`	date	delivery date from the Auftragszeilen
`sFL_BIO`	String	FL\_BIO from B\_ARTFORM
`dvPartnerLieferDatum`	Date	delivery date Partner
`nvPartnerLieferTag`	Number	delivery day Partner
`nvPartnerLieferWoche`	Number	Delivery week Partner
`nvPartnerLieferJahr`	Number	Lieferjahr Partner
`svARTFORM_HINWEIS`	String	note, info from B\_ARTFORM

/

Anzeige

• LIEFERWOCHE , String, description Delivery week from the Reporttexten
• dvAFCOLLFDAT, date , delivery date from the Auftragszeilen
• dVALDATUM1, date , Valutadatum1
• dVALDATUM2, date , Valutadatum2
• Lname1_1 , String , formula for address print Lname1_2, Lname1_3, Lname2_1, Lname2_2
• nBETRAG_VERPACK, Number , amount the packaging costs per line
• nHOEHE, Number ,Höhe of the Artikels
• nMINMEZSWERT , Number , Wert of the special surcharge
• nPOSSUM_VERPACK , Number , sum the packaging costs
• nPROZENT1 , Number
• nTOPFGR , Number ,pot size
• nvBETRAG_ETIKETTE , Number , amount the label costs
• nvBETRAG_MINDERMENGE , Number , amount of the special surcharge
• nVERPACKPREIS, Number, price the packaging (per line)
• nvETMENGE , Number , Label quantity
• nvETMWST, Number , VAT the Labels
• nvETPMENGE, Number , Labels-price quantity
• nvETPREIS , Number , Number , Label price
• nvETVPEH, Number , Packing unit the Labels
• nvLFPOS, Number ,
• nvLFTAG , Number , weekday the delivery (1-7)
• nvPOSSUM_ETIKETTE , Number , sum the label costs
• nvPOSSUM_MINDERMENGE, Number , sum of the special surcharge
• nvTOURPOS , Number , number the Lieferreihenfolge (from the Tourenplanung)
• sZUSCHLAGPREISMENGE , String , price quantity of the special surcharge
• sARTIKELBOTAN , String , Botanical name of the article
• sBARCODE, String , Barcode
• sBearbeiter , String , Benutzer, the order created hat
• sDANREDE , String , Depot- salutation
• sDEPOTNR , String , Depot- number
• sDKNDKBZ , String , Depot- short name
• sDLAND , String , Depot- country
• sDNAME1 , String , Name1
• sDNAME2 , String , Name2
• sDORT , String , city
• sDPLZ , String , Depot- postal code
• sDPOSTFACH , String , Depot- P.O. box
• sDTRASSE , String , Depot- street
• sDZH , String , Depot- zu attention
• sGATGRPBOTAN, String , Botanical name of the article group (can also translated are through Artland)
• sKND_HANDY , String , mobile number of the customers
• sKndNAME3 , String , Name3 of the customers
• sSACH_EMAIL , String , Email of the processor
• sSACH_HANDY , String , Mobile phone of the processor
• sSACH_KBEZ , String , short name of the processor
• sSACH_NAME1 , String , Name1 of the processor
• sSACH_NAME2 , String , Name2 of the processor
• sSACH_TELEFON , String , phone number of the processor
• sVARIANTEBEZ , String , Artikelvariantenbezeichnung (can also translated are through translations)
• svCHARGENNR , String , Batch number of the Artikels
• sVERPACK , String , Verpackungskurzbezeichnung
• sVERT_AGENTUR , Vertreteragentur
• sVERT_EMAIL , String , Email of the Vertreters
• sVERT_HANDY , String , Mobile number of the sales representative
• sVERT_KNDNR , Sring
• svVATERAUFTRNR, String , Order number of the Vater
• sVERT_LAND , String , Country of the sales representative
• sVERT_MODEM , String , Modemnummer of the Vertreters
• sVERT_ORT ,String , City of the sales representative
• sVERT_PLZ , tring , postal code of the Vertreters
• sVERT_POSTFACH, String , P.O. box of the sales representative
• SVERT_PROVGRUPPE , tring , Provisionsgruppe of the Vertreters
• sVERT_STRASSE , String , street of the Vertreters
• svVERT_UIDNR , String ,VAT ID of the Vertreters
• svFAXNUMMER , String ,fax number of the customers
• svFRACHTZONE, String , freight zone
• svHALTBGRP , String , Haltbarkeitsgruppe
• svIDENTNR , String , Identnummer, Reference number of the Artikels
• svPOSTFAX , String character string NACH the fax number for faxing from PAT (hängt of the Faxtreiber ab)
• svPREFAX, String , character string VOR the fax number for faxing from PAT (hängt of the Faxtreiber ab)
• svQUALKENNZ, Qualtitätskennzeichen of the Artikels
• svZUSBARCODE, String , Zusatzbarcode
• svSTANDORTNAME , String , description of the Standortes from B_HAUS
• svLADTELEFON , String ,Phone from Ladestelle ( delivery address)
• svLADFAX , String , fax from Ladestelle ( delivery address)
• svLADHANDY , String , Mobil from Ladestelle ( delivery address)
• svLADEMAIL, String, E-Mail of the Lieferscheins (delivery address)
• svLADUIDNR, String, UID-Nr. of the Lieferscheins (delivery address)
• svDTELEFON , String , Phone from Depot
• svDFAX , String , fax from Depot
• svDHANDY, String , Mobil from Depot
• ZeigePostfach , String , formula for address print
• ZeigeStrasse , String , formula for address print
• svKUNDENTEXT , String , KNDSTAMM
• svLFANGNAME , String , name of the Bearbeiters Angelegt
• svLFAENNAME , String , name of the Bearbeiters Geändert
• svTOURINFO , String , Information the Tour B_TOURID
• svTRANSMBEZ , String , description of the Transportmittels B_TRANSMITTEL
• dvTOURSHIPDATE, Date/Time , Shipping Date B_TOURID
• sDNAME3, String ,Depotname3
• dvAUFTRDAT, date , Order date B_AUFTRAG
• svKUNDE_FILIALNR , String , branch number of the customers
• svKUNDE_ILN, String , ILN-number of the customers
• svKUNDE_ILNZENTRALE , String , ILN-Zentrale of the customers
• svWARENGRP, String , product group
• svVERPACKUNGBEZ , String , Bezeichung the packaging
• svFRACHTZONEBEZ , String , Bezeichung the freight zone ( B_AUFTRAG )
• svFRACHTZONE, String , description of the freight zone ( B_KNDFIRMA )
• svKUNDENTEXT , String , Kundenbezogener text on order confirmation and delivery note (B_KNDSTAMM) -> funktioniert not !!!! - stattdessen svKUNDENTEXTAUSLF use!!!
• svCHARGENNR, String , Batch number (b_prodplan)
• svGATGLONGTEXT , String , Beschreibung in article group (b_gatgrp)
• svRES_CHARGENNR1 bis n z.b svRES_CHARGENNR12 , Batch number the Reservierung)
• svRES_STANDORT1 bis n z.b svRES_STANDORT String , Location the Batch
• svRES_TEXT1 bis n z.b svRES_TEXT10 , String , text the Produktions - Batch
• nvRES_MENGE bis n , number , menge the Pflanzen NICHT gerundet
• nvRES_TRAYANZ1 bis n', number , anzahl trays = menge / VPEH
• svRES_QUALITAET1 bis n , number , Qualitaet
• svRES_IDENTNR1 bis n , number , identnummer the Batch is of the Suppliers vergeben.
• nRES_PRKW1 bis n , number , produktionswoche
• dRES_PRDATUM1 bis n , number , produktionsdatum
• svRES_URLAND bis n, number , Ursprungsland - is for the Batch eingegeben.
• svKUNDE_KNDKBZ KundenAdresse if customer not delivery address (kndlad-adresse) svKUNDE_ANREDE, svKUNDE_NAME1, svKUNDE_NAME2, svKUNDE_NAME3, svKUNDE_ZH, svKUNDE_STRASSE, svKUNDE_LAND, svKUNDE_PLZ, svKUNDE_ORT, svKUNDE_POSTFACH, svKUNDE_ORTSTEIL, svKUNDE_BUNDESSTAAT, svKUNDE_FAX, svKUNDE_EMAIL, svKUNDE_FIRMENBUCH, svKUNDE_STEUERCODE
• svVERSANDABTEIL String from B_ARTFORM
• svAFC_URLAND Ursprungsland from b_auftrcol
• svLEER_ARTNR1-n
• svLEER_ARTKBZ1-n
• svLEER_SHOW1-n (hier steht ein Plus drinnen, if incoming,outgoing and balance not 0 are) for the Anzeige.
• svLIEFLAND Country of the supplier in the order line
• nvLEER_AUSGANG1-n
• nvLEER_EINGANG1-n
• nvLEER_SALDO1-n
• svUSER Windows user
• sKNDGRP String B_LFSCHEIN.KNDGRP
• sL_KOPF1 String Kopftext1 delivery note
• sL_KOPF2 String Kopftext2 delivery note
• svLPLZ String delivery address postal code
• svLORT String delivery address city
• svLORTSTEIL String delivery address district
• nvTLP_REIHE Number Column Row from B_LAGE
• svRKNDNAME1 String Name1 of the invoice customers
• svRKNDNAME2 String Name2 of the invoice customers
• svRKNDNAME3 String Name3 of the invoice customers
• svRKNDSTRASSE String Street of the invoice customer
• svRKNDPLZ String Postal code of the invoice customer
• svRKNDORT String City of the invoice customer
• svRKNDLANDKURZ String short name of the Landes of the invoice customers
• svRKNDLAND String description of the Landes of the invoice customers
• svRKNDBUNDESSTAATKURZ String short name of the federal state of the invoice customers
• svRKNDBUNDESSTAAT String description of the federal state of the invoice customers
• sKndBUNDESSTAAT String Lange description of the federal state of the Lieferkunden
• nvGNDMENGE Number Erstmenge from the order
• svLIEFKBZ String Lieferantenkurzbezeichnung from B_LIEFERANT
• svLIEFNAME1 String Name1 of the Suppliers from B_LIEFERANT
• svLIEFLAND String LAND of the Suppliers from B_LIEFERANT
• svLIEFLANDNAME String country name from B_LAND with FIRMA from B_LFSCHEIN
• svTOURID String TourID from B_AUFTRCOL
• svLADEHILFSMITTEL from B_TOURID
• svKUNDE_LFDRUCKART String Lieferscheindruckart from the customer master
• svKUNDE_LFMAIL String e-mail address for delivery note bulk print from the customer master
• svKUNDE_LFMAILCC String e-mail address CC for delivery note bulk print from the customer master
• svKUNDE_LFMAILBCC String e-mail address BCC for delivery note bulk print from the customer master
• svERSTE_SEITE Contains for erster Page ein +, otherwise is the Variable leer
• svLIEFALLELAENDER String All countries of the Suppliers of the Artikels (comma-separated)
• svALLEBOTANISCH String All botanische names the Article (from B_ARTIKEL) with Zeilenumbruch getrennt
• sALLEURLAENDER String All Ursprungsländer the Ausgangschargen
• svALLEURLAENDERISO String All Ursprungsländer the Ausgangschargen im ISO-Code
• svKUNDENTEXTAUSLF String (B_LFSCHEIN.KTEXT, kommt from the customer master and is in B_LFSCHEIN übernommen)
• svALLEURLAENDERAUFTRCOL String All Urländer from B_AUFTRCOL comma-separated in the footer
• svALLEURLAENDERAUFTRCOLISO String All Urländer from B_AUFTRCOL comma-separated in the footer im ISO-Code
• svALLEGATGRPBOTANISCH String All botanische names the Gattungsgruppen (B_GATGRP.ANDBEZ) with Zeilenumbruch getrennt
• svRKNDPFLPASSNR String plant passport number of the invoice customers from the customer-company master
• svKNDPFLPASSNR String plant passport number of the Lieferkunden from the customer-company master
• svLIEFALLELAENDERISO String ISO country of the Suppliers if B_FORM.COUNTRYSOURCE = 'SUPPLIER' or leer, otherwise ISO country of the Standorts (B_AUFTRCOL.STANDORT->B_HAUS.LAND)
• svPFLPASSNR String sucht with Service Code (IN_1) in B_KONVERT (Projekt=SERVICE, Kennung=SERVICE), if er dort eine plant passport number findet gut, otherwise nimmt er the plant passport number from B_FIRMA
• svPZ_CODES String Sucht with Lieferland + Gatgrp (gefüllt or ---) + Code_Anweisung = PZ_LF in B_HAFTUNGSAUSSCHLUSS_MATRIX and gives the text zurück. All gefundenen texts are Kommagetrennt together gefügt
• sLEGENDE_PROLF String Die Legende aber per delivery note, can in the footer the LFNR angezeigt are
• svALLESORTIMENTBEZ String assortment Bezeichnungen for Pflanzenpass (in the footer)
• svKUNDE_ARANR String Aranr. from the customer master of the Lieferkunden
• nvLAGEWAG Number number shelves per Container from B_AUFTRCOL
• svARTICLE_COLOUR String Artikelfarbe from B_ARTIKEL or the translation from B_KONVERT
• svPRODUCT_TYPE String Produkttyp from B_ARTIKEL or the translation from B_KONVERT
• svSORTIMENTBEZ String assortment description (B_SORTIMENT.BEZ)
• svMASTER_AWB_ID String Master AWB ID from B_TOURID Rechnungskundenvariablen, sRechKNDNR, sRechKNDKBZ, sRechANREDE, sRechZH, sRechNAME1, sRechNAME2, sRechNAME3, sRechPLZ, sRechORT, sRechLAND, sRechSTRASSE, sRechPOSTFACH, sRechLPO, sRechKUNDE_ILN, sRechKUNDE_FILIALNR, sRechLANDBEZ, sRechTELEFON, sRechFAX, sRechHANDY, sRechORTSTEIL, sRechBUNDESSTAAT, sRechBUNDESSTAAT_LANG, sRechSTEUERCODE, sRechEMAIL, sRechUIDNR
• sRechREMAIL (e-mail address from the customer master tab delivery note/invoice for delivery note bulk print if not leer)
• sRechREMAILCC (e-mail address from the customer master tab delivery note/invoice for delivery note bulk print if not leer)
• sRechREMAILBCC (e-mail address from the customer master tab delivery note/invoice for delivery note bulk print if not leer)
• Rechnungskundenvariablen (Rechnungskunde2 = ZRechnungskunde of the Lieferkunden) sRech2KNDNR, sRech2KNDKBZ, sRech2ANREDE, sRech2ZH, sRech2NAME1, sRech2NAME2, sRech2NAME3, sRech2PLZ, sRech2ORT, sRech2LAND, sRech2STRASSE, sRech2POSTFACH, sRech2LPO, sRech2KUNDE_ILN, sRech2KUNDE_FILIALNR, sRech2LANDBEZ, sRech2TELEFON, sRech2FAX, sRech2HANDY, sRech2ORTSTEIL, sRech2BUNDESSTAAT, sRech2BUNDESSTAAT_LANG, sRech2STEUERCODE, sRech2EMAIL, sRech2UIDNR
• sRech2REMAIL (e-mail address from the customer master tab delivery note/invoice for delivery note bulk print if not leer)
• sRech2REMAILCC (e-mail address from the customer master tab delivery note/invoice for delivery note bulk print if not leer)
• sRech2REMAILBCC (e-mail address from the customer master tab delivery note/invoice for delivery note bulk print if not leer)
• Kundenlieferadressenvariablen (Kndlad) sLadKNDNR, sLadKNDKBZ, sLadANREDE, sLadZH, sLadNAME1, sLadNAME2, sLadNAME3, sLadPLZ, sLadORT, sLadLAND, sLadSTRASSE, sLadPOSTFACH, sLadLPO, sLadKUNDE_ILN, sLadKUNDE_FILIALNR, sLadLANDBEZ, sLadTELEFON, sLadFAX, sLadHANDY, sLadORTSTEIL, sLadBUNDESSTAAT, sLadSTEUERCODE, sLadEMAIL, sLadUIDNR, sLadBUNDESSTAAT_LANG
• variables for Sammeldruck (sums through mehrere Lieferscheine): nvSAMMEL_SUM_MINDERMENGE, nvSAMMEL_SUM_VERPACK, nvSAMMEL_SUM_ETIKETTE
• Protected Zone (PZ) Variables - depending on B_HAFTUNGSAUSSCHLUSS.CODE_ANWEISUNG (searched by Company, Delivery Country and Article Group) contains PZ or not
  • svALLEURLAENDERAUFTRCOL_PZ (country of origin of order line (PAT Code) for the groups with PZ)
  • svALLEURLAENDERAUFTRCOLISO_PZ (country of origin of order line in ISO Format for the groups with PZ)
  • svALLEURLAENDERAUFTRCOL_NOT_PZ (country of origin of order line (PAT Code) for the groups not PZ)
  • svALLEURLAENDERAUFTRCOLISO_NOT_PZ (country of origin of order line in ISO Format for the groups not PZ)
  • svALLEGATGRPTEXTS_PZ (text of article group for the groups with PZ)
  • svALLEGATGRPTEXTS_NOT_PZ (text of article group for the groups not PZ)
  • svALLEGATGRPBOTANISCH_PZ (botanical name of article group for the groups with PZ)
  • svALLEGATGRPBOTANISCH_NOT_PZ (botanical name of article group for the groups not PZ)
  • svALLEARTBOT_PZ (botanical name of article for teh groups with PZ)
  • svALLEARTBOT_NOT_PZ (botanical name of article for the groups not PZ)
  • svALLEURLAENDERISO_PZ (country of origin of Reserviations ISO Format for the groups with PZ)
  • svALLEURLAENDERISO_NOT_PZ (country of origin of Reservations ISO Format for the groups not PZ)
  • ovEU_FLAG_PZ (Object Variable for EU Flag, filled if all or partly lines are PZ, not filled when no line is PZ)
  • ovEU_FLAG_NOT_PZ (Object Variable for EU Flag, filled if all or partly lines are not PZ, not filled when all lines are PZ)
  • The file for the EU Flag: eu_flag_white_low.JPG, must be in REPORTS Directory
• f

/ Diese variables are filled if eine Batch number verhanden is:

• svRES_CHARGENNR1..n from B_PRODPLAN
• svRES_STANDORT1..n from B_PROD_CHARGE or B_TRACE_CHARGE or B_PRODPLAN
• svRES_TEXT1..n from B_PRODPLAN
• nvRES_MENGE1..n from B_RES_CHARGE
• nvRES_TRAYANZ1..n Quantity from B_RES_CHARGE (VPEH from B_PRODPLAN)
• svRES_QUALITAET1..n from B_PRODPLAN
• svRES_IDENTNR1..n from B_TRACE_CHARGE or B_RES_CHARGE
• nRES_PRKW1..n from B_PRODPLAN
• dRES_PRDATUM1..n from B_PRODPLAN
• svRES_URLAND1..n from B_PRODPLAN
• nvRES_PROZSAATAUFSCHLAG1..n from B_PRODPLAN
• nvRES_KEIMLIEF1..n from B_PRODPLAN
• nvRES_1000KORNGEWICHT1..n from B_PRODPLAN ((MENGE_GEH/MENGE_MEH)*1000)
• svRES_REGISTRATION_NUMBER1..n from B_PROD_REGISTRATION
• svRES_INITIAL_REGISTRATION_NUMBER1..n from B_PROD_REGISTRATION
• svIDENTNR from B_PRODPLAN
• svQUALKENNZ from B_PRODPLAN
• svKEIMLIEF from B_PRODPLAN
• svCERTIFICATE_NO1..n from CERTIFICATES
• svAPPROVAL_MARK1..n from CERTIFICATES
• svCERTIFICATE_USAGE_ID1..n from CERTIFICATES
• svCERTIFICATE_CATEGORY_ID1..n from CERTIFICATES
• svCERTIFICATE_AUTONOMOUS_ID1..n from CERTIFICATES
• svFUND_AGENCY_NO11..n from CERTIFICATES
• svFUND_AGENCY_NO21..n from CERTIFICATES
• svCERTIFICATE_BASIC_MATERIAL_ID1..n from CERTIFICATES
• svALTITUDE1..n from CERTIFICATES
• svREIFEJAHR1..n from CERTIFICATES
• svBAUMSCHULALTER1..n from CERTIFICATES
• svVERWENDUNG1..n from CERTIFICATES
• svAUTOCHTHONIE1..n from CERTIFICATES
• svAM1..n from CERTIFICATES
• svKATEGORIE1..n from CERTIFICATES
• svREGISTERZEICHEN1..n from CERTIFICATES
• svVERMEHRUNGSGUTART1..n from CERTIFICATES
• svURSPRUNG1..n from CERTIFICATES
• svSONDERHERKUNFT1..n from CERTIFICATES
• svZUSATZINFO1..n from CERTIFICATES
• svWG1..n from CERTIFICATES
• svHL1..n from CERTIFICATES
• svHERKUNFT1..n from CERTIFICATES
• svCERTIFICATE_AUTOCHTHONOUS_ID1..n from CERTIFICATES
• svPROPAGATION_MATERIAL_TYPE_ID1..n from CERTIFICATES
• svREGISTRATION_NO1..n from CERTIFICATES
• svCERTIFICATE_ORIGIN_ID1..n from CERTIFICATES
• svGROWING_REGION_NAME1..n from CERTIFICATES
• svGROWING_REGION_ID1..n from CERTIFICATES
• nvPOSSIBLE_GENETIC_MODIFICATON1..n from CERTIFICATES
• nvEVG1..n from CERTIFICATES
• nvYEAR_OF_HARVEST1..n from CERTIFICATES
• nvYEAR_OF_SOWING1..n from CERTIFICATES
• nvYEAR_OF_POTTING1..n from CERTIFICATES
• nvYEAR_OF_CUTTING1..n from CERTIFICATES

38.1.2 Stichwörter

Reportvariablen delivery note, Report delivery note, delivery note Report

39 Report Variables: Loading List

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

39.1 Report Variables: Loading List

**Note:** The variable descriptions were translated from the German wiki with a glossary (machine-assisted); where a description is unclear check the German variable name and the original wiki text.

39.1.1 loading list (ladeliste.qrp)

_Hinweise fuer the Reservierungssystem. Chargenverwaltung _

ACHTUNG: !!! Die Chargenreservierungen fuer the Saatchargen are in the ITEMS !!! z.b siRES_TEXT 1 ... siRES_TEXT4 Die Informationen fuer the Produktionschargen befinden sich in the variables.

!!Die Items and variables for the Chargenreservoerungen are only gefüllt, if the Default Setting/ Produktion/Lager / Zeige Tracinginformationen gesetzt is.!!

Firmeneinstellungen->Batch ITEMS loading list->Lagerstandorte statt Reservierungen:Es are the Standorte for Article and Product form fetched (FL_ART = P or L -> evtl. also from B_PROD_CHARGE) and statt the reservierten or getraceten Standorten angezeigt (Input Item: siRES_STANDORT1-10 or Variable svRES_STANDORT1-10)

39.1.1.1 Input Items

siKNDINFOSUBTYP, siRES_CHARGENNR1, siRES_STANDORT1, niRES_MENGE1, siRES_QUALITAET1, niRES_1000KORN1, niRES_AKTKEIM1, niRES_KEIMLIEF1, siRES_IDENTNR1, siRES_AUSCHARGENNR1, siRES_CHARGENNR2, siRES_STANDORT2, niRES_MENGE2, siRES_QUALITAET2, niRES_1000KORN2, niRES_AKTKEIM2, niRES_KEIMLIEF2, siRES_IDENTNR2, siRES_AUSCHARGENNR2, siRES_CHARGENNR3, siRES_STANDORT3, niRES_MENGE3, siRES_QUALITAET3, niRES_1000KORN3, niRES_AKTKEIM3, niRES_KEIMLIEF3, siRES_IDENTNR3, siRES_AUSCHARGENNR3, niRES_TRAYANZ1, niRES_TRAYANZ2, niRES_TRAYANZ3, siRES_TEXT1, siRES_TEXT2, siRES_TEXT3, siRES_CHARGENNR4, siRES_STANDORT4, niRES_MENGE4, siRES_QUALITAET4, niRES_1000KORN4, niRES_AKTKEIM4, niRES_KEIMLIEF4, siRES_IDENTNR4, siRES_AUSCHARGENNR4, niRES_TRAYANZ4, siRES_TEXT4, niRES_1000KORN5, niRES_AKTKEIM5, niRES_KEIMLIEF5, siRES_AUSCHARGENNR5, niRES_1000KORN6, niRES_AKTKEIM6, niRES_KEIMLIEF6, siRES_AUSCHARGENNR6, niRES_1000KORN7, niRES_AKTKEIM7, niRES_KEIMLIEF7, siRES_AUSCHARGENNR7, niRES_1000KORN8, niRES_AKTKEIM8, niRES_KEIMLIEF8, siRES_AUSCHARGENNR8, niRES_1000KORN9, niRES_AKTKEIM9, niRES_KEIMLIEF9, siRES_AUSCHARGENNR9, niRES_1000KORN10, niRES_AKTKEIM10, niRES_KEIMLIEF10, siRES_AUSCHARGENNR10, siGESVERPACKMENGEFORM, siVERPACKMENGEFORM, siKNDVERPACKMENGEFORM, siALTERNAME, siSTANDORT, siABTEILUNG

• siORDER_SHIPPINGDATE (String) = Versand(tag)date from the Table B_AUFTRCOL (B_AUFTRCOL.SHIPPINGDATE) /

<thead></thead><tbody></tbody>

Name	Type	Content
`ARTKBZ`	String	Artikelkurzbezeichnung
`ARTNR`	String	Article number
`AUFTR_INFO`	String	Order number
`AUFTRDAT`	Date/Time	Order date
`BEZ`	String	Company name
`FIRMNR`	String	Company number
`FORM`	String	Product form
`GATGRPBEZ`	String	article group name
`GESVERPACKMENGE`	String	type and number aller production aid on the loading list
`KNDKBZ`	String	Customer short name
`KNDNR`	String	Customer number
`KNDVERPACKMENGE`	String	type and number the production aid je customer
`KW1`	String	Delivery week and date
`LADLISTINFO`	String
`LFDATUM`	Date/Time	delivery date
`LFJAHR`	Number	Lieferjahr
`LFKW`	Number	Delivery week
`LIEFERDAT`	Date/Time
`LLAND`	String	Lieferland
`LNAME1`	String	Liefername1
`LNAME2`	String	Liefername2
`LORT`	String	Lieferort
`LPLZ`	String	Lieferpostleitzahl
`LSTRASSE`	String	Lieferstraße
`MCODE`	String	Matchcode
`nGESVE`	Number	Total quantity the Verpackungseinheiten
`niMENGENFAKTOR`	Number	Mengenfaktor
`niTOURPOS`	Number	Tourposition (Reihenfolge)
`nKNDVE`	Number	number Verpackungseinheiten je customer
`nLFTAG`	Number	Liefer-weekday (1-7)
`nMENGE`	Number	Quantity
`nVE`	Number	number Packing unit
`PRDHLFNR`	String	production aid
`sAUFRTNR`	String	Order number
`sGATGRP`	String	article group
`siANREDE`	String	salutation
`siDANREDE`	String	salutation Depot
`siDEMAIL`	String	Email Depot
`siDEPOTNR`	String	Depotnummer
`siDFAX`	String	fax Depot
`siDHANDY`	String	Mobile phone Depot
`siDKNDKBZ`	String	short name Depot
`siDLAND`	String	country Depot
`siDNAME1`	String	Name1 Depot
`siDNAME2`	String	Name2 Depot
`siDORT`	String	city Depot
`siDORTSTEIL`	String	district Depot
`siDPLZ`	String	postal code Depot
`siDPOSTFACH`	String	P.O. box Depot
`siDSTRASSE`	String	street Depot
`siDTELEFON`	String	Phone Depot
`siDZH`	String	Attention Depot
`siEMAIL`	String	Email Depot
`siFAX`	String	fax Depot
`siFL_LIEFDIREKT`	String	flag delivery direkt
`siHANDY`	String	mobile number customer
`siKNDKBZ`	String	Customer short name
`siLAND`	String	country
`siLIEFER_ANREDE`	String	salutation of the Lieferkunden (of the order)
`siLIEFER_FAX`	String	fax number of the Lieferkunden (of the order)
`siLIEFER_HANDY`	String	mobile number of the Lieferkunden (of the order)
`siLIEFER_KNDNR`	String	Customer number of the Lieferkunden (of the order)
`siLIEFER_LAND`	String	country of the Lieferkunden (of the order)
`siLIEFER_NAME1`	String	Name1 of the Lieferkunden (of the order)
`siLIEFER_NAME2`	String	Name2 of the Lieferkunden (of the order)
`siLIEFER_ORT`	String	city of the Lieferkunden (of the order)
`siLIEFER_ORTSTEIL`	String	district of the Lieferkunden (of the order)
`siLIEFER_PLZ`	String	postal code of the Lieferkunden (of the order)
`siLIEFER_POSTFACH`	String	P.O. box of the Lieferkunden (of the order)
`siLIEFER_STRASSE`	String	street of the Lieferkunden (of the order)
`siLIEFER_TELEFON`	String	phone number of the Lieferkunden (of the order)
`siLIEFER_ZH`	String	Attention of the Lieferkunden (of the order)
`siLIEFNR`	String	supplier number
`siNAME1`	String	Name1 of the Lieferkunden or ggf. the delivery address (kndlad)
`siNAME2`	String	Name2 of the Lieferkunden or ggf. the delivery address (kndlad)
`siORT`	String	city of the Lieferkunden or ggf. the delivery address (kndlad)
`siORTSTEIL`	String	district of the Lieferkunden or ggf. the delivery address (kndlad)
`siPLZ`	String	postal code of the Lieferkunden or ggf. the delivery address (kndlad)
`siPOSTFACH`	String	P.O. box of the Lieferkunden or ggf. the delivery address (kndlad)
`siR_ANREDE`	String	salutation of the Rechnungsempfänger
`siR_EMAIL`	String	Email of the Rechnungsempfänger
`siR_FAX`	String	fax of the Rechnungsempfänger
`siR_HANDY`	String	Mobile phone of the Rechnungsempfänger
`siR_KNDKBZ`	String	short name of the Rechnungsempfänger
`siR_KNDNR`	String	Customer number of the Rechnungsempfänger
`siR_LAND`	String	country of the Rechnungsempfänger
`siR_NAME1`	String	Name1 of the Rechnungsempfänger
`siR_NAME2`	String	Name2 of the Rechnungsempfänger
`siR_ORT`	String	city of the Rechnungsempfänger
`siR_ORTSTEIL`	String	district of the Rechnungsempfänger
`siR_PLZ`	String	postal code of the Rechnungsempfänger
`siR_POSTFACH`	String	P.O. box of the Rechnungsempfänger
`siR_STRASSE`	String	street of the Rechnungsempfänger
`siR_TELEFON`	String	Phone of the Rechnungsempfänger
`siR_ZH`	String	Attention of the Rechnungsempfänger
`siRES_STRING`	String	Reservierung (Quantity and Batch number)
`siSTRASSE`	String	street of the Lieferkunden or ggf. the delivery address (kndlad)
`siTELEFON`	String	phone number of the Lieferkunden or ggf. the delivery address (kndlad)
`siVATER_ANREDE`	String	salutation of the Vaterauftrag
`siVATER_FAX`	String	fax of the Vaterauftrag
`siVATER_HANDY`	String	Mobile phone of the Vaterauftrag
`siVATER_KNDNR`	String	Customer number of the Vaterauftrag
`siVATER_LAND`	String	country of the Vaterauftrag
`siVATER_NAME1`	String	Name1 of the Vaterauftrag
`siVATER_NAME2`	String	Name2 of the Vaterauftrag
`siVATER_ORT`	String	city of the Vaterauftrag
`siVATER_ORTSTEIL`	String	district of the Vaterauftrag
`siVATER_PLZ`	String	postal code of the Vaterauftrag
`siVATER_POSTFACH`	String	P.O. box of the Vaterauftrag
`siVATER_STRASSE`	String	street of the Vaterauftrag
`siVATER_TELEFON`	String	Phone of the Vaterauftrag
`siVATER_ZH`	String	Attention of the Vaterauftrag
`siVATERAUFTRNR`	String	Order number of the Vaterauftrag
`siWARENGRP`	String	product group
`siZH`	String	Attention of the Lieferkunden or ggf. the delivery address (kndlad)
`sKOMMISSION`	String	Consignment
`sKOPFTEXT`	String	header text
`sLADLISTINFO`	String	Ladelisteninformation
`sLFINFO`	String	Lieferscheinformation
`sORDERNR`	String	Ordernummer
`SORTE`	String	Sorte
`sVARIANTEBEZ`	String	name the Product form
`TEL_LANDCODE`	String
`TEL_VORWAHL`	String
`TELEFON`	String
`TEXT`	String	text from the Article(order-)zeilen
`TOURBEZ`	String	Tourname
`TOURID`	String	Tour-ID
`TOURNR`	String	Tourkurzname
`TRANSMITTEL`	String	Means of transport
`VERPACKMENGE`	String	type and number the production aid
`VERTRNR`	String	sales representative number
`VPEH`	Number	Packing unit
`siVERSART`	String	Shipping type
siVERSARTBEZ,	String	Versandartbezeichnung
`siGEBART`	String	Gebindeart
`niANZGEB`	Number	number the Gebinde from AUFTRCOL
`niANZVERPACK`	Number	number the packages calculated in the LL
`niANZGEBINDE`	Number	number the Gebinde calculated in the LL
`niPRKW`	Number	PRKW from Auftrcol
`niPRJAHR`	Number	PRJAHR from Auftrcol
`niPRJAHR`	Number	PRJAHR from Auftrcol
`siLNAME2`	String	LNAME2 from Auftrcol
`siKNDINFOTYP`	String	Typ from KNDSTAMM for Kundensegmentierung
`siKNDINFOSUBTYP`	String	Subtyp from KNDSTAMM for Kundensegmentierung
`siRES_CHARGENNR1`	String	Informationen from B\_PRODPLAN through reservierte Batches from Here bis
`siRES_STANDORT1`	String
`niRES_MENGE1`	Number
`siRES_QUALITAET1`	String
`niRES_1000KORN1`	Number
`niRES_AKTKEIM1`	Number
`niRES_KEIMLIEF1`	Number
`siRES_IDENTNR1`	String
`siRES_AUSCHARGENNR1`	String
`siRES_CHARGENNR2`	String
`siRES_STANDORT2`	String
`niRES_MENGE2`	Number
`siRES_QUALITAET2`	String
`niRES_1000KORN2`	Number
`niRES_AKTKEIM2`	Number
`niRES_KEIMLIEF2`	Number
`siRES_IDENTNR2`	String
`siRES_AUSCHARGENNR2`	String
`siRES_CHARGENNR3`	String
`siRES_STANDORT3`	String
`niRES_MENGE3`	Number
`siRES_QUALITAET3`	String
`niRES_1000KORN3`	Number
`niRES_AKTKEIM3`	Number
`niRES_KEIMLIEF3`	Number
`siRES_IDENTNR3`	String
`siRES_AUSCHARGENNR3`	String	Here
`siGESVERPACKMENGEFORM`	String	tab getrennt, on Report einzurichten
`siVERPACKMENGEFORM`	String	tab getrennt, on Report einzurichten
`siKNDVERPACKMENGEFORM`	String	tab getrennt, on Report einzurichten
`siALTERNAME`	String
`siSTANDORT`	String	Location, max. länge 40
`siABTEILUNG`	String	department, max. länge 8
`siTRACE_CHARGE_CHARGENNR`	String	loading list Location: Batch number from the Table B\_TRACE\_CHARGE
`siPRODPLAN_STANDORT`	String	loading list Location: Location from B\_PRODPLAN
`siPROD_CHARGE_STANDORT`	String	loading list Location: Location from B\_PROD\_CHARGE
`niTRACE_CHARGE_SUM`	Number	loading list Location: sum the Quantity in B\_TRACE\_CHARGE
`niTRAYS`	Number	loading list Location: sum the Trays in B\_TRACE\_CHARGE
`niTRACE_CHARGE_DIV_VPEH_SUM`	Number	loading list Location: sum the Quantity in B\_TRACE\_CHARGE divdiert durch the Verpackungseinheiten
`niTRACE_CHARGE_SUM`	Number	loading list Location with data from the Tracing: Quantity in B\_TRACE\_CHARGE
`niTRAYS`	Number	loading list Location with data from the Tracing: in B\_TRACE\_CHARGE (Grundlage: PVPEH)
`siPROD_CHARGE_STANDORT`	String	loading list Location with data from the Tracing: Location from B\_TRACE\_CHARGE
`siKNDGRP`	String	Kundengruppe (KNDGRP) from B\_AUFTRAG
`siKARTNR`	String	Customer article number
`siKARTKBZ`	String	Kundenartikelbezeichnung
`siGATGRPBOTNAME`	String	Botanical name of the article group
`siBARCODE`	String	Barcode from Kundenartikel
`niPVPEH`	Number	PVPEH from the order line
`siVERPACK`	String	packaging from B\_AUFTRCOL
`siVERPACKBEZ`	String	Verpackungsbezeichnung from B\_VERPACKUNG
`siLADELISTINFO`	String	Ladelisteninformation from B\_KNDSTAMM, da Variable svKUNDELADELISTINFO only for Sorting per order angezeigt is
`siKNDLAD`	String	Kndlad
`KNDLADVERPACKMENGE1`	String	sum Tray quantity per Kndlad and Prdhlfnr with Prdhlfnr
`siKNDLADVERPACKMENGEFORM`	String	sum Tray quantity per Kndlad and Prdhlfnr with Prdhlfnr and Product form
`nKNDLADVE`	String	sum Tray quantity per Kndlad
`siOLDKNDNR`	String	B\_KNDSTAMM.OLDKNDNR
`siKNDLOC`	String	customer location (B\_AUFTRCOL.KNDLOC)
`siTRACE_CHARGE_LIEFNR`	String	B\_PRODPLAN.LIEFNR (the getraceten Batch)
`siALLEURLAENDERAUFTRCOLPROAUFTRAG`	String	All Urländer from B\_AUFTRCOL per order
`siALLEURLAENDERPROAUFTRAG`	String	All Urländer from the Reservierungen/Tracing (B\_PRODPLAN) per order
`siALLEBOTANISCHPROAUFTRAG`	String	All botanischen names the Article (B\_ARTIKEL) per order
`siALLEGATGRPBOTANISCHPROAUFTRAG`	String	All botanischen names the Gattungsgruppen per order
`siLIEFALLELAENDERPROAUFTRAG`	String	All countries of the Suppliers from B\_AUFTRCOL per order
`siALLEURLAENDERPROAUFTRAGISO`	String	All Urländer from the Reservierungen/Tracing (B\_PRODPLAN) per order im ISO-Code
`siALLEURLAENDERAUFTRCOLPROAUFTRAGISO`	String	All Urländer from B\_AUFTRCOL per order im ISO-Code
`siLIEFALLELAENDERPROAUFTRAGISO`	String	All countries of the Suppliers from B\_AUFTRCOL per order als ISO-Code
`siALLEURLAENDERAUFTRCOLPROKUNDE`	String	All Urländer from B\_AUFTRCOL per customer
`siALLEURLAENDERPROKUNDE`	String	All Urländer from the Reservierungen/Tracing (B\_PRODPLAN) per customer
`siALLEBOTANISCHPROKUNDE`	String	All botanischen names the Article (B\_ARTIKEL) per customer
`siALLEGATGRPBOTANISCHPROKUNDE`	String	All botanischen names the Gattungsgruppen per customer
`siLIEFALLELAENDERPROKUNDE`	String	All countries of the Suppliers from B\_AUFTRCOL per customer
`siALLEURLAENDERPROKUNDEISO`	String	All Urländer from the Reservierungen/Tracing (B\_PRODPLAN) per customer im ISO-Code
`siALLEURLAENDERAUFTRCOLPROKUNDEISO`	String	All Urländer from B\_AUFTRCOL per customer im ISO-Code
`siLIEFALLELAENDERPROKUNDEISO`	String	All countries of the Suppliers from B\_AUFTRCOL per customer als ISO-Code
`siARTICLE_COLOUR`	String	Artikelfarbe from B\_ARTIKEL or the translation from B\_KONVERT
`siPRODUCT_TYPE`	String	Produkttyp from B\_ARTIKEL or the translation from B\_KONVERT
`siFRACHTZ`	String	freight zone from B\_AUFTRAG
`siFRACHTZBEZ`	String	freight zone Long description from B\_FRACHTZ
`siAUFTRCOL_TIMEST`	String	B\_AUFTRCOL.TIMEST
`nTOURID_TRACED_TRAYS`	Number	Getracete Trays per Tourid on loading list Location
`nKUNDE_TRACED_TRAYS`	Number	Getracete Trays per customer on loading list Location
`nAUFTRAG_TRACED_TRAYS`	Number	Getracete Trays per order on loading list Location
`nKNDLAD_TRACED_TRAYS`	Number	Getracete Trays per Kndlad on loading list Location
`nKOMMISSION_TRACED_TRAYS`	Number	Getracete Trays per Consignment on loading list Location
`nVARIANTE_TRACED_TRAYS`	Number	Getracete Trays per Product form on loading list Location
`nGESAMT_TRACED_TRAYS`	Number	Getracete Trays per loading list on loading list Location

/

39.1.1.2 Variables

svRES_CHARGENNR1, svRES_STANDORT1, svRES_TEXT1, nvRES_MENGE1, nvRES_TRAYANZ1, svRES_QUALITAET1, svRES_QUALITAETTEXT1, svRES_IDENTNR1, nRES_PRKW1, dRES_PRDATUM1, svRES_CHARGENNR2, svRES_STANDORT2, svRES_TEXT2, nvRES_MENGE2, nvRES_TRAYANZ2, svRES_QUALITAET2, svRES_QUALITAETTEXT2, svRES_IDENTNR2, nRES_PRKW2, dRES_PRDATUM2, svRES_CHARGENNR3, svRES_STANDORT3, svRES_TEXT3, nvRES_MENGE3, nvRES_TRAYANZ3, svRES_QUALITAET3, svRES_QUALITAETTEXT3, svRES_IDENTNR3, nRES_PRKW3, dRES_PRDATUM3, svRES_CHARGENNR4, svRES_STANDORT4, svRES_TEXT4, nvRES_MENGE4, nvRES_TRAYANZ4, svRES_QUALITAET4, svRES_QUALITAETTEXT4, svRES_IDENTNR4, nRES_PRKW4, dRES_PRDATUM4, svRES_CHARGENNR5, svRES_STANDORT5, svRES_TEXT5, nvRES_MENGE5, nvRES_TRAYANZ5, svRES_QUALITAET5, svRES_QUALITAETTEXT5, svRES_IDENTNR5, nRES_PRKW5, dRES_PRDATUM5, svRES_CHARGENNR6, svRES_STANDORT6, svRES_TEXT6, nvRES_MENGE6, nvRES_TRAYANZ6, svRES_QUALITAET6, svRES_QUALITAETTEXT6, svRES_IDENTNR6, nRES_PRKW6, dRES_PRDATUM6

• ........ and the ganze bis xxx10 ......................
• nvRES_LFKW1 - nvRES_LFKW10
• nvRES_PROZSAATAUFSCHLAG1 - nvRES_PROZSAATAUFSCHLAG10
• svRES_LIEFNR1 - svRES_LIEFNR10
• svRES_REGISTRATION_NUMBER1 - svRES_REGISTRATION_NUMBER10
• svRES_INITIAL_REGISTRATION_NUMBER1 - svRES_INITIAL_REGISTRATION_NUMBER10
• Container Informationen ( PAT_CONTAINER )
• svKND_CONT_ALLINFO ( informationen ) svTOUR_CONT_ALLINFO
• nvKND_CONT_WAGANZ ( number Container ) nvTOUR_CONT_WAGANZ
• nvKND_CONT_LAGEN ( Number of shelves )
• nvTOUR_CONT_LAGEN ( Number of shelves )
• nvKND_CONT_BRETTER ( number the Bretter NICHT AKTIV )
• nvTOUR_CONT_BRETTER ( Number of shelves )
• nvKND_CONT_LAGEN ( number the Aufsetzer )
• nvTOUR_CONT_LAGEN ( number the Aufsetzer ) sFL_GPREIS svFL_LFGARANTIE
• svCERTIFICATE_NO1..n from CERTIFICATES
• svAPPROVAL_MARK1..n from CERTIFICATES
• svCERTIFICATE_USAGE_ID1..n from CERTIFICATES
• svCERTIFICATE_CATEGORY_ID1..n from CERTIFICATES
• svCERTIFICATE_AUTONOMOUS_ID1..n from CERTIFICATES
• svFUND_AGENCY_NO11..n from CERTIFICATES
• svFUND_AGENCY_NO21..n from CERTIFICATES
• svCERTIFICATE_BASIC_MATERIAL_ID1..n from CERTIFICATES
• svALTITUDE1..n from CERTIFICATES
• svREIFEJAHR1..n from CERTIFICATES
• svBAUMSCHULALTER1..n from CERTIFICATES
• svVERWENDUNG1..n from CERTIFICATES
• svAUTOCHTHONIE1..n from CERTIFICATES
• svAM1..n from CERTIFICATES
• svKATEGORIE1..n from CERTIFICATES
• svREGISTERZEICHEN1..n from CERTIFICATES
• svVERMEHRUNGSGUTART1..n from CERTIFICATES
• svURSPRUNG1..n from CERTIFICATES
• svSONDERHERKUNFT1..n from CERTIFICATES
• svZUSATZINFO1..n from CERTIFICATES
• svWG1..n from CERTIFICATES
• svHL1..n from CERTIFICATES
• svHERKUNFT1..n from CERTIFICATES
• svCERTIFICATE_AUTOCHTHONOUS_ID1..n from CERTIFICATES
• svPROPAGATION_MATERIAL_TYPE_ID1..n from CERTIFICATES
• svREGISTRATION_NO1..n from CERTIFICATES
• svCERTIFICATE_ORIGIN_ID1..n from CERTIFICATES
• svGROWING_REGION_NAME1..n from CERTIFICATES
• svGROWING_REGION_ID1..n from CERTIFICATES
• nvPOSSIBLE_GENETIC_MODIFICATON1..n from CERTIFICATES
• nvEVG1..n from CERTIFICATES
• nvYEAR_OF_HARVEST1..n from CERTIFICATES
• nvYEAR_OF_SOWING1..n from CERTIFICATES
• nvYEAR_OF_POTTING1..n from CERTIFICATES
• nvYEAR_OF_CUTTING1..n from CERTIFICATES | Name | Type | Content | |---|---|---| | A_DATUM | String | Label for Order date | | ARTIKELBEZ | String | Label for Article description | | ARTIKELNR | String | Label for Article number | | AUFTRAG | String | Label for order | | AUFTRAGNR | String | Label for Order number | | bALLES | String | | | bBREAKGROUPAUFTRAG | String | formula for Breakgroup for neuem order | | bBREAKGROUPKOMMISSION | String | formula for Breakgroup for neuer Consignment | | bBREAKGROUPKUNDE | String | formula for Breakgroup for neuem customers | | bBREAKGROUPORDER | String | formula for Breakgroup for neuer Ordernummer | | bBREAKGROUPVARIANTE | String | formula for Breakgroup for neuer Product form | | bBREAKGROUPWARENGRP | String | formula for Breakgroup for neuer product group | | bBREAKGROUPKNDLAD | String | formula for Breakgroup for neuer Kndlad | | bDebug | String | formula for Anzeige only im Debug-Modus | | BEZ_FIRMA | String | Label for company | | BEZ_ORDERNR | String | Label for Ordernummer | | BEZ_PFLANZEN | String | Label for Pflanzen | | bPAGEBREAKAUFTRAG | String | formula for Seitenumbruch for neuem order | | bPAGEBREAKKOMMISSION | String | formula for Seitenumbruch for neuer Consignment | | bPAGEBREAKKUNDE | String | formula for Seitenumbruch for neuem customers | | bPAGEBREAKORDER | String | formula for Seitenumbruch for neuer Ordernummer | | bPAGEBREAKTOUR | String | formula for Seitenumbruch for neuer Tour | | bPAGEBREAKVARIANTE | String | formula for Seitenumbruch for neuer Product form | | bPAGEBREAKWARENGRP | String | formula for Seitenumbruch for neuer product group | | bPAGEBREAKKNDLAD | String | formula for Seitenumbruch for neuer product group | | GATGRP | String | Label for article group | | GEDR_AM | String | Label for „gedruckt am" | | GEPACKT | String | Label for gepackt | | GESAMTSUMME | String | Label for grand total | | KNDSUMME | String | Label for Kundensumme | | KOMMISSION | String | Label for Consignment | | KUNDE | String | Label for customer | | KUNDEN_TEL | String | Label for customer phone number | | KUNDENNR | String | Label for Customer number | | KW | String | Label for Delivery week | | LF_DATUM | String | Label for delivery date | | LL_INFO | String | Label for Ladelisteninformation | | LL_TITEL | String | Label for loading list | | MENGE | String | Label for Quantity (maintenance/Reporttexte) | | nAUFTRAGMENGE | Number | order quantity | | nGESAMTMENGE | Number | Total quantity | | nKOMMISSIONMENGE | Number | Quantity per Consignment | | nKUNDEMENGE | Number | Quantity per customer | | nTOURMENGE | Number | Quantity per Tour | | nTOURPOS | Number | Tourreihenfolge (Tourposition) | | nVARIANTENMENGE | Number | Quantity je Product form | | nvGEWARTIKEL | Number | Weight of the Artikels | | nvGEWPRDHLFNR | Number | Weight of the Produktionshilfsmittels | | nvLEITKARTEN | Number | number Leitkarten | | nvSTDVKSUM | Number | Standardverkaufsumme (order currency) | | nvVOLUMEN | Number | Volumen | | nvVPANZ | Number | number packages | | R_MENGE | String | Label for Restmenge | | sANREDE | String | | | sAUFTRAGVERPACKMENGE | String | type and number packages je order | | sDANREDE | String | salutation Depot | | sDEPOTNR | String | Depot-Customer number | | sDKNDKBZ | String | Depot-Customer short name | | sDLAND | String | Depot-country | | sDNAME1 | String | Depot-Name1 | | sDNAME2 | String | Depot-Name2 | | sDORT | String | Depot-city | | sDPLZ | String | Depot-postal code | | sDPOSTFACH | String | Depot-P.O. box | | sDSTRASSE | String | Depot-street | | sDZH | String | Depot zu attention | | SEITE | String | Label for Page | | sEMAIL | String | | | sFAX | String | | | sFL_LIEFERDIREKT | String | flag "Supplier liefert zum customers" from the order | | sGESAMTVERPACKMENGE | String | Type and number of packages in total | | sHANDY | String | | | sKNDKBZ | String | | | sKOMMISSIONVERPACKMENGE | String | type and number the packages je Consignment | | sLAND | String | | | sLIEFER_ANREDE | String | | | sLIEFER_FAX | String | | | sLIEFER_HANDY | String | | | sLIEFER_KNDNR | String | | | sLIEFER_LAND | String | | | sLIEFER_NAME1 | String | | | sLIEFER_NAME2 | String | | | sLIEFER_ORT | String | | | sLIEFER_ORTSTEIL | String | | | sLIEFER_PLZ | String | | | sLIEFER_POSTFACH | String | | | sLIEFER_STRASSE | String | | | sLIEFER_TELEFON | String | | | sLIEFER_ZH | String | | | sLIEFERNR | String | supplier number | | sLNAME2 | String | | | sNAME1 | String | | | sNAME2 | String | | | sORT | String | | | sORTSTEIL | String | | | sPLZ | String | | | sPOSTFACH | String | | | sSTRASSE | String | | | sTELEFON | String | | | sTOURINFO | String | | | sTOURVERPACKMENGE | String | type and number the packages je Tour | | SUMME | String | Label for sum | | sVARIANTENVERPACKMENGE | String | type and number the packages je Product form | | sVATER_ANREDE | String | | | sVATER_FAX | String | | | sVATER_HANDY | String | | | sVATER_KNDNR | String | | | sVATER_LAND | String | | | sVATER_NAME1 | String | | | sVATER_NAME2 | String | | | sVATER_ORT | String | | | sVATER_ORTSTEIL | String | | | sVATER_PLZ | String | | | sVATER_POSTFACH | String | | | sVATER_STRASSE | String | | | sVATER_TELEFON | String | | | sVATER_ZH | String | | | sVATERAUFTRNR | String | | | svAVISIEREN | String | flag Advance notice | | svFL_CHEP | String | flag Cheppalette | | svFL_FIXTERMIN | String | flag Fixtermin | | svGEWEH | String | weight unit | | svGRUNDEINHEIT | String | Grundeinheit | | svKATALOG | String | Katalogkennzeichen | | svPRODHMITTELBEZ | String | production aid name | | svRKNDNR | String | Invoice customer number | | svZAHLART | String | payment method | | sWARENGRP | String | product group | | sZH | String | | | TOUR | String | Label for Tour | | TRANSMIT | String | Label for Means of transport | | VARIANTE | String | Label for Product form | | VARKOMMISSION | String | | | VERPACKUNG | String | Label for packaging | | VERTRETERNR | String | Label for sales representative number | | dvVALUTADATUM | Date/Time | value date from the order | | svBARCODE | String | Barcode from B_ARTFORM | | svMATERIALNR | String | Materialnr from B_ARTFORM | | svKUNDELADELISTINFO | String | LADELISTINFO from B_KNDSTAMM | | nvBOXEN_TOUR | Number | Calculated Quantity the boxes from the Verpackungsmodul per TourID | | nvBOXEN_AUFTRAG | Number | Calculated Quantity the boxes from the Verpackungsmodul per order | | nvBOXEN_KNDNR | Number | Calculated Quantity the boxes from the Verpackungsmodul per KundenvBOXEN_KOMMISSION | | nvBOXEN_KOMMISSION | Number | Calculated Quantity the boxes from the Verpackungsmodul per Consignment | | svKBESTNR | String | Customer order number from the order | | svTOURLANDBEZ | String | country name Tour | | All NAME2 also NAME3! | | | | All LAND also LANDBEZ | | | | svSTDWAEHRUNG | String | | | nvRABATT | Number | | | nvRABATT2 | Number | | | svR_EDIFACTKUNDE | String | If (B_KNDFIRMA.FL_EXCLUDE_EDI_RE = N or _) and B_KNDGRP_EIGENSCH.FL_REELEKT = 'J' is these Variable on + gesetzt. | | svTOURSERVICE | | | | svTOURLADEHILFSMITTEL | | | | svTOURABHOLTAG | | | | svTOURANLIEFERTAG | | | | dvTOURABHOLZEIT | | | | nvETMENGE | Number | Label quantity | | nvBETRAG_ETIKETTE | Number | Etikettenbetrag in the line | | nvETPMENGE | Number | Label price quantity | | nvETPREIS | Number | Label price | | nvPOSSUM_ETIKETTE | Number | Label quantity | | dvTOURANLIEFERZEIT | | | | dvAUFTR_LFDATUM | Date/Time | delivery date of the order | | svAUFTR_BEAANG_NAME | String | name user the Auftrages | | svPRODHMITTELBEZ | String | Produktionshilfsmittelbezeichnungder | | svPRODTEXT | String | Prodtext from B_AUFTRCOL | | svTEXT2 | String | TEXT2 from B_AUFTRCOL | | svFL_ERSATZ | String | flag Ersatzsorte from B_AUFTRCOL | | svLAGERNR | String | Lagernummer from B_ARTFORM | | sKNDLADVERPACKMENGE | String | sum Tray quantity per Kndlad per Prdhlfnr | | nKNDLADMENGE | Number | Sum quantity per Kndlad | | svFRACHTINFO1 | String | Frachtinfo1 from Tour-info (B_TOURID) | | dvPartnerLieferDatum | Date | delivery date +/- Liefervorlauf | | nvPartnerLieferTag | Number | delivery day (delivery date +/- Liefervorlauf) | | nvPartnerLieferWoche | Number | Delivery week (delivery date +/- Liefervorlauf) | | nvPartnerLieferJahr | Number | Lieferjahr (delivery date +/- Liefervorlauf) | | svLIEFALLELAENDER | String | All countries of the Suppliers from B_AUFTRCOL | | svALLEBOTANISCH | String | All botanischen names of the Artikels from B_ARTIKEL | | svALLEURLAENDER | String | All Urländer the Ausgangschargen (Res. or Tracing) | | svALLEURLAENDERAUFTRCOL | String | All Urländer from B_AUFTRCOL | | svALLEGATGRPBOTANISCH | String | All botanischen names the Gattungsgruppen (from B_GATGRP) | | svPZ_CODES | String | PZ Codes: Sucht with Lieferland + Gatgrp (gefüllt or ---) + Code_Anweisung = PZ_LL in B_HAFTUNGSAUSSCHLUSS_MATRIX and gives the text zurück. All gefundenen texts are Kommagetrennt together gefügt | | svALLEURLAENDERISO | String | All Urländer the Ausgangschargen (Res. or Tracing) im ISO-Code | | svALLEURLAENDERAUFTRCOLISO | String | All Urländer from B_AUFTRCOL im ISO-Code | | svPFLPASSNR | String | plant passport number from B_KONVERT with Projekt = 'SERVICE', Switch = 'SERVICE', IN_1 = Service Code, OUT = plant passport number. If leer or not found plant passport number from B_FIRMA | | svLIEFALLELAENDERISO | String | ISO-country of the Suppliers, if B_FORM.COUNTRYSOURCE = 'SUPPLIER' or leer, otherwise ISO country of the Standorts B_AUFTRCOL.STANDORT->B_HAUS.LAND) | | svRKNDPFLPASSNR | String | plant passport number of the invoice customers from the customer-company master | | svKNDPFLPASSNR | String | plant passport number of the Lieferkunden from the customer-company master | | svKNDKENNUNG1 | String | Kennung1 from the customer master | | svKNDKENNUNG2 | String | Kennung2 from the customer master | | ovQRAUFTRNRTOURIDIMAGE | Object | Object Variable for QR Code Auftrnr + Tourid wobei A and - weggelassen are | | ovQRTOURIDIMAGE | Object | Object Variable for QR Code Tourid wobei - weggelassen is | | ovQRKNDNRTOURIDIMAGE | Object | Object Variable for QR Code Kndnr + Tourid wobei - weggelassen is |

/

39.1.1.2.1 Boxnummern from Außen- and Innenkartons

• Firmeneinstellung -> Sonstige -> Boxnummern on loading list show**
• svOuterBoxNumbers - String - Sortierte List the Außenkartons with the Article
• svInnerBoxNumbers - String - Sortierte List the Innenkartons with the Article

40 Report Variables: Customer Packing List

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

40.1 Report Variables: Customer Packing List

**Note:** The variable descriptions were translated from the German wiki with a glossary (machine-assisted); where a description is unclear check the German variable name and the original wiki text.

40.1.1 Kundenpackliste (PACK_KUNDE.qrp)

Wichtige Hinweise:

folgende Settings:

• VAL_bPL_TOURPOS Anzeige Tourposition
• VAL_bPL_KBESTNR Anzeige Customer order number
• VAL_bPL_AUFTRNR Anzeige with KNDLAD and DEPOTNR

40.1.1.1 Input Items

• siLNAME3 -> B_auftrag.LNAME3
• siLNAME2 -> B_AUFTRAG.LNAME2
• siLANREDE -> B_AUFTRAG.LANREDE
• siLZH -> B_AUFTRAG.LZH
• siLPOSTFACH -> B_AUFTRAG.LPOSTFACH

<thead></thead><tbody></tbody>

Name	Type	Content
`BEZ`	String
`GATGRPBEZ`	String	Gattungsgruppenbezeichnung
`GESVERPACKMENGE`	String
`GRUPPE`	String
`KNDKBZ`	String	Customer short name
`KNDNR`	String	Customer number
`KNDVERPACKMENGE`	String
`KW`	String	Kalenderwoche
`LIEFERDAT`	Date/Time
`MCODE`	String
`nGESVE`	Number
`niTOURPOS`	Number
`nKNDVE`	Number
`nMENGE`	Number
`NVE`	Number
`sGATGRP`	String
`siKBESTNR`	String
`sKOPFTEXT`	String
`sLADLISTINFO`	String
`sLFINFO`	String
`sLLAND`	String
`sLNAME1`	String
`sLORT`	String
`sLPLZ`	String
`sLSTRASSE`	String
`SORTE`	String
`TOURBEZ`	String
`TOURID`	String
`TOURNR`	String
`TRANSMITTEL`	String
`VERPACKMENGE`	String
`siLORTSTEIL`		LIEFER DATEN
`siDEPOTNR`		DEPOT DATEN
`siDKNDKBZ`		DEPOT DATEN
`siDANREDE`		DEPOT DATEN
`siDNAME1`		DEPOT DATEN
`siDNAME2`		DEPOT DATEN
`siDNAME3`		DEPOT DATEN
`siDSTRASSE`		DEPOT DATEN
`siDLAND`		DEPOT DATEN
`siDLANDBEZ`		DEPOT DATEN
`siDPLZ`		DEPOT DATEN
`siDORT`		DEPOT DATEN
`siDZH`		DEPOT DATEN
`siDPOSTFACH`		DEPOT DATEN
`siDORTSTEIL`		DEPOT DATEN
`siDTELEFON`		DEPOT DATEN
`siDHANDY`		DEPOT DATEN
`siDFAX`		DEPOT DATEN
`siDEMAIL`		DEPOT DATEN
`niCC`	Im Detailblock	number the CC Container
`niLagen`	Im Detailblock	Number of shelves incl Container
`niPaletten`	Im Detailblock	number the pallets
`niKartons`	Im Detailblock	number the Kartons
`niRCC`	Im Report Footer	number the CC Container gerundet
`niRLagen`	Im Report Footer	Number of shelves incl Container gerundet
`niRPaletten`	Im Report Footer	number the pallets gerundet
`niRKartons`	Im Report Footer	number the Kartons gerundet
`niCCUeberKunde`	Number	sum Containers per customer gerundet
`niLagenUeberKunde`	Number	sum shelves per customer gerundet
`niPalettenUeberKunde`	Number	sum pallets per customer gerundet
`niKartonsUeberKunde`	Number	sum Kartons per customer gerundet

40.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content
`ARTIKELBEZ`	String
`ARTIKELNR`	String
`BEZ_FIRMA`	String
`BEZ_PFLANZEN`	String
`GATGRP`	String
`GEDR_AM`	String
`GEPACKT`	String
`GESAMTSUMME`	String
`KNDSUMME`	String
`KOMMISSION`	String
`KUNDE`	String
`LF_DATUM`	String
`MENGE`	String	Label for Quantity (maintenance / Reporttexte)
`PL_INFO`	String
`PL_TITEL`	String
`R_MENGE`	String
`sANREDE`	String
`SEITE`	String
`sEMAIL`	String
`sFAX`	String
`sHANDY`	String
`sLAND`	String
`sLNAME2`	String
`sNAME1`	String
`sNAME2`	String
`sORT`	String
`sORTSTEIL`	String
`sPLZ`	String
`sPOSTFACH`	String
`sSTANDORT`	String
`sSTRASSE`	String
`sTELEFON`	String
`sTOURINFO`	String
`SUMME`	String
`sZH`	String
`TOUR`	String
`TRANSMIT`	String
`VARIANTE`	String
`VERPACKUNG`	String
`svBARCODE`	String	Barcode from B\_ARTFORM
`svMATERIALNR`	String	Material number from B\_ARTFORM
`svGATGRPBOTNAME`	String	Botanical name of the article group
`svTOURSERVICE`	String	Service (B\_TOURID)
`svTOURLADEHILFSMITTEL`	String	Tour Ladehilfsmitten (B\_TOURID)
`svTOURABHOLTAG`	String	Tour pickup day (B\_TOURID)
`svTOURANLIEFERTAG`	String	Tour delivery day (B\_TOURID)
`dVERSANDTAG`	date	Tour shipping day (B\_TOURID)
`dvTOURABHOLZEIT`	date	Tour Abholzeit with date (B\_TOURID)
`svABHOLZEIT`	String	Tour Abholzeit only Zeit (B\_TOURID)
`dvTOURANLIEFERZEIT`	date	Tour Anlieferzeit with date (B\_TOURID)
`svANLIEFERZEIT`	String	Tour Anlieferzeit only Zeit (B\_TOURID)
`sKTEXT`	String	B\_KNDSTAMM.KTEXT (field tab Sonstiges-> Kundenbezogener text on delivery note and order confirmation)

41 Report Variables: Delivery List LIEF01

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

41.1 Report Variables: Delivery List LIEF01

**Note:** The variable descriptions were translated from the German wiki with a glossary (machine-assisted); where a description is unclear check the German variable name and the original wiki text.

41.1.1 verschiedene Lieferlisten ( LIEFERLISTE LIEFTRACE ... )

LFARTSUM.QRP, LFKNDFM.QRP, LIEFTRACExxx.QRP, QUALTRACExxx.QRP

xxx = FirmenNummer

41.1.1.1 Allgemeine variables

Sind for allen reports in the Lieferliste wo ein customer available is

• svKINFO cfKunde.sKINFO)
• svKTEXT cfKunde.sKTEXT

41.1.1.2 Input Items

ARTKBZ, ARTNR, AUFTRDAT, AUFTRNR

• AUSFORM String
• AUSMENGE Number
• BEZ String FIRMNR, FORM, GATGRP, GATGRPBEZ, KNDKBZ, KNDLAD, KNDNR, KOMMISION, KW, LFDATUM, LFJAHR, LFKW, LIEFNR, LLAND, LNAME1, LNAME2, LORT, LPLZ, LSTRASSE, MCODE, MENGE, PRDHLFNR, siKBESTNR, sKNDNRLAD, sKOPFTEXT
• sLADLISTINFO (from b_auftrag) sLFINFO, SORTE, TOURNR, niCC
• niLagen ( im DetailBlock ) niPaletten niKartons
• niTOURPOS (only for List with Tour without Tracinginformationen)
• siAUFTRTIMEST (only for LIEFTRACEXX.qrp)

41.1.1.3 Variables

nVPEH, sANREDE, sDANREDE, sDEPOTNR, sDKNDKBZ, sDLAND, sDNAME1, sDNAME2, sDORT, sDPLZ, sDPOSTFACH, sDSTRASSE, sDZH, sEMAIL, sFAX, sHANDY, sHAUPTVATER, sKNDKBZ, sLAND, sNAME1, sNAME2, sORT, sORTSTEIL, sPLZ

• svLADELISTINFO (from b_kndstamm) sPOSTFACH, sSTANDORT, sSTRASSE, sTELEFON, sVARIANTE, sWARENGRP, sZH, sVARIANTENBEZ
• svVERSART = Versantart
• svPRDHLFNRBEZ production aid description
• svAFCTEXT text from B_AUFTRCOL
• svAFCTEXT2 Text2 from B_AUFTRCOL
• svZAHLART payment method from Table: B_ZAHLART Column: ZAHLART
• svZAHLART_BEZ payment method description from Table: B_ZAHLART Column: BEZ _ Fuer the Chargenreservierungen . Die variables are from xxx1 bis xx10 immer gleich _
• svRES_CHARGENNR1 ... svRES_CHARGENNR10 svRES_STANDORT1
• svRES_TEXT1 ( texts the Batches ) nvRES_MENGE1, nvRES_TRAYANZ1, svRES_QUALITAET1, svRES_QUALITAETTEXT1, svRES_IDENTNR1, nRES_PRKW1, dRES_PRDATUM1, dRES_LFDATUM1
• svRES_REGISTRATION_NUMBER (B_PROD_REGISTRATION.BATCH_NO = B_PRODPLAN.CHARGENNR)
• svRES_INITIAL_REGISTRATION_NUMBER (B_PROD_REGISTRATION.BATCH_NO = B_PRODPLAN.CHARGENNR)

41.1.1.4 Pagebreak variables

bPAGEBREAKKUNDE, bPAGEBREAKKNDLAD, bPAGEBREAKDEPOT, bPAGEBREAKAUFTRAG

/ Die variables gelten only for folgende Reports

• List with Tour and customers / Consignment
• List with Tour and customers / Consignment and Customer order number
• List with Tour and customers / Consignment and Customer order number - Tracing Informationen
• Lieferliste Kompakt (Qualität) Tracing Informationen

42 Report Variables: Purchase Order

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

42.1 Report Variables: Purchase Order

**Note:** The variable descriptions were translated from the German wiki with a glossary (machine-assisted); where a description is unclear check the German variable name and the original wiki text.

42.1.1 BESTELLUNG.QRP

Für jeden Suppliers can eine eigener Report in the Stammdaten hinterlegt are unter Stammdaten/Lieferantenstamm/Eigenschaften.

• E-Mail Attachment name
• Der names of the E-Mail Anhangs can translated are. Stammdaten -> Allgemeines -> translations: field Typ = BESTELLUNG, field short name = ---, field language = language of the Suppliers, field translation = translation
• Sorting Sortierungen _ external Sorting _

KEY = REPBESTELLORDER. z.b B_BESTCOL.KOMMISION,B_BESTCOL.ARTKBZ

• Setting im Firmenstamm->purchase order->Bestellreport: Angelieferte not drucken. Ist the Setting ticked, bewirkt es, dass angelieferte lines the purchase order not on the Report gedruckt are. Mitunter can es then vorkommen, dass ein leerer Report gedruckt is, if the gesamte purchase order bereits angeliefert wurde. Unvollständige Listen
• Stornierte lines are in jedem Fall printed

42.1.1.1 Input Items

sBESTNR, sVONAUFTRNR, sFIRMNR, sLIEFNR, sLIEFKBZ, sRLIEFNR, sLIEFGRP, sSTATUS, sKNDNR, dBESTDATUM, sBESTART, sZAHLART, sFRACHTZ, sVERSART, sTOURNR, nSTAFFMENGE, nPFRACHTPR, sARTEINGANG, sVERTRNR, sKONTAKT, sKNDLAD, sLNAME1, sLNAME2, sLLAND, sLPLZ, sLSTRASSE, sLPOSTFACH, sLORT, sLORTSTEIL, sPREISGRP, niRABATTHEADER, nZUSCHLAG, sOLDKNDNR, sWAEHR, nAMENGE, nPREISS, nPROV, sLANREDE, sLZH, sLUIDNR, sRANREDE, sRZH, sRNAME1, sRNAME2, sRLAND, sRPLZ, sRORT, sRSTRASSE, sRPOSTFACH, sAFORDER, sRORTSTEIL, lHEADINFO, lFUSSINFO, sLIEFAUFTRNR, sANLNR, sGATGRP

• sARTKBZ (possible translate through Artland) dEINGDAT, nMENGE, nSTDEKPREIS, sKOMMISION, sSTDWAEHR, nFIREKPREIS, nBESTMENGE, sARTNR, nALTBESTMENGE, sFIRWAEHR, nGNDMENGE, nSTDEKSUM, nFIREKSUM, sPRDHLFNR, nPMENGE, sPEH, sFORM, sAUSFORM, nLFKW, nMWST, nFIRLIZPREIS, nFIRLIZPROSTK, nAUSMENGE, nLFJAHR, nLIZPREIS, nLIZPROSTK, nRABATT, nAUSMENGANZ, nZUSCHLAG, sAUSPRDHLFNR, dLFDATUM, nFRACHTPREIS, sVERPACK, nVERPACKPREIS, nVPEH, nFIRFRACHTPREIS, nVPELAGE, nLAGEWAG, nKARTPAL, nFIRVERPACKPREIS, nVPEKART, nPFLANZ, sTEXT, nSKTAGE, nSKPROZ, nFIRZUSCHL, siTOURNR_COL, sGEBART, sLFMEEH, sPRMEEH, sRECHNR, sBUGRUPPE, nGEWTARA, nGEWNETTO, nGEWSTUECK, sLLIEFNR, nPVPEH, sORDERNR, sCHARGENNR, nMINMEZSWERT, nGNDPREIS, sMCODE, nAUSFALL, nGEWICHT, nTOPFGR, nHOEHE, sFIRMAARTKBZ, sLANDPOSTORT, sLPO, sTOURBEZ, sZAHLARTBEZ, sVERTBEZ, sVERTNAME1
• sVERTNAME2, sVERTFAX sVERTTEL
• sPRDHLFNRBEZ (possible translate through translations), sSORTE
• sGATGRPBEZ (possible translate through Artland) sLANDBEZ, sANREDE, sZH, sNAME1, sNAME2, sLAND, sPLZ, sSTRASSE, sPOSTFACH, sORT, sORTSTEIL, sTELEFON, sFAX, lINFOTEXT, siBESTCOLSTATUS, siBE_STATUS, siANGELEGT, siGEAENDERT, diGEANDERTDATUM, siFL_GEAENDERTHEADER
• siFL_GEAENDERTCOLUMN if Column heute changed wurde liLIEFLADELISTINFO
• niLWEKPREIS Einkaufspreis in Lieferantenwährung (STDVKPREIS hat the gleiche Currency wie FIRVKPREIS) siLWWAEHR, siTOURBEZ_COL, niPREISRABATT1, siINTERNTEXT, siBEAANG
• siALTERNAME (Botanical name of the article) siKENNUNG
• siBESTTIMEST ( if the line already angeliefert wurde) niFREMDMENGE, niFREMDPMENGE, siFREMDEH, niLWFREMDEK, siKNDNR_LIEFERANT
• siARTICLE_COLOUR (from B_ARTIKEL or translation from B_KONVERT)
• siPRODUCT_TYPE (from B_ARTIKEL or translation from B_KONVERT)
• siARANR (of the Suppliers)
• sGATGRPBOTAN botanical name the Gatgrp (possible translate through Artland)
• siGATGRPBEZ_TRANS Gatgrp Bez. translation (from Translations Table)
• siGATGRPBOT_TRANS Gatgrp botanischer name translation (from Translations Table) siLIEFERANT_EMAIL, siLIEFERANT_EMAILCC, siLIEFERANT_EMAILBCC, siLIEFERANT_SERIENDR_EMAIL, siLIEFERANT_SERIENDR_EMAILCC, siLIEFERANT_SERIENDR_EMAILBCC

42.1.1.2 Variables

<thead></thead><tbody></tbody>

Name	Type	Content		Quelle
svMATERIALNR	String	material number		B\_ARTFORM
svVATERAUFTRNR	String	Anzeige the Vateraufragsnummer
svBEAANG\_NAME	String	name the Angelegtbearbeiters the first position
svTOURNR	String	Tour number from the order		B\_AUFTRAG
svDEPOTNR	String	Depotnummer from the order		B\_AUFTRAG
svDEPOTKBZ	String	Depot short name		B\_AUFTRAG
svDEPOTPLZ	String	Depot postal code		B\_AUFTRAG
svUSER	String	Windows User
sB\_KOPF1	String	Kopftext1 purchase order
sB\_KOPF2	String	Kopftext2 purchase order
sLLANDBEZ	String	Länderbezeichnung long (delivery address)		B\_LAND
sRLANDBEZ	String	Länderbezeichnung long (invoice address)		B\_LAND
svBARCODE	String	Barcode		ZUSBARCODE from B\_ARTFORM
sFL\_BIO	String	flag BIO		FL\_BIO from B\_ARTFORM
nvMENGE\_MEH	Number	Quantity in Mengeneinheit for Gewichtsberechnung		MENGE\_MEH from B\_ARTFORM
svMENGEN\_EH	String	Mengeneinheit for Gewichtsberchnung		MENGEN\_EH from B\_ARTFORM
nvMENGE\_GEH	Number	Quantity in weight unit for Gewichtsberechnung		MENGE\_GEH from B\_ARTFORM
A\_DATUM	String	TEXT Order date
L\_DATUM	String	text delivery date
R\_DATUM	String	text invoice date
svGEWICHT\_EH	String	weight unit for Gewichtsberechnung		GEWICHT\_EH from B\_ARTFORM
sVARIANTEBEZ	String	Variantenbezeichnung (possible zu translate through translations)		KBZ from B\_FORM
svLARTNR	String	Lieferantenartikelnummer		Lieferantenartikelnummer from B\_ARTLIEF
svLARTKBZ	String	Lieferantenartikelbezeichnung		Lieferantenartikelbezeichnung from B\_ARTLIEF
svLFORM	String	Lieferantenvariante		Lieferantenvariante from B\_ARTLIEF
sLBUNDESSTAAT\_LANG	String	Liefer-federal state Lang		B\_BESTHEAD.LBUNDESSTAAT long

42.1.1.2.1 formula for the 1000 Korn Weight on the Report

NumberIFF( nvMENGE_MEH, 0, 0, ((nvMENGE_GEH/nvMENGE_MEH) * 1000))

42.1.1.3 variables for Bestellungen from Aufträgen

svVATERAUFTRNR, svDEPOTNR, svDEPOTKBZ, svDEPOTPLZ, svTOURNR, svKEBSTNR

svAF_AUFTRINFO (Lieferscheinfuss from the Auftragskopf)

svAF_LFINFO (Liferscheinkopftext from order)

svAF_LADLISTINFO (Ladelisteninformation)

svAF_KOPFTEXT (header text from auftrag)

svAF_VERTNR (sales representative from Auftragskopf)

nv_AF_PFRACHTPR (Freight lump sum from Auftragskopf)

svAFC_TEXT (text from order line)

svAFC_KOMMISION (Consignment from order line)

nv_AFC_STDVKPREIS (sales price from order line)

sv_AFC_STDWAEHR (Kundenwährung from order line)

nv_AFC_PMENGE (price quantity from order line)

nv_AFC_RABATT (Rebate from order line)

nv_AFC_LIZPREIS (Lizenz from order line)

nv_AFC_LIZPROSTK (license price quantity from order line)

svDEPOTNAME1, svDEPOTNAME2, svDEPOTSTRASSE, svDEPOTLAND, svDEPOTORT, svKNDNR, svKNDKBZ, svKNDPLZ, svKNDNAME1, svKNDNAME2, svKNDSTRASSE, svKNDLAND, svKNDORT, svKNDTELEFON, svKNDFAX, svKNDMOBIL, svKNDANREDE, svVERTRNAME1, svVERTRNAME2, svVERTRKBZ, svAF_ABTEILUNG

43 Report Variables: Purchase Orders from Orders

**Ported by Claude** · translated to English from WikiPat on 05.10.2026

43.1 Report Variables: Purchase Orders from Orders

**Note:** The variable descriptions were translated from the German wiki with a glossary (machine-assisted); where a description is unclear check the German variable name and the original wiki text.

43.1.1 Input-Items

<thead></thead><tbody></tbody>

Table	Name
`B_BESTHEAD`	sBESTNR
`B_BESTHEAD`	sVONAUFTRNR
`B_BESTHEAD`	sFIRMNR
`B_BESTHEAD`	sLIEFNR
`B_BESTHEAD`	sLIEFKBZ
`B_BESTHEAD`	sRLIEFNR
`B_BESTHEAD`	sLIEFGRP
`B_BESTHEAD`	sSTATUS
`B_BESTHEAD`	sKNDNR
`B_BESTHEAD`	dBESTDATUM
`B_BESTHEAD`	sBESTART
`B_BESTHEAD`	sZAHLART
`B_BESTHEAD`	sFRACHTZ
`B_BESTHEAD`	sVERSART
`B_BESTHEAD`	sTOURNR
`B_BESTHEAD`	nSTAFFMENGE
`B_BESTHEAD`	nPFRACHTPR
`B_BESTHEAD`	sARTEINGANG
`B_BESTHEAD`	sVERTRNR
`B_BESTHEAD`	sKONTAKT
`B_BESTHEAD`	sKNDLAD
`B_BESTHEAD`	sLNAME1
`B_BESTHEAD`	sLNAME2
`B_BESTHEAD`	sLLAND
`B_BESTHEAD`	sLPLZ
`B_BESTHEAD`	sLSTRASSE
`B_BESTHEAD`	sLPOSTFACH
`B_BESTHEAD`	sLORT
`B_BESTHEAD`	sLORTSTEIL
`B_BESTHEAD`	sPREISGRP
`B_BESTHEAD`	nRABATT
`B_BESTHEAD`	nZUSCHLAG
`B_BESTHEAD`	sOLDKNDNR
`B_BESTHEAD`	sWAEHR
`B_BESTHEAD`	nAMENGE
`B_BESTHEAD`	nPREISS
`B_BESTHEAD`	nPROV
`B_BESTHEAD`	sLANREDE
`B_BESTHEAD`	sLZH
`B_BESTHEAD`	sLUIDNR
`B_BESTHEAD`	sRANREDE
`B_BESTHEAD`	sRZH
`B_BESTHEAD`	sRNAME1
`B_BESTHEAD`	sRNAME2
`B_BESTHEAD`	sRLAND
`B_BESTHEAD`	sRPLZ
`B_BESTHEAD`	sRORT
`B_BESTHEAD`	sRSTRASSE
`B_BESTHEAD`	sRPOSTFACH
`B_BESTHEAD`	sAFORDER
`B_BESTHEAD`	sRORTSTEIL
`B_BESTHEAD`	lHEADINFO
`B_BESTHEAD`	lFUSSINFO
`B_BESTHEAD`	sLIEFAUFTRNR
`B_BESTCOL`	sANLNR
`B_BESTCOL`	sGATGRP
`B_BESTCOL`	sARTKBZ
`B_BESTCOL`	dEINGDAT
`B_BESTCOL`	nMENGE
`B_BESTCOL`	nSTDEKPREIS
`B_BESTCOL`	sKOMMISION
`B_BESTCOL`	sSTDWAEHR
`B_BESTCOL`	nFIREKPREIS
`B_BESTCOL`	nBESTMENGE
`B_BESTCOL`	sARTNR
`B_BESTCOL`	nALTBESTMENGE
`B_BESTCOL`	sFIRWAEHR
`B_BESTCOL`	nGNDMENGE
`B_BESTCOL`	nSTDEKSUM
`B_BESTCOL`	nFIREKSUM
`B_BESTCOL`	sPRDHLFNR
`B_BESTCOL`	nPMENGE
`B_BESTCOL`	sPEH
`B_BESTCOL`	sFORM
`B_BESTCOL`	sAUSFORM
`B_BESTCOL`	nLFKW
`B_BESTCOL`	nMWST
`B_BESTCOL`	nFIRLIZPREIS
`B_BESTCOL`	nFIRLIZPROSTK
`B_BESTCOL`	nAUSMENGE
`B_BESTCOL`	nLFJAHR
`B_BESTCOL`	nLIZPREIS
`B_BESTCOL`	nLIZPROSTK
`B_BESTCOL`	nRABATT
`B_BESTCOL`	nAUSMENGANZ
`B_BESTCOL`	nZUSCHLAG
`B_BESTCOL`	sAUSPRDHLFNR
`B_BESTCOL`	dLFDATUM
`B_BESTCOL`	nFRACHTPREIS
`B_BESTCOL`	sVERPACK
`B_BESTCOL`	nVERPACKPREIS
`B_BESTCOL`	nVPEH
`B_BESTCOL`	nFIRFRACHTPREIS
`B_BESTCOL`	nVPELAGE
`B_BESTCOL`	nLAGEWAG
`B_BESTCOL`	nKARTPAL
`B_BESTCOL`	nFIRVERPACKPREIS
`B_BESTCOL`	nVPEKART
`B_BESTCOL`	nPFLANZ
`B_BESTCOL`	sTEXT
`B_BESTCOL`	nSKTAGE
`B_BESTCOL`	nSKPROZ
`B_BESTCOL`	nFIRZUSCHL
`B_BESTCOL`	sTOURNR
`B_BESTCOL`	sGEBART
`B_BESTCOL`	sLFMEEH
`B_BESTCOL`	sPRMEEH
`B_BESTCOL`	sRECHNR
`B_BESTCOL`	sBUGRUPPE
`B_BESTCOL`	nGEWTARA
`B_BESTCOL`	nGEWNETTO
`B_BESTCOL`	nGEWSTUECK
`B_BESTCOL`	sLLIEFNR
`B_BESTCOL`	nPVPEH
`B_BESTCOL`	sORDERNR
`B_BESTCOL`	sCHARGENNR
`B_BESTCOL`	nMINMEZSWERT
`B_BESTCOL`	nGNDPREIS
`B_BESTCOL`	sMCODE
`B_BESTCOL`	nAUSFALL
`B_BESTCOL`	nGEWICHT
`B_BESTCOL`	nTOPFGR
`B_BESTCOL`	nHOEHE
`sFIRMAARTKBZ`
`sLANDPOSTORT`
`sLPO`
`sTOURBEZ`
`sZAHLARTBEZ`
`sVERTBEZ`
`sVERTNAME1`
`sVERTNAME2`
`sVERTFAX`
`sVERTTEL`
`sPRDHLFNRBEZ`
`sSORTE`
`sGATGRPBEZ`
`sLANDBEZ`
`B_LIEFERANT`	sANREDE
`B_LIEFERANT`	sZH
`B_LIEFERANT`	sNAME1
`B_LIEFERANT`	sNAME2
`B_LIEFERANT`	sLAND
`B_LIEFERANT`	sPLZ
`B_LIEFERANT`	sSTRASSE
`B_LIEFERANT`	sPOSTFACH
`B_LIEFERANT`	sORT
`B_LIEFERANT`	sORTSTEIL
`B_LIEFERANT`	sTELEFON
`B_LIEFERANT`	sFAX

43.1.2 Imput-variables

Here is besonders zu beachten, dass einige variables from the Klasse cfBEST_AF_PARAM gelesen are!

<thead></thead><tbody></tbody>

Table	Name
`B_BESTHEAD`	sBESTNR
`B_BESTHEAD`	sLIEFNR
`B_BESTHEAD`	sKNDNR
`B_BESTHEAD`	dBESTDATUM
`B_BESTHEAD`	sKNDLAD
`B_BESTHEAD`	sLNAME1
`B_BESTHEAD`	sLNAME2
`B_BESTHEAD`	sLLAND
`B_BESTHEAD`	sLPLZ
`B_BESTHEAD`	sLSTRASSE
`B_BESTHEAD`	sLPOSTFACH
`B_BESTHEAD`	sLORT
`B_BESTHEAD`	sLORTSTEIL
`B_BESTHEAD`	nPFRACHTPR
`B_BESTHEAD`	sVERTRNR
`B_BESTHEAD`	sLIEFAUFTRNR
(AFBest)	dAUFTRDAT
(AFBest)	sWARNUNG
(AFBest)	svVERSART
(AFBest)	svKOPFTEXT
(AFBest)	svLANREDE
(AFBest)	svLNAME3
`B_BESTCOL`	sANLNR
`B_BESTCOL`	sGATGRP
`B_BESTCOL`	sARTKBZ
`B_BESTCOL`	nMENGE
`B_BESTCOL`	sKOMMISION
`B_BESTCOL`	sARTNR
`B_BESTCOL`	sPRDHLFNR
`B_BESTCOL`	sFORM
`B_BESTCOL`	nLFKW
`B_BESTCOL`	nLFJAHR
`B_BESTCOL`	dLFDATUM
`B_BESTCOL`	nPRKW
`B_BESTCOL`	nPRJAHR
`B_BESTCOL`	dPRDATUM
`B_BESTCOL`	nSTDEKPREIS
`B_BESTCOL`	nFIREKPREIS
`B_BESTCOL`	nPMENGE
`B_BESTCOL`	sPEH
`B_BESTCOL`	nVPEH
`B_BESTCOL`	nLIZPREIS
`B_BESTCOL`	nFIRLIZPREIS
`B_BESTCOL`	nLIZPROSTK
`B_BESTCOL`	nFIRLIZPROSTK
`B_BESTCOL`	sSTDWAEHR
`B_BESTCOL`	sFIRWAEHR
`B_BESTCOL`	sLFMEEH
`B_BESTCOL`	sABTEILUNG
`B_BESTCOL`	nMENGENFAKTOR
`B_BESTCOL`	sBEAANG
`B_BESTCOL`	sBEAAEN
`B_BESTCOL`	sLIEFNR
`B_BESTCOL`	sFIRMNR
`B_BESTCOL`	sTEXT
`B_LIEFERANT`	sANREDE
`B_LIEFERANT`	sZH
`B_LIEFERANT`	sNAME1
`B_LIEFERANT`	sNAME2
`B_LIEFERANT`	sLAND
`B_LIEFERANT`	sPLZ
`B_LIEFERANT`	sSTRASSE
`B_LIEFERANT`	sPOSTFACH
`B_LIEFERANT`	sORT
`B_LIEFERANT`	sORTSTEIL
`B_LIEFERANT`	sTELEFON
`B_LIEFERANT`	sFAX
`B_BESTCOL`	nPRKW
`B_BESTCOL`	nPRJAHR
`B_BESTCOL`	dPRDATUM
`B_BESTCOL`	svABTEILUNG
(AFBest)	svABTEILUNG2
`B_BESTCOL`	nvMENGENFAKTOR
`B_BESTCOL`	BEAAEN
`B_BESTCOL`	BEAANG
(AFBest)	svDEPOTNR
(AFBest)	svDEPOTKBZ
(AFBest)	svDEPOTPLZ
(AFBest)	svTOURNR
`cgBEST_AF_PARAM`	svKBESTNR
`cgBEST_AF_PARAM`	svKOPFTEXT
`cgBEST_AF_PARAM`	svAUFTRINFO
`cgBEST_AF_PARAM`	svLFINFO
`cgBEST_AF_PARAM`	svLADLISTINFO
`cgBEST_AF_PARAM`	svRECHINFO

43.1.3 Stichwortliste

Reportvariablen purchase order from Aufträgen, Report purchase order from Aufträgen, variables Report purchase order from Aufträgen, Bestellungsreportvariablen from order