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

Таблица: SL29 - «Invoice Consolidation History». Маска имени таблицы: «SL29%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL29001 NCHAR STRING 10 0 10 Customer_Code Customer Code   1 Да
SL29002 NCHAR STRING 2 0 2 CurrCode Currency Code Document   2 Да
SL29003 NCHAR STRING 15 0 15 InvoiceNo_Consolidated Invoice Number   3 Да
SL29004 NCHAR STRING 15 0 15 InvoiceNo_Reference Invoice Reference Number   4 Да
SL29005 NCHAR STRING 9 0 9 TransactionNo Transaction Number      
SL29006 DATETIME DATE 0 0 8 Date_Invoice_Original Original Invoice Date      
SL29007 NUMERIC MONEY 28 8 20 Amount_Invoice_Original_LCU Original Invoice Amount (Local Currency)      
SL29008 NUMERIC MONEY 28 8 20 Amount_Invoice_Original_OCU Original Invoice Amount (Document Currency)      
SL29009 NUMERIC MONEY 28 8 20 Amount_Sales_TAX Sales Tax Amount (Local Currency)      
SL29010 NVARCHAR VSTRING 20 0 20 Text_Commentary Commentary Text      
SL29011 NCHAR STRING 1 0 1 Flag_UseField23 (obsolete)      
SL29012 NCHAR STRING 3 0 3 SalesMan Salesman      
SL29013 DATETIME DATE 0 0 8 Date_Invoice Invoice Date      
SL29014 NVARCHAR ACCSTR 50 0 50 Account_String Accounting String      
SL29015 NCHAR STRING 1 0 1 Slip_Type Slip Type 0 - Normal invoice
1 - Discount
2 - Cash discount		    
SL29016 NCHAR STRING 1 0 1 Source_Module_Sign Source Module Type Specifies the module where the merge invoice was created:
0 - Sales order
1 - Project
2 - Service Order		    
SL29017 NCHAR STRING 1 0 1 Flag_Merge_Proposal_Printed Merge Proposal Printed      
SL29018 NCHAR STRING 1 0 1 Merge_Type Merge Type 1 - Merge/Consolidate per week
2 - Merge/Consolidate per month		    
SL29019 NVARCHAR VSTRING 20 0 20 Reference_Customer Customer Reference      
SL29020 NVARCHAR VSTRING 20 0 20 Reference_Our Our Reference      
SL29021 NVARCHAR VSTRING 6 0 6 SubObjectNo Source Sub-object For merge invoices created from project management, this field will hold the sub-project code if invoicing was done on sub-project level.    
SL29022 NVARCHAR VSTRING 25 0 25 Text_Line_1 Text Line 1      
SL29023 NVARCHAR VSTRING 25 0 25 Text_Line_2 Text Line 2      
SL29024 NCHAR STRING 2 0 2 TAX_Code VAT Code      
SL29025 NUMERIC X_NUMERIC 18 8 10 ExchgRate1 Exchange Rate 1      
SL29026 NUMERIC X_NUMERIC 18 8 10 ExchgRate2 Exchange Rate 2      
SL29027 NCHAR STRING 3 0 3 Exchange Algorithm Exchange Algorithm      
SL29028 NVARCHAR VSTRING 12 0 12 ObjectNo Source Object Value is dependent on the source module type (SL29016) and can be a sales order, service order or a project number.    
SL29029 NCHAR STRING 6 0 6 LiabilityCode LiabilityCode      
SL29030 NCHAR STRING 2 0 2 OrigPaymTerm OrigPaymTerm Payment Term from sales order    
SL29031 NCHAR STRING 2 0 2 ActPaymTerm ActPaymTerm Payment Term used in consolidated invoice    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Sales Ledger | Invoice Consolidation History