пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Ledger»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SL03 — Sales Ledger Invoices

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL03001 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code   1 Да
SL03002 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да
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 CurencyCode Currency Code Invoice      
SL03016 NUMERIC MONEY 28 8 20 SalesTaxAmo Sales Tax Amount (Local Currency)      
SL03017 NVARCHAR VSTRING 50 0 50 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 (obsolete)      
SL03020 NVARCHAR VSTRING 2 0 2 Spare (obsolete)      
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 Commentary Text      
SL03025 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).
   
SL03026 NVARCHAR VSTRING 1 0 1 Spare Point of Title Passage 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 (obsolete)      
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 Flag3      
SL03032 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SL03033 NVARCHAR VSTRING 1 0 1 TaxDiscFlag Tax Discount Flag      
SL03034 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
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 Order 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 (obsolete)      
SL03038 DATETIME DATE 0 0 8 LatestIntDate Last Interest Date      
SL03039 NVARCHAR VSTRING 20 0 20 TotIntOriCur Total Interest Charged (Invoice Currency)      
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 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 Currency Contract      
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 (obsolete)      
SL03049 NVARCHAR VSTRING 1 0 1 Insoluto Insoluto (Bill in Suspense) Insoluto (Bill in Suspense)    
SL03050 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SL03051 NVARCHAR VSTRING 1 0 1 PaymentLedger (obsolete)      
SL03052 NVARCHAR VSTRING 2 0 2 SalesTaxCode VAT 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 Late Payment %      
SL03057 NCHAR STRING 2 0 2 WayOfPayment Way of Payment      
SL03058 NUMERIC MONEY 28 8 20 DTASentAmount Sent Payment Amount (Local Currency)      
SL03059 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
SL03060 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
SL03061 NUMERIC X_NUMERIC 18 8 10 ExchgRate1ByAmo Exchange Rate 1      
SL03062 NUMERIC X_NUMERIC 18 8 10 ExchgRate2ByAmo Exchange Rate 2      
SL03063 NCHAR STRING 3 0 3 ExchgAlgtm Exchange Algorithm      
SL03064 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI-Contract      
SL03065 NVARCHAR VSTRING 25 0 25 ReferenceNumber Reference Number      
SL03066 INT INTEGER 0 0 2 RepCurrCode Currency Code Reporting      
SL03067 NUMERIC MONEY 28 8 20 SalesOrdAmount Purchase Order Amount      
SL03068 NUMERIC MONEY 28 8 20 AmPaidPNLoc Total Paid by PN/PDC (Local Currency)      
SL03069 NUMERIC MONEY 28 8 20 AmPaidPNOrig Total Paid by PN/PDC (Invoice Currency)      
SL03070 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number      
SL03071 NVARCHAR VSTRING 10 0 10 SalStatNo Periodic Billing — Statement Number      
SL03072 NVARCHAR VSTRING 15 0 15 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 (Local Currency)      
SL03075 NUMERIC MONEY 28 8 20 Spare (obsolete)      
SL03076 DATETIME DATE 0 0 8 HistInvDate Historical Invoice Date      
SL03077 DATETIME DATE 0 0 8 HistDueDate Historical Due Date      
SL03078 DATETIME DATE 0 0 8 HistDiscDate1 Historical Discount Date 1      
SL03079 NVARCHAR VSTRING 5 0 5 HistDisc1 Historical Discount 1 %      
SL03080 DATETIME DATE 0 0 8 HistDiscDate2 Historical Discount Date 2      
SL03081 NVARCHAR VSTRING 5 0 5 HistDisc2 Historical Discount 2 %      
SL03082 DATETIME DATE 0 0 8 HistDiscDate3 Historical Discount Date 3      
SL03083 NVARCHAR VSTRING 5 0 5 HistDisc3 Historical Discount 3 %      
SL03084 NVARCHAR VSTRING 15 0 15 GlobalLocationCode Global Location Code      
SL03085 NCHAR STRING 6 0 6 SubObjectNo Sub-object Number      
SL03086 NVARCHAR VSTRING 9 0 9 OrigTransNum Original Transaction Number      
SL03087 NVARCHAR VSTRING 10 0 10 InvOrdCust Customer Code Order      
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 Code      
SL03092 NVARCHAR VSTRING 10 0 10 FiscalTextCode Fiscal Text Code      
SL03093 NVARCHAR VSTRING 10 0 10 SerialCode Serial Invoice Prefix      
SL03094 NVARCHAR VSTRING 10 0 10 CityCode City Code      
SL03095 NVARCHAR VSTRING 1 0 1 Detail Detail      
SL03096 NVARCHAR VSTRING 1 0 1 CashMethod Cash Method [0/1]      
SL03097 NUMERIC MONEY 28 8 20 WithholdTaxLocCur With-holding Tax Amount (Local Currency)      
SL03098 NUMERIC MONEY 28 8 20 WithholdTaxOriCur With-holding Tax Amount (Original Currency)      
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 Original Currency      
SL03102 NCHAR SWITCH 1 0 1 Instalments Instalments      
SL03103 INT INTEGER 0 0 1 SalesReturnReasonCode Sales Return Reason Code      
SL03104 NVARCHAR VSTRING 15 0 15 TaxNoteNo TaxNoteNo      
SL03105 NVARCHAR VSTRING 10 0 10 FinOperationCode2 FinOperationCode2      
SL03106 NCHAR STRING 1 0 1 EDIStatus EDI Status      
SL03107 INT INTEGER 0 0 3 NumberOfPages NumberOfPages      
SL03108 NVARCHAR VSTRING 16 0 16 IssuerExtCode IssuerExtCode      
SL03109 DATETIME DATE 0 0 8 IssuerExpDate IssuerExpDate      
SL03110 NCHAR STRING 1 0 1 POSMachine POSMachine      
SL03111 DATETIME DATE 0 0 8 TaxNoteRegDate TaxNoteRegDate The date of tax note registration.    
SL03112 NCHAR STRING 6 0 6 IssuerCode Issuer Code      
SL03113 NUMERIC MONEY 28 8 20 CommisionBase Commision Base      
SL03114 NUMERIC MONEY 28 8 20 CommisionWithheldCost Commision Withheld Cost      
SL03115 NVARCHAR VSTRING 1 0 1 CommissionDistrMethod Commision Distribution Method      
SL03116 INT INTEGER 0 0 1 DueDateDefinition Due Date Definition      
SL03117 NVARCHAR VSTRING 2 0 2 PaymentTermCode Payment Term Code      
SL03118 INT INTEGER 0 0 1 LockPaymentsInvoices Lock Payments 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 Spesometro Forms      
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 TaxRegStatus      
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 OCU      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SL03003 6 6 6 6 6 6 9 9 9 9 9 9 9 9
SL03024 15 15 15 15 15 15 15 15 15 15 15 15 50 50
SL03065 20 20 20 20 20 20 20 20 25 25 25 25 25 25
SL03086 6 6 6 6 6 6 9 9 9 9 9 9 9 9
SL03088 2 2 2 2 2 2 2 2 3 3 3 3 3 3
SL03099 20 20 20 20 20 20 20 20 20 20 20 20
SL03100 28 20 28 20 28 20 28 20 28 20 28 20
SL03101 28 20 28 20 28 20 28 20 28 20 28 20
SL03102 1 1 1 1 1 1 1 1 1 1 1 1
SL03103 0 1 0 1 0 1 0 1 0 1 0 1
SL03104 15 15 15 15 15 15 15 15 15 15 15 15
SL03105 10 10 10 10 10 10 10 10 10 10 10 10
SL03106 1 1 1 1 1 1 1 1 1 1 1 1
SL03107 0 3 0 3 0 3 0 3 0 3 0 3
SL03108 16 16 16 16 16 16 16 16 16 16 16 16
SL03109 0 8 0 8 0 8 0 8 0 8 0 8
SL03110 1 1 1 1 1 1 1 1 1 1 1 1
SL03111 0 8 0 8 0 8 0 8 0 8 0 8
SL03112 4 4 6 6 6 6 6 6 6 6
SL03113 28 20 28 20 28 20 28 20 28 20
SL03114 28 20 28 20 28 20 28 20 28 20
SL03115 1 1 1 1 1 1 1 1 1 1
SL03116 0 1 0 1 0 1 0 1 0 1
SL03117 2 2 2 2 2 2 2 2 2 2
SL03118 0 1 0 1 0 1 0 1
SL03119 0 3 0 3 0 3 0 3
SL03120 50 50 50 50
SL03121 12 12 12 12
SL03122 0 8 0 8
SL03123 2 2 2 2
SL03124 3 3 3 3
SL03125 1 1 1 1
SL03126 20 20
SL03127 20 20
SL03128 2 2
SL03129 28 20
SL03130 28 20

Навигация: