| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Code | Code | int | 11 | 0 | | | | Allow NULL? |
| 2 | DateID | Date | date | 8 | 0 | | | | |
| 3 | Dscription | Description | nvarchar | 50 | 0 | | | | Allow NULL? |
| 4 | Project | Project Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | Credit | Incoming Total | num | 19 | 6 | | | | Allow NULL? |
| 6 | CredCur | Entrance Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | Debit | Outgoing Amount | num | 19 | 6 | | | | Allow NULL? |
| 8 | DebCur | Issue Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | SecLevel | Security Level | int | 6 | 0 | | 1 | 1=Cash Account, 2=Checks, 3=Customer Liabilities, 4=Payable to Vendors, 5=Credit, 6=Bill of Exchange, 7=Customer Forecast, 8=Vendor Forecast | Allow NULL? |
| 10 | UserId | User ID | int | 6 | 0 | | | | Allow NULL? |
| 11 | Frequency | Frequency | char | 1 | 0 | | O | A=Annually, D=Daily, M=Monthly, O=One Time, Q=Quarterly, S=Semiannually, W=Weekly | Allow NULL? |
| 12 | Remind | Subfrequency | int | 6 | 0 | | -1 | -1, 1001=On 1, 1002=On 2, 1003=On 3, 1004=On 4, 1005=On 5, 1006=On 6, 1007=On 7, 1008=On 8, 1009=On 9, 1010=On 10, 1011=On 11, 1012=On 12, 1013=On 13, 1014=On 14, 1015=On 15, 1016=On 16, 1017=On 17, 1018=On 18, 1019=On 19, 101=Every 1, 1020=On 20, 1021=On 21, 1022=On 22, 1023=On 23, 1024=On 24, 1025=On 25, 1026=On 26, 1027=On 27, 1028=On 2 | Allow NULL? |
| 13 | EndDate | Execution End Date | date | 8 | 0 | | | | |
| 14 | OcrCode | Distribution Rule 1 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 15 | OcrCode2 | Distribution Rule 2 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 16 | OcrCode3 | Distribution Rule 3 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 17 | OcrCode4 | Distribution Rule 4 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
| 18 | OcrCode5 | Distribution Rule 5 | nvarchar | 8 | 0 | OOCR | | | Allow NULL? |
