DBBase



WARNING icon
Basic Reports is an Advanced User feature.



WARNING icon
WARNING: Before making changes to ANY of your Basic Report templates it is advisable to take a backup.


Overview

This page describes the DBBase (General) data fields that are available to be the Basic Reports (using the Basic Reports interface) and Report Builder when the system is set to use Basic Reports.

The options below can be seen when a DBMemo option is added to the report using the Basic Reports Memo button button on the top menu. Once added to the report and the drop-down in the top left is set to DBDetails, the drop down to the right will be populated:
DBBase options in Basic Reports

DBBase Available Fields

Calc prefix

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
calc_company_tax_ref Displays the customer's tax number (in the European Communities – VAT number). Prefix VAT numbers with two-character country code for business customers based in other European countries (e.g. DK 13189900, IT 10007940157). This will be stamped and stored against invoices that are created, for more information see How the Tax Ref affects the EC Tax Register.  green tick   green tick 
calc_customer_ref  green tick   green tick   green tick 
calc_date_printed The date that the report was printed.  green tick   green tick   green tick 
calc_deliverytotal  green tick 
calc_document_ref Displays the appropriate Label depending on the document type. For example: If the document is a credit note, the label will read Credit Note  green tick   green tick 
calc_document_type The document type as defined in the system. For example, Doc Type 1-1 = Sales Invoice  green tick   green tick   green tick 
calc_document_type_desc The description attached to the document type. Doc Type 1-1 has the description of Sales Invoice.  green tick   green tick 
calc_due_date  green tick 
calc_grandtotal  green tick 
calc_has_ship_to_address  green tick   green tick 
calc_inv_copy_id Displays the system generate unique ID and its copy number in brackets if you have setup multiple documents in Customer Financial Tab.  green tick   green tick 
calc_invoice_date The date that the Sales Invoice was created.  green tick   green tick 
calc_inv_box_count  green tick   green tick 
calc_is_first_invoice  green tick 
calc_itemtotal  green tick 
calc_payment_label  green tick   green tick 
calc_payment_terms Displays the payment terms as set against the customer record, Financial tab.  green tick   green tick   green tick   green tick 
calc_so_associated_ref  green tick 
calc_so_customer_poref  green tick 
calc_so_delivery_date  green tick 
calc_so_order_date  green tick 
calc_so_order_code  green tick 
calc_subtotal  green tick 
calc_taxtotal  green tick 
calc_total_not_paid Displays the result of Total Payment - Amount Paid.  green tick   green tick 
calc_total_payment Displays the total amount paid for an invoice.  green tick   green tick 
calc_total_weight Displays the total weight shipped.  green tick   green tick 

C

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
calculated_note  green tick   green tick 
company_code Displays the Customer URN  green tick   green tick   green tick   green tick 
company_id Displays the Customer system generated unique ID for  green tick   green tick   green tick 
company_name Displays the Customer / Company name  green tick   green tick 
company_proforma Displays a True (-1) or False (0) value depending whether the customer is setup as a Proforma customer or not.  green tick 
company_ptype_id  green tick 
company_tax_ref  green tick   green tick   green tick   green tick 
comp_class_desc  green tick 
consignment_ref  green tick 
copy_num Typically used when the system is configured to print multiple copies of reports. Displays document copy number.  green tick   green tick 
country_id Displays the system generated unique ID for Country.  green tick   green tick 
courier_code: Displays the courier code as defined in System Data Couriers.
 green tick   green tick   green tick 
courier_export_type  green tick 
courier_name Displays the Courier service name.  green tick   green tick   green tick 
courier_note  green tick   green tick 
courier_service_image Typically used with the DB Image object. Displays the courier service image as defined in System Data Couriers  green tick   green tick   green tick 
courier_service_note  green tick 
credit_note Returns a True (-1) or False (0) value depending on whether the document type is Credit note or not.  green tick   green tick   green tick 
currency_id Displays the system's ID for the type of currency being used.  green tick   green tick   green tick   green tick 
customer_po Displays Customer's PO Ref  green tick   green tick   green tick 

D

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
date_issued Displays the date that the Sales Invoice was issued.  green tick   green tick   green tick 
date_printed Displays the date that the Sales Invoice print previewed to then print out or email, this is when the Invoice number is assigned.  green tick   green tick   green tick   green tick 
date_printed_invoice_document Displays the date that the Sales Invoice was physically printed out.  green tick   green tick 
date_required  green tick 
deladdress_id  green tick 
delivery_date Displays the date that the Sales Invoice was physically printed out.  green tick   green tick   green tick 
delivery_gross_total Displays Gross total of delivery.  green tick   green tick   green tick 
delivery_order  green tick 
delivery_tax_total Displays Tax total of delivery.  green tick   green tick   green tick 
delivery_timeslot Displays the value that has been entered in the Timeslot field within Sales Orders Additional Tab
 green tick   green tick   green tick 
delivery_total Displays the cost of delivery including tax  green tick   green tick   green tick   green tick 

F to I

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
first_invoice  green tick   green tick   green tick 
gross_total Displays Gross total of the Sales Order.  green tick   green tick   green tick   green tick 
header_note  green tick 
internet_ref  green tick 
invoice_code Displays the Invoice number / ref.  green tick   green tick   green tick 
invoice_date Displays the date an invoice was printed or created in the Sales Invoice Manager.  green tick   green tick 
invoice_id Displays the system generate unique ID.  green tick   green tick   green tick 
invoice_note Typically used with the DB Memo object. Displays the note defined in Invoice Note.
 green tick   green tick   green tick 
