One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table OR03 — Sales Order Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR03001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да / Yes
OR03002 NCHAR STRING 6 0 6 LineNumber Line Number   2 Да / Yes
OR03003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   3 Да / Yes
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 120 0 120 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      
OR03141 NCHAR STRING 3 0 3 TaxReasonCode Tax Reason Code      
OR03142 NCHAR SWITCH 1 0 1 ConfirmedbyPlanner Confirmed by Planner      

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