| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinance |
| 1 | OCFL | Cash Flow Additional Trans. | 11 | Frequency | Frequency | VarChar | 1 | 0 | O | A=Annually, D=Daily, M=Monthly, O=One Time, Q=Quarterly, S=Semiannually, W=Weekly |
| 2 | ORCR | Recurring Postings | 3 | Frequency | Frequency | VarChar | 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 |
| TOPInventory and Production |
| 3 | OCYC | Cycle | 3 | Frequency | Frequency | VarChar | 1 | 0 | | 0=Daily, 1=Weekly, 2=Every Four Weeks, 3=Monthly, 4=Quarterly, 5=Semiannually, 6=Annually, 7=None, 8=Every "X" Days: |
| TOPMarketing Documents |
| 4 | ORCP | Recurring Transaction Template | 7 | Frequency | Frequency | VarChar | 1 | 0 | M | A=Annually, D=Daily, M=Monthly, O=One Time, Q=Quarterly, S=Semiannually, W=Weekly |
