One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PL03 — Purchase Ledger Invoices

Таблица / Table: PL03 — «Purchase Ledger». Маска имени таблицы / Table name mask: «PL03%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL03001 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code   1 Да / Yes
PL03002 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number   2 Да / Yes
PL03003 NVARCHAR VSTRING 9 0 9 TransactioNo Transaction Number General ledger transaction number for the transaction created when the invoice was created. If the invoice is first entered as an unauthorized invoice, this field will hold the transaction number for the transaction created for the authorized invoice and column PL03018 will hold the transaction number for the authorized invoice transaction.    
PL03004 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PL03005 DATETIME DATE 0 0 8 BookEntrDate Book-Entry Date Book-entry for the transaction created when the invoice was entered. If the invoice is first entered as an unauthorized invoice, this field will hold the book-entry date for the transaction created for the authorized invoice and column PL03019 will hold the book-entry date for the authorized invoice transaction.    
PL03006 DATETIME DATE 0 0 8 DueDate Due Date      
PL03007 DATETIME DATE 0 0 8 DiscDate1 Discount Date 1      
PL03008 NVARCHAR VSTRING 5 0 5 Discount1 Discount 1 %      
PL03009 DATETIME DATE 0 0 8 DiscDate2 Discount Date 2      
PL03010 NVARCHAR VSTRING 5 0 5 Discount2 Discount 2 %      
PL03011 DATETIME DATE 0 0 8 DiscDate3 Discount Date 3      
PL03012 NVARCHAR VSTRING 5 0 5 Discount3 Discount 3 %      
PL03013 NUMERIC MONEY 28 8 20 InvAmoLocCur Invoice Amount (Local Currency)      
PL03014 NUMERIC MONEY 28 8 20 InvAmoOriCur Invoice Amount (Invoice Currency)      
PL03015 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Invoice      
PL03016 NUMERIC MONEY 28 8 20 SalesTaxAmnt Sales Tax Amount (Local Currency)      
PL03017 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
PL03018 NVARCHAR VSTRING 9 0 9 TransNoInvoice Transaction Number Invoice General ledger transaction number for the transaction created when a invoice is entered as authorized. This field is only used when the invoice is first entered as unauthorized, otherwise column PL03003 is used to store the transaction number for the invoice.    
PL03019 DATETIME DATE 0 0 8 BEDateInv Book-Entry Date Invoice Book-entry date for the transaction created when a invoice is entered as authorized. This field is only used when the invoice is first entered as unauthorized, otherwise column PL03004 is used to store the book-entry date for the invoice.    
PL03020 NVARCHAR VSTRING 10 0 10 SupplBankNo Supplier Bank Code      
PL03021 NCHAR STRING 2 0 2 WayOfPayment Payment Method      
PL03022 NVARCHAR VSTRING 1 0 1 PaymBlock Blocked for Payment      
PL03023 NVARCHAR VSTRING 5 0 5 AuthorizCod1 Authorization Code      
PL03024 NVARCHAR VSTRING 50 0 50 CommentaryTx Text      
PL03025 DATETIME DATE 0 0 8 LatePaymDate Last Payment Date      
PL03026 NUMERIC MONEY 28 8 20 PaidAmounLCU Paid Amount (Local Currency)      
PL03027 NUMERIC MONEY 28 8 20 PaiAmoOriCur Paid Amount (Invoice Currency)      
PL03028 NVARCHAR VSTRING 1 0 1 PaymentSent Payment Sent      
PL03029 NVARCHAR VSTRING 1 0 1 PaymPriority Payment Priority      
PL03030 NVARCHAR VSTRING 1 0 1 Spare Red Storno Invoice      
PL03031 NVARCHAR VSTRING 1 0 1 VATDiffBooked Tax Difference Booked      
PL03032 NCHAR STRING 1 0 1 RecurrInvUpd Recurring Invoice Updated      
PL03033 NVARCHAR VSTRING 10 0 10 PurchOrdNo Purchase Order Number      
PL03034 DATETIME DATE 0 0 8 TRDateInv Transaction Date Invoice      
PL03035 NUMERIC MONEY 28 8 20 WithHTaxBase Withholding Tax Base This field should contain the withholding tax base.    
PL03036 NUMERIC MONEY 28 8 20 ResVATPaiLCU Amount Sent for Payment      
PL03037 NVARCHAR VSTRING 1 0 1 RecurrInv Recurring Invoice      
PL03038 NVARCHAR VSTRING 4 0 4 StateBankCode Central Bank Code      
PL03039 NVARCHAR VSTRING 1 0 1 PrelimBooking Preliminary Booking 0 — The invoice is entered as authorized.

1 — The invoice is only entered as authorized :(Only used in older versions of Scala)

2 — The invoice is only entered as authorized: No book-entry was made for the unauthorized invoices.

3 — The invoice is only entered as authorized: Debit & TAX amounts was booked directly; but cost was book to a control account setup in the automatic account schedule (pos. 24).

