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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PLH3001 NCHAR STRING 2 0 2 Originating Company Originating Company   1 Да
PLH3002 NCHAR STRING 10 0 10 Main Inv Suppl Code Main Invoice Supplier Code   2 Да
PLH3003 NCHAR STRING 15 0 15 Main Inv Number Main Invoice Number   3 Да
PLH3004 NCHAR STRING 2 0 2 Target Company Code Target Company   4 Да
PLH3005 NCHAR SWITCH 1 0 1 Updated Flag Updated      
PLH3006 NCHAR SWITCH 1 0 1 Created Flag Created      
PLH3007 NUMERIC MONEY 28 8 20 Recharge Amount Recharge Amount      
PLH3008 NUMERIC MONEY 28 8 20 Recharge Service Fee Recharge Service Fee      
PLH3009 NVARCHAR VSTRING 10 0 10 SupplierCode Supplier Code      
PLH3010 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number      
PLH3011 NVARCHAR VSTRING 6 0 6 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 VSTRING 50 0 50 AccString Accounting String      
PLH3026 NVARCHAR VSTRING 6 0 6 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 15 0 15 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 OrderNo 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 6 0 6 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 3 0 3 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 6 0 6 Original Transaction Number Original Transaction Number      
PLH3087 NCHAR STRING 2 0 2 Document Type 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 15 0 15 InvoiceNo Invoice Number      
PLH3096 NVARCHAR VSTRING 1 0 1 InvoiceStatus Invoice Status      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Ledger | Recharge Invoice Accounts Payable Header