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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table SL21 — Sales Ledger Payments

Таблица / Table: SL21 — «Sales Ledger Payments». Маска имени таблицы / Table name mask: «SL21%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL21001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SL21002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да / Yes
SL21003 NVARCHAR VSTRING 6 0 6 LineNumber Line Number   3 Да / Yes
SL21004 NVARCHAR VSTRING 9 0 9 TransactNo Transaction Number      
SL21005 DATETIME DATE 0 0 8 TransactDate Transaction Date      
SL21006 DATETIME DATE 0 0 8 BookEntryDate Book Entry Date      
SL21007 NUMERIC MONEY 28 8 20 AmountLocCur Amount (Local Currency)      
SL21008 NUMERIC MONEY 28 8 20 AmountOriCur Amount (Invoice Currency)      
SL21009 NVARCHAR VSTRING 1 0 1 RecFlag Receipt Document Status 0 — Not printed

1 — Receipt printed
   
SL21010 NVARCHAR VSTRING 25 0 25 CheckNumber Check Number      
SL21011 NVARCHAR VSTRING 2 0 2 PayTransCode Payment Transaction Code      
SL21012 NVARCHAR VSTRING 10 0 10 PayRemark Payment Remark      
SL21013 NUMERIC MONEY 28 8 20 DiscountTaken Discount Taken (Local Currency)      
SL21014 NUMERIC X_NUMERIC 18 8 10 ExchgRate1 Exchange Rate 1      
SL21015 NUMERIC X_NUMERIC 18 8 10 ExchgRate2 Exchange Rate 2      
SL21016 NCHAR STRING 3 0 3 ExchgAlgtm Exchange Algorithm      
SL21017 INT INTEGER 0 0 2 CurrencyCode Currency Code Invoice      
SL21018 NUMERIC MONEY 28 8 20 DiscountTakenICU Discount Taken (Invoice Currency)      
SL21019 NUMERIC MONEY 28 8 20 PaymentCurrAmo Amount (Payment Currency)      
SL21020 NUMERIC MONEY 28 8 20 DiscInPaymCurr Discount Taken (Payment Currency)      
SL21021 INT INTEGER 0 0 2 PaymCurrCode Currency Code Payment      
SL21022 NUMERIC MONEY 28 8 20 AmPaidPNLoc Amount Paid by PN/PDC (Local Currency)      
SL21023 NUMERIC MONEY 28 8 20 AmPaidPNOrig Amount Paid by PN/PDC (Document Currency)      
SL21024 INT INTEGER 0 0 1 PaymentType Payment Type 0=Payment

1=Revaluation

2=Withholding Tax
   
SL21025 NUMERIC MONEY 28 8 20 RealisedGainsLosses Realised Gains/Losses      
SL21026 NUMERIC MONEY 28 8 20 UnrealizedGains Unrealized Gains      
SL21027 NUMERIC MONEY 28 8 20 UnrealizedLosses Unrealized Losses      
SL21028 NVARCHAR VSTRING 15 0 15 ReceiptNum Receipt number      
SL21029 NVARCHAR VSTRING 6 0 6 IssuerCode Issuer code      
SL21030 NVARCHAR VSTRING 8 0 8 FormNumber Form number      
SL21031 INT INTEGER 0 0 3 InstalmentNumber InstalmentNumber      
SL21032 INT INTEGER 0 0 1 LockPaymentsInvoices Lock Payments Invoices 0 ? Default. Payment can be matched against invoices or Sales Orders.

1 ? Payment is ?locked? for linking to Sales Order or to matching against invoices.
   
SL21033 NCHAR SWITCH 1 0 1 Reconciled Reconciled      
SL21034 NVARCHAR VSTRING 38 0 38 RemittanceLink Remittance Link      
SL21035 NVARCHAR VSTRING 20 0 20 PrepaymLink Prepayment Link      
SL21036 NCHAR STRING 1 0 1 LinkType Link Type      
SL21037 NCHAR STRING 1 0 1 VoidingStatus Voiding Status      
SL21038 NVARCHAR ACCSTR 120 0 120 AccountString Accounting String      
SL21039 NVARCHAR VSTRING 25 0 25 AASReference AAS Reference      
SL21040 NCHAR STRING 1 0 1 PaymentType Payment Type      

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