item_gross_total Displays the Gross total of the line items.  green tick   green tick   green tick 
item_tax_total Displays Tax total of the sales order.  green tick   green tick   green tick 
item_total Displays the Net total of the line items.  green tick   green tick   green tick 


iv_actual_weight_after_shipping  green tick   green tick 
iv_associated_ref Displays the Associated Reference as defined in Sales Orders Main Tab.
 green tick   green tick 
iv_delivery_gross_total  green tick 
iv_delivery_total  green tick 
iv_item_gross_total  green tick 
iv_item_total  green tick 
iv_sales_source  green tick 
iv_tax_total  green tick 

J to O

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
job_batch_code  green tick 
job_code  green tick 
jobcost_code Displays Gross total of the Sales Order  green tick 
net_items_total  green tick 
net_total Displays Net total of the Sales Order  green tick   green tick   green tick 
num_labels  green tick   green tick 
order_date  green tick 

P

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
paid_for Returns a True (-1) or False (0) value depending on whether the Sales Order is fully paid or not.  green tick   green tick 
payment_type_desc
pickinglist_note Typically used with the DB Memo object and displays the note defined in Sales Orders Notes Tab.
 green tick   green tick   green tick 
picking_note_date_printed  green tick 
picking_sheet_box_no  green tick 
picking_sheet_box_no_new  green tick 
porder_code  green tick 
porder_date  green tick 
porder_id  green tick 
porder_code  green tick 
print_batch_code  green tick 
printed_count  green tick 
ptype_id Displays the system ID for the payment type.  green tick   green tick   green tick   green tick 

R

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
remainder_account Displays the remainder on a customer's account, if setup as credit account type.  green tick   green tick 
round_code  green tick 

S

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
sales_source The sales source of the sales order Sales Orders Additional Tab.  green tick   green tick 
ship_date  green tick 
shipto_reference  green tick   green tick 
shiptoaddress_id  green tick   green tick 
shiptoprovider_id  green tick   green tick 
show_deladdr_co_name Displays the delivery address defined against a sales order in Sales Orders Addresses Tab.  green tick   green tick   green tick 
show_invaddr_co_name Displays the invoice address defined against a sales order in Sales Orders Addresses Tab.  green tick   green tick   green tick 
site_id  green tick 
so_associated_ref Displays the Sales order associated ref as defined in Sales Orders Main Tab.  green tick   green tick 
so_associated_ref2  green tick   green tick 
so_customer_po - Displays the PO number as defined in Sales Orders Main Tab.  green tick   green tick 
so_date_created Displays the date that the Sales Order was created.  green tick   green tick 
so_delivery_gross_total Displays the Gross total for the delivery on a Sales Order.  green tick   green tick   green tick 
so_delivery_tax_total Displays the total Tax for delivery on a Sales Order.  green tick   green tick 
so_delivery_total Displays the Sales Order delivery Total.  green tick   green tick   green tick   green tick 
so_flags  green tick   green tick 
so_gross_total Displays the Gross total for the delivery on a Sales Order.  green tick   green tick   green tick 
so_invoice_priority  green tick 
so_item_tax_total Displays the Line item gross total.  green tick   green tick 
so_item_gross_total Displays the Line item gross total.  green tick   green tick   green tick 
so_item_total Displays the Line item net total.  green tick   green tick   green tick   green tick 
so_net_total Displays the Sales Order net total.  green tick   green tick   green tick 
so_tax_total Displays the Sales Order total Tax.  green tick   green tick   green tick 
so_sorder_code Displays the Sales Order number.  green tick   green tick   green tick 
sorder_code Displays the system's ID for which document type.  green tick 
sorder_id Displays the system's ID for which document type.  green tick   green tick   green tick 
sotype_id Displays the system's ID for which document type.  green tick   green tick   green tick 
sovtype_id Displays the system's ID for which document type.  green tick   green tick   green tick 
ss_logo_file Typically used with the DBImage object to display the logo image assigned to Sales Source as define in System Data Sale Source
 green tick   green tick   green tick 
supaddress_id  green tick 
supplier_id  green tick 
supplier_other_ref  green tick 

T

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
taken_by The name of the user logged in at Sales Order creation.  green tick   green tick   green tick 
tax_point The date of the tax point.  green tick   green tick 
tax_total The total Tax amount.  green tick   green tick   green tick 
terms_id The ID number of the terms type as defined in Customer Financial Tab.
 green tick   green tick   green tick 
termsp_id The ID number of the terms type as defined in Supplier Financial tab.
 green tick 
terms_period The number days / months of the terms as defined in Customer Financial Tab.
 green tick   green tick   green tick 
termsp_period The number days / months of the terms as defined in Supplier Financial tab.
 green tick 

U to W

Field
Description
Sales Invoice
Delivery note
Picking ticket
Purchase order
user_name  green tick 
vendor_ref  green tick   green tick   green tick   green tick 
volume  green tick 
Wndirect_ref  green tick   green tick 


See Also

Visit KhaosWikiX at https://support.khaoscontrol.com/wiki_kcx/ to see the following:

Contact the Khaos Team