One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SL27 — Sales Statement

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL27001 NVARCHAR VSTRING 10 0 10 CustCode Customer Code   1 Да / Yes
SL27002 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code Document   2 Да / Yes
SL27003 NVARCHAR VSTRING 10 0 10 SalesStatNo Sales Statement Number   3 Да / Yes
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)      

Навигация / Navigation: