На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table GLCB — Petty Cash Master Table

Таблица / Table: GLCB — «Petty Cash Master File». Маска имени таблицы / Table name mask: «GLCB%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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      

Навигация / Navigation: