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

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table PLH4 — Recharge Invoice Accounts Payable transaction lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PLH4001 NCHAR STRING 2 0 2 OriginatingCompany Originating Company   1 Да / Yes
PLH4002 NCHAR STRING 10 0 10 MainInvSupplCode Main Invoice Supplier Code   2 Да / Yes
PLH4003 NCHAR STRING 25 0 25 MainInvNumber Main Invoice Number   3 Да / Yes
PLH4004 NCHAR STRING 2 0 2 TargetCompanyCode Target Company Code   4 Да / Yes
PLH4005 NCHAR STRING 7 0 7 LineNumber Line Number   5 Да / Yes
PLH4006 NCHAR SWITCH 1 0 1 UpdatedFlag Updated Flag      
PLH4007 NCHAR SWITCH 1 0 1 CreatedFlag Created Flag      
PLH4008 NCHAR STRING 9 0 9 TransactionNumber Transaction Number      
PLH4009 DATETIME DATE 0 0 8 TranDate Transaction Date      
PLH4010 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 PLH4014 and PLH4015 is used for specifying the accounting string and amount)
   
PLH4011 NVARCHAR ACCSTR 120 0 120 CodingString Accounting String      
PLH4012 NUMERIC MONEY 28 8 20 Amount Amount (Local Currency)      
PLH4013 INT INTEGER 0 0 2 CurrencyCode Currency Code Line      
PLH4014 NVARCHAR ACCSTR 120 0 120 CodingString2 Accounting String (Line Currency)      
PLH4015 NUMERIC MONEY 28 8 20 Amount2 Amount (Line Currency)      
PLH4016 NVARCHAR VSTRING 25 0 25 TranText Transaction Line Text      
PLH4017 NCHAR STRING 10 0 10 Code1 Supplier Code      
PLH4018 NVARCHAR VSTRING 23 0 23 Code2 Invoice Number      
PLH4019 NCHAR STRING 6 0 6 Code4 Journal Code      
PLH4020 NCHAR STRING 2 0 2 Code3 General Ledger Period      
PLH4021 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
PLH4022 NCHAR STRING 8 0 8 Code8 Transaction Code 6      
PLH4023 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)

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

1 — Reversed Sign (+ credit, — debit)
   
PLH4025 NUMERIC NUMBER 20 0 1 NumOfDecimals No of Decimals      
PLH4026 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.    
PLH4027 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
PLH4028 INT INTEGER 0 0 4 UnitCode Unit Code      
PLH4029 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
PLH4030 NUMERIC NUMBER 20 0 6 JournalNumber Journal Number      
PLH4031 NCHAR STRING 9 0 9 PLReference Internal Reference Number      
PLH4032 NCHAR STRING 6 0 6 SubProjectCode Sub-Project Number      
PLH4033 NCHAR STRING 6 0 6 ActivityCode Activity Code      
PLH4034 NCHAR STRING 8 0 8 UserIdentity Entered By      
PLH4035 DATETIME DATE 0 0 8 DateOfEntry Date Entered      
PLH4036 NVARCHAR VSTRING 25 0 25 Text2 Transaction (Text Line Currency)      
PLH4037 NCHAR STRING 4 0 4 Spare (obsolete)      
PLH4038 NVARCHAR VSTRING 25 0 25 AASCode AAS code      

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