One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SL27 — Sales Statement

Таблица: SL27 — «Sales Statement». Маска имени таблицы: «SL27%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL27001 NVARCHAR VSTRING 10 0 10 CustCode Customer Code   1 Да
SL27002 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code Document   2 Да
SL27003 NVARCHAR VSTRING 10 0 10 SalesStatNo Sales Statement Number   3 Да
SL27004 DATETIME DATE 0 0 8 SalesStatDate Sales Statement Date      
SL27005 NUMERIC MONEY 28 8 20 PrevBillAmLoc Previous Billed Amount (Local Currency)      
SL27006 NUMERIC MONEY 28 8 20 PrevBillAmOrig Previous Billed Amount (Document Currency)      
SL27007 NUMERIC MONEY 28 8 20 MatchPaymPerLoc Matched Payments Period (Local Currency)      
SL27008 NUMERIC MONEY 28 8 20 MatchPaymPerOrig Matched Payments Period (Document Currency)      
SL27009 NUMERIC MONEY 28 8 20 AccPaymRecLoc On Account Payments Received YTD (Local Currency)      
SL27010 NUMERIC MONEY 28 8 20 AccPaymRecOrig On Account Payments Received YTD (Document Currency)      
SL27011 NUMERIC MONEY 28 8 20 TaxSalesPerLoc Taxable Sales Period (Local Currency)      
SL27012 NUMERIC MONEY 28 8 20 TaxSalesPerOrig Taxable Sales Period (Document Currency)      
SL27013 NUMERIC MONEY 28 8 20 NonTaxSalesPerLoc Non-taxable Sales Period (Local Currency)      
SL27014 NUMERIC MONEY 28 8 20 NonTaxSalesPerOrig Non-taxable Sales Period (Document Currency)      
SL27015 NUMERIC MONEY 28 8 20 SalesTaxAm Sales Tax Amount (Local Currency)      
SL27016 NUMERIC MONEY 28 8 20 TaxCNotesPerLoc Taxable of Credit Notes Period (Local Currency)      
SL27017 NUMERIC MONEY 28 8 20 TaxCNotesPerOrig Taxable of Credit Notes Period (Document Currency)      
SL27018 NUMERIC MONEY 28 8 20 NonTaxCNotesPerLoc Non-Taxable of Credit Notes Period (Local Currency)      
SL27019 NUMERIC MONEY 28 8 20 NonTaxCNotesPerOrig Non-Taxable of Credit Notes Period (Document Currency)      
SL27020 NUMERIC MONEY 28 8 20 TaxCNotesPer Tax of Credit Notes Period (Local Currency)      
SL27021 NUMERIC MONEY 28 8 20 TaxRebatesPerLoc Taxable Discounts Period (Local Currency)      
SL27022 NUMERIC MONEY 28 8 20 TaxRebatesPerOrig Taxable Discounts Period (Document Currency)      
SL27023 NUMERIC MONEY 28 8 20 NonTaxRebatesPerLoc Non-taxable Discounts Period (Local Currency)      
SL27024 NUMERIC MONEY 28 8 20 NonTaxRebatesPerOrig Non-taxable Discounts Period (Document Currency)      
SL27025 NUMERIC MONEY 28 8 20 TaxRebatesPer Tax of Discounts Period (Local Currency)      
SL27026 NUMERIC MONEY 28 8 20 PrevPerARbalOrg Previous Period AR Balance (Document Currency)      
SL27027 NUMERIC MONEY 28 8 20 CurrentPerARbalOrg Current Period AR Balance (Document Currency)      
SL27028 NUMERIC MONEY 28 8 20 Spare (obsolete)      
SL27029 NUMERIC MONEY 28 8 20 Spare (obsolete)      
SL27030 NUMERIC MONEY 28 8 20 Spare (obsolete)      
SL27031 NUMERIC MONEY 28 8 20 GrossBillAmLoc Gross Billed Amount (Local Currency)      
SL27032 NUMERIC MONEY 28 8 20 GrossBillAmOrig Gross Billed Amount (Document Currency)      
SL27033 NUMERIC MONEY 28 8 20 NonTaxBillAmLoc Non-taxable Billed Amount (Local Currency)      
SL27034 NUMERIC MONEY 28 8 20 NonTaxBillAmOrig Non-taxable Billed Amount (Document Currency)      
SL27035 NUMERIC MONEY 28 8 20 TotalTaxAm Tax Amount (Local Currency)      
SL27036 NUMERIC MONEY 28 8 20 TotalTaxVar Tax Variance Amount (Local Currency)      
SL27037 NUMERIC MONEY 28 8 20 PaidAmountLoc Paid Amount (Local Currency)      
SL27038 NUMERIC MONEY 28 8 20 PaidAmountOrig Paid Amount (Document Currency)      
SL27039 DATETIME DATE 0 0 8 DueDatePaym Due Date for Payment      
SL27040 DATETIME DATE 0 0 8 DiscountDate1 Discount Date 1      
SL27041 NVARCHAR VSTRING 5 0 5 DiscountPerc1 Discount 1 %      
SL27042 DATETIME DATE 0 0 8 DiscountDate2 Discount Date 2      
SL27043 NVARCHAR VSTRING 5 0 5 DiscountPerc2 Discount 2 %      
SL27044 DATETIME DATE 0 0 8 DiscountDate3 Discount Date 3      
SL27045 NVARCHAR VSTRING 5 0 5 DiscountPerc3 Discount 3 %      
SL27046 DATETIME DATE 0 0 8 SummPerStartDate Summarizing Period Start date      
SL27047 DATETIME DATE 0 0 8 SummPerEndDate Summarizing Period End date      
SL27048 NUMERIC MONEY 28 8 20 PrevPerARbalLoc Previous Period AR Balance (Local Currency)      
SL27049 NUMERIC MONEY 28 8 20 CurrentPerARbalLoc Current Period AR Balance (Local Currency)      

Навигация: