Administration > System initialization > Report settings > APIs > b1documentgenerate - robinfeng/beashelp GitHub Wiki
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
่ฟๅ ไธป้กต