| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | RcurCode | Recurring Postings Code | nvarchar | 8 | 0 | | | | Allow NULL? |
| 2 | RcurDesc | Transaction Description | nvarchar | 50 | 0 | | | | Allow NULL? |
| 3 | Frequency | Frequency | char | 1 | 0 | | M | A=Annually, D=Daily, M=Monthly, N=Not executed yet, O=One Time, Q=Quarterly, S=Semi-annually, T=Template, W=Weekly | Allow NULL? |
| 4 | Remind | Sub-Frequency | int | 6 | 0 | | 1 | | Allow NULL? |
| 5 | LastPosted | Last Executed | date | 8 | 0 | | | | |
| 6 | NextDeu | Next Execution | date | 8 | 0 | | | | |
| 7 | EntryCount | Entries Counter | int | 6 | 0 | | 0 | | Allow NULL? |
| 8 | Volume | Transaction Amount | num | 19 | 6 | | | | Allow NULL? |
| 9 | VolCurr | Total Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | FinancVol | Total Monetary Val. of Trans. | num | 19 | 6 | | | | Allow NULL? |
| 11 | Ref1 | Reference 1 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 12 | Ref2 | Reference 2 | nvarchar | 11 | 0 | | | | Allow NULL? |
| 13 | TransCode | Transaction Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | Memo | Details | nvarchar | 50 | 0 | | | | Allow NULL? |
| 15 | LimitRtrns | Returns Limit | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 16 | Returns | No. of Returns | int | 6 | 0 | | | | Allow NULL? |
| 17 | LimitDate | Date Limit | date | 8 | 0 | | | | |
| 18 | Instance | Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 19 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 20 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 21 | StampTax | Stamp Tax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 22 | AutoVat | Automatic VAT | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 23 | ManageWTax | Manage WTax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 24 | Ref3 | Reference 3 | nvarchar | 11 | 0 | | | | Allow NULL? |