One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SLH3 — Recharge Invoice Accounts Receivable Header

Таблица: SLH3 — «Recharge Invoice Accounts Receivable header master file». Маска имени таблицы: «SLH30000»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLH3001 NCHAR STRING 2 0 2 OriginatingCompany Originating Company   1 Да
SLH3002 NCHAR STRING 10 0 10 MainInvSupplCode Main Invoice Supplier Code   2 Да
SLH3003 NCHAR STRING 25 0 25 MainInvNumber Main Invoice Number   3 Да
SLH3004 NCHAR STRING 6 0 6 TargetEntity Target Company   4 Да
SLH3005 NCHAR SWITCH 1 0 1 UpdatedFlag Updated      
SLH3006 NCHAR SWITCH 1 0 1 CreatedFlag Created      
SLH3007 NUMERIC MONEY 28 8 20 RechargeAmount Recharge Amount      
SLH3008 NUMERIC MONEY 28 8 20 RechargeServiceFee Recharge Service Fee      
SLH3009 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
SLH3010 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number      
SLH3011 NVARCHAR VSTRING 9 0 9 TransactNo Transaction Number      
SLH3012 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SLH3013 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
SLH3014 DATETIME DATE 0 0 8 DueDate Due Date      
SLH3015 DATETIME DATE 0 0 8 DiscDate1 Discount Date 1      
SLH3016 NVARCHAR VSTRING 5 0 5 Disc1 Discount 1 %      
SLH3017 DATETIME DATE 0 0 8 DiscDate2 Discount Date 2      
SLH3018 NVARCHAR VSTRING 5 0 5 Disc2 Discount 2 %      
SLH3019 DATETIME DATE 0 0 8 DiscDate3 Discount Date 3      
SLH3020 NVARCHAR VSTRING 5 0 5 Disc3 Discount 3 %      
SLH3021 NUMERIC MONEY 28 8 20 InvAmoLocCur Invoice Amount (Local Currency)      
SLH3022 NUMERIC MONEY 28 8 20 InvAmoOriCur Invoice Amount (Invoice Currency)      
SLH3023 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Invoice      
SLH3024 NUMERIC MONEY 28 8 20 SalesTaxAmo Sales Tax Amount      
SLH3025 NVARCHAR VSTRING 50 0 50 AccntString Accounting String      
SLH3026 NVARCHAR VSTRING 10 0 10 SalesTaxPerc Sales Tax Percentage      
SLH3027 NUMERIC MONEY 28 8 20 VATPaidLCU Paid VAT Amount (Local Currency)      
SLH3028 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
SLH3029 NVARCHAR VSTRING 1 0 1 InterestBlck Interest Blocked      
SLH3030 NVARCHAR VSTRING 1 0 1 ReminderBlck Reminder Blocked      
SLH3031 NVARCHAR VSTRING 2 0 2 ReminderSent Number of Reminders Sent      
SLH3032 NVARCHAR VSTRING 50 0 50 CommentaryTx Commentary Text      
SLH3033 NVARCHAR VSTRING 1 0 1 Spare Storno Invoice Indicates if the invoice was created by reversing a previously entered invoice, in this case the accounting transactions created for the invoice is booked with reversed sign (negative amounts are booked as debit and positive amounts are booked as credit).
0 — The invoice is a normally entered/created invoice.
1 — The invoice was created as a storno invoice (booked with reversed sings).
   
SLH3034 NVARCHAR VSTRING 1 0 1 Spare Point of Title Passage Only used for US (country code 1) in interface with external tax application.    
SLH3035 NVARCHAR VSTRING 1 0 1 InvTypeFlag1 Invoice Type Used in combination with periodic billing statements:
0 — Regular invoice
1 — Credit note
2 — Re-invoice
3 — Discount
4 — Other Discount
   
