One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of module «Sales Ledger»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SLH4 — Recharge Invoice Accounts Receivable Transaction Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SLH4001 NCHAR STRING 2 0 2 OriginatingCompany Originating Company   1 Да / Yes
SLH4002 NCHAR STRING 10 0 10 MainInvSupplCode Main Invoice Supplier Code   2 Да / Yes
SLH4003 NCHAR STRING 25 0 25 MainInvNumber Main Invoice Number   3 Да / Yes
SLH4004 NCHAR STRING 10 0 10 TargetEntity Target Company Code   4 Да / Yes
SLH4005 NCHAR STRING 7 0 7 LineNumber Line Number   5 Да / Yes
SLH4006 NCHAR SWITCH 1 0 1 UpdatedFlag Updated Flag      
SLH4007 NCHAR SWITCH 1 0 1 CreatedFlag Created Flag      
SLH4008 NCHAR STRING 9 0 9 TransactionNumber 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 120 0 120 CodingString 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 120 0 120 CodingString2 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 AmntSign 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 INT INTEGER 0 0 4 UnitCode Unit Code      
SLH4029 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
SLH4030 NUMERIC NUMBER 20 0 6 JournalNumber Journal Number      
SLH4031 NCHAR STRING 9 0 9 PLReference 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)      
SLH4038 NVARCHAR VSTRING 25 0 25 AASCode AAS code      

Навигация / Navigation: