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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PL30 — Check Register

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL30001 NVARCHAR VSTRING 15 0 15 CheckNo Check Number   1 Да / Yes
PL30002 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number   2 Да / Yes
PL30003 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PL30004 NVARCHAR VSTRING 9 0 9 TransactNo Transaction Number      
PL30005 DATETIME DATE 0 0 8 PaymentDate Payment Date      
PL30006 NUMERIC MONEY 28 8 20 PaidAmount Paid Amount (Invoice Currency)      
PL30007 NUMERIC MONEY 28 8 20 InvoiceAmount Invoice Amount (Invoice Currency)      
PL30008 NVARCHAR ACCSTR 120 0 120 AccountString AccountString bank accounting

string
   
PL30009 NVARCHAR VSTRING 15 0 15 CommentText Text      
PL30010 NVARCHAR VSTRING 36 0 36 TransText Transaction Text      
PL30011 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Invoice      
PL30012 NUMERIC MONEY 28 8 20 DiscountAmnt Discount Amount (Invoice Currency)      
PL30013 NUMERIC MONEY 28 8 20 AmountPaid Amount Paid (Payment Currency)      
PL30014 NUMERIC MONEY 28 8 20 DiscountAmount Discount Amount (Payment Currency)      
PL30015 INT INTEGER 0 0 2 PaymentCurrencyCode Currency Code Payment      
PL30016 NVARCHAR VSTRING 1 0 1 ReconciliationFlag Flag of Cheque Reconciliation 0-no reconciliated (ready) 1-reconciliated    
PL30017 NCHAR SWITCH 1 0 1 Voided Voided Voiding flag

0-Normal

1-Voided
   
PL30018 INT INTEGER 0 0 3 InstalmentNumber Instalment Number   3 Да / Yes
PL30019 NVARCHAR VSTRING 6 0 6 PaymentOrdNum Payment order number      
PL30020 NVARCHAR VSTRING 1 0 1 Type Type Type    
PL30021 NVARCHAR VSTRING 10 0 10 BankCode Bank Code Bank Code    
PL30022 NVARCHAR VSTRING 7 0 7 ChequeNumber Cheque Number Cheque Number (Spain)    
PL30023 NVARCHAR VSTRING 1 0 1 ChequeNumberControlDigit Cheque Number Control Digit Cheque Number Control Digit    
PL30024 DATETIME DATE 0 0 8 DateEmission Date Emission Date Emission    
PL30025 DATETIME DATE 0 0 8 DueDate Due Date Due Date    
PL30026 NVARCHAR VSTRING 1 0 1 Printed Printed Printed    
PL30027 NVARCHAR VSTRING 2 0 2 ChequeSeries Cheque Series Cheque Series    
PL30028 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
PL30029 NCHAR SWITCH 1 0 1 PartiallyVoided Partially Voided      
PL30030 NVARCHAR VSTRING 10 0 10 PaymentProposal Payment Proposal      

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