One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / 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      
PL03016 NUMERIC MONEY 28 8 20 SalesTaxAmnt Purchase Tax Amount (Local Currency)      
PL03017 NVARCHAR ACCSTR 120 0 120 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 Payment Block      
PL03023 NVARCHAR VSTRING 5 0 5 AuthorizCod1 Authorization code      
PL03024 NVARCHAR VSTRING 50 0 50 CommentaryTx Commentary Text      
PL03025 DATETIME DATE 0 0 8 LatePaymDate Latest 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 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 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 Res payed tax LCU      
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 Unauthorized Flag 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      
PL03042 NVARCHAR VSTRING 12 0 12 ClearingNLAC Clearing Nominal Ledger account      
PL03043 NVARCHAR VSTRING 40 0 40 ReferenComm Payment Text      
PL03044 NVARCHAR VSTRING 1 0 1 CurrContract Forward Cover      
PL03045 NUMERIC X_NUMERIC 18 8 10 FixExchgRate Forward cover exchange rate      
PL03046 NVARCHAR VSTRING 15 0 15 ContractNo Forward cover contract number      
PL03047 NVARCHAR VSTRING 8 0 8 WithHTaxCode With-holding Tax Code      
PL03048 NVARCHAR VSTRING 1 0 1 PaymentAuth Payment Authorization Flag      
PL03049 NUMERIC MONEY 28 8 20 WithholdTaxLocCur Withholding Tax Amount (Local Currency)      
PL03050 NVARCHAR VSTRING 2 0 2 VATCode Tax 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 End Date      
PL03057 NUMERIC MONEY 28 8 20 RepAmount Repeat Amount (Invoice Currency)      
PL03058 NVARCHAR VSTRING 6 0 6 RepPercent Repeat %      
PL03059 NUMERIC X_NUMERIC 13 8 5 WHTax Withholding Tax %      
PL03060 NUMERIC MONEY 28 8 20 VATPaid reserved for VAT Paid LCU      
PL03061 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Forward cover exchange rate 2      
PL03062 NCHAR STRING 3 0 3 FixedExchgAlgtm Forward cover algorithm      
PL03063 NUMERIC X_NUMERIC 18 8 10 ExchgRate1ByAmo Exchange rate 1      
PL03064 NUMERIC X_NUMERIC 18 8 10 ExchgRate2ByAmo Exchange rate 2      
PL03065 NCHAR STRING 3 0 3 ExchgAlgtmByAmo Exchange rate algorithm      
PL03066 NVARCHAR VSTRING 25 0 25 ReferenceNumber International Reference Number      
PL03067 INT INTEGER 0 0 2 RepCurrCode Reporting currency code      
PL03068 NUMERIC MONEY 28 8 20 PurchaseOrdAmount Purchase order amount      
PL03069 NUMERIC MONEY 28 8 20 VATDiffAmount Tax Difference Amount      
PL03070 NUMERIC MONEY 28 8 20 AmPaidPNLoc Total paid by PN/PDC LCU      
PL03071 NUMERIC MONEY 28 8 20 AmPaidPNOrig Total paid by PN/PDC ICU      
PL03072 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment proposal number      
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 <>      
PL03076 NVARCHAR VSTRING 25 0 25 OriginalInvoiceNumber Original Invoice Number      
PL03077 NVARCHAR VSTRING 1 0 1 InvoicePaidFlag Invoice Paid Flag      
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 Type      
PL03083 NVARCHAR VSTRING 10 0 10 SerialCode Serial code      
PL03084 NVARCHAR VSTRING 10 0 10 FiscalTextCode CFOP 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      
PL03090 NUMERIC MONEY 28 8 20 WithholdTaxOriCur With-holding Tax Amount ICU      
PL03091 NUMERIC MONEY 28 8 20 NetInvAmntLCU Net Invoice Amount in Local Currency (Brazil)      
PL03092 NUMERIC MONEY 28 8 20 NetInvAmntOCU Net Invoice Amount in Invoice Currency (Brazil)      
PL03093 NCHAR SWITCH 1 0 1 Instalments Instalment      
PL03094 NCHAR STRING 6 0 6 IssuerCode Document Issuer Code      
PL03095 NVARCHAR VSTRING 16 0 16 IssuerExtCode External Issuer Code      
PL03096 DATETIME DATE 0 0 8 IssuerExpDate Issuer Expiration Date      
PL03097 NCHAR STRING 1 0 1 POSMachine POS Machine      
PL03098 NVARCHAR VSTRING 6 0 6 TaxNoteNo Tax Note Number External Tax note number must be saved to this field.    
PL03099 DATETIME DATE 0 0 8 TaxNoteRegDate Tax Note Register Date The date of tax note registration.    
PL03100 INT INTEGER 0 0 1 DueDateDefinition Due date definition      
PL03101 NVARCHAR VSTRING 2 0 2 PaymentTermsCode Payment Term      
PL03102 NCHAR STRING 6 0 6 PaymentTaxLiability Payment Tax Liability Code PaymentTaxLiabilityCode    
PL03103 INT INTEGER 0 0 3 PaymentBlockReason Payment Block Reason Code      
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 Number      
PL03109 DATETIME X_DATETIME 0 0 17 FiscalKeyProtocolDate Fiscal Key Protocol Date      
PL03110 NVARCHAR VSTRING 150 0 150 ExtUserDefined1 Extended User defined 1      
PL03111 NVARCHAR VSTRING 150 0 150 ExtUserDefined2 Extended User defined 2      
PL03112 NVARCHAR VSTRING 150 0 150 ExtUserDefined3 Extended User defined 3      
PL03113 NVARCHAR VSTRING 150 0 150 ExtUserDefined4 Extended User defined 4      
PL03114 NVARCHAR VSTRING 150 0 150 ExtUserDefined5 Extended User defined 5      
PL03115 NVARCHAR VSTRING 150 0 150 ExtUserDefined6 Extended User defined 6      
PL03116 NVARCHAR VSTRING 150 0 150 ExtUserDefined7 Extended User defined 7      
PL03117 NVARCHAR VSTRING 150 0 150 ExtUserDefined8 Extended User defined 8      
PL03118 NVARCHAR VSTRING 150 0 150 ExtUserDefined9 Extended User defined 9      
PL03119 NVARCHAR VSTRING 150 0 150 ExtUserDefined10 Extended User defined 10      
PL03120 NVARCHAR VSTRING 150 0 150 ExtUserDefined11 Extended User defined 11      
PL03121 NVARCHAR VSTRING 150 0 150 ExtUserDefined12 Extended User defined 12      
PL03122 NVARCHAR VSTRING 150 0 150 ExtUserDefined13 Extended User defined 13      
PL03123 NVARCHAR VSTRING 150 0 150 ExtUserDefined14 Extended User defined 14      
PL03124 NVARCHAR VSTRING 150 0 150 ExtUserDefined15 Extended User defined 15      
PL03125 NVARCHAR VSTRING 150 0 150 ExtUserDefined16 Extended User defined 16      
PL03126 NVARCHAR VSTRING 150 0 150 ExtUserDefined17 Extended User defined 17      
PL03127 NVARCHAR VSTRING 150 0 150 ExtUserDefined18 Extended User defined 18      
PL03128 NVARCHAR VSTRING 150 0 150 ExtUserDefined19 Extended User defined 19      
PL03129 NVARCHAR VSTRING 150 0 150 ExtUserDefined20 Extended User defined 20      
PL03130 NVARCHAR VSTRING 12 0 12 SpesometroForms Include in Spesometro form      
PL03131 NCHAR STRING 1 0 1 SummaryDoc Summary Document      
PL03132 NCHAR STRING 2 0 2 PO3Subtype Sub type      
PL03133 NVARCHAR VSTRING 15 0 15 AdjustmNo Adjustment Number (Cancelled Invoice) Adjustment Number (Cancelled Invoice)    
PL03134 DATETIME DATE 0 0 8 AdjustmDate Adjustment Date (Cancelled Invoice) Adjustment Date (Cancelled Invoice)    
PL03135 NVARCHAR VSTRING 50 0 50 AdjustmComment Adjustment Comment (Cancelled Invoice) Adjustment Comment (Cancelled Invoice)    
PL03136 NCHAR STRING 2 0 2 AdjustmCode Adjustment Code (Cancelled invoice) 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: