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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SL03 — Sales Ledger Invoices

Таблица / Table: SL03 — «Sales Ledger». Маска имени таблицы / Table name mask: «SL03%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL03001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да / Yes
SL03002 NVARCHAR VSTRING 25 0 25 InvoiceNo Invoice Number   2 Да / Yes
SL03003 NVARCHAR VSTRING 9 0 9 TransactNo Transaction Number      
SL03004 DATETIME DATE 0 0 8 InvoiceDate Invoice Date      
SL03005 DATETIME DATE 0 0 8 BookEntryDate Book-Entry Date      
SL03006 DATETIME DATE 0 0 8 DueDate Due Date      
SL03007 DATETIME DATE 0 0 8 DiscntDate1 Discount Date 1      
SL03008 NVARCHAR VSTRING 5 0 5 Discount1 Discount 1 %      
SL03009 DATETIME DATE 0 0 8 DiscntDate2 Discount Date 2      
SL03010 NVARCHAR VSTRING 5 0 5 Discount Discount 2 %      
SL03011 DATETIME DATE 0 0 8 DiscntDate3 Discount Date 3      
SL03012 NVARCHAR VSTRING 5 0 5 Discount3 Discount 3 %      
SL03013 NUMERIC MONEY 28 8 20 InvAmoLocCur Invoice Amount (Local Currency)      
SL03014 NUMERIC MONEY 28 8 20 InvAmoOriCur Invoice Amount (Invoice Currency)      
SL03015 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code Invoice      
SL03016 NUMERIC MONEY 28 8 20 SalesTaxAmo Sales Tax Amount (Local Currency)      
SL03017 NVARCHAR ACCSTR 120 0 120 AccntString Accounting String      
SL03018 NVARCHAR VSTRING 10 0 10 SalesTaxPercent Sales Tax Percentage Only used for US (country code 1)    
SL03019 NUMERIC MONEY 28 8 20 VATPaidLCU VAT payed LCU      
SL03020 NVARCHAR VSTRING 2 0 2 Spare Spare      
SL03021 NVARCHAR VSTRING 1 0 1 InterestBlck Interest Blocked      
SL03022 NVARCHAR VSTRING 1 0 1 ReminderBlck Reminder Blocked      
SL03023 NVARCHAR VSTRING 2 0 2 ReminderSent Number of Reminders Sent      
SL03024 NVARCHAR VSTRING 50 0 50 CommentaryTx Text      
SL03025 NVARCHAR VSTRING 1 0 1 StornoInvoice 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).
   
SL03026 NVARCHAR VSTRING 1 0 1 USTaxType Tax type Only used for US (country code 1) in interface with external tax application.    
SL03027 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
   
SL03028 NVARCHAR VSTRING 1 0 1 InvTypeFlag2 Invoice type, part 2      
SL03029 NVARCHAR VSTRING 1 0 1 ExclFormBillingFlag Included into Billing      
SL03030 NVARCHAR VSTRING 1 0 1 InvoicePaidFlag Invoice paid      
SL03031 NVARCHAR VSTRING 1 0 1 InvTypeFlag3 Invoice type, part 3      
SL03032 NVARCHAR VSTRING 1 0 1 Spare Spare      
SL03033 NVARCHAR VSTRING 1 0 1 TaxDiscFlag Tax discount flag      
SL03034 NVARCHAR VSTRING 1 0 1 Spare Spare      
SL03035 NVARCHAR VSTRING 1 0 1 SourceForInv Source for invoice Invoice created by:

1 — Sales order

2 — On-account invoice for service order

4 — Project

5 — Service order

6 — Contract invoice

8 — Merge invoice in sales ledger
   
SL03036 NVARCHAR VSTRING 12 0 12 OrderNumber Object number Order number is assigned depending on the source of the invoice, it might be a sales order number, service order number, project number or contract number.    
SL03037 NVARCHAR VSTRING 1 0 1 UseField51 [USE FIELD 51]      
SL03038 DATETIME DATE 0 0 8 LatestIntDate Last interest date      
SL03039 NVARCHAR VSTRING 20 0 20 TotIntOriCur Interest charge      
SL03040 NVARCHAR VSTRING 1 0 1 TransactType Transaction type 0 — Normal invoice

1 — Interest invoice

9 — Temporary value assigned during entry of invoices, indicates that entry of invoice has not been completed.
   
SL03041 NVARCHAR VSTRING 3 0 3 Salesman Salesman      
SL03042 NVARCHAR VSTRING 1 0 1 CollectInvoice Collection Invoice Indicates if the invoice has been sent for collection or not.

0 — Invoice has not been sent for collection.

1 — Invoice is in collection status.
   
