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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SLH3001 NCHAR STRING 2 0 2 Originating Company Originating Company   1 Да
SLH3002 NCHAR STRING 10 0 10 Main Inv Suppl Code Main Invoice Supplier Code   2 Да
SLH3003 NCHAR STRING 15 0 15 Main Inv Number Main Invoice Number   3 Да
SLH3004 NCHAR STRING 6 0 6 Target Entity Target Company   4 Да
SLH3005 NCHAR SWITCH 1 0 1 Updated Flag Updated      
SLH3006 NCHAR SWITCH 1 0 1 Created Flag Created      
SLH3007 NUMERIC MONEY 28 8 20 Recharge Amount Recharge Amount      
SLH3008 NUMERIC MONEY 28 8 20 Recharge Service Fee Recharge Service Fee      
SLH3009 NVARCHAR VSTRING 10 0 10 Customer Code Customer Code      
SLH3010 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number      
SLH3011 NVARCHAR VSTRING 6 0 6 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 15 0 15 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 6 0 6 Original Transaction Number Original Transaction Number      
SLH3095 NVARCHAR VSTRING 10 0 10 InvOrdCust Customer Code Order      
SLH3096 NCHAR STRING 2 0 2 Document Type 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      

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Sales Ledger | Recharge Invoice Accounts Receivable Header