Таблица: SL04 - «Invoice Journal». Маска имени таблицы: «SL04%cc%yy»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL04001 NUMERIC NUMBER 20 0 8 Reccounter Record Counter      
SL04002 NCHAR STRING 6 0 6 Transactno Transaction Number   1 Да
SL04003 NCHAR STRING 5 0 5 Linenumber Line Number   2 Да
SL04004 DATETIME DATE 0 0 8 Trandate Transaction Date      
SL04005 NCHAR SWITCH 1 0 1 Flag Primary Line Currency Used for currency/quantity accounting transactions to specify what the primary currency was for the transaction line:
0 - Normal transaction line in local currency, no foreign amount or quantity is specified.
1 - Only foreign amount or quantity is specified, no local amount exist for the transaction line.
2 - Foreign amount or quantity is specified for the transaction line but the local currency amount is the primary amount.
3 - Foreign amount is specified and was the primary amount when the transaction line was entered.
(Foreign amounts and quantity is booked on statistical accounts and column SL04009 and SL04010 is used for specifying the accounting string and amount)
   
SL04006 NVARCHAR ACCSTR 50 0 50 Accstring Accounting String      
SL04007 NUMERIC MONEY 28 8 20 Amountlcu Amount (Local Currency)      
SL04008 INT INTEGER 0 0 2 Currcode Currency Code Line      
SL04009 NVARCHAR ACCSTR 50 0 50 Accstringocu Accounting String (Line Currency)      
SL04010 NUMERIC MONEY 28 8 20 Amountocu Amount (Line Currency)      
SL04011 NVARCHAR VSTRING 25 0 25 Trantext Transaction Line Text      
SL04012 NCHAR STRING 10 0 10 Code1 Customer Code      
SL04013 NVARCHAR VSTRING 23 0 23 Code2 Invoice Number      
SL04014 NCHAR STRING 6 0 6 Code3 Journal Code      
SL04015 NCHAR STRING 2 0 2 Code4 General Ledger Period      
SL04016 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
SL04017 NCHAR STRING 8 0 8 Code6 Transaction Code 6      
SL04018 NCHAR STRING 1 0 1 Tag1 Transaction Tag 1      
SL04019 NCHAR STRING 1 0 1 Tag2 Transaction Tag 2      
SL04020 NCHAR STRING 1 0 1 Tag3 Transaction Tag 3      
SL04021 NCHAR STRING 1 0 1 Tranlinetype Line Type 0 - Other transaction lines
1 - Accounts receivable transaction line
2 - Tax accounting transaction line
5 - Periodical allocation transaction
9 - Transaction line is related to a project activity code
   
SL04022 NCHAR STRING 1 0 1 Tranlinesign Amount Sign 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit)
   
SL04023 NUMERIC NUMBER 20 0 1 Noofdecimals No of Decimals      
SL04024 NCHAR STRING 5 0 5 Linkcode In Closing Period The character 'i' indicates that the transaction will be booked in the closing period, otherwise the field will be empty.    
SL04025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
SL04026 NCHAR STRING 2 0 2 Unitcode Unit Code      
SL04027 NUMERIC MONEY 28 8 20 Amountccu Amount (Alternative Currency)      
SL04028 NCHAR STRING 13 0 13 contraacc Contra Account      
SL04029 NUMERIC NUMBER 20 0 6 Journalno Journal Number      
SL04030 NCHAR STRING 6 0 6 Plreference PL Reference      
SL04031 NCHAR STRING 6 0 6 Subprjcode Sub-Project Number      
SL04032 NCHAR STRING 6 0 6 Activitycode Activity Code      
SL04033 NCHAR STRING 8 0 8 Usridentby Entered By      
SL04034 DATETIME DATE 0 0 8 Dateofentry Date Entered      
SL04035 NCHAR STRING 8 0 8 Usridupdby Updated By      
SL04036 DATETIME DATE 0 0 8 Dateofupd Date Updated      
SL04037 NVARCHAR VSTRING 25 0 25 Trantxtocu Transaction Text (Line Currency)      
SL04038 NCHAR STRING 2 0 2 SourceCompany Source Company      
SL04039 NCHAR STRING 8 0 8 Usridprnby Printed By      
SL04040 DATETIME DATE 0 0 8 Dateofprn Date Printed      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Ledger | Sales Ledger Invoice Journal