пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «General Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица GLCB — Petty Cash Master Table

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GLCB001 NCHAR STRING 8 0 8 CashDeskLocation Cash Office Code   1 Да
GLCB002 INT INTEGER 0 0 2 CashDeskCurrCode Currency Code Cash Office   2 Да
GLCB003 NCHAR SWITCH 1 0 1 DocType Document Type 1 — Cash Receipt
2 — Cash Issues
3 Да
GLCB004 NCHAR STRING 6 0 6 DocNO Document Number   4 Да
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      

Навигация: