One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Payroll»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PA17 — Payroll Journal

Таблица / Table: PA17 — «PA17 Payroll Trans». Маска имени таблицы / Table name mask: «PA17%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?
PA17001 NUMERIC NUMBER 20 0 9 Reccounter Record Counter      
PA17002 NCHAR STRING 9 0 9 Transactno Transaction Number   1 Да / Yes
PA17003 NCHAR STRING 7 0 7 Linenumber Line Number   2 Да / Yes
PA17004 DATETIME DATE 0 0 8 Trandate Transaction Date      
PA17005 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 PA17009 and PA17010 is used for specifying the accounting string and amount)
   
PA17006 NVARCHAR ACCSTR 120 0 120 Accstring Accounting String      
PA17007 NUMERIC MONEY 28 8 20 Amountlcu Amount (Local Currency)      
PA17008 INT INTEGER 0 0 2 Currcode Currency Code Line      
PA17009 NVARCHAR ACCSTR 120 0 120 Accstringocu Accounting String (Line Currency)      
PA17010 NUMERIC MONEY 28 8 20 Amountocu Amount (Line Currency)      
PA17011 NVARCHAR VSTRING 36 0 36 Trantext Transaction Line Text      
PA17012 NCHAR STRING 10 0 10 Code1 Employee Code   3 Да / Yes
PA17013 NVARCHAR VSTRING 25 0 25 Code2 Transaction Code 2      
PA17014 NCHAR STRING 6 0 6 Code3 Wage Type      
PA17015 NCHAR STRING 2 0 2 Code4 Transaction Code 4      
PA17016 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
PA17017 NCHAR STRING 8 0 8 Code6 Transaction Code 6      
PA17018 NCHAR STRING 1 0 1 Tag1 Transaction Tag 1      
PA17019 NCHAR STRING 1 0 1 Tag2 Transaction Tag 2      
PA17020 NCHAR STRING 1 0 1 Tag3 Transaction Tag 3      
PA17021 NCHAR STRING 1 0 1 Tranlinetype Line Type      
PA17022 NCHAR STRING 1 0 1 Tranlinesign Amount Sign 0 — Normal Sign (+ debit, — credit)

1 — Reversed Sign (+ credit, — debit)
   
PA17023 NUMERIC NUMBER 20 0 1 Noofdecimals Number of Decimals      
PA17024 NCHAR STRING 8 0 8 Linkcode In Closing Period      
PA17025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
PA17026 INT INTEGER 0 0 4 Unitcode Unit Code      
PA17027 NUMERIC MONEY 28 8 20 Amountccu Amount (Alternative Currency)      
PA17028 NCHAR STRING 13 0 13 Contraacc Contra Account      
PA17029 NUMERIC NUMBER 20 0 6 Journalno Journal Number      
PA17030 NCHAR STRING 9 0 9 Plreference PL Reference      
PA17031 NCHAR STRING 6 0 6 Subprojcode Sub-Project Number      
PA17032 NCHAR STRING 6 0 6 Activitycode Activity Code      
PA17033 NCHAR STRING 8 0 8 Usridentby Entered By      
PA17034 DATETIME DATE 0 0 8 Dateofentry Date Entered      
PA17035 NCHAR STRING 8 0 8 Usridupdby Updated By      
PA17036 DATETIME DATE 0 0 8 Dateofupd Date Updated      
PA17037 NVARCHAR VSTRING 36 0 36 Trantxtocu Transaction Text (Line Currency)      
PA17038 NVARCHAR ACCSTR 120 0 120 Secondaccstr Accounting String Second      
PA17039 NCHAR STRING 8 0 8 Usridprnby Printed By      
PA17040 DATETIME DATE 0 0 8 Dateofprn Date Printed      
PA17041 TINYINT X_TINYINT 0 0 1 TaxType Tax type 0 — no tax line

1 — social benefits line

2 — tax line
   
PA17042 INT INTEGER 0 0 4 TaxId Tax identifier      
PA17043 NVARCHAR VSTRING 3 0 3 AllocNum Allocation number      
PA17044 TINYINT X_TINYINT 0 0 2 AllocLineNum Allocation line number      
PA17045 NVARCHAR VSTRING 7 0 7 SrcLineNum Source line number      
PA17046 TINYINT X_TINYINT 0 0 1 TaxAmountType Tax amount type 0 — no

1 — tax base

2 — tax total
   

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