Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: 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 | 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 | 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 | 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 | 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. | ||
PL03100 | INT | INTEGER | 0 | 0 | 1 | Due Date Definition | ||||
PL03101 | NVARCHAR | VSTRING | 2 | 0 | 2 | PaymentTermsCode | PaymentTermsCode |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Ledger | Purchase Ledger Invoices