Cost table

Description

This contains additional billing information for Watchdoc. For the bank of France, it is possible to have the min and max consumption.

 

Schema

Field

Type

Required

Primary key

Description

cstId

int

*

*

Insert ID (identity)

cstA4NB

float

.

 

Cost of one A4 page black&white.

cstA4C

float

.

 

Cost of one A4 color page

cstA3NB

float

.

 

Cost of one page A3 black & white

cstA3C

float

.

 

Cost of an A3 color page

cstQUEUE

nvarchar(64)

.

 

Watchdoc Id of the print queue

cstLOYER

float

.

 

Cost of the print queue

cstSCAN

float

.

 

Cost of scan

cstSERIALNUMBER

nvarchar(64)

.

 

Serial number of the print queue

cstCOSTSTART

datetime

.

 

Start date of the contract for the print queue

cstMODEL

nvarchar(64)

.

 

Model of the print queue

cstCOSTSTOP

datetime

.

 

End date of the contract for the print queue

cstUSAGEMIN

int

.

 

Maximum number of pages per month for the print queue

cstUSAGEMAX

int

.

 

Minimum number of pages per month for the print queue

cstLOYERA4C

int

.

 

A4 color pages included in the rent

cstLOYERA4NB

int

.

 

A4 black & white pages included in the rent

cstEXTRA

nvarchar(64)

.

 

Comment on the print queue

cstDIRECTION

nvarchar(64)

.

 

Allocation of the print queue

cstLOCATION

nvarchar(64)

.

 

Location of the print queue

cstADRESSEMAC

nvarchar(64)

.

 

Mac address of the print queue

cstMAINTENANCE

float

.

 

Cost of the maintenance of the print queue