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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
OR21001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да
OR21002 NCHAR STRING 6 0 6 LineNo Line Number   3 Да
OR21003 NCHAR STRING 6 0 6 StrucLineNo Sub-line Number   4 Да
OR21004 INT INTEGER 0 0 1 LineType Line Type 0 - Normal Order Line Related to Stock Item
1 - Non Stock Item Line (dot item)		    
OR21005 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
OR21006 NVARCHAR VSTRING 25 0 25 DescripLine1 Description Line 1      
OR21007 NVARCHAR VSTRING 25 0 25 DescripLine2 Description Line 2      
OR21008 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Order Currency)      
OR21009 NUMERIC MONEY 28 8 20 UnitCostPric Unit Cost Price (Local Currency)      
OR21010 INT INTEGER 0 0 4 UnitCode Unit Code      
OR21011 NUMERIC X_NUMERIC 20 8 12 QtyOrdered Quantity Ordered      
OR21012 NUMERIC X_NUMERIC 20 8 12 QtyShipped Quantity Delivered      
OR21013 INT INTEGER 0 0 1 Spare Picking List Status 0 - Line not ready for printing
1 - Line ready for printing on picking list
2 - Line sent on picking list		    
OR21014 NCHAR STRING 2 0 2 AccountCode1 Accounting Code 1      
OR21015 NCHAR SWITCH 1 0 1 BackOrdrFlag 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.    
OR21016 INT INTEGER 0 0 1 LinePrntFlag 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).		    
OR21017 NVARCHAR VSTRING 6 0 6 VolDiscount Volume Discount %      
OR21018 NVARCHAR VSTRING 6 0 6 CustDiscount Customer Discount %      
OR21019 DATETIME DATE 0 0 8 IntrPlanning Internal Planning Date      
OR21020 NUMERIC X_NUMERIC 18 8 10 QtyUnInDeliv Items per Package (Purchase)      
OR21021 NUMERIC X_NUMERIC 18 8 10 QtyUnOutDeli Items per Package (Sales)      
OR21022 NUMERIC X_NUMERIC 18 8 10 SellPrMultip Selling Price Multiplier      
OR21023 NUMERIC X_NUMERIC 18 8 10 CostPrMultip Cost Price Multiplier      
OR21024 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
OR21025 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)		    
OR21026 INT INTEGER 0 0 1 DistCostCode Distribution Cost Code      
OR21027 INT INTEGER 0 0 1 RepOrPrcCode 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		    
OR21028 NVARCHAR ACCSTR 50 0 50 AccounString Accounting String      
OR21029 INT INTEGER 0 0 1 FLAGDeliStat Delivery Status      
OR21030 INT INTEGER 0 0 1 FLAGInvStat Invoice Status      
OR21031 INT INTEGER 0 0 1 StockStatus Stock Item Status      
OR21032 BINARY BINSTRING 1 0 1 ShipmRoule 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.		    
OR21033 NUMERIC X_NUMERIC 20 8 12 QyAllocated Quantity Allocated      
OR21034 NCHAR SWITCH 1 0 1 FLAGHasSubIt Has Sub-items in structure Indicates if the order line is a BoM and there are sub-items attached to the item    
OR21035 NVARCHAR VSTRING 8 0 8 ItemType Item Type      
OR21036 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.    
OR21037 DATETIME DATE 0 0 8 DelivDateReq Delivery Date Requested      
OR21038 NCHAR SWITCH 1 0 1 FLAGCurrComp Currency Compensation      
OR21039 INT INTEGER 0 0 2 CompensCurr Currency Code Compensation      
OR21040 NUMERIC MONEY 28 8 20 OrDateExch Order Date Exchange Rate      
OR21041 NUMERIC X_NUMERIC 28 8 20 OR2141SPARE Delivery Date Exchange Rate      
OR21042 DATETIME DATE 0 0 8 IntrPlanningBO Internal Planning Date Back Order      
OR21043 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
OR21044 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
OR21045 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
OR21046 NVARCHAR VSTRING 6 0 6 WarehouseID Warehouse      
OR21047 NUMERIC MONEY 28 8 20 StatistPrice Statistical Price (Local Currency)      
OR21048 NUMERIC X_NUMERIC 14 8 6 StatiDiscou Statistical Discount      
OR21049 NUMERIC MONEY 28 8 20 StatCostPrc Statistical Cost Price (Local Currency)      
OR21050 NUMERIC X_NUMERIC 20 8 12 QtyOriginal Original Quantity      
OR21051 NVARCHAR VSTRING 6 0 6 Spare Picking List Number      
OR21052 NCHAR STRING 1 0 1 DiscountsFrozen Discounts Frozen      
OR21053 NUMERIC X_NUMERIC 20 8 12 Spare Quantity Allocated      
OR21054 NUMERIC X_NUMERIC 20 8 12 Spare Quantity Delivered      
OR21055 NCHAR SWITCH 1 0 1 FLAGStatNot Statistics Not Updated Used internally during order line entry to indicate if statistics has been updated or not.    
OR21056 NUMERIC X_NUMERIC 20 8 12 Spare Quantity Ordered      
OR21057 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.    
OR21058 NUMERIC X_NUMERIC 12 8 4 CusDisCalIt1 Customer Discount Calculation Item 1      
OR21059 NUMERIC X_NUMERIC 12 8 4 CusDisCalIt2 Customer Discount Calculation Item 2      
OR21060 NUMERIC X_NUMERIC 12 8 4 CusDisCalIt3 Customer Discount Calculation Item 3      
OR21061 INT INTEGER 0 0 2 VATCode1099 VAT Code 1      
OR21062 INT INTEGER 0 0 2 VATCode2099 VAT Code 2      
OR21063 NUMERIC MONEY 28 8 20 OrigDefaPri Original Default Price (Original Currency) The original price that was given when the order line was created.    
OR21064 NUMERIC X_NUMERIC 14 8 6 OriDefCusCod Original Default Discount The original line discount given when the order line was created.    
OR21065 NVARCHAR VSTRING 15 0 15 InvoiceNo Invoice Number   2 Да
OR21066 NVARCHAR VSTRING 10 0 10 SuborderNo Sub-order Number      
OR21067 NVARCHAR VSTRING 10 0 10 PurchaseOrNo Purchase Order Number      
OR21068 NVARCHAR VSTRING 12 0 12 PurchaLineNo Purchase Order Line Number      
OR21069 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		    
OR21070 NCHAR STRING 1 0 1 Status1 Status 1      
OR21071 NCHAR STRING 1 0 1 Status2 Status 2      
OR21072 NCHAR STRING 1 0 1 Status3 Status 3      
OR21073 NCHAR STRING 1 0 1 SubType Sub-type      
OR21074 NVARCHAR VSTRING 27 0 27 Contract Contract Number      
OR21075 NVARCHAR VSTRING 35 0 35 SearchField Search Key      
OR21076 NUMERIC NUMBER 20 0 10 PickingList Picking List Number      
OR21077 NUMERIC X_NUMERIC 18 8 10 Curexrate2 Currency Exchange Rate 2      
OR21078 NCHAR STRING 3 0 3 Curexalgm Currency Exchange Algorithm      
OR21079 NUMERIC X_NUMERIC 18 8 10 Orddtexrate2 Order Date Exchange Rate 2      
OR21080 NCHAR STRING 3 0 3 Orddtexalgm Order Date Exchange Algorithm      
OR21081 NUMERIC X_NUMERIC 18 8 10 Deldtexrate2 Delivery Date Exchange Rate 2      
OR21082 NCHAR STRING 3 0 3 Deldtexalgm Delivery Date Exchange Algorithm      
OR21083 INT INTEGER 0 0 2 Currcode Currency Code Order      
OR21084 NCHAR SWITCH 1 0 1 Ediswitch EDI Contract      
OR21085 INT INTEGER 0 0 2 OrigPriceCurCode Currency Code Original Price      
OR21086 NUMERIC MONEY 28 8 20 OrigUnitPrice Original Unit Price (Original Currency)      
OR21087 NVARCHAR VSTRING 11 0 11 PriceDiscountHistory Price/Discount History      
OR21088 NUMERIC MONEY 28 8 20 CostPriceCC Unit Cost Price (Order Currency)      
OR21089 NCHAR STRING 25 0 25 SiteCode Site Code      
OR21090 DATETIME DATE 0 0 8 TargetDate Target Date      
OR21091 NVARCHAR VSTRING 2 0 2 GRPAltRout Graphical Alternative Routing      
OR21092 DATETIME DATE 0 0 8 GRPStartDate Graphical Planning Start Date      
OR21093 DATETIME DATE 0 0 8 GRPDueDate Graphical Planning Due Date      
OR21094 INT INTEGER 0 0 1 GRPStatus Graphical Status      
OR21095 NVARCHAR VSTRING 1 0 1 DropShipmentline Drop Shipment Line      
OR21096 NCHAR STRING 38 0 38 ORBOMNodeID BoM Node ID Order      
OR21097 NCHAR STRING 38 0 38 SCBOMNodeID BoM Node ID Stock      
OR21098 NVARCHAR VSTRING 20 0 20 CustPOLineNo Customer Purchase Order Line Number      
OR21099 NVARCHAR VSTRING 20 0 20 DelCustPOLineNo Delivery Customer Purchase Order Line Number      
OR21100 INT INTEGER 0 0 9 DiscountGroupNumber Discount Group      
OR21101 DATETIME DATE 0 0 8 DateConfirmationPrinted Date Confirmation Printed      
OR21102 DATETIME DATE 0 0 8 DatePickListPrinted Date Picking List Printed      
OR21103 DATETIME DATE 0 0 8 DateDeliveryProposalPrinted Date Delivery Proposal Printed      
OR21104 NCHAR STRING 1 0 1 BlockForProcess BOM Blocked for Processing      
OR21105 NCHAR STRING 4 0 4 VersionNumber Version Number      
OR21106 NUMERIC MONEY 28 8 20 UnitCostPriceCC Unit Cost Price (Alternative Currency)      
OR21107 NVARCHAR VSTRING 1 0 1 DSIssueOnGRR 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		    
OR21108 NCHAR STRING 6 0 6 TaxCode Tax Code Order Line      
OR21109 NUMERIC MONEY 28 8 20 PriceInclTax Unit Price Including Tax (Order Currency)      
OR21110 NCHAR SWITCH 1 0 1 UseLocalBalance Use local balance      
OR21111 NCHAR SWITCH 1 0 1 DeliveryWithoutStockTrans Delivery Without Stock Trans      
OR21112 NCHAR STRING 8 0 8 StatisticsLineID Statistics Line ID      
OR21113 NCHAR SWITCH 1 0 1 BlockPriceChange Block Price Change Blocked for automatic price change    
OR21114 DATETIME DATE 0 0 8 ConfDD Confirmed Delivery Date      
OR21115 DATETIME DATE 0 0 8 ConfDDBO Confirmed Delivery Date Back Order      
OR21116 DATETIME DATE 0 0 8 OriginalConfDD Original Confirmed Delivery Date      
OR21117 NVARCHAR VSTRING 25 0 25 NomenclatureNo NomenclatureNo      
OR21118 DATETIME DATE 0 0 8 DelDateAccepted Accepted Delivery Date      
OR21119 NCHAR STRING 10 0 10 OrderCustomerCode Order Customer Code      
OR21120 NVARCHAR VSTRING 10 0 10 FinOperationCode FinOperationCode      
OR21121 DATETIME DATE 0 0 8 OrderLinePricingDate Order Line Pricing Date      
OR21122 NCHAR STRING 10 0 10 OrderPricingNumber Order Pricing Number      
OR21123 NVARCHAR VSTRING 20 0 20 RequestedDeliveryTime Requested Delivery Time      
OR21124 NVARCHAR VSTRING 20 0 20 AcceptedDeliveryTime Accepted Delivery Time      
OR21125 INT INTEGER 0 0 4 ExternalStatus External status      
OR21126 INT INTEGER 0 0 1 LinePriceType Line Price Type 0 –> Gross price + Discount (existing model)
1 –> Gross price + Net price (new)		    
OR21127 NUMERIC MONEY 28 8 20 NetUnitPrice Net Unit Price      
OR21128 DATETIME DATE 0 0 8 ConfirmedProductionDate Confirmed Production Date      
OR21129 NCHAR STRING 2 0 2 ExemptTaxCode Exempt Tax Code      
OR21130 NUMERIC MONEY 28 8 20 ExemptLimit Exempt Limit Tax exemption limit used for order line    
OR21131 NUMERIC MONEY 28 8 20 TaxablePrice Taxable Price Taxable Price for FOC items    
OR21132 NCHAR STRING 2 0 2 AccountCode2 Accounting Code 2      
OR21133 NCHAR SWITCH 1 0 1 DeliveryBlocked Delivery Blocked      
OR21134 NCHAR SWITCH 1 0 1 Spare Spare      
OR21135 NUMERIC MONEY 28 8 20 PackageTaxAmntPerKg Packaging Tax Amount per kg      
OR21136 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved credit limit      
OR21137 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
OR21138 NUMERIC MONEY 28 8 20 LineFreightOCU Line Freight OCU      
OR21139 NUMERIC MONEY 28 8 20 LineFreightICU Line Freight ICU      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Order | Sales Order Lines History