SL03043 NVARCHAR VSTRING 2 0 2 OrigCompComp Original company code Used for central sales ledger to specify the company where the invoice was created.    
SL03044 NVARCHAR VSTRING 12 0 12 ClearNLAC Clearing Nominal ledger account Used for central sales ledger to specify the clearing account that was used as debt to the subsidiary company.    
SL03045 NVARCHAR VSTRING 1 0 1 CurrContract Forward cover      
SL03046 NUMERIC X_NUMERIC 18 8 10 FixExchRate Fixed Exchange Rate      
SL03047 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
SL03048 NVARCHAR VSTRING 1 0 1 Spare Spare      
SL03049 NVARCHAR VSTRING 1 0 1 Insoluto Insoluto Flag Insoluto (Bill in Suspense)    
SL03050 NVARCHAR VSTRING 1 0 1 Spare Spare      
SL03051 NVARCHAR VSTRING 1 0 1 PaymentLedger Automatic Payment      
SL03052 NVARCHAR VSTRING 2 0 2 SalesTaxCode Tax Code      
SL03053 NUMERIC MONEY 28 8 20 TotPaydAmLCU Paid Amount (Local Currency)      
SL03054 NUMERIC MONEY 28 8 20 TotPaydAmORG Paid Amount (Invoice Currency)      
SL03055 DATETIME DATE 0 0 8 LastPaymDate Last Payment Date      
SL03056 NVARCHAR VSTRING 6 0 6 InterLatePayment Interest %      
SL03057 NCHAR STRING 2 0 2 WayOfPayment Way of Payment      
SL03058 NUMERIC MONEY 28 8 20 DTASentAmount DTA sent amount      
SL03059 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed exchange rate 2      
SL03060 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed exchange rate algorithm      
SL03061 NUMERIC X_NUMERIC 18 8 10 ExchgRate1ByAmo Exchange Rate      
SL03062 NUMERIC X_NUMERIC 18 8 10 ExchgRate2ByAmo Exchange rate 2      
SL03063 NCHAR STRING 3 0 3 ExchgAlgtm Exchange rate algorithm      
SL03064 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI Contract switch      
SL03065 NVARCHAR VSTRING 25 0 25 ReferenceNumber Reference Number      
SL03066 INT INTEGER 0 0 2 RepCurrCode Reporting currency code      
SL03067 NUMERIC MONEY 28 8 20 SalesOrdAmount Purchase order amount      
SL03068 NUMERIC MONEY 28 8 20 AmPaidPNLoc Total paid by PN/PDC LCU      
SL03069 NUMERIC MONEY 28 8 20 AmPaidPNOrig Total paid by PN/PDC ICU      
SL03070 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment proposal number      
SL03071 NVARCHAR VSTRING 10 0 10 SalStatNo Statement number      
SL03072 NVARCHAR VSTRING 25 0 25 RefToInvNo Periodic Billing — Reference      
SL03073 NVARCHAR VSTRING 10 0 10 RefToStatNo Reference to statement number      
SL03074 NUMERIC MONEY 28 8 20 UnrealizedPrLoss Unrealized Profit/Loss      
SL03075 NUMERIC MONEY 28 8 20 Spare Spare      
SL03076 DATETIME DATE 0 0 8 HistInvDate Historical Invoice Date(Billing)      
SL03077 DATETIME DATE 0 0 8 HistDueDate Historical Due Date(Billing)      
SL03078 DATETIME DATE 0 0 8 HistDiscDate1 Historical Discount Date 1(Billing)      
SL03079 NVARCHAR VSTRING 5 0 5 HistDisc1 Historical Discount 1 [%](Billing)      
SL03080 DATETIME DATE 0 0 8 HistDiscDate2 Historical Discount Date 2(Billing)      
SL03081 NVARCHAR VSTRING 5 0 5 HistDisc2 Historical Discount 2 [%](Billing)      
SL03082 DATETIME DATE 0 0 8 HistDiscDate3 Historical Discount Date 3(Billing)      
SL03083 NVARCHAR VSTRING 5 0 5 HistDisc3 Historical Discount 3 [%](Billing)      
SL03084 NVARCHAR VSTRING 15 0 15 GlobalLocationCode Global Location Code      
SL03085 NCHAR STRING 6 0 6 SubObjectNo Sub-Project Number      
SL03086 NVARCHAR VSTRING 9 0 9 OrigTransNum Original Transaction Number      
SL03087 NVARCHAR VSTRING 10 0 10 InvOrdCust Order Customer Code      
SL03088 NCHAR STRING 3 0 3 DocumentType Document Type      
SL03089 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
SL03090 NVARCHAR VSTRING 10 0 10 CFOPCode CFOP Code      
SL03091 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
SL03092 NVARCHAR VSTRING 10 0 10 FiscalTextCode CFOP Fiscal Text Code      
SL03093 NVARCHAR VSTRING 10 0 10 SerialCode Serial Code      
SL03094 NVARCHAR VSTRING 10 0 10 CityCode City      
SL03095 NVARCHAR VSTRING 1 0 1 Detail Detail      
SL03096 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method      
SL03097 NUMERIC MONEY 28 8 20 WithholdTaxLocCur With-holding Tax Amount LCU      
SL03098 NUMERIC MONEY 28 8 20 WithholdTaxOriCur With-holding Tax Amount ICU      
SL03099 NVARCHAR VSTRING 20 0 20 BankNoteNo Bank note number      
SL03100 NUMERIC MONEY 28 8 20 NetInvAmntLCU Net Invoice Amount in Local Currency      
SL03101 NUMERIC MONEY 28 8 20 NetInvAmntOCU Net Invoice Amount in Invoice Currency      
SL03102 NCHAR SWITCH 1 0 1 Instalments Instalments      
SL03103 INT INTEGER 0 0 1 SalesReturnReasonCode Sales Return Reason Code      
SL03104 NVARCHAR VSTRING 25 0 25 TaxNoteNo Tax Note Number      
SL03105 NVARCHAR VSTRING 10 0 10 FinOperationCode2 Financial Operation Code 2      
SL03106 NCHAR STRING 1 0 1 EDIStatus EDI Status      
SL03107 INT INTEGER 0 0 3 NumberOfPages Number Of Pages      
SL03108 NVARCHAR VSTRING 16 0 16 IssuerExtCode Issuer External Code      
SL03109 DATETIME DATE 0 0 8 IssuerExpDate Issuer validity Date      
SL03110 NCHAR STRING 1 0 1 POSMachine POS Machine      
SL03111 DATETIME DATE 0 0 8 TaxNoteRegDate Tax Note Register Date The date of tax note registration.    
SL03112 NCHAR STRING 6 0 6 IssuerCode Invoice Issuer Code      
SL03113 NUMERIC MONEY 28 8 20 CommisionBase Commission Base      
SL03114 NUMERIC MONEY 28 8 20 CommisionWithheldCost Commission Withheld Cost      
SL03115 NVARCHAR VSTRING 1 0 1 CommissionDistrMethod Commission Distribution Method      
SL03116 INT INTEGER 0 0 1 DueDateDefinition Due Date Definition      
SL03117 NVARCHAR VSTRING 2 0 2 PaymentTermCode Payment Term      
SL03118 INT INTEGER 0 0 1 LockPaymentsInvoices Lock Payments for Invoices 0 – Default. Payment can be matched against invoices or Sales Orders.

