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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PLSE — SEPA CRT payments and receipts

Таблица / Table: PLSE — «SEPA CRT payments and receipts». Маска имени таблицы / Table name mask: «PLSE%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PLSE001 NCHAR STRING 10 0 10 SupplierCode Supplier Code      
PLSE002 NCHAR STRING 25 0 25 InvoiceNo Invoice No      
PLSE003 NCHAR STRING 1 0 1 PaymentBlock Payment Block      
PLSE004 NUMERIC MONEY 28 8 20 AmountPaidInvCur AmountPaidInvCur      
PLSE005 NUMERIC MONEY 28 8 20 DiscountAmountInvCur DiscountAmountInvCur      
PLSE006 DATETIME DATE 0 0 8 CalcuDueDate CalcuDueDate      
PLSE007 NUMERIC MONEY 28 8 20 WHTaxAmountInvCur WHTaxAmountInvCur      
PLSE008 NCHAR STRING 8 0 8 Code Code      
PLSE009 NCHAR STRING 2 0 2 WayOfPayment WayOfPayment      
PLSE010 NUMERIC MONEY 28 8 20 AmoPaidPaymentCurr AmoPaidPaymentCurr      
PLSE011 NUMERIC MONEY 28 8 20 DscAmoPaymentCurr DscAmoPaymentCurr      
PLSE012 NUMERIC MONEY 28 8 20 WHoldTaxPayCurrency WHoldTaxPayCurrency      
PLSE013 INT INTEGER 0 0 2 PaymentCurrencyCode PaymentCurrencyCode      
PLSE014 NUMERIC X_NUMERIC 18 8 10 ExchangeRate1 ExchangeRate1      
PLSE015 NUMERIC X_NUMERIC 18 8 10 ExchangeRate2 ExchangeRate2      
PLSE016 NCHAR STRING 3 0 3 ExchnageAlgorithm ExchnageAlgorithm      
PLSE017 NVARCHAR VSTRING 50 0 50 PaymentDetails PaymentDetails      
PLSE018 INT INTEGER 0 0 3 INstallmentNumber INstallmentNumber      
PLSE019 NVARCHAR VSTRING 6 0 6 PaymentOrdNum Payment order number      
PLSE020 NVARCHAR VSTRING 6 0 6 ChequeNumber Cheque number      
PLSE021 NCHAR SWITCH 1 0 1 PaymentOrdApproved Payment order approved      
PLSE022 NVARCHAR VSTRING 34 0 34 DebtorAccount Debtor Account      
PLSE023 NVARCHAR VSTRING 30 0 30 Spare Spare      
PLSE024 NCHAR STRING 2 0 2 InvoiceCurrencyCode Invoice Currency Code      
PLSE025 NCHAR STRING 2 0 2 BankAccountCurrCode Bank account currency code      
PLSE026 NVARCHAR VSTRING 10 0 10 PaymentDetailID Payment Detail ID      
PLSE027 NCHAR STRING 6 0 6 PaymentTaxLiabilityCode Payment Tax Liability Code      
PLSE028 NVARCHAR VSTRING 35 0 35 OrigMesID OrigMesID      
PLSE029 DATETIME X_DATETIME 0 0 17 OrigCreDtTm OrigCreDtTm      
PLSE030 NVARCHAR VSTRING 35 0 35 OrigEndToEndId OrigEndToEndId      
PLSE031 INT INTEGER 0 0 1 StepStatus StepStatus      
PLSE032 NCHAR STRING 4 0 4 GroupStatus Group Status      
PLSE033 NCHAR STRING 4 0 4 GrStatusReasonCd GrStatusReasonCd      
PLSE034 NVARCHAR VSTRING 35 0 35 GrStatusReasonTxt GrStatusReasonTxt      
PLSE035 NCHAR STRING 4 0 4 TransStatus TransStatus      
PLSE036 NCHAR STRING 4 0 4 TrStatusReasonCd TrStatusReasonCd      
PLSE037 NVARCHAR VSTRING 35 0 35 TrStatusReasonTxt TrStatusReasonTxt      
PLSE038 NCHAR SWITCH 1 0 1 ConversToPaymCur ConversToPaymCur      
PLSE039 NCHAR STRING 10 0 10 PaymentProposal Payment Proposal      
PLSE040 NVARCHAR VSTRING 4 0 4 ChargeBearer Charge Bearer      
PLSE041 NVARCHAR VSTRING 35 0 35 PaymentID Payment ID      
PLSE042 INT INTEGER 0 0 2 DebtorAccountType Debtor Account Type      
PLSE043 NCHAR STRING 2 0 2 SubType Sub-Type      
PLSE044 NVARCHAR VSTRING 11 0 11 BICCreditorAccountsBank BIC — Creditor Account’s Bank      
PLSE045 NVARCHAR VSTRING 35 0 35 CreditorAccount Creditor Account      
PLSE046 NCHAR STRING 2 0 2 CreditorAccountType Creditor Account Type      
PLSE047 INT INTEGER 0 0 1 PaymentPriority Payment Priority      
PLSE048 NCHAR STRING 4 0 4 CentralBankCode Central Bank Code      
PLSE049 NVARCHAR VSTRING 50 0 50 InvoiceComment Invoice Comment      
PLSE050 NCHAR STRING 5 0 5 ClearingSystemIDCreditorBank Clearing System ID – Creditor Bank      
PLSE051 NVARCHAR VSTRING 35 0 35 ClearingMemberIDCreditorBank Clearing Member ID – Creditor Bank      
PLSE052 INT INTEGER 0 0 1 CreditSplitStatus Credit Split Status      
PLSE053 INT INTEGER 0 0 1 PMAASReference PM AAS Reference      
PLSE054 NVARCHAR ACCSTR 120 0 120 GLAccount GL Account      
PLSE055 NVARCHAR VSTRING 10 0 10 AltGrouping1 Alt Grouping 1      
PLSE056 NVARCHAR VSTRING 10 0 10 AltGrouping2 Alt Grouping 2      
PLSE057 NCHAR STRING 3 0 3 OriginalInstalmentNum Original instalment number      

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