4 — The invoice is only entered as authorized: TAX, Debit and Cost are booked to control accounts setup in the automatic account schedule (pos. 23 — 25).		    
PL03040 NVARCHAR VSTRING 9 0 9 InternRefNo Internal Reference Number      
PL03041 NVARCHAR VSTRING 2 0 2 OrigCompCode Original Company Code (Central Ledger)      
PL03042 NVARCHAR VSTRING 12 0 12 ClearingNLAC Clearing Account (Central Ledger)      
PL03043 NVARCHAR VSTRING 40 0 40 ReferenComm Reference      
PL03044 NVARCHAR VSTRING 1 0 1 CurrContract Currency Contract      
PL03045 NVARCHAR VSTRING 10 0 10 FixExchgRate Fixed Exchange Rate      
PL03046 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
PL03047 NVARCHAR VSTRING 8 0 8 WithHTaxCode With-holding Tax Code      
PL03048 NVARCHAR VSTRING 1 0 1 PaymentAuth Pay Unauthorized Invoice      
PL03049 NUMERIC MONEY 28 8 20 WithholdTaxLocCur With-holding Tax Amount (Local Currency)      
PL03050 NVARCHAR VSTRING 2 0 2 VATCode VAT Code      
PL03051 NVARCHAR VSTRING 5 0 5 AuthoriCode2 Authorization Code 2      
PL03052 NVARCHAR VSTRING 8 0 8 TaxCode 1099 Tax Code      
PL03053 NUMERIC MONEY 28 8 20 Amount 1099 Amount (Local Currency)      
PL03054 NVARCHAR VSTRING 4 0 4 RepeatInterval Repeat Interval Specifies the time interval between each recurring invoice where a leading character ‘W’ means number of weeks, ‘M’ number of month and without leading character it’s number of days.    
PL03055 DATETIME DATE 0 0 8 RepStartDate Repeat Start Date      
PL03056 DATETIME DATE 0 0 8 RepStopDate Repeat Stop Date      
PL03057 NUMERIC MONEY 28 8 20 RepAmount Repeat Amount (Invoice Currency)      
PL03058 NVARCHAR VSTRING 6 0 6 RepPercent Repeat percentage      
PL03059 NUMERIC X_NUMERIC 13 8 5 WHTax With-holding Tax      
PL03060 NUMERIC MONEY 28 8 20 VATPaid (obsolete)      
PL03061 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
PL03062 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
PL03063 NUMERIC X_NUMERIC 18 8 10 ExchgRate1ByAmo Exchange Rate (by amount)      
PL03064 NUMERIC X_NUMERIC 18 8 10 ExchgRate2ByAmo Exchange Rate 2 (by amount)      
PL03065 NCHAR STRING 3 0 3 ExchgAlgtmByAmo Fixed Exchange Algorithm (by amount)      
PL03066 NVARCHAR VSTRING 25 0 25 ReferenceNumber Reference Number      
PL03067 INT INTEGER 0 0 2 RepCurrCode Currency Code Reporting      
PL03068 NUMERIC MONEY 28 8 20 PurchaseOrdAmount Purchase Order Amount (Reporting Currency)      
PL03069 NUMERIC MONEY 28 8 20 VATDiffAmount VAT Difference Amount (Local Currency)      
PL03070 NUMERIC MONEY 28 8 20 AmPaidPNLoc Total Paid Amount by PN/PDC (Local Currency)      
PL03071 NUMERIC MONEY 28 8 20 AmPaidPNOrig Total Paid Amount by PN/PDC (Invoice Currency)      
PL03072 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number PN      
PL03073 NVARCHAR VSTRING 10 0 10 SupDivisionCode Supplier Division Code      
PL03074 NUMERIC MONEY 28 8 20 UnrealizedPrLoss Unrealized Profit/Loss      
PL03075 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PL03076 NVARCHAR VSTRING 25 0 25 OriginalInvoiceNumber Original Invoice Number      
PL03077 NVARCHAR VSTRING 1 0 1 InvoicePaidFlag Invoice Paid      
PL03078 NVARCHAR VSTRING 9 0 9 OrigTransNum Original Transaction Number      
PL03079 NCHAR STRING 3 0 3 DocumentType Document Type      
PL03080 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
PL03081 NVARCHAR VSTRING 10 0 10 CFOPCode CFOP Code      
PL03082 NVARCHAR VSTRING 10 0 10 OperationType Operation Code      
PL03083 NVARCHAR VSTRING 10 0 10 SerialCode Serial Invoice Prefix      
PL03084 NVARCHAR VSTRING 10 0 10 FiscalTextCode Fiscal Text Code      
PL03085 NVARCHAR VSTRING 1 0 1 CorrectionNumber Correction number      
PL03086 NVARCHAR VSTRING 10 0 10 OrderNo Order Number      
PL03087 NVARCHAR VSTRING 25 0 25 InvoiceNum Invoice Number      
PL03088 NVARCHAR VSTRING 1 0 1 InvoiceStatus Invoice Status      
PL03089 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method [0/1]      
PL03090 NUMERIC MONEY 28 8 20 WithholdTaxOriCur With-holding Tax Amount (Original Currency)      
PL03091 NUMERIC MONEY 28 8 20 NetInvAmntLCU Net Invoice Amount in Local Currency      
PL03092 NUMERIC MONEY 28 8 20 NetInvAmntOCU Net Invoice Amount in Original Currency      
PL03093 NCHAR SWITCH 1 0 1 Instalments Instalments      
PL03094 NCHAR STRING 6 0 6 IssuerCode IssuerCode      
PL03095 NVARCHAR VSTRING 16 0 16 IssuerExtCode IssuerExtCode      
PL03096 DATETIME DATE 0 0 8 IssuerExpDate IssuerExpDate      
PL03097 NCHAR STRING 1 0 1 POSMachine POSMachine      
PL03098 NVARCHAR VSTRING 6 0 6 TaxNoteNo TaxNoteNo External Tax note number must be saved to this field.    
PL03099 DATETIME DATE 0 0 8 TaxNoteRegDate TaxNoteRegDate The date of tax note registration.    
PL03100 INT INTEGER 0 0 1 DueDateDefinition Due Date Definition      
PL03101 NVARCHAR VSTRING 2 0 2 PaymentTermsCode PaymentTermsCode      
PL03102 NCHAR STRING 6 0 6 PaymentTaxLiability PaymentTaxLiability PaymentTaxLiabilityCode    
PL03103 INT INTEGER 0 0 3 PaymentBlockReason Payment Block Reason      
PL03104 NVARCHAR VSTRING 10 0 10 BrokerSuppliercode Broker Supplier code      
PL03105 NVARCHAR VSTRING 25 0 25 CustomsDeclarationNumber Customs Declaration Number      
PL03106 INT INTEGER 0 0 1 AdditionalInvoiceFlag Additional Invoice Flag      
PL03107 NVARCHAR VSTRING 50 0 50 FiscalKey Fiscal Key      
PL03108 NVARCHAR VSTRING 20 0 20 FiscalKeyProtocolNo Fiscal Key Protocol No      
PL03109 DATETIME X_DATETIME 0 0 17 FiscalKeyProtocolDate Fiscal Key Protocol Date      
PL03110 NVARCHAR VSTRING 150 0 150 ExtUserDefined1 Ext. User Defined 1      
PL03111 NVARCHAR VSTRING 150 0 150 ExtUserDefined2 Ext. User Defined 2      
PL03112 NVARCHAR VSTRING 150 0 150 ExtUserDefined3 Ext. User Defined 3      
PL03113 NVARCHAR VSTRING 150 0 150 ExtUserDefined4 Ext. User Defined 4      
PL03114 NVARCHAR VSTRING 150 0 150 ExtUserDefined5 Ext. User Defined 5      
PL03115 NVARCHAR VSTRING 150 0 150 ExtUserDefined6 Ext. User Defined 6      
PL03116 NVARCHAR VSTRING 150 0 150 ExtUserDefined7 Ext. User Defined 7      
PL03117 NVARCHAR VSTRING 150 0 150 ExtUserDefined8 Ext. User Defined 8      
PL03118 NVARCHAR VSTRING 150 0 150 ExtUserDefined9 Ext. User Defined 9      
PL03119 NVARCHAR VSTRING 150 0 150 ExtUserDefined10 Ext. User Defined 10      
PL03120 NVARCHAR VSTRING 150 0 150 ExtUserDefined11 Ext. User Defined 11      
PL03121 NVARCHAR VSTRING 150 0 150 ExtUserDefined12 Ext. User Defined 12      
PL03122 NVARCHAR VSTRING 150 0 150 ExtUserDefined13 Ext. User Defined 13      
PL03123 NVARCHAR VSTRING 150 0 150 ExtUserDefined14 Ext. User Defined 14      
PL03124 NVARCHAR VSTRING 150 0 150 ExtUserDefined15 Ext. User Defined 15      
PL03125 NVARCHAR VSTRING 150 0 150 ExtUserDefined16 Ext. User Defined 16      
PL03126 NVARCHAR VSTRING 150 0 150 ExtUserDefined17 Ext. User Defined 17      
PL03127 NVARCHAR VSTRING 150 0 150 ExtUserDefined18 Ext. User Defined 18      
PL03128 NVARCHAR VSTRING 150 0 150 ExtUserDefined19 Ext. User Defined 19      
PL03129 NVARCHAR VSTRING 150 0 150 ExtUserDefined20 Ext. User Defined 20      
PL03130 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
PL03131 NCHAR STRING 1 0 1 SummaryDoc Summary Document      
PL03132 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      
PL03133 NVARCHAR VSTRING 15 0 15 AdjustmNo Adjustment Number Adjustment Number (Cancelled Invoice)    
PL03134 DATETIME DATE 0 0 8 AdjustmDate Adjustment Date Adjustment Date (Cancelled Invoice)    
PL03135 NVARCHAR VSTRING 50 0 50 AdjustmComment Adjustment Comment Adjustment Comment (Cancelled Invoice)    
PL03136 NCHAR STRING 2 0 2 AdjustmCode Adjustment Code Adjustment Code (Cancelled Invoice)    
PL03137 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
PL03138 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      
PL03139 NCHAR SWITCH 1 0 1 TaxDiscFlag Tax Discount Flag      

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