Home > Technical > Table Definitions > BANKDTL

BANKDTL

When the user enters the banking details for a day, there will be one BANKINGHDR record and multiple BANKINGDTL records (one for each BANKINGDEF record).

Column

Type

Description

INTBANKCODE

INT

The code of the banking header that these banking details are for.

BANKINGHDR.ctrCode

STRGUID

VARCHAR(38)

 

DTMWHEN

DATETIME

When the details were entered.

INTTENDERCODE

INT

 

STRDESCRIPTION

VARCHAR(20)

 

CURTENDERAMT

DECIMAL(19,4)

 

STRCURRENCYCODE

VARCHAR(10)

 

CURFOREIGNAMT

DECIMAL(19,4)

 

STRREFNUM

VARCHAR(20)

 

DBLRATE

DECIMAL(10,6)

 

DBLACCOUNTRATE

DECIMAL(10,6)

 

STRREFNUM2

VARCHAR(15)

 

 

Primary Key: INTBANKCODE+STRGUID

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)