Таблица: SYL8 - «Document Issuer». Маска имени таблицы: «SYL8%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SYL8001 | NCHAR | SWITCH | 1 | 0 | 1 | DocumentType | Document Type | A - Invoice Issuer
B - Delivery Note Issuer C - Receipt Issuer |
1 | Да |
SYL8002 | NCHAR | STRING | 4 | 0 | 4 | DocumentIssuerCode | Issuer Code | 2 | Да | |
SYL8003 | NCHAR | STRING | 16 | 0 | 16 | DocIssuerExternalCod | External Code | |||
SYL8004 | DATETIME | DATE | 0 | 0 | 8 | DocIssuervalidDate | Valid to Date | |||
SYL8005 | NVARCHAR | VSTRING | 35 | 0 | 35 | AdrLine1 | Address Line 1 | |||
SYL8006 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine2 | Address Line 2 | |||
SYL8007 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine3 | Address Line 3 | |||
SYL8008 | NVARCHAR | VSTRING | 35 | 0 | 35 | AddrLine4 | Address Line 4 | |||
SYL8009 | NVARCHAR | VSTRING | 10 | 0 | 10 | ZipCode | Zip Code | |||
SYL8010 | NCHAR | STRING | 2 | 0 | 2 | StateCode | State Code | |||
SYL8011 | NCHAR | STRING | 3 | 0 | 3 | GeoCode | Geo Code | |||
SYL8012 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephNumb | Telephone Number | |||
SYL8013 | NVARCHAR | VSTRING | 20 | 0 | 20 | FaxNumb | Fax Number | |||
SYL8014 | DATETIME | DATE | 0 | 0 | 8 | LastDocIssueDate | Last Document Issue Date | |||
SYL8015 | NCHAR | STRING | 2 | 0 | 2 | CounterRefA0 | Counter Reference Category A Invoice | |||
SYL8016 | NCHAR | STRING | 2 | 0 | 2 | CounterRefA1 | Counter Reference Category A Debit Note | |||
SYL8017 | NCHAR | STRING | 2 | 0 | 2 | CounterRefA2 | Counter Reference Category A Credit Note | |||
SYL8018 | NCHAR | STRING | 2 | 0 | 2 | CounterRefB0 | Counter Reference Category B Invoice | |||
SYL8019 | NCHAR | STRING | 2 | 0 | 2 | CounterRefB1 | Counter Reference Category B Debit Note | |||
SYL8020 | NCHAR | STRING | 2 | 0 | 2 | CounterRefB2 | Counter Reference Category B Credit Note | |||
SYL8021 | NCHAR | STRING | 2 | 0 | 2 | CounterRefC0 | Counter Reference Category C Invoice | |||
SYL8022 | NCHAR | STRING | 2 | 0 | 2 | CounterRefC1 | Counter Reference Category C Debit Note | |||
SYL8023 | NCHAR | STRING | 2 | 0 | 2 | CounterRefC2 | Counter Reference Category C Credit Note | |||
SYL8024 | NCHAR | STRING | 2 | 0 | 2 | CounterrefE0 | Counter Reference Category E Invoice | |||
SYL8025 | NCHAR | STRING | 2 | 0 | 2 | CounterRefE1 | Counter Reference Category E Debit Note | |||
SYL8026 | NCHAR | STRING | 2 | 0 | 2 | CounterRefE2 | Counter Reference Category E Credit Note | |||
SYL8027 | NCHAR | STRING | 2 | 0 | 2 | CounterRefZ0 | Counter Reference Category Z Invoice | |||
SYL8028 | NCHAR | STRING | 2 | 0 | 2 | CounterRefZ1 | Counter Reference Category Z Debit Note | |||
SYL8029 | NCHAR | STRING | 2 | 0 | 2 | CounterRefZ2 | Counter Reference Category Z Credit Note | |||
SYL8030 | NCHAR | STRING | 1 | 0 | 1 | PrinterPaperType | Printer Paper Type | 0 - Plain paper
1 - Pre-printed/Pre-numbered |
||
SYL8031 | NVARCHAR | VSTRING | 1 | 0 | 1 | PrefixLength | Prefix Length | |||
SYL8032 | NVARCHAR | VSTRING | 2 | 0 | 2 | CounterLength | Counter Length | |||
SYL8033 | NCHAR | SWITCH | 1 | 0 | 1 | POSMachine | POS Machine | |||
SYL8034 | NCHAR | SWITCH | 1 | 0 | 1 | FlagDefInvDate | ||||
SYL8035 | NCHAR | SWITCH | 1 | 0 | 1 | FlagReprintDelNote | ||||
SYL8036 | NVARCHAR | VSTRING | 10 | 0 | 10 | InvSerialCode | Invoice Serial Code | |||
SYL8037 | NCHAR | STRING | 1 | 0 | 1 | PrefixType | Prefix Type | |||
SYL8038 | NCHAR | STRING | 1 | 0 | 1 | Delimiter | Delimiter | |||
SYL8039 | NCHAR | STRING | 2 | 0 | 2 | CounterRefA3 | Counter Reference TaxNote Category A | |||
SYL8040 | NCHAR | STRING | 2 | 0 | 2 | CounterRefB3 | Counter Reference TaxNote Category B | |||
SYL8041 | NCHAR | STRING | 2 | 0 | 2 | CounterRefC3 | Counter Reference TaxNote Category C | |||
SYL8042 | NCHAR | STRING | 2 | 0 | 2 | CounterRefE3 | Counter Reference TaxNote Category E | |||
SYL8043 | NCHAR | STRING | 2 | 0 | 2 | CounterRefZ3 | Counter Reference TaxNote Category Z |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | System Utilities/Office Autom. | Document Issuer