Таблица: PL50 - «Supplier Payment Proposal Header». Маска имени таблицы: «PL50%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL50001 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number   1 Да
PL50002 NVARCHAR VSTRING 8 0 8 UserIdOwner User      
PL50003 NUMERIC MONEY 28 8 20 TransferAmount Transfer Amount (Local Currency)      
PL50004 NUMERIC MONEY 28 8 20 Discount Discount (Local Currency)      
PL50005 DATETIME DATE 0 0 8 CreationDate Date Created      
PL50006 DATETIME DATE 0 0 8 ApprovalDate Date Approved      
PL50007 DATETIME DATE 0 0 8 FirstPrintDate Date First Printed      
PL50008 DATETIME DATE 0 0 8 ReprintDate Date Reprinted      
PL50009 DATETIME DATE 0 0 8 LatestCollectDate Last Collection Date      
PL50010 NUMERIC MONEY 28 8 20 AmPaidPaymCurr Amount (Payment Currency)      
PL50011 NUMERIC MONEY 28 8 20 DiscPaymCurr Discount (Payment Currency)      
PL50012 NCHAR STRING 2 0 2 PaymCurrCode Currency Code Payment      
PL50013 NUMERIC X_NUMERIC 18 8 10 ExchRate1 Currency Exchange Rate 1      
PL50014 NUMERIC X_NUMERIC 18 8 10 ExchRate2 Currency Exchange Rate 2      
PL50015 NCHAR STRING 3 0 3 ExchAlg Currency Exchange Algorithm      
PL50016 DATETIME DATE 0 0 8 UpToInvDueDate Up-to Invoice Due Date      
PL50017 DATETIME DATE 0 0 8 PaymBookingDate Payment Date      
PL50018 NCHAR STRING 2 0 2 PaymentWay Payment Method      
PL50019 NCHAR STRING 2 0 2 AltPaymentWay Alternative Payment Method      
PL50020 NCHAR STRING 3 0 3 MinCurrCode Minimum Currency Code      
PL50021 NCHAR STRING 3 0 3 MaxCurrCode Maximum Currency Code      
PL50022 NCHAR STRING 10 0 10 MinCustCode Minimum Supplier Code      
PL50023 NCHAR STRING 10 0 10 MaxCustCode Maximum Supplier Code      
PL50024 NCHAR STRING 4 0 4 MinCatCode Minimum Category      
PL50025 NCHAR STRING 4 0 4 MaxCatCode Maximum Category      
PL50026 NVARCHAR VSTRING 1 0 1 OtherPaymCurrFlag Other Payment Currency      
PL50027 NCHAR STRING 3 0 3 PaymCurrCode Currency Code Payment      
PL50028 DATETIME DATE 0 0 8 CNoteDueDate Due Date for Credit Amount      
PL50029 INT INTEGER 0 0 1 DiscUsageFlag Discount Usage      
PL50030 NVARCHAR ACCSTR 50 0 50 MinAccString Accounting String Minimum      
PL50031 NVARCHAR ACCSTR 50 0 50 MaxAccString Accounting String Maximum      
PL50032 DATETIME DATE 0 0 8 PaymNotesPrintedDate Date Payment Note Printed      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Ledger | Payment Proposal Header