Home > Technical > Table Definitions > BANKHDR

BANKHDR

Column

Type

Description

CTRCODE

INT

 

STRTRADECODE

VARCHAR(10)

 

INTSTARTSALESCODE

BIGINT

 

INTSTARTTILLCODE

BIGINT

 

INTENDSALESCODE

BIGINT

 

INTENDTILLCODE

BIGINT

 

STRSTATUS

VARCHAR(10)

The current status of the banking, for example New, Printed, Accepted.

STRWHO

VARCHAR

The user who entered the details.

DTMWHEN

DATETIME

When the details were entered.

CURSALES

DECIMAL(19,4)

 

CURINCOME

DECIMAL(19,4)

 

CUREXPENSES

DECIMAL(19,4)

 

CURTILLVARIANCE

FLOAT

 

CUREXCHANGEADJ

DECIMAL(19,4)

 

CUREXPECTED

DECIMAL(19,4)

 

CURACTUAL

DECIMAL(19,4)

 

INTTRADINGPERIOD

INT

The trading period the banking details are for.

MEMCOMMENT

TEXT

 

CURROUNDING

DECIMAL(19,4)

 

CURSALESNETT

DECIMAL(19,4)

 

INTFROMREFRESH

BIGINT

 

DTMFROMREFRESH

DATETIME

 

CUREXPENSESBO

DECIMAL(19,4)

 

CURINCOMEBO

DECIMAL(19,4)

 

DBLSAFEFLOAT

DECIMAL(19,4)

 

DBLSAFETOTAL

DECIMAL(19,4)

 

INTCHANGEFLAG

INT

 

INTNEWFLAG

INT

 

STRAUTHORISEDBY

VARCHAR(10)

 

DTMSTATUS

DATETIME

 

 

Primary Key: CTRCODE

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