Document Tables

 

 

beas_document_header

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


 

beas_document_line

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