пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table SL12 — Customer Payment Proposal Header

Таблица / Table: SL12 — «Customer Payment Proposal Header». Маска имени таблицы / Table name mask: «SL12%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL12001 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number   1 Да / Yes
SL12002 NVARCHAR VSTRING 8 0 8 UserIdOwner Owner      
SL12003 NUMERIC MONEY 28 8 20 TransferAmount Transfer Amount (Local Currency)      
SL12004 NUMERIC MONEY 28 8 20 Discount Discount (Local Currency)      
SL12005 DATETIME DATE 0 0 8 CreationDate Date Created      
SL12006 DATETIME DATE 0 0 8 ApprovalDate Date Approved      
SL12007 DATETIME DATE 0 0 8 FirstPrintDate Date First Printed      
SL12008 DATETIME DATE 0 0 8 ReprintDate Date Re-printed      
SL12009 DATETIME DATE 0 0 8 LatestCollectDate Last Collection Date      
SL12010 NUMERIC MONEY 28 8 20 AmPaidPaymCurr Amount Paid (Payment Currency)      
SL12011 NUMERIC MONEY 28 8 20 DiscPaymCurr Discount Amount (Payment Currency)      
SL12012 NCHAR STRING 2 0 2 CodePaymCurr Currency Code Payment      
SL12013 NUMERIC X_NUMERIC 18 8 10 ExchRate1 Exchange Rate 1      
SL12014 NUMERIC X_NUMERIC 18 8 10 ExchRate2 Exchange Rate 2      
SL12015 NCHAR STRING 3 0 3 ExchAlg Exchange Algorithm      
SL12016 DATETIME DATE 0 0 8 UpToInvDueDate Up to Invoice Due Date      
SL12017 DATETIME DATE 0 0 8 PaymBookingDate Payment Date      
SL12018 NCHAR STRING 2 0 2 PaymentWay Payment way      
SL12019 NCHAR STRING 2 0 2 AltPaymentWay Alternative Payment Way      
SL12020 NCHAR STRING 3 0 3 MinCurrCode Minimum Currency Code      
SL12021 NCHAR STRING 3 0 3 MaxCurrCode Maximum Currency Code      
SL12022 NCHAR STRING 10 0 10 MinCustCode Minimum Customer Code      
SL12023 NCHAR STRING 10 0 10 MaxCustCode Maximum Customer Code      
SL12024 NCHAR STRING 4 0 4 MinCatCode Minimum Category Code      
SL12025 NCHAR STRING 4 0 4 MaxCatCode Maximum Category Code      
SL12026 NVARCHAR VSTRING 1 0 1 OtherPaymCurrFlag Other Payment Currency      
SL12027 NCHAR STRING 3 0 3 PaymCurrCode Currency Code Payment      
SL12028 DATETIME DATE 0 0 8 CNoteDueDate Credit Note due date to be included      
SL12029 INT INTEGER 0 0 1 DiscUsageFlag Discount Usage      
SL12030 NVARCHAR ACCSTR 50 0 50 MinAccString Minimum Accounting Dimensions      
SL12031 NVARCHAR ACCSTR 50 0 50 MaxAccString Maximum Accounting Dimensions      
SL12032 DATETIME DATE 0 0 8 PaymNotesPrintedDate Date Payment Notices Printed      
SL12033 NCHAR STRING 2 0 2 CrBankCode Creditor Bank Code      
SL12034 NCHAR STRING 1 0 1 ShowPLBalance Show PL Balance      
SL12035 INT INTEGER 0 0 2 PaymentCurrency2 Payment Currency 2      

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