Таблица: PLH6 - «Inter-Company Transaction Entry». Маска имени таблицы: «PLH60000»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PLH6001 NCHAR STRING 2 0 2 OriginatingCompany Originating Company   1 Да
PLH6002 NCHAR STRING 9 0 9 TransNum Transaction Number   2 Да
PLH6003 NCHAR STRING 5 0 5 LineNumber Line Number   3 Да
PLH6004 NCHAR SWITCH 1 0 1 UpdatedFlag Updated Flag      
PLH6005 NCHAR SWITCH 1 0 1 CreatedFlag Created Flag      
PLH6006 NCHAR STRING 2 0 2 TargetCompanyCode Target Company Code      
PLH6007 DATETIME DATE 0 0 8 TranDate Transaction Date      
PLH6008 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 PLH6012 and PLH6013 is used for specifying the accounting string and amount)
   
PLH6009 NVARCHAR ACCSTR 50 0 50 CodingString Accounting String      
PLH6010 NUMERIC MONEY 28 8 20 Amount Amount (Local Currency)      
PLH6011 INT INTEGER 0 0 2 CurrencyCode Currency Code Line      
PLH6012 NVARCHAR ACCSTR 50 0 50 CodingString2 Accounting String (Line Currency)      
PLH6013 NUMERIC MONEY 28 8 20 Amount2 Amount (Line Currency)      
PLH6014 NVARCHAR VSTRING 25 0 25 TranText Transaction Line Text      
PLH6015 NCHAR STRING 10 0 10 Code1 Supplier Code      
PLH6016 NVARCHAR VSTRING 23 0 23 Code2 Invoice Number      
PLH6017 NCHAR STRING 6 0 6 Code4 Journal Code      
PLH6018 NCHAR STRING 2 0 2 Code3 General Ledger Period      
PLH6019 NVARCHAR VSTRING 35 0 35 Code5 Transaction Code 5      
PLH6020 NCHAR STRING 8 0 8 Code6 Transaction Code 6      
PLH6021 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
   
PLH6022 NCHAR STRING 1 0 1 TranLineSign Amount Sign 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit)
   
PLH6023 NUMERIC NUMBER 20 0 1 NumOfDecimals No of Decimals      
PLH6024 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.    
PLH6025 NUMERIC X_NUMERIC 20 8 12 Quantity Quantity      
PLH6026 INT INTEGER 0 0 4 UnitCode Unit Code      
PLH6027 NUMERIC MONEY 28 8 20 AmountCCU Amount (Alternative Currency)      
PLH6028 NUMERIC NUMBER 20 0 6 JournalNumber Journal Number      
PLH6029 NCHAR STRING 9 0 9 PLReference Internal Reference Number      
PLH6030 NCHAR STRING 6 0 6 SubProjectCode Sub-Project Number      
PLH6031 NCHAR STRING 6 0 6 ActivityCode Activity Code      
PLH6032 NCHAR STRING 6 0 6 UserIdentity Entered By      
PLH6033 DATETIME DATE 0 0 8 DateOfEntry Date Entered      
PLH6034 NVARCHAR VSTRING 25 0 25 Text2 Transaction Text (Line Currency)      
PLH6035 NCHAR STRING 10 0 10 DocumentNumber Document Number      
PLH6036 NCHAR STRING 9 0 9 TransactionNumber Transaction Number      
PLH6037 NCHAR STRING 6 0 6 Spare (obsolete)      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Ledger | Inter-Company Transaction Entry