| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Banking | ||||||||||
| 1 | OBNK | External Bank Statement Received | 7 | Memo | Details | nVarChar | 254 | 0 | ||
| 2 | ODPS | Deposit | 9 | Memo | Details | nVarChar | 250 | 0 | ||
| 3 | ODPT | Postdated Deposit | 6 | Memo | Details | nVarChar | 250 | 0 | ||
| Business Partners | ||||||||||
| 4 | OPRT | Partners | 5 | Memo | Details | nVarChar | 50 | 0 | ||
| 5 | OSLP | Sales Employee | 3 | Memo | Remarks | nVarChar | 50 | 0 | ||
| Finance | ||||||||||
| 6 | AJDT | Journal Entry - History | 7 | Memo | Details | nVarChar | 50 | 0 | ||
| 7 | CCPD | Period-End Closing | 9 | Memo | Row Details | nVarChar | 50 | 0 | ||
| 8 | OBTF | Journal Voucher Entry | 7 | Memo | Details | nVarChar | 50 | 0 | ||
| 9 | OHSV | Hasavsevet Journal Entry | 7 | Memo | Details | nVarChar | 22 | 0 | ||
| 10 | OJDT | Journal Entry | 7 | Memo | Details | nVarChar | 50 | 0 | ||
| 11 | ORCR | Recurring Postings | 14 | Memo | Details | nVarChar | 50 | 0 | ||
| 12 | OTRT | Posting Templates | 4 | Memo | Details | nVarChar | 50 | 0 | ||
| Inventory and Production | ||||||||||
| 13 | OWKO | Production Instructions | 15 | Memo | Remarks | nVarChar | 254 | 0 | ||
| 14 | UWKO | Production Instructions | 15 | Memo | Remarks | nVarChar | 254 | 0 | ||
| Sales Opportunities | ||||||||||
| 15 | OCMT | Competitors | 4 | Memo | Details | nVarChar | 50 | 0 | ||
| 16 | OOPR | Sales Opportunity | 20 | Memo | Remarks | Text | 16 | 0 | ||
| 17 | OPR1 | Sales Opportunity - Rows | 11 | Memo | Remarks | Text | 16 | 0 | ||
| 18 | OPR2 | Sales Opportunity - Partners | 4 | Memo | Details | nVarChar | 50 | 0 | ||
| 19 | OPR3 | Sales Opportunity - Competitors | 4 | Memo | Details | nVarChar | 50 | 0 | ||
| Service | ||||||||||
| 20 | OAGP | Agent Name | 3 | Memo | Description | nVarChar | 50 | 0 | ||