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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SYSM — Report 347 format parameters

Таблица: SYSM — «Report 347 format parameters». Маска имени таблицы: «SYSM%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SYSM001 NVARCHAR VSTRING 4 0 4 FinYear Finansial Year Finansial Year 1 Да
SYSM002 NCHAR STRING 9 0 9 IDFiscal IDFiscal IDFiscal    
SYSM003 NVARCHAR VSTRING 40 0 40 Name Name Name    
SYSM004 NVARCHAR VSTRING 2 0 2 Initial Initial Initial    
SYSM005 NVARCHAR VSTRING 40 0 40 Address Address Address    
SYSM006 NVARCHAR VSTRING 5 0 5 Number Number Number    
SYSM007 NVARCHAR VSTRING 2 0 2 Ladder Ladder Ladder    
SYSM008 NVARCHAR VSTRING 2 0 2 Floor Floor Floor    
SYSM009 NVARCHAR VSTRING 2 0 2 Door Door Door    
SYSM010 NVARCHAR VSTRING 5 0 5 ZipCode Zip Code Zip Code    
SYSM011 NVARCHAR VSTRING 35 0 35 Municipality Municipality Municipality    
SYSM012 NVARCHAR VSTRING 2 0 2 ProvinceCode Province Code Province Code    
SYSM013 NVARCHAR VSTRING 1 0 1 TypeSupport Type Support Type Support    
SYSM014 NVARCHAR VSTRING 9 0 9 Telephone Telephone Telephone    
SYSM015 NVARCHAR VSTRING 40 0 40 PersonContact Person Contact Person Contact    
SYSM016 NVARCHAR VSTRING 13 0 13 NumberVoucherCurrent Number Voucher Current Number Voucher Current    
SYSM017 NVARCHAR VSTRING 1 0 1 ComplementaryVoucher Complementary Voucher Complementary Voucher    
SYSM018 NVARCHAR VSTRING 1 0 1 SubstituteVoucher Substitute Voucher Substitute Voucher    
SYSM019 NVARCHAR VSTRING 13 0 13 NumberVoucherPrevious Number Voucher Previous Number Voucher Previous    
SYSM020 NVARCHAR VSTRING 10 0 10 StatusCodeTax00to09Cust StatusCodeTax (00 to 09) Cust StatusCodeTax (00 to 09) Cust    
SYSM021 NVARCHAR VSTRING 10 0 10 StatusCodeTax10to19Cust StatusCodeTax (10 to 19) Cust StatusCodeTax (10 to 19) Cust    
SYSM022 NVARCHAR VSTRING 10 0 10 StatusCodeTax20to29Cust StatusCodeTax (20 to 29) Cust StatusCodeTax (20 to 29) Cust    
SYSM023 NVARCHAR VSTRING 10 0 10 StatusCodeTax30to39Cust StatusCodeTax (30 to 39) Cust StatusCodeTax (30 to 39) Cust    
SYSM024 NVARCHAR VSTRING 10 0 10 StatusCodeTax40to49Cust StatusCodeTax (40 to 49) Cust StatusCodeTax (40 to 49) Cust    
SYSM025 NVARCHAR VSTRING 10 0 10 StatusCodeTax50to59Cust StatusCodeTax (50 to 59) Cust StatusCodeTax (50 to 59) Cust    
SYSM026 NVARCHAR VSTRING 10 0 10 StatusCodeTax60to69Cust StatusCodeTax (60 to 69)Cust StatusCodeTax (60 to 69)Cust    
SYSM027 NVARCHAR VSTRING 10 0 10 StatusCodeTax70to79Cust StatusCodeTax (70 to 79) Cust StatusCodeTax (70 to 79) Cust    
SYSM028 NVARCHAR VSTRING 10 0 10 StatusCodeTax80to89Cust StatusCodeTax (80 to 89) Cust StatusCodeTax (80 to 89) Cust    
SYSM029 NVARCHAR VSTRING 10 0 10 StatusCodeTax90to99Cust StatusCodeTax (90 to 99) Cust StatusCodeTax (90 to 99) Cust    
SYSM030 NVARCHAR VSTRING 10 0 10 StatusCodeTax00to09Sup StatusCodeTax (00 to 09) Sup StatusCodeTax (00 to 09) Sup    
SYSM031 NVARCHAR VSTRING 10 0 10 StatusCodeTax10to19Sup StatusCodeTax (10 to 19) Sup StatusCodeTax (10 to 19) Sup    
SYSM032 NVARCHAR VSTRING 10 0 10 StatusCodeTax20to29Sup StatusCodeTax (20 to 29) Sup StatusCodeTax (20 to 29) Sup    
SYSM033 NVARCHAR VSTRING 10 0 10 StatusCodeTax30to39Sup StatusCodeTax (30 to 39) Sup StatusCodeTax (30 to 39) Sup    
SYSM034 NVARCHAR VSTRING 10 0 10 StatusCodeTax40to49Sup StatusCodeTax (40 to 49) Sup StatusCodeTax (40 to 49) Sup    
SYSM035 NVARCHAR VSTRING 10 0 10 StatusCodeTax50to59Sup StatusCodeTax (50 to 59) Sup StatusCodeTax (50 to 59) Sup    
SYSM036 NVARCHAR VSTRING 10 0 10 StatusCodeTax60to69Sup StatusCodeTax (60 to 69) Sup StatusCodeTax (60 to 69) Sup    
SYSM037 NVARCHAR VSTRING 10 0 10 StatusCodeTax70to79Sup StatusCodeTax (70 to 79) Sup StatusCodeTax (70 to 79) Sup    
SYSM038 NVARCHAR VSTRING 10 0 10 StatusCodeTax80to89Sup StatusCodeTax (80 to 89) Sup StatusCodeTax (80 to 89) Sup    
SYSM039 NVARCHAR VSTRING 10 0 10 StatusCodeTax90to99Sup StatusCodeTax (90 to 99) Sup StatusCodeTax (90 to 99) Sup    
SYSM040 NUMERIC MONEY 28 8 20 AmountLimit Amount Limit Amount Limit    
SYSM041 NCHAR STRING 1 0 1 DiscVolume Disc volume Disc volume    
SYSM042 NCHAR STRING 10 0 10 CustomerTypeToDeclare Customer Types to declare Customer Types to declare    
SYSM043 NCHAR STRING 10 0 10 SuppTypesToDeclare Supplier Types to declare Supplier Types to declare    
SYSM044 NVARCHAR VSTRING 16 0 16 VATStatementID VAT Statement ID      
SYSM045 NVARCHAR VSTRING 1 0 1 MediaType Media Type      
SYSM046 NVARCHAR VSTRING 1 0 1 AdditionalDeclaration Additional declaration      
SYSM047 NVARCHAR VSTRING 1 0 1 ReplacementDeclaration Replacement declaration      
SYSM048 NVARCHAR VSTRING 13 0 13 PrevDeclarationNum Previous declaration number      
SYSM049 NVARCHAR VSTRING 1 0 1 DiscVolume340 Disc Volume 340      
SYSM050 NUMERIC MONEY 28 8 20 CashLimit Cash Limit      

Навигация: