| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ACFP | CFOP for Nota Fiscal | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 2 | 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 |
| 3 | 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 |
| 4 | ATSC | CST Code for Nota Fiscal | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 5 | 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 |
| 6 | 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 |
| 7 | 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 |
| 8 | OCFP | CFOP for Nota Fiscal | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 9 | 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 |
| 10 | 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 |
| 11 | 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 |
| 12 | 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 |
| 13 | 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 |
| 14 | 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 |
| 15 | 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 |
| 16 | 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 |
| 17 | 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 |
| 18 | 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 |
| 19 | 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 |
| 20 | 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 |
| 21 | OTSC | CST Code for Nota Fiscal | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 22 | OUSG | Usage of Nota Fiscal | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| TOPBanking |
| 23 | 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 |
| 24 | 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 |
| 25 | ARCT | Incoming Payment - History | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 26 | OBNK | External Bank Statement Received | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 27 | 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 |
| 28 | 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 |
| 29 | 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 |
| 30 | OCRV | Credit Payments | 26 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 31 | 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 |
| 32 | ODPS | Deposit | 36 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 33 | ODPT | Postdated Deposit | 21 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 34 | ODSC | Bank Codes | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 35 | OITR | Internal Reconciliation | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 36 | 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 |
| 37 | OPDF | Payment Draft | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 38 | OPYM | Payment Methods for Payment Wizard | 16 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 39 | ORCT | Incoming Payment | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 40 | OVPM | Outgoing Payments | 67 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| TOPBusiness Partners |
| 41 | ACPN | Campaign | 19 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 42 | ACPR | Contact Persons - History | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 43 | ACRD | Business Partners - History | 142 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 44 | AOAT | Blanket Agreement | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 45 | 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 |
| 46 | OCLG | Activities | 18 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 47 | 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 |
| 48 | 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 |
| 49 | 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 |
| 50 | 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 |
| 51 | OCPN | Campaign | 19 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 52 | OCPR | Contact Persons | 14 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 53 | OCRD | Business Partner | 142 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 54 | 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 |
| 55 | 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 |
| 56 | OOAT | Blanket Agreement | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 57 | OPRT | Partners | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 58 | 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 |
| 59 | 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 |
| 60 | AACT | G/L Account - History | 45 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 61 | 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 |
| 62 | AJDT | Journal Entry - History | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 63 | AMDR | Manual Distribution Rule | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 64 | AVTG | Tax Definition | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 65 | OACR | Accrual Type | 7 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 66 | OACT | G/L Accounts | 45 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 67 | 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 |
| 68 | OBGS | Budget Scenario | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 69 | OBTF | Journal Voucher Entry | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 70 | OCCT | Cost Center Type | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 71 | 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 |
| 72 | 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 |
| 73 | OJDT | Journal Entry | 24 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 74 | OJET | JE Docment Type | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 75 | OMDR | Manual Distribution Rule | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 76 | OPRJ | Project Codes | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 77 | 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 |
| 78 | 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 |
| 79 | 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 |
| 80 | OTRC | Journal Entry Codes | 4 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 81 | 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 |
| 82 | OVTG | Tax Definition | 8 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| TOPHuman Resources |
| 83 | OIDT | Employee ID Type | 3 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| TOPInventory and Production |
| 84 | ABTN | Batch Numbers Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 85 | ABTW | Batch Attributes in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 86 | 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 |
| 87 | AITM | Items - History | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 88 | 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 |
| 89 | AMRV | Inventory Revaluation - History | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 90 | ASRN | Serial Numbers Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 91 | AWHS | Warehouses - History | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 92 | 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 |
| 93 | OBTN | Batch Numbers Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 94 | OBTW | Batch Attributes in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 95 | ODBN | Bat. Nos - Draft - Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 96 | ODBW | Batch Draft Attribs in Locat. | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 97 | ODSN | SNs - Draft - Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 98 | ODSW | SN Draft Attribs in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 99 | 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 |
| 100 | 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 |
| 101 | OIGE | Goods Issue | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 102 | OIGN | Goods Receipt | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 103 | OILM | Inventory Log Message | 33 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 104 | 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 |
| 105 | OIPF | Landed Costs | 46 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 106 | OIQI | Inventory Initial Quantity | 10 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 107 | OIQR | Inventory Stock Posting (Reconcile) | 10 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 108 | 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 |
| 109 | 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 |
| 110 | OITM | Items | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 111 | 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 |
| 112 | OIVL | Whse Journal | 62 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 113 | 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 |
| 114 | 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 |
| 115 | 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 |
| 116 | OMRV | Inventory Revaluation | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 117 | 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 |
| 118 | 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 |
| 119 | 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 |
| 120 | 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 |
| 121 | OSRN | Serial Numbers Master Data | 15 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 122 | OSRW | Serial No. Attribs in Location | 5 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 123 | 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 |
| 124 | OWHS | Warehouses | 9 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 125 | 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 |
| 126 | OWTQ | Inventory Transfer Request | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 127 | OWTR | Inventory Transfer | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 128 | SITM | Items | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 129 | SIVL | Whse Journal | 62 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 130 | UILM | IVI Inventory Log Message | 33 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 131 | UITM | Items | 188 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 132 | UIVL | Whse Journal | 62 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 133 | 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 |
| 134 | ADOC | Invoice - History | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 135 | OCIN | A/R Correction Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 136 | OCPI | A/P Correction Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 137 | OCPV | A/P Correction Invoice Reversal | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 138 | OCSI | A/R Correction Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 139 | OCSV | A/R Correction Invoice Reversal | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 140 | ODLN | Delivery | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 141 | ODPI | A/R Down Payment | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 142 | ODPO | A/P Down Payment | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 143 | ODRF | Drafts | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 144 | OIEI | Incoming Excise Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 145 | OINV | A/R Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 146 | OOEI | Outgoing Excise Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 147 | OPCH | A/P Invoice | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 148 | OPDN | Goods Receipt PO | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 149 | OPOR | Purchase Order | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 150 | OPQT | Purchase Quotation | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 151 | OQUT | Sales Quotation | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 152 | ORCP | Recurring Transaction Template | 18 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 153 | ORDN | Returns | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 154 | ORDR | Sales Order | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 155 | ORIN | A/R Credit Memo | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 156 | ORPC | A/P Credit Memo | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 157 | ORPD | Goods Return | 73 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 158 | 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 |
| 159 | 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 |
| 160 | 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 |
| 161 | RITM | Reporting Element | 41 | DataSource | Data Source | Int | 6 | 0 | 1 | |
| TOPSales Opportunities |
| 162 | AOCR | Distribution Rule | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 163 | 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 |
| 164 | OOCR | Distribution Rule | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| 165 | OPRC | Cost Center | 6 | DataSource | Data Source | VarChar | 1 | 0 | N | |
| TOPService |
| 166 | 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 |
