Таблица: OR41 - «Sales Order Lines Historical Versions». Маска имени таблицы: «OR41%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
OR41001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да
OR41002 NCHAR STRING 6 0 6 LineNumber Line Number   3 Да
OR41003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   4 Да
OR41004 INT INTEGER 0 0 1 LineType Line Type 0 - Normal Order Line Related to Stock Item
1 - Non Stock Item Line (dot item)
   
OR41005 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
OR41006 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
OR41007 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
OR41008 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Order Currency)      
OR41009 NUMERIC MONEY 28 8 20 UnitCostPric Unit Cost Price (Local Currency)      
OR41010 INT INTEGER 0 0 2 UnitCode Unit Code      
OR41011 NUMERIC X_NUMERIC 20 8 12 ORQtyOrdered Quantity Ordered      
OR41012 NUMERIC X_NUMERIC 20 8 12 QtyShipped Quantity Delivered      
OR41013 INT INTEGER 0 0 1 FlagPickList Picking List Status 0 - Line not ready for printing
1 - Line ready for printing on picking list
2 - Line sent on picking list
   
OR41014 INT INTEGER 0 0 2 AcctingCode Accounting Code      
OR41015 NCHAR SWITCH 1 0 1 FLAGBackOrFl Back Order Only used temporary during stock withdraw to indicate the lines that has been delivered during the process, lines with '1' will not be issued when pressing '+' or 'A' to deliver all lines.    
OR41016 INT INTEGER 0 0 1 FLAGLinePrn Line Layout 0 - The line is NOT printed on order documents.
1 - The line is printed with quantity, unit price and line total (Controlled by DDF file).
2 - The line is printed with line total amount only on the documents (Controlled by DDF file).
   
OR41017 NVARCHAR VSTRING 6 0 6 VolDiscount Volume Discount %      
OR41018 NVARCHAR VSTRING 6 0 6 CustDiscount Customer Discount %      
OR41019 DATETIME DATE 0 0 8 IntrPlanning Internal Planning Date      
OR41020 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDel Items per Package (Purchase)      
OR41021 NUMERIC X_NUMERIC 18 8 10 QtyUniOutDel Items per Package (Sales)      
OR41022 NUMERIC X_NUMERIC 18 8 10 SellPrMultip Selling Price Multiplier      
OR41023 NUMERIC X_NUMERIC 18 8 10 CostPrMultip Cost Price Multiplier      
OR41024 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
OR41025 INT INTEGER 0 0 1 ExtraTaxCode Extra Tax Code 0 - Line is not liable for extra tax
1-3 Line is liable for extra tax (rate is defined in stock control)
   
OR41026 INT INTEGER 0 0 1 DistriCostCo Distribution Cost Code      
OR41027 INT INTEGER 0 0 1 ReptOrPriceC Repeat Order Price Option 0 - Use the price defined on the order line when invoicing the order
1 - Get current prices when invoicing the order
   
OR41028 NVARCHAR ACCSTR 50 0 50 AccCodString Accounting String      
OR41029 INT INTEGER 0 0 1 FLAGDelStat Delivery Status      
OR41030 INT INTEGER 0 0 1 FLAGInvStat Invoice Status      
OR41031 INT INTEGER 0 0 1 StockStatus Stock Item Status      
OR41032 BINARY BINSTRING 1 0 1 ShipmentRoul Delivery Rule 0 - No test of the stock balance.
1 - Test on positive stock balance .
2 - Closed stock item, blocked orders.
3 - Direct delivery from supplier to customer.
4 - No over delivery.
5 - Back-delivery to purchase control.
   