SLH3036 NVARCHAR VSTRING 1 0 1 InvTypeFlag2 (obsolete)      
SLH3037 NVARCHAR VSTRING 1 0 1 ExclFormBillingFlag Excluded from Billing      
SLH3038 NVARCHAR VSTRING 1 0 1 InvoicePaidFlag Invoice Paid      
SLH3039 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3040 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3041 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3042 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3043 NVARCHAR VSTRING 1 0 1 SourceForInv Source for Invoice      
SLH3044 NVARCHAR VSTRING 12 0 12 OrderNumber Order Number      
SLH3045 NVARCHAR VSTRING 1 0 1 UseField51 (obsolete)      
SLH3046 DATETIME DATE 0 0 8 LatestIntDate Last Interest Date      
SLH3047 NVARCHAR VSTRING 20 0 20 TotIntOriCur Total Interest Charged (Invoice Currency)      
SLH3048 NVARCHAR VSTRING 1 0 1 TransactType Transaction Type      
SLH3049 NVARCHAR VSTRING 3 0 3 Salesman Salesman      
SLH3050 NVARCHAR VSTRING 1 0 1 CollectInvoice Collection Invoice      
SLH3051 NVARCHAR VSTRING 2 0 2 OrigCompComp Original Company Code      
SLH3052 NVARCHAR VSTRING 12 0 12 ClearNLAC Clearing Account      
SLH3053 NVARCHAR VSTRING 1 0 1 CurrContract Currency Contract      
SLH3054 NUMERIC X_NUMERIC 18 8 10 FixExchRate Fixed Exchange Rate      
SLH3055 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
SLH3056 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3057 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3058 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SLH3059 NVARCHAR VSTRING 1 0 1 PaymentLedger (obsolete)      
SLH3060 NVARCHAR VSTRING 2 0 2 SalesTaxCode VAT Code      
SLH3061 NUMERIC MONEY 28 8 20 TotPaidAmLCU Paid Amount (Local Currency)      
SLH3062 NUMERIC MONEY 28 8 20 TotPaidAmORG Paid Amount (Document Currency)      
SLH3063 DATETIME DATE 0 0 8 LastPaymDate Last Payment Date      
SLH3064 NVARCHAR VSTRING 6 0 6 InterLatePayment Interest Late Payment %      
SLH3065 NCHAR STRING 2 0 2 WayOfPayment Way of Payment      
SLH3066 NUMERIC MONEY 28 8 20 DTASentAmount Sent Payment Amount (Local Currency)      
SLH3067 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
SLH3068 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
SLH3069 NUMERIC X_NUMERIC 18 8 10 ExchgRate1ByAmo Exchange Rate 1      
SLH3070 NUMERIC X_NUMERIC 18 8 10 ExchgRate2ByAmo Exchange Rate 2      
SLH3071 NCHAR STRING 3 0 3 ExchgAlgtm Exchange Algorithm      
SLH3072 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI-Contract      
SLH3073 NCHAR STRING 20 0 20 ReferenceNumber Reference Number      
SLH3074 INT INTEGER 0 0 2 RepCurrCode Currency Code Reporting      
SLH3075 NUMERIC MONEY 28 8 20 SalesOrdAmount Purchase Order Amount      
SLH3076 NUMERIC MONEY 28 8 20 AmPaidPNLoc Total Paid by PN/PDC (Local Currency)      
SLH3077 NUMERIC MONEY 28 8 20 AmPaidPNOrig Total Paid by PN/PDC (Document Currency)      
SLH3078 NVARCHAR VSTRING 6 0 6 PaidPropNo Payment Proposal Number      
SLH3079 NVARCHAR VSTRING 10 0 10 SalStatNo Periodic Billing — Statement Number      
SLH3080 NVARCHAR VSTRING 15 0 15 RefToInvNo Periodic Billing — Reference      
SLH3081 NVARCHAR VSTRING 10 0 10 RefToStatNo Reference to Statement Number      
SLH3082 NUMERIC MONEY 28 8 20 UnrealizedPrLoss Unrealized Profit/Loss (Local Currency)      
SLH3083 NUMERIC MONEY 28 8 20 Spare (obsolete)      
SLH3084 DATETIME DATE 0 0 8 HistInvDate Historical Invoice Date      
SLH3085 DATETIME DATE 0 0 8 HistDueDate Historical Due Date      
SLH3086 DATETIME DATE 0 0 8 HistDiscDate1 Historical Discount Date 1      
SLH3087 NVARCHAR VSTRING 5 0 5 HistDisc1 Historical Discount 1      
SLH3088 DATETIME DATE 0 0 8 HistDiscDate2 Historical Discount Date 2      
SLH3089 NVARCHAR VSTRING 5 0 5 HistDisc2 Historical Discount 2      
SLH3090 DATETIME DATE 0 0 8 HistDiscDate3 Historical Discount Date 3      
SLH3091 NVARCHAR VSTRING 5 0 5 HistDisc3 Historical Discount 3      
SLH3092 NVARCHAR VSTRING 15 0 15 GlobalLocationCode Global Location Code      
SLH3093 NCHAR STRING 6 0 6 SubObjectNo Sub-object Number      
SLH3094 NVARCHAR VSTRING 9 0 9 OrigTransNum Original Transaction Number      
SLH3095 NVARCHAR VSTRING 10 0 10 InvOrdCust Customer Code Order      
SLH3096 NCHAR STRING 3 0 3 DocumentType Document Type      
SLH3097 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
SLH3098 NVARCHAR VSTRING 10 0 10 CFOPCode CFOP Code      
SLH3099 NVARCHAR VSTRING 10 0 10 OperationType Operation Code      
SLH3100 NVARCHAR VSTRING 10 0 10 FiscalTextCode Fiscal Text Code      
SLH3101 NVARCHAR VSTRING 10 0 10 SerialCode Serial Invoice Prefix      
SLH3102 NVARCHAR VSTRING 10 0 10 CityCode City Code      
SLH3103 NVARCHAR VSTRING 1 0 1 Detail Detail      
SLH3104 NCHAR STRING 1 0 1 CashMethod CashMethod      
SLH3105 NUMERIC MONEY 28 8 20 WithholdTaxLocCur WithholdTaxLocCur      
SLH3106 NUMERIC MONEY 28 8 20 WithholdTaxOriCur WithholdTaxOriCur      
SLH3107 NVARCHAR VSTRING 20 0 20 BankNoteNo BankNoteNo      
SLH3108 NUMERIC MONEY 28 8 20 NetInvAmntLCU NetInvAmntLCU      
SLH3109 NUMERIC MONEY 28 8 20 NetInvAmntOCU NetInvAmntOCU      
SLH3110 NCHAR SWITCH 1 0 1 Instalments Instalments      
SLH3111 INT INTEGER 0 0 1 SalesReturnReasonCode SalesReturnReasonCode      
SLH3112 NVARCHAR VSTRING 15 0 15 TaxNoteNo TaxNoteNo      
SLH3113 NVARCHAR VSTRING 10 0 10 FinOperationCode2 FinOperationCode2      
SLH3114 NCHAR STRING 1 0 1 EDIStatus EDIStatus      
SLH3115 INT INTEGER 0 0 3 NumberOfPages NumberOfPages      
SLH3116 NVARCHAR VSTRING 16 0 16 IssuerExtCode IssuerExtCode      
SLH3117 DATETIME DATE 0 0 8 IssuerExpDate IssuerExpDate      
SLH3118 NCHAR STRING 1 0 1 POSMachine POSMachine      
SLH3119 DATETIME DATE 0 0 8 TaxNoteRegDate TaxNoteRegDate      
SLH3120 NCHAR STRING 6 0 6 IssuerCode Issuer Code      
SLH3121 NUMERIC MONEY 28 8 20 CommisionBase Commision Base      
SLH3122 NUMERIC MONEY 28 8 20 CommisionWithheldCost Commision Withheld Cost      
SLH3123 NCHAR STRING 1 0 1 CommissionDistrMethod Commision Distribution Method      
SLH3124 INT INTEGER 0 0 1 DueDateDefinition Due Date Definition      
SLH3125 NCHAR STRING 2 0 2 PaymentTermCode Payment Term Code      
SLH3126 INT INTEGER 0 0 1 LockPaymentsInvoices LockPaymentsInvoices      
SLH3127 INT INTEGER 0 0 3 CorrectionNumber CorrectionNumber      
SLH3128 NVARCHAR VSTRING 50 0 50 FiscalReference Fiscal Reference      
SLH3129 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
SLH3130 DATETIME DATE 0 0 8 ReminderDate Reminder Date      
SLH3131 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      
SLH3132 NCHAR STRING 3 0 3 PaymentCode Payment Code      
SLH3133 NCHAR STRING 1 0 1 TaxRegStatus TaxRegStatus      
SLH3134 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
SLH3135 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      

Навигация: