Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | OPCI | Process Checklist Instance | 10 | Memo | Remarks | Text | 16 | 0 | ||
2 | TRN1 | Subtable of OTRN | 8 | Memo | Memo | Text | 16 | 0 | ||
Banking | ||||||||||
3 | MTH2V | Bank Statements of External Reconciliation | 9 | Memo | Details | nVarChar | 254 | 0 | ||
4 | OBNK | External Bank Statement Received | 7 | Memo | Details | nVarChar | 254 | 0 | ||
5 | ODPS | Deposit | 9 | Memo | Details | nVarChar | 250 | 0 | ||
6 | ODPT | Postdated Deposit | 6 | Memo | Details | nVarChar | 250 | 0 | ||
Business Partners | ||||||||||
7 | ACP3 | Campaign - Partners | 6 | Memo | Details | nVarChar | 50 | 0 | ||
8 | CPN3 | Campaign - Partners | 6 | Memo | Details | nVarChar | 50 | 0 | ||
9 | OPRT | Partners | 5 | Memo | Details | nVarChar | 50 | 0 | ||
10 | OSLP | Sales Employee | 3 | Memo | Remarks | nVarChar | 50 | 0 | ||
Finance | ||||||||||
11 | AJDT | Journal Entry - History | 7 | Memo | Remarks | nVarChar | 50 | 0 | ||
12 | CCPD | Period-End Closing | 9 | Memo | Row Details | nVarChar | 50 | 0 | ||
13 | OBTF | Journal Voucher Entry | 7 | Memo | Remarks | nVarChar | 50 | 0 | ||
14 | OHSV | Hasavsevet Journal Entry | 7 | Memo | Details | nVarChar | 22 | 0 | ||
15 | OJDT | Journal Entry | 7 | Memo | Remarks | nVarChar | 50 | 0 | ||
16 | ORCR | Recurring Postings | 14 | Memo | Details | nVarChar | 50 | 0 | ||
17 | OTRT | Posting Templates | 4 | Memo | Details | nVarChar | 50 | 0 | ||
General | ||||||||||
18 | ORCJ | Resource Capacity Log | 21 | Memo | Memo | Text | 16 | 0 | ||
Inventory and Production | ||||||||||
19 | OWKO | Production Instructions | 15 | Memo | Remarks | nVarChar | 254 | 0 | ||
20 | UWKO | Production Instructions | 15 | Memo | Remarks | nVarChar | 254 | 0 | ||
Sales Opportunities | ||||||||||
21 | AOPR | Opportunity | 20 | Memo | Remarks | Text | 16 | 0 | ||
22 | OCMT | Competitors | 4 | Memo | Details | nVarChar | 50 | 0 | ||
23 | OOPR | Opportunity | 20 | Memo | Remarks | Text | 16 | 0 | ||
24 | OPR1 | Opportunity - Rows | 11 | Memo | Remarks | Text | 16 | 0 | ||
25 | OPR2 | Opportunity - Partners | 4 | Memo | Details | nVarChar | 50 | 0 | ||
26 | OPR3 | Opportunity - Competitors | 4 | Memo | Details | nVarChar | 50 | 0 | ||
Service | ||||||||||
27 | OAGP | Agent Name | 3 | Memo | Description | nVarChar | 50 | 0 |