Home > Technical > Table Definitions > BANKINGDET

BANKINGDET

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

LINTBANKCODE

INT

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

BANKINGHDR.ctrCode

INTSECTION

INT

Copied from BANKINGDEF.intSection

INTCODE

INT

A unique number assigned by the system.

DTMTRADEDATE

DATETIME

The date that this details are for.

STRDESCRIPTION

VARCHAR(30)

Copied from BANKINGDEF.strDescription

STRGLXREF

VARCHAR(20)

Copied from BANKINGDEF.strGLXRef

STRLEDGERCODE

VARCHAR(10)

Copied from BANKINGDEF.strLedgerCode

STRACCOUNTCODE

VARCHAR(20)

Copied from BANKINGDEF.strAccountCode

CURAMOUNT

DECIMAL(19,4)

The value entered by the user for this category.

 

Primary Key: LINTBANKCODE+INTSECTION+INTCODE

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