На один уровень вверх / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Purchase Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица PL05 — Purchase Ledger Payment Journal

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL05001 NUMERIC NUMBER 20 0 9 Reccounter Record Counter      
PL05002 NCHAR STRING 9 0 9 Transactno Transact Number   1 Да
PL05003 NCHAR STRING 7 0 7 Linenumber Line Number   2 Да
PL05004 DATETIME DATE 0 0 8 Trandate Transaction Date      
PL05005 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 PL05009 and PL05010 is used for specifying the accounting string and amount)		    
PL05006 NVARCHAR ACCSTR 50 0 50 Accstring Accounting String      
PL05007 NUMERIC MONEY 28 8 20 Amountlcu Amount (Local Currency)      
PL05008 INT INTEGER 0 0 2 Currcode Currency Code Line      
PL05009 NVARCHAR ACCSTR 50 0 50 Accstringocu Accounting String (Line Currency)      
PL05010 NUMERIC MONEY 28 8 20 Amountocu Amount (Line Currency)      
PL05011 NVARCHAR VSTRING 36 0 36 Trantext Transaction Line Text      
PL05012 NCHAR STRING 10 0 10 Code1 Supplier Code      
PL05013 NVARCHAR VSTRING 25 0 25 Code2 Invoice Number      
PL05014 NCHAR STRING 6 0 6 Code3 Journal Code      
PL05015 NCHAR STRING 2 0 2 Code4 General Ledger Period      
PL05016 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
PL05017 NCHAR STRING 8 0 8 Code6 Payment Line Number      
PL05018 NCHAR STRING 1 0 1 Tag1 Transaction Tag 1      
PL05019 NCHAR STRING 1 0 1 Tag2 Transaction Tag 2      
PL05020 NCHAR STRING 1 0 1 Tag3 Transaction Tag 3      
PL05021 NCHAR STRING 1 0 1 Tranlinetype Line Type 0 — Other transaction lines
1 — Accounts payable transaction line
2 — Tax accounting transaction line		    
PL05022 NCHAR STRING 1 0 1 Tranlinesign Amount Sign 0 — Normal Sign (+ debit, — credit)
1 — Reversed Sign (+ credit, — debit)		    
PL05023 NUMERIC NUMBER 20 0 1 Noofdecimals No of Decimals      
PL05024 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.    
PL05025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
PL05026 INT INTEGER 0 0 4 Unitcode Unit Code      
PL05027 NUMERIC MONEY 28 8 20 Amountccu Amount (Alternative Currency)      
PL05028 NCHAR STRING 13 0 13 Contraacc Contra Account      
PL05029 NUMERIC NUMBER 20 0 6 Journalno Journal Number      
PL05030 NCHAR STRING 9 0 9 Plreference Internal Reference Number      
PL05031 NCHAR STRING 6 0 6 Subprjcode Sub-Project Number      
PL05032 NCHAR STRING 6 0 6 Activitycode Activity Code      
PL05033 NCHAR STRING 8 0 8 Usridupdby UserID for Update      
PL05034 DATETIME DATE 0 0 8 Dateofentry Date Entered      
PL05035 NCHAR STRING 8 0 8 Usridentby UserID for Entry      
PL05036 DATETIME DATE 0 0 8 Dateofupd Date Updated      
PL05037 NVARCHAR VSTRING 36 0 36 Trantxtocu Transaction Text (Line Currency)      
PL05038 NUMERIC X_NUMERIC 18 8 10 paxrate Payment Exchange Rate      
PL05039 NUMERIC X_NUMERIC 18 8 10 paxrate2 Payment Exchange Rate 2      
PL05040 NCHAR STRING 3 0 3 palgorithm Payment Exchange Algorithm      
PL05041 NCHAR STRING 8 0 8 Usridprnby Printed By      
PL05042 DATETIME DATE 0 0 8 Dateofprn Date Printed      
PL05043 NCHAR SWITCH 1 0 1 PrnStatus PrintedStatus      
PL05044 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
PL05045 NVARCHAR VSTRING 6 0 6 TaxCode TaxCode      

Навигация: