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 |