Таблица | Table: GLCB - «Petty Cash Master File». Маска имени таблицы | Table Name Mask: «GLCB%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
GLCB001 | NCHAR | STRING | 8 | 0 | 8 | CashDeskLocation | Cash Office Code | 1 | Да / Yes | |
GLCB002 | INT | INTEGER | 0 | 0 | 2 | CashDeskCurrCode | Currency Code Cash Office | 2 | Да / Yes | |
GLCB003 | NCHAR | SWITCH | 1 | 0 | 1 | DocType | Document Type | 1 - Cash Receipt
2 - Cash Issues |
3 | Да / Yes |
GLCB004 | NCHAR | STRING | 6 | 0 | 6 | DocNO | Document Number | 4 | Да / Yes | |
GLCB005 | DATETIME | DATE | 0 | 0 | 8 | DocDate | Document Date | |||
GLCB006 | NCHAR | STRING | 8 | 0 | 8 | CashierCode | Cashier Code | |||
GLCB007 | NCHAR | SWITCH | 1 | 0 | 1 | LedgerCode | Ledger Code | 0 - General Ledger Transaction
1 - Purchase Ledger Transaction 2 - Sales Ledger Transaction 3 - Payroll Transaction |
||
GLCB008 | NCHAR | STRING | 10 | 0 | 10 | RcptCliEmplCode | Recipient/Payer Code | |||
GLCB009 | NVARCHAR | VSTRING | 35 | 0 | 35 | RcptCliEmplName | Recipient/Payer Name | |||
GLCB010 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address1 | Recipient/Payer Address Line 1 | |||
GLCB011 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address2 | Recipient/Payer Address Line 2 | |||
GLCB012 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address3 | Recipient/Payer Address Line 3 | |||
GLCB013 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address4 | Recipient/Payer Address Line 4 | |||
GLCB014 | NVARCHAR | VSTRING | 65 | 0 | 65 | TextLine1 | Text Line 1 | |||
GLCB015 | NVARCHAR | VSTRING | 65 | 0 | 65 | TextLine2 | Text Line 2 | |||
GLCB016 | NVARCHAR | VSTRING | 65 | 0 | 65 | TextLine3 | Text Line 3 | |||
GLCB017 | NCHAR | SWITCH | 1 | 0 | 1 | reserved | (obsolete) | |||
GLCB018 | NCHAR | SWITCH | 1 | 0 | 1 | reserved | (obsolete) | |||
GLCB019 | NCHAR | SWITCH | 1 | 0 | 1 | reserved | (obsolete) | |||
GLCB020 | NUMERIC | MONEY | 28 | 8 | 20 | DocAmoLocCurr | Document Amount (Local Currency) | |||
GLCB021 | NUMERIC | MONEY | 28 | 8 | 20 | DocAmoOrgCurr | Document Amount (Document Currency) | |||
GLCB022 | NCHAR | SWITCH | 1 | 0 | 1 | DocStatusFlag | Document Status | 0 - Document has not been sent
1 - Document sent but not updated 2 - Document sent and update 3 - Used for opening balance transaction |
||
GLCB023 | NCHAR | STRING | 8 | 0 | 8 | ExternalCode | External Code | |||
GLCB024 | NCHAR | STRING | 9 | 0 | 9 | GLXactionNO | Transaction Number | |||
GLCB025 | NVARCHAR | ACCSTR | 50 | 0 | 50 | CashDeskAcntStr | Accounting String | |||
GLCB026 | NCHAR | STRING | 12 | 0 | 12 | CorrespondingAcnt | Corresponding Account | |||
GLCB027 | NCHAR | STRING | 2 | 0 | 2 | ReasonCode | Reason Code | |||
GLCB028 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate | Currency Exchange Rate 1 | |||
GLCB029 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchgRate2 | Currency Exchange Rate 2 | |||
GLCB030 | NCHAR | STRING | 3 | 0 | 3 | CurrConvertAlgtm | Currency Exchange Algorithm | |||
GLCB031 | NCHAR | STRING | 3 | 0 | 3 | LanguageCode | Language | |||
GLCB032 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address5 | Recipient/Payer Address Line 5 | |||
GLCB033 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address6 | Recipient/Payer Address Line 6 | |||
GLCB034 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address7 | Recipient/Payer Address Line 7 | |||
GLCB035 | NVARCHAR | VSTRING | 3 | 0 | 3 | CountryCode | Recipient/Payer Country Code |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | Petty Cash Master Table