Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
Organization | nvarchar | 510 | √ | null |
|
|
||
Site | nvarchar | 510 | √ | null |
|
|
||
ClientCode | nvarchar | 510 | √ | null |
|
|
||
ClientName | nvarchar | 510 | √ | null |
|
|
||
InvoiceNo | nvarchar | 510 | √ | null |
|
|
||
Reference | nvarchar | 510 | √ | null |
|
|
||
ARAccount | nvarchar | 510 | √ | null |
|
|
||
InvoiceDate | date | 6 | √ | null |
|
|
||
0 - 29 | money | 21,4 | √ | null |
|
|
||
30 - 59 | money | 21,4 | √ | null |
|
|
||
60 - 89 | money | 21,4 | √ | null |
|
|
||
90 - 119 | money | 21,4 | √ | null |
|
|
||
120 + | money | 21,4 | √ | null |
|
|
||
Total | money | 21,4 | √ | null |
|
|
||
ClosingPeriod | date | 6 | √ | null |
|
|
||
AVA_insdate | datetime2 | 16,3 | √ | (getdate()) |
|
|
||
AVA_archfilepath | nvarchar | 510 | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors