One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SLD2 — Customer Payment Proposal Header History

Таблица / Table: SLD2 — «Customer Payment Proposal Header History». Маска имени таблицы / Table name mask: «SLD2%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLD2001 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number   1 Да / Yes
SLD2002 NVARCHAR VSTRING 8 0 8 UserIdOwner Owner      
SLD2003 NUMERIC MONEY 28 8 20 TransferAmount Transfer Amount (Local Currency)      
SLD2004 NUMERIC MONEY 28 8 20 Discount Discount (Local Currency)      
SLD2005 DATETIME DATE 0 0 8 CreationDate Date Created      
SLD2006 DATETIME DATE 0 0 8 ApprovalDate Date Approved      
SLD2007 DATETIME DATE 0 0 8 FirstPrintDate Date First Printed      
SLD2008 DATETIME DATE 0 0 8 ReprintDate Date Re-printed      
SLD2009 DATETIME DATE 0 0 8 LatestCollectDate Last Collection Date      
SLD2010 NUMERIC MONEY 28 8 20 AmPaidPaymCurr Amount Paid (Payment Currency)      
SLD2011 NUMERIC MONEY 28 8 20 DiscPaymCurr Discount Amount (Payment Currency)      
SLD2012 NCHAR STRING 2 0 2 PaymCurrCode Currency Code Payment      
SLD2013 NUMERIC X_NUMERIC 18 8 10 ExchRate1 Exchange Rate 1      
SLD2014 NUMERIC X_NUMERIC 18 8 10 ExchRate2 Exchange Rate 2      
SLD2015 NCHAR STRING 3 0 3 ExchAlg Exchange Algorithm      
SLD2016 DATETIME DATE 0 0 8 UpToInvDueDate Up to Invoice Due Date      
SLD2017 DATETIME DATE 0 0 8 PaymBookingDate Payment Date      
SLD2018 NCHAR STRING 2 0 2 PaymentWay Payment Way      
SLD2019 NCHAR STRING 2 0 2 AltPaymentWay Alternative Payment Way      
SLD2020 NCHAR STRING 3 0 3 MinCurrCode Minimum Currency Code      
SLD2021 NCHAR STRING 3 0 3 MaxCurrCode Maximum Currency Code      
SLD2022 NCHAR STRING 10 0 10 MinCustCode Minimum Customer Code      
SLD2023 NCHAR STRING 10 0 10 MaxCustCode Maximum Customer Code      
SLD2024 NCHAR STRING 4 0 4 MinCatCode Minimum Category Code      
SLD2025 NCHAR STRING 4 0 4 MaxCatCode Maximum Category Code      
SLD2026 NCHAR STRING 1 0 1 OtherPaymCurrFlag Other Payment Currency      
SLD2027 NCHAR STRING 3 0 3 PaymentCurrCode Currency Code Payment      
SLD2028 DATETIME DATE 0 0 8 CNoteDueDate Credit Note due date to be included      
SLD2029 INT INTEGER 0 0 1 DiscUsageFlag Discount Usage      
SLD2030 NVARCHAR ACCSTR 120 0 120 MinAccString Minimum Accounting Dimensions      
SLD2031 NVARCHAR ACCSTR 120 0 120 MaxAccString Maximum Accounting Dimensions      
SLD2032 DATETIME DATE 0 0 8 PaymNotesPrintedDate Date Payment Notices Printed      
SLD2033 NCHAR STRING 2 0 2 CrBankCode Creditor Bank Code      
SLD2034 NCHAR STRING 1 0 1 ShowPLBalance Show PL Balance      
SLD2035 INT INTEGER 0 0 2 PaymentCurrency2 Payment Currency 2      

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