пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / 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 SL05 — Sales Ledger Payment Journal

Таблица / Table: SL05 — «Payment Journal». Маска имени таблицы / Table name mask: «SL05%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL05001 NUMERIC NUMBER 20 0 9 Reccounter Record Counter      
SL05002 NCHAR STRING 9 0 9 Transactno Transact Number   1 Да / Yes
SL05003 NCHAR STRING 7 0 7 Linenumber Line Number   2 Да / Yes
SL05004 DATETIME DATE 0 0 8 Trandate Transaction Date      
SL05005 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 SL05009 and SL05010 is used for specifying the accounting string and amount)
   
SL05006 NVARCHAR ACCSTR 120 0 120 Accstring Accounting String      
SL05007 NUMERIC MONEY 28 8 20 Amountlcu Amount (Local Currency)      
SL05008 INT INTEGER 0 0 2 Currcode Currency Code Line      
SL05009 NVARCHAR ACCSTR 120 0 120 Accstringocu Accounting String Payment Currency      
SL05010 NUMERIC MONEY 28 8 20 Amountocu Amount (Line Currency)      
SL05011 NVARCHAR VSTRING 36 0 36 Trantext Transaction Line Text      
SL05012 NCHAR STRING 10 0 10 Code1 Customer Code      
SL05013 NVARCHAR VSTRING 25 0 25 Code2 Invoice Number      
SL05014 NCHAR STRING 6 0 6 Code3 Journal Code      
SL05015 NCHAR STRING 2 0 2 Code4 General Ledger Period      
SL05016 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
SL05017 NCHAR STRING 8 0 8 Code6 Payment Line Number      
SL05018 NCHAR STRING 1 0 1 Tag1 Transaction Tag 1      
SL05019 NCHAR STRING 1 0 1 Tag2 Transaction Tag 2      
SL05020 NCHAR STRING 1 0 1 Tag3 Transaction Tag 3      
SL05021 NCHAR STRING 1 0 1 Tranlinetype Line Type 0 — Other transaction lines

1 — Accounts receivable transaction line

2 — Tax accounting transaction line
   
SL05022 NCHAR STRING 1 0 1 Tranlinesign Amount Sign 0 — Normal Sign (+ debit, — credit)

1 — Reversed Sign (+ credit, — debit)
   
SL05023 NUMERIC NUMBER 20 0 1 Noofdecimals No of Decimals      
SL05024 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.    
SL05025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
SL05026 INT INTEGER 0 0 4 Unitcode Unit Code      
SL05027 NUMERIC MONEY 28 8 20 Amountccu Amount (Alternative Currency)      
SL05028 NCHAR STRING 13 0 13 Contraacc Contra Account      
SL05029 NUMERIC NUMBER 20 0 6 Journalno Journal Number      
SL05030 NCHAR STRING 9 0 9 Plreference PL Reference      
SL05031 NCHAR STRING 6 0 6 Subprjcode Sub-Project Number      
SL05032 NCHAR STRING 6 0 6 Activitycode Activity Code      
SL05033 NCHAR STRING 8 0 8 Usridupdby UserID for Update      
SL05034 DATETIME DATE 0 0 8 Dateofentry Date Entered      
SL05035 NCHAR STRING 8 0 8 Usridentby UserID for Entry      
SL05036 DATETIME DATE 0 0 8 Dateofupd Date Updated      
SL05037 NVARCHAR VSTRING 36 0 36 Trantxtocu Transaction Text Payment Currency      
SL05038 NUMERIC X_NUMERIC 18 8 10 paxrate Payment Exchange Rate      
SL05039 NUMERIC X_NUMERIC 18 8 10 paxrate2 Payment Exchange Rate 2      
SL05040 NCHAR STRING 3 0 3 paalgorithm Payment Exchange Algorithm      
SL05041 NCHAR STRING 8 0 8 Usridprnby Printed By      
SL05042 DATETIME DATE 0 0 8 Dateofprn Date Printed      
SL05043 NCHAR SWITCH 1 0 1 PrnStatus PrintedStatus      
SL05044 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
SL05045 NVARCHAR VSTRING 6 0 6 TaxCode TaxCode      

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