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