| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | ALR1 | Queue of messages to be sent | 8 | Status | Status | VarChar | 1 | 0 | U | P=In Process, S=Sent, U=Not Sent |
| 2 | APJ1 | Project Plan Steps | 15 | Status | Status | Int | 11 | 0 | 0 | |
| 3 | AWLS | Workflow - Task Details | 19 | Status | Status | VarChar | 1 | 0 | W | C=Cancelling, D=Completing, E=Error, F=Completed, G=In Progress, N=Suspended, O=Forwarding, P=Picking, Q=Canceled, S=Setup, W=To Be Picked |
| 4 | AWMG | Workflow Manager | 7 | Status | Status | VarChar | 1 | 0 | I | A=Active, F=Import failed, I=Inactive, M=Importing, P=Imported |
| 5 | OMDC | Master Data Cleanup | 5 | Status | Status | VarChar | 1 | 0 | | E=Executed, S=Saved |
| 6 | OPCI | Process Checklist Instance | 6 | Status | Instance Status | VarChar | 1 | 0 | N | F=Finished, N=New, P=In Process |
| 7 | ORLD | Reference Links Definition | 4 | Status | Status | VarChar | 1 | 0 | O | C=Customized, O=Original |
| 8 | OWFI | Workflow - Instances | 5 | Status | Status | nVarChar | 8 | 0 | | C=Cancelling, E=Error, F=Completed, G=In Progress, Q=Canceled, S=Setup |
| 9 | OWLS | Workflow - Task Details | 19 | Status | Status | VarChar | 1 | 0 | W | C=Cancelling, D=Completing, E=Error, F=Completed, G=In Progress, N=Suspended, O=Forwarding, P=Picking, Q=Canceled, S=Setup, W=To Be Picked |
| 10 | OWMG | Workflow Manager | 7 | Status | Status | VarChar | 1 | 0 | I | A=Active, D=Deleted, E=Activation failed, F=Import failed, I=Inactive, M=Importing, P=Imported |
| 11 | OWTJ | Workflow Timer Job | 3 | Status | Status | nVarChar | 10 | 0 | | |
| 12 | PJT1 | Project Plan Steps | 15 | Status | Status | Int | 11 | 0 | 0 | |
| 13 | USR1 | Short Cut | 1 | STATUS | Status | VarChar | 1 | 0 | | |
| TOPBanking |
| 14 | ARCT | Incoming Payment - History | 84 | Status | Created by Payment Wizard | VarChar | 1 | 0 | N | C=Yes, N=BoE Canceled, Y=No |
| 15 | CHO2 | Checks for Payment - Print Status | 3 | Status | Status | VarChar | 1 | 0 | N | D=Details, N=Not Confirmed, O=Overflow, T=Not Printed, V=Void |
| 16 | OBNH | Bank Statement Header | 5 | Status | Status | VarChar | 1 | 0 | D | D=Draft, E=Finalized, O=Old |
| 17 | OPDF | Payment Draft | 84 | Status | Created by Payment Run | VarChar | 1 | 0 | N | C=BoE Canceled, N=No, Y=Yes |
| 18 | OPEX | Payment Results Table | 40 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 19 | OPWZ | Payment Wizard | 20 | Status | Object Status | VarChar | 1 | 0 | S | E=Executed Wizard, R=Recommended Wizard, S=Saved Wizard |
| 20 | ORCT | Incoming Payment | 84 | Status | Created by Payment Run | VarChar | 1 | 0 | N | C=BoE Canceled, N=No, Y=Yes |
| 21 | OVPM | Outgoing Payments | 84 | Status | Created by Payment Run | VarChar | 1 | 0 | N | C=BoE Canceled, N=No, Y=Yes |
| 22 | PWZ3 | Payment Wizard - Rows 3 | 56 | Status | Inv Status | VarChar | 1 | 0 | | |
| TOPBusiness Partners |
| 23 | ACP1 | Campaign - BPs | 7 | Status | BP Status | VarChar | 1 | 0 | | A=Active, I=Inactive |
| 24 | ACPN | Campaign | 6 | Status | Campaign Status | VarChar | 1 | 0 | O | C=Canceled, F=Finished, O=Open |
| 25 | AOAT | Blanket Agreement | 10 | Status | Agreement Status | VarChar | 1 | 0 | D | A=Approved, C=Canceled, D=Draft, F=On Hold, T=Terminated |
| 26 | CPN1 | Campaign - BPs | 7 | Status | BP Status | VarChar | 1 | 0 | | A=Active, I=Inactive |
| 27 | OCLG | Activities | 42 | status | Status | Int | 11 | 0 | | |
| 28 | OCPN | Campaign | 6 | Status | Campaign Status | VarChar | 1 | 0 | O | C=Canceled, F=Finished, O=Open |
| 29 | OOAT | Blanket Agreement | 10 | Status | Agreement Status | VarChar | 1 | 0 | D | A=Approved, C=Canceled, D=Draft, F=On Hold, T=Terminated |
| TOPFinance |
| 30 | AJD2 | Withholding Tax - History | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 31 | BTF2 | Journal Voucher Withholding Tax - History | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 32 | FAM1 | Fixed Asset Data Migration - Rows | 6 | Status | Status | VarChar | 1 | 0 | Y | N=Failed, Y=Successful |
| 33 | JDT2 | Withholding Tax - History | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 34 | OBTD | Journal Vouchers List | 2 | Status | Open/Closed Document | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 35 | OCFT | Cash Flow Transactions - Rows | 20 | Status | Status | VarChar | 1 | 0 | | |
| 36 | ODRN | Depreciation Run | 5 | Status | Status | VarChar | 1 | 0 | D | C=Canceled, F=Failed, N=No Depreciation Posted, S=Depreciation Posted |
| 37 | OFAM | Fixed Asset Data Migration | 11 | Status | Status of Migration Run | VarChar | 1 | 0 | S | F=Failed, P=Partially Successful, S=Successful |
| 38 | OISW | Intrastat Wizard | 7 | Status | Status | VarChar | 1 | 0 | | A=Archived, C=Closed, D=Deleted, O=Open |
| 39 | OSCM | Special Ledger - Analytical Accounting Configuration Rules: Material | 4 | Status | Rule Status | VarChar | 1 | 0 | | |
| 40 | OSCR | Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses | 4 | Status | Rule Status | VarChar | 1 | 0 | | |
| 41 | OSLM | Special Ledger - Analytical Accounting Report: Material | 5 | Status | Document Status | VarChar | 1 | 0 | | |
| 42 | OSLR | Special Ledger - Analytical Accounting Report: Revenues & Expenses | 5 | Status | Document Status | VarChar | 1 | 0 | | |
| 43 | OVRW | VAT Reposting Wizard | 4 | Status | Status | VarChar | 1 | 0 | E | C=Canceled, D=Draft, E=Executed, S=Saved |
| 44 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 9 | Status | Status | VarChar | 1 | 0 | | |
| 45 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 9 | Status | Status | VarChar | 1 | 0 | | |
| TOPGeneral |
| 46 | EMSTT | EMSTT | 3 | Status | Status | nVarChar | 30 | 0 | | |
| 47 | NFN5 | NF Skipped Numbers | 7 | Status | Status | VarChar | 1 | 0 | N | A=Approved, E=Error, N=New, S=Sent |
| 48 | OBTA | Brazil - Tax Adjustment | 2 | Status | Status | VarChar | 1 | 0 | O | C=Canceled, O=Open |
| 49 | ODAB | Dashboard | 7 | Status | Dashboard Status | VarChar | 1 | 0 | A | A=Active, I=Inactive |
| 50 | OGPA | Gross Profit Adjustment | 5 | Status | Status | VarChar | 1 | 0 | | E=Executed, P=Saved Parameters, R=Saved Recommendations, S=Simulation |
| 51 | OHMM | SAP HANA Model Management | 6 | Status | Status | VarChar | 1 | 0 | | D=Deployed, I=Imported, T=In Task |
| 52 | SEVT | SEVT | 4 | Status | Event status | nVarChar | 50 | 0 | | |
| 53 | SEWH1 | SEWH1 | 6 | Status | AddOn Status | nVarChar | 50 | 0 | | |
| 54 | SOUT | SOUT | 10 | Status | Status | VarChar | 1 | 0 | C | C=Check in, E=Error, I=Success with info, P=In process, S=Success |
| 55 | SWPD | SWPD | 10 | Status | Status during import | VarChar | 1 | 0 | M | A=Active, D=Deleted, E=Activate failed, F=Import failed, I=Inactive, M=Importing, P=Imported |
| 56 | WOBJ | Object Wizard | 8 | Status | Execution Status | VarChar | 1 | 0 | D | D=Done, P=Postponed, R=Ready |
| TOPHuman Resources |
| 57 | AHEM | Employees | 28 | status | Status | Int | 11 | 0 | | |
| 58 | HET1 | Employee Transfer Details | 4 | Status | Processing Status | VarChar | 1 | 0 | N | A=Accepted, E=Error, N=New, S=Sent |
| 59 | OHEM | Employees | 28 | status | Status | Int | 11 | 0 | | |
| 60 | OHET | Object: HR Employee Transfer | 4 | Status | Processing Status | VarChar | 1 | 0 | N | A=Accepted, E=Error, N=New, P=Processing, R=Received, S=Sent |
| TOPInventory and Production |
| 61 | ABTN | Batch Numbers Master Data | 13 | Status | Status | VarChar | 1 | 0 | 0 | 0=Released, 1=Not Accessible, 2=Locked |
| 62 | AINC | Inventory Counting | 11 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 63 | AIQI | Inventory Opening Balance | 22 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 64 | AIQR | Inventory Posting | 21 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 65 | APKL | Pick List - History | 9 | Status | Status | VarChar | 1 | 0 | R | C=Closed, D=Partially Delivered, P=Partially Picked, R=Released, Y=Picked |
| 66 | ASRN | Serial Numbers Master Data | 13 | Status | Status | VarChar | 1 | 0 | | 0=Available, 1=Unavailable |
| 67 | AWOR | Production Order - History | 5 | Status | Production Order Status | VarChar | 1 | 0 | P | C=Canceled, L=Closed, P=Planned, R=Released |
| 68 | IGE13 | Goods Issue Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 69 | IGE2 | Goods Issue - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 70 | IGE3 | Goods Issue - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 71 | IGE5 | Goods Issue - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 72 | IGE6 | Goods Issue - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 73 | IGN13 | Goods Receipt Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 74 | IGN2 | Goods Receipt - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 75 | IGN3 | Goods Receipt - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 76 | IGN5 | Goods Receipt - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 77 | IGN6 | Goods Receipt- Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 78 | OBTN | Batch Numbers Master Data | 13 | Status | Status | VarChar | 1 | 0 | 0 | 0=Released, 1=Not Accessible, 2=Locked |
| 79 | ODBN | Bat. Nos - Draft - Master Data | 13 | Status | Status | VarChar | 1 | 0 | 0 | 0=Released, 1=Not Accessible, 2=Locked |
| 80 | ODSN | SNs - Draft - Master Data | 13 | Status | Status | VarChar | 1 | 0 | | 0=Available, 1=Unavailable |
| 81 | OICD | Inventory Counting Draft | 11 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 82 | OINC | Inventory Counting | 11 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 83 | OIOD | Inventory Opening Balance Draft | 22 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 84 | OIPD | Inventory Posting Draft | 21 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 85 | OIQI | Inventory Opening Balance | 22 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 86 | OIQR | Inventory Posting | 21 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 87 | OISL | Simulation Log File | 10 | Status | Status | VarChar | 1 | 0 | | F=Failed, R=In Progress, S=Successful |
| 88 | OPKL | Pick List | 9 | Status | Status | VarChar | 1 | 0 | R | C=Closed, D=Partially Delivered, P=Partially Picked, R=Released, Y=Picked |
| 89 | OSRN | Serial Numbers Master Data | 13 | Status | Status | VarChar | 1 | 0 | | 0=Available, 1=Unavailable, 2=Allocated |
| 90 | OWKO | Production Instructions | 2 | Status | Processing Status | VarChar | 1 | 0 | O | E=Production Completed, I=Work Instructions, O=Work Instructions |
| 91 | OWOR | Production Order | 5 | Status | Production Order Status | VarChar | 1 | 0 | P | C=Canceled, L=Closed, P=Planned, R=Released |
| 92 | UBTN | Batch Numbers Master Data | 13 | Status | Status | VarChar | 1 | 0 | 0 | 0=Released, 1=Not Accessible, 2=Locked |
| 93 | USRN | Serial Numbers Master Data | 13 | Status | Status | VarChar | 1 | 0 | | 0=Available, 1=Unavailable, 2=Allocated |
| 94 | UWKO | Production Instructions | 2 | Status | Processing Status | VarChar | 1 | 0 | O | E=Production Completed, I=Work Instructions, O=Work Instructions |
| 95 | UWOR | Production Order | 5 | Status | Production Order Status | VarChar | 1 | 0 | P | C=Canceled, L=Closed, P=Planned, R=Released |
| 96 | WTQ13 | Inventory Transfer Request Rows - Distributed Freights | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 97 | WTQ2 | Inventory Transfer Request - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 98 | WTQ3 | Inventory Transfer Request - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 99 | WTQ5 | Inventory Transfer Request - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 100 | WTQ6 | Inventory Transfer Request - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 101 | WTR13 | Inventory Transfer Rows - Distributed Freights | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 102 | WTR2 | Inventory Transfer - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 103 | WTR3 | Inventory Transfer - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 104 | WTR5 | Inventory Transfer - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 105 | WTR6 | Inventory Transfer - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| TOPMarketing Documents |
| 106 | ADO13 | A/R Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 107 | ADO2 | A/R Invoice - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 108 | ADO3 | A/R Invoice - Freight - History | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 109 | ADO5 | Withholding Tax - History | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 110 | ADO6 | Documents History - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 111 | CIN13 | Correction Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 112 | CIN2 | A/R Correction Invoice - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 113 | CIN3 | A/R Correction Invoice - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 114 | CIN5 | AR Correction Invoice - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 115 | CIN6 | Correction Invoice - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 116 | CPI13 | A/P Correction Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 117 | CPI2 | A/P Correction Invoice - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 118 | CPI3 | A/P Correction Invoice - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 119 | CPI5 | Withholding Tax Data | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 120 | CPI6 | Documents History - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 121 | CPV13 | A/P Correction Invoice Reversal Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 122 | CPV2 | A/P Correction Invoice Reversal - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 123 | CPV3 | A/P Correction Invoice Reversal - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 124 | CPV5 | A/P Correction Invoice Reversal - WTax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 125 | CPV6 | A/P Correction Invoice Reversal - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 126 | CSI13 | A/R Correction Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 127 | CSI2 | A/R Corr Inv - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 128 | CSI3 | A/R Correction Invoice - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 129 | CSI5 | A/R Correction Invoice - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 130 | CSI6 | A/R Corr. Inv. - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 131 | CSV13 | A/R Correction Invoice Reversal Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 132 | CSV2 | A/R Correction Invoice Reversal - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 133 | CSV3 | A/R Correction Invoice Reversal - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 134 | CSV5 | A/R Correction Invoice Reversal - WTax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 135 | CSV6 | A/R Correction Invoice Reversal - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 136 | DLN13 | Delivery Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 137 | DLN2 | Delivery Notes - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 138 | DLN3 | Delivery Notes - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 139 | DLN5 | Delivery - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 140 | DLN6 | Delivery - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 141 | DPI13 | A/R Down Payment Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 142 | DPI2 | A/R Down Payment - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 143 | DPI3 | A/R Down Payment - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 144 | DPI5 | A/R Down Payment - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 145 | DPI6 | A/R Down Payment - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 146 | DPO13 | A/P Down Payment Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 147 | DPO2 | A/P Down Payment - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 148 | DPO3 | A/P Down Payment - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 149 | DPO5 | A/P Down Payment - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 150 | DPO6 | Down Payment Out - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 151 | DRF13 | Draft Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 152 | DRF2 | Draft - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 153 | DRF3 | Draft - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 154 | DRF5 | Draft Documents - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 155 | DRF6 | Document Drafts - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 156 | IEI13 | Incoming Excise Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 157 | IEI2 | Incoming Excise Invoice - Freight - History - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 158 | IEI3 | IEI - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 159 | IEI5 | Incoming Excise Invoice - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 160 | IEI6 | IEI - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 161 | INV13 | A/R Invoice Rows - Distributed Freights | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 162 | INV2 | A/R Invoice - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 163 | INV3 | A/R Invoice - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 164 | INV5 | A/R Invoice - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 165 | INV6 | A/R Invoice - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 166 | ODWZ | Dunning Wizard | 5 | Status | Wizard Status | VarChar | 1 | 0 | S | E=Executed and Printed or Sent by E-Mail, O=Executed, Not Yet Printed or Sent by E-Mail, P=Partially Executed and Printed, R=Saved Recommendations, S=Saved Parameters, T=Partially Executed, Not Yet Printed or Sent by E-Mail |
| 167 | OEI13 | Outgoing Excise Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 168 | OEI2 | OEI - Freight Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 169 | OEI3 | OEI - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 170 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 171 | OEI6 | Outgoing Excise Invoice - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 172 | ORCL | Recurring Transaction Instances | 5 | Status | Recurrence Status | VarChar | 1 | 0 | N | E=Executed, N=Not Executed, R=Removed |
| 173 | OWDD | Docs. for Confirmation | 8 | Status | Status | VarChar | 1 | 0 | W | A=Generated by Authorizer, C=Canceled, N=Rejected, P=Generated, W=Pending, Y=Approved |
| 174 | PCH13 | A/P Invoice Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 175 | PCH2 | A/P Invoice - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 176 | PCH3 | A/P Invoice - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 177 | PCH5 | A/P Invoice - Withholding Tax Data | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 178 | PCH6 | A/P Invoice - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 179 | PDN13 | Goods Receipt PO Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 180 | PDN2 | Goods Receipt PO - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 181 | PDN3 | Goods Receipt PO - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 182 | PDN5 | Goods Reciept PO - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 183 | PDN6 | Goods Receipt PO - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 184 | POR13 | Purchase Order Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 185 | POR2 | Purchase Order - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 186 | POR3 | Purchase Order - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 187 | POR5 | Purchase Order - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 188 | POR6 | Purchase Order - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 189 | PQT13 | Purchase Quotation Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 190 | PQT2 | Purchase Quotation - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 191 | PQT3 | Purchase Quotation - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 192 | PQT5 | Purchase Quotation - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 193 | PQT6 | Purchase Quotation - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 194 | PRQ13 | Purchase Request Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 195 | PRQ2 | Purchase Request - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 196 | PRQ3 | Purchase Request - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 197 | PRQ5 | Purchase Request - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 198 | PRQ6 | Purchase Request - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 199 | QUT13 | Sales Quotation Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 200 | QUT2 | Sales Quotation - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 201 | QUT3 | Sales Quotation - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 202 | QUT5 | Sales Quotation - Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 203 | QUT6 | Sales Quotation - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 204 | RDN13 | Returns Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 205 | RDN2 | Return - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 206 | RDN3 | Return - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 207 | RDN5 | Returns - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 208 | RDN6 | Returns - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 209 | RDR13 | Sales Order Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 210 | RDR2 | Sales Order - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 211 | RDR3 | Sales Order - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 212 | RDR5 | Sales Order - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 213 | RDR6 | Sales Order - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 214 | RIN13 | A/R Credit Memo Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 215 | RIN2 | A/R Credit Memo - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 216 | RIN3 | A/R Credit Memo - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 217 | RIN5 | A/R Credit Memo - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 218 | RIN6 | A/R Credit Memo - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 219 | RPC13 | A/P Credit Memo Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 220 | RPC2 | A/P Credit Memo Rows - Expenses | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 221 | RPC3 | A/P Credit Memo - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 222 | RPC5 | A/P Credit Memo - Withholding Tax | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 223 | RPC6 | A/P Credit Memo - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 224 | RPD13 | Goods Returns Rows - Distributed Expenses | 47 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 225 | RPD2 | Goods Return - Freight - Rows | 41 | Status | Status | VarChar | 1 | 0 | O | C=Close, O=Open |
| 226 | RPD3 | Goods Return - Freight | 45 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 227 | RPD5 | Goods Return - Withholding Tax Data | 24 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 228 | RPD6 | Goods Return - Installments | 6 | Status | Installment Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 229 | WDD1 | Documents for Approval - Authorizers | 4 | Status | Status | VarChar | 1 | 0 | W | N=Not Approved, W=Pending, Y=Approved |
| TOPMRP |
| 230 | ORCM | Recommendation Data | 14 | Status | Order Status | VarChar | 1 | 0 | O | A=Accepted, D=Deleted, O=Opened, P=Processed |
| TOPReports |
| 231 | OEBL | E-Balance | 3 | Status | Status | VarChar | 1 | 0 | | G=Generated, S=Saved |
| 232 | OECDW | ECD Wizard | 5 | Status | Status | VarChar | 1 | 0 | | E=Executed, S=Saved |
| 233 | OEFDW | EFD Wizard | 5 | Status | Status | VarChar | 1 | 0 | | E=Executed, S=Saved |
| 234 | OEJB | Wizard Run Details for ERV-JAb | 8 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 235 | OLLR | Electronic Report Generation Result | 6 | Status | Status | VarChar | 1 | 0 | C | C=Canceled, E=Executed, F=Failed |
| 236 | OTRB | Tax Report Wizard for Brazil | 11 | Status | Wizard Run Status | VarChar | 1 | 0 | | C=Canceled, E=Executed, S=Saved |
| 237 | RDOC | Document | 56 | Status | Status | VarChar | 1 | 0 | A | A=Active, I=Inactive |
| 238 | SRA2 | Scheduled Report Run Output | 4 | Status | Status | VarChar | 1 | 0 | 0 | 0=Schedule Inactive, 1=Report Scheduled, E=In progress, F=Failure, S=Successful, T=Results to Be Distributed |
| TOPSales Opportunities |
| 239 | AOPR | Opportunity | 21 | Status | Status | VarChar | 1 | 0 | O | L=Lost, O=Open, W=Won |
| 240 | OOPR | Opportunity | 21 | Status | Status | VarChar | 1 | 0 | O | L=Lost, O=Open, W=Won |
| 241 | OPR1 | Opportunity - Rows | 14 | Status | Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| TOPService |
| 242 | AINS | Customer Equipment Card - History | 43 | status | Status | VarChar | 1 | 0 | A | A=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated |
| 243 | ASCL | History | 18 | status | Status | Int | 6 | 0 | -3 | |
| 244 | OCTR | Service Contracts | 6 | Status | Contract Status | VarChar | 1 | 0 | D | A=Approved, D=Draft, F=On Hold, T=Terminated |
| 245 | OINS | Customer Equipment Card | 43 | status | Status | VarChar | 1 | 0 | A | A=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated |
| 246 | OISR | Service Calls | 10 | Status | Call Status | VarChar | 1 | 0 | O | C=Closed, O=Open |
| 247 | OREQ | External System Call Request | 3 | Status | Request Status | VarChar | 1 | 0 | N | C=Comfirmed, F=Failed, N=New, P=In Process, S=Completed |
| 248 | OSCL | Service Calls | 18 | status | Status | Int | 6 | 0 | -3 | |
| 249 | REQ1 | External System Call Request - Message List | 6 | Status | Message Status | VarChar | 1 | 0 | U | R=Read, U=Unread |
