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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SYSM001 NVARCHAR VSTRING 4 0 4 Finansial Year 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 Zip Code Zip Code Zip Code    
SYSM011 NVARCHAR VSTRING 35 0 35 Municipality Municipality Municipality    
SYSM012 NVARCHAR VSTRING 2 0 2 Province Code Province Code Province Code    
SYSM013 NVARCHAR VSTRING 1 0 1 Type Support Type Support Type Support    
SYSM014 NVARCHAR VSTRING 9 0 9 Telephone Telephone Telephone    
SYSM015 NVARCHAR VSTRING 40 0 40 Person Contact Person Contact Person Contact    
SYSM016 NVARCHAR VSTRING 13 0 13 Number Voucher Current Number Voucher Current Number Voucher Current    
SYSM017 NVARCHAR VSTRING 1 0 1 Complementary Voucher Complementary Voucher Complementary Voucher    
SYSM018 NVARCHAR VSTRING 1 0 1 Substitute Voucher Substitute Voucher Substitute Voucher    
SYSM019 NVARCHAR VSTRING 13 0 13 Number Voucher Previous Number Voucher Previous Number Voucher Previous    
SYSM020 NVARCHAR VSTRING 10 0 10 StatusCodeTax (00 to 09) Cust StatusCodeTax (00 to 09) Cust StatusCodeTax (00 to 09) Cust    
SYSM021 NVARCHAR VSTRING 10 0 10 StatusCodeTax (10 to 19) Cust StatusCodeTax (10 to 19) Cust StatusCodeTax (10 to 19) Cust    
SYSM022 NVARCHAR VSTRING 10 0 10 StatusCodeTax (20 to 29) Cust StatusCodeTax (20 to 29) Cust StatusCodeTax (20 to 29) Cust    
SYSM023 NVARCHAR VSTRING 10 0 10 StatusCodeTax (30 to 39) Cust StatusCodeTax (30 to 39) Cust StatusCodeTax (30 to 39) Cust    
SYSM024 NVARCHAR VSTRING 10 0 10 StatusCodeTax (40 to 49) Cust StatusCodeTax (40 to 49) Cust StatusCodeTax (40 to 49) Cust    
SYSM025 NVARCHAR VSTRING 10 0 10 StatusCodeTax (50 to 59) Cust StatusCodeTax (50 to 59) Cust StatusCodeTax (50 to 59) Cust    
SYSM026 NVARCHAR VSTRING 10 0 10 StatusCodeTax (60 to 69)Cust StatusCodeTax (60 to 69)Cust StatusCodeTax (60 to 69)Cust    
SYSM027 NVARCHAR VSTRING 10 0 10 StatusCodeTax (70 to 79) Cust StatusCodeTax (70 to 79) Cust StatusCodeTax (70 to 79) Cust    
SYSM028 NVARCHAR VSTRING 10 0 10 StatusCodeTax (80 to 89) Cust StatusCodeTax (80 to 89) Cust StatusCodeTax (80 to 89) Cust    
SYSM029 NVARCHAR VSTRING 10 0 10 StatusCodeTax (90 to 99) Cust StatusCodeTax (90 to 99) Cust StatusCodeTax (90 to 99) Cust    
SYSM030 NVARCHAR VSTRING 10 0 10 StatusCodeTax (00 to 09) Sup StatusCodeTax (00 to 09) Sup StatusCodeTax (00 to 09) Sup    
SYSM031 NVARCHAR VSTRING 10 0 10 StatusCodeTax (10 to 19) Sup StatusCodeTax (10 to 19) Sup StatusCodeTax (10 to 19) Sup    
SYSM032 NVARCHAR VSTRING 10 0 10 StatusCodeTax (20 to 29) Sup StatusCodeTax (20 to 29) Sup StatusCodeTax (20 to 29) Sup    
SYSM033 NVARCHAR VSTRING 10 0 10 StatusCodeTax (30 to 39) Sup StatusCodeTax (30 to 39) Sup StatusCodeTax (30 to 39) Sup    
SYSM034 NVARCHAR VSTRING 10 0 10 StatusCodeTax (40 to 49) Sup StatusCodeTax (40 to 49) Sup StatusCodeTax (40 to 49) Sup    
SYSM035 NVARCHAR VSTRING 10 0 10 StatusCodeTax (50 to 59) Sup StatusCodeTax (50 to 59) Sup StatusCodeTax (50 to 59) Sup    
SYSM036 NVARCHAR VSTRING 10 0 10 StatusCodeTax (60 to 69) Sup StatusCodeTax (60 to 69) Sup StatusCodeTax (60 to 69) Sup    
SYSM037 NVARCHAR VSTRING 10 0 10 StatusCodeTax (70 to 79) Sup StatusCodeTax (70 to 79) Sup StatusCodeTax (70 to 79) Sup    
SYSM038 NVARCHAR VSTRING 10 0 10 StatusCodeTax (80 to 89) Sup StatusCodeTax (80 to 89) Sup StatusCodeTax (80 to 89) Sup    
SYSM039 NVARCHAR VSTRING 10 0 10 StatusCodeTax (90 to 99) Sup StatusCodeTax (90 to 99) Sup StatusCodeTax (90 to 99) Sup    
SYSM040 NUMERIC MONEY 28 8 20 Amount Limit Amount Limit Amount Limit    
SYSM041 NCHAR STRING 1 0 1 Disc volume Disc volume Disc volume    
SYSM042 NCHAR STRING 10 0 10 Customer Types to declare Customer Types to declare Customer Types to declare    
SYSM043 NCHAR STRING 10 0 10 Supplier Types to declare Supplier Types to declare Supplier Types to declare    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | System Utilities/Office Autom. | Report 347 format parameters