Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
ClosingPeriod | date | 6 | √ | null |
|
|
||
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 |
|
|
||
Total | money | 21,4 | √ | null |
|
|
||
AgingDays | int | 4 | √ | null |
|
|
||
AdjustedAgingDays | int | 4 | √ | null |
|
|
||
0 - 30 | money | 21,4 | √ | null |
|
|
||
31 - 60 | money | 21,4 | √ | null |
|
|
||
61 - 90 | money | 21,4 | √ | null |
|
|
||
91 - 120 | money | 21,4 | √ | null |
|
|
||
121 - 150 | money | 21,4 | √ | null |
|
|
||
151 - 180 | money | 21,4 | √ | null |
|
|
||
181 - 210 | money | 21,4 | √ | null |
|
|
||
211 - 240 | money | 21,4 | √ | null |
|
|
||
241 - 270 | money | 21,4 | √ | null |
|
|
||
271 - 300 | money | 21,4 | √ | null |
|
|
||
301 - 330 | money | 21,4 | √ | null |
|
|
||
331 - 360 | money | 21,4 | √ | null |
|
|
||
361+ | money | 21,4 | √ | null |
|
|