| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ACRC | Credit Cards | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 2 | AEXD | Freight Setup | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Incr., D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 3 | OALC | Loading Expenses | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Data Doc., I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 4 | OALR | Alerts | 12 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 5 | OCDT | Credit Card Payment | 22 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 6 | OCFP | CFOP for Nota Fiscal | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Incr., D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, U=Update |
| 7 | OCRC | Credit Cards | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 8 | OCRN | Currency Codes | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 9 | OCRP | Payment Methods | 10 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 10 | ODOW | Data Ownership - Objects | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 11 | ODOX | Data Ownership - Exceptions | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 12 | OEXD | Freight Setup | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Incr., D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 13 | OIDX | CPI Codes | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 14 | OLNG | User Language Table | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 15 | OMLS | Distribution List | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 16 | OMLT | Multi-Language Translation | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 17 | OPVL | Lender - Pelecard | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 18 | OSHP | Delivery Types | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 19 | OTSC | CST Code for Nota Fiscal | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Incr., D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, T=Year Transfer, U=Update |
| 20 | OUSG | Usage of Nota Fiscal | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Incr., D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPBanking |
| 21 | ABOE | Bill of Exchange for Payment - History | 35 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 22 | ACHO | Checks for Payment - History | 36 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 23 | ARCT | Incoming Payment - History | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Restore Wizard, D=Partner Implementation, I=Update, M=DI API, N=Interface, O=Doc. Generation Wizard, P=Year Transfer, T=Yes, U=Import |
| 24 | OBNK | External Bank Statement Received | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 25 | OBOE | Bill of Exchange for Payment | 35 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 26 | OCHD | Checks for Payment Drafts | 36 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 27 | OCHO | Checks for Payment | 36 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 28 | OCRV | Credit Payments | 26 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 29 | OCTG | Payment Terms | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 30 | ODPS | Deposit | 36 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 31 | ODPT | Postdated Deposit | 21 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 32 | ODSC | Bank Codes | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 33 | OITR | Internal Reconciliation | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Incr., D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, T=Year Transfer, U=Update |
| 34 | OMTH | Reconciliation History | 10 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 35 | OPDF | Payment Draft | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 36 | OPYM | Payment Methods for Payment Wizard | 16 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 37 | ORCT | Incoming Payment | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 38 | OVPM | Outgoing Payments | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPBusiness Partners |
| 39 | ACPR | Contact Persons - History | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 40 | ACRD | Business Partners - History | 142 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 41 | DDT1 | Withholding Tax Deduction Hierarchy - Rows | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Data Doc., I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 42 | OCLG | Activities | 18 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 43 | OCLO | Meetings Location | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 44 | OCLS | Activity Subjects | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 45 | OCLT | Activity Types | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, p=Partner Implementation, T=Year Transfer, U=Update |
| 46 | OCOG | Commission Groups | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 47 | OCPR | Contact Persons | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 48 | OCRD | Business Partner | 142 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 49 | OCRG | Card Groups | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 50 | ODDT | Withholding Tax Deduction Hierarchy | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 51 | OPRT | Partners | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 52 | OSCN | Customer/Vendor Cat. No. | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 53 | OSLP | Sales Employee | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPFinance |
| 54 | AACT | G/L Account - History | 45 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 55 | AFPR | Posting Period-Log | 12 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 56 | AJDT | Journal Entry - History | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 57 | AVTG | Tax Definition | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 58 | OACT | G/L Accounts | 45 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 59 | OBGD | Budget Cost Assess. Mthd | 16 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 60 | OBGS | Budget Scenario | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 61 | OBTF | Journal Voucher Entry | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 62 | ODDG | Withholding Tax Deduction Groups | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 63 | OFPR | Posting Period | 12 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 64 | OJDT | Journal Entry | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 65 | OMDR | Manual Distribution Rule | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 66 | OPRJ | Project Codes | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 67 | ORCR | Recurring Postings | 19 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 68 | ORTS | CPI and FC Rates for Reports | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 69 | ORTT | CPI and FC Rates | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 70 | OTRC | Journal Entry Codes | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 71 | OTRT | Posting Templates | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 72 | OVTG | Tax Definition | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPInventory and Production |
| 73 | AITB | Item Groups - History | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 74 | AITM | Items - History | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 75 | AITT | Product Tree - History | 9 | DataSource | Data source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 76 | AMRV | Inventory Revaluation - History | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto. Incr., D=Data Document, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 77 | AWHS | Warehouses - History | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 78 | OARG | Customs Groups | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 79 | OBTN | Batch Numbers Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 80 | OBTW | Batch Attributes in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 81 | ODBN | Bat. Nos - Draft - Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 82 | ODBW | Batch Draft Attribs in Locat. | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 83 | ODSN | SNs - Draft - Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 84 | ODSW | SN Draft Attribs in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 85 | OENT | Shipping Types | 39 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 86 | OIBT | Batch No. for Item | 25 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 87 | OIGE | Goods Issue | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 88 | OIGN | Goods Receipt | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 89 | OILM | Inventory Log Message | 33 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 90 | OINM | Whse Journal | 28 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 91 | OIPF | Landed Costs | 46 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 92 | OIQI | Inventory Initial Quantity | 10 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 93 | OIQR | Inventory Stock Posting (Reconcile) | 10 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 94 | OIRT | Interest Prices | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 95 | OITB | Item Groups | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 96 | OITM | Items | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 97 | OITT | Product Tree | 9 | DataSource | Data source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 98 | OIVL | Whse Journal | 62 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, U=Upgrade, Y=Year Transfer |
| 99 | OLGT | Length Units | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 100 | OMRC | Manufacturers | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 101 | OMRL | Advanced Inventory Revaluation | 21 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 102 | OMRV | Inventory Revaluation | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 103 | OPLN | Price Lists | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 104 | ORCN | Retail Chains | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 105 | OSPG | Special Prices for Groups | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 106 | OSRI | Serial Numbers for Items | 25 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Document Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 107 | OSRN | Serial Numbers Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 108 | OSRW | Serial No. Attribs in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 109 | OWGT | Weight Units | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 110 | OWHS | Warehouses | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 111 | OWKO | Production Instructions | 26 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 112 | OWTR | Inventory Transfer | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 113 | UILM | IVI Inventory Log Message | 33 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 114 | UITM | Items | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Document Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 115 | UIVL | Whse Journal | 62 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, U=Upgrade, Y=Year Transfer |
| 116 | UWKO | Production Instructions | 26 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPMarketing Documents |
| 117 | ADOC | Invoice - History | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 118 | OCIN | A/R Correction Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 119 | OCPI | A/P Correction Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 120 | OCPV | A/P Correction Invoice Reversal | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 121 | OCSI | A/R Correction Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 122 | OCSV | A/R Correction Invoice Reversal | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 123 | ODLN | Delivery | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 124 | ODPI | A/R Down Payment | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 125 | ODPO | A/P Down Payment | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 126 | ODRF | Drafts | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 127 | OIEI | Incoming Excise Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, U=Upgrade |
| 128 | OINV | A/R Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 129 | OOEI | Outgoing Excise Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Data Doc., I=Interface, M=Import, N=Unknown, O=OBServer, P=Partner Implementation, U=Upgrade |
| 130 | OPCH | A/P Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 131 | OPDN | Goods Receipt PO | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 132 | OPOR | Purchase Order | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 133 | OQUT | Sales Quotation | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 134 | ORDN | Returns | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 135 | ORDR | Sales Order | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 136 | ORIN | A/R Credit Memo | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 137 | ORPC | A/P Credit Memo | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 138 | ORPD | Goods Return | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 139 | OSAL | Outgoing | 39 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 140 | OTRA | Transition | 39 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPReports |
| 141 | OQCN | Query Catagories | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Upgrade |
| 142 | RITM | Reporting Element | 41 | DataSource | Data Source | Int | 6 | 0 | 1 | 1=Static, 2=Variable, 3=Data, 4=Calculation |
| TOPSales Opportunities |
| 143 | OCMT | Competitors | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 144 | OOCR | Loading Factors | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| 145 | OPRC | Profit Center | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
| TOPService |
| 146 | OAGP | Agent Name | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update |
