One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SL21 — Sales Ledger Payments

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL21001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да
SL21002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да
SL21003 NVARCHAR VSTRING 2 0 2 LineNumber Line Number   3 Да
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 15 0 15 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 VSTRING 50 0 50 AccountString Accounting String      
SL21039 NVARCHAR VSTRING 25 0 25 AASReference AAS Reference      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SL21004 6 6 6 6 6 6 9 9 9 9 9 9 9 9
SL21028 15 15 15 15 15 15 15 15 15 15 15 15
SL21029 4 4 4 4 6 6 6 6 6 6 6 6
SL21030 8 8 8 8 8 8 8 8 8 8 8 8
SL21031 0 3 0 3 0 3 0 3 0 3 0 3
SL21032 0 1 0 1 0 1 0 1
SL21033 1 1 1 1 1 1
SL21034 38 38
SL21035 20 20
SL21036 1 1
SL21037 1 1
SL21038 50 50
SL21039 25 25

Навигация: