Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...

На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Книга Продаж» / Sales Ledger tables structure changes

Название Таблицы / Table Name Описание Таблицы / Table Description Поле / Field Расширенный комментарий / Extended Comment Тип данных / Data Type Длина поля iScala 3.5/ iScala 3.5 Length Точность iScala 3.5/ iScala 3.5 Precision Длина поля iScala 2.2/ iScala 2.2 Length Точность iScala 2.2/ iScala 2.2 Precision Новое поле? / is a New Field?
SL01 Customer File SL01006 Reference 1 NVARCHAR 35   20   —
SL01 Customer File SL01007 Reference 2 NVARCHAR 35   20   —
SL01 Customer File SL01008 Reference 3 NVARCHAR 35   20   —
SL01 Customer File SL01009 Reference 4 NVARCHAR 35   20   —
SL01 Customer File SL01017 Accounting String NVARCHAR 120   50   —
SL01 Customer File SL01021 Tax Registration Number NVARCHAR 20   15   —
SL01 Customer File SL01036 Discount Code NVARCHAR 3   2   —
SL01 Customer File SL01109 Long Customer Name NVARCHAR 200   50   —
SL01 Customer File SL01141 Invoice Issuer Code NCHAR 6   4   —
SL01 Customer File SL01151 Financial Operation Code NVARCHAR 10   1   —
SL01 Customer File SL01156 LTM Group NCHAR 6   — — +
SL01 Customer File SL01157 Drop Shipment Flag NCHAR 1   — — +
SL01 Customer File SL01158 Delivery Note, Sort INT 4   — — +
SL01 Customer File SL01159 Print Delivery Note at Picking Confirmation NVARCHAR 1   — — +
SL01 Customer File SL01160 Send Delivery Note at Picking Confirmation NVARCHAR 1   — — +
SL01 Customer File SL01161 Reorder Customer NCHAR 1   — — +
SL01 Customer File SL01162 Delivery Note Printing INT 1   — — +
SL01 Customer File SL01163 Invoice Printing INT 1   — — +
SL01 Customer File SL01164 ID type NCHAR 2   — — +
SL01 Customer File SL01165 Tax Responsibility Type NCHAR 2   — — +
SL01 Customer File SL01166 Harbour NVARCHAR 4   — — +
SL01 Customer File SL01167 Bundesland NVARCHAR 2   — — +
SL01 Customer File SL01168 Statistical Manner Code NVARCHAR 6   — — +
SL01 Customer File SL01169 Currency ID Number NVARCHAR 2   — — +
SL01 Customer File SL01170 EC Department Code NVARCHAR 2   — — +
SL01 Customer File SL01171 Regime Code NVARCHAR 2   — — +
SL01 Customer File SL01172 Print Invoice at Picking Confirmation NVARCHAR 1   — — +
SL01 Customer File SL01173 Send Invoice at Picking Confirmation NVARCHAR 1   — — +
SL01 Customer File SL01174 Fix Payment Day 1 INT 2   — — +
SL01 Customer File SL01175 Fix Payment Day 2 INT 2   — — +
SL01 Customer File SL01176 Fix Payment Day 3 INT 2   — — +
SL01 Customer File SL01177 Month Excluded from Payment INT 2   — — +
SL01 Customer File SL01178 Picking Confirmation, release for Delivery Note NVARCHAR 1   — — +
SL01 Customer File SL01179 Extended Commission Code NCHAR 2   — — +
SL01 Customer File SL01180 Tax Type NVARCHAR 6   — — +
SL01 Customer File SL01181 Tax Surcharge NCHAR 1   — — +
SL01 Customer File SL01182 Merge RIBA NCHAR 1   — — +
SL01 Customer File SL01183 Payment Address Code NVARCHAR 2   — — +
SL01 Customer File SL01184 Invoice Address Code NVARCHAR 2   — — +
SL01 Customer File SL01185 Invoice Sent Address Code NVARCHAR 2   — — +
SL01 Customer File SL01186 Excise Control Code NVARCHAR 25   — — +
SL01 Customer File SL01187 Excise Registration Number NVARCHAR 25   — — +
SL01 Customer File SL01188 Excise Division NVARCHAR 25   — — +
SL01 Customer File SL01189 Consolidated Sales Order Address Code NVARCHAR 2   — — +
SL01 Customer File SL01190 Region Code NVARCHAR 10   — — +
SL01 Customer File SL01191 State/Province Code NVARCHAR 10   — — +
SL01 Customer File SL01192 County Code NVARCHAR 10   — — +
SL01 Customer File SL01193 Email Address NVARCHAR 200   — — +
SL01 Customer File SL01194 Address Line 5 NVARCHAR 35   — — +
SL01 Customer File SL01195 Address Line 6 NVARCHAR 35   — — +
SL01 Customer File SL01196 Address Line 7 NVARCHAR 35   — — +
SL01 Customer File SL01197 Consolidation Mode for Lease Contracts NVARCHAR 1   — — +
SL01 Customer File SL01198 Extended User defined 1 NVARCHAR 150   — — +
SL01 Customer File SL01199 Extended User defined 2 NVARCHAR 150   — — +
SL01 Customer File SL01200 Extended User defined 3 NVARCHAR 150   — — +
SL01 Customer File SL01201 Extended User defined 4 NVARCHAR 150   — — +
SL01 Customer File SL01202 Extended User defined 5 NVARCHAR 150   — — +
SL01 Customer File SL01203 Extended User defined 6 NVARCHAR 150   — — +
SL01 Customer File SL01204 Extended User defined 7 NVARCHAR 150   — — +
SL01 Customer File SL01205 Extended User defined 8 NVARCHAR 150   — — +
SL01 Customer File SL01206 Extended User defined 9 NVARCHAR 150   — — +
SL01 Customer File SL01207 Extended User defined 10 NVARCHAR 150   — — +
SL01 Customer File SL01208 Extended User defined 11 NVARCHAR 150   — — +
SL01 Customer File SL01209 Extended User defined 12 NVARCHAR 150   — — +
SL01 Customer File SL01210 Extended User defined 13 NVARCHAR 150   — — +
SL01 Customer File SL01211 Extended User defined 14 NVARCHAR 150   — — +
SL01 Customer File SL01212 Extended User defined 15 NVARCHAR 150   — — +
SL01 Customer File SL01213 Extended User defined 16 NVARCHAR 150   — — +
SL01 Customer File SL01214 Extended User defined 17 NVARCHAR 150   — — +
SL01 Customer File SL01215 Extended User defined 18 NVARCHAR 150   — — +
SL01 Customer File SL01216 Extended User defined 19 NVARCHAR 150   — — +
SL01 Customer File SL01217 Extended User defined 20 NVARCHAR 150   — — +
SL01 Customer File SL01218 Partial Delivery Planning NVARCHAR 1   — — +
SL01 Customer File SL01219 License Flag NCHAR 1   — — +
SL01 Customer File SL01220 Licensed From DATETIME 8   — — +
SL01 Customer File SL01221 Licensed To DATETIME 8   — — +
SL01 Customer File SL01222 Partial Delivery if Credit Limit is Exceeded NCHAR 1   — — +
SL01 Customer File SL01223 Taxes on Ordered not Shipped amount (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01224 Additional costs on order (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01225 Taxes on additional order costs (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01226 Allocated not shipped amount (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01227 Taxes on allocated not shipped amount (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01228 Taxes on shipped not invoiced amount (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01229 Additional costs on order (shipped; LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01230 Taxes on additional costs on order (shipped; LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01231 Longitude NUMERIC 28 8 — — +
SL01 Customer File SL01232 Latitude NUMERIC 28 8 — — +
SL01 Customer File SL01233 Altitude NUMERIC 28 8 — — +
SL01 Customer File SL01234 Prepayments for Credit Check NUMERIC 20 8 — — +
SL01 Customer File SL01235 External ID NVARCHAR 36   — — +
SL01 Customer File SL01236 SUFARMA NVARCHAR 10   — — +
SL01 Customer File SL01237 Special ICMS regime (Brazil) NVARCHAR 50   — — +
SL01 Customer File SL01238 Spare (Brazil) NCHAR 1   — — +
SL01 Customer File SL01239 Include in Spesometro Form NVARCHAR 12   — — +
SL01 Customer File SL01240 Postal Giro A/C NVARCHAR 15   — — +
SL01 Customer File SL01241 Bank Giro Number NVARCHAR 15   — — +
SL01 Customer File SL01242 Way of Payments (Credit Note) NCHAR 2   — — +
SL01 Customer File SL01243 PO3 Sub type NCHAR 2   — — +
SL01 Customer File SL01244 SWIFT Address NVARCHAR 12   — — +
SL01 Customer File SL01245 WH Taxes on Ordered Not Shipped (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01246 WH Taxes on Additional Order Costs (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01247 WH Taxes on Allocated Not Shipped (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01248 WH Taxes on Shipped Not Invoiced (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01249 WH Taxes on Additional Shipped Costs (LCU) NUMERIC 20 8 — — +
SL01 Customer File SL01250 Overdue Tolerance Period INT 3   — — +
SL01 Customer File SL01251 Overdue Total Tolerance Amount NUMERIC 20 8 — — +
SL01 Customer File SL01252 Overdue Invoice Tolerance Amount NUMERIC 20 8 — — +
SL01 Customer File SL01253 Credit control status INT 2   — — +
SL01 Customer File SL01254 Reason Code for Non-Standard Taxation NCHAR 3   — — +
SL01 Customer File SL01255 Split Payments NCHAR 1   — — +
SL01 Customer File SL01256 Bank Code 2 NVARCHAR 10   — — +
SL01 Customer File SL01257 Bank Account Number 2 NVARCHAR 34   — — +
SL01 Customer File SL01258 Block New Orders NCHAR 1   — — +
SL01 Customer File SL01259 Anonymized NCHAR 1   — — +
SL03 Sales Ledger SL03002 Invoice Number NVARCHAR 25   15   —
SL03 Sales Ledger SL03003 Transaction Number NVARCHAR 9   6   —
SL03 Sales Ledger SL03017 Accounting String NVARCHAR 120   50   —
SL03 Sales Ledger SL03024 Text NVARCHAR 50   15   —
SL03 Sales Ledger SL03065 Reference Number NVARCHAR 25   20   —
SL03 Sales Ledger SL03072 Periodic Billing — Reference NVARCHAR 25   15   —
SL03 Sales Ledger SL03086 Original Transaction Number NVARCHAR 9   6   —
SL03 Sales Ledger SL03088 Document Type NCHAR 3   2   —
SL03 Sales Ledger SL03099 Bank note number NVARCHAR 20   — — +
SL03 Sales Ledger SL03100 Net Invoice Amount in Local Currency NUMERIC 20 8 — — +
SL03 Sales Ledger SL03101 Net Invoice Amount in Invoice Currency NUMERIC 20 8 — — +
SL03 Sales Ledger SL03102 Instalments NCHAR 1   — — +
SL03 Sales Ledger SL03103 Sales Return Reason Code INT 1   — — +
SL03 Sales Ledger SL03104 Tax Note Number NVARCHAR 25   — — +
SL03 Sales Ledger SL03105 Financial Operation Code 2 NVARCHAR 10   — — +
SL03 Sales Ledger SL03106 EDI Status NCHAR 1   — — +
SL03 Sales Ledger SL03107 Number Of Pages INT 3   — — +
SL03 Sales Ledger SL03108 Issuer External Code NVARCHAR 16   — — +
SL03 Sales Ledger SL03109 Issuer validity Date DATETIME 8   — — +
SL03 Sales Ledger SL03110 POS Machine NCHAR 1   — — +
SL03 Sales Ledger SL03111 Tax Note Register Date DATETIME 8   — — +
SL03 Sales Ledger SL03112 Invoice Issuer Code NCHAR 6   — — +
SL03 Sales Ledger SL03113 Commission Base NUMERIC 20 8 — — +
SL03 Sales Ledger SL03114 Commission Withheld Cost NUMERIC 20 8 — — +
SL03 Sales Ledger SL03115 Commission Distribution Method NVARCHAR 1   — — +
SL03 Sales Ledger SL03116 Due Date Definition INT 1   — — +
SL03 Sales Ledger SL03117 Payment Term NVARCHAR 2   — — +
SL03 Sales Ledger SL03118 Lock Payments for Invoices INT 1   — — +
SL03 Sales Ledger SL03119 Correction Number INT 3   — — +
SL03 Sales Ledger SL03120 Fiscal Reference NVARCHAR 50   — — +
SL03 Sales Ledger SL03121 Include in Spesometro Form NVARCHAR 12   — — +
SL03 Sales Ledger SL03122 Reminder Date DATETIME 8   — — +
SL03 Sales Ledger SL03123 PO3 Sub Type NCHAR 2   — — +
SL03 Sales Ledger SL03124 Payment Code NCHAR 3   — — +
SL03 Sales Ledger SL03125 Tax Registration Status NCHAR 1   — — +
SL03 Sales Ledger SL03126 Public Procurement Code1 NVARCHAR 20   — — +
SL03 Sales Ledger SL03127 Public Procurement Code2 NVARCHAR 20   — — +
SL03 Sales Ledger SL03128 Advance/Prepayment Flag NCHAR 2   — — +
SL03 Sales Ledger SL03129 Deducted Advance/Prepayment Amount LCU NUMERIC 20 8 — — +
SL03 Sales Ledger SL03130 Deducted Advance/Prepayment Amount ICU NUMERIC 20 8 — — +
SL03 Sales Ledger SL03131 Own Bank Code 1 NCHAR 2   — — +
SL03 Sales Ledger SL03132 Own Bank Code 2 NCHAR 2   — — +
SL03 Sales Ledger SL03133 Bank Code 1 NVARCHAR 10   — — +
SL03 Sales Ledger SL03134 Bank Account 1 NVARCHAR 34   — — +
SL03 Sales Ledger SL03135 Bank Code 2 NVARCHAR 10   — — +
SL03 Sales Ledger SL03136 Bank Account 2 NVARCHAR 34   — — +
SL03 Sales Ledger SL03137 Tax Registration Date DATETIME 8   — — +
SL03 Sales Ledger SL03138 Tax Registration No NVARCHAR 9   — — +
SL03 Sales Ledger SL03139 Tax Registration Country NCHAR 3   — — +
SL04 Invoice Journal SL04001 Record Counter NUMERIC 9   8   —
SL04 Invoice Journal SL04002 Transaction Number NCHAR 9   6   —
SL04 Invoice Journal SL04003 Line Number NCHAR 7   5   —
SL04 Invoice Journal SL04006 Accounting String NVARCHAR 120   50   —
SL04 Invoice Journal SL04009 Accounting String (Line Currency) NVARCHAR 120   50   —
SL04 Invoice Journal SL04011 Transaction Line Text NVARCHAR 100   25   —
SL04 Invoice Journal SL04013 Invoice Number NVARCHAR 25   23   —
SL04 Invoice Journal SL04024 In Closing Period NCHAR 8   5   —
SL04 Invoice Journal SL04026 Unit Code INT 4   2   —
SL04 Invoice Journal SL04030 PL Reference NCHAR 9   6   —
SL04 Invoice Journal SL04037 Transaction Text (Line Currency) NVARCHAR 100   25   —
SL04 Invoice Journal SL04038 Source Company NCHAR 2   — — +
SL04 Invoice Journal SL04039 Printed By NCHAR 8   — — +
SL04 Invoice Journal SL04040 Date Printed DATETIME 8   — — +
SL04 Invoice Journal SL04041 PrintedStatus NCHAR 1   — — +
SL04 Invoice Journal SL04042 AAS code NVARCHAR 25   — — +
SL05 Payment Journal SL05001 Record Counter NUMERIC 9   8   —
SL05 Payment Journal SL05002 Transact Number NCHAR 9   6   —
SL05 Payment Journal SL05003 Line Number NCHAR 7   5   —
SL05 Payment Journal SL05006 Accounting String NVARCHAR 120   50   —
SL05 Payment Journal SL05009 Accounting String Payment Currency NVARCHAR 120   50   —
SL05 Payment Journal SL05011 Transaction Line Text NVARCHAR 100   25   —
SL05 Payment Journal SL05013 Invoice Number NVARCHAR 25   23   —
SL05 Payment Journal SL05024 In Closing Period NCHAR 8   5   —
SL05 Payment Journal SL05026 Unit Code INT 4   2   —
SL05 Payment Journal SL05030 PL Reference NCHAR 9   6   —
SL05 Payment Journal SL05037 Transaction Text Payment Currency NVARCHAR 100   25   —
SL05 Payment Journal SL05041 Printed By NCHAR 8   — — +
SL05 Payment Journal SL05042 Date Printed DATETIME 8   — — +
SL05 Payment Journal SL05043 PrintedStatus NCHAR 1   — — +
SL05 Payment Journal SL05044 AAS code NVARCHAR 25   — — +
SL05 Payment Journal SL05045 TaxCode NVARCHAR 6   — — +
SL07 Interest Charged SL07002 Invoice Number NVARCHAR 25   15   —
SL07 Interest Charged SL07007 Status Flag NCHAR 1   — — +
SL07 Interest Charged SL07008 Interest Invoice No NVARCHAR 25   — — +
SL07 Interest Charged SL07009 Issuer Code NCHAR 6   — — +
SL08 Sales Ledger Parameters SL08102 Print Tax Code and Base Amount as text INT 1   — — +
SL08 Sales Ledger Parameters SL08103 Type of Sales Transaction INT 1   — — +
SL08 Sales Ledger Parameters SL08104 Default Tax Code NCHAR 6   — — +
SL08 Sales Ledger Parameters SL08105 Tax Note Number NVARCHAR 15   — — +
SL08 Sales Ledger Parameters SL08106 Tax Note Number Flag INT 1   — — +
SL08 Sales Ledger Parameters SL08107 Minimum Amount for FOC Items NUMERIC 20 8 — — +
SL08 Sales Ledger Parameters SL08108 Tax on Interest Flag INT 1   — — +
SL08 Sales Ledger Parameters SL08109 Tax Liability Code for Interest NVARCHAR 6   — — +
SL08 Sales Ledger Parameters SL08110 Default Customer License Flag NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08111 Customer Licensed from DATETIME 8   — — +
SL08 Sales Ledger Parameters SL08112 Customer Licensed to DATETIME 8   — — +
SL08 Sales Ledger Parameters SL08113 Use Daily Based Counter for Tax Notes INT 1   — — +
SL08 Sales Ledger Parameters SL08114 Advance Invoice Amount Apportion Rule INT 1   — — +
SL08 Sales Ledger Parameters SL08115 Use Customer Balance in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08116 Use Order Tax in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08117 Use Additional Costs in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08118 Use Taxes on Additional Costs on Order in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08119 Use Allocated Amount in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08120 Use Taxes on Allocated Amount in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08121 Use Shipped Amount in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08122 Use Taxes on Shipped Amount in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08123 Use Additional Costs on Order (Shipped) in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08124 Use Taxes On Additional Costs on Order (Shipped) in Credit Check NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08125 Tax Mode for Freight NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08126 Maximum Acceptable Credit Control Status INT 2   — — +
SL08 Sales Ledger Parameters SL08127 Multi-Level Credit Control Approval NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08128 Credit Control Approval Group NVARCHAR 8   — — +
SL08 Sales Ledger Parameters SL08129 Credit Limit Boundary INT 1   — — +
SL08 Sales Ledger Parameters SL08130 Overdue Boundary INT 1   — — +
SL08 Sales Ledger Parameters SL08131 Multi-level Approval on Line Level NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08132 Tolerance for Cancel of Approval, Amount NUMERIC 20 8 — — +
SL08 Sales Ledger Parameters SL08133 Tolerance for Cancel of Approval, Percent NUMERIC 6 8 — — +
SL08 Sales Ledger Parameters SL08134 Fixed Level Credit Control Approval Group NVARCHAR 8   — — +
SL08 Sales Ledger Parameters SL08135 Currency Exchange Rate Date NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08136 Default Customer Life Cycle Status INT 1   — — +
SL08 Sales Ledger Parameters SL08137 Late Assignment Of Transaction Number NCHAR 1   — — +
SL08 Sales Ledger Parameters SL08138 Default Invoice Split INT 1   — — +
SL08 Sales Ledger Parameters SL08139 Export code GCC VAT implementing states INT 1   — — +
SL09 Automatic Accounting SL SL09003 Accounting code 1 NCHAR 2   — — +
SL09 Automatic Accounting SL SL09004 Accounting code 2 NCHAR 2   — — +
SL09 Automatic Accounting SL SL09005 Extra code NCHAR 2   — — +
SL10 Payment Ledger SL10003 Transaction Number NVARCHAR 9   6   —
SL10 Payment Ledger SL10009 Accounting String NVARCHAR 120   50   —
SL11 Payment Ledger Proposal SL11002 Invoice Number NVARCHAR 25   15   —
SL11 Payment Ledger Proposal SL11021 InstalmentNumber INT 3   — — +
SL11 Payment Ledger Proposal SL11022 Mandate Reference NVARCHAR 35   — — +
SL11 Payment Ledger Proposal SL11023 Transaction ID NVARCHAR 55   — — +
SL11 Payment Ledger Proposal SL11024 Sequence Type NCHAR 1   — — +
SL11 Payment Ledger Proposal SL11025 Transaction Status NCHAR 2   — — +
SL11 Payment Ledger Proposal SL11026 Reason Code NVARCHAR 8   — — +
SL11 Payment Ledger Proposal SL11027 Reason Info NVARCHAR 60   — — +
SL11 Payment Ledger Proposal SL11028 Payment ID NVARCHAR 40   — — +
SL11 Payment Ledger Proposal SL11029 Cancellation ID NVARCHAR 25   — — +
SL11 Payment Ledger Proposal SL11030 Cancellation Date Time DATETIME 17   — — +
SL11 Payment Ledger Proposal SL11031 PO3 Sub type NCHAR 2   — — +
SL11 Payment Ledger Proposal SL11032 Invoice Currency Code NCHAR 2   — — +
SL12 Customer Payment Proposal Header SL12030 Minimum Accounting Dimensions NVARCHAR 120   50   —
SL12 Customer Payment Proposal Header SL12031 Maximum Accounting Dimensions NVARCHAR 120   50   —
SL12 Customer Payment Proposal Header SL12033 Creditor Bank Code NCHAR 2   — — +
SL12 Customer Payment Proposal Header SL12034 Show PL Balance NCHAR 1   — — +
SL12 Customer Payment Proposal Header SL12035 Payment Currency 2 INT 2   — — +
SL14 Delivery Addresses SL14015 Accounting String NVARCHAR 120   50   —
SL14 Delivery Addresses SL14020 Invoice Issuer Code NCHAR 6   4   —
SL14 Delivery Addresses SL14022 Country Code NVARCHAR 3   — — +
SL14 Delivery Addresses SL14023 Region Code NVARCHAR 10   — — +
SL14 Delivery Addresses SL14024 State/Province Code NVARCHAR 10   — — +
SL14 Delivery Addresses SL14025 County Code NVARCHAR 10   — — +
SL14 Delivery Addresses SL14026 Email Address NVARCHAR 200   — — +
SL14 Delivery Addresses SL14027 Address Line 5 NVARCHAR 35   — — +
SL14 Delivery Addresses SL14028 Address Line 6 NVARCHAR 35   — — +
SL14 Delivery Addresses SL14029 Address Line 7 NVARCHAR 35   — — +
SL14 Delivery Addresses SL14030 Tax Registration No NVARCHAR 20   — — +
SL14 Delivery Addresses SL14031 Delivery Method NCHAR 2   — — +
SL15 Commissions SL15001 Invoice Number NVARCHAR 25   15   —
SL16 Due Commissions SL16002 Invoice Number NVARCHAR 25   15   —
SL17 VAT Transactions SL17001 Invoice Number NVARCHAR 25   15   —
SL17 VAT Transactions SL17010 Transaction Number NVARCHAR 9   6   —
SL17 VAT Transactions SL17012 Order Line plus Subline or CostId NVARCHAR 60   15   —
SL17 VAT Transactions SL17021 Line Number NCHAR 7   5   —
SL17 VAT Transactions SL17031 Tax Exemption Type NCHAR 2   1   —
SL17 VAT Transactions SL17047 InvoiceRefer NVARCHAR 25   — — +
SL17 VAT Transactions SL17048 Original Currency Code NVARCHAR 2   — — +
SL17 VAT Transactions SL17049 Base Amount (Original Currency) NUMERIC 20 8 — — +
SL17 VAT Transactions SL17050 VAT Type NVARCHAR 6   — — +
SL17 VAT Transactions SL17051 Accounting Info NVARCHAR 120   — — +
SL17 VAT Transactions SL17052 Line Ref SL04 NVARCHAR 7   — — +
SL17 VAT Transactions SL17053 Financial Year NVARCHAR 4   — — +
SL17 VAT Transactions SL17054 Ref GL06 NVARCHAR 9   — — +
SL17 VAT Transactions SL17055 Direct from GL NVARCHAR 1   — — +
SL17 VAT Transactions SL17056 Surcharge Tax Code NVARCHAR 6   — — +
SL17 VAT Transactions SL17057 AAS code NVARCHAR 25   — — +
SL17 VAT Transactions SL17058 Order Line Number NCHAR 12   — — +
SL17 VAT Transactions SL17059 Reference to PL Invoice NVARCHAR 25   — — +
SL17 VAT Transactions SL17060 ReferPLSupplier NVARCHAR 10   — — +
SL17 VAT Transactions SL17061 Actual Tax Base NUMERIC 20 8 — — +
SL17 VAT Transactions SL17062 Freight Tax Amount NUMERIC 20 8 — — +
SL17 VAT Transactions SL17063 Destination Rate NUMERIC 8 8 — — +
SL17 VAT Transactions SL17064 Tax Description NVARCHAR 30   — — +
SL17 VAT Transactions SL17065 Invoice Line No NVARCHAR 6   — — +
SL17 VAT Transactions SL17066 Tax Amount OCU NUMERIC 20 8 — — +
SL17 VAT Transactions SL17067 HMRC Period Key NVARCHAR 4   — — +
SL17 VAT Transactions SL17068 Tax Registration Country NCHAR 3   — — +
SL18 Invoice Consolidation SL18003 Invoice Number NVARCHAR 25   15   —
SL18 Invoice Consolidation SL18004 Invoice Reference Number NVARCHAR 25   15   —
SL18 Invoice Consolidation SL18005 Transaction Number NVARCHAR 9   6   —
SL18 Invoice Consolidation SL18014 Accounting String NVARCHAR 120   50   —
SL18 Invoice Consolidation SL18030 OrigPaymTerm NCHAR 2   — — +
SL18 Invoice Consolidation SL18031 ActPaymTerm NCHAR 2   — — +
SL18 Invoice Consolidation SL18032 Delivery Tax Registration No NVARCHAR 20   — — +
SL18 Invoice Consolidation SL18033 Tax Registration Country NCHAR 3   — — +
SL19 Standard Customers SL19006 Reference 1 NVARCHAR 35   20   —
SL19 Standard Customers SL19007 Reference 2 NVARCHAR 35   20   —
SL19 Standard Customers SL19008 Reference 3 NVARCHAR 35   20   —
SL19 Standard Customers SL19009 Reference 4 NVARCHAR 35   20   —
SL19 Standard Customers SL19017 Accounting String NVARCHAR 120   50   —
SL19 Standard Customers SL19021 Tax Registration Number NVARCHAR 20   15   —
SL19 Standard Customers SL19036 Discount Code NVARCHAR 3   2   —
SL19 Standard Customers SL19109 Complete Customer Name NVARCHAR 200   50   —
SL19 Standard Customers SL19141 Invoice Issuer Code NCHAR 6   4   —
SL19 Standard Customers SL19151 Financial Operation Code NVARCHAR 10   1   —
SL19 Standard Customers SL19156 LTM Group NCHAR 6   — — +
SL19 Standard Customers SL19157 Drop Shipment Flag NCHAR 1   — — +
SL19 Standard Customers SL19158 Delivery Note, sort INT 4   — — +
SL19 Standard Customers SL19159 Auto print DN NVARCHAR 1   — — +
SL19 Standard Customers SL19160 Auto send DN NVARCHAR 1   — — +
SL19 Standard Customers SL19161 Need back-order NCHAR 1   — — +
SL19 Standard Customers SL19162 Delivery note printing INT 1   — — +
SL19 Standard Customers SL19163 Invoice printing INT 1   — — +
SL19 Standard Customers SL19164 TaxIDType NCHAR 2   — — +
SL19 Standard Customers SL19165 ResponsibilityType NCHAR 2   — — +
SL19 Standard Customers SL19166 Harbour NVARCHAR 4   — — +
SL19 Standard Customers SL19167 Bundesland NVARCHAR 2   — — +
SL19 Standard Customers SL19168 StatManner NVARCHAR 6   — — +
SL19 Standard Customers SL19169 CurrIdentNumber NVARCHAR 2   — — +
SL19 Standard Customers SL19170 ECDepartment NVARCHAR 2   — — +
SL19 Standard Customers SL19171 Regime NVARCHAR 2   — — +
SL19 Standard Customers SL19172 Auto print Invoice NVARCHAR 1   — — +
SL19 Standard Customers SL19173 Auto send Invoice NVARCHAR 1   — — +
SL19 Standard Customers SL19174 Fix Payment Day 1 INT 2   — — +
SL19 Standard Customers SL19175 Fix Payment Day 2 INT 2   — — +
SL19 Standard Customers SL19176 Fix Payment Day 3 INT 2   — — +
SL19 Standard Customers SL19177 Paymnt Exclud Month INT 2   — — +
SL19 Standard Customers SL19178 Release For DN NVARCHAR 1   — — +
SL19 Standard Customers SL19179 Extended Commission Code NCHAR 2   — — +
SL19 Standard Customers SL19180 Tax Type NVARCHAR 6   — — +
SL19 Standard Customers SL19181 Tax Surcharge NCHAR 1   — — +
SL19 Standard Customers SL19182 Merge RIBA NCHAR 1   — — +
SL19 Standard Customers SL19183 Payment Address Code NVARCHAR 2   — — +
SL19 Standard Customers SL19184 Invoice Address Code NVARCHAR 2   — — +
SL19 Standard Customers SL19185 Invoice Sent Address Code NVARCHAR 2   — — +
SL19 Standard Customers SL19186 Excise Control Code NVARCHAR 25   — — +
SL19 Standard Customers SL19187 Excise Registration Number NVARCHAR 25   — — +
SL19 Standard Customers SL19188 Excise Division NVARCHAR 25   — — +
SL19 Standard Customers SL19189 DA for Consolidated Sales Orders NVARCHAR 2   — — +
SL19 Standard Customers SL19190 Region Code NVARCHAR 10   — — +
SL19 Standard Customers SL19191 State/Province Code NVARCHAR 10   — — +
SL19 Standard Customers SL19192 County Code NVARCHAR 10   — — +
SL19 Standard Customers SL19193 Email address NVARCHAR 200   — — +
SL19 Standard Customers SL19194 Address Line 5 NVARCHAR 35   — — +
SL19 Standard Customers SL19195 Address Line 6 NVARCHAR 35   — — +
SL19 Standard Customers SL19196 Address Line 7 NVARCHAR 35   — — +
SL19 Standard Customers SL19197 Consolidation Mode for Lease Contracts NVARCHAR 1   — — +
SL19 Standard Customers SL19198 Ext. User defined field 1 NVARCHAR 150   — — +
SL19 Standard Customers SL19199 Ext. User defined field 2 NVARCHAR 150   — — +
SL19 Standard Customers SL19200 Ext. User defined field 3 NVARCHAR 150   — — +
SL19 Standard Customers SL19201 Ext. User defined field 4 NVARCHAR 150   — — +
SL19 Standard Customers SL19202 Ext. User defined field 5 NVARCHAR 150   — — +
SL19 Standard Customers SL19203 Ext. User defined field 6 NVARCHAR 150   — — +
SL19 Standard Customers SL19204 Ext. User defined field 7 NVARCHAR 150   — — +
SL19 Standard Customers SL19205 Ext. User defined field 8 NVARCHAR 150   — — +
SL19 Standard Customers SL19206 Ext. User defined field 9 NVARCHAR 150   — — +
SL19 Standard Customers SL19207 Ext. User defined field 10 NVARCHAR 150   — — +
SL19 Standard Customers SL19208 Ext. User defined field 11 NVARCHAR 150   — — +
SL19 Standard Customers SL19209 Ext. User defined field 12 NVARCHAR 150   — — +
SL19 Standard Customers SL19210 Ext. User defined field 13 NVARCHAR 150   — — +
SL19 Standard Customers SL19211 Ext. User defined field 14 NVARCHAR 150   — — +
SL19 Standard Customers SL19212 Ext. User defined field 15 NVARCHAR 150   — — +
SL19 Standard Customers SL19213 Ext. User defined field 16 NVARCHAR 150   — — +
SL19 Standard Customers SL19214 Ext. User defined field 17 NVARCHAR 150   — — +
SL19 Standard Customers SL19215 Ext. User defined field 18 NVARCHAR 150   — — +
SL19 Standard Customers SL19216 Ext. User defined field 19 NVARCHAR 150   — — +
SL19 Standard Customers SL19217 Ext. User defined field 20 NVARCHAR 150   — — +
SL19 Standard Customers SL19218 Partial Delivery Planning NVARCHAR 1   — — +
SL19 Standard Customers SL19219 License Flag NCHAR 1   — — +
SL19 Standard Customers SL19220 Licensed From DATETIME 8   — — +
SL19 Standard Customers SL19221 Licensed To DATETIME 8   — — +
SL19 Standard Customers SL19222 Partial delivery on credit check NCHAR 1   — — +
SL19 Standard Customers SL19223 Taxes on Ordered Not Shipped amount (LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19224 Additional costs on order (LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19225 Taxes on additional order costs (LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19226 Allocated not shipped amount (LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19227 Taxes on allocated not shipped amount (LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19228 Taxes on shipped not invoiced amount (LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19229 Additional costs on order (shipped; LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19230 Taxes on additional costs on order (shipped; LCU) NUMERIC 20 8 — — +
SL19 Standard Customers SL19231 Longitude NUMERIC 28 8 — — +
SL19 Standard Customers SL19232 Latitude NUMERIC 28 8 — — +
SL19 Standard Customers SL19233 Altitude NUMERIC 28 8 — — +
SL19 Standard Customers SL19234 Prepayments for Credit Check NUMERIC 20 8 — — +
SL19 Standard Customers SL19235 External ID NVARCHAR 36   — — +
SL19 Standard Customers SL19236 SUFARMA NVARCHAR 10   — — +
SL19 Standard Customers SL19237 Special ICMS regime – Brazil NVARCHAR 50   — — +
SL19 Standard Customers SL19238 Spare (Brazil) NCHAR 1   — — +
SL19 Standard Customers SL19239 Spesometro Forms NVARCHAR 12   — — +
SL19 Standard Customers SL19240 Postal Giro A/C NVARCHAR 15   — — +
SL19 Standard Customers SL19241 Bank Giro A/C NVARCHAR 15   — — +
SL19 Standard Customers SL19242 Credit Pay Way NCHAR 2   — — +
SL19 Standard Customers SL19243 PO3 Sub type NCHAR 2   — — +
SL19 Standard Customers SL19244 SWIFT Address NVARCHAR 12   — — +
SL19 Standard Customers SL19245 WH Taxes On Ordered Not Shipped LCU NUMERIC 20 8 — — +
SL19 Standard Customers SL19246 WH Taxes On Add Order Costs LCU NUMERIC 20 8 — — +
SL19 Standard Customers SL19247 WH Taxes On Alloc Not Shipped LCU NUMERIC 20 8 — — +
SL19 Standard Customers SL19248 WH Taxes On Shipped Not Invoiced LCU NUMERIC 20 8 — — +
SL19 Standard Customers SL19249 WH Taxes On Add Shipped Costs LCU NUMERIC 20 8 — — +
SL19 Standard Customers SL19250 Overdue tolerance period INT 3   — — +
SL19 Standard Customers SL19251 Overdue total tolerance amount NUMERIC 20 8 — — +
SL19 Standard Customers SL19252 Overdue invoice tolerance amount NUMERIC 20 8 — — +
SL19 Standard Customers SL19253 Credit control status INT 2   — — +
SL19 Standard Customers SL19254 Tax Reason Code NCHAR 3   — — +
SL19 Standard Customers SL19255 Split Payments NCHAR 1   — — +
SL19 Standard Customers SL19256 Bank Code 2 NVARCHAR 10   — — +
SL19 Standard Customers SL19257 Bank Account 2 NVARCHAR 34   — — +
SL19 Standard Customers SL19258 Block New Orders NCHAR 1   — — +
SL19 Standard Customers SL19259 Anonymized NCHAR 1   — — +
SL21 Sales Ledger Payments SL21002 Invoice Number NVARCHAR 25   15   —
SL21 Sales Ledger Payments SL21003 Line Number NVARCHAR 6   2   —
SL21 Sales Ledger Payments SL21004 Transaction Number NVARCHAR 9   6   —
SL21 Sales Ledger Payments SL21010 Check Number NVARCHAR 25   15   —
SL21 Sales Ledger Payments SL21028 Receipt number NVARCHAR 15   — — +
SL21 Sales Ledger Payments SL21029 Issuer code NVARCHAR 6   — — +
SL21 Sales Ledger Payments SL21030 Form number NVARCHAR 8   — — +
SL21 Sales Ledger Payments SL21031 InstalmentNumber INT 3   — — +
SL21 Sales Ledger Payments SL21032 Lock Payments Invoices INT 1   — — +
SL21 Sales Ledger Payments SL21033 Reconciled NCHAR 1   — — +
SL21 Sales Ledger Payments SL21034 Remittance Link NVARCHAR 38   — — +
SL21 Sales Ledger Payments SL21035 Prepayment Link NVARCHAR 25   — — +
SL21 Sales Ledger Payments SL21036 Link Type NCHAR 1   — — +
SL21 Sales Ledger Payments SL21037 Voiding Status NCHAR 1   — — +
SL21 Sales Ledger Payments SL21038 Accounting String NVARCHAR 120   — — +
SL21 Sales Ledger Payments SL21039 AAS Reference NVARCHAR 25   — — +
SL21 Sales Ledger Payments SL21040 Payment Type NCHAR 1   — — +
SL21 Sales Ledger Payments SL21041 Accounting String AR NVARCHAR 120   — — +
SL22 Payment Terms SL SL22020 Multiply Payment Periods NVARCHAR 2   — — +
SL22 Payment Terms SL SL22021 Day of Period NVARCHAR 2   — — +
SL22 Payment Terms SL SL22022 AmountBasis NUMERIC 20 8 — — +
SL22 Payment Terms SL SL22023 AltPaymentTerm NVARCHAR 2   — — +
SL22 Payment Terms SL SL22024 Instalments NCHAR 1   — — +
SL22 Payment Terms SL SL22025 FixedPaymDays NVARCHAR 1   — — +
SL22 Payment Terms SL SL22026 FixedPaymentDay NVARCHAR 2   — — +
SL22 Payment Terms SL SL22027 WayOfPayment NVARCHAR 2   — — +
SL22 Payment Terms SL SL22028 DueDateDefinition INT 1   — — +
SL22 Payment Terms SL SL22029 Statistical factor NUMERIC 12 8 — — +
SL22 Payment Terms SL SL22030 Deposit Account NVARCHAR 12   — — +
SL22 Payment Terms SL SL22031 Month excluded 1 INT 2   — — +
SL22 Payment Terms SL SL22032 Month excluded 2 INT 2   — — +
SL22 Payment Terms SL SL22033 Fixed Payment Day for excluded month INT 2   — — +
SL22 Payment Terms SL SL22034 Min Coin Rounding NCHAR 1   — — +
SL22 Payment Terms SL SL22035 Credit Note Payment Term NVARCHAR 2   — — +
SL22 Payment Terms SL SL22036 Invoice Cash Discount Switch NCHAR 1   — — +
SL22 Payment Terms SL SL22037 Box Transport documents (00-99) NVARCHAR 100   — — +
SL22 Payment Terms SL SL22038 No Payment NCHAR 1   — — +
SL22 Payment Terms SL SL22039 Cash Payment Flag NCHAR 1   — — +
SL22 Payment Terms SL SL22040 Spare NCHAR 2   — — +
SL22 Payment Terms SL SL22041 PO3 Sub type NCHAR 2   — — +
SL24 Sales Statement Tax Variance SL24012 Output Tax Account NVARCHAR 120   50   —
SL24 Sales Statement Tax Variance SL24013 Input Tax Account NVARCHAR 120   50   —
SL25 Sales Statement Proposal SL25052 Tax Variance Account NVARCHAR 120   50   —
SL26 Sales Statement Proposal References SL26008 Invoice Number NVARCHAR 25   15   —
SL28 Billing Proposal Header SL28011 Minimum Invoice Number NVARCHAR 25   15   —
SL28 Billing Proposal Header SL28012 Maximum Invoice Number NVARCHAR 25   15   —
SL28 Billing Proposal Header SL28015 Accounting String Minimum NVARCHAR 120   50   —
SL28 Billing Proposal Header SL28016 Accounting String Maximum NVARCHAR 120   50   —
SL29 Invoice Consolidation History SL29003 Invoice Number NCHAR 25   15   —
SL29 Invoice Consolidation History SL29004 Invoice Reference Number NCHAR 25   15   —
SL29 Invoice Consolidation History SL29005 Transaction Number NCHAR 9   6   —
SL29 Invoice Consolidation History SL29014 Accounting String NVARCHAR 120   50   —
SL29 Invoice Consolidation History SL29029 LiabilityCode NCHAR 6   — — +
SL29 Invoice Consolidation History SL29030 OrigPaymTerm NCHAR 2   — — +
SL29 Invoice Consolidation History SL29031 ActPaymTerm NCHAR 2   — — +
SL29 Invoice Consolidation History SL29032 Delivery Tax Registration No NVARCHAR 20   — — +
SL29 Invoice Consolidation History SL29033 Tax Registration Country NCHAR 3   — — +
SL30 Tax details for Payments SL30001 InvoiceNo NVARCHAR 25   15   —
SL30 Tax details for Payments SL30010 TransactioNo NVARCHAR 9   6   —
SL30 Tax details for Payments SL30012 InvoiceNoOld NVARCHAR 25   15   —
SL30 Tax details for Payments SL30021 TransactLineNo NCHAR 7   5   —
SL30 Tax details for Payments SL30047 InvoiceRefer NVARCHAR 25   — — +
SL31 Prepayment Allocation Lines SL31007 Invoice Number Payment NVARCHAR 25   15   —
SL31 Prepayment Allocation Lines SL31010 Invoice Number NVARCHAR 25   15   —
SL31 Prepayment Allocation Lines SL31019 Issuer Code NCHAR 6   — — +
SL31 Prepayment Allocation Lines SL31020 Tax note number NVARCHAR 25   — — +
SL31 Prepayment Allocation Lines SL31021 Sales Invoice No NVARCHAR 25   — — +
SL31 Prepayment Allocation Lines SL31022 Object Value NUMERIC 20 8 — — +
SL31 Prepayment Allocation Lines SL31023 Order Currency Code INT 2   — — +
SL31 Prepayment Allocation Lines SL31024 OCU Exchange Rate 1 NUMERIC 10 8 — — +
SL31 Prepayment Allocation Lines SL31025 OCU Exchange Algorithm NCHAR 3   — — +
SL31 Prepayment Allocation Lines SL31026 OCU Exchange Rate 2 NUMERIC 10 8 — — +
SL31 Prepayment Allocation Lines SL31027 ICU Exchange Rate 1 NUMERIC 10 8 — — +
SL31 Prepayment Allocation Lines SL31028 ICU Exchange Algorithm NCHAR 3   — — +
SL31 Prepayment Allocation Lines SL31029 ICU Exchange Rate 2 NUMERIC 10 8 — — +
SL31 Prepayment Allocation Lines SL31030 Invoice Currency Code INT 2   — — +
SL31 Prepayment Allocation Lines SL31031 Tax Registration Date DATETIME 8   — — +
SL32 Prepayment Tax Base Lines SL32011 LineType NVARCHAR 6   — — +
SL32 Prepayment Tax Base Lines SL32012 InvoiceNoPayment NVARCHAR 25   — — +
SL32 Prepayment Tax Base Lines SL32013 OrderLineNo NCHAR 6   — — +
SL32 Prepayment Tax Base Lines SL32014 Tax Base Gross ICU NUMERIC 20 8 — — +
SL32 Prepayment Tax Base Lines SL32015 Tax Base Net ICU NUMERIC 20 8 — — +
SL32 Prepayment Tax Base Lines SL32016 Tax Amount ICU NUMERIC 20 8 — — +
SL32 Prepayment Tax Base Lines SL32017 Tax Base Gross LCU NUMERIC 20 8 — — +
SL32 Prepayment Tax Base Lines SL32018 Tax Base Net LCU NUMERIC 20 8 — — +
SL32 Prepayment Tax Base Lines SL32019 Tax Amount LCU NUMERIC 20 8 — — +
SL32 Prepayment Tax Base Lines SL32020 Tax Liability NCHAR 6   — — +
SL32 Prepayment Tax Base Lines SL32021 Line Discount ICU NUMERIC 20 8 — — +
SL33 Prepayment Tax Details SL33010 Line Type NVARCHAR 6   — — +
SL33 Prepayment Tax Details SL33011 Tax Base OCU NUMERIC 20 8 — — +
SL33 Prepayment Tax Details SL33012 Tax Amount OCU NUMERIC 20 8 — — +
SL34 Prepayment Deductions SL34006 Invoice Number NVARCHAR 25   15   —
SL34 Prepayment Deductions SL34009 Deducted Amount PCU NUMERIC 20 8 — — +
SL34 Prepayment Deductions SL34010 Deducted Tax Amount PCU NUMERIC 20 8 — — +
SL34 Prepayment Deductions SL34011 Deducted Amount LCU NUMERIC 20 8 — — +
SL34 Prepayment Deductions SL34012 Deducted Tax Amount LCU NUMERIC 20 8 — — +
SL35 Multiply Payment Periods SL35001 Payment Term NVARCHAR 2   — — +
SL35 Multiply Payment Periods SL35002 Period No INT 2   — — +
SL35 Multiply Payment Periods SL35003 Partial Payment % NUMERIC 12 8 — — +
SL35 Multiply Payment Periods SL35004 Due Date INT 4   — — +
SL35 Multiply Payment Periods SL35005 Day Cash Discount 1 NVARCHAR 3   — — +
SL35 Multiply Payment Periods SL35006 Cash Discount 1 NVARCHAR 6   — — +
SL35 Multiply Payment Periods SL35007 Day Cash Discount 2 NVARCHAR 3   — — +
SL35 Multiply Payment Periods SL35008 Cash Discount 2 NVARCHAR 6   — — +
SL35 Multiply Payment Periods SL35009 Day Cash Discount 3 NVARCHAR 3   — — +
SL35 Multiply Payment Periods SL35010 Cash Discount 3 NVARCHAR 6   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36001 Object Type NCHAR 2   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36002 Object No NVARCHAR 15   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36003 Sub Project Code NCHAR 6   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36004 Line No NCHAR 6   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36005 Struct Line No NCHAR 6   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36006 Invoice No NCHAR 25   — — +
SL36 Link Prepayment/Advance Invoices to SO SL36007 Qty Invoiced NUMERIC 12 8 — — +
SL39 Delivery Tax Allocation Lines SL39001 ObjectType NVARCHAR 4   — — +
SL39 Delivery Tax Allocation Lines SL39002 ObjectNumber NVARCHAR 15   — — +
SL39 Delivery Tax Allocation Lines SL39003 Sub-ProjectCode NVARCHAR 6   — — +
SL39 Delivery Tax Allocation Lines SL39004 LineType NVARCHAR 6   — — +
SL39 Delivery Tax Allocation Lines SL39005 LineNo NVARCHAR 6   — — +
SL39 Delivery Tax Allocation Lines SL39006 StructLineNo NVARCHAR 6   — — +
SL39 Delivery Tax Allocation Lines SL39007 AutoSubStringNo NVARCHAR 4   — — +
SL39 Delivery Tax Allocation Lines SL39008 InvoiceNo NVARCHAR 25   — — +
SL39 Delivery Tax Allocation Lines SL39009 DeliveredQty NUMERIC 12 8 — — +
SL39 Delivery Tax Allocation Lines SL39010 ShipmentDate DATETIME 8   — — +
SL39 Delivery Tax Allocation Lines SL39011 DeliveryDate DATETIME 8   — — +
SL39 Delivery Tax Allocation Lines SL39012 TaxCode NVARCHAR 6   — — +
SL39 Delivery Tax Allocation Lines SL39013 TaxRegDate DATETIME 8   — — +
SL39 Delivery Tax Allocation Lines SL39014 TaxRegStatus NCHAR 1   — — +
SL39 Delivery Tax Allocation Lines SL39015 TaxBaseOCU NUMERIC 20 8 — — +
SL39 Delivery Tax Allocation Lines SL39016 TaxBaseLCU NUMERIC 20 8 — — +
SL39 Delivery Tax Allocation Lines SL39017 TaxAmountOCU NUMERIC 20 8 — — +
SL39 Delivery Tax Allocation Lines SL39018 TaxAmountLCU NUMERIC 20 8 — — +
SL39 Delivery Tax Allocation Lines SL39019 Delivery Note Number NVARCHAR 20   — — +
SL39 Delivery Tax Allocation Lines SL39020 Delivery Confirmation NCHAR 1   — — +
SL39 Delivery Tax Allocation Lines SL39021 Customer Code NVARCHAR 10   — — +
SL39 Delivery Tax Allocation Lines SL39022 Invoice Interval From Date DATETIME 8   — — +
SL39 Delivery Tax Allocation Lines SL39023 Invoice Interval To Date DATETIME 8   — — +
SL40 Payment Methods SL40001 PaymentMethodCode NCHAR 2   — — +
SL40 Payment Methods SL40002 PaymentMethodName NVARCHAR 50   — — +
SL40 Payment Methods SL40003 DLLName NVARCHAR 45   — — +
SL40 Payment Methods SL40004 AASPosition NCHAR 3   — — +
SL40 Payment Methods SL40005 Local/Foreign NCHAR 2   — — +
SL40 Payment Methods SL40006 ChequePayment NCHAR 2   — — +
SL40 Payment Methods SL40007 ActivationFlag NCHAR 1   — — +
SL40 Payment Methods SL40008 TypeofUsage NCHAR 1   — — +
SL40 Payment Methods SL40009 DocUpdateFlag NCHAR 1   — — +
SL40 Payment Methods SL40010 FileUpdateFlag NCHAR 1   — — +
SL40 Payment Methods SL40011 OutstandingItem NCHAR 1   — — +
SL40 Payment Methods SL40012 ElectrCommunFlag NCHAR 1   — — +
SL40 Payment Methods SL40013 EuroCurrencyCode NCHAR 2   — — +
SL45 Extended Bank Info SL45001 Customer Code NCHAR 10   — — +
SL45 Extended Bank Info SL45002 Bank Code NCHAR 2   — — +
SL45 Extended Bank Info SL45003 Bank Name NVARCHAR 35   — — +
SL45 Extended Bank Info SL45004 External Bank Code NVARCHAR 11   — — +
SL45 Extended Bank Info SL45005 Account Number NCHAR 34   — — +
SL45 Extended Bank Info SL45006 Address Line 1 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45007 Address Line 2 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45008 Address Line 3 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45009 Address Line 4 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45010 Post Code NVARCHAR 10   — — +
SL45 Extended Bank Info SL45011 Telephone Number NVARCHAR 20   — — +
SL45 Extended Bank Info SL45012 Telefax NVARCHAR 20   — — +
SL45 Extended Bank Info SL45013 Correspondent Bank Name NVARCHAR 35   — — +
SL45 Extended Bank Info SL45014 Correspondent External Bank Code NVARCHAR 10   — — +
SL45 Extended Bank Info SL45015 Correspondent Account Number NVARCHAR 34   — — +
SL45 Extended Bank Info SL45016 Correspondent Address Line 1 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45017 Correspondent Address Line 2 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45018 Correspondent Address Line 3 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45019 Correspondent Address Line 4 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45020 Payment Priority NCHAR 1   — — +
SL45 Extended Bank Info SL45021 Address Line 5 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45022 Address Line 6 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45023 Address Line 7 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45024 Correspondent Address Line 5 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45025 Correspondent Address Line 6 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45026 Correspondent Address Line 7 NVARCHAR 35   — — +
SL45 Extended Bank Info SL45027 Country Code NCHAR 3   — — +
SL45 Extended Bank Info SL45028 Correspondent Country Code NCHAR 3   — — +
SL45 Extended Bank Info SL45029 BIC NVARCHAR 15   — — +
SL45 Extended Bank Info SL45030 Correspondent BIC NVARCHAR 15   — — +
SL45 Extended Bank Info SL45031 Bank Account Type NCHAR 1   — — +
SL45 Extended Bank Info SL45032 Default Code NCHAR 1   — — +
SL45 Extended Bank Info SL45033 Tax/vat Payment Currency — Invoice Point INT 2   — — +
SL45 Extended Bank Info SL45034 Tax/vat Payment Currency — Payment Point INT 2   — — +
SL45 Extended Bank Info SL45035 GL tax/vat payment account NVARCHAR 12   — — +
SL46 Invoice Template Header SL46001 Version INT 4   — — +
SL46 Invoice Template Header SL46002 Locked NCHAR 1   — — +
SL46 Invoice Template Header SL46003 Created User ID NCHAR 8   — — +
SL46 Invoice Template Header SL46004 Created Time Stamp DATETIME 17   — — +
SL46 Invoice Template Header SL46005 Locked User ID NCHAR 8   — — +
SL46 Invoice Template Header SL46006 Locked Time Stamp DATETIME 17   — — +
SL47 Invoice Template Lines SL47001 Version INT 4   — — +
SL47 Invoice Template Lines SL47002 Source Module NCHAR 2   — — +
SL47 Invoice Template Lines SL47003 Target Table INT 2   — — +
SL47 Invoice Template Lines SL47004 Target Field NCHAR 7   — — +
SL47 Invoice Template Lines SL47005 Source Table NCHAR 4   — — +
SL47 Invoice Template Lines SL47006 Source Field NVARCHAR 20   — — +
SL47 Invoice Template Lines SL47007 UDDB NVARCHAR 20   — — +
SL48 Invoice Template Field definitions SL48001 Version INT 4   — — +
SL48 Invoice Template Field definitions SL48002 Target Table INT 2   — — +
SL48 Invoice Template Field definitions SL48003 Target Field NCHAR 7   — — +
SL48 Invoice Template Field definitions SL48004 Label NVARCHAR 50   — — +
SL48 Invoice Template Field definitions SL48005 Field Type INT 4   — — +
SL48 Invoice Template Field definitions SL48006 Field Length INT 4   — — +
SL48 Invoice Template Field definitions SL48007 Number Of Decimals INT 4   — — +
SL61 Reminder Proposal SL61001 Customer Code NCHAR 10   — — +
SL61 Reminder Proposal SL61002 Invoice No NCHAR 15   — — +
SL97 Work File for Ledger Statement SL97004 TransactioNo NVARCHAR 9   6   —
SL97 Work File for Ledger Statement SL97005 InvoiceNo NVARCHAR 25   15   —
SLA1 SL account exceptions SLA1001 Account NVARCHAR 25   — — +
SLA1 SL account exceptions SLA1002 Exception mark NCHAR 1   — — +
SLB1 Bank Note Records SLB1001 Module Type NVARCHAR 2   — — +
SLB1 Bank Note Records SLB1002 Invoice No NVARCHAR 25   — — +
SLB1 Bank Note Records SLB1003 Installment No NVARCHAR 3   — — +
SLB1 Bank Note Records SLB1004 Bank Note No NVARCHAR 20   — — +
SLB1 Bank Note Records SLB1005 Order No NVARCHAR 10   — — +
SLB1 Bank Note Records SLB1006 Bank Note Date DATETIME 8   — — +
SLB1 Bank Note Records SLB1007 Inv Curr Code INT 2   — — +
SLB1 Bank Note Records SLB1008 Inv Amnt LCU NUMERIC 20 8 — — +
SLB1 Bank Note Records SLB1009 Inv Amnt ICU NUMERIC 20 8 — — +
SLB1 Bank Note Records SLB1010 Cash Discount NVARCHAR 6   — — +
SLB1 Bank Note Records SLB1011 Cash Disc Date DATETIME 8   — — +
SLB1 Bank Note Records SLB1012 Intrst Per Day ICU NUMERIC 20 8 — — +
SLB1 Bank Note Records SLB1013 InterestTxt NVARCHAR 50   — — +
SLB1 Bank Note Records SLB1014 Bank Note Status NCHAR 1   — — +
SLB4 Tax Note Description SLB4001 CustomerCode NVARCHAR 10   — — +
SLB4 Tax Note Description SLB4002 InvoiceNo NVARCHAR 25   — — +
SLB4 Tax Note Description SLB4003 SortOrder INT 3   — — +
SLB4 Tax Note Description SLB4004 TNDescriptionTxt NVARCHAR 80   — — +
SLB4 Tax Note Description SLB4005 Tax Note Registration Date DATETIME 8   — — +
SLB4 Tax Note Description SLB4006 Tax Note Number NVARCHAR 25   — — +
SLB4 Tax Note Description SLB4007 Spare NVARCHAR 6   — — +
SLB4 Tax Note Description SLB4008 Spare NVARCHAR 35   — — +
SLB4 Tax Note Description SLB4009 Spare NUMERIC 12 8 — — +
SLB4 Tax Note Description SLB4010 Spare NUMERIC 20 8 — — +
SLB4 Tax Note Description SLB4011 Spare INT 4   — — +
SLB5 Tax Note lines details SLB5001 Customer Code NCHAR 10   — — +
SLB5 Tax Note lines details SLB5002 Tax Note Number NVARCHAR 25   — — +
SLB5 Tax Note lines details SLB5003 Tax Note Registration Date DATETIME 8   — — +
SLB5 Tax Note lines details SLB5004 Sales Order Number NCHAR 10   — — +
SLB5 Tax Note lines details SLB5005 Sales Order Line Number NCHAR 6   — — +
SLB5 Tax Note lines details SLB5006 Sales Order Sub Line Number NCHAR 6   — — +
SLB5 Tax Note lines details SLB5007 Tax Code NCHAR 6   — — +
SLB5 Tax Note lines details SLB5008 Sales Order Line Stock Code NVARCHAR 35   — — +
SLB5 Tax Note lines details SLB5009 Sales Order Line Quantity NUMERIC 12 8 — — +
SLB5 Tax Note lines details SLB5010 Sales Order Line Unit Price NUMERIC 20 8 — — +
SLB5 Tax Note lines details SLB5011 Sales Order Line Unit Code INT 4   — — +
SLB5 Tax Note lines details SLB5012 Deducted Quantity of delivered goods NUMERIC 12 8 — — +
SLB5 Tax Note lines details SLB5013 ObjectType NCHAR 4   — — +
SLB5 Tax Note lines details SLB5014 LineType NCHAR 6   — — +
SLC1 Credit Check permission levels SLC1001 Currency Code INT 2   — — +
SLC1 Credit Check permission levels SLC1002 Level 01 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1003 Level 02 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1004 Level 03 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1005 Level 04 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1006 Level 05 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1007 Level 06 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1008 Level 07 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1009 Level 08 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1010 Level 09 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1011 Level 10 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1012 Overdue level 1 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1013 Overdue level 1 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1014 Overdue level 3 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1015 Overdue level 4 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1016 Overdue level 5 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1017 Overdue level 6 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1018 Overdue level 7 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1019 Overdue level 8 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1020 Overdue level 9 NUMERIC 20 8 — — +
SLC1 Credit Check permission levels SLC1021 Overdue level 10 NUMERIC 20 8 — — +
SLCM Approval Matrix SLCM001 Rule NCHAR 2   — — +
SLCM Approval Matrix SLCM002 Line ID NCHAR 2   — — +
SLCM Approval Matrix SLCM003 Condition Type INT 2   — — +
SLCM Approval Matrix SLCM004 Parameter 1 NUMERIC 20 8 — — +
SLCM Approval Matrix SLCM005 Parameter 2 INT 10   — — +
SLCM Approval Matrix SLCM006 Parameter 3 NVARCHAR 50   — — +
SLCM Approval Matrix SLCM007 Parameter 4 DATETIME 8   — — +
SLCM Approval Matrix SLCM008 Level INT 1   — — +
SLCS Credit Control Status Configuration SLCS001 Line Number INT 2   — — +
SLCS Credit Control Status Configuration SLCS002 Credit Control Status INT 2   — — +
SLCS Credit Control Status Configuration SLCS003 Condition Type NCHAR 2   — — +
SLCS Credit Control Status Configuration SLCS004 Parameter 1 NUMERIC 20 8 — — +
SLCS Credit Control Status Configuration SLCS005 Spare NVARCHAR 35   — — +
SLD1 Payment Ledger Proposal History SLD1001 Customer Code NVARCHAR 10   — — +
SLD1 Payment Ledger Proposal History SLD1002 Invoice No NVARCHAR 25   — — +
SLD1 Payment Ledger Proposal History SLD1003 Transfer Blocked NCHAR 1   — — +
SLD1 Payment Ledger Proposal History SLD1004 Transfer Amount (Local Currency) NUMERIC 20 8 — — +
SLD1 Payment Ledger Proposal History SLD1005 Discount (Local Currency) NVARCHAR 20   — — +
SLD1 Payment Ledger Proposal History SLD1006 Calculated Due Date DATETIME 8   — — +
SLD1 Payment Ledger Proposal History SLD1007 Way Of Payment NCHAR 2   — — +
SLD1 Payment Ledger Proposal History SLD1008 Amount Paid (Payment Currency) NUMERIC 20 8 — — +
SLD1 Payment Ledger Proposal History SLD1009 Discount (Payment Currency) NUMERIC 20 8 — — +
SLD1 Payment Ledger Proposal History SLD1010 Currency Code Payment INT 2   — — +
SLD1 Payment Ledger Proposal History SLD1011 Exchange Rate 1 NUMERIC 10 8 — — +
SLD1 Payment Ledger Proposal History SLD1012 Exchange Rate 2 NUMERIC 10 8 — — +
SLD1 Payment Ledger Proposal History SLD1013 Exchange Algorithm NCHAR 3   — — +
SLD1 Payment Ledger Proposal History SLD1014 Payment Proposal Number NVARCHAR 6   — — +
SLD1 Payment Ledger Proposal History SLD1015 Owner NVARCHAR 8   — — +
SLD1 Payment Ledger Proposal History SLD1016 Payment Note Number NVARCHAR 6   — — +
SLD1 Payment Ledger Proposal History SLD1017 Date Updated DATETIME 8   — — +
SLD1 Payment Ledger Proposal History SLD1018 Date Note Printed DATETIME 8   — — +
SLD1 Payment Ledger Proposal History SLD1019 IBAN Code NVARCHAR 28   — — +
SLD1 Payment Ledger Proposal History SLD1020 Withholding Tax NUMERIC 20 8 — — +
SLD1 Payment Ledger Proposal History SLD1021 Instalment Number INT 3   — — +
SLD1 Payment Ledger Proposal History SLD1022 Mandate Reference NVARCHAR 35   — — +
SLD1 Payment Ledger Proposal History SLD1023 Transaction ID NVARCHAR 55   — — +
SLD1 Payment Ledger Proposal History SLD1024 Sequence Type NCHAR 1   — — +
SLD1 Payment Ledger Proposal History SLD1025 Transaction Status NCHAR 2   — — +
SLD1 Payment Ledger Proposal History SLD1026 Reason Code NVARCHAR 8   — — +
SLD1 Payment Ledger Proposal History SLD1027 Reason Info NVARCHAR 60   — — +
SLD1 Payment Ledger Proposal History SLD1028 Payment ID NVARCHAR 40   — — +
SLD1 Payment Ledger Proposal History SLD1029 Cancellation ID NVARCHAR 25   — — +
SLD1 Payment Ledger Proposal History SLD1030 Cancellation Date Time DATETIME 17   — — +
SLD1 Payment Ledger Proposal History SLD1031 PO3 Sub type NCHAR 2   — — +
SLD1 Payment Ledger Proposal History SLD1032 Invoice Currency Code NCHAR 2   — — +
SLD2 Customer Payment Proposal Header History SLD2001 Payment Proposal Number NVARCHAR 6   — — +
SLD2 Customer Payment Proposal Header History SLD2002 Owner NVARCHAR 8   — — +
SLD2 Customer Payment Proposal Header History SLD2003 Transfer Amount (Local Currency) NUMERIC 20 8 — — +
SLD2 Customer Payment Proposal Header History SLD2004 Discount (Local Currency) NUMERIC 20 8 — — +
SLD2 Customer Payment Proposal Header History SLD2005 Date Created DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2006 Date Approved DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2007 Date First Printed DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2008 Date Re-printed DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2009 Last Collection Date DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2010 Amount Paid (Payment Currency) NUMERIC 20 8 — — +
SLD2 Customer Payment Proposal Header History SLD2011 Discount Amount (Payment Currency) NUMERIC 20 8 — — +
SLD2 Customer Payment Proposal Header History SLD2012 Currency Code Payment NCHAR 2   — — +
SLD2 Customer Payment Proposal Header History SLD2013 Exchange Rate 1 NUMERIC 10 8 — — +
SLD2 Customer Payment Proposal Header History SLD2014 Exchange Rate 2 NUMERIC 10 8 — — +
SLD2 Customer Payment Proposal Header History SLD2015 Exchange Algorithm NCHAR 3   — — +
SLD2 Customer Payment Proposal Header History SLD2016 Up to Invoice Due Date DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2017 Payment Date DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2018 Payment Way NCHAR 2   — — +
SLD2 Customer Payment Proposal Header History SLD2019 Alternative Payment Way NCHAR 2   — — +
SLD2 Customer Payment Proposal Header History SLD2020 Minimum Currency Code NCHAR 3   — — +
SLD2 Customer Payment Proposal Header History SLD2021 Maximum Currency Code NCHAR 3   — — +
SLD2 Customer Payment Proposal Header History SLD2022 Minimum Customer Code NCHAR 10   — — +
SLD2 Customer Payment Proposal Header History SLD2023 Maximum Customer Code NCHAR 10   — — +
SLD2 Customer Payment Proposal Header History SLD2024 Minimum Category Code NCHAR 4   — — +
SLD2 Customer Payment Proposal Header History SLD2025 Maximum Category Code NCHAR 4   — — +
SLD2 Customer Payment Proposal Header History SLD2026 Other Payment Currency NCHAR 1   — — +
SLD2 Customer Payment Proposal Header History SLD2027 Currency Code Payment NCHAR 3   — — +
SLD2 Customer Payment Proposal Header History SLD2028 Credit Note due date to be included DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2029 Discount Usage INT 1   — — +
SLD2 Customer Payment Proposal Header History SLD2030 Minimum Accounting Dimensions NVARCHAR 120   — — +
SLD2 Customer Payment Proposal Header History SLD2031 Maximum Accounting Dimensions NVARCHAR 120   — — +
SLD2 Customer Payment Proposal Header History SLD2032 Date Payment Notices Printed DATETIME 8   — — +
SLD2 Customer Payment Proposal Header History SLD2033 Creditor Bank Code NCHAR 2   — — +
SLD2 Customer Payment Proposal Header History SLD2034 Show PL Balance NCHAR 1   — — +
SLD2 Customer Payment Proposal Header History SLD2035 Payment Currency 2 INT 2   — — +
SLD3 Payment Proposal Header 2 History SLD3001 Payment Proposal Number NVARCHAR 6   — — +
SLD3 Payment Proposal Header 2 History SLD3002 Message ID NVARCHAR 40   — — +
SLD3 Payment Proposal Header 2 History SLD3003 Message Date Time DATETIME 17   — — +
SLD3 Payment Proposal Header 2 History SLD3004 Proposal Status NCHAR 2   — — +
SLD3 Payment Proposal Header 2 History SLD3005 Number of Transactions INT 8   — — +
SLD3 Payment Proposal Header 2 History SLD3006 Reason Code NVARCHAR 8   — — +
SLD3 Payment Proposal Header 2 History SLD3007 Reason Info NVARCHAR 60   — — +
SLD3 Payment Proposal Header 2 History SLD3008 Creditor ID NVARCHAR 25   — — +
SLD3 Payment Proposal Header 2 History SLD3009 Cancellation ID NVARCHAR 25   — — +
SLD3 Payment Proposal Header 2 History SLD3010 Cancellation DateTime DATETIME 17   — — +
SLD3 Payment Proposal Header 2 History SLD3011 Updating Date DATETIME 8   — — +
SLDD Payment Proposal Header 2 SLDD001 Payment Proposal Number NVARCHAR 6   — — +
SLDD Payment Proposal Header 2 SLDD002 Message ID NVARCHAR 40   — — +
SLDD Payment Proposal Header 2 SLDD003 Message Date Time DATETIME 17   — — +
SLDD Payment Proposal Header 2 SLDD004 Proposal Status NCHAR 2   — — +
SLDD Payment Proposal Header 2 SLDD005 Number of Transactions INT 8   — — +
SLDD Payment Proposal Header 2 SLDD006 Reason Code NVARCHAR 8   — — +
SLDD Payment Proposal Header 2 SLDD007 Reason Info NVARCHAR 60   — — +
SLDD Payment Proposal Header 2 SLDD008 Creditor ID NVARCHAR 25   — — +
SLDD Payment Proposal Header 2 SLDD009 Cancellation ID NVARCHAR 25   — — +
SLDD Payment Proposal Header 2 SLDD010 Cancellation DateTime DATETIME 17   — — +
SLDD Payment Proposal Header 2 SLDD011 Updating Date DATETIME 8   — — +
SLDS Portuguese Digital Signature SLDS001 Customer Code NCHAR 10   — — +
SLDS Portuguese Digital Signature SLDS002 Invoice Number (SL side) NCHAR 25   — — +
SLDS Portuguese Digital Signature SLDS003 Year NCHAR 4   — — +
SLDS Portuguese Digital Signature SLDS004 Source INT 2   — — +
SLDS Portuguese Digital Signature SLDS005 Credit Note NCHAR 1   — — +
SLDS Portuguese Digital Signature SLDS006 History NCHAR 1   — — +
SLDS Portuguese Digital Signature SLDS007 Invoice Issuer NVARCHAR 6   — — +
SLDS Portuguese Digital Signature SLDS008 Invoice Category NCHAR 1   — — +
SLDS Portuguese Digital Signature SLDS009 Invoice Type NCHAR 1   — — +
SLDS Portuguese Digital Signature SLDS010 Date and Time DATETIME 17   — — +
SLDS Portuguese Digital Signature SLDS011 Customer code (previous doc.) NVARCHAR 10   — — +
SLDS Portuguese Digital Signature SLDS012 Invoice number (previous doc.) NVARCHAR 25   — — +
SLDS Portuguese Digital Signature SLDS013 Digital singature NVARCHAR 200   — — +
SLDS Portuguese Digital Signature SLDS014 Serial number of key NVARCHAR 100   — — +
SLDS Portuguese Digital Signature SLDS015 Sequence within series INT 9   — — +
SLDS Portuguese Digital Signature SLDS016 Version Number INT 9   — — +
SLDS Portuguese Digital Signature SLDS017 Original String NVARCHAR 256   — — +
SLDS Portuguese Digital Signature SLDS018 Fiscal Key/CAE Code NVARCHAR 50   — — +
SLDS Portuguese Digital Signature SLDS019 CAE expiration date DATETIME 17   — — +
SLDS Portuguese Digital Signature SLDS020 CAE Comment NVARCHAR 1024   — — +
SLDS Portuguese Digital Signature SLDS021 Fiscal Key/CAE Status INT 2   — — +
SLDS Portuguese Digital Signature SLDS022 Fiscal Key Request Number NCHAR 10   — — +
SLDS Portuguese Digital Signature SLDS023 Fiscal Key Protocol No NVARCHAR 20   — — +
SLDS Portuguese Digital Signature SLDS024 Fiscal Key Protocol Date DATETIME 17   — — +
SLE0 Drafts SLE0001 CustomerCode NCHAR 10   — — +
SLE0 Drafts SLE0002 InvoiceNumber NCHAR 25   — — +
SLE0 Drafts SLE0003 RemittanceNo NVARCHAR 6   — — +
SLE0 Drafts SLE0004 BankAgent NVARCHAR 2   — — +
SLE0 Drafts SLE0005 Accepted NVARCHAR 1   — — +
SLE0 Drafts SLE0006 Remarks NVARCHAR 32   — — +
SLE0 Drafts SLE0007 Status NVARCHAR 1   — — +
SLE0 Drafts SLE0008 AccumExpenses NUMERIC 20 8 — — +
SLE0 Drafts SLE0009 PrintedStatus NVARCHAR 1   — — +
SLE0 Drafts SLE0010 DocumentCode NVARCHAR 1   — — +
SLE0 Drafts SLE0011 RemittanceStatus NVARCHAR 1   — — +
SLE0 Drafts SLE0012 CustomerBankAccount NVARCHAR 34   — — +
SLE0 Drafts SLE0013 CBankAddress1 NVARCHAR 32   — — +
SLE0 Drafts SLE0014 CBankAddress2 NVARCHAR 32   — — +
SLE0 Drafts SLE0015 CBankAddress3 NVARCHAR 32   — — +
SLE0 Drafts SLE0016 CustomerBankName NVARCHAR 42   — — +
SLE0 Drafts SLE0017 StampAmount NUMERIC 20 8 — — +
SLE0 Drafts SLE0018 CBankAddress4 NVARCHAR 32   — — +
SLE1 Remittance Header SLE1001 RemittanceNo NCHAR 6   — — +
SLE1 Remittance Header SLE1002 RemittanceDate DATETIME 8   — — +
SLE1 Remittance Header SLE1003 Bank/Agent NVARCHAR 2   — — +
SLE1 Remittance Header SLE1004 TotalAmount NUMERIC 20 8 — — +
SLE1 Remittance Header SLE1005 InterestAmount NUMERIC 20 8 — — +
SLE1 Remittance Header SLE1006 PendingAmount NUMERIC 20 8 — — +
SLE1 Remittance Header SLE1007 AccumExpenses NUMERIC 20 8 — — +
SLE1 Remittance Header SLE1008 InitialStatus NVARCHAR 1   — — +
SLE1 Remittance Header SLE1009 Remarks NVARCHAR 32   — — +
SLE1 Remittance Header SLE1010 Proposal NVARCHAR 1   — — +
SLE1 Remittance Header SLE1011 ClosedStatus NVARCHAR 1   — — +
SLE1 Remittance Header SLE1012 SupportNo NVARCHAR 6   — — +
SLE1 Remittance Header SLE1013 Norm NVARCHAR 2   — — +
SLE1 Remittance Header SLE1014 SupportDate DATETIME 8   — — +
SLE2 Remittance Details SLE2001 RemittanceNo NCHAR 6   — — +
SLE2 Remittance Details SLE2002 CustomerCode NCHAR 10   — — +
SLE2 Remittance Details SLE2003 InvoiceNo NCHAR 25   — — +
SLE2 Remittance Details SLE2004 RemittanceDate DATETIME 8   — — +
SLE2 Remittance Details SLE2005 CodeCurrency NVARCHAR 2   — — +
SLE3 Bank/Agent SLE3001 Bank/AgentCode NCHAR 2   — — +
SLE3 Bank/Agent SLE3002 Bank/AgentName NVARCHAR 25   — — +
SLE3 Bank/Agent SLE3003 DiscountLimit NUMERIC 20 8 — — +
SLE3 Bank/Agent SLE3004 AccountingStringCashAccount NVARCHAR 120   — — +
SLE3 Bank/Agent SLE3005 Reserved NVARCHAR 1   — — +
SLE3 Bank/Agent SLE3006 Reserved NVARCHAR 1   — — +
SLE3 Bank/Agent SLE3007 Reserved NVARCHAR 1   — — +
SLE3 Bank/Agent SLE3008 WaitingDays NVARCHAR 3   — — +
SLE3 Bank/Agent SLE3009 AccountingStringRiskAccount NVARCHAR 120   — — +
SLE3 Bank/Agent SLE3010 Reserved NVARCHAR 1   — — +
SLE3 Bank/Agent SLE3011 Reserved NVARCHAR 1   — — +
SLE3 Bank/Agent SLE3012 Reserved NVARCHAR 1   — — +
SLE3 Bank/Agent SLE3013 AmountRisk NUMERIC 20 8 — — +
SLE3 Bank/Agent SLE3014 AmountNotRisk NVARCHAR 20   — — +
SLE3 Bank/Agent SLE3015 BankCode NVARCHAR 4   — — +
SLE3 Bank/Agent SLE3016 BankOfficeCode NVARCHAR 4   — — +
SLE3 Bank/Agent SLE3017 BankAccountNo NVARCHAR 10   — — +
SLE3 Bank/Agent SLE3018 BankAccountNoCD NVARCHAR 2   — — +
SLE3 Bank/Agent SLE3019 BankAAddress1 NVARCHAR 35   — — +
SLE3 Bank/Agent SLE3020 BankAAddress2 NVARCHAR 35   — — +
SLE3 Bank/Agent SLE3021 BankAAddress3 NVARCHAR 35   — — +
SLE3 Bank/Agent SLE3022 AssignorCodeNorm32 NVARCHAR 15   — — +
SLE3 Bank/Agent SLE3023 AssignorCodeNorm58 NVARCHAR 15   — — +
SLE3 Bank/Agent SLE3024 AssignorCodeNorm19 NVARCHAR 15   — — +
SLE3 Bank/Agent SLE3025 SupportNoNorm32 NVARCHAR 6   — — +
SLE3 Bank/Agent SLE3026 SupportNoNorm58 NVARCHAR 6   — — +
SLE3 Bank/Agent SLE3027 SupportNoNorm19 NVARCHAR 6   — — +
SLE3 Bank/Agent SLE3028 Path&NameFile NVARCHAR 35   — — +
SLE3 Bank/Agent SLE3029 IBAN ISO Country Code NVARCHAR 2   — — +
SLE3 Bank/Agent SLE3030 Control Digits IBAN NVARCHAR 2   — — +
SLE4 Draft Transactions SLE4001 CustomerCode NCHAR 10   — — +
SLE4 Draft Transactions SLE4002 InvoiceNo NCHAR 25   — — +
SLE4 Draft Transactions SLE4003 DraftTransactionNo NCHAR 6   — — +
SLE4 Draft Transactions SLE4004 JournalTransactionNo NVARCHAR 9   — — +
SLE4 Draft Transactions SLE4005 OldDraftType NVARCHAR 1   — — +
SLE4 Draft Transactions SLE4006 OldDraftStatus NVARCHAR 1   — — +
SLE4 Draft Transactions SLE4007 NewDraftType NVARCHAR 1   — — +
SLE4 Draft Transactions SLE4008 NewDraftStatus NVARCHAR 1   — — +
SLE4 Draft Transactions SLE4009 Reserved NVARCHAR 6   — — +
SLE4 Draft Transactions SLE4010 Reserved NVARCHAR 6   — — +
SLE4 Draft Transactions SLE4011 Reserved NVARCHAR 6   — — +
SLE4 Draft Transactions SLE4012 Reserved NVARCHAR 6   — — +
SLE4 Draft Transactions SLE4013 ExpensesAmount NUMERIC 20 8 — — +
SLE4 Draft Transactions SLE4014 TransactionDate DATETIME 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5001 Reccounter NUMERIC 9   — — +
SLE5 Sales Ledger Payment Provisional SLE5002 TransactNo NCHAR 9   — — +
SLE5 Sales Ledger Payment Provisional SLE5003 LineNo NCHAR 7   — — +
SLE5 Sales Ledger Payment Provisional SLE5004 TransactDate DATETIME 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5005 Flag NCHAR 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5006 AccountString NVARCHAR 120   — — +
SLE5 Sales Ledger Payment Provisional SLE5007 AmountLCU NUMERIC 20 8 — — +
SLE5 Sales Ledger Payment Provisional SLE5008 CurrCode INT 2   — — +
SLE5 Sales Ledger Payment Provisional SLE5009 AccStringOCU NVARCHAR 120   — — +
SLE5 Sales Ledger Payment Provisional SLE5010 AmountOCU NUMERIC 20 8 — — +
SLE5 Sales Ledger Payment Provisional SLE5011 TransacText NVARCHAR 100   — — +
SLE5 Sales Ledger Payment Provisional SLE5012 Code1 NCHAR 10   — — +
SLE5 Sales Ledger Payment Provisional SLE5013 Code2 NVARCHAR 25   — — +
SLE5 Sales Ledger Payment Provisional SLE5014 Code3 NCHAR 6   — — +
SLE5 Sales Ledger Payment Provisional SLE5015 Code4 NCHAR 2   — — +
SLE5 Sales Ledger Payment Provisional SLE5016 Code5 NVARCHAR 35   — — +
SLE5 Sales Ledger Payment Provisional SLE5017 Code6 NCHAR 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5018 Tag1 NCHAR 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5019 Tag2 NCHAR 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5020 Tag3 NCHAR 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5021 TransLineType NCHAR 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5022 TransLineSign NCHAR 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5023 NoDecimals NUMERIC 1   — — +
SLE5 Sales Ledger Payment Provisional SLE5024 Linkcode NCHAR 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5025 Quantity NUMERIC 20 8 — — +
SLE5 Sales Ledger Payment Provisional SLE5026 Unitcode INT 4   — — +
SLE5 Sales Ledger Payment Provisional SLE5027 AmountOCU NUMERIC 20 8 — — +
SLE5 Sales Ledger Payment Provisional SLE5028 ContraAcc NCHAR 13   — — +
SLE5 Sales Ledger Payment Provisional SLE5029 JournalNo NUMERIC 6   — — +
SLE5 Sales Ledger Payment Provisional SLE5030 PlReference NCHAR 9   — — +
SLE5 Sales Ledger Payment Provisional SLE5031 SubprjCode NCHAR 6   — — +
SLE5 Sales Ledger Payment Provisional SLE5032 ActivityCode NCHAR 6   — — +
SLE5 Sales Ledger Payment Provisional SLE5033 UsrIdBy NCHAR 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5034 DateEntry DATETIME 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5035 UsrIdUpdBy NCHAR 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5036 dateUpd DATETIME 8   — — +
SLE5 Sales Ledger Payment Provisional SLE5037 TransTxtOCU NVARCHAR 100   — — +
SLE5 Sales Ledger Payment Provisional SLE5038 PaxRate NCHAR 10   — — +
SLE5 Sales Ledger Payment Provisional SLE5039 PaxRate2 NCHAR 10   — — +
SLE5 Sales Ledger Payment Provisional SLE5040 PaAlgorithm NCHAR 3   — — +
SLE7 Extended Payment SLE7001 RecordType NCHAR 1   — — +
SLE7 Extended Payment SLE7002 PaymentTerm NCHAR 2   — — +
SLE7 Extended Payment SLE7003 SimpleMultiple NVARCHAR 1   — — +
SLE7 Extended Payment SLE7004 ValuablesType NVARCHAR 1   — — +
SLE7 Extended Payment SLE7005 Period NVARCHAR 3   — — +
SLE7 Extended Payment SLE7006 Day/Month NVARCHAR 1   — — +
SLE7 Extended Payment SLE7007 OthersPayments NVARCHAR 2   — — +
SLE7 Extended Payment SLE7008 PaymentTerms1 NVARCHAR 2   — — +
SLE7 Extended Payment SLE7009 %PaymentTerms1 NVARCHAR 6   — — +
SLE7 Extended Payment SLE7010 PaymentTerms2 NVARCHAR 2   — — +
SLE7 Extended Payment SLE7011 %PaymentTerms2 NVARCHAR 6   — — +
SLE7 Extended Payment SLE7012 PaymentTerms3 NVARCHAR 2   — — +
SLE7 Extended Payment SLE7013 %PaymentTerms3 NVARCHAR 6   — — +
SLE7 Extended Payment SLE7014 MinimumValue NVARCHAR 12   — — +
SLE8 Advanced Sales Ledger Parameters SLE8001 Index ID INT 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8002 Remittance Number NVARCHAR 6   — — +
SLE8 Advanced Sales Ledger Parameters SLE8003 Negotiable Trans Num NVARCHAR 6   — — +
SLE8 Advanced Sales Ledger Parameters SLE8004 GLTransactNo NVARCHAR 9   — — +
SLE8 Advanced Sales Ledger Parameters SLE8005 Use SL Trans Number NCHAR 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8006 Use GL Trans Number NCHAR 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8007 Type of Negotiable Instr. from Cust NCHAR 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8008 Assign Bank when Remit creating NCHAR 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8009 Integrated with SL NCHAR 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8010 Show Negotiable Instr. on closing orders NCHAR 1   — — +
SLE8 Advanced Sales Ledger Parameters SLE8011 Show Risk Calc at Bank NCHAR 1   — — +
SLE9 Advanced Automatic Accounting Codes SLE9001 IndexID NCHAR 6   — — +
SLE9 Advanced Automatic Accounting Codes SLE9002 Coding Schedule NVARCHAR 12   — — +
SLER Remittance Work File SLER001 RemittanceNo NCHAR 6   — — +
SLER Remittance Work File SLER002 RemittanceDate DATETIME 8   — — +
SLER Remittance Work File SLER003 SelectedFlag NVARCHAR 1   — — +
SLER Remittance Work File SLER004 CurrencyCode NVARCHAR 2   — — +
SLH1 Invoice Header History SLH1001 Customer Code NVARCHAR 10   — — +
SLH1 Invoice Header History SLH1002 Invoice No NVARCHAR 25   — — +
SLH1 Invoice Header History SLH1003 Invoice Date DATETIME 8   — — +
SLH1 Invoice Header History SLH1004 Invoice Currency Code NCHAR 2   — — +
SLH1 Invoice Header History SLH1005 Invoice Currency Name NVARCHAR 3   — — +
SLH1 Invoice Header History SLH1006 Issuer Code NVARCHAR 6   — — +
SLH1 Invoice Header History SLH1007 Invoice Net Total OCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1008 Invoice Net Total LCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1009 Invoice Grand Total Amount OCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1010 Invoice Grand Total Amount LCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1011 User Defined 1 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1012 User Defined 2 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1013 User Defined 3 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1014 User Defined 4 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1015 User Defined 5 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1016 User Defined 6 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1017 User Defined 7 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1018 User Defined 8 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1019 User Defined 9 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1020 User Defined 10 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1021 UserDefined 11 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1022 UserDefined 12 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1023 UserDefined 13 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1024 UserDefined 14 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1025 UserDefined 15 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1026 UserDefined 16 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1027 UserDefined 17 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1028 UserDefined 18 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1029 UserDefined 19 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1030 UserDefined 20 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1031 Net Total Before Charges OCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1032 Net Total Before Charges LCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1033 Tax Total Amount OCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1034 Tax Total Amount LCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1035 Rounding Amount OCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1036 Rounding Amount LCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1037 Specification Printed NCHAR 1   — — +
SLH1 Invoice Header History SLH1038 Paper Printed Flag INT 1   — — +
SLH1 Invoice Header History SLH1039 Number of printouts INT 4   — — +
SLH1 Invoice Header History SLH1040 XML Sent flag INT 1   — — +
SLH1 Invoice Header History SLH1041 Created User ID NCHAR 8   — — +
SLH1 Invoice Header History SLH1042 Created Time Stamp DATETIME 8   — — +
SLH1 Invoice Header History SLH1043 Template Version INT 4   — — +
SLH1 Invoice Header History SLH1044 Printed Time Stamp DATETIME 17   — — +
SLH1 Invoice Header History SLH1045 Language Code NVARCHAR 3   — — +
SLH1 Invoice Header History SLH1046 Document Layout Code NCHAR 1   — — +
SLH1 Invoice Header History SLH1047 Withholding Tax Amount OCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1048 Withholding Tax Amount LCU NUMERIC 20 8 — — +
SLH1 Invoice Header History SLH1049 User Defined 21 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1050 User Defined 22 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1051 User Defined 23 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1052 User Defined 24 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1053 User Defined 25 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1054 User Defined 26 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1055 User Defined 27 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1056 User Defined 28 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1057 User Defined 29 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1058 User Defined 30 NVARCHAR 120   — — +
SLH1 Invoice Header History SLH1059 Email To NVARCHAR 200   — — +
SLH1 Invoice Header History SLH1060 Email CC NVARCHAR 200   — — +
SLH1 Invoice Header History SLH1061 Email BCC NVARCHAR 200   — — +
SLH1 Invoice Header History SLH1062 Email From NVARCHAR 200   — — +
SLH1 Invoice Header History SLH1063 File Name NVARCHAR 250   — — +
SLH1 Invoice Header History SLH1064 Paper copies to print INT 4   — — +
SLH1 Invoice Header History SLH1065 Number of XML sendings INT 4   — — +
SLH1 Invoice Header History SLH1066 Latest XML sending timestamp DATETIME 17   — — +
SLH1 Invoice Header History SLH1067 Latest reprint timestamp DATETIME 17   — — +
SLH1 Invoice Header History SLH1068 Customer PO number NVARCHAR 30   — — +
SLH1 Invoice Header History SLH1069 Document ID INT 2   — — +
SLH1 Invoice Header History SLH1070 Tax Registration Date DATETIME 8   — — +
SLH1 Invoice Header History SLH1071 Credit Reason NVARCHAR 50   — — +
SLH1 Invoice Header History SLH1072 Original Invoice NVARCHAR 25   — — +
SLH2 Invoice Issuer/Recipient History SLH2001 Customer Code NVARCHAR 10   — — +
SLH2 Invoice Issuer/Recipient History SLH2002 Invoice No NVARCHAR 25   — — +
SLH2 Invoice Issuer/Recipient History SLH2003 Type INT 4   — — +
SLH2 Invoice Issuer/Recipient History SLH2004 Company Name NVARCHAR 50   — — +
SLH2 Invoice Issuer/Recipient History SLH2005 Tax Registration Number NVARCHAR 20   — — +
SLH2 Invoice Issuer/Recipient History SLH2006 State Registration Number NVARCHAR 20   — — +
SLH2 Invoice Issuer/Recipient History SLH2007 Address Line 1 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2008 Address Line 2 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2009 Address Line 3 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2010 Address Line 4 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2011 Address Line 5 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2012 Address Line 6 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2013 Address Line 7 NVARCHAR 35   — — +
SLH2 Invoice Issuer/Recipient History SLH2014 Zip Code NVARCHAR 10   — — +
SLH2 Invoice Issuer/Recipient History SLH2015 Email Address NVARCHAR 50   — — +
SLH2 Invoice Issuer/Recipient History SLH2016 Phone No NVARCHAR 20   — — +
SLH2 Invoice Issuer/Recipient History SLH2017 Fax No NVARCHAR 20   — — +
SLH2 Invoice Issuer/Recipient History SLH2018 User Defined 1 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2019 User Defined 2 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2020 User Defined 3 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2021 User Defined 4 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2022 User Defined 5 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2023 User Defined 6 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2024 User Defined 7 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2025 User Defined 8 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2026 User Defined 9 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2027 User Defined 10 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2028 User Defined 11 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2029 User Defined 12 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2030 User Defined 13 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2031 User Defined 14 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2032 User Defined 15 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2033 User Defined 16 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2034 User Defined 17 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2035 User Defined 18 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2036 User Defined 19 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2037 User Defined 20 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2038 Country Code NVARCHAR 3   — — +
SLH2 Invoice Issuer/Recipient History SLH2039 Region Code NVARCHAR 10   — — +
SLH2 Invoice Issuer/Recipient History SLH2040 State Province Code NVARCHAR 10   — — +
SLH2 Invoice Issuer/Recipient History SLH2041 County Code NVARCHAR 10   — — +
SLH2 Invoice Issuer/Recipient History SLH2042 City Code NVARCHAR 10   — — +
SLH2 Invoice Issuer/Recipient History SLH2043 User Defined 21 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2044 User Defined 22 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2045 User Defined 23 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2046 User Defined 24 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2047 User Defined 25 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2048 User Defined 26 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2049 User Defined 27 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2050 User Defined 28 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2051 User Defined 29 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2052 User Defined 30 NVARCHAR 120   — — +
SLH2 Invoice Issuer/Recipient History SLH2053 PEPPOL Endpoint ID NVARCHAR 25   — — +
SLH2 Invoice Issuer/Recipient History SLH2054 PEPPOL EndpointScheme ID INT 4   — — +
SLH2 Invoice Issuer/Recipient History SLH2055 Export Code INT 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3003 Main Invoice Number NCHAR 25   15   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3010 Invoice Number NVARCHAR 25   15   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3011 Transaction Number NVARCHAR 9   6   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3025 Accounting String NVARCHAR 120   50   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3032 Commentary Text NVARCHAR 50   15   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3080 Periodic Billing — Reference NVARCHAR 25   15   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3094 Original Transaction Number NVARCHAR 9   6   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3096 Document Type NCHAR 3   2   —
SLH3 Recharge Invoice Accounts Receivable header master file SLH3104 CashMethod NCHAR 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3105 WithholdTaxLocCur NUMERIC 20 8 — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3106 WithholdTaxOriCur NUMERIC 20 8 — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3107 BankNoteNo NVARCHAR 20   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3108 NetInvAmntLCU NUMERIC 20 8 — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3109 NetInvAmntOCU NUMERIC 20 8 — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3110 Instalments NCHAR 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3111 SalesReturnReasonCode INT 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3112 TaxNoteNo NVARCHAR 25   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3113 FinOperationCode2 NVARCHAR 10   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3114 EDIStatus NCHAR 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3115 NumberOfPages INT 3   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3116 IssuerExtCode NVARCHAR 16   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3117 IssuerExpDate DATETIME 8   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3118 POSMachine NCHAR 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3119 TaxNoteRegDate DATETIME 8   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3120 Issuer Code NCHAR 6   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3121 Commision Base NUMERIC 20 8 — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3122 Commision Withheld Cost NUMERIC 20 8 — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3123 Commision Distribution Method NCHAR 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3124 Due Date Definition INT 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3125 Payment Term Code NCHAR 2   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3126 LockPaymentsInvoices INT 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3127 CorrectionNumber INT 3   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3128 Fiscal Reference NVARCHAR 50   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3129 Spesometro Forms NVARCHAR 12   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3130 Reminder Date DATETIME 8   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3131 PO3 Sub type NCHAR 2   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3132 Payment Code NCHAR 3   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3133 TaxRegStatus NCHAR 1   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3134 Public Procurement Code1 NVARCHAR 20   — — +
SLH3 Recharge Invoice Accounts Receivable header master file SLH3135 Public Procurement Code2 NVARCHAR 20   — — +
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4003 Main Invoice Number NCHAR 25   15   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4005 Line Number NCHAR 7   5   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4008 Transaction Number NCHAR 9   6   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4011 Accounting String NVARCHAR 120   50   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4014 Accounting String (Line Currency) NVARCHAR 120   50   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4026 In Closing Period NCHAR 8   5   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4028 Unit Code INT 4   2   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4031 Internal Reference Number NCHAR 9   6   —
SLH4 Recharge Invoice Accounts Receivable transaction lines file SLH4038 AAS code NVARCHAR 25   — — +
SLH5 Invoice Lines History SLH5001 Customer Code NVARCHAR 10   — — +
SLH5 Invoice Lines History SLH5002 Invoice No NVARCHAR 25   — — +
SLH5 Invoice Lines History SLH5003 Object No NVARCHAR 12   — — +
SLH5 Invoice Lines History SLH5004 Line No NVARCHAR 6   — — +
SLH5 Invoice Lines History SLH5005 Tax Line No NVARCHAR 3   — — +
SLH5 Invoice Lines History SLH5006 Source For Invoice NVARCHAR 1   — — +
SLH5 Invoice Lines History SLH5007 Line Discount LCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5008 Net Line Amount LCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5009 Tax Code NVARCHAR 6   — — +
SLH5 Invoice Lines History SLH5010 Tax Type NVARCHAR 6   — — +
SLH5 Invoice Lines History SLH5011 Tax Percentage NVARCHAR 6   — — +
SLH5 Invoice Lines History SLH5012 Base Amount LCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5013 Tax Amount LCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5014 Fixed Exchange Rate NUMERIC 10 8 — — +
SLH5 Invoice Lines History SLH5015 Line Discount OCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5016 Net Line Amount OCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5017 Base Amount OCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5018 Tax Amount OCU NUMERIC 20 8 — — +
SLH5 Invoice Lines History SLH5019 Invoice Currency Code NVARCHAR 3   — — +
SLH5 Invoice Lines History SLH5020 Object Type INT 4   — — +
SLH5 Invoice Lines History SLH5021 Line Type INT 4   — — +
SLH5 Invoice Lines History SLH5022 Extended Line No NVARCHAR 50   — — +
SLH5 Invoice Lines History SLH5023 Tax Exemption Reason Code NVARCHAR 3   — — +
SLH5 Invoice Lines History SLH5024 Invoice Line No NVARCHAR 6   — — +
SLH5 Invoice Lines History SLH5025 Tax Collector Type NCHAR 1   — — +
SLH5 Invoice Lines History SLH5026 Deducted by Invoice No NVARCHAR 25   — — +
SLH6 Invoice Lines Details History SLH6001 Customer Code NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6002 Invoice No NVARCHAR 25   — — +
SLH6 Invoice Lines Details History SLH6003 Invoice Line No NVARCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6004 Object Type INT 4   — — +
SLH6 Invoice Lines Details History SLH6005 Object No NVARCHAR 12   — — +
SLH6 Invoice Lines Details History SLH6006 Sub-Object No NVARCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6007 Invoice Plan Line No NVARCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6008 Line Type INT 4   — — +
SLH6 Invoice Lines Details History SLH6009 Line Number NVARCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6010 Extended Line number NVARCHAR 50   — — +
SLH6 Invoice Lines Details History SLH6011 Stock/Activity Code NVARCHAR 35   — — +
SLH6 Invoice Lines Details History SLH6012 Description 1 NVARCHAR 50   — — +
SLH6 Invoice Lines Details History SLH6013 Description 2 NVARCHAR 50   — — +
SLH6 Invoice Lines Details History SLH6014 Qty NUMERIC 12 8 — — +
SLH6 Invoice Lines Details History SLH6015 Unit Of Measure (Code) INT 4   — — +
SLH6 Invoice Lines Details History SLH6016 Unit Of Measure (Description) NVARCHAR 25   — — +
SLH6 Invoice Lines Details History SLH6017 Price per Unit OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6018 Price per Unit LCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6019 Gross Line Discount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6020 Gross Line Discount LCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6021 Net Line Amount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6022 Net Line Amount LCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6023 Gross Line Amount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6024 Gross Line Amount LCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6025 Tax Code NVARCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6026 Tax Percentage NVARCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6027 Tax Amount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6028 Tax Amount LCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6029 User Defined 1 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6030 User Defined 2 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6031 User Defined 3 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6032 User Defined 4 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6033 User Defined 5 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6034 User Defined 6 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6035 User Defined 7 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6036 User Defined 8 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6037 User Defined 9 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6038 User Defined 10 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6039 User Defined 11 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6040 User Defined 12 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6041 User Defined 13 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6042 User Defined 14 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6043 User Defined 15 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6044 User Defined 16 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6045 User Defined 17 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6046 User Defined 18 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6047 User Defined 19 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6048 User Defined 20 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6049 Withholding Tax Amount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6050 Withholding Tax Amount LCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6051 Delivery Date From DATETIME 8   — — +
SLH6 Invoice Lines Details History SLH6052 Delivery Date To DATETIME 8   — — +
SLH6 Invoice Lines Details History SLH6053 Tax BE Date DATETIME 8   — — +
SLH6 Invoice Lines Details History SLH6054 Tax Liability NCHAR 6   — — +
SLH6 Invoice Lines Details History SLH6055 Financial Operation Type NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6056 Financial Operation Code NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6057 Source City Code NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6058 Destination City Code NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6059 User Defined 21 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6060 User Defined 22 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6061 User Defined 23 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6062 User Defined 24 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6063 User Defined 25 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6064 User Defined 26 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6065 User Defined 27 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6066 User Defined 28 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6067 User Defined 29 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6068 User Defined 30 NVARCHAR 120   — — +
SLH6 Invoice Lines Details History SLH6069 Deducted by Invoice No NVARCHAR 25   — — +
SLH6 Invoice Lines Details History SLH6070 Spare NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6071 Spare NVARCHAR 10   — — +
SLH6 Invoice Lines Details History SLH6072 Net Line Discount OCU NUMERIC 20 8 — — +
SLH6 Invoice Lines Details History SLH6073 Net Line Discount LCU NUMERIC 20 8 — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7001 Customer Code NVARCHAR 10   — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7002 Invoice No NVARCHAR 25   — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7003 Invoice Line Number NVARCHAR 6   — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7004 Text Line Number NVARCHAR 6   — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7005 Text Type NVARCHAR 2   — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7006 Text NVARCHAR 4000   — — +
SLH7 Invoice Texts Linked to Generic Invoices SLH7007 Original Reference NVARCHAR 8   — — +
SLH8 Invoice Bank Info SLH8001 Customer Code NVARCHAR 10   — — +
SLH8 Invoice Bank Info SLH8002 Invoice No NVARCHAR 25   — — +
SLH8 Invoice Bank Info SLH8003 Bank Type NCHAR 2   — — +
SLH8 Invoice Bank Info SLH8004 Bank Code NCHAR 10   — — +
SLH8 Invoice Bank Info SLH8005 Bank Name NVARCHAR 35   — — +
SLH8 Invoice Bank Info SLH8006 Account No NVARCHAR 34   — — +
SLH8 Invoice Bank Info SLH8007 BIC NVARCHAR 19   — — +
SLI1 Payment Term Instalments SL Header SLI1001 PaymentTerm NVARCHAR 2   — — +
SLI1 Payment Term Instalments SL Header SLI1002 Instalment Type NVARCHAR 1   — — +
SLI1 Payment Term Instalments SL Header SLI1003 Number Of Instalments INT 3   — — +
SLI1 Payment Term Instalments SL Header SLI1004 Percentage NCHAR 1   — — +
SLI1 Payment Term Instalments SL Header SLI1005 Interval INT 3   — — +
SLI1 Payment Term Instalments SL Header SLI1006 UnitInterval NCHAR 1   — — +
SLI1 Payment Term Instalments SL Header SLI1007 Interest% NVARCHAR 6   — — +
SLI1 Payment Term Instalments SL Header SLI1008 NewInterest% NVARCHAR 6   — — +
SLI1 Payment Term Instalments SL Header SLI1009 ActivateNewInterest DATETIME 8   — — +
SLI1 Payment Term Instalments SL Header SLI1010 PeriodOfGrace INT 3   — — +
SLI1 Payment Term Instalments SL Header SLI1011 UnitPeriodOfGrace NCHAR 1   — — +
SLI1 Payment Term Instalments SL Header SLI1012 EndOfMonthPerGrace NCHAR 1   — — +
SLI1 Payment Term Instalments SL Header SLI1013 PlusNumberOfUnit INT 3   — — +
SLI1 Payment Term Instalments SL Header SLI1014 FinancialCharge NUMERIC 20 8 — — +
SLI1 Payment Term Instalments SL Header SLI1015 UseTotalRounding NCHAR 1   — — +
SLI1 Payment Term Instalments SL Header SLI1016 InterestTaxCode NCHAR 6   — — +
SLI1 Payment Term Instalments SL Header SLI1017 FinTaxCode NCHAR 6   — — +
SLI1 Payment Term Instalments SL Header SLI1018 WayOfPaymentPerInstlmnts NCHAR 1   — — +
SLI2 Payment Term Instalments SL Lines SLI2001 PaymentTerm NVARCHAR 2   — — +
SLI2 Payment Term Instalments SL Lines SLI2002 InstallmentNumber INT 3   — — +
SLI2 Payment Term Instalments SL Lines SLI2003 DateCalculation INT 3   — — +
SLI2 Payment Term Instalments SL Lines SLI2004 Percentage% NVARCHAR 6   — — +
SLI2 Payment Term Instalments SL Lines SLI2005 WayOfPayment NVARCHAR 2   — — +
SLI3 Payment Term Instalments SL SLI3001 CustomerCode NVARCHAR 10   — — +
SLI3 Payment Term Instalments SL SLI3002 InvoiceNo NVARCHAR 25   — — +
SLI3 Payment Term Instalments SL SLI3003 InstalmentNumber INT 3   — — +
SLI3 Payment Term Instalments SL SLI3004 DueDate DATETIME 8   — — +
SLI3 Payment Term Instalments SL SLI3005 InvAmoLocCur NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3006 InvAmoOriCur NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3007 PaidAmountLocCur NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3008 PaidAmountOriCur NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3009 LastPaymentDate DATETIME 8   — — +
SLI3 Payment Term Instalments SL SLI3010 WayOfPayment NVARCHAR 2   — — +
SLI3 Payment Term Instalments SL SLI3011 Invoice Date DATETIME 8   — — +
SLI3 Payment Term Instalments SL SLI3012 Currency Code NVARCHAR 2   — — +
SLI3 Payment Term Instalments SL SLI3013 Payment Terms NVARCHAR 2   — — +
SLI3 Payment Term Instalments SL SLI3014 No of Insoluti/Unpaid NVARCHAR 2   — — +
SLI3 Payment Term Instalments SL SLI3015 Payment Address Code NVARCHAR 2   — — +
SLI3 Payment Term Instalments SL SLI3016 Bank Code NVARCHAR 10   — — +
SLI3 Payment Term Instalments SL SLI3017 Bank Account NVARCHAR 34   — — +
SLI3 Payment Term Instalments SL SLI3018 Slip Number NVARCHAR 10   — — +
SLI3 Payment Term Instalments SL SLI3019 RIBA Number NVARCHAR 10   — — +
SLI3 Payment Term Instalments SL SLI3020 Status NVARCHAR 1   — — +
SLI3 Payment Term Instalments SL SLI3021 No. Reminder NVARCHAR 3   — — +
SLI3 Payment Term Instalments SL SLI3022 Slip Date DATETIME 8   — — +
SLI3 Payment Term Instalments SL SLI3023 Deposit Account NVARCHAR 12   — — +
SLI3 Payment Term Instalments SL SLI3024 Percentage NVARCHAR 6   — — +
SLI3 Payment Term Instalments SL SLI3025 Instalment Type NCHAR 1   — — +
SLI3 Payment Term Instalments SL SLI3026 Original Instalment No INT 3   — — +
SLI3 Payment Term Instalments SL SLI3027 Invoice Point Currency (tax/vat) INT 2   — — +
SLI3 Payment Term Instalments SL SLI3028 Payment Point Currency (tax/vat) INT 2   — — +
SLI3 Payment Term Instalments SL SLI3029 Tax/vat Amount Payment in Point Currency NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3030 Paid Tax Amount in Payment Point Currency NUMERIC 20 8 — — +
SLI3 Payment Term Instalments SL SLI3031 GL tax/vat payment account NVARCHAR 12   — — +
SLI9 RIBA Payment proposals SLI9001 Customer Code NVARCHAR 10   — — +
SLI9 RIBA Payment proposals SLI9002 Invoice Ref Number NVARCHAR 25   — — +
SLI9 RIBA Payment proposals SLI9003 Due Date DATETIME 8   — — +
SLI9 RIBA Payment proposals SLI9004 Payment Amount NUMERIC 20 8 — — +
SLI9 RIBA Payment proposals SLI9005 Discount NUMERIC 20 8 — — +
SLI9 RIBA Payment proposals SLI9006 Invoice Date DATETIME 8   — — +
SLI9 RIBA Payment proposals SLI9007 Payment Block NVARCHAR 1   — — +
SLI9 RIBA Payment proposals SLI9008 RIBA Number NVARCHAR 10   — — +
SLI9 RIBA Payment proposals SLI9009 Draft Date DATETIME 8   — — +
SLI9 RIBA Payment proposals SLI9010 Bank Code NVARCHAR 10   — — +
SLI9 RIBA Payment proposals SLI9011 Instalment Number NVARCHAR 2   — — +
SLIN Invoice Based Intrastat SL SLIN001 Customer Code NCHAR 10   — — +
SLIN Invoice Based Intrastat SL SLIN002 Invoice Number NCHAR 25   — — +
SLIN Invoice Based Intrastat SL SLIN003 Statistical Code NVARCHAR 14   — — +
SLIN Invoice Based Intrastat SL SLIN004 Amount LCU NUMERIC 20 8 — — +
SLIN Invoice Based Intrastat SL SLIN005 Nature of Transaction NCHAR 2   — — +
SLIN Invoice Based Intrastat SL SLIN006 Sales Order NCHAR 10   — — +
SLIN Invoice Based Intrastat SL SLIN007 Volume Net NUMERIC 10 8 — — +
SLIN Invoice Based Intrastat SL SLIN008 Supplementary Units QTY or Description NCHAR 10   — — +
SLIN Invoice Based Intrastat SL SLIN009 Statistical Value NUMERIC 20 8 — — +
SLIN Invoice Based Intrastat SL SLIN010 Regime NCHAR 2   — — +
SLIN Invoice Based Intrastat SL SLIN011 Transport Method NCHAR 2   — — +
SLIN Invoice Based Intrastat SL SLIN012 Country of Nature NCHAR 3   — — +
SLIN Invoice Based Intrastat SL SLIN013 Country of Origin NCHAR 3   — — +
SLIN Invoice Based Intrastat SL SLIN014 Country of Destination NCHAR 3   — — +
SLIN Invoice Based Intrastat SL SLIN015 Period Reference NCHAR 2   — — +
SLIN Invoice Based Intrastat SL SLIN016 Year Reference NCHAR 4   — — +
SLIN Invoice Based Intrastat SL SLIN017 Amount OCU NUMERIC 20 8 — — +
SLIN Invoice Based Intrastat SL SLIN018 Original Currency Code INT 2   — — +
SLIN Invoice Based Intrastat SL SLIN019 Transaction Date DATETIME 8   — — +
SLIN Invoice Based Intrastat SL SLIN020 Line Number INT 3   — — +
SLIN Invoice Based Intrastat SL SLIN021 Tax Registration Country NCHAR 3   — — +
SLL1 Tax Exemptions SLL1014 ExemptLimit NUMERIC 20 8 — — +
SLL1 Tax Exemptions SLL1015 ExemptTaxCode NCHAR 2   — — +
SLM0 Mandate SLM0001 Mandate Reference NVARCHAR 35   — — +
SLM0 Mandate SLM0002 Debtor Code NVARCHAR 10   — — +
SLM0 Mandate SLM0003 Debtor Name NVARCHAR 35   — — +
SLM0 Mandate SLM0004 Debtor Address Line 1 NVARCHAR 35   — — +
SLM0 Mandate SLM0005 Debtor Address Line 2 NVARCHAR 35   — — +
SLM0 Mandate SLM0006 Debtor Address Line 3 NVARCHAR 35   — — +
SLM0 Mandate SLM0007 Debtor Address Line 4 NVARCHAR 35   — — +
SLM0 Mandate SLM0008 Debtor Address Line 5 NVARCHAR 35   — — +
SLM0 Mandate SLM0009 Debtor Address Line 6 NVARCHAR 35   — — +
SLM0 Mandate SLM0010 Debtor Address Line 7 NVARCHAR 35   — — +
SLM0 Mandate SLM0011 Debtor Country Code NCHAR 3   — — +
SLM0 Mandate SLM0012 Debtor Identification Code NVARCHAR 25   — — +
SLM0 Mandate SLM0013 Debtor Reference Name NVARCHAR 35   — — +
SLM0 Mandate SLM0014 Debtor Identification of Reference Part NVARCHAR 25   — — +
SLM0 Mandate SLM0015 Debtor IBAN Account NVARCHAR 34   — — +
SLM0 Mandate SLM0016 Underlying Contract ID NVARCHAR 25   — — +
SLM0 Mandate SLM0017 Debtor Bank BIC Code NVARCHAR 15   — — +
SLM0 Mandate SLM0018 Creditor Identification Code NVARCHAR 25   — — +
SLM0 Mandate SLM0019 Creditor Name NVARCHAR 35   — — +
SLM0 Mandate SLM0020 Creditor Reference Name NVARCHAR 35   — — +
SLM0 Mandate SLM0021 Creditor Identification of Reference Part NVARCHAR 25   — — +
SLM0 Mandate SLM0022 Creditor Address line 1 NVARCHAR 35   — — +
SLM0 Mandate SLM0023 Creditor Address line 2 NVARCHAR 35   — — +
SLM0 Mandate SLM0024 Creditor Address line 3 NVARCHAR 35   — — +
SLM0 Mandate SLM0025 Creditor Address line 4 NVARCHAR 35   — — +
SLM0 Mandate SLM0026 Creditor Address line 5 NVARCHAR 35   — — +
SLM0 Mandate SLM0027 Creditor Address line 6 NVARCHAR 35   — — +
SLM0 Mandate SLM0028 Creditor Address line 7 NVARCHAR 35   — — +
SLM0 Mandate SLM0029 Creditor Country Code NCHAR 3   — — +
SLM0 Mandate SLM0030 Signed Place NVARCHAR 50   — — +
SLM0 Mandate SLM0031 Signed by NVARCHAR 100   — — +
SLM0 Mandate SLM0032 Signed Date DATETIME 8   — — +
SLM0 Mandate SLM0033 E-signature NVARCHAR 256   — — +
SLM0 Mandate SLM0034 Type of Payment NCHAR 1   — — +
SLM0 Mandate SLM0035 Valid from Date DATETIME 8   — — +
SLM0 Mandate SLM0036 Valid to Date DATETIME 8   — — +
SLM0 Mandate SLM0037 Record type NCHAR 1   — — +
SLM0 Mandate SLM0038 Special Comment 1 NVARCHAR 80   — — +
SLM0 Mandate SLM0039 Special Comment 2 NVARCHAR 80   — — +
SLM0 Mandate SLM0040 Special Comment 3 NVARCHAR 80   — — +
SLM0 Mandate SLM0041 Contract Description NVARCHAR 80   — — +
SLM0 Mandate SLM0042 Version number NVARCHAR 10   — — +
SLM0 Mandate SLM0043 Document Language NCHAR 3   — — +
SLM0 Mandate SLM0044 Proposal created by NVARCHAR 8   — — +
SLM0 Mandate SLM0045 Proposal created date DATETIME 8   — — +
SLM0 Mandate SLM0046 Proposal printed by NVARCHAR 8   — — +
SLM0 Mandate SLM0047 Proposal printed date DATETIME 8   — — +
SLM0 Mandate SLM0048 Mandate created by NVARCHAR 8   — — +
SLM0 Mandate SLM0049 Mandate created date DATETIME 8   — — +
SLM0 Mandate SLM0050 Mandate printed by NVARCHAR 8   — — +
SLM0 Mandate SLM0051 Mandate printed date DATETIME 8   — — +
SLM0 Mandate SLM0052 Mandate first used DATETIME 8   — — +
SLM0 Mandate SLM0053 Priority INT 2   — — +
SLM0 Mandate SLM0054 Mandate last used DATETIME 8   — — +
SLM0 Mandate SLM0055 Activated INT 1   — — +
SLM0 Mandate SLM0056 Inactivated by NVARCHAR 8   — — +
SLM0 Mandate SLM0057 Inactivated date DATETIME 8   — — +
SLM0 Mandate SLM0058 Activated by NVARCHAR 8   — — +
SLM0 Mandate SLM0059 Activated date DATETIME 8   — — +
SLM0 Mandate SLM0060 Debtor Post Code NVARCHAR 10   — — +
SLM0 Mandate SLM0061 Debtor City Code NVARCHAR 10   — — +
SLM0 Mandate SLM0062 Creditor Post Code NVARCHAR 10   — — +
SLM0 Mandate SLM0063 Creditor City Code NVARCHAR 10   — — +
SLM0 Mandate SLM0064 Creditor Bank Code NCHAR 2   — — +
SLM0 Mandate SLM0065 Used in proposal INT 1   — — +
SLMH Mandate history SLMH001 Mandate Reference NVARCHAR 35   — — +
SLMH Mandate history SLMH002 Debtor Code NVARCHAR 10   — — +
SLMH Mandate history SLMH003 Debtor name NVARCHAR 35   — — +
SLMH Mandate history SLMH004 Debtor Address line 1 NVARCHAR 35   — — +
SLMH Mandate history SLMH005 Debtor Address line 2 NVARCHAR 35   — — +
SLMH Mandate history SLMH006 Debtor Address line 3 NVARCHAR 35   — — +
SLMH Mandate history SLMH007 Debtor Address line 4 NVARCHAR 35   — — +
SLMH Mandate history SLMH008 Debtor Address line 5 NVARCHAR 35   — — +
SLMH Mandate history SLMH009 Debtor Address line 6 NVARCHAR 35   — — +
SLMH Mandate history SLMH010 Debtor Address line 7 NVARCHAR 35   — — +
SLMH Mandate history SLMH011 Debtor Country Code NCHAR 3   — — +
SLMH Mandate history SLMH012 Debtor ID NVARCHAR 25   — — +
SLMH Mandate history SLMH013 Debtor Reference name NVARCHAR 35   — — +
SLMH Mandate history SLMH014 Debtor Reference ID NVARCHAR 25   — — +
SLMH Mandate history SLMH015 Debtor IBAN account NVARCHAR 34   — — +
SLMH Mandate history SLMH016 Underlying Contract ID NVARCHAR 25   — — +
SLMH Mandate history SLMH017 Debtor Bank BIC code NVARCHAR 15   — — +
SLMH Mandate history SLMH018 Creditor ID NVARCHAR 25   — — +
SLMH Mandate history SLMH019 Creditor name NVARCHAR 35   — — +
SLMH Mandate history SLMH020 Creditor Reference name NVARCHAR 35   — — +
SLMH Mandate history SLMH021 Creditor Reference ID NVARCHAR 25   — — +
SLMH Mandate history SLMH022 Creditor Address line 1 NVARCHAR 35   — — +
SLMH Mandate history SLMH023 Creditor Address line 2 NVARCHAR 35   — — +
SLMH Mandate history SLMH024 Creditor Address line 3 NVARCHAR 35   — — +
SLMH Mandate history SLMH025 Creditor Address line 4 NVARCHAR 35   — — +
SLMH Mandate history SLMH026 Creditor Address line 5 NVARCHAR 35   — — +
SLMH Mandate history SLMH027 Creditor Address line 6 NVARCHAR 35   — — +
SLMH Mandate history SLMH028 Creditor Address line 7 NVARCHAR 35   — — +
SLMH Mandate history SLMH029 Creditor Country Code NCHAR 3   — — +
SLMH Mandate history SLMH030 Signed place NVARCHAR 50   — — +
SLMH Mandate history SLMH031 Signed by NVARCHAR 100   — — +
SLMH Mandate history SLMH032 Signed date DATETIME 8   — — +
SLMH Mandate history SLMH033 E-signature NVARCHAR 256   — — +
SLMH Mandate history SLMH034 Type of payment NCHAR 1   — — +
SLMH Mandate history SLMH035 Valid from date DATETIME 8   — — +
SLMH Mandate history SLMH036 Valid up to date DATETIME 8   — — +
SLMH Mandate history SLMH037 Record Type NCHAR 1   — — +
SLMH Mandate history SLMH038 Special Comment1 NVARCHAR 80   — — +
SLMH Mandate history SLMH039 Special Comment 2 NVARCHAR 80   — — +
SLMH Mandate history SLMH040 Special Comment 3 NVARCHAR 80   — — +
SLMH Mandate history SLMH041 Contract description NVARCHAR 80   — — +
SLMH Mandate history SLMH042 Version Number NVARCHAR 10   — — +
SLMH Mandate history SLMH043 Document language NCHAR 3   — — +
SLMH Mandate history SLMH044 Proposal created by NVARCHAR 8   — — +
SLMH Mandate history SLMH045 Proposal created DATETIME 8   — — +
SLMH Mandate history SLMH046 Proposal printed by NVARCHAR 8   — — +
SLMH Mandate history SLMH047 Proposal printed DATETIME 8   — — +
SLMH Mandate history SLMH048 Mandate created by NVARCHAR 8   — — +
SLMH Mandate history SLMH049 Mandate created DATETIME 8   — — +
SLMH Mandate history SLMH050 Mandate printed by NVARCHAR 8   — — +
SLMH Mandate history SLMH051 Mandate printed DATETIME 8   — — +
SLMH Mandate history SLMH052 Mandate first used DATETIME 8   — — +
SLMH Mandate history SLMH053 Priority INT 2   — — +
SLMH Mandate history SLMH054 Mandate last used DATETIME 8   — — +
SLMH Mandate history SLMH055 Activated INT 1   — — +
SLMH Mandate history SLMH056 Inactivated by NVARCHAR 8   — — +
SLMH Mandate history SLMH057 Inactivated date DATETIME 8   — — +
SLMH Mandate history SLMH058 Activated by NVARCHAR 8   — — +
SLMH Mandate history SLMH059 Activated date DATETIME 8   — — +
SLMH Mandate history SLMH060 Debtor Zip-Code NVARCHAR 10   — — +
SLMH Mandate history SLMH061 Debtor City Code NVARCHAR 10   — — +
SLMH Mandate history SLMH062 Creditor Zip-Code NVARCHAR 10   — — +
SLMH Mandate history SLMH063 Creditor City Code NVARCHAR 10   — — +
SLMH Mandate history SLMH064 Reason code change NCHAR 2   — — +
SLMH Mandate history SLMH065 Mandate changed by NVARCHAR 8   — — +
SLMH Mandate history SLMH066 Mandate changed DATETIME 8   — — +
SLMH Mandate history SLMH067 Reason code delete NCHAR 2   — — +
SLMH Mandate history SLMH068 Mandate deleted by NVARCHAR 8   — — +
SLMH Mandate history SLMH069 Mandate deleted DATETIME 8   — — +
SLMH Mandate history SLMH070 Creditor Bank code NCHAR 2   — — +
SLR4 SL Reversed Transaction SLR4001 Original Transaction Number NCHAR 9   — — +
SLR4 SL Reversed Transaction SLR4002 Reversed Transaction Number NCHAR 9   — — +
SLR4 SL Reversed Transaction SLR4003 Journal Number Original Transaction NVARCHAR 9   — — +
SLR4 SL Reversed Transaction SLR4004 Journal Number Reversed Transaction NVARCHAR 9   — — +
SLT7 Temporary tax table for autopayments SLT7001 Invoice Number NVARCHAR 25   — — +
SLT7 Temporary tax table for autopayments SLT7002 Customer Code NVARCHAR 10   — — +
SLT7 Temporary tax table for autopayments SLT7003 Line Type NVARCHAR 1   — — +
SLT7 Temporary tax table for autopayments SLT7004 Line Number NVARCHAR 15   — — +
SLT7 Temporary tax table for autopayments SLT7005 Tax Type NVARCHAR 6   — — +
SLT7 Temporary tax table for autopayments SLT7006 Base Amount NUMERIC 20 8 — — +
SLT7 Temporary tax table for autopayments SLT7007 Tax Amount NUMERIC 20 8 — — +
SLT7 Temporary tax table for autopayments SLT7008 Rate Code NVARCHAR 2   — — +
SLT7 Temporary tax table for autopayments SLT7009 Rate Percent NUMERIC 12 8 — — +
SLT7 Temporary tax table for autopayments SLT7010 Installment Number INT 3   — — +
SLT7 Temporary tax table for autopayments SLT7011 AdjustedTax NCHAR 1   — — +
SLT7 Temporary tax table for autopayments SLT7012 Actual Tax Base NUMERIC 20 8 — — +
SLT7 Temporary tax table for autopayments SLT7013 Actual Tax Rate NUMERIC 12 8 — — +
SLUL Advanced credit control utilized amounts SLUL001 Order No NCHAR 15   — — +
SLUL Advanced credit control utilized amounts SLUL002 Invoice Customer NCHAR 10   — — +
SLUL Advanced credit control utilized amounts SLUL003 Source module INT 1   — — +
SLUL Advanced credit control utilized amounts SLUL004 Ordered Not Delivered Amount NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL005 Delivered Not Invoiced Amount NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL006 Taxes On Ordered Not Shipped Amount NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL007 Additional Costs (Ordered) NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL008 Taxes On Additional Costs (Ordered) NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL009 Allocated Not Delivered Amount NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL010 Taxes On Allocated Not Delivered Amount NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL011 Taxes On Delivered Not Invoiced Amount NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL012 Additional Costs (Delivered) NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL013 Taxes On Addional Costs (Delivered) NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL014 Draft flag INT 1   — — +
SLUL Advanced credit control utilized amounts SLUL015 Date of Calculation DATETIME 17   — — +
SLUL Advanced credit control utilized amounts SLUL016 WH Taxes On Ordered Not Shipped LCU NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL017 WH Taxes On Add Order Costs LCU NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL018 WH Taxes On Alloc Not Shipped LCU NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL019 WH Taxes On Shipped Not Invoiced LCU NUMERIC 20 8 — — +
SLUL Advanced credit control utilized amounts SLUL020 WH Taxes On Add Shipped Costs LCU NUMERIC 20 8 — — +
SLXX Customer Statement work file SLXX003 InvoiceNo NVARCHAR 25   15   —
SLXX Customer Statement work file SLXX004 PaymentNo NVARCHAR 7   3   —
SLXX Customer Statement work file SLXX005 wotrano NVARCHAR 9   6   —
SLXZ Customer Statement by Date work file SLXZ003 woref NCHAR 7   3   —
SLXZ Customer Statement by Date work file SLXZ004 wotrano NCHAR 9   6   —