Таблица: 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