Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 NVARCHAR VSTRING 20 0 20 AmoPaidPaymentCurr AmoPaidPaymentCurr      
PLSE011 NVARCHAR VSTRING 20 0 20 DscAmoPaymentCurr DscAmoPaymentCurr      
PLSE012 NVARCHAR VSTRING 20 0 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 BankAccountNum Bank account number      
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 NCHAR STRING 10 0 10 PaymentID PaymentID      
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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | SEPA CRT payments and receipts