OR41033 NUMERIC X_NUMERIC 20 8 12 QtyAlloc Quantity Allocated      
OR41034 NCHAR SWITCH 1 0 1 HasSubitemin Has Sub-items in structure Indicates if the order line is a BoM and there are sub-items attached to the item    
OR41035 NVARCHAR VSTRING 8 0 8 Spare Sales Tax percentage Sales tax percentage used for the order line, this is only applicable when using country code 1 (US) and there the system has been setup to use an external tax system.    
OR41036 NUMERIC MONEY 28 8 20 Spare Sales Tax Amount (Order Currency) Sales tax amount for the order line, this is only applicable when using country code 1 (US) and there the system has been setup to use an external tax system.    
OR41037 DATETIME DATE 0 0 8 DelDateReque Delivery Date Requested      
OR41038 NCHAR SWITCH 1 0 1 FLAGCurrComp Currency Compensation      
OR41039 INT INTEGER 0 0 2 CompCurrNo Currency Code Compensation      
OR41040 NUMERIC X_NUMERIC 28 8 20 OrDExchRate Order Date Exchange Rate      
OR41041 NUMERIC X_NUMERIC 28 8 20 DelivDExRate Delivery Date Exchange Rate      
OR41042 DATETIME DATE 0 0 8 IntrPlanningBO Internal Planning Date Back Order      
OR41043 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
OR41044 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
OR41045 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
OR41046 NVARCHAR VSTRING 6 0 6 WarehouseNo Warehouse      
OR41047 NUMERIC MONEY 28 8 20 StatisPrice Statistical Price (Local Currency)      
OR41048 NUMERIC X_NUMERIC 14 8 6 StatisDisco Statistical Discount      
OR41049 NUMERIC MONEY 28 8 20 StatisCost Statistical Cost Price (Local Currency)      
OR41050 NUMERIC X_NUMERIC 20 8 12 QtyOrig Original Quantity      
OR41051 NVARCHAR VSTRING 6 0 6 PickListNo Picking List Number      
OR41052 NCHAR STRING 1 0 1 DiscountsFrozen Discounts Frozen      
OR41053 NUMERIC X_NUMERIC 20 8 12 QtyAllocated Quantity Allocated      
OR41054 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered      
OR41055 NCHAR SWITCH 1 0 1 FLAGStatupda Statistics Not Updated Used internally during order line entry to indicate if statistics has been updated or not.    
OR41056 NUMERIC X_NUMERIC 20 8 12 QtyReservded Quantity Ordered      
OR41057 NUMERIC X_NUMERIC 18 8 10 UnitConvFact UOM Conversion Factor Conversion factor used to convert between sales unit of measurement and stock unit of measurement.    
OR41058 NUMERIC X_NUMERIC 12 8 4 CustDiscoun1 Customer Discount Calculation Item 1      
OR41059 NUMERIC X_NUMERIC 12 8 4 CustDiscoun2 Customer Discount Calculation Item 2      
OR41060 NUMERIC X_NUMERIC 12 8 4 CustDiscoun3 Customer Discount Calculation Item 3      
OR41061 INT INTEGER 0 0 2 VATCode1 VAT Code 1      
OR41062 INT INTEGER 0 0 2 VATCode2 VAT Code 2      
OR41063 NUMERIC MONEY 28 8 20 OrigDefaulPr Original Default Price (Original Currency) The original price that was given when the order line was created.    
OR41064 NUMERIC X_NUMERIC 14 8 6 OrigDefaCust Original Default Discount The original line discount given when the order line was created.    
OR41065 NVARCHAR VSTRING 15 0 15 InvNoDummy Invoice Number      
OR41066 NVARCHAR VSTRING 10 0 10 SuborderNo Sub-order Number      
OR41067 NVARCHAR VSTRING 10 0 10 PurchaseOrNo Purchase Order Number      
OR41068 NVARCHAR VSTRING 12 0 12 PurchaLineNo Purchase Order Line Number      
OR41069 INT INTEGER 0 0 1 PurcStatFlag Purchase Order Status 0 - Purchase order line created
1 - Purchase order printed
2 - Purchase order line confirmed
3 - Delivery entered for purchase order line
   
