Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | OPPA | Password Administration | 2 | SecLevel | Security Level | nVarChar | 20 | 0 | Low | Custom=Custom, High=High, Low=Low, Medium=Medium |
Finance | ||||||||||
2 | OCFL | Cash Flow Additional Trans. | 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 |