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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PL30 — Check Register

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL30001 NVARCHAR VSTRING 15 0 15 CheckNo Check Number   1 Да
PL30002 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number   2 Да
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 VSTRING 50 0 50 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 Да
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      

Навигация: