Название Таблицы / 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 |
|
— |