| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ABP2 | Branch Tributary Info. Log | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 247 | |
2 | ADP1 | Object Settings - History | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
3 | ALR1 | Queue of messages to be sent | 9 | ObjType | Object | nVarChar | 20 | 0 | | |
4 | ALR3 | Dynamic message data cells | 5 | ObjType | The linked object | nVarChar | 20 | 0 | | |
5 | AOB1 | Sent Messages - User History | 2 | ObjType | Object | nVarChar | 20 | 0 | 12 | -1=Random, 11=Contact Person, 12=User |
6 | AUSR | Archive Users - History | 66 | objType | Object Type | nVarChar | 20 | 0 | 12 | |
7 | AWLS | Workflow - Task Details | 6 | ObjType | Object Type | nVarChar | 20 | 0 | | |
8 | BPL2 | Branch Tributary Info. | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 247 | |
9 | CUMI | My Menu Items | 7 | ObjType | Object Type | nVarChar | 20 | 0 | | |
10 | MLS1 | Distribution Lists - Recipients | 3 | ObjType | Object | nVarChar | 20 | 0 | | |
11 | OCFX | Cash Flow Forecast Object Types | 1 | ObjType | Object Type | nVarChar | 20 | 0 | | |
12 | OUSR | Users | 66 | objType | Object Type - History | nVarChar | 20 | 0 | 12 | |
13 | OWLS | Workflow - Task Details | 6 | ObjType | Object Type | nVarChar | 20 | 0 | | |
14 | UDG1 | User Defaults - Documents | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
TOPBanking |
15 | ACH1 | Checks for Payment - Rows - History | 14 | ObjType | Object Type | nVarChar | 20 | 0 | | |
16 | ACHO | Checks for Payment - History | 43 | ObjType | Object Type | nVarChar | 20 | 0 | 57 | |
17 | ARC1 | Incoming Payment - Checks - History | 13 | ObjType | ObjType | nVarChar | 20 | 0 | | |
18 | ARC2 | Incoming Payment - Invoices - History | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
19 | ARC3 | Credit Vouchers History | 25 | ObjType | Object Type | nVarChar | 20 | 0 | | |
20 | ARC4 | Incoming Payment - Account List - History | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
21 | ARC5 | Reciept log vat adjustment-History | 4 | ObjType | Object Type - History | nVarChar | 20 | 0 | | |
22 | ARC6 | Incoming Payments - WTax Rows - History | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
23 | ARCT | Incoming Payment - History | 56 | ObjType | Object Type | nVarChar | 20 | 0 | | |
24 | CHD1 | Checks for Payment Drafts - Rows | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 123 | |
25 | CHO1 | Checks for Payment - Rows | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 57 | |
26 | OCHD | Checks for Payment Drafts | 43 | ObjType | Object Type | nVarChar | 20 | 0 | 123 | |
27 | OCHO | Checks for Payment | 43 | ObjType | Object Type | nVarChar | 20 | 0 | 57 | |
28 | ODPS | Deposit | 37 | ObjType | Object Type | nVarChar | 20 | 0 | | |
29 | ODPT | Postdated Deposit | 22 | ObjType | Object Type | nVarChar | 20 | 0 | | |
30 | OPDF | Payment Draft | 56 | ObjType | Object Type | nVarChar | 20 | 0 | | 24=Incoming Payment, 46=Outgoing Payments |
31 | ORCT | Incoming Payment | 56 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | 24=Incoming Payment |
32 | OVPM | Outgoing Payments | 56 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | 46=Outgoing Payments |
33 | PDF1 | Payment Draft - Checks | 13 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
34 | PDF2 | Payment Draft - Invoices | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
35 | PDF3 | Payment Draft - Credit Vouchers | 25 | ObjType | Object Type | nVarChar | 20 | 0 | | |
36 | PDF4 | Payment Draft - Account List | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
37 | PDF5 | PaymentDraft - vat adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | | |
38 | PDF6 | Payment Drafts - Withholding Tax - Rows | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
39 | PEX1 | Payment Results Table - Rows | 11 | ObjType | Document Object Type | nVarChar | 20 | 0 | | |
40 | PMN5 | Payment - VAT Adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
41 | PWZ3 | Payment Wizard - Rows 3 | 33 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
42 | PWZ4 | Payment Wizard - Rows 4 | 9 | ObjType | Object Type | nVarChar | 20 | 0 | | 24=Incoming Payment, 46=Outgoing Payment |
43 | RCC4 | Incoming Payment - Credit Vouchers | 11 | ObjType | Number of Payments | nVarChar | 20 | 0 | 1 | |
44 | RCT1 | Incoming Payment - Checks | 13 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
45 | RCT2 | Incoming Payments - Invoices | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
46 | RCT3 | Incoming Pmt - Credit Vouchers | 25 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
47 | RCT4 | Incoming Payment - Account List | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
48 | RCT5 | Reciept vat adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
49 | RCT6 | Incoming Payments - WTax Rows | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 24 | |
50 | VPM1 | Outgoing Payments - Check Rows | 13 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
51 | VPM2 | Outgoing Payments - Invoices | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
52 | VPM3 | Outgoing Payments - Credit Vouchers | 25 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
53 | VPM4 | Outgoing Payments - Accounts | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
54 | VPM5 | Outgoing Payments - Vat Adjustment | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
55 | VPM6 | Outgoing Payments - WTax Rows | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 46 | |
TOPBusiness Partners |
56 | ACPR | Contact Persons - History | 18 | ObjType | Object Type | nVarChar | 20 | 0 | | |
57 | ACR1 | Business Partner Addresses - History | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
58 | ACR2 | Bussiness Partners - Payment Methods-History | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
59 | ACR3 | Business Partner Control Accounts - History | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
60 | ACRD | Business Partners - History | 170 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
61 | AOAT | Blanket Agreement | 38 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000025 | |
62 | CRD1 | Business Partners - Addresses | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
63 | CRD2 | Bussiness Partners - Payment Methods | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
64 | CRD3 | BP Control Account | 5 | ObjType | Object Type | Int | 6 | 0 | 2 | |
65 | OCPR | Contact Persons | 18 | ObjType | Object Type | nVarChar | 20 | 0 | 11 | |
66 | OCRD | Business Partner | 170 | ObjType | Object Type | nVarChar | 20 | 0 | 2 | |
67 | OOAT | Blanket Agreement | 38 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000025 | |
TOPFinance |
68 | AACT | G/L Account - History | 52 | ObjType | Object Type | nVarChar | 20 | 0 | | |
69 | ACD1 | Credit Memo - Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
70 | ACD2 | Credit Memo - Area Journal Transactions | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
71 | ACD3 | Credit Memo - Item Areas | 8 | ObjType | Object Type | nVarChar | 20 | 0 | | |
72 | ACQ1 | Capitalization - Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
73 | ACQ2 | Capitalization - Area Journal Transactions | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
74 | ACQ3 | Capitalization - Item Areas | 8 | ObjType | Object Type | nVarChar | 20 | 0 | | |
75 | AFA1 | Asset Document - Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
76 | AFA2 | Asset Document - Area Journal Transactions | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
77 | AFAD | Asset Document - History | 12 | ObjType | Object Type | nVarChar | 20 | 0 | | |
78 | AJD1 | Journal Entry - History - Rows | 47 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
79 | AJD2 | Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
80 | AJDT | Journal Entry - History | 31 | ObjType | Object Type | nVarChar | 20 | 0 | | |
81 | BTF1 | Journal Voucher - Rows | 47 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
82 | BTF2 | Journal Voucher Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
83 | FTR1 | Transfer - Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
84 | FTR2 | Transfer - Area Journal Transactions | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
85 | FTR3 | Transfer - Item Areas | 8 | ObjType | Object Type | nVarChar | 20 | 0 | | |
86 | ISW3 | Declaration Rows | 6 | ObjType | Document Type | Int | 11 | 0 | | |
87 | JDT1 | Journal Entry - Rows | 47 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
88 | JDT2 | Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
89 | MDP1 | Manual Depreciation - Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
90 | MDP2 | Manual Depreciation - Area Journal Transactions | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
91 | MDP3 | Manual Depreciation - Item Areas | 8 | ObjType | Object Type | nVarChar | 20 | 0 | | |
92 | OACD | Credit Memo | 12 | ObjType | Object Type | nVarChar | 20 | 0 | | |
93 | OACQ | Capitalization | 12 | ObjType | Object Type | nVarChar | 20 | 0 | | |
94 | OACT | G/L Accounts | 52 | ObjType | Object Type | nVarChar | 20 | 0 | 1 | |
95 | OBTF | Journal Voucher Entry | 31 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
96 | OFTR | Transfer | 12 | ObjType | Object Type | nVarChar | 20 | 0 | | |
97 | OJDT | Journal Entry | 31 | ObjType | Object Type | nVarChar | 20 | 0 | 30 | |
98 | OMDP | Manual Depreciation | 12 | ObjType | Object Type | nVarChar | 20 | 0 | | |
99 | ORTI | Retirement | 12 | ObjType | Object Type | nVarChar | 20 | 0 | | |
100 | RTI1 | Retirement - Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | | |
101 | RTI2 | Retirement - Area Journal Transactions | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
102 | RTI3 | Retirement - Item Areas | 8 | ObjType | Object Type | nVarChar | 20 | 0 | | |
TOPGeneral |
103 | ARSC | Resource Master Data - Log | 107 | ObjType | Object Type | nVarChar | 20 | 0 | 290 | |
104 | ARSC1 | Resources - Warehouses - Log | 4 | ObjType | Object | nVarChar | 20 | 0 | 290 | |
105 | ARSC2 | Resources - Prices - Log | 8 | ObjType | Object | nVarChar | 20 | 0 | 290 | |
106 | ARSC5 | Resources - Preferred Vendors - Log | 4 | ObjType | Object | nVarChar | 20 | 0 | 290 | |
107 | CIN11 | Correction Invoice - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
108 | OAGM | Arguments for Integration Framework | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
109 | ODSL | Schedule Row Detail | 2 | ObjType | Object Type | nVarChar | 20 | 0 | -1 | 1250000001=Warehouse Transfer Request, 13=A/R Reserve Invoice, 163=A/P Correction Reserve Invoice, 165=A/R Correction Reserve Invoice, 17=Sales Order, 18=A/P Reserve Invoice, 202=Production Order, 22=Purchase Order |
110 | ORSC | Resources | 107 | ObjType | Object Type | nVarChar | 20 | 0 | 290 | |
111 | OSLD | Schedule Row Detail | 2 | ObjType | Object Type | nVarChar | 20 | 0 | -1 | 1250000001=Warehouse Transfer Request, 13=A/R Reserve Invoice, 163=A/P Correction Reserve Invoice, 165=A/R Correction Reserve Invoice, 17=Sales Order, 18=A/P Reserve Invoice, 202=Production Order, 22=Purchase Order |
112 | RSC1 | Resources - Warehouses | 4 | ObjType | Object | nVarChar | 20 | 0 | 290 | |
113 | RSC2 | Resources - Prices | 8 | ObjType | Object | nVarChar | 20 | 0 | 290 | |
114 | RSC5 | Resources - Preferred Vendors | 4 | ObjType | Object | nVarChar | 20 | 0 | 290 | |
TOPInventory and Production |
115 | ABTN | Batch Numbers Master Data | 20 | ObjType | Object Type | nVarChar | 20 | 0 | | |
116 | ABTW | Batch Attributes in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
117 | ADG1 | Discount Groups Rows | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | 43=Manufacturer, 4=Items, 52=Item Groups, 8=Item Properties |
118 | AEDG | Discount Groups | 3 | ObjType | Object Type | nVarChar | 20 | 0 | -1 | 10=Card Payment Groups, 2=Cards |
119 | AIN11 | Inventory Counting - Individual Counters - Row SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
120 | AIN3 | Inventory Count - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
121 | AIN7 | Inventory Counting - Team Counter - Row SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
122 | AINC | Inventory Counting | 19 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000065 | |
123 | AIQI | Inventory Opening Balance | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
124 | AIQR | Inventory Posting | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
125 | AIT1 | Item - Prices - History | 8 | ObjType | Object | nVarChar | 20 | 0 | | |
126 | AIT13 | Asset Attributes | 67 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
127 | AIT2 | Items - Multiple Preferred Vendors - History | 4 | ObjType | Object | nVarChar | 20 | 0 | | |
128 | AIT3 | Items - Localization Fields - History | 4 | ObjType | Log Instance | nVarChar | 20 | 0 | 0 | |
129 | AIT5 | Asset Item Projects - History | 7 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
130 | AIT6 | Asset Item Distribution Rules | 11 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
131 | AIT7 | Asset Item Depreciation Params - History | 13 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
132 | AIT8 | Asset Item Balances - History | 16 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
133 | AIT9 | Item - UoM Prices | 13 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
134 | AITM | Items - History | 199 | ObjType | Object Type | nVarChar | 20 | 0 | | |
135 | AKL2 | Pick List for SnB and Bin Details | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 156 | |
136 | AMR1 | Inventory Revaluation - History - Rows | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
137 | AMR2 | Inventory Revaluation FIFO Rows (Archive) | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
138 | AMRV | Inventory Revaluation - History | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
139 | APKL | Pick List - History | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 156 | |
140 | AQI1 | Inventory Opening Balance - Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
141 | AQI2 | Inventory Opening Balance - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
142 | AQR1 | Inventory Posting - Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
143 | AQR3 | Inventory Count - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
144 | ASRN | Serial Numbers Master Data | 20 | ObjType | Object Type | nVarChar | 20 | 0 | | |
145 | AWHS | Warehouses - History | 54 | objType | Object Type - History | nVarChar | 20 | 0 | 64 | |
146 | EDG1 | Discount Groups Rows | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | 43=Manufacturer, 4=Items, 52=Item Groups, 8=Item Properties |
147 | ICD11 | Inventory Counting Draft - Individual Counter - Row SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
148 | ICD3 | Inventory Count Draft - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
149 | ICD7 | Inventory Counting Draft - Team Counter - Row SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
150 | IGE1 | Goods Issue - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
151 | IGE10 | Goods Issue - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
152 | IGE11 | Goods Issue - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
153 | IGE13 | Goods Issue Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
154 | IGE15 | Gds Issue - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 60 | |
155 | IGE16 | Goods Issue - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
156 | IGE19 | Goods Issue - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
157 | IGE2 | Goods Issue - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
158 | IGE3 | Goods Issue - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
159 | IGE5 | Goods Issue - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
160 | IGE6 | Goods Issue - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
161 | IGE7 | Delivery Packages - Goods Issue | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
162 | IGE8 | Items in Package - Goods Issue | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | |
163 | IGE9 | Goods Issue - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
164 | IGN1 | Goods Receipt - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
165 | IGN10 | Goods Receipt - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
166 | IGN11 | Goods Receipt - Drawn Dpm Det | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
167 | IGN13 | Goods Receipt Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
168 | IGN15 | Gds Rcpt - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 59 | |
169 | IGN16 | Goods Receipt - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
170 | IGN19 | Goods Receipt - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
171 | IGN2 | Goods Receipt - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
172 | IGN3 | Goods Receipt - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
173 | IGN5 | Goods Receipt - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
174 | IGN6 | Goods Receipt- Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
175 | IGN7 | Goods Receipt - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
176 | IGN8 | Goods Receipt - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | |
177 | IGN9 | Goods Receipt - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
178 | INC11 | Inventory Counting - Individual Counter - Row SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
179 | INC3 | Inventory Count - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
180 | INC7 | Inventory Counting - Team Counter - Row SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
181 | IOD1 | Inventory Opening Balance Draft - Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
182 | IOD2 | Inventory Opening Balance Draft - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
183 | IPD1 | Inventory Posting Draft - Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
184 | IPD3 | Inventory Posting Draft - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
185 | IQI1 | Inventory Opening Balance - Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
186 | IQI2 | Inventory Opening Balance - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
187 | IQR1 | Inventory Posting - Rows | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
188 | IQR3 | Inventory Posting - SnB | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
189 | ITM1 | Items - Prices | 8 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
190 | ITM13 | Asset Attributes | 67 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
191 | ITM2 | Items - Multiple Preferred Vendors | 4 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
192 | ITM3 | Items - Localization Fields | 4 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
193 | ITM5 | Asset Item Projects | 7 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
194 | ITM6 | Asset Item Distribution Rules | 11 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
195 | ITM7 | Asset Item Depreciation Params | 13 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
196 | ITM8 | Asset Item Balances | 16 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
197 | ITM9 | Item - UoM Prices | 13 | ObjType | Object | nVarChar | 20 | 0 | 4 | |
198 | MRV1 | Inventory Revaluation Information Array | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
199 | MRV2 | Inventory Revaluation FIFO Rows | 16 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
200 | OBTN | Batch Numbers Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
201 | OBTW | Batch Attributes in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
202 | ODBN | Bat. Nos - Draft - Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
203 | ODBW | Batch Draft Attribs in Locat. | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
204 | ODSN | SNs - Draft - Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
205 | ODSW | SN Draft Attribs in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
206 | OEDG | Discount Groups | 3 | ObjType | Object Type | nVarChar | 20 | 0 | -1 | 10=Card Payment Groups, 2=Cards |
207 | OENT | Shipping Types | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
208 | OICD | Inventory Counting Draft | 19 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000065 | |
209 | OIGE | Goods Issue | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 60 | 60=Goods Issue |
210 | OIGN | Goods Receipt | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 59 | 59=Goods Receipt |
211 | OINC | Inventory Counting | 19 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000065 | |
212 | OIOD | Inventory Opening Balance Draft | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
213 | OIPD | Inventory Posting Draft | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
214 | OIPF | Landed Costs | 48 | ObjType | Object Type | nVarChar | 20 | 0 | 69 | |
215 | OIQI | Inventory Opening Balance | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 310000001 | |
216 | OIQR | Inventory Posting | 15 | ObjType | Object Type | nVarChar | 20 | 0 | 10000071 | |
217 | OITM | Items | 199 | ObjType | Object Type | nVarChar | 20 | 0 | 4 | |
218 | OMRV | Inventory Revaluation | 22 | ObjType | Object Type | nVarChar | 20 | 0 | 162 | |
219 | OPKL | Pick List | 12 | ObjType | Object Type | nVarChar | 20 | 0 | 156 | |
220 | OSPG | Special Prices for Groups | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | 43=Companies, 52=Item Group, 8=Item Properties |
221 | OSRN | Serial Numbers Master Data | 20 | ObjType | object type | nVarChar | 20 | 0 | | |
222 | OSRW | Serial No. Attribs in Location | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
223 | OWHS | Warehouses | 54 | objType | Object Type - History | nVarChar | 20 | 0 | 64 | |
224 | OWKO | Production Instructions | 27 | ObjType | Object Type | nVarChar | 20 | 0 | 68 | |
225 | OWTQ | Inventory Transfer Request | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | 1250000001=Inventory Transfer Request |
226 | OWTR | Inventory Transfer | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | 67=Inventory Transfer |
227 | PKL2 | Pick List for SnB and Bin Details | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 156 | |
228 | SITM | Items | 199 | ObjType | Object Type | nVarChar | 20 | 0 | 4 | |
229 | UBTN | Batch Numbers Master Data | 20 | ObjType | Object Type | nVarChar | 20 | 0 | | |
230 | UITM | Items | 199 | ObjType | Object Type | nVarChar | 20 | 0 | 4 | |
231 | USRN | Serial Numbers Master Data | 20 | ObjType | Object Type | nVarChar | 20 | 0 | | |
232 | UWKO | Production Instructions | 27 | ObjType | Object Type | nVarChar | 20 | 0 | 68 | |
233 | WTQ1 | Inventory Transfer Request - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
234 | WTQ10 | Inventory Transfer Request - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
235 | WTQ11 | Inv. Transfer Request - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
236 | WTQ13 | Inventory Transfer Request Rows - Distributed Freights | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
237 | WTQ15 | Inv. Transfer Request - Drawn Dpm Appl | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
238 | WTQ16 | Inventory Transfer Request - SnB Properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
239 | WTQ19 | Inventory Transfer Request - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
240 | WTQ2 | Inventory Transfer Request - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
241 | WTQ3 | Inventory Transfer Request - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | |
242 | WTQ5 | Inventory Transfer Request - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | | |
243 | WTQ6 | Inventory Transfer Request - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
244 | WTQ7 | Inventory Transfer Request - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
245 | WTQ8 | Inventory Transfer Request - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 1250000001 | |
246 | WTQ9 | Inventory Transfer Request - Drawn DPM | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
247 | WTR1 | Inventory Transfer - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
248 | WTR10 | Inventory Transfer - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
249 | WTR11 | Inv. Transfer - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
250 | WTR13 | Inventory Transfer Rows - Distributed Freights | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
251 | WTR15 | Inv. Transfer - Drawn Dpm Appl | 3 | ObjType | object type | nVarChar | 20 | 0 | 67 | |
252 | WTR16 | Inventory Transfer - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
253 | WTR19 | Inventory Transfer - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
254 | WTR2 | Inventory Transfer - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
255 | WTR3 | Inventory Transfer - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
256 | WTR5 | Inventory Transfer - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
257 | WTR6 | Inventory Transfer - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
258 | WTR7 | Inventory Transfer - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
259 | WTR8 | Inventory Transfer - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 67 | |
260 | WTR9 | Inventory Transfer - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
TOPMarketing Documents |
261 | ADO1 | A/R Invoice (Rows) - History | 79 | ObjType | Object Type | nVarChar | 20 | 0 | | |
262 | ADO10 | A/R Invoice - Row Structure - History | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
263 | ADO11 | A/R Inv (Drawn Dpm Det) - Hist | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
264 | ADO13 | A/R Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
265 | ADO15 | A/R Inv (Drawn Dpm Applied) - Hist | 3 | ObjType | object type | nVarChar | 20 | 0 | 13 | |
266 | ADO16 | Draft - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
267 | ADO19 | Bin Allocation Data - History | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
268 | ADO2 | A/R Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
269 | ADO3 | A/R Invoice - Freight - History | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | |
270 | ADO5 | Withholding Tax - History | 28 | ObjType | Object Type | nVarChar | 20 | 0 | | |
271 | ADO6 | Documents History - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | | |
272 | ADO7 | Delivery Packages - History | 6 | ObjType | Object Type | nVarChar | 20 | 0 | | |
273 | ADO8 | Items in Package - History | 6 | ObjType | Object Type | nVarChar | 20 | 0 | | |
274 | ADO9 | A/R Invoice (Rows) - History | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
275 | ADOC | Invoice - History | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | |
276 | ATX1 | Tax Invoice - History - Rows | 7 | ObjType | Object Type | Int | 6 | 0 | | |
277 | ATX2 | Tax Invoice Operation Codes | 4 | ObjType | Object Type | Int | 11 | 0 | | |
278 | ATXI | Tax Invoice - History | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
279 | CIN1 | Correction Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
280 | CIN10 | Correction Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
281 | CIN13 | Correction Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
282 | CIN19 | Correction Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
283 | CIN2 | A/R Correction Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
284 | CIN3 | A/R Correction Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
285 | CIN5 | AR Correction Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
286 | CIN6 | Correction Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
287 | CIN7 | Delivery Packages - Correction Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
288 | CIN8 | Items in Package - Correction Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | |
289 | CIN9 | Correction Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
290 | CPI1 | A/P Correction Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
291 | CPI10 | A/P Correction Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
292 | CPI11 | A/P Corr. Inv - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
293 | CPI13 | A/P Correction Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
294 | CPI15 | A/P Corr Inv - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 163 | |
295 | CPI16 | A/P Corr. Inv - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
296 | CPI19 | A/P Correction Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
297 | CPI2 | A/P Correction Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
298 | CPI3 | A/P Correction Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
299 | CPI5 | Withholding Tax Data | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
300 | CPI6 | Documents History - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
301 | CPI7 | A/P Correction Invoice - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
302 | CPI8 | A/P Correction Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | |
303 | CPI9 | A/P Corr. Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
304 | CPV1 | A/P Correction Invoice Reversal - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
305 | CPV10 | A/P CrIn Rev - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
306 | CPV11 | A/P CrIn Rev - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
307 | CPV13 | A/P Correction Invoice Reversal Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
308 | CPV15 | A/P CrIn Rev - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 164 | |
309 | CPV16 | A/P Correction Invoice Reversal - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
310 | CPV19 | A/P Correction Invoice Reversal - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
311 | CPV2 | A/P Correction Invoice Reversal - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
312 | CPV3 | A/P Correction Invoice Reversal - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
313 | CPV5 | A/P Correction Invoice Reversal - WTax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
314 | CPV6 | A/P Correction Invoice Reversal - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
315 | CPV7 | A/P Corr Inv Rvsl - Deliv Pkgs | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
316 | CPV8 | A/P Correction Invoice Reversal - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | |
317 | CPV9 | A/P Corr Inv Rvrsl - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
318 | CSI1 | A/R Correction Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
319 | CSI10 | A/R Correction Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
320 | CSI11 | A/R Corr. Inv. - Drawn Dpm Det | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
321 | CSI13 | A/R Correction Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
322 | CSI15 | A/R Corr Inv - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 165 | |
323 | CSI16 | A/R Corr. Inv. - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
324 | CSI19 | A/R Correction Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
325 | CSI2 | A/R Corr Inv - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
326 | CSI3 | A/R Correction Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
327 | CSI5 | A/R Correction Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
328 | CSI6 | A/R Corr. Inv. - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
329 | CSI7 | A/R Corr. Inv. Deliv. Pkgs | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
330 | CSI8 | A/R Corr. Inv. - Items in Pkg | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | |
331 | CSI9 | A/R Corr. Inv. - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | |
332 | CSV1 | A/R Correction Invoice Reversal - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
333 | CSV10 | A/R Correction Invoice Reversal - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
334 | CSV11 | A/R CrIn Rev - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
335 | CSV13 | A/R Correction Invoice Reversal Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
336 | CSV15 | A/R CrIn Rev - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 166 | |
337 | CSV16 | A/R Correction Invoice Reversal - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
338 | CSV19 | A/R Correction Invoice Reversal - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
339 | CSV2 | A/R Correction Invoice Reversal - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
340 | CSV3 | A/R Correction Invoice Reversal - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
341 | CSV5 | A/R Correction Invoice Reversal - WTax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
342 | CSV6 | A/R Correction Invoice Reversal - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
343 | CSV7 | A/R Correction Invoice Reversal - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
344 | CSV8 | A/R Correction Invoice Reversal - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | |
345 | CSV9 | A/R CrIn Rev - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
346 | DLN1 | Delivery - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
347 | DLN10 | Delivery - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
348 | DLN11 | Delivery - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
349 | DLN13 | Delivery Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
350 | DLN15 | Delivery - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 15 | |
351 | DLN16 | Delivery - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
352 | DLN19 | Delivery - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
353 | DLN2 | Delivery Notes - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
354 | DLN3 | Delivery Notes - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
355 | DLN5 | Delivery - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
356 | DLN6 | Delivery - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
357 | DLN7 | Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
358 | DLN8 | Items in Package - Delivery | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | |
359 | DLN9 | Delivery - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
360 | DPI1 | A/R Down Payment - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
361 | DPI10 | A/R Down Payment - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
362 | DPI11 | A/R DP - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
363 | DPI13 | A/R Down Payment Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 202 | |
364 | DPI15 | A/R DP - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 203 | |
365 | DPI16 | A/R Down Payment - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
366 | DPI19 | A/R Down Payment - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
367 | DPI2 | A/R Down Payment - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
368 | DPI3 | A/R Down Payment - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 202 | |
369 | DPI5 | A/R Down Payment - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
370 | DPI6 | A/R Down Payment - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
371 | DPI7 | Delivery Packages - A/R Down Pymt | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
372 | DPI8 | Items in Package - A/R Down Pmt. | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | |
373 | DPI9 | Down Payment Incoming - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
374 | DPO1 | A/P Down Payment - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
375 | DPO10 | A/P Down Payment - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
376 | DPO11 | A/P DP - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
377 | DPO13 | A/P Down Payment Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
378 | DPO15 | A/P DP - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 204 | |
379 | DPO16 | A/P Down Payment - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
380 | DPO19 | A/P Down Payment - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
381 | DPO2 | A/P Down Payment - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
382 | DPO3 | A/P Down Payment - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
383 | DPO5 | A/P Down Payment - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
384 | DPO6 | Down Payment Out - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
385 | DPO7 | Delivery Packages - A/P Down Pymt | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
386 | DPO8 | Items in Package - A/P Down Pmt. | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | |
387 | DPO9 | Down Payment Outgoing - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
388 | DRF1 | Draft - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
389 | DRF10 | Draft - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
390 | DRF11 | Draft - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
391 | DRF13 | Draft Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
392 | DRF15 | Draft - Drawn Dpm Applied | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
393 | DRF16 | Draft - SnB - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | | |
394 | DRF19 | Draft - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
395 | DRF2 | Draft - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
396 | DRF3 | Draft - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
397 | DRF5 | Draft Documents - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
398 | DRF6 | Document Drafts - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
399 | DRF7 | Delivery Packages - Drafts | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
400 | DRF8 | Items in Package - Draft | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 112 | |
401 | DRF9 | Document Draft - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
402 | IEI1 | Incoming Excise Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
403 | IEI10 | Incoming Excise Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
404 | IEI11 | IEI - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
405 | IEI13 | Incoming Excise Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
406 | IEI15 | IEI - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 140000010 | |
407 | IEI16 | Incoming Excise Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
408 | IEI19 | Incoming Excise Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
409 | IEI2 | Incoming Excise Invoice - Freight - History - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
410 | IEI3 | IEI - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
411 | IEI5 | Incoming Excise Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
412 | IEI6 | IEI - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
413 | IEI7 | Delivery Packages - Incoming Excise Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
414 | IEI8 | Incoming Excise Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | |
415 | IEI9 | IEI - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | |
416 | INV1 | A/R Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
417 | INV10 | A/R Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
418 | INV11 | A/R Invoice - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
419 | INV13 | A/R Invoice Rows - Distributed Freights | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
420 | INV15 | A/R Inv. - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 13 | |
421 | INV16 | A/R Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
422 | INV19 | A/R Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
423 | INV2 | A/R Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
424 | INV3 | A/R Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
425 | INV5 | A/R Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
426 | INV6 | A/R Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
427 | INV7 | A/R Invoice - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
428 | INV8 | A/R Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | |
429 | INV9 | A/R Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | 203=A/R Down Payment |
430 | OCIN | A/R Correction Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 132 | 132=Correction Invoice |
431 | OCPI | A/P Correction Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 163 | 163=A/P Correction Invoice |
432 | OCPV | A/P Correction Invoice Reversal | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 164 | 164=A/P Correction Invoice Reversal |
433 | OCSI | A/R Correction Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 165 | 165=A/R Correction Invoice |
434 | OCSV | A/R Correction Invoice Reversal | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 166 | 166=A/R Correction Invoice Reversal |
435 | ODLN | Delivery | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 15 | 15=Delivery |
436 | ODPI | A/R Down Payment | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 203 | 203=A/R Down Payment |
437 | ODPO | A/P Down Payment | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 204 | 204=A/P Down Payment |
438 | ODRF | Drafts | 10 | ObjType | Object Type | nVarChar | 20 | 0 | | 1250000001=Inventory Transfer Request, 132=Correction Invoice, 13=A/R Invoice, 1470000113=Purchase Request, 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/ |
439 | OEI1 | Outgoing Excise Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
440 | OEI10 | Outgoing Excise Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
441 | OEI11 | OEI - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
442 | OEI13 | Outgoing Excise Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
443 | OEI15 | OEI - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 140000009 | |
444 | OEI16 | Outgoing Excise Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
445 | OEI19 | Outgoing Excise Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
446 | OEI2 | OEI - Freight Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
447 | OEI3 | OEI - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
448 | OEI5 | Outgoing Excise Invoice - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
449 | OEI6 | Outgoing Excise Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 140000000 | |
450 | OEI7 | Delivery Packages - Outgoing Excise Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
451 | OEI8 | Outgoing Excise Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | |
452 | OEI9 | OEI - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 203 | |
453 | OIEI | Incoming Excise Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000010 | 140000010=Incoming Excise Invoice |
454 | OINV | A/R Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 13 | 13=A/R Invoice |
455 | OLGL | Legal Data | 4 | ObjType | Object Type | nVarChar | 20 | 0 | 540000073 | |
456 | OOEI | Outgoing Excise Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 140000009 | 140000009=Outgoing Excise Invoice |
457 | OPCH | A/P Invoice | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | 18=A/P Invoice |
458 | OPDN | Goods Receipt PO | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | 20=Goods Receipt PO |
459 | OPOR | Purchase Order | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | 22=Purchase Order |
460 | OPQT | Purchase Quotation | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | 540000006=Purchase Quotation |
461 | OPRQ | Purchase Request | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | 1470000113=Purchase Request |
462 | OQUT | Sales Quotation | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | 23=Sales Quotation |
463 | ORDN | Returns | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | 16=Returns |
464 | ORDR | Sales Order | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | 17=Sales Order |
465 | ORIN | A/R Credit Memo | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | 14=A/R Credit Memo |
466 | ORPC | A/P Credit Memo | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | 19=A/P Credit Memo |
467 | ORPD | Goods Return | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | 21=Goods Return |
468 | OSAL | Outgoing | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
469 | OTPI | Purchase Tax Invoice | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
470 | OTRA | Transition | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | |
471 | OTSI | Sales Tax Invoice | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
472 | OTXD | Tax Invoice Draft | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 194 | |
473 | OWDD | Docs. for Confirmation | 5 | ObjType | Object Type | nVarChar | 20 | 0 | | (-0=(-, (-1=(-, (-2=(-, (-3=(-, 10000071=Inventory Posting, 112=Documents - Drafts, 1250000001=Inventory Transfer Request, 132=Correction Invoice, 13=A/R Invoice, 140=Payment Drafts, 1470000065=Inventory Counting, 1470000109=Inventory Counting - Drafts, 1470000113=Purchase Request, 1470000131=Inventory Opening Balance - Drafts, 1470000136= |
474 | PCH1 | A/P Invoice - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
475 | PCH10 | A/P Invoice - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
476 | PCH11 | A/P Invoice - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
477 | PCH13 | A/P Invoice Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
478 | PCH15 | A/P Invoice - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 18 | |
479 | PCH16 | A/P Invoice - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
480 | PCH19 | A/P Invoice - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
481 | PCH2 | A/P Invoice - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
482 | PCH3 | A/P Invoice - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
483 | PCH5 | A/P Invoice - Withholding Tax Data | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
484 | PCH6 | A/P Invoice - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
485 | PCH7 | Delivery Packages - A/P Invoice | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
486 | PCH8 | A/P Invoice - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 18 | |
487 | PCH9 | A/P Invoice - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | 204 | 204=A/P Down Payment |
488 | PDN1 | Goods Receipt PO - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
489 | PDN10 | Goods Receipt PO - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
490 | PDN11 | GRPO - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
491 | PDN13 | Goods Receipt PO Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
492 | PDN15 | GRPO - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 20 | |
493 | PDN16 | Goods Receipt PO - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
494 | PDN19 | Goods Receipt PO - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
495 | PDN2 | Goods Receipt PO - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
496 | PDN3 | Goods Receipt PO - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
497 | PDN5 | Goods Reciept PO - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
498 | PDN6 | Goods Receipt PO - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
499 | PDN7 | Goods Receipt PO - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
500 | PDN8 | Goods Receipt PO - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 20 | |
501 | PDN9 | Goods Receipt PO - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
502 | POR1 | Purchase Order - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
503 | POR10 | Purchase Order - Row structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
504 | POR11 | PO - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
505 | POR13 | Purchase Order Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
506 | POR15 | PO - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 22 | |
507 | POR16 | Purchase Order - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
508 | POR19 | Purchase Order - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
509 | POR2 | Purchase Order - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
510 | POR3 | Purchase Order - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
511 | POR5 | Purchase Order - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
512 | POR6 | Purchase Order - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
513 | POR7 | Delivery Packages - Purchase Order | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
514 | POR8 | Items in Package - Purchase Order | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 22 | |
515 | POR9 | Purchase Order - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
516 | PQT1 | Purchase Quotation - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
517 | PQT10 | Purchase Quotation - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
518 | PQT11 | PQ - Drawn DPM Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
519 | PQT13 | Purchase Quotation Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
520 | PQT15 | PQ - Drawn DPM Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 540000006 | |
521 | PQT16 | Purchase Quotation - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
522 | PQT19 | Purchase Quotation - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
523 | PQT2 | Purchase Quotation - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
524 | PQT3 | Purchase Quotation - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
525 | PQT5 | Purchase Quotation - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
526 | PQT6 | Purchase Quotation - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
527 | PQT7 | Delivery Packages - Purchase Quotation | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
528 | PQT8 | Items in Package - Purchase Quotation | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 540000006 | |
529 | PQT9 | Purchase Quotation - Drawn DPM | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
530 | PRQ1 | Purchase Request - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
531 | PRQ10 | Purchase Request - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
532 | PRQ11 | PR - Drawn DPM Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
533 | PRQ13 | Purchase Request Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
534 | PRQ15 | PR - Drawn DPM Applied | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
535 | PRQ16 | Purchase Request - SnB Properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
536 | PRQ19 | Purchase Request - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
537 | PRQ2 | Purchase Request - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
538 | PRQ3 | Purchase Request - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
539 | PRQ5 | Purchase Request - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
540 | PRQ6 | Purchase Request - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
541 | PRQ7 | Delivery Packages - Purchase Request | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
542 | PRQ8 | Items in Package - Purchase Request | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 1470000113 | |
543 | PRQ9 | Purchase Request - Drawn DPM | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
544 | QUT1 | Sales Quotation - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
545 | QUT10 | Sales Quotation - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
546 | QUT11 | Sls Quote - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
547 | QUT13 | Sales Quotation Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
548 | QUT15 | Sls Quote - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 23 | |
549 | QUT16 | Sales Quotation - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
550 | QUT19 | Sales Quotation - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
551 | QUT2 | Sales Quotation - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
552 | QUT3 | Sales Quotation - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
553 | QUT5 | Sales Quotation - Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
554 | QUT6 | Sales Quotation - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
555 | QUT7 | Delivery Packages - Sales Quotation | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
556 | QUT8 | Sales Quotation - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 23 | |
557 | QUT9 | Sales Quotation - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
558 | RDN1 | Returns - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
559 | RDN10 | Returns - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
560 | RDN11 | Returns - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
561 | RDN13 | Returns Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
562 | RDN15 | Returns - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 16 | |
563 | RDN16 | Returns - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
564 | RDN19 | Returns - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
565 | RDN2 | Return - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
566 | RDN3 | Return - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
567 | RDN5 | Returns - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
568 | RDN6 | Returns - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
569 | RDN7 | Delivery Packages - Returns | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
570 | RDN8 | Returns - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 16 | |
571 | RDN9 | Returns - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
572 | RDR1 | Sales Order - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
573 | RDR10 | Sales Order - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
574 | RDR11 | Sls Ord. - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
575 | RDR13 | Sales Order Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
576 | RDR15 | Sls Ord. - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 17 | |
577 | RDR16 | Sales Order - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
578 | RDR19 | Sales Order - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
579 | RDR2 | Sales Order - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
580 | RDR3 | Sales Order - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
581 | RDR5 | Sales Order - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
582 | RDR6 | Sales Order - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
583 | RDR7 | Delivery Packages - Sales Order | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
584 | RDR8 | Sales Order - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 17 | |
585 | RDR9 | Order - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
586 | RIN1 | A/R Credit Memo - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
587 | RIN10 | A/R Credit Memo - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
588 | RIN11 | A/R Cr. Memo - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
589 | RIN13 | A/R Credit Memo Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
590 | RIN15 | A/R Cr. Memo - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 14 | |
591 | RIN16 | A/R Credit Memo - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
592 | RIN19 | A/R Credit Memo - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
593 | RIN2 | A/R Credit Memo - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
594 | RIN3 | A/R Credit Memo - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
595 | RIN5 | A/R Credit Memo - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
596 | RIN6 | A/R Credit Memo - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
597 | RIN7 | A/R Credit Memo - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
598 | RIN8 | Items in Package - A/R Credit Memo | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 14 | |
599 | RIN9 | A/R Credit Memo - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
600 | RPC1 | A/P Credit Memo - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
601 | RPC10 | A/P Credit Memo - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
602 | RPC11 | A/P Cr. Memo - Drawn Dpm Det. | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
603 | RPC13 | A/P Credit Memo Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
604 | RPC15 | A/P Cr. Memo - Drawn Dpm Appld | 3 | ObjType | object type | nVarChar | 20 | 0 | 19 | |
605 | RPC16 | A/P Credit Memo - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
606 | RPC19 | A/P Credit Memo - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
607 | RPC2 | A/P Credit Memo Rows - Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
608 | RPC3 | A/P Credit Memo - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
609 | RPC5 | A/P Credit Memo - Withholding Tax | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
610 | RPC6 | A/P Credit Memo - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
611 | RPC7 | Delivery Packages - A/P Credit Memo | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
612 | RPC8 | Items in Package - A/P Credit Memo | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 19 | |
613 | RPC9 | A/P Credit Memo - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
614 | RPD1 | Goods Return - Rows | 79 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
615 | RPD10 | Goods Return - Row Structure | 8 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
616 | RPD11 | Gds Return - Drawn Dpm Detail | 14 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
617 | RPD13 | Goods Returns Rows - Distributed Expenses | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
618 | RPD15 | Gds Return - Drawn Dpm Applied | 3 | ObjType | object type | nVarChar | 20 | 0 | 21 | |
619 | RPD16 | Goods Return - SnB properties | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
620 | RPD19 | Goods Return - Bin Allocation Data | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
621 | RPD2 | Goods Return - Freight - Rows | 11 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
622 | RPD3 | Goods Return - Freight | 10 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
623 | RPD5 | Goods Return - Withholding Tax Data | 28 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
624 | RPD6 | Goods Return - Installments | 3 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
625 | RPD7 | Goods Return - Delivery Packages | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
626 | RPD8 | Goods Return - Items in Package | 6 | ObjType | Object Type | nVarChar | 20 | 0 | 21 | |
627 | RPD9 | Goods Return - Drawn Dpm | 6 | ObjType | Base Object Type | nVarChar | 20 | 0 | | |
628 | TPI1 | Purchase Tax Invoice - Rows | 7 | ObjType | Object Type | Int | 6 | 0 | | |
629 | TPI2 | Tax Invoice Operation Codes | 4 | ObjType | Object Type | Int | 11 | 0 | | |
630 | TSI1 | Sales Tax Invoice - Rows1 | 7 | ObjType | Object Type | Int | 6 | 0 | | |
631 | TSI2 | Tax Invoice Operation Codes | 4 | ObjType | Object Type | Int | 11 | 0 | | |
632 | TXD1 | Tax Invoice Drafts - Rows | 7 | ObjType | Object Type | Int | 6 | 0 | | |
TOPMRP |
633 | ORCM | Recommendation Data | 3 | ObjType | Document Number | Int | 11 | 0 | | |
TOPReports |
634 | OTRS | Tax Report Saving Object | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
635 | SRA3 | Scheduled Report Recipients | 3 | ObjType | Object Type | nVarChar | 20 | 0 | | |
636 | TRS1 | Tax Report Saving Object - Approved Documents | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
637 | TRS2 | Tax Rpt Sav Obj Man Chgd Vals | 2 | ObjType | Object Type | nVarChar | 20 | 0 | | |
638 | XROBJ | XLR Company Report Objects | 7 | ObjType | ObjType | Int | 11 | 0 | | |
TOPSales Opportunities |
639 | OPR1 | Opportunity - Rows | 13 | ObjType | Object Type | nVarChar | 9 | 0 | -1 | 13=Sales Invoices, 15=Delivery Notes, 17=Sales Orders, 18=Purchase Invoices, 20=Goods Receipt POs, 22=Purchase Orders, 23=Sales Quotations, 540000006=Purchase Quotations |
TOPService |
640 | AINS | Customer Equipment Card - History | 36 | objType | Object Type | nVarChar | 20 | 0 | 176 | |
641 | ASC1 | Service Call Solutions - History | 4 | objType | Object Type - History | nVarChar | 20 | 0 | 191 | |
642 | ASCL | History | 24 | objType | Object Type | nVarChar | 20 | 0 | 191 | |
643 | OINS | Customer Equipment Card | 36 | objType | Object Type | nVarChar | 20 | 0 | 176 | |
644 | OSCL | Service Calls | 24 | objType | Object Type | nVarChar | 20 | 0 | 191 | |
645 | QUE2 | Queue Elements | 2 | objType | Object Type | nVarChar | 20 | 0 | | |
646 | SCL1 | Service Call Solutions - Rows | 4 | objType | Object Type | nVarChar | 20 | 0 | 191 | |