Таблица: PL03 - «Purchase Ledger». Маска имени таблицы: «PL03%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL03001 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code   1 Да
PL03002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да
PL03003 NVARCHAR VSTRING 6 0 6 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 6 0 6 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 15 0 15 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 OrderNo Purchase Order Number      
PL03034 DATETIME DATE 0 0 8 TRDateInv Transaction Date Invoice      
PL03035 NVARCHAR VSTRING 22 0 22 Spare (obsolete)      
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 6 0 6 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 3 0 3 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 3 0 3 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 NCHAR STRING 20 0 20 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 15 0 15 GlobalLocationCode Global Location Code      
PL03077 NVARCHAR VSTRING 1 0 1 InvoicePaidFlag Invoice Paid      
PL03078 NVARCHAR VSTRING 6 0 6 Original transaction number Original Transaction Number      
PL03079 NCHAR STRING 2 0 2 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 Detail Detail      
PL03086 NVARCHAR VSTRING 10 0 10 OrderNo Order Number      
PL03087 NVARCHAR VSTRING 15 0 15 InvoiceNo 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 4 0 4 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.    

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Ledger | Purchase Ledger Invoices