Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| accmodel | varchar | 10 | √ | null |
|
|
|||||
| journal | varchar | 10 | √ | null |
|
|
|||||
| account | varchar | 10 | √ | null |
|
|
|||||
| accountlabel | varchar | 250 | √ | null |
|
|
|||||
| subaccount | varchar | 30 | √ | null |
|
|
|||||
| subaccountlabel | varchar | 250 | √ | null |
|
|
|||||
| accid | int8 | 19 | √ | null |
|
|
|||||
| accsubid | int8 | 19 | √ | null |
|
|
|||||
| auxiliarycode | varchar | 30 | √ | null |
|
|
|||||
| companycode | varchar | 10 | √ | null |
|
|
|||||
| axe1 | varchar | 30 | √ | null |
|
|
|||||
| axe2 | varchar | 30 | √ | null |
|
|
|||||
| ctrid | int8 | 19 | √ | null |
|
|
|||||
| ctreference | varchar | 30 | √ | null |
|
|
|||||
| prcode | varchar | 10 | √ | null |
|
|
|||||
| offerid | int8 | 19 | √ | null |
|
|
|||||
| startamount | float8 | 17,17 | √ | null |
|
|
|||||
| totaldebit | float8 | 17,17 | √ | null |
|
|
|||||
| totalcredit | float8 | 17,17 | √ | null |
|
|
|||||
| endamount | float8 | 17,17 | √ | null |
|
|
|||||
| percode | varchar | 10 | √ | null |
|
|