Таблица: SY55 - «Cheque Transactions». Маска имени таблицы: «SY55%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SY55001 NUMERIC NUMBER 20 0 9 RecordCounter Record Counter   1 Да
SY55002 NCHAR STRING 9 0 9 TransactionNO Transaction Number   3 Да
SY55003 NCHAR STRING 7 0 7 LineNO Line Number   4 Да
SY55004 DATETIME DATE 0 0 8 TransactionDate Transaction Date      
SY55005 NCHAR SWITCH 1 0 1 Flag Primary Line Currency      
SY55006 NVARCHAR ACCSTR 50 0 50 AccountingString Accounting String      
SY55007 NUMERIC MONEY 28 8 20 AmountLCU Amount (Local Currency)      
SY55008 INT INTEGER 0 0 2 CurrencyCode Currency Code Line      
SY55009 NVARCHAR ACCSTR 50 0 50 AccountingStrOCU Accounting String Line Currency      
SY55010 NUMERIC MONEY 28 8 20 AmountOCU Amount (Line Currency)      
SY55011 NVARCHAR VSTRING 25 0 25 TransactionText Transaction Line Text      
SY55012 NCHAR STRING 10 0 10 Code1 Customer/Supplier Code      
SY55013 NVARCHAR VSTRING 23 0 23 Code2 Document Number      
SY55014 NCHAR STRING 6 0 6 Code3 Journal Code      
SY55015 NCHAR STRING 2 0 2 Code4 General Ledger Period      
SY55016 NVARCHAR VSTRING 35 0 35 Code5 Foreign Amount (Currency Account)      
SY55017 NCHAR STRING 8 0 8 Code6 Compound Allocation Switches      
SY55018 NCHAR SWITCH 1 0 1 Tag1 Period Allocation      
SY55019 NCHAR SWITCH 1 0 1 Tag2 Project Line Type      
SY55020 NCHAR SWITCH 1 0 1 Tag3 Transaction Flag      
SY55021 NCHAR STRING 1 0 1 TransactionLineType Line Type      
SY55022 NCHAR SWITCH 1 0 1 TransactionLineSign Transaction Sign      
SY55023 NUMERIC NUMBER 20 0 1 NOofDecimals Number of Decimals      
SY55024 NCHAR STRING 5 0 5 LinkCode Link Code      
SY55025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
SY55026 INT INTEGER 0 0 4 UnitCode Unit Code      
SY55027 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
SY55028 NCHAR STRING 13 0 13 ContraAccount Contra Account      
SY55029 NUMERIC NUMBER 20 0 6 JournalNumber Journal Number      
SY55030 NCHAR STRING 6 0 6 PLReference PL Reference      
SY55031 NCHAR STRING 6 0 6 SubProjectCode Sub-Project Number      
SY55032 NCHAR STRING 6 0 6 ActivityCode Activity Code      
SY55033 NCHAR STRING 8 0 8 UserID Entered By   2 Да
SY55034 DATETIME DATE 0 0 8 DateOfEntry Date Entered      
SY55035 NCHAR STRING 8 0 8 updUserID Updated By      
SY55036 DATETIME DATE 0 0 8 DateOfUpdate Date Updated      
SY55037 NVARCHAR VSTRING 25 0 25 XactionTextOCU Transaction Text Line Currency      
SY55038 NCHAR STRING 8 0 8 prnUserID Printed By      
SY55039 DATETIME DATE 0 0 8 DateOfPrint Date Printed      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | System Utilities/Office Autom. | Cheque Transactions