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

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

Таблица / Table: PL04 — «Invoice Journal». Маска имени таблицы / Table name mask: «PL04%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?
PL04001 NUMERIC NUMBER 20 0 9 Reccounter Record Counter      
PL04002 NCHAR STRING 9 0 9 Transactno Transaction Number   1 Да / Yes
PL04003 NCHAR STRING 7 0 7 Linenumber Line Number   2 Да / Yes
PL04004 DATETIME DATE 0 0 8 TranDate Transaction Date      
PL04005 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 PL04009 and PL04010 is used for specifying the accounting string and amount)
   
PL04006 NVARCHAR ACCSTR 120 0 120 Accstring Accounting String      
PL04007 NUMERIC MONEY 28 8 20 Amountlcu Amount (Local Currency)      
PL04008 INT INTEGER 0 0 2 Currcode Currency Code Line      
PL04009 NVARCHAR ACCSTR 120 0 120 Accstringocu Accounting String Line Currency      
PL04010 NUMERIC MONEY 28 8 20 Amountocu Amount (Line Currency)      
PL04011 NVARCHAR VSTRING 36 0 36 Trantext Transaction Line Text      
PL04012 NCHAR STRING 10 0 10 Code1 Supplier Code      
PL04013 NVARCHAR VSTRING 25 0 25 Code2 Invoice Number      
PL04014 NCHAR STRING 6 0 6 Code3 Journal Code      
PL04015 NCHAR STRING 2 0 2 code4 General Ledger Period      
PL04016 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
PL04017 NCHAR STRING 8 0 8 Code6 Transaction Code 6      
PL04018 NCHAR STRING 1 0 1 Tag1 Transaction Tag 1      
PL04019 NCHAR STRING 1 0 1 Tag2 Transaction Tag 2      
PL04020 NCHAR STRING 1 0 1 Tag3 Transaction Tag 3      
PL04021 NCHAR STRING 1 0 1 Tranlinetype Line Type 0 — Other transaction lines

1 — Accounts payable transaction line

2 — Tax accounting transaction line

3 — Accounts payable transaction line (unauthorized invoice)

4 — Tax accounting transaction line (unauthorized invoice)

7 — Periodical allocation transaction

9 — Transaction line is related to a project activity code
   
PL04022 NCHAR STRING 1 0 1 Tranlinesign Amount Sign 0 — Normal Sign (+ debit, — credit)

1 — Reversed Sign (+ credit, — debit)
   
PL04023 NUMERIC NUMBER 20 0 1 Noofdecimals No of Decimals      
PL04024 NCHAR STRING 8 0 8 Linkcode In Closing Period The character ‘i’ indicates that the transaction will be booked in the closing period, otherwise the field will be empty.    
PL04025 NUMERIC X_NUMERIC 28 8 20 Quantity Quantity      
PL04026 INT INTEGER 0 0 4 Unitcode Unit Code      
PL04027 NUMERIC MONEY 28 8 20 Amountccu Amount (Alternative Currency)      
PL04028 NCHAR STRING 13 0 13 Contraacc Contra Account      
PL04029 NUMERIC NUMBER 20 0 6 Journalno Journal Number      
PL04030 NCHAR STRING 9 0 9 Plreference Internal Reference Number      
PL04031 NCHAR STRING 6 0 6 Subprjcode Sub-Project Number      
PL04032 NCHAR STRING 6 0 6 Activitycode Activity Code      
PL04033 NCHAR STRING 8 0 8 Usridupdby UserID for Update      
PL04034 DATETIME DATE 0 0 8 Dateofentry Date Entered      
PL04035 NCHAR STRING 8 0 8 Usridentby UserID for Entry      
PL04036 DATETIME DATE 0 0 8 Dateofupd Date Updated      
PL04037 NVARCHAR VSTRING 36 0 36 TranTextLineCurr Transaction Text (Line Currency)      
PL04038 NCHAR STRING 2 0 2 SourceCompany Source Company      
PL04039 NCHAR STRING 8 0 8 Usridprnby Printed By      
PL04040 DATETIME DATE 0 0 8 Dateofprn Date Printed      
PL04041 NCHAR SWITCH 1 0 1 PrnStatus PrintedStatus      
PL04042 NVARCHAR VSTRING 25 0 25 AASCode AAS code      

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