Таблица | Table: GLCD - «Petty Cash Desk Parameters». Маска имени таблицы | Table Name Mask: «GLCD%cc%yy»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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 50 0 50 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      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | General Ledger | Petty Cash Desk Parameters