| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ADP1 | Object Settings - History | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
2 | ALR1 | Queue of messages to be sent | 9 | ObjType | Object | nVarChar | 20 | 0 | | |
3 | ALR3 | Dynamic message data cells | 5 | ObjType | The linked object | nVarChar | 20 | 0 | | |
4 | AOB1 | Sent Messages - User History | 2 | ObjType | Object | nVarChar | 20 | 0 | 12 | -1=Random, 11=Contact Person, 12=User |
5 | AUSR | Archive Users - History | 66 | objType | Object Type | nVarChar | 20 | 0 | 12 | |
6 | CUMI | My Menu Items | 7 | ObjType | Object Type | nVarChar | 20 | 0 | | |
7 | MLS1 | Distribution Lists - Recipients | 3 | ObjType | Object | nVarChar | 20 | 0 | | |
8 | OUSR | Users | 66 | objType | Object Type - History | nVarChar | 20 | 0 | 12 | |
9 | UDG1 | User Defaults - Documents | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
TOPBanking |
10 | ACH1 | Checks for Payment - Rows - History | 14 | ObjType | Object Type | nVarChar | 20 | 0 | | |
11 | ACHO | Checks for Payment - History | 43 | ObjType | Object Type | nVarChar | 20 | 0 | 57 | |
12 | ARC1 | Incoming Payment - Checks - History | 13 | ObjType | ObjType | nVarChar | 20 | 0 | | |
13 | ARC2 | Incoming Payment - Invoices - History | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
14 | ARC3 | Credit Vouchers History | 25 | ObjType | Object Type | nVarChar | 20 | 0 | | |
15 | ARC4 | Incoming Payment - Account List - History | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
16 | ARC5 | Reciept log | 4 | ObjType | Object Type - History | nVarChar | 20 | 0 | | |
17 | ARC6 | Incoming Payments - WTax Rows - History | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
18 | ARCT | Incoming Payment - History | 56 | ObjType | Object Type | nVarChar | 20 | 0 | | |
19 | CHD1 | Checks for Payment Drafts - Rows | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 123 | |
20 | CHO1 | Checks for Payment - Rows | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 57 | |
21 | OCHD | Checks for Payment Drafts | 43 | ObjType | Object Type | nVarChar | 20 | 0 | 123 | |
22 | OCHO | Checks for Payment | 43 | ObjType | Object Type | nVarChar | 20 | 0 | 57 | |
23 | ODPS | Deposit | 37 | ObjType | Object Type | nVarChar | 20 | 0 | | |
24 | ODPT | Postdated Deposit | 22 | ObjType | Object Type | nVarChar | 20 | 0 | | |
25 | OPDF | Payment Draft | 56 | ObjType | Object Type | nVarChar | 20 | 0 | | 24=Incoming Payment, 46=Outgoing Payments |
26 | ORCT | Incoming Payment | 56 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | 24=Incoming Payment |
27 | OVPM | Outgoing Payments | 56 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | 46=Outgoing Payments |
28 | PDF1 | Payment Draft - Checks | 13 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
29 | PDF2 | Payment Draft - Invoices | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
30 | PDF3 | Payment Draft - Credit Vouchers | 25 | ObjType | Object Type | nVarChar | 20 | 0 | | |
31 | PDF4 | Payment Draft - Account List | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
32 | PDF5 | PaymentDraft - | 4 | ObjType | Object Type | nVarChar | 20 | 0 | | |
33 | PDF6 | Payment Drafts - Withholding Tax - Rows | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
34 | PEX1 | Payment Results Table - Rows | 11 | ObjType | Document Object Type | nVarChar | 20 | 0 | | |
35 | PMN5 | Payment - VAT Adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
36 | PWZ3 | Payment Wizard - Rows 3 | 33 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
37 | PWZ4 | Payment Wizard - Rows 4 | 9 | ObjType | Object Type | nVarChar | 20 | 0 | | 24=Incoming Payment, 46=Outgoing Payment |
38 | RCC4 | Incoming Payment - Credit Vouchers | 11 | ObjType | Number of Payments | nVarChar | 20 | 0 | 1 | |
39 | RCT1 | Incoming Payment - Checks | 13 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
40 | RCT2 | Incoming Payments - Invoices | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
41 | RCT3 | Incoming Pmt - Credit Vouchers | 25 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
42 | RCT4 | Incoming Payment - Account List | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
43 | RCT5 | Reciept vat adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
44 | RCT6 | Incoming Payments - WTax Rows | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
45 | VPM1 | Outgoing Payments - Check Rows | 13 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
46 | VPM2 | Outgoing Payments - Invoices | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
47 | VPM3 | Outgoing Payments - Credit Vouchers | 25 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
48 | VPM4 | Outgoing Payments - Accounts | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
49 | VPM5 | Outgoing Payments - Vat Adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
50 | VPM6 | Outgoing Payments - WTax | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
TOPBusiness Partners |
51 | ACPR | Contact Persons - History | 18 | ObjType | Object Type | nVarChar | 20 | 0 | | |
52 | ACR1 | Business Partner Addresses - History | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
53 | ACR2 | Bussiness Partners - Payment Methods-History | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
54 | ACR3 | Business Partner Control Accounts - History | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
55 | ACRD | Business Partners - History | 170 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
56 | CRD1 | Business Partners - Addresses | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
57 | CRD2 | Bussiness Partners - Payment Methods | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
58 | CRD3 | BP Control Account | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
59 | OCPR | Contact Persons | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 11 | |
60 | OCRD | Business Partner | 170 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
TOPFinance |
61 | AACT | G/L Account - History | 52 | ObjType | Object Type | nVarChar | 20 | 0 | | |
62 | AJD1 | Journal Entry - History - Rows | 47 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
63 | AJDT | Journal Entry - History | 31 | ObjType | Object Type | nVarChar | 20 | 0 | | |
64 | BTF1 | Journal Voucher | 47 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
65 | JDT1 | Journal Entry - Rows | 47 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
66 | OACT | G/L Accounts | 52 | ObjType | Object Type | nVarChar | 20 | 0 | 1 | |
67 | OBTF | Journal Voucher Entry | 31 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
68 | OJDT | Journal Entry | 31 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
TOPInventory and Production |
69 | AIT1 | Item - Prices - History | 8 | ObjType | Object | nVarChar | 20 | 0 | | |
70 | AITM | Items - History | 199 | ObjType | Object Type | nVarChar | 20 | 0 | | |
71 | AMR1 | Inventory Revaluation - History - Rows | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
72 | AMR2 | Inventory Revaluation FIFO Rows (Archive) | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
73 | AMRV | Inventory Revaluation - History | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
74 | APKL | Pick List - History | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 156 | |
75 | AWHS | Warehouses - History | 54 | objType | Object Type - History | nVarChar | 20 | 0 | 64 | |
76 | IGE1 | Goods Issue - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
77 | IGE10 | Goods Issue - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
78 | IGE11 | Goods Issue - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
79 | IGE2 | Goods Issue - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
80 | IGE3 | Goods Issue - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
81 | IGE5 | Goods Issue - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
82 | IGE6 | Goods Issue - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
83 | IGE7 | Delivery Packages - Goods Issue | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
84 | IGE8 | Items in Package - Goods Issue | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
85 | IGE9 | Goods Issue - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
86 | IGN1 | Goods Receipt - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
87 | IGN10 | Goods Receipt - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
88 | IGN11 | Goods Receipt - Drawn Dpm Det | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
89 | IGN2 | Goods Receipt - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
90 | IGN3 | Goods Receipt - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
91 | IGN5 | Goods Receipt - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
92 | IGN6 | Goods Receipt- Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
93 | IGN7 | Goods Receipt - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
94 | IGN8 | Goods Receipt - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
95 | IGN9 | Goods Receipt - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
96 | IQI1 | Inventory Initial Qty Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
97 | IQR1 | Inventory Stock Posting (Reconcile) Lines | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
98 | ITM1 | Items - Prices | 8 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
99 | MRV1 | Inventory Revaluation Information Array | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
100 | MRV2 | Inventory Revaluation FIFO Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
101 | OBTN | Batch Numbers Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
102 | OBTW | Batch Attributes in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
103 | ODBN | Bat. Nos - Draft - Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
104 | ODBW | Batch Draft Attribs in Locat. | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
105 | ODSN | SNs - Draft - Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
106 | ODSW | SN Draft Attribs in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
107 | OENT | Shipping Types | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
108 | OIGE | Goods Issue | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | 60=Goods Issue |
109 | OIGN | Goods Receipt | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | 59=Goods Receipt |
110 | OIPF | Landed Costs | 48 | ObjType | Object Type | nVarChar | 20 | 0 | 69 | |
111 | OIQI | Inventory Initial Quantity | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
112 | OIQR | Inventory Stock Posting (Reconcile) | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
113 | OITM | Items | 199 | ObjType | Object Type | nVarChar | 20 | 0 | 4 | |
114 | OMRV | Inventory Revaluation | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
115 | OPKL | Pick List | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 156 | |
116 | OSPG | Special Prices for Groups | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | 43=Companies, 52=Item Group, 8=Item Properties |
117 | OSRN | Serial Numbers Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
118 | OSRW | Serial No. Attribs in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
119 | OWHS | Warehouses | 54 | objType | Object Type - History | nVarChar | 20 | 0 | 64 | |
120 | OWKO | Production Instructions | 27 | ObjType | Object Type | nVarChar | 20 | 0 | 68 | |
121 | OWTR | Inventory Transfer | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | 67=Inventory Transfer |
122 | UITM | Items | 199 | ObjType | Object Type | nVarChar | 20 | 0 | 4 | |
123 | UWKO | Production Instructions | 27 | ObjType | Object Type | nVarChar | 20 | 0 | 68 | |
124 | WTR1 | Inventory Transfer - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
125 | WTR10 | Inventory Transfer - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
126 | WTR11 | Inv. Transfer - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
127 | WTR2 | Inventory Transfer - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
128 | WTR3 | Inventory Transfer - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
129 | WTR5 | Inventory Transfer - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
130 | WTR6 | Inventory Transfer - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
131 | WTR7 | Inventory Transfer - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
132 | WTR8 | Inventory Transfer - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
133 | WTR9 | Inventory Transfer - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
TOPMarketing Documents |
134 | ADO1 | A/R Invoice (Rows) - History | 79 | ObjType | Object Type | nVarChar | 20 | 0 | | |
135 | ADO10 | A/R Invoice - Row Structure - History | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
136 | ADO11 | A/R Inv (Drawn Dpm Det) - Hist | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
137 | ADO13 | A/R Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
138 | ADO15 | A/R Inv (Drawn Dpm Applied) - Hist | 3 | ObjType | object type | nVarChar | 20 | 0 | 13 | |
139 | ADO16 | Draft - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
140 | ADO2 | A/R Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
141 | ADO3 | A/R Invoice - Freight - History | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | |
142 | ADO5 | Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | | |
143 | ADO6 | Documents History - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | | |
144 | ADO7 | Delivery Packages - History | 6 | ObjType | Object Type | nVarChar | 20 | 0 | | |
145 | ADO8 | Items in Package - History | 6 | ObjType | Object Type | nVarChar | 20 | 0 | | |
146 | ADO9 | A/R Invoice (Rows) - History | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
147 | ADOC | Invoice - History | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | |
148 | AJD2 | Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
149 | ATX1 | Tax Invoice - History - Rows | 7 | ObjType | Object Type | Int | 6 | 0 | | |
150 | ATXI | Tax Invoice - History | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
151 | BTF2 | Journal Voucher Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
152 | CIN1 | Correction Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
153 | CIN10 | Correction Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
154 | CIN13 | Correction Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
155 | CIN2 | A/R Correction Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
156 | CIN3 | A/R Correction Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
157 | CIN5 | AR Correction Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
158 | CIN6 | Correction Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
159 | CIN7 | Delivery Packages - Correction Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
160 | CIN8 | Items in Package - Correction Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
161 | CIN9 | Correction Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
162 | CPI1 | A/P Correction Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
163 | CPI10 | A/P Correction Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
164 | CPI11 | A/P Corr. Inv - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
165 | CPI13 | A/P Correction Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
166 | CPI15 | A/P Corr Inv - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 163 | |
167 | CPI16 | A/P Corr. Inv - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
168 | CPI2 | A/P Correction Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
169 | CPI3 | A/P Correction Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
170 | CPI5 | Withholding Tax Data | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
171 | CPI6 | Documents History - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
172 | CPI7 | A/P Correction Invoice - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
173 | CPI8 | A/P Correction Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
174 | CPI9 | A/P Corr. Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
175 | CPV1 | A/P Correction Invoice Reversal - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
176 | CPV10 | A/P CrIn Rev - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
177 | CPV11 | A/P CrIn Rev - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
178 | CPV13 | A/P Correction Invoice Reversal Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
179 | CPV15 | A/P CrIn Rev - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 164 | |
180 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
181 | CPV2 | A/P Correction Invoice Reversal - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
182 | CPV3 | A/P Correction Invoice Reversal - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
183 | CPV5 | A/P Correction Invoice Reversal - WTax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
184 | CPV6 | A/P Correction Invoice Reversal - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
185 | CPV7 | A/P Corr Inv Rvsl - Deliv Pkgs | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
186 | CPV8 | A/P Correction Invoice Reversal - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
187 | CPV9 | A/P Corr Inv Rvrsl - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
188 | CSI1 | A/R Correction Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
189 | CSI10 | A/R Correction Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
190 | CSI11 | A/R Corr. Inv. - Drawn Dpm Det | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
191 | CSI13 | A/R Correction Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
192 | CSI15 | A/R Corr Inv - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 165 | |
193 | CSI16 | A/R Corr. Inv. - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
194 | CSI2 | A/R Corr Inv - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
195 | CSI3 | A/R Correction Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
196 | CSI5 | A/R Correction Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
197 | CSI6 | A/R Corr. Inv. - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
198 | CSI7 | A/R Corr. Inv. Deliv. Pkgs | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
199 | CSI8 | A/R Corr. Inv. - Items in Pkg | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
200 | CSI9 | A/R Corr. Inv. - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | |
201 | CSV1 | A/R Correction Invoice Reversal - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
202 | CSV10 | A/R Correction Invoice Reversal - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
203 | CSV11 | A/R CrIn Rev - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
204 | CSV13 | A/R Correction Invoice Reversal Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
205 | CSV15 | A/R CrIn Rev - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 166 | |
206 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
207 | CSV2 | A/R Correction Invoice Reversal - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
208 | CSV3 | A/R Correction Invoice Reversal - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
209 | CSV5 | A/R Correction Invoice Reversal - WTax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
210 | CSV6 | A/R Correction Invoice Reversal - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
211 | CSV7 | A/R Correction Invoice Reversal - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
212 | CSV8 | A/R Correction Invoice Reversal - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
213 | CSV9 | A/R CrIn Rev - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
214 | DLN1 | Delivery - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
215 | DLN10 | Delivery - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
216 | DLN11 | Delivery - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
217 | DLN13 | Delivery Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
218 | DLN15 | Delivery - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 15 | |
219 | DLN16 | Delivery - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
220 | DLN2 | Delivery Notes - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
221 | DLN3 | Delivery Notes - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
222 | DLN5 | Delivery - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
223 | DLN6 | Delivery - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
224 | DLN7 | Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
225 | DLN8 | Items in Package - Delivery | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
226 | DLN9 | Delivery - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
227 | DPI1 | A/R Down Payment - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
228 | DPI10 | A/R Down Payment - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
229 | DPI11 | A/R DP - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
230 | DPI13 | A/R Down Payment Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 202 | |
231 | DPI15 | A/R DP - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 203 | |
232 | DPI16 | A/R Down Payment - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
233 | DPI2 | A/R Down Payment - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
234 | DPI3 | A/R Down Payment - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 202 | |
235 | DPI5 | A/R Down Payment - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
236 | DPI6 | A/R Down Payment - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
237 | DPI7 | Delivery Packages - A/R Down Pymt | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
238 | DPI8 | Items in Package - A/R Down Pmt. | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
239 | DPI9 | Down Payment Incoming - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
240 | DPO1 | A/P Down Payment - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
241 | DPO10 | A/P Down Payment - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
242 | DPO11 | A/P DP - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
243 | DPO13 | A/P Down Payment Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
244 | DPO15 | A/P DP - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 204 | |
245 | DPO16 | A/P Down Payment - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
246 | DPO2 | A/P Down Payment - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
247 | DPO3 | A/P Down Payment - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
248 | DPO5 | A/P Down Payment - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
249 | DPO6 | Down Payment Out - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
250 | DPO7 | Delivery Packages - A/P Down Pymt | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
251 | DPO8 | Items in Package - A/P Down Pmt. | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
252 | DPO9 | Down Payment Outgoing - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
253 | DRF1 | Draft - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
254 | DRF10 | Draft - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
255 | DRF11 | Draft - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
256 | DRF13 | Draft Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
257 | DRF15 | Draft - Drawn Dpm Applied | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
258 | DRF16 | Draft - SnB - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
259 | DRF2 | Draft - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
260 | DRF3 | Draft - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
261 | DRF5 | Draft Documents - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
262 | DRF6 | Document Drafts - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
263 | DRF7 | Delivery Packages - Drafts | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
264 | DRF8 | Items in Package - Draft | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
265 | DRF9 | Document Draft - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
266 | IEI1 | Incoming Excise Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
267 | IEI10 | Incoming Excise Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
268 | IEI11 | IEI - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
269 | IEI13 | Incoming Excise Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
270 | IEI15 | IEI - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 140000010 | |
271 | IEI16 | Incoming Excise Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
272 | IEI2 | Incoming Excise Invoice - Freight - History - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
273 | IEI3 | IEI - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
274 | IEI5 | Incoming Excise Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
275 | IEI6 | IEI - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
276 | IEI7 | Delivery Packages - Incoming Excise Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
277 | IEI8 | Incoming Excise Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
278 | IEI9 | IEI - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | |
279 | IGE13 | Goods Issue Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
280 | IGE15 | Gds Issue - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 60 | |
281 | IGE16 | Goods Issue - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
282 | IGN13 | Goods Receipt Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
283 | IGN15 | Gds Rcpt - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 59 | |
284 | IGN16 | Goods Receipt - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
285 | INV1 | A/R Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
286 | INV10 | A/R Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
287 | INV11 | A/R Invoice - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
288 | INV13 | A/R Invoice Rows - Distributed Freights | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
289 | INV15 | A/R Inv. - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 13 | |
290 | INV16 | A/R Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
291 | INV2 | A/R Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
292 | INV3 | A/R Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
293 | INV5 | A/R Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
294 | INV6 | A/R Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
295 | INV7 | A/R Invoice - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
296 | INV8 | A/R Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
297 | INV9 | A/R Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | 203=A/R Down Payment |
298 | JDT2 | Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
299 | OCIN | A/R Correction Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | 132=Correction Invoice |
300 | OCPI | A/P Correction Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | 163=A/P Correction Invoice |
301 | OCPV | A/P Correction Invoice Reversal | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | 164=A/P Correction Invoice Reversal |
302 | OCSI | A/R Correction Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | 165=A/R Correction Invoice |
303 | OCSV | A/R Correction Invoice Reversal | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | 166=A/R Correction Invoice Reversal |
304 | ODLN | Delivery | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | 15=Delivery |
305 | ODPI | A/R Down Payment | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | 203=A/R Down Payment |
306 | ODPO | A/P Down Payment | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | 204=A/P Down Payment |
307 | ODRF | Drafts | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 204=A/P Down Payment, 20=Goods Receipt, 21=Goods Ret |
308 | OEI1 | Outgoing Excise Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
309 | OEI10 | Outgoing Excise Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
310 | OEI11 | OEI - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
311 | OEI13 | Outgoing Excise Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
312 | OEI15 | OEI - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 140000009 | |
313 | OEI16 | Outgoing Excise Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
314 | OEI2 | OEI - Freight Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
315 | OEI3 | OEI - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
316 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
317 | OEI6 | Outgoing Excise Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 140000000 | |
318 | OEI7 | Delivery Packages - Outgoing Excise Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
319 | OEI8 | Outgoing Excise Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
320 | OEI9 | OEI - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | |
321 | OIEI | Incoming Excise Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | 140000010=Incoming Excise Invoice |
322 | OINV | A/R Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | 13=A/R Invoice |
323 | OOEI | Outgoing Excise Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | 140000009=Outgoing Excise Invoice |
324 | OPCH | A/P Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | 18=A/P Invoice |
325 | OPDN | Goods Receipt PO | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | 20=Goods Receipt PO |
326 | OPOR | Purchase Order | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | 22=Purchase Order |
327 | OQUT | Sales Quotation | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | 23=Sales Quotation |
328 | ORDN | Returns | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | 16=Returns |
329 | ORDR | Sales Order | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | 17=Sales Order |
330 | ORIN | A/R Credit Memo | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | 14=A/R Credit Memo |
331 | ORPC | A/P Credit Memo | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | 19=A/P Credit Memo |
332 | ORPD | Goods Return | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | 21=Goods Return |
333 | OSAL | Outgoing | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
334 | OTPI | Purchase Tax Invoice | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
335 | OTRA | Transition | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
336 | OTSI | Sales Tax Invoice | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
337 | OTXD | Tax Invoice Draft | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
338 | OWDD | Docs. for Confirmation | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | (-=(-, 112=Documents - Drafts, 132=Correction Invoice, 13=A/R Invoice, 140=Payment Drafts, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment, 20 |
339 | PCH1 | A/P Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
340 | PCH10 | A/P Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
341 | PCH11 | A/P Invoice - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
342 | PCH13 | A/P Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
343 | PCH15 | A/P Invoice - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 18 | |
344 | PCH16 | A/P Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
345 | PCH2 | A/P Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
346 | PCH3 | A/P Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
347 | PCH5 | A/P Invoice - Withholding Tax Data | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
348 | PCH6 | A/P Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
349 | PCH7 | Delivery Packages - A/P Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
350 | PCH8 | A/P Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
351 | PCH9 | A/P Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 204 | 204=A/P Down Payment |
352 | PDN1 | Goods Receipt PO - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
353 | PDN10 | Goods Receipt PO - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
354 | PDN11 | GRPO - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
355 | PDN13 | Goods Receipt PO Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
356 | PDN15 | GRPO - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 20 | |
357 | PDN16 | Goods Receipt PO - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
358 | PDN2 | Goods Receipt PO - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
359 | PDN3 | Goods Receipt PO - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
360 | PDN5 | Goods Reciept PO - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
361 | PDN6 | Goods Receipt PO - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
362 | PDN7 | Goods Receipt PO - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
363 | PDN8 | Goods Receipt PO - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
364 | PDN9 | Goods Receipt PO - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
365 | POR1 | Purchase Order - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
366 | POR10 | Purchase Order - Row structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
367 | POR11 | PO - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
368 | POR13 | Purchase Order Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
369 | POR15 | PO - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 22 | |
370 | POR16 | Purchase Order - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
371 | POR2 | Purchase Order - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
372 | POR3 | Purchase Order - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
373 | POR5 | Purchase Order - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
374 | POR6 | Purchase Order - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
375 | POR7 | Delivery Packages - Purchase Order | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
376 | POR8 | Items in Package - Purchase Order | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
377 | POR9 | Purchase Order - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
378 | QUT1 | Sales Quotation - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
379 | QUT10 | Sales Quotation - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
380 | QUT11 | Sls Quote - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
381 | QUT13 | Sales Quotation Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
382 | QUT15 | Sls Quote - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 23 | |
383 | QUT16 | Sales Quotation - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
384 | QUT2 | Sales Quotation - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
385 | QUT3 | Sales Quotation - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
386 | QUT5 | Sales Quotation - Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
387 | QUT6 | Sales Quotation - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
388 | QUT7 | Delivery Packages - Sales Quotation | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
389 | QUT8 | Sales Quotation - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
390 | QUT9 | Sales Quotation - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
391 | RDN1 | Returns - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
392 | RDN10 | Returns - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
393 | RDN11 | Returns - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
394 | RDN13 | Returns Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
395 | RDN15 | Returns - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 16 | |
396 | RDN16 | Returns - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
397 | RDN2 | Return - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
398 | RDN3 | Return - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
399 | RDN5 | Returns - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
400 | RDN6 | Returns - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
401 | RDN7 | Delivery Packages - Returns | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
402 | RDN8 | Returns - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
403 | RDN9 | Returns - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
404 | RDR1 | Sales Order - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
405 | RDR10 | Sales Order - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
406 | RDR11 | Sls Ord. - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
407 | RDR13 | Sales Order Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
408 | RDR15 | Sls Ord. - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 17 | |
409 | RDR16 | Sales Order - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
410 | RDR2 | Sales Order - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
411 | RDR3 | Sales Order - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
412 | RDR5 | Sales Order - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
413 | RDR6 | Sales Order - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
414 | RDR7 | Delivery Packages - Sales Order | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
415 | RDR8 | Sales Order - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
416 | RDR9 | Order - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
417 | RIN1 | A/R Credit Memo - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
418 | RIN10 | A/R Credit Memo - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
419 | RIN11 | A/R Cr. Memo - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
420 | RIN13 | A/R Credit Memo Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
421 | RIN15 | A/R Cr. Memo - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 14 | |
422 | RIN16 | A/R Credit Memo - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
423 | RIN2 | A/R Credit Memo - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
424 | RIN3 | A/R Credit Memo - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
425 | RIN5 | A/R Credit Memo - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
426 | RIN6 | A/R Credit Memo - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
427 | RIN7 | A/R Credit Memo - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
428 | RIN8 | Items in Package - A/R Credit Memo | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
429 | RIN9 | A/R Credit Memo - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
430 | RPC1 | A/P Credit Memo - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
431 | RPC10 | A/P Credit Memo - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
432 | RPC11 | A/P Cr. Memo - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
433 | RPC13 | A/P Credit Memo Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
434 | RPC15 | A/P Cr. Memo - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 19 | |
435 | RPC16 | A/P Credit Memo - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
436 | RPC2 | A/P Credit Memo Rows - Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
437 | RPC3 | A/P Credit Memo - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
438 | RPC5 | A/P Credit Memo - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
439 | RPC6 | A/P Credit Memo - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
440 | RPC7 | Delivery Packages - A/P Credit Memo | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
441 | RPC8 | Items in Package - A/P Credit Memo | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
442 | RPC9 | A/P Credit Memo - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
443 | RPD1 | Goods Return - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
444 | RPD10 | Goods Return - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
445 | RPD11 | Gds Return - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
446 | RPD13 | Goods Returns Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
447 | RPD15 | Gds Return - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 21 | |
448 | RPD16 | Goods Return - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
449 | RPD2 | Goods Return - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
450 | RPD3 | Goods Return - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
451 | RPD5 | Goods Return - Withholding Tax Data | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
452 | RPD6 | Goods Return - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
453 | RPD7 | Goods Return - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
454 | RPD8 | Goods Return - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
455 | RPD9 | Goods Return - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
456 | TPI1 | Purchase Tax Invoice - Rows | 7 | ObjType | Object Type | Int | 6 | 0 | | |
457 | TSI1 | Sales Tax Invoice - Rows1 | 7 | ObjType | Object Type | Int | 6 | 0 | | |
458 | TXD1 | Tax Invoice Drafts - Rows | 7 | ObjType | Object Type | Int | 6 | 0 | | |
459 | WTR13 | Inventory Transfer Rows - Distributed Freights | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
460 | WTR15 | Inv. Transfer - Drawn Dpm Appl | 3 | ObjType | object type | nVarChar | 20 | 0 | 67 | |
461 | WTR16 | Inventory Transfer - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
TOPMRP |
462 | ORCM | Recommendation Data | 3 | ObjType | Document Number | Int | 11 | 0 | | |
TOPReports |
463 | OTRS | Tax Report Saving Object | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
464 | TRS1 | Tax Report Saving Object - Approved Documents | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
465 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
466 | XROBJ | XLR Company Report Objects | 7 | ObjType | ObjType | Int | 11 | 0 | | |
TOPSales Opportunities |
467 | OPR1 | Sales Opportunity - Rows | 13 | ObjType | Object Type | nVarChar | 2 | 0 | -1 | 13=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 23=Quotations |
TOPService |
468 | AINS | Customer Equipment Card - History | 36 | objType | Object Type | nVarChar | 20 | 0 | 176 | |
469 | ASC1 | Service Call Solutions - History | 4 | objType | Object Type - History | nVarChar | 20 | 0 | 191 | |
470 | ASCL | History | 24 | objType | Object Type | nVarChar | 20 | 0 | 191 | |
471 | OINS | Customer Equipment Card | 36 | objType | Object Type | nVarChar | 20 | 0 | 176 | |
472 | OSCL | Service Calls | 24 | objType | Object Type | nVarChar | 20 | 0 | 191 | |
473 | QUE2 | Queue Elements | 2 | objType | Object Type | nVarChar | 20 | 0 | | |
474 | SCL1 | Service Call Solutions - Rows | 4 | objType | Object Type | nVarChar | 20 | 0 | 191 | |