| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeneral |
1 | MOBJ | MOBJ | 7 | objId | Internal Object Id | Int | 11 | 0 | | |
2 | SDRR | Drag&Relate - Reports | 1 | ObjId | Object ID | nVarChar | 4 | 0 | | |
3 | SXROA | XLR Object Access | 3 | ObjId | ObjId | nVarChar | 254 | 0 | | |
4 | SXROB | XLR Objects | 1 | objid | objid | Int | 11 | 0 | | |
5 | SXRPR | XLR Properties | 2 | objid | objid | Int | 11 | 0 | | |
6 | UFRM | UFRM | 4 | objId | Object Id | nVarChar | 36 | 0 | | |
TOPInventory and Production |
7 | AIN11 | Inventory Counting - Individual Counters - Row SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
8 | AIN3 | Inventory Count - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
9 | AIN7 | Inventory Counting - Team Counter - Row SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
10 | AQI2 | Inventory Opening Balance - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
11 | AQR3 | Inventory Count - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
12 | ICD11 | Inventory Counting Draft - Individual Counter - Row SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
13 | ICD3 | Inventory Count Draft - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
14 | ICD7 | Inventory Counting Draft - Team Counter - Row SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
15 | IGE16 | Goods Issue - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
16 | IGN16 | Goods Receipt - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
17 | INC11 | Inventory Counting - Individual Counter - Row SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
18 | INC3 | Inventory Count - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
19 | INC7 | Inventory Counting - Team Counter - Row SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
20 | IOD2 | Inventory Opening Balance Draft - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
21 | IPD3 | Inventory Posting Draft - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
22 | IQI2 | Inventory Opening Balance - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
23 | IQR3 | Inventory Posting - SnB | 6 | ObjId | Object ID | Int | 11 | 0 | | |
24 | WTQ16 | Inventory Transfer Request - SnB Properties | 6 | ObjId | Object ID | Int | 11 | 0 | | |
25 | WTR16 | Inventory Transfer - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
TOPMarketing Documents |
26 | ADO16 | Draft - SnB properties | 6 | ObjId | Object ID | Int | 11 | 0 | | |
27 | CPI16 | A/P Corr. Inv - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
28 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
29 | CSI16 | A/R Corr. Inv. - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
30 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
31 | DLN16 | Delivery - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
32 | DPI16 | A/R Down Payment - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
33 | DPO16 | A/P Down Payment - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
34 | DRF16 | Draft - SnB - Rows | 6 | ObjId | Object id | Int | 11 | 0 | | |
35 | IEI16 | Incoming Excise Invoice - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
36 | INV16 | A/R Invoice - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
37 | OEI16 | Outgoing Excise Invoice - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
38 | PCH16 | A/P Invoice - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
39 | PDN16 | Goods Receipt PO - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
40 | POR16 | Purchase Order - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
41 | PQT16 | Purchase Quotation - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
42 | PRQ16 | Purchase Request - SnB Properties | 6 | ObjId | Object ID | Int | 11 | 0 | | |
43 | PRR16 | A/P Return Request - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
44 | QUT16 | Sales Quotation - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
45 | RDN16 | Returns - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
46 | RDR16 | Sales Order - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
47 | RIN16 | A/R Credit Memo - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
48 | RPC16 | A/P Credit Memo - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
49 | RPD16 | Goods Return - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
50 | RRR16 | A/R Return Request - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
51 | SFC16 | Self Credit Memo - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
52 | SFI16 | Self Invoice - SnB properties | 6 | ObjId | Object id | Int | 11 | 0 | | |
TOPReports |
53 | SEL1 | Selection Lists - Lists | 2 | ObjID | Object ID | nVarChar | 20 | 0 | | |