Таблица: 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 | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Ledger | Recharge Invoice Accounts Receivable Header