| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFinance |
| 1 | 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 |
| 2 | OCYC | Cycle | 3 | Frequency | Frequency | VarChar | 1 | 0 | | 0=Daily, 1=Weekly, 2=Every 4 Weeks, 3=Monthly, 4=Quarterly, 5=Half Yearly, 6=Annually, 7=One Time, 8=Every X days: |
| TOPMarketing Documents |
| 3 | ORCP | Recurring Transaction Template | 7 | Frequency | Frequency | VarChar | 1 | 0 | M | |
