пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
GLCY001 NCHAR STRING 8 0 8 CashDeskLocation Cash Office Code   1 Да
GLCY002 INT INTEGER 0 0 2 CashDeskCurrCode Currency Code Cash Office   2 Да
GLCY003 NCHAR SWITCH 1 0 1 CashDocType Document Type   3 Да
GLCY004 NCHAR STRING 6 0 6 CashDocNumber Document Number   4 Да
GLCY005 NUMERIC NUMBER 20 0 9 RecordCounter Record Number      
GLCY006 NCHAR STRING 9 0 9 XactionNumber Transaction Number      
GLCY007 NCHAR STRING 7 0 7 LineNumber Line Number   5 Да
GLCY008 DATETIME DATE 0 0 8 XactionDate Transaction Date      
GLCY009 NCHAR SWITCH 1 0 1 PrimaryFlag Primary Line Currency      
GLCY010 NVARCHAR ACCSTR 50 0 50 AccountingString Accounting String      
GLCY011 NUMERIC MONEY 28 8 20 AmountLCU Amount (Local Currency)      
GLCY012 INT INTEGER 0 0 2 CurrencyCode Currency Code Line      
GLCY013 NVARCHAR ACCSTR 50 0 50 AccountingStringOCU Accounting String Line Currency      
GLCY014 NUMERIC MONEY 28 8 20 AmountOCU Amount (Line Currency)      
GLCY015 NVARCHAR VSTRING 36 0 36 XactionText Transaction Line Text      
GLCY016 NCHAR STRING 10 0 10 Code1 Customer/Supplier Code      
GLCY017 NVARCHAR VSTRING 25 0 25 Code2 Document Number      
GLCY018 NCHAR STRING 6 0 6 Code3 Journal Code      
GLCY019 NCHAR STRING 2 0 2 Code4 General Ledger Period      
GLCY020 NVARCHAR VSTRING 35 0 35 Code5 Foreign Amount (Currency Account)      
GLCY021 NCHAR STRING 8 0 8 Code6 Compound Allocation Switches      
GLCY022 NCHAR STRING 1 0 1 Tag1 Period Allocation 0 - Period allocation has not been executed for the transaction line
1 - Period allocation has been executed for the transaction line
2 - (used with analytical ledger)
3 - (used with analytical ledger)
   
GLCY023 NCHAR STRING 1 0 1 Tag2 Project Line Type Only valid of GL07031 and GL07032 has a value:
0 - GL07032 is linked to a project activity line
1 - GL07032 is linked to a activity code
   
GLCY024 NCHAR STRING 1 0 1 Tag3 Transaction Flag 0 - Standard value
1 - Transaction line is a currency revaluation transaction line
2 - Transaction line is in closing period
   
GLCY025 NCHAR STRING 1 0 1 XactionLineType Line Type 0 - Manual Transaction in General Ledger
1 - Reversal Transaction in General Ledger
2 - Accrued Transaction (Periodic Allocation)
3 - Customer Invoice (From Sales Ledger)
4 - Customer Payment (From Sales Ledger)
5 - Supplier Invoice (From Purchase Ledger)
6 - Supplier Payment (From Purchase Ledger)
7 - Depreciation Transaction (From Asset Management)
8 - Automatic Period Allocation
9 - Transaction from Project Management
A - Transaction from Payroll
B - Transaction from Stock Journal
C - Transaction from Promissory Notes
D - Petty Cash Transaction
K - Fixed Assets Revaluation Transaction
L - Cash-Books Transaction
M - Transaction from MPC WIP Journal
S - Transaction from Source Company (Consolidation)
T - Temporary Cheque Transactions (Day-Book Journal)
i - Closing Period Transaction
k - Year End Closing Transaction
| - Transferred Open Balances of Currency Accounts
   
GLCY026 NCHAR STRING 1 0 1 XactionLineSign Transaction Sign 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit)
   
GLCY027 NUMERIC NUMBER 20 0 1 NOofDecimals Number of Decimals      
GLCY028 NCHAR STRING 5 0 5 LinkCode Link Code      
GLCY029 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
GLCY030 INT INTEGER 0 0 4 UnitCode Unit Code      
GLCY031 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
GLCY032 NCHAR STRING 13 0 13 ContaAccount Contra Account      
GLCY033 NCHAR STRING 6 0 6 JournalNumber Journal Number      
GLCY034 NCHAR STRING 9 0 9 PLReference PL Reference      
GLCY035 NCHAR STRING 6 0 6 SubProjectCode Sub-Project Number      
GLCY036 NCHAR STRING 6 0 6 ActivityCode Activity Code      
GLCY037 NCHAR STRING 8 0 8 UserID Entered By      
GLCY038 DATETIME DATE 0 0 8 DateOfEntry Date Entered      
GLCY039 NCHAR STRING 8 0 8 UserIDUpdated Updated By      
GLCY040 DATETIME DATE 0 0 8 DateOfUpdate Date Updated      
GLCY041 NVARCHAR VSTRING 36 0 36 XactionTextOCU Transaction Text Line Currency      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | General Ledger | Petty Cash Transaction File

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.