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

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SLDS — Portuguese Digital Signature

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLDS001 NCHAR STRING 10 0 10 CustomerCode Customer Code Customer Code 1 Да / Yes
SLDS002 NCHAR STRING 15 0 15 InvNumSL Invoice Number (SL side) Invoice Number (SL side) 2 Да / Yes
SLDS003 NCHAR STRING 4 0 4 Year Year Year 3 Да / Yes
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    

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