1 – Payment is ‘locked’ for linking to Sales Order or to matching against invoices.
   
SL03119 INT INTEGER 0 0 3 CorrectionNumber Correction Number Number of corrective Tax Note for Corrective Tax Notes.    
SL03120 NVARCHAR VSTRING 50 0 50 FiscalReference Fiscal Reference      
SL03121 NVARCHAR VSTRING 12 0 12 SpesometroForms Include in Spesometro Form      
SL03122 DATETIME DATE 0 0 8 ReminderDate Reminder Date      
SL03123 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub Type      
SL03124 NCHAR STRING 3 0 3 PaymentCode Payment Code      
SL03125 NCHAR STRING 1 0 1 TaxRegStatus Tax Registration Status      
SL03126 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
SL03127 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      
SL03128 NCHAR STRING 2 0 2 AdvPrepFlag Advance/Prepayment Flag      
SL03129 NUMERIC MONEY 28 8 20 AdvPrepDedAmntLCU Deducted Advance/Prepayment Amount LCU      
SL03130 NUMERIC MONEY 28 8 20 AdvPrepDedAmntOCU Deducted Advance/Prepayment Amount ICU      
SL03131 NCHAR STRING 2 0 2 OwnBankCode1 Own Bank Code 1      
SL03132 NCHAR STRING 2 0 2 OwnBankCode2 Own Bank Code 2      
SL03133 NVARCHAR VSTRING 10 0 10 BankCode1 Bank Code 1      
SL03134 NVARCHAR VSTRING 34 0 34 BankAccount1 Bank Account 1      
SL03135 NVARCHAR VSTRING 10 0 10 BankCode2 Bank Code 2      
SL03136 NVARCHAR VSTRING 34 0 34 BankAccount2 Bank Account 2      
SL03137 DATETIME DATE 0 0 8 TaxRegDate Tax Registration Date      
SL03138 NVARCHAR VSTRING 9 0 9 TaxRegNo Tax Registration No      
SL03139 NCHAR STRING 3 0 3 TaxRegCountry Tax Registration Country      

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