Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Organization | nvarchar | 510 | √ | null |
|
|
||
| Site | nvarchar | 510 | √ | null |
|
|
||
| Client code | nvarchar | 510 | √ | null |
|
|
||
| Client name | nvarchar | 510 | √ | null |
|
|
||
| Invoice No. | nvarchar | 510 | √ | null |
|
|
||
| Reference | nvarchar | 510 | √ | null |
|
|
||
| AR Account | nvarchar | 510 | √ | null |
|
|
||
| Invoice date | nvarchar | 510 | √ | null |
|
|
||
| 0 - 29 | nvarchar | 510 | √ | null |
|
|
||
| 30 - 59 | nvarchar | 510 | √ | null |
|
|
||
| 60 - 89 | nvarchar | 510 | √ | null |
|
|
||
| 90 - 119 | nvarchar | 510 | √ | null |
|
|
||
| 120 + | nvarchar | 510 | √ | null |
|
|
||
| Total | nvarchar | 510 | √ | 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