One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Sales Order»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица OR03 — Sales Order Lines

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
OR03001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да
OR03002 NCHAR STRING 6 0 6 LineNumber Line Number   2 Да
OR03003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   3 Да
OR03004 INT INTEGER 0 0 1 LineType Line Type 0 — Normal Order Line Related to Stock Item
1 — Non Stock Item Line (dot item)
   
OR03005 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
OR03006 NVARCHAR VSTRING 25 0 25 DescrLine1 Description Line 1      
OR03007 NVARCHAR VSTRING 25 0 25 DescrLine2 Description Line 2      
OR03008 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Order Currency)      
OR03009 NUMERIC MONEY 28 8 20 UnitCostPric Unit Cost Price (Local Currency)      
OR03010 INT INTEGER 0 0 4 UnitCode Unit Code      
OR03011 NUMERIC X_NUMERIC 20 8 12 ORQtyOrdered Quantity Ordered (Order Unit)      
OR03012 NUMERIC X_NUMERIC 20 8 12 QtyShipped Quantity Delivered (Order Unit)      
OR03013 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
   
OR03014 NCHAR STRING 2 0 2 AcctingCode1 Accounting Code 1      
OR03015 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.    
OR03016 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).
   
OR03017 NVARCHAR VSTRING 6 0 6 VolDiscount Volume Discount %      
OR03018 NVARCHAR VSTRING 6 0 6 CustDiscount Customer Discount %      
OR03019 DATETIME DATE 0 0 8 IntrPlanning Intermal Planning Date      
OR03020 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDel Items per Package (Purchase)      
OR03021 NUMERIC X_NUMERIC 18 8 10 QtyUniOutDel Items per Package (Sales)      
OR03022 NUMERIC X_NUMERIC 18 8 10 SellPrMultip Selling Price Multiplier      
OR03023 NUMERIC X_NUMERIC 18 8 10 CostPrMultip Cost Price Multiplier      
OR03024 NUMERIC X_NUMERIC 28 8 20 CurrExchRate Currency Exchange Rate      
OR03025 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)
   
OR03026 INT INTEGER 0 0 1 DistriCostCo Distribution Cost Code      
OR03027 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
   
OR03028 NVARCHAR ACCSTR 50 0 50 AccCodString Accounting String      
OR03029 INT INTEGER 0 0 1 FLAGDelStat Delivery Status      
OR03030 INT INTEGER 0 0 1 FLAGInvStat Invoice Status      
OR03031 INT INTEGER 0 0 1 StockStatus Stock Item Status      
OR03032 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.
   
OR03033 NUMERIC X_NUMERIC 20 8 12 QtyAlloc Quantity Allocated (Order Unit)      
OR03034 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    
OR03035 NVARCHAR VSTRING 8 0 8 ItemType Item Type      
OR03036 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.    
OR03037 DATETIME DATE 0 0 8 DelDateReque Delivery Date Requested      
OR03038 NCHAR SWITCH 1 0 1 FLAGCurrComp Currency Compensation      
OR03039 INT INTEGER 0 0 2 CompCurrNo Currency Code Compensation      
OR03040 NUMERIC X_NUMERIC 28 8 20 OrDExchRate Order Date Exchange Rate      
OR03041 NUMERIC X_NUMERIC 28 8 20 DelivDExRate Delivery Date Exchange Rate      
OR03042 DATETIME DATE 0 0 8 IntrPlanningBO Internal Planning Back Order Date      
OR03043 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
OR03044 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
OR03045 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
OR03046 NVARCHAR VSTRING 6 0 6 WarehouseNo Warehouse      
OR03047 NUMERIC MONEY 28 8 20 StatisPrice Statistical Price (Local Currency)      
OR03048 NUMERIC X_NUMERIC 14 8 6 StatisDisco Statistical Discount      
OR03049 NUMERIC MONEY 28 8 20 StatisCost Statistical Cost Price (Local Currency)      
OR03050 NUMERIC X_NUMERIC 20 8 12 QtyOrig Original Quantity (Order Unit)      
OR03051 NVARCHAR VSTRING 6 0 6 PickListNo Picking List Number      
OR03052 NCHAR STRING 1 0 1 DiscountsFrozen Discounts Frozen      
OR03053 NUMERIC X_NUMERIC 20 8 12 QtyAllocated Quantity Allocated (Stock Unit)      
OR03054 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered (Stock Unit)      
OR03055 NCHAR SWITCH 1 0 1 FLAGStatupda Statistics Not Updated Used internally during order line entry to indicate if statistics has been updated or not.    
OR03056 NUMERIC X_NUMERIC 20 8 12 QtyReservded Quantity Ordered (Stock Unit)      
OR03057 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.    
OR03058 NUMERIC X_NUMERIC 12 8 4 CustDiscoun1 Customer Discount Calculation Item 1      
OR03059 NUMERIC X_NUMERIC 12 8 4 CustDiscoun2 Customer Discount Calculation Item 2      
OR03060 NUMERIC X_NUMERIC 12 8 4 CustDiscoun3 Customer Discount Calculation Item 3      
OR03061 INT INTEGER 0 0 2 VATCode1 VAT Code 1      
OR03062 INT INTEGER 0 0 2 VATCode2 VAT Code 2      
OR03063 NUMERIC MONEY 28 8 20 OrigDefaulPr Original Default Price (Original Currency) The original price that was given when the order line was created.    
OR03064 NUMERIC X_NUMERIC 14 8 6 OrigDefaCust Original Default Discount The original line discount given when the order line was created.    
OR03065 NVARCHAR VSTRING 15 0 15 InvNoDummy Invoice Number      
OR03066 NVARCHAR VSTRING 10 0 10 SuborderNo Sub-order Number      
OR03067 NVARCHAR VSTRING 10 0 10 PurchaseOrNo Purchase Order Number      
OR03068 NVARCHAR VSTRING 12 0 12 PurchaLineNo Purchase Order Line Number      
OR03069 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
   
