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

Таблица: SL21 - «Sales Ledger Payments». Маска имени таблицы: «SL21%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL21001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да
SL21002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да
SL21003 NVARCHAR VSTRING 2 0 2 LineNumber Line Number   3 Да
SL21004 NVARCHAR VSTRING 6 0 6 TransactNo Transaction Number      
SL21005 DATETIME DATE 0 0 8 TransactDate Transaction Date      
SL21006 DATETIME DATE 0 0 8 BookEntryDate Book Entry Date      
SL21007 NUMERIC MONEY 28 8 20 AmountLocCur Amount (Local Currency)      
SL21008 NUMERIC MONEY 28 8 20 AmountOriCur Amount (Invoice Currency)      
SL21009 NVARCHAR VSTRING 1 0 1 RecFlag Receipt Document Status 0 - Not printed
1 - Receipt printed		    
SL21010 NVARCHAR VSTRING 15 0 15 CheckNumber Check Number      
SL21011 NVARCHAR VSTRING 2 0 2 PayTransCode Payment Transaction Code      
SL21012 NVARCHAR VSTRING 10 0 10 PayRemark Payment Remark      
SL21013 NUMERIC MONEY 28 8 20 DiscountTaken Discount Taken (Local Currency)      
SL21014 NUMERIC X_NUMERIC 18 8 10 ExchgRate1 Exchange Rate 1      
SL21015 NUMERIC X_NUMERIC 18 8 10 ExchgRate2 Exchange Rate 2      
SL21016 NCHAR STRING 3 0 3 ExchgAlgtm Exchange Algorithm      
SL21017 INT INTEGER 0 0 2 CurrencyCode Currency Code Invoice      
SL21018 NUMERIC MONEY 28 8 20 DiscountTaken Discount Taken (Invoice Currency)      
SL21019 NUMERIC MONEY 28 8 20 PaymentCurrAmo Amount (Payment Currency)      
SL21020 NUMERIC MONEY 28 8 20 DiscInPaymCurr Discount Taken (Payment Currency)      
SL21021 INT INTEGER 0 0 2 PaymCurrCode Currency Code Payment      
SL21022 NUMERIC MONEY 28 8 20 AmPaidPNLoc Amount Paid by PN/PDC (Local Currency)      
SL21023 NUMERIC MONEY 28 8 20 AmPaidPNOrig Amount Paid by PN/PDC (Document Currency)      
SL21024 INT INTEGER 0 0 1 PaymentType Payment Type 0=Payment
1=Revaluation
2=Withholding Tax		    
SL21025 NUMERIC MONEY 28 8 20 RealisedGainsLosses Realised Gains/Losses      
SL21026 NUMERIC MONEY 28 8 20 UnrealizedGains Unrealized Gains      
SL21027 NUMERIC MONEY 28 8 20 UnrealizedLosses Unrealized Losses      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Sales Ledger Payments