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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PLSE001 NCHAR STRING 10 0 10 Supplier Code Supplier Code      
PLSE002 NCHAR STRING 15 0 15 Invoice No Invoice No      
PLSE003 NCHAR STRING 1 0 1 Payment Block 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 Payment order number Payment order number      
PLSE020 NVARCHAR VSTRING 6 0 6 Cheque number Cheque number      
PLSE021 NCHAR SWITCH 1 0 1 Payment order approved Payment order approved      
PLSE022 NVARCHAR VSTRING 34 0 34 Bank account number Bank account number      
PLSE023 NVARCHAR VSTRING 30 0 30 Spare Spare      
PLSE024 NCHAR STRING 2 0 2 Invoice Currency Code Invoice Currency Code      
PLSE025 NCHAR STRING 2 0 2 Bank account currency code Bank account currency code      
PLSE026 NCHAR STRING 10 0 10 PaymentID PaymentID      
PLSE027 NCHAR STRING 6 0 6 Payment Tax Liability Code 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 Group Status 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 2.3 SR2 - 2.03.10355 | Purchase Ledger | SEPA CRT payments and receipts