| 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 |
10 | UITE | UITE | 5 | itemType | Item Type | VarChar | 1 | 0 | | |
TOPInventory and Production |
11 | AITM | Items - History | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
12 | AWO1 | Production Order (Rows) - History | 22 | ItemType | Item Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
13 | IGE1 | Goods Issue - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
14 | IGN1 | Goods Receipt - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
15 | ILM3 | Non-Inventory and Resource Components Log Msg | 4 | ItemType | Item Type | Int | 11 | 0 | | |
16 | IVL2 | Inventory Components for Production | 5 | ItemType | Item Type | Int | 11 | 0 | | |
17 | OITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
18 | SITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
19 | SIVL2 | Inventory Components for Production | 5 | ItemType | Item Type | Int | 11 | 0 | | |
20 | UILM3 | Non-Inventory and Resource Components Log Msg | 4 | ItemType | Item Type | Int | 11 | 0 | | |
21 | UITM | Items | 213 | ItemType | Item Type | VarChar | 1 | 0 | I | F=Fixed Assets, I=Items, L=Labor, T=Travel |
22 | UIVL2 | Inventory Components for Production | 5 | ItemType | Item Type | Int | 11 | 0 | | |
23 | UWOR1 | Production Order - Rows | 22 | ItemType | Item Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
24 | WOR1 | Production Order - Rows | 22 | ItemType | Item Type | Int | 11 | 0 | 4 | -18=Text, 290=Resource, 4=Item |
25 | WTQ1 | Inventory Transfer Request - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
26 | WTR1 | Inventory Transfer - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
TOPMarketing Documents |
27 | ADO1 | A/R Invoice (Rows) - History | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
28 | CIN1 | Correction Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
29 | CPI1 | A/P Correction Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
30 | CPV1 | A/P Correction Invoice Reversal - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
31 | CSI1 | A/R Correction Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
32 | CSV1 | A/R Correction Invoice Reversal - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
33 | DLN1 | Delivery - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
34 | DPI1 | A/R Down Payment - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
35 | DPO1 | A/P Down Payment - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
36 | DRF1 | Draft - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 290=Resource, 4=Item |
37 | IEI1 | Incoming Excise Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
38 | INV1 | A/R Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
39 | MIN2 | Item Imformation of MI | 12 | ItemType | Item Type | VarChar | 1 | 0 | I | |
40 | 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 |
41 | OEI1 | Outgoing Excise Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
42 | PCH1 | A/P Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
43 | PDN1 | Goods Receipt PO - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
44 | POR1 | Purchase Order - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
45 | PQT1 | Purchase Quotation - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
46 | PRQ1 | Purchase Request - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
47 | PRR1 | A/P Return Request - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
48 | QUT1 | Sales Quotation - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
49 | RDN1 | Returns - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
50 | RDR1 | Sales Order - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
51 | RIN1 | A/R Credit Memo - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
52 | RPC1 | A/P Credit Memo - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
53 | RPD1 | Goods Return - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
54 | RRR1 | A/R Return Request - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
55 | SFC1 | Self Credit Memo - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |
56 | SFI1 | Self Invoice - Rows | 253 | ItemType | Item Type | Int | 11 | 0 | 4 | 4=Item |