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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL31001 NVARCHAR VSTRING 2 0 2 Object Type   01=Sales Order
02=Service Order
03=Project
04=Direct Invoice
05=Contract		 1 Да
SL31002 NVARCHAR VSTRING 15 0 15 Object Number     2 Да
SL31003 NVARCHAR VSTRING 6 0 6 Sub-Project Code     3 Да
SL31004 NCHAR STRING 6 0 6 Line Number     4 Да
SL31005 NCHAR STRING 1 0 1 Line Type   0-Request
1-Linked Prepayment
2-Adv Invoice		    
SL31006 NVARCHAR VSTRING 10 0 10 Customer Code        
SL31007 NVARCHAR VSTRING 15 0 15 Invoice Number Payment   Invoice Number of the Prepayment    
SL31008 NUMERIC MONEY 28 8 20 Allocated Amount        
SL31009 NUMERIC X_NUMERIC 28 8 20 Advance Percentage   Used for Line type = 2 and Alloc Amnt = 0    
SL31010 NVARCHAR VSTRING 15 0 15 Invoice Number        
SL31011 DATETIME DATE 0 0 8 Invoice Date        
SL31012 NCHAR STRING 1 0 1 Invoice Status   0-not ready;
1-Print;
2-Printed;
3-Updated
   
SL31013 NCHAR STRING 1 0 1 Deduction   0-On-hold for deduction;
1-Deduct
2-Never deduct (service and advances)		    
SL31014 NCHAR SWITCH 1 0 1 Base includes tax   0-Alloc Amnt dont include tax;
1-Alloc Amnt includes tax		    
SL31015 INT INTEGER 0 0 2 Currency Code   Currency Allocation    
SL31016 DATETIME DATE 0 0 8 Due Date   Due date for Request/Advance Invoice    
SL31017 NCHAR STRING 1 0 1 Distribution   Prepayment tax allocation    
SL31018 NVARCHAR VSTRING 40 0 40 Remark text        

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Ledger | Prepayment Allocation Lines