OR41070 NCHAR STRING 1 0 1 Status1 Status 1      
OR41071 NCHAR STRING 1 0 1 Status2 Status 2      
OR41072 NCHAR STRING 1 0 1 Status3 Status 3      
OR41073 NCHAR STRING 1 0 1 SubType Sub-type      
OR41074 NVARCHAR VSTRING 27 0 27 Contract Contract Number      
OR41075 NVARCHAR VSTRING 35 0 35 SearchField Search Key      
OR41076 NUMERIC NUMBER 20 0 10 PickingList Picking List Number      
OR41077 NUMERIC X_NUMERIC 18 8 10 CurrExchgRate2 Currency Exchange Rate 2      
OR41078 NCHAR STRING 3 0 3 CurrExchgAlgtm Currency Exchange Algorithm      
OR41079 NUMERIC X_NUMERIC 18 8 10 OrderDateExchgRate2 Order Date Exchange Rate 2      
OR41080 NCHAR STRING 3 0 3 OrderDateExchgAlgtm Order Date Exchange Algorithm      
OR41081 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 Delivery Date Exchange Rate 2      
OR41082 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm Delivery Date Exchange Algorithm      
OR41083 INT INTEGER 0 0 2 CurrencyCode Currency Code Order      
OR41084 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI Contract      
OR41085 INT INTEGER 0 0 2 OrigPriceCurCode Currency Code Original Price      
OR41086 NUMERIC MONEY 28 8 20 OrigUnitPrice Original Unit Price (Original Currency)      
OR41087 NVARCHAR VSTRING 11 0 11 PriceDiscountHistory Price/Discount History      
OR41088 NUMERIC MONEY 28 8 20 CostPriceCC Unit Cost Price (Order Currency)      
OR41089 NCHAR STRING 25 0 25 SiteCode Site Code      
OR41090 DATETIME DATE 0 0 8 TargetDate Target Date      
OR41091 NVARCHAR VSTRING 2 0 2 GRPAltRout Graphical Alternative Routing      
OR41092 DATETIME DATE 0 0 8 GRPStartDate Graphical Planning Start Date      
OR41093 DATETIME DATE 0 0 8 GRPDueDate Graphical Planning Due Date      
OR41094 INT INTEGER 0 0 1 GRPStatus Graphical Status      
OR41095 NVARCHAR VSTRING 1 0 1 DropShipmentline Drop Shipment Line      
OR41096 NCHAR STRING 38 0 38 ORBOMNodeID Order BoM Node      
OR41097 NCHAR STRING 38 0 38 SCBOMNodeID Stock BoM Node      
OR41098 NVARCHAR VSTRING 20 0 20 CustPOLineNo Customer Purchase Order Line Number      
OR41099 NVARCHAR VSTRING 20 0 20 DelCustPOLineNo Delivery Customer Purchase Order Line Number      
OR41100 INT INTEGER 0 0 9 DiscountGroupNumber Discount Group      
OR41101 DATETIME DATE 0 0 8 Date Confirmation Printed Date Confirmation Printed      
OR41102 DATETIME DATE 0 0 8 Date Picking List printed Date Picking List Printed      
OR41103 DATETIME DATE 0 0 8 Date Delivery Proposal Printed Date Delivery Proposal Printed      
OR41104 NCHAR STRING 1 0 1 Blocked for Processing BOM Blocked for Processing      
OR41105 NCHAR STRING 4 0 4 Version Number Version Number   2 Да
OR41106 NUMERIC MONEY 28 8 20 UnitCostPriceCC Unit Cost Price (Alternative Currency)      
OR41107 NVARCHAR VSTRING 1 0 1 DS issue on receipt rule Drop Shipment Issue on Receipt Rule 0 - Receive into Inventory
1 - Receive into Inventory and hard allocate to sales/service order
2 - Receive into Inventory and issue to sales/service order
3 - Issue to sales/service order without inventory update
   
OR41108 NCHAR STRING 6 0 6 TaxCode Tax Code Order Line      
OR41109 NUMERIC MONEY 28 8 20 PriceInclTax Unit Price Including Tax (Order Currency)      
OR41110 NCHAR SWITCH 1 0 1 Use local balance Use local balance      
OR41111 NCHAR SWITCH 1 0 1 Delivery Without Stock Trans        
OR41112 NCHAR STRING 8 0 8 Statistics Line ID        
OR41113 NCHAR SWITCH 1 0 1 Block Price Change   Blocked for automatic price change    
OR41114 DATETIME DATE 0 0 8 ConfDD Confirmed Delivery Date      
OR41115 DATETIME DATE 0 0 8 ConfDDBO Confirmed Delivery Date Back Order      
OR41116 DATETIME DATE 0 0 8 Original Conf.DD Original Confirmed Delivery Date      
OR41117 NVARCHAR VSTRING 25 0 25 NomenclatureNo NomenclatureNo      
OR41118 DATETIME DATE 0 0 8 DelDateAccepted Accepted Delivery Date      
OR41119 NCHAR STRING 10 0 10 Order Customer Code Order Customer Code      
OR41120 NVARCHAR VSTRING 10 0 10 FinOperationCode FinOperationCode      
OR41121 DATETIME DATE 0 0 8 Order Line Pricing Date Order Line Pricing Date      
OR41122 NCHAR STRING 10 0 10 Order Pricing Number Order Pricing Number      
OR41123 NVARCHAR VSTRING 20 0 20 Requested Delivery Time Requested Delivery Time      
OR41124 NVARCHAR VSTRING 20 0 20 Accepted Delivery Time Accepted Delivery Time      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Order | Sales Order Lines Historical Versions