Таблица: 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 6 0 6 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 15 0 15 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 Spare (obsolete)      
SL03032 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
SL03033 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
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 Spare (obsolete)      
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 NCHAR STRING 20 0 20 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 6 0 6 Original transaction number Original Transaction Number      
SL03087 NVARCHAR VSTRING 10 0 10 InvOrdCust Customer Code Order      
SL03088 NCHAR STRING 2 0 2 Document Type 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)      

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