Таблица | Table: GLCB - «Petty Cash Master File». Маска имени таблицы | Table Name Mask: «GLCB%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?
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