If this API is active, beas generates two tables BEFORE printing the documents
beas_document_header
beas_document_line
These can be easily accessed with Crystal Reports, since the data is calculated, translated and formatted in advance.
Beas also ensures the upward compatibility of the forms, since this structure does not change, however it may be expanded.
After print content of the table is deleted. To keep it, see Configuration wizard – Print and Report settings
beas_document_header
ID
|
unique ID
|
docnum
|
Document number with prefix and suffix (char)
|
num_docnum
|
Document number as number
|
docentry
|
Internal document number
|
docdate
|
Formatted form date
|
docduedate
|
Formatted form date
|
taxdate
|
Formatted form date
|
printdate
|
Formatted print date (always current date)
|
cardcode
|
Customer Number
|
cardname
|
Customer Name
|
cardfname
|
Foreign language name
|
lictradnum
|
UID number of business partner
|
addid
|
ID no2 of business partner
|
vatidincmp
|
|
iban
|
IBAN of business partner
|
language
|
Document language (Beas language type)
|
languageitem
|
Item language (Beas language type)
|
Net
|
Net total (total of all individual prices before discount), formatted in document currency
|
discount
|
Discount, formatted in document currency
|
discountpercent
|
Discount percentage, as a number
|
nettotal
|
Net total after discount, formatted in document currency
|
vattot
|
Tax total formatted in document currency
|
doctotal
|
Gross total formatted in document currency
|
currency
|
Document currency
|
num_net
|
Net total, as number
|
num_discount
|
Discount total as a number
|
num_nettotal
|
Net total after discount
|
num_vattot
|
Tax total as number
|
num_doctotal
|
Gross total as number
|
contactname
|
Customer contact person
|
contacttitle
|
Title
|
contactposition
|
Position
|
contactaddress
|
Address
|
contacttel1
|
|
contacttel2
|
|
contactmobile
|
|
contactfax
|
|
contactemail
|
|
contactpager
|
|
shiptocode
|
Supplier address name
|
shipaddress
|
Formatted address details
|
shiplictradnum
|
UID number of delivery address
|
transportcode
|
Terms of delivery description
|
slpcode
|
Inhouse contact person
|
ownercode
|
Document owner (code)
|
ownerfirstname
|
Document owner first name
|
ownermiddlename
|
|
ownerlastname
|
|
ownerjobtitle
|
|
ownerposition
|
|
ownerdepartment
|
|
ownerbran
|
|
ownerofficetel
|
|
ownermobile
|
|
ownerpager
|
|
ownerfax
|
|
owneremail
|
|
paymentconditionname
|
Payment conditions. If a discount is stored, the name of the discount condition is output
|
paymentconditiontext
|
Discount information
|
companyname
|
Name of own company
|
companyadress_as_line
|
Address as single line
|
companyprintheader
|
|
companyphone1
|
|
companyphone2
|
|
companyfax
|
|
companyemail
|
|
companymanager
|
Managing director
|
companyrevoffice
|
|
companytaxidnum
|
|
companyfreezoneno
|
|
report_header
|
Page header (each page) - can also be RTF-formatted
|
report_start
|
First header text
|
textheader
|
Document header text
|
textfooter
|
Document footer text
|
document_end
|
Fixed document end text
|
report_end
|
Last fixed footer text
|
report_footer
|
Page footer (fixed, each page)
|
beas_document_line
ID
|
Fixed ID
|
line
|
Continuous serial number. Sorting is performed using this serial number.
|
linenum
|
Internal line number of the document
|
linepos
|
Visible line number of the document line
|
linetype
|
Line type
S=Subtotal
|
baseref
|
Base document reference
|
basetype
|
Base document type
|
baseline
|
Base document internal line number
|
baselinepos
|
unassigned
|
basedocnum
|
unassigned
|
linestatus
|
Status of the line. O=Open, C=Close
|
itemcode
|
Item Number
|
catalogno
|
unassigned
|
description
|
Item description. If translation is available, then translated into ITEM DOCUMENT LANGUAGE.
If there is no translation in the item document language, the system checks for a document language translation.
|
Match code
|
Match code from item master
|
drawingnumber
|
Drawing number from item master
|
longtext
|
Long description (possibly RTF)
If sales document:
if item document language = database language, then own long description,
otherwise foreign language description. If translation for item document language
exists, then its sales description has priority.
If purchase document
Long text of order according to item master. If translation for item document language
exists, then its order description has priority.
|
project
|
|
Barcode
|
"codebars" field from document line
|
vendornum
|
From document line
|
serialnum
|
From document line
|
sernumflag
|
If serial number item, then Y
|
batchnumflag
|
If batch number item, then Y
|
suppcatnum
|
From item master
|
quantity
|
Formatted quantity specification in document quantity unit
|
openquantity
|
Open quantity formatted
|
quantityunit
|
Document quantity unit
Translated according to SAP Business One translation for sale in the item master according to unit of sale. For purchase, according to the unit of purchase.
|
num_quantity
|
Quantity as number in document quantity unit
|
num_openqty
|
Open quantity as number in document quantity unit
|
num_in_sale
|
Conversion factor to unit of store
|
packunit
|
unassigned
|
num_in_pack
|
unassigned
|
factor1...4
|
Packaging factors
|
num_width
|
Width
|
width_unit
|
Width specification: unit as symbol
|
num_length
|
|
length_unit
|
|
num_weight
|
|
weight_unit
|
|
num_volume
|
|
volume_unut
|
|
shpdate
|
Delivery date formatted as a string
|
price
|
Individual price in document currency as a string.
Individual price relates to each document quantity unit.
|
pricetotal
|
Individual price in document currency as a string. For subtotals, the subtotal price.
|
discountpercent
|
Listed here as a number.
|
discount
|
As a string
|
num_price
|
Price as number in document currency
|
num_pricetotal
|
Price as number in document currency
|
currency
|
Output currency
|
whscode
|
Store Code
|
vatgroup
|
Tax group
|
back to APIs
Help URL: https://help.beascloud.com/beas202106/index.html?b1documentgenerate.htm
|