OR03070 NCHAR STRING 1 0 1 Status1 Status 1      
OR03071 NCHAR STRING 1 0 1 Status2 Status 2      
OR03072 NCHAR STRING 1 0 1 Status3 Status 3      
OR03073 NCHAR STRING 1 0 1 SubType Sub-type      
OR03074 NVARCHAR VSTRING 27 0 27 Contract Contract Number      
OR03075 NVARCHAR VSTRING 35 0 35 SearchField Search Key      
OR03076 NUMERIC NUMBER 20 0 10 PickingList Picking List Number      
OR03077 NUMERIC X_NUMERIC 18 8 10 CurrExchgRate2 Currency Exchange Rate 2      
OR03078 NCHAR STRING 3 0 3 CurrExchgAlgtm Currency Exchange Algorithm      
OR03079 NUMERIC X_NUMERIC 18 8 10 OrderDateExchgRate2 Order Date Exchange Rate 2      
OR03080 NCHAR STRING 3 0 3 OrderDateExchgAlgtm Order Date Exchange Algorithm      
OR03081 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 Delivery Date Exchange Rate 2      
OR03082 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm Delivery Date Exchange Algorithm      
OR03083 INT INTEGER 0 0 2 CurrencyCode Currency Code Order      
OR03084 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI Contract      
OR03085 INT INTEGER 0 0 2 OrigPriceCurCode Currency Code Original Price      
OR03086 NUMERIC MONEY 28 8 20 OrigUnitPrice Original Unit Price (Original Currency)      
OR03087 NVARCHAR VSTRING 11 0 11 PriceDiscountHistory Price/Discount History      
OR03088 NUMERIC MONEY 28 8 20 CostPriceCC Unit Cost Price (Order Currency)      
OR03089 NCHAR STRING 25 0 25 SiteCode Site Code      
OR03090 DATETIME DATE 0 0 8 TargetDate Target Date      
OR03091 NVARCHAR VSTRING 2 0 2 GRPAltRout Graphical Alternative Routing      
OR03092 DATETIME DATE 0 0 8 GRPStartDate Graphical Planning Start Date      
OR03093 DATETIME DATE 0 0 8 GRPDueDate Graphical Planning Due Date      
OR03094 INT INTEGER 0 0 1 GRPStatus Graphical Status      
OR03095 NVARCHAR VSTRING 1 0 1 DropShipmentline Drop Shipment Line      
OR03096 NCHAR STRING 38 0 38 ORBOMNodeID BoM Node ID Order      
OR03097 NCHAR STRING 38 0 38 SCBOMNodeID BoM Node ID Stock      
OR03098 NVARCHAR VSTRING 20 0 20 CustPOLineNo Customer Purchase Order Line Number      
OR03099 NVARCHAR VSTRING 20 0 20 DelCustPOLineNo Delivery Customer Purchase Order Line Number      
OR03100 INT INTEGER 0 0 9 DiscountGroupNumber Discount Group      
OR03101 DATETIME DATE 0 0 8 DateConfirmationPrinted Date Confirmation Printed      
OR03102 DATETIME DATE 0 0 8 DatePickListPrinted Date Picking List Printed      
OR03103 DATETIME DATE 0 0 8 DateDeliveryProposalPrinted Date Delivery Proposal Printed      
OR03104 NCHAR STRING 1 0 1 BlockForProcess BOM Blocked for Processing      
OR03105 NCHAR STRING 4 0 4 VersionNumber Version Number      
OR03106 NUMERIC MONEY 28 8 20 UnitCostPriceCC Unit Cost Price (Alternative Currency)      
OR03107 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
   
OR03108 NCHAR STRING 6 0 6 TaxCode Tax Code Order Line      
OR03109 NUMERIC MONEY 28 8 20 PriceInclTax Unit Price Including Tax (Order Currency)      
OR03110 NCHAR SWITCH 1 0 1 UseLocalBalance Use local balance      
OR03111 NCHAR SWITCH 1 0 1 DeliveryWithoutStockTrans Delivery Without Stock Trans      
OR03112 NCHAR STRING 8 0 8 StatisticsLineID Statistics Line ID      
OR03113 NCHAR SWITCH 1 0 1 BlockPriceChange Block Price Change Blocked for automatic price change    
OR03114 DATETIME DATE 0 0 8 ConfDD Confirmed Delivery Date      
OR03115 DATETIME DATE 0 0 8 ConfDDBO Confirmed Delivery Date Back Order      
OR03116 DATETIME DATE 0 0 8 OriginalConfDD Original Confirmed Delivery Date      
OR03117 NVARCHAR VSTRING 25 0 25 NomenclatureNo NomenclatureNo      
OR03118 DATETIME DATE 0 0 8 DelDateAccepted Accepted Delivery Date      
OR03119 NCHAR STRING 10 0 10 OrderCustomerCode Order Customer Code      
OR03120 NVARCHAR VSTRING 10 0 10 FinOperationCode FinOperationCode      
OR03121 DATETIME DATE 0 0 8 OrderLinePricingDate Order Line Pricing Date      
OR03122 NCHAR STRING 10 0 10 OrderPricingNumber Order Pricing Number      
OR03123 NVARCHAR VSTRING 20 0 20 RequestedDeliveryTime Requested Delivery Time      
OR03124 NVARCHAR VSTRING 20 0 20 AcceptedDeliveryTime Accepted Delivery Time      
OR03125 INT INTEGER 0 0 4 ExternalStatus External status      
OR03126 INT INTEGER 0 0 1 LinePriceType Line Price Type 0 –> Gross price + Discount (existing model)
1 –> Gross price + Net price (new)
   
OR03127 NUMERIC MONEY 28 8 20 NetUnitPrice Net Unit Price      
OR03128 DATETIME DATE 0 0 8 ConfirmedProductionDate Confirmed Production Date      
OR03129 NCHAR STRING 2 0 2 ExemptTaxCode Exempt Tax Code      
OR03130 NUMERIC MONEY 28 8 20 ExemptLimit Exempt Limit Tax exemption limit used for order line    
OR03131 NUMERIC MONEY 28 8 20 TaxablePrice Taxable Price Taxable Price for FOC items    
OR03132 NCHAR STRING 2 0 2 AcctingCode2 Accounting Code 2      
OR03133 NCHAR SWITCH 1 0 1 DeliveryBlocked Delivery block flag      
OR03134 NCHAR SWITCH 1 0 1 Spare Spare      
OR03135 NUMERIC MONEY 28 8 20 PackageTaxAmntPerKg Packaging Tax Amount per kg      
OR03136 NCHAR SWITCH 1 0 1 ApprovedCreditLimit Approved credit limit      
OR03137 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
OR03138 NUMERIC MONEY 28 8 20 LineFreightOCU Line Freight OCU      
OR03139 NUMERIC MONEY 28 8 20 LineFreightICU Line Freight ICU      
OR03140 NCHAR STRING 4 0 4 InvPrefix Inv Prefix      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
OR03010 0 2 0 2 0 4 0 4 0 4 0 4 0 4
OR03014 0 2 0 2 0 2 2 2 2 2 2 2 2 2
OR03114 0 8 0 8 0 8 0 8 0 8 0 8
OR03115 0 8 0 8 0 8 0 8 0 8 0 8
OR03116 0 8 0 8 0 8 0 8 0 8 0 8
OR03117 25 25 25 25 25 25 25 25 25 25 25 25
OR03118 0 8 0 8 0 8 0 8 0 8 0 8
OR03119 10 10 10 10 10 10 10 10 10 10 10 10
OR03120 10 10 10 10 10 10 10 10 10 10 10 10
OR03121 0 8 0 8 0 8 0 8 0 8 0 8
OR03122 10 10 10 10 10 10 10 10 10 10 10 10
OR03123 20 20 20 20 20 20 20 20 20 20 20 20
OR03124 20 20 20 20 20 20 20 20 20 20 20 20
OR03125 0 4 0 4 0 4 0 4 0 4
OR03126 0 1 0 1 0 1 0 1 0 1
OR03127 28 20 28 20 28 20 28 20 28 20
OR03128 0 8 0 8 0 8 0 8 0 8
OR03129 2 2 2 2 2 2 2 2 2 2
OR03130 28 20 28 20 28 20 28 20 28 20
OR03131 28 20 28 20 28 20 28 20 28 20
OR03132 2 2 2 2 2 2 2 2
OR03133 1 1 1 1 1 1 1 1
OR03134 1 1 1 1 1 1 1 1
OR03135 28 20 28 20 28 20
OR03136 1 1 1 1 1 1
OR03137 10 10 10 10
OR03138 28 20 28 20
OR03139 28 20 28 20
OR03140 4 4

Навигация: