b1documentgenerate

Administration > System Initialization > Report settings > APIs > b1documentgenerate

Top  Previous  Next

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:http://www.beascloud.net/docs/help/online_eng/index.html?b1documentgenerate.htm