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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SLDS — Portuguese Digital Signature

Таблица: SLDS — «Portuguese Digital Signature». Маска имени таблицы: «SLDS%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLDS001 NCHAR STRING 10 0 10 CustomerCode Customer Code Customer Code 1 Да
SLDS002 NCHAR STRING 15 0 15 InvNumSL Invoice Number (SL side) Invoice Number (SL side) 2 Да
SLDS003 NCHAR STRING 4 0 4 Year Year Year 3 Да
SLDS004 INT INTEGER 0 0 2 Source Source Source    
SLDS005 NCHAR STRING 1 0 1 CreditNote Credit Note Credit Note    
SLDS006 NCHAR STRING 1 0 1 History History History    
SLDS007 NVARCHAR VSTRING 6 0 6 InvoiceIssuer Invoice Issuer Invoice Issuer    
SLDS008 NCHAR STRING 1 0 1 InvoiceCategory Invoice Category Invoice Category    
SLDS009 NCHAR STRING 1 0 1 InvoiceType Invoice Type Invoice Type    
SLDS010 DATETIME X_DATETIME 0 0 17 DateAndTime Date and Time Date and Time    
SLDS011 NVARCHAR VSTRING 10 0 10 CustCodePrevDoc Customer code (previous doc.) Customer code (previous doc.)    
SLDS012 NVARCHAR VSTRING 15 0 15 InvNumPrevDoc Invoice number (previous doc.) Invoice number (previous doc.)    
SLDS013 NVARCHAR VSTRING 200 0 200 DigitalSignature Digital singature Digital singature    
SLDS014 NVARCHAR VSTRING 100 0 100 SerNumKey Serial number of key Serial number of key    
SLDS015 INT INTEGER 0 0 9 SeqWithinSeries Sequence within series Sequence within series    
SLDS016 INT INTEGER 0 0 9 VersionNumber Version Number Version Number    
SLDS017 NVARCHAR VSTRING 256 0 256 OriginalString Original String Original String used to calculate the invoice signature    
SLDS018 NVARCHAR VSTRING 50 0 50 FiscalKeyCAECode Fiscal Key/CAE Code Fiscal Key/CAE Code    
SLDS019 DATETIME X_DATETIME 0 0 17 CAEExpiryDate CAE expiration date CAE expiration date    
SLDS020 NVARCHAR VSTRING 1024 0 1024 CAEComment CAE Comment CAE Comment    
SLDS021 INT INTEGER 0 0 2 FiscalKeyCAEStatus Fiscal Key/CAE Status      
SLDS022 NCHAR STRING 10 0 10 FiscalKeyRequestNumber Fiscal Key Request Number Fiscal Key Request Number    
SLDS023 NVARCHAR VSTRING 20 0 20 FiscalKeyProtocolNo Fiscal Key Protocol No Fiscal Key Protocol No    
SLDS024 DATETIME X_DATETIME 0 0 17 FiscalKeyProtocolDate Fiscal Key Protocol Date Fiscal Key Protocol Date    

Навигация: