пользователям программных продуктов 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 «Purchase Ledger»

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

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL50001 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number   1 Да / Yes
PL50002 NVARCHAR VSTRING 8 0 8 UserIdOwner User      
PL50003 NUMERIC MONEY 28 8 20 TransferAmount Transfer Amount (Local Currency)      
PL50004 NUMERIC MONEY 28 8 20 Discount Discount (Local Currency)      
PL50005 DATETIME DATE 0 0 8 CreationDate Date Created      
PL50006 DATETIME DATE 0 0 8 ApprovalDate Date Approved      
PL50007 DATETIME DATE 0 0 8 FirstPrintDate Date First Printed      
PL50008 DATETIME DATE 0 0 8 ReprintDate Date Reprinted      
PL50009 DATETIME DATE 0 0 8 LatestCollectDate Last Collection Date      
PL50010 NUMERIC MONEY 28 8 20 AmPaidPaymCurr Amount (Payment Currency)      
PL50011 NUMERIC MONEY 28 8 20 DiscPaymCurr Discount (Payment Currency)      
PL50012 NCHAR STRING 2 0 2 CodePaymCurr Currency Code Payment      
PL50013 NUMERIC X_NUMERIC 18 8 10 ExchRate1 Currency Exchange Rate 1      
PL50014 NUMERIC X_NUMERIC 18 8 10 ExchRate2 Currency Exchange Rate 2      
PL50015 NCHAR STRING 3 0 3 ExchAlg Currency Exchange Algorithm      
PL50016 DATETIME DATE 0 0 8 UpToInvDueDate Up-to Invoice Due Date      
PL50017 DATETIME DATE 0 0 8 PaymBookingDate Payment Date      
PL50018 NCHAR STRING 2 0 2 PaymentWay Payment Method      
PL50019 NCHAR STRING 2 0 2 AltPaymentWay Alternative Payment Method      
PL50020 NCHAR STRING 3 0 3 MinCurrCode Minimum Currency Code      
PL50021 NCHAR STRING 3 0 3 MaxCurrCode Maximum Currency Code      
PL50022 NCHAR STRING 10 0 10 MinCustCode Minimum Supplier Code      
PL50023 NCHAR STRING 10 0 10 MaxCustCode Maximum Supplier Code      
PL50024 NCHAR STRING 4 0 4 MinCatCode Minimum Category      
PL50025 NCHAR STRING 4 0 4 MaxCatCode Maximum Category      
PL50026 NVARCHAR VSTRING 1 0 1 OtherPaymCurrFlag Other Payment Currency      
PL50027 NCHAR STRING 3 0 3 PaymCurrCode Currency Code Payment      
PL50028 DATETIME DATE 0 0 8 CNoteDueDate Due Date for Credit Amount      
PL50029 INT INTEGER 0 0 1 DiscUsageFlag Discount Usage      
PL50030 NVARCHAR ACCSTR 50 0 50 MinAccString Accounting String Minimum      
PL50031 NVARCHAR ACCSTR 50 0 50 MaxAccString Accounting String Maximum      
PL50032 DATETIME DATE 0 0 8 PaymNotesPrintedDate Date Payment Note Printed      

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