Таблица | Table: GLH0 - «PMS Interface File Structure Definition (Header)». Маска имени таблицы | Table Name Mask: «GLH0%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
GLH0001 | NCHAR | STRING | 3 | 0 | 3 | File Structure Code | File Structure Code | 1 | Да / Yes | |
GLH0002 | NCHAR | STRING | 32 | 0 | 32 | File Structure Name | File Structure Name | |||
GLH0003 | NCHAR | STRING | 64 | 0 | 64 | Path | Path | |||
GLH0004 | NCHAR | STRING | 12 | 0 | 12 | File Name | File Name | |||
GLH0005 | NCHAR | STRING | 3 | 0 | 3 | Data Type | Data Type | F - The file layout is for a file with fixed record length an column position/length
D - The file layout if for a Delimiter separated file, the delimiter character is defined in column GLH0006. |
||
GLH0006 | NCHAR | STRING | 3 | 0 | 3 | Delimiter | Delimiter Character | |||
GLH0007 | NCHAR | STRING | 3 | 0 | 3 | Char 2 | Option String | 3 character string where each character is a separate option:
Character 1: Text Qualifier character Character 2: General ledger transaction number series, A-Z or empty for standard counter Character 3: (Not used) |
||
GLH0008 | NCHAR | STRING | 1 | 0 | 1 | Transfer Type | Transfer Type | 0 - Revenue transfer
1 - City Ledger Transfer (Sales Ledger) |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | PMS Interface File Structure Definition (Header)