| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | TRN1 | Subtable of OTRN | 4 | ItemType | Item Type | nVarChar | 8 | 0 | | |
| TOPBusiness Partners |
| 2 | ACP2 | Campaign - Items | 5 | ItemType | Item Type | VarChar | 1 | 0 | | I=Items, L=Labor, T=Travel |
| 3 | CPN2 | Campaign - Items | 5 | ItemType | Item Type | VarChar | 1 | 0 | | I=Items, L=Labor, T=Travel |
| TOPFinance |
| 4 | ISW2 | Intrastat Reported Items | 12 | ItemType | Item Type | VarChar | 1 | 0 | I | I=Item, N=Item not relevant to Intrastat, S=Service |
| 5 | ISW3 | Declaration Rows | 42 | ItemType | Item Type | VarChar | 1 | 0 | I | I=Item, N=Item Not Relevant to Intrastat, S=Service |
| TOPGeneral |
| 6 | COLM | COLM resource | 5 | ItemType | Item Type | Int | 11 | 0 | 0 | 0=None, 105=Bar, 113=Select popup, 116=Link button, 117=Picture, 121=Check box, 16=Edit text |
| 7 | ITEM | Item Resource | 5 | ItemType | Item Type | Int | 11 | 0 | | 0=User item, 100=Rectangle, 101=FwdBck button, 102=ActiveX, 103=Multi page, 104=Pane popup, 112=Progress, 113=Select popup, 114=Edit popup, 115=Pane button, 116=Link button, 117=Picture, 118=Extended edit, 119=Preview, 120=Media, 121=Check box, 122=Radio button, 123=Graph, 124=Icon, 125=Popup, 127=Grid, 129=Button Combo, 16=Edit text, 4=Bu |
| 8 | RFTL | FITL resource | 6 | ItemType | Item type | Int | 11 | 0 | | 0=User item, 100=Rectangle, 101=FwdBck button, 102=User group, 103=Multi page, 104=Pane popup, 112=Progress, 113=Select popup, 114=Edit popup, 115=Pane button, 116=Link button, 117=Picture, 118=Extended edit, 119=Preview, 120=Media, 121=Check box, 122=Radio button, 123=Graph, 124=Icon, 125=Popup, 127=Matrix, 16=Edit text, 4=Button, 8=Stati |
| 9 | RMTL | MITL resource | 6 | ItemType | Item type | Int | 11 | 0 | 0 | 0=None, 105=Bar, 113=Select popup, 116=Link button, 117=Picture, 121=Check box, 16=Edit text |
| TOPInventory and Production |
| 10 | AITM | Items - History | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
| 11 | AWO1 | Production Order (Rows) - History | 23 | ItemType | Item Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
| 12 | IGE1 | Goods Issue - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
| 13 | IGN1 | Goods Receipt - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
| 14 | ILM3 | Non-Inventory and Resource Components Log Msg | 4 | ItemType | Item Type | Int | 11 | 0 | | |
| 15 | OITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
| 16 | SITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
| 17 | UILM3 | Non-Inventory and Resource Components Log Msg | 4 | ItemType | Item Type | Int | 11 | 0 | | |
| 18 | UITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
| 19 | UWOR1 | Production Order - Rows | 23 | ItemType | Item Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
| 20 | WOR1 | Production Order - Rows | 23 | ItemType | Item Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
| 21 | WTQ1 | Inventory Transfer Request - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 22 | WTR1 | Inventory Transfer - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| TOPMarketing Documents |
| 23 | ADO1 | A/R Invoice (Rows) - History | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
| 24 | CIN1 | Correction Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 25 | CPI1 | A/P Correction Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 26 | CPV1 | A/P Correction Invoice Reversal - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 27 | CSI1 | A/R Correction Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 28 | CSV1 | A/R Correction Invoice Reversal - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 29 | DLN1 | Delivery - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 30 | DPI1 | A/R Down Payment - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 31 | DPO1 | A/P Down Payment - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 32 | DRF1 | Draft - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
| 33 | IEI1 | Incoming Excise Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 34 | INV1 | A/R Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 35 | MIN2 | Item Imformation of MI | 12 | ItemType | Item Type | VarChar | 1 | 0 | I | |
| 36 | MIV2 | A/P Monthly Invoice - Item | 12 | ItemType | Item Type | VarChar | 1 | 0 | I | D=Down Payment Paid, E=Expense, I=Item, R=Rounding, S=Service, T=Tax Amount, W=WTax Amount |
| 37 | OEI1 | Outgoing Excise Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 38 | PCH1 | A/P Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 39 | PDN1 | Goods Receipt PO - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 40 | POR1 | Purchase Order - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 41 | PQT1 | Purchase Quotation - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 42 | PRQ1 | Purchase Request - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 43 | QUT1 | Sales Quotation - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 44 | RDN1 | Returns - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 45 | RDR1 | Sales Order - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 46 | RIN1 | A/R Credit Memo - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 47 | RPC1 | A/P Credit Memo - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
| 48 | RPD1 | Goods Return - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
