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

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SL31 — Prepayment Allocation Lines

Таблица / Table: SL31 — «Prepayment Allocation Lines». Маска имени таблицы / Table name mask: «SL31%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SL31001 NVARCHAR VSTRING 2 0 2 ObjectType Object Type 01=Sales Order

02=Service Order

03=Project

04=Direct Invoice

05=Contract		 1 Да / Yes
SL31002 NVARCHAR VSTRING 15 0 15 ObjectNumber Object Number   2 Да / Yes
SL31003 NVARCHAR VSTRING 6 0 6 SubProjectCode Sub-Project Code   3 Да / Yes
SL31004 NCHAR STRING 6 0 6 LineNumber Line Number   4 Да / Yes
SL31005 NCHAR STRING 1 0 1 LineType Line Type 0-Request

1-Linked Prepayment

2-Adv Invoice		    
SL31006 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code      
SL31007 NVARCHAR VSTRING 15 0 15 InvoiceNumberPayment Invoice Number Payment Invoice Number of the Prepayment    
SL31008 NUMERIC MONEY 28 8 20 AllocatedAmount Allocated Amount      
SL31009 NUMERIC X_NUMERIC 28 8 20 AdvancePercentage Advance Percentage Used for Line type = 2 and Alloc Amnt = 0    
SL31010 NVARCHAR VSTRING 15 0 15 InvoiceNumber Invoice Number      
SL31011 DATETIME DATE 0 0 8 InvDate Invoice Date      
SL31012 NCHAR STRING 1 0 1 InvoiceStatus Invoice Status 0-not ready;

1-Print;

2-Printed;

3-Updated
    
SL31013 NCHAR STRING 1 0 1 Deduction Deduction 0-On-hold for deduction;

1-Deduct

2-Never deduct (service and advances)		    
SL31014 NCHAR SWITCH 1 0 1 BaseInclTax Base includes tax 0-Alloc Amnt dont include tax;

1-Alloc Amnt includes tax		    
SL31015 INT INTEGER 0 0 2 CurrencyCode Currency Code Currency Allocation    
SL31016 DATETIME DATE 0 0 8 DueDate Due Date Due date for Request/Advance Invoice    
SL31017 NCHAR STRING 1 0 1 Distribution Distribution Prepayment tax allocation    
SL31018 NVARCHAR VSTRING 40 0 40 RemarkText Remark text      
SL31019 NCHAR STRING 6 0 6 IssuerCode Issuer Code      
SL31020 NVARCHAR VSTRING 15 0 15 TaxNoteNumber Tax note number      
SL31021 NVARCHAR VSTRING 15 0 15 SalesInvoiceNo Sales Invoice No      
SL31022 NUMERIC MONEY 28 8 20 ObjectValue Object Value      
SL31023 INT INTEGER 0 0 2 OrderCurrCode Order Currency Code      
SL31024 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate1 OCU Exchange Rate 1      
SL31025 NCHAR STRING 3 0 3 OCUExchAlgorithm OCU Exchange Algorithm      
SL31026 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate2 OCU Exchange Rate 2      
SL31027 NUMERIC X_NUMERIC 18 8 10 ICUExchangeRate1 ICU Exchange Rate 1      
SL31028 NCHAR STRING 3 0 3 ICUExchAlgorithm ICU Exchange Algorithm      
SL31029 NUMERIC X_NUMERIC 18 8 10 ICUExchangeRate2 ICU Exchange Rate 2      
SL31030 INT INTEGER 0 0 2 InvCurrCode Invoice Currency Code      

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