| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Finance | ||||||||||
| 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 |
| Inventory 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: | |