Таблица: PL44 - «Prepayment Documents». Маска имени таблицы: «PL44%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL44001 NCHAR STRING 6 0 6 ReferenceNo Reference Number   1 Да
PL44002 NCHAR STRING 8 0 8 UserCode User   2 Да
PL44003 NVARCHAR VSTRING 15 0 15 ChequeNo Cheque Number      
PL44004 NVARCHAR VSTRING 35 0 35 Name Name      
PL44005 NVARCHAR VSTRING 35 0 35 Address1 Address Line 1      
PL44006 NVARCHAR VSTRING 35 0 35 Address2 Address Line 2      
PL44007 NVARCHAR VSTRING 35 0 35 Address3 Address Line 3      
PL44008 NVARCHAR VSTRING 35 0 35 Address4 Address Line 4      
PL44009 NVARCHAR VSTRING 65 0 65 TextLine1 Text Line 1      
PL44010 NVARCHAR VSTRING 65 0 65 TextLine2 Text Line 2      
PL44011 NVARCHAR VSTRING 65 0 65 TextLine3 Text Line 3      
PL44012 DATETIME DATE 0 0 8 ChequeDate Cheque Date      
PL44013 NVARCHAR ACCSTR 50 0 50 AccouString1 (obsolete)      
PL44014 NVARCHAR VSTRING 20 0 20 Amount1 Amount (Local Currency)      
PL44015 NVARCHAR ACCSTR 50 0 50 AccouString2 Currency Conversion Text      
PL44016 NVARCHAR VSTRING 20 0 20 Amount2 (obsolete)      
PL44017 NVARCHAR ACCSTR 50 0 50 AccounString3 (obsolete)      
PL44018 NVARCHAR VSTRING 20 0 20 Amount3 (obsolete)      
PL44019 NVARCHAR ACCSTR 50 0 50 AccounString4 (obsolete)      
PL44020 NVARCHAR VSTRING 20 0 20 Amount4 (obsolete)      
PL44021 NVARCHAR ACCSTR 50 0 50 AccounString5 (obsolete)      
PL44022 NVARCHAR VSTRING 20 0 20 Amount5 (obsolete)      
PL44023 NVARCHAR VSTRING 20 0 20 ChequeAmount Amount (Cheque Currency)      
PL44024 INT INTEGER 0 0 1 ChequePrFlag Cheque Print Status 0 - The cheque has not been printed
1 - The cheque has been printed		    
PL44025 INT INTEGER 0 0 1 DocumLayout Document Layout      
PL44026 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PL44027 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
PL44028 NVARCHAR VSTRING 34 0 34 BankAccNo Bank Account Number      
PL44029 INT INTEGER 0 0 1 BankType Bank Type 0 - No bank information
1 - Bank code and account are used from the supplier
2 - Bank code and account are used from the bank information		    
PL44030 NVARCHAR VSTRING 34 0 34 BankAccNo2 Bank Account Number 2      
PL44031 INT INTEGER 0 0 2 CurrencyCode Currency Code Cheque      
PL44032 NVARCHAR VSTRING 8 0 8 ContractCode Contract Code      
PL44033 NVARCHAR VSTRING 35 0 35 Address5 Address Line 5      
PL44034 NVARCHAR VSTRING 35 0 35 Address6 Address Line 6      
PL44035 NVARCHAR VSTRING 35 0 35 Address7 Address Line 7      
PL44036 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      

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