One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table GLCD — Petty Cash Desk Parameters

Таблица / Table: GLCD — «Petty Cash Desk Parameters». Маска имени таблицы / Table name mask: «GLCD%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?
GLCD001 NCHAR STRING 8 0 8 CashDeskLocation Cash Office Code   1 Да / Yes
GLCD002 INT INTEGER 0 0 2 CashDeskCurrCode Currency Code Cash Office   2 Да / Yes
GLCD003 NVARCHAR ACCSTR 120 0 120 CashAcntStr Accounting String      
GLCD004 NCHAR SWITCH 1 0 1 DocLayout Document Code      
GLCD005 NUMERIC NUMBER 20 0 1 PrintCopies Copies to Print      
GLCD006 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD007 NCHAR SWITCH 1 0 1 RcptDocCnt (obsolete)      
GLCD008 NCHAR SWITCH 1 0 1 IssueDocCnt (obsolete)      
GLCD009 NCHAR SWITCH 1 0 1 XactionNumberCnt General Ledger Transaction Counter Blank if own counter is in use for cash desk, A-Z to use the correspondent general ledger counter.    
GLCD010 NCHAR SWITCH 1 0 1 DailyReportCnt (obsolete)      
GLCD011 NCHAR STRING 8 0 8 CurrentCashier Current Cashier      
GLCD012 NUMERIC MONEY 28 8 20 YearOpeningBalance Year Opening Balance      
GLCD013 NUMERIC MONEY 28 8 20 CurrentBalance Current Balance      
GLCD014 NUMERIC MONEY 28 8 20 BalanceLastClosed Balance Last Closed      
GLCD015 DATETIME DATE 0 0 8 DateLastClosed Date Last Closed      
GLCD016 NCHAR STRING 1 0 1 BufferOption Allow Unauthorized Documents      
GLCD017 NCHAR STRING 1 0 1 NegBalanceOption Allow Negative Balance      
GLCD018 NCHAR SWITCH 1 0 1 LetChgDateOnEntry (obsolete)      
GLCD019 NCHAR STRING 1 0 1 GLIntLevel (obsolete)      
GLCD020 NCHAR SWITCH 1 0 1 ClosingRequired (obsolete)      
GLCD021 NCHAR STRING 1 0 1 PAIntLevel (obsolete)      
GLCD022 NCHAR STRING 1 0 1 PAWageType1 (obsolete)      
GLCD023 NCHAR STRING 2 0 2 PAAccumulator1 (obsolete)      
GLCD024 NCHAR STRING 1 0 1 PAWageType2 (obsolete)      
GLCD025 NCHAR STRING 2 0 2 PAAccumulator2 (obsolete)      
GLCD026 NCHAR STRING 1 0 1 PAWageType3 (obsolete)      
GLCD027 NCHAR STRING 2 0 2 PAAccumulator3 (obsolete)      
GLCD028 NCHAR STRING 1 0 1 PAWageType4 (obsolete)      
GLCD029 NCHAR STRING 2 0 2 PAAccumulator4 (obsolete)      
GLCD030 NUMERIC MONEY 28 8 20 SlryYearOpeningBal Salary Year Opening Balance      
GLCD031 NUMERIC MONEY 28 8 20 SlryCurrentBal Salary Current Balance      
GLCD032 NUMERIC MONEY 28 8 20 SlryBalanceLastClo Salary Last Closing Balance      
GLCD033 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD034 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD035 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD036 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD037 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD038 NCHAR STRING 1 0 1 reserved (obsolete)      
GLCD039 NCHAR STRING 6 0 6 JournalCode Journal Code      

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