id |
unigue ID |
docnum |
document No. with Prefix and Suffix (Char) |
num_docnum |
document No as numeral |
docentry |
internal document No. |
docdate |
formatted reference date |
docduedate |
formatted reference date |
taxdate |
formatted reference date |
printdate |
formatted printing date (always current date) |
showcatalognr |
if Y then according to SBO only the catalognr of the business partner and not the itemcode gets printed |
cardcode |
Customer No. |
cardname |
Customer name |
cardfname |
foreign language name |
lictradnum |
UID-No. of the business partner |
addid |
ID-Nr2 of the business partner |
comments |
Comments |
vatidincmp |
|
address |
address business partner |
iban |
IBAN of business partner |
language |
document language (BEAS-language type) |
languageitem |
item language (BEAS-language type) |
languageseparator |
decimal separator |
languagethousendseparator |
thousend separator |
languagedateformat |
date format |
netto |
net sum (sum of all single prices before discount), formatted in document-currency |
discount |
discount, formatted in document-currency |
discountpercent |
discount in percent |
nettosum |
net sum after discount, formatted in document-currency |
vatsum |
sum of taxes, formatted in document-currency |
doctotal |
gross sum, formatted in document-currency |
currency |
document-currency |
num_netto |
net as numeral |
num_discount |
discount sum as numeral |
num_nettosum |
net after discount |
num_prepaymentsum |
prepaymentsum in document-currency |
num_prepaymentpercent |
prepayment in percent |
num_prepaymentvat |
prepayment tax in document-currency |
num_freightsum |
freightsum in document-currency |
num_freightvat |
freightsum tax in document-currency |
num_vatsum |
tax sum as numeral |
num_doctotal |
gross sum as numeral |
num_discountpercent |
discount |
weight_mg |
total weight in mg |
volume_mm2 |
total volume in mm² |
contactname |
contact name customer |
contacttitel |
Titel |
contactposition |
Position |
contactaddress |
address |
contacttel1 |
|
contacttel2 |
|
contactmobile |
|
contactfax |
|
contactemail |
|
contactpager |
|
shiptocode |
|
shipaddress |
formatted shipping address |
shiplictradnum |
UID-No. delivery address |
transportcode |
|
slpcode |
contact person of the own company |
ownercode |
owner of document (Code) |
ownerfirstname |
owner of document firstname |
ownermiddlename |
|
ownerlastname |
|
ownerjobtitle |
|
ownerofficetel |
|
ownermobile |
|
ownerpager |
|
ownerfax |
|
owneremail |
|
paymentconditionname |
paymentconditionname translated |
paymentconditioncode |
paymentcondition-Code not translated |
paymentdiscountname |
discountname translated. If there is no discount the paymentconditions are dispayed |
paymentdiscountcode |
discount-code |
paymentconditiontext |
discount conditions |
companyname |
name of the own company |
companyadress_as_line |
address in one line |
companyprintheader |
|
companyphone1 |
|
companyphone2 |
|
companypfax |
|
companyemail |
|
companymanager |
|
companyrevoffice |
|
companytaxidnum |
|
companyfreezoneno |
|
report_header |
report header (each page) - can be formatted as RTF |
report_start |
first fix header text |
textheader |
text header of the document |
textfooter |
text footer of the document |
document_end |
fix endtext of the document |
report_end |
last fix text footer |
report_footer |
footer of the report (fix, each page) |
paytocode |
from header (oinv.paytocode) |
invoicecardcode |
If there is an entry for a consolidate partner (bill to) for the business partner at accounting the information of the consolidate partner is displayed in invoicexxxxx. |
invoicecardname |
Name from customer address - if there is an entry for a bill to address, this name and address are displayed. |
invoiceaddress2 |
|
invoiceaddress3 |
|
invoicestreet |
|
invoiceblock |
|
invoicezipcode |
|
invoicecity |
|
invoicecounty |
|
invoicestate |
|
invoicecountry |
code of country |
invoicecountryname |
translated countryname |
invoicephone1 |
|
invoicefax |
|
invoiceemail |
id |
fix ID |
line |
consecutive number. Use it for sorting. |
linenum |
internal line No. of the document |
linepos |
visible line No. of the document |
linetype |
line type: S=Zwischensumme (subtotal) , A=Alternativartikel (alternative item), T=Textfeld (text field) |
baseref |
reference to the base document |
basetype |
type of the base document |
baseline |
internal line No. of the base document |
baselinepos |
free |
basedocnum |
free |
linestatus |
Status of the line. O=Open, C=Close |
itemcode |
itemdode If in SAP is set: show part number (catalog number), the itemcode is inserted anyway. So you can decide what should be displayed when creating a report. See beas_document_header.showcatalognr. |
catalognr |
catalog number of the business partner (is always filled - independent from the setting 'show catalog number' |
description |
description of the item - if translation available then it gets translated in the ITEM LANGUAGE - if no translation in ITEM LANGUAGE available then DOCUMENT LANGUAGE is used |
matchcode |
Matchcode of item master data |
drawingnumber |
drawing number of item master data |
longtext |
long text (maybe RTF) If sales report: if item language = database language then own long text, else foreign language text. If there is a translation in the item language, then its sales description has higher priority. If receipt document purchase order longtext of item master data. If translation available for item language its purchase order description has higher priority. |
project |
|
barcode |
field "codebars" from line of document |
vendornum |
from line of document |
serialnum |
from line of document |
sernumflag |
if serial No. item then Y |
batchnumflag |
if batch No. item then Y |
suppcatnum |
from item master data |
quantity |
formatted quantity in document unit of M. |
openquantity |
open quantity formatted |
quantityunit |
document quantity of unit: according to SBO-translation: if sales: see sales unit in item master data, if purchase: see purchase unit in item master data |
num_quantity |
quantity as numeral in document unit of M. |
num_openqty |
open quantity as numeral in document unit of M. |
num_in_sale |
conversionfactor to store unit |
packunit |
free |
num_in_pack |
free |
factor1...4 |
factors for packaging |
num_width |
with |
width_unit |
|
num_length |
|
length_unit |
|
num_weight |
|
weight_unit |
|
num_volume |
|
volume_unut |
|
shipdate |
shipping date as a String |
price |
Single price in document currency as a String Single price refers to each document unit of M. |
discount |
discount price |
discountpercent |
discount percent |
priceafterdiscount |
price after discount |
pricetotal |
line price in document currency as a String. If subtotals the subtotalprice is dispayed
Characteristic SETARTIKEL (treetype=S) Opposite to the SBO-default here is displayed the sum of the single components. You can setup with the visibility of SBO (suppress depending on the Treetype) if you want to display the single item (Treetype=I) or the total item price. ONLY the lineprice net and gross is summed, no discount or price before discount. |
priceaftervat |
total price after taxes |
num_price |
as numeral |
num_discount |
|
num_discountpercent |
|
num_priceafterdiscount |
|
num_pricetotal |
|
num_priceaftervat |
|
currency |
output currency |
whscode |
Storage code |
vatgroup |
tax group |
vatreportcode |
invoice text (translated) of the tax group |
freight_linetotal |
sum of freight costs (from rdr2 or inv2 ...) |
freight_vatsum |
sum taxes (from rdr2, inv2...) |