Таблица: SLH4 - «Recharge Invoice Accounts Receivable transaction lines file». Маска имени таблицы: «SLH40000»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLH4001 NCHAR STRING 2 0 2 Originating Company Originating Company   1 Да
SLH4002 NCHAR STRING 10 0 10 Main Inv Suppl Code Main Invoice Supplier Code   2 Да
SLH4003 NCHAR STRING 15 0 15 Main Inv Number Main Invoice Number   3 Да
SLH4004 NCHAR STRING 10 0 10 Target Entity Target Company Code   4 Да
SLH4005 NCHAR STRING 5 0 5 Line Number Line Number   5 Да
SLH4006 NCHAR SWITCH 1 0 1 Updated Flag Updated Flag      
SLH4007 NCHAR SWITCH 1 0 1 Created Flag Created Flag      
SLH4008 NCHAR STRING 6 0 6 Transaction Number Transaction Number      
SLH4009 DATETIME DATE 0 0 8 TranDate Transaction Date      
SLH4010 NCHAR SWITCH 1 0 1 Primary 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 SLH4009 and SLH4010 is used for specifying the accounting string and amount)		    
SLH4011 NVARCHAR ACCSTR 50 0 50 Coding String Accounting String      
SLH4012 NUMERIC MONEY 28 8 20 Amount Amount (Local Currency)      
SLH4013 INT INTEGER 0 0 2 CurrencyCode Currency Code Line      
SLH4014 NVARCHAR ACCSTR 50 0 50 Coding String2 Accounting String (Line Currency)      
SLH4015 NUMERIC MONEY 28 8 20 Amount2 Amount (Line Currency)      
SLH4016 NVARCHAR VSTRING 25 0 25 TranText Transaction Line Text      
SLH4017 NCHAR STRING 10 0 10 Code1 Customer Code      
SLH4018 NVARCHAR VSTRING 23 0 23 Code2 Invoice Number      
SLH4019 NCHAR STRING 6 0 6 Code4 Journal Code      
SLH4020 NCHAR STRING 2 0 2 Code3 General Ledger Period      
SLH4021 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
SLH4022 NCHAR STRING 8 0 8 Code6 Transaction Code 6      
SLH4023 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		    
SLH4024 NCHAR STRING 1 0 1 NumOfDecimals Amount Sign 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit)		    
SLH4025 NUMERIC NUMBER 20 0 1 NumOfDecimals Number of Decimals      
SLH4026 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.    
SLH4027 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
SLH4028 NCHAR STRING 2 0 2 UnitCode Unit Code      
SLH4029 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
SLH4030 NUMERIC NUMBER 20 0 6 Journal Number Journal Number      
SLH4031 NCHAR STRING 6 0 6 PL Reference Internal Reference Number      
SLH4032 NCHAR STRING 6 0 6 SubProjectCode Sub-Project Number      
SLH4033 NCHAR STRING 6 0 6 ActivityCode Activity Code      
SLH4034 NCHAR STRING 8 0 8 UserIdentity Entered By      
SLH4035 DATETIME DATE 0 0 8 DateOfEntry Date Entered      
SLH4036 NVARCHAR VSTRING 25 0 25 Text2 Transaction Text (Line Currency)      
SLH4037 NVARCHAR VSTRING 4 0 4 Spare (obsolete)      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Recharge Invoice Accounts Receivable Transaction Lines