The Data in the Page headers on the "Empty.rep" as well as all reports on the Reports menu and User reports menu; except Document layout files, Debtor statements and Creditor remittance advises), is as follows: 

The Company dataset is included the "Empty.rep" report. It contains the data entered in the  Setup → Company info menu on the Setup ribbon.

If you are choosing the "New.rep" report, and need to include some details of your company, you need to add the Company dataset to include the details already included  Setup → Company info menu on the Setup ribbon.

Page header Company Data

The Company dataset is included the "Empty.rep" report. It contains the data entered in the Company info option on the Setup ribbon.

The Page header (as on the "Empty.rep" consists of the following expressions:

Expression

SQL

Description


TRpShape0

Horizontal line

Horizontal line 


TRpShape1

Horizontal line

Horizontal line


TRpExpression0

COMPANYDATA.SCOMPANYNAME

Company name – In the case of multi page reports, where the company details (on Page header) is only printed on the first page of a report. 


TRpExpression1

COMPANYDATA.SADDRESS1

The data path – The full path (location and folders) in which the Set of Books is stored on your system or network.  


TRpExpression2

COMPANYDATA.SADDRESS2

System user of your Operating system and the TurboCASH user set in Access control) who printed the report. 


TrpExpression3

COMPANYDATA.SADDRESS3

Date stamp – System date and time the report is printed. 


TRpExpression4

COMPANYDATA.SPOSTCODE

Page number and last page number to indicate the expected number of pages. 


TRpExpression5

CUSTOM('GETTEXTLANG',316,'COMPANY REG nr',0,0,0)+': '



TRpExpression6

CUSTOM('GETTEXTLANG',317,'TAX nr',0,0,0)+': '



TRpExpression7

COMPANYDATA.SCOMPANYREGNO



TRpExpression8

COMPANYDATA.STAXREGNO



TRpExpression9

COMPANYDATA.SPHONENUMBER



TRpExpression10

CUSTOM('GETTEXTLANG',974,'Phone',0,0,0)



TRpExpression11

CUSTOM('GETTEXTLANG',189,'Fax',0,0,0)+': '



TRpExpression12

CUSTOM('GETTEXTLANG',191,'Email',0,0,0)+': '



TRpExpression13

CUSTOM('GETTEXTLANG',3212,'Website',0,0,0)+': '



TRpExpression14

COMPANYDATA.SWEBSITE



TRpExpression15

COMPANYDATA.SEMAILADDRESS



TRpExpression16

COMPANYDATA.SFAXNUMBER



COMPANYDATA SQL

The company data SQL consists of two (2) tables (i.e. SYSVARS and SYSVARSEXT) tables in the Database. 

To write SQL is actually very simple, for example, “select data from table”,  where data is a valid field name (e.g. ScompanyName Company name) in the table and table is a valid table name (e.g. Sysvars). To call the company name and Fax number (as entered in the Company info (Setup ribbon) screen (it is stored in the sysvars table)), you may simply write select SCompanyName CompanyName, SFaxNumber Fax from Sysvars.  

The SQL for the COMPANYDATA dataset included in the "Empty.rep" is as follows:

SQL Text

Data on Company info


Select a.*, SCompanyName  ,

SCompanyRegNo ,

SEmailAddress ,

SAddress1 ,

SAddress2 ,

SAddress3 ,

SPostCode ,

SPhoneNumber ,

SFaxNumber ,

STaxRegNo ,

BLOBLOGO,

SAccountReportName1 ,

SAccountReportName2 ,

SDebtorReportName1 ,

SDebtorReportName2 ,

SCreditorReportName1 ,

SCreditorReportName2 ,

SStockReportName1 ,

SStockReportName2 ,

SBANKNAME1, 

SBANKNAME2, 

SBANKNUMBER2, 

SBANKNUMBER1, 

SBANKSWIFT1, 

SBANKIBAN1, 

SBANKSWIFT2, 

SBANKIBAN2, 

SBANKACCOUNTNAME1, 

SBANKACCOUNTNAME2,

SBANKBIC1,

SBANKBIC2

from Sysvars 

, sysvarsext a

Company name

Company registration number

E-mail

Address line 1

Address line 2

Address line 3

Postal code

Telephone number

Fax number

Tax registration number

Company logo (Options tab)

Account group 1

Account group 2

Debtor group 1

Debtor group 2

Creditor group 1

Creditor group 2

Stock group 1

Stock group 2

Bank name 1

Bank name 2

Bank account number 1

Bank account number 2

SWIFT 1

IBAN 1

SWIFT 2

IBAN 2

Bank account name 1

Bank account name 2

BIC 1

BIC 2
























SWIFT - (Society for Worldwide Interbank Financial Telecommunication) 

IBAN - (International Bank Account Number)





BIC - (Bank Identifier Code)

The SYSVARSEXT table is joined to the SYSVARS table in the COMPANYDATA Dataset.

SCONTACTNAME ContactName,
SMOBILE  MobileNo
from Sysvarsext


Click on the Show data button.