На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table PLH3 — Recharge Invoice Accounts Payable Header

Таблица / Table: PLH3 — «Recharge Invoice Accounts Payable header master file». Маска имени таблицы / Table name mask: «PLH30000»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PLH3001 NCHAR STRING 2 0 2 OriginatingCompany Originating Company   1 Да / Yes
PLH3002 NCHAR STRING 10 0 10 MainInvSupplCode Main Invoice Supplier Code   2 Да / Yes
PLH3003 NCHAR STRING 25 0 25 MainInvNumber Main Invoice Number   3 Да / Yes
PLH3004 NCHAR STRING 2 0 2 TargetCompanyCode Target Company   4 Да / Yes
PLH3005 NCHAR SWITCH 1 0 1 UpdatedFlag Updated      
PLH3006 NCHAR SWITCH 1 0 1 CreatedFlag Created      
PLH3007 NUMERIC MONEY 28 8 20 RechargeAmount Recharge Amount      
PLH3008 NUMERIC MONEY 28 8 20 RechargeServiceFee Recharge Service Fee      
PLH3009 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PLH3010 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number      
PLH3011 NVARCHAR VSTRING 9 0 9 TransactioNo Transaction Number      
PLH3012 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
PLH3013 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
PLH3014 DATETIME DATE 0 0 8 DueDate Due Date      
PLH3015 DATETIME DATE 0 0 8 DiscDate1 Discount Date 1      
PLH3016 NVARCHAR VSTRING 5 0 5 Disc1 Discount 1      
PLH3017 DATETIME DATE 0 0 8 DiscDate2 Discount Date 2      
PLH3018 NVARCHAR VSTRING 5 0 5 Disc2 Discount 2      
PLH3019 DATETIME DATE 0 0 8 DiscDate3 Discount Date 3      
PLH3020 NVARCHAR VSTRING 5 0 5 Disc3 Discount 3      
PLH3021 NUMERIC MONEY 28 8 20 InvAmoLocCur Invoice Amount (Local Currency)      
PLH3022 NUMERIC MONEY 28 8 20 InvAmoOriCur Invoice Amount (Invoice Currency)      
PLH3023 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Invoice      
PLH3024 NUMERIC MONEY 28 8 20 SalesTaxAmnt Sales Tax Amount (Local Currency)      
PLH3025 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
PLH3026 NVARCHAR VSTRING 9 0 9 TransNoInvoice Transaction Number Invoice      
PLH3027 DATETIME DATE 0 0 8 BEDateInv Book-Entry Date Invoice      
PLH3028 NVARCHAR VSTRING 10 0 10 SupplBankNo Supplier Bank Code      
PLH3029 NCHAR STRING 2 0 2 WayOfPayment Payment Method      
PLH3030 NVARCHAR VSTRING 1 0 1 PaymBlock Blocked for Payment      
PLH3031 NVARCHAR VSTRING 5 0 5 AuthorizCod1 Authorization Code 1      
PLH3032 NVARCHAR VSTRING 50 0 50 CommentaryTx Text      
PLH3033 DATETIME DATE 0 0 8 LatePaymDate Last Payment Date      
PLH3034 NUMERIC MONEY 28 8 20 PaidAmounLCU Paid Amount (Local Currency)      
PLH3035 NUMERIC MONEY 28 8 20 PaidAmounOriCur Paid Amount (Invoice Currency)      
PLH3036 NVARCHAR VSTRING 1 0 1 PaymentSent Payment Sent      
PLH3037 NVARCHAR VSTRING 1 0 1 PaymPriority Payment Priority      
PLH3038 NVARCHAR VSTRING 1 0 1 Spare Red Storno Invoice      
PLH3039 NVARCHAR VSTRING 1 0 1 VATDiffBooked Tax Difference Booked      
PLH3040 NCHAR STRING 1 0 1 RecurrInvUpd Recurring Invoice Updated      
PLH3041 NVARCHAR VSTRING 10 0 10 PurchOrdNo Purchase Order Number      
PLH3042 DATETIME DATE 0 0 8 TRDateInv Transaction Date Invoice      
PLH3043 NVARCHAR VSTRING 22 0 22 Spare (obsolete)      
PLH3044 NUMERIC MONEY 28 8 20 ResVATPaiLCU Amount Sent for Payment      
PLH3045 NVARCHAR VSTRING 1 0 1 RecurrInv Recurring Invoice      
PLH3046 NVARCHAR VSTRING 3 0 3 StateBankCode Central Bank Code      
PLH3047 NVARCHAR VSTRING 1 0 1 PrelimBooking Preliminary Booking      
PLH3048 NVARCHAR VSTRING 9 0 9 InternRefNo Internal Reference Number      
PLH3049 NVARCHAR VSTRING 2 0 2 OrigCompCode Original Company Code (Central Ledger)      
PLH3050 NVARCHAR VSTRING 12 0 12 ClearingNLAC Clearing Account (Central Ledger)      
PLH3051 NVARCHAR VSTRING 40 0 40 ReferenComm Reference      
PLH3052 NVARCHAR VSTRING 1 0 1 CurrContract Currency Contract      
PLH3053 NVARCHAR VSTRING 10 0 10 FixExchgRate Fixed Exchange Rate      
PLH3054 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
PLH3055 NVARCHAR VSTRING 3 0 3 WithHTaxCode With-holding Tax Code      
PLH3056 NVARCHAR VSTRING 1 0 1 PaymentAuth Pay Unauthorized Invoice      
PLH3057 NVARCHAR VSTRING 20 0 20 WithholdTax With-holding Tax Amount (Local Currency)      
PLH3058 NVARCHAR VSTRING 2 0 2 VATCode VAT Code      
PLH3059 NVARCHAR VSTRING 5 0 5 AuthorizCod2 Authorization Code 2      
PLH3060 NVARCHAR VSTRING 8 0 8 TaxCode 1099 Tax Code      
PLH3061 NUMERIC MONEY 28 8 20 Amount 1099 Amount (Local Currency)      
PLH3062 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.    
PLH3063 DATETIME DATE 0 0 8 RepStartDate Repeat Start Date      
PLH3064 DATETIME DATE 0 0 8 RepStopDate Repeat Stop Date      
PLH3065 NUMERIC MONEY 28 8 20 RepAmount Repeat Amount (Invoice Currency)      
PLH3066 NVARCHAR VSTRING 6 0 6 RepPercent Repeat percentage      
PLH3067 NUMERIC X_NUMERIC 13 8 5 WHTax With-holding Tax      
PLH3068 NUMERIC MONEY 28 8 20 VATPaid (obsolete)      
PLH3069 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
PLH3070 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
PLH3071 NUMERIC X_NUMERIC 18 8 10 ExchgRate1ByAmo Exchange Rate (by amount)      
PLH3072 NUMERIC X_NUMERIC 18 8 10 ExchgRate2ByAmo Exchange Rate 2 (by amount)      
PLH3073 NCHAR STRING 3 0 3 ExchgAlgtmByAmo Fixed Exchange Algorithm (by amount)      
PLH3074 NCHAR STRING 20 0 20 ReferenceNumber Reference Number      
PLH3075 INT INTEGER 0 0 2 RepCurrCode Currency Code Reporting      
PLH3076 NUMERIC MONEY 28 8 20 PurchaseOrdAmount Purchase Order Amount (Reporting Currency)      
PLH3077 NUMERIC MONEY 28 8 20 VATDiffAmount VAT Difference Amount (Local Currency)      
PLH3078 NUMERIC MONEY 28 8 20 AmPaidPNLoc Total Paid Amount by PN/PDC (Local Currency)      
PLH3079 NUMERIC MONEY 28 8 20 AmPaidPNOrig Total Paid Amount by PN/PDC (Invoice Currency)      
PLH3080 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number PN      
PLH3081 NVARCHAR VSTRING 10 0 10 SupDivisionCode Supplier Division Code      
PLH3082 NUMERIC MONEY 28 8 20 UnrealizedPrLoss Unrealized Profit/Loss      
PLH3083 NUMERIC MONEY 28 8 20 Spare (obsolete)      
PLH3084 NVARCHAR VSTRING 15 0 15 GlobalLocationCode Global Location Code      
PLH3085 NVARCHAR VSTRING 1 0 1 InvoicePaidFlag Invoice Paid      
PLH3086 NVARCHAR VSTRING 9 0 9 OrigTransNum Original Transaction Number      
PLH3087 NCHAR STRING 3 0 3 DocumentType Document Type      
PLH3088 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
PLH3089 NVARCHAR VSTRING 10 0 10 CFOPCode CFOP Code      
PLH3090 NVARCHAR VSTRING 10 0 10 OperationType Operation Code      
PLH3091 NVARCHAR VSTRING 10 0 10 SerialCode Serial Invoice Prefix      
PLH3092 NVARCHAR VSTRING 10 0 10 FiscalTextCode Fiscal Text Code      
PLH3093 NVARCHAR VSTRING 1 0 1 Detail Detail      
PLH3094 NVARCHAR VSTRING 10 0 10 OrderNo Order Number      
PLH3095 NVARCHAR VSTRING 25 0 25 InvoiceNum Invoice Number      
PLH3096 NVARCHAR VSTRING 1 0 1 InvoiceStatus Invoice Status      
PLH3097 NCHAR STRING 1 0 1 CashMethod Cash Method      
PLH3098 NUMERIC MONEY 28 8 20 WithholdTaxOriCur WithholdTaxOriCur      
PLH3099 NUMERIC MONEY 28 8 20 NetInvAmntLCU NetInvAmntLCU      
PLH3100 NUMERIC MONEY 28 8 20 NetInvAmntOCU NetInvAmntOCU      
PLH3101 NCHAR SWITCH 1 0 1 Instalments Instalments      
PLH3102 NCHAR STRING 6 0 6 IssuerCode IssuerCode      
PLH3103 NVARCHAR VSTRING 16 0 16 IssuerExtCode IssuerExtCode      
PLH3104 DATETIME DATE 0 0 8 IssuerExpDate IssuerExpDate      
PLH3105 NCHAR STRING 1 0 1 POSMachine POSMachine      
PLH3106 NVARCHAR VSTRING 6 0 6 TaxNoteNo TaxNoteNo      
PLH3107 DATETIME DATE 0 0 8 TaxNoteRegDate TaxNoteRegDate      
PLH3108 INT INTEGER 0 0 1 DueDateDefinition Due Date Definition      
PLH3109 NCHAR STRING 2 0 2 PaymentTermsCode PaymentTermsCode      
PLH3110 NCHAR STRING 6 0 6 PaymentTaxLiability PaymentTaxLiability      
PLH3111 INT INTEGER 0 0 3 PaymentBlockReason PaymentBlockReason      
PLH3112 NVARCHAR VSTRING 10 0 10 BrokerSuppliercode Broker Supplier code      
PLH3113 NVARCHAR VSTRING 25 0 25 CustomsDeclarationNumber Customs Declaration Number      
PLH3114 INT INTEGER 0 0 1 AdditionalInvoiceFlag Additional Invoice Flag      
PLH3115 NVARCHAR VSTRING 50 0 50 FiscalKey Fiscal Key      
PLH3116 NVARCHAR VSTRING 20 0 20 FiscalKeyProtocolNo Fiscal Key Protocol No      
PLH3117 DATETIME X_DATETIME 0 0 17 FiscalKeyProtocolDate Fiscal Key Protocol Date      
PLH3118 NVARCHAR VSTRING 150 0 150 ExtUserdefined1 Ext. User defined 1      
PLH3119 NVARCHAR VSTRING 150 0 150 ExtUserdefined2 Ext. User defined 2      
PLH3120 NVARCHAR VSTRING 150 0 150 ExtUserdefined3 Ext. User defined 3      
PLH3121 NVARCHAR VSTRING 150 0 150 ExtUserdefined4 Ext. User defined 4      
PLH3122 NVARCHAR VSTRING 150 0 150 ExtUserdefined5 Ext. User defined 5      
PLH3123 NVARCHAR VSTRING 150 0 150 ExtUserdefined6 Ext. User defined 6      
PLH3124 NVARCHAR VSTRING 150 0 150 ExtUserdefined7 Ext. User defined 7      
PLH3125 NVARCHAR VSTRING 150 0 150 ExtUserdefined8 Ext. User defined 8      
PLH3126 NVARCHAR VSTRING 150 0 150 ExtUserdefined9 Ext. User defined 9      
PLH3127 NVARCHAR VSTRING 150 0 150 ExtUserdefined10 Ext. User defined 10      
PLH3128 NVARCHAR VSTRING 150 0 150 ExtUserdefined11 Ext. User defined 11      
PLH3129 NVARCHAR VSTRING 150 0 150 ExtUserdefined12 Ext. User defined 12      
PLH3130 NVARCHAR VSTRING 150 0 150 ExtUserdefined13 Ext. User defined 13      
PLH3131 NVARCHAR VSTRING 150 0 150 ExtUserdefined14 Ext. User defined 14      
PLH3132 NVARCHAR VSTRING 150 0 150 ExtUserdefined15 Ext. User defined 15      
PLH3133 NVARCHAR VSTRING 150 0 150 ExtUserdefined16 Ext. User defined 16      
PLH3134 NVARCHAR VSTRING 150 0 150 ExtUserdefined17 Ext. User defined 17      
PLH3135 NVARCHAR VSTRING 150 0 150 ExtUserdefined18 Ext. User defined 18      
PLH3136 NVARCHAR VSTRING 150 0 150 ExtUserdefined19 Ext. User defined 19      
PLH3137 NVARCHAR VSTRING 150 0 150 ExtUserdefined20 Ext. User defined 20      
PLH3138 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
PLH3139 NCHAR STRING 1 0 1 SummaryDocument Summary Document      
PLH3140 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      
PLH3141 NVARCHAR VSTRING 25 0 25 AdjustmNo Adjustment Number Adjustment Number (Cancelled Invoice)    
PLH3142 DATETIME DATE 0 0 8 AdjustmDate Adjustment Date Adjustment Date (Cancelled Invoice)    
PLH3143 NVARCHAR VSTRING 50 0 50 AdjustmComment Adjustment Comment Adjustment Comment (Cancelled Invoice)    
PLH3144 NCHAR STRING 2 0 2 AdjustmCode Adjustment Code Adjustment Code (Cancelled Invoice)    
PLH3145 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
PLH3146 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      

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