Таблица: OR01 - «Order Head». Маска имени таблицы: «OR01%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
OR01001 | NCHAR | NUMERICSTRING | 10 | 0 | 10 | OrderNumber | Order Number | 1 | Да | |
OR01002 | INT | INTEGER | 0 | 0 | 1 | OrderType | Order Type | 0 - Quotation
1 - Normal Order 2 - Invoice Order 3 - Direct Order 4 - Back Order 5 - Repeat Order 6 - Work Order 7 - Direct Credit Order 8 - Credit Order 9 - Re-invoice Order |
||
OR01003 | NCHAR | STRING | 10 | 0 | 10 | CustCodeInv | Customer Code Invoice | |||
OR01004 | NCHAR | STRING | 10 | 0 | 10 | CustCodeDel | Customer Code Delivery | |||
OR01005 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remark1 | Remark Line 1 | |||
OR01006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Remark2 | Remark Line 2 | |||
OR01007 | INT | INTEGER | 0 | 0 | 1 | FLAGOrAckn | Order Confirmation Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01008 | INT | INTEGER | 0 | 0 | 1 | FLAGPickList | Picking List Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01009 | INT | INTEGER | 0 | 0 | 1 | FLAGDispNote | Delivery Note Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01010 | INT | INTEGER | 0 | 0 | 1 | FLAGInvoice | Invoice Status | 0 - Not ready for printing
1 - Print invoice 2 - Invoice sent 3 - Print partial invoice 4 - Partial invoice sent 5 - Print consolidated invoice 6 - Consolidated invoice sent |
||
OR01011 | INT | INTEGER | 0 | 0 | 1 | FLAGProcStru | Structure Order Processed | |||
OR01012 | INT | INTEGER | 0 | 0 | 2 | TermsPayment | Payment Terms | |||
OR01013 | INT | INTEGER | 0 | 0 | 2 | TermsofDel | Delivery Terms | |||
OR01014 | INT | INTEGER | 0 | 0 | 2 | WayofDel | Delivery Method | |||
OR01015 | DATETIME | DATE | 0 | 0 | 8 | OrderDate | Order Date | |||
OR01016 | DATETIME | DATE | 0 | 0 | 8 | DelDate | Delivery Date | |||
OR01017 | NVARCHAR | VSTRING | 35 | 0 | 35 | OurReferen | Our Reference | |||
OR01018 | NVARCHAR | VSTRING | 35 | 0 | 35 | YourReferen | Your Reference | |||
OR01019 | NVARCHAR | VSTRING | 3 | 0 | 3 | SalesmanNo | Salesman | |||
OR01020 | NVARCHAR | VSTRING | 6 | 0 | 6 | OrdDiscount | Order Discount % | |||
OR01021 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | |||
OR01022 | DATETIME | DATE | 0 | 0 | 8 | InvoiceQuot | Invoice Date/Quote Valid To Date | Depends on order type:
Order type 0 (quote): Quote valid to date All other types: Invoice date |
||
OR01023 | NVARCHAR | VSTRING | 20 | 0 | 20 | DispatNoteNo | Delivery Note Number | |||
OR01024 | NUMERIC | MONEY | 28 | 8 | 20 | OrderValue | Order Value (Order Currency) | |||
OR01025 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccCodString | Accounting String | |||
OR01026 | INT | INTEGER | 0 | 0 | 1 | ORMergeOption | Order Merge Option | 0 - Not to be merged/consolidate
1 - Merge/Consolidate per week 2 - Merge/Consolidate per month |
||
OR01027 | NVARCHAR | VSTRING | 3 | 0 | 3 | LanguageCode | Language | |||
OR01028 | INT | INTEGER | 0 | 0 | 2 | CurrCode | Currency Code Order | |||
OR01029 | INT | INTEGER | 0 | 0 | 1 | FLAGExportOR | Export Order | |||
OR01030 | INT | INTEGER | 0 | 0 | 1 | FLAGExpDoc | Export Document Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01031 | INT | INTEGER | 0 | 0 | 1 | FLAGTransDoc | Transport Document Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01032 | INT | INTEGER | 0 | 0 | 1 | FLAGCurrComp | Currency Compensation | |||
OR01033 | INT | INTEGER | 0 | 0 | 2 | CompCurrNo | Currency Code Compensation | |||
OR01034 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | LimitCompens | Currency Compensation Limit % | |||
OR01035 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Compensation | Currency Compensation % | |||
OR01036 | NUMERIC | MONEY | 28 | 8 | 20 | ORDateExRat | Order Date Exchange Rate | |||
OR01037 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | DelDateExRat | Delivery Date Exchange Rate | |||
OR01038 | NCHAR | STRING | 4 | 0 | 4 | OrRepInterva | Order Repeat Interval | Time unit is dependent on the first character of the field:
Number of days (no leading character) Number of Weeks (W as leading character) Number of Month (M as leading character) |
||
OR01039 | DATETIME | DATE | 0 | 0 | 8 | RepOrStartD | Repeat Order Start Date | |||
OR01040 | DATETIME | DATE | 0 | 0 | 8 | RepOrStopDa | Repeat Order End Date | |||
OR01041 | NUMERIC | MONEY | 28 | 8 | 20 | RepOrAccInv | Repeat Order Accumulated Invoiced Amount (Order Currency) | |||
OR01042 | NUMERIC | MONEY | 28 | 8 | 20 | RepOrdAccum | Repeat Order Accumulated Costs (Local Currency) | |||
OR01043 | NUMERIC | MONEY | 28 | 8 | 20 | HandlingFee | Handling Fee (Order Currency) | |||
OR01044 | NUMERIC | MONEY | 28 | 8 | 20 | FreightAmoun | Freight Amount (Order Currency) | |||
OR01045 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeOrd | Customer Code Order | |||
OR01046 | NUMERIC | MONEY | 28 | 8 | 20 | Packing | Packing Amount (Order Currency) | |||
OR01047 | INT | INTEGER | 0 | 0 | 1 | FLAGDeliProp | Delivery Proposal Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01048 | NUMERIC | MONEY | 28 | 8 | 20 | Insurance | Insurance Amount (Order Currency) | |||
OR01049 | NVARCHAR | VSTRING | 1 | 0 | 1 | StornoInvSw | Storno Invoice | |||
OR01050 | NVARCHAR | VSTRING | 6 | 0 | 6 | WareHouse | Warehouse | |||
OR01051 | NVARCHAR | VSTRING | 2 | 0 | 2 | PriceList | Price List | |||
OR01052 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGUpdatInt | Update Intrastat | |||
OR01053 | NVARCHAR | VSTRING | 1 | 0 | 1 | PtOfTitlPass | Point of Title | |||
OR01054 | NVARCHAR | VSTRING | 1 | 0 | 1 | PricTypOnRep | Price Type Repeat Order | 0 - Use the price defined on the order line when invoicing the order
1 - Get current prices when invoicing the order |
||
OR01055 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAGTaxInvoice | Tax Invoice Status | 0 - Document not ready for printing
1 - Print document 2 - Document sent |
||
OR01056 | NVARCHAR | VSTRING | 35 | 0 | 35 | ShipmentMark | Shipment Mark | |||
OR01057 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | Net Weight | |||
OR01058 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | Gross Weight | |||
OR01059 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Volume | Volume | |||
OR01060 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NoOfUnits | No of Units | |||
OR01061 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | ExternComm1 | External Commission % | |||
OR01062 | NVARCHAR | VSTRING | 10 | 0 | 10 | ExternComm2 | External Commission Code | |||
OR01063 | NUMERIC | MONEY | 28 | 8 | 20 | OwnFreight | Own Freight Amount (Order Currency) | |||
OR01064 | NUMERIC | MONEY | 28 | 8 | 20 | CommBaseOrd | Commission Base Order Value (Order Currency) | |||
OR01065 | INT | INTEGER | 0 | 0 | 1 | DocuLayout | Document Layout | |||
OR01066 | NCHAR | SWITCH | 1 | 0 | 1 | CurrContract | Currency Contract | |||
OR01067 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | FixedExchRat | Fixed Exchange Rate | |||
OR01068 | NVARCHAR | VSTRING | 15 | 0 | 15 | ContractNo | Fixed Exchange Rate Contract Number | |||
OR01069 | NVARCHAR | VSTRING | 8 | 0 | 8 | CampaignCode | Campaign | |||
OR01070 | NVARCHAR | VSTRING | 20 | 0 | 20 | ExtDelNoteNo | Extended Delivery Note Number | |||
OR01071 | INT | INTEGER | 0 | 0 | 1 | InvRoundMod | Invoice Rounding Model | |||
OR01072 | NVARCHAR | VSTRING | 20 | 0 | 20 | CustPONo | Customer Purchase Order Number | |||
OR01073 | NCHAR | SWITCH | 1 | 0 | 1 | LetterOfCred | Letter of Credit | |||
OR01074 | DATETIME | DATE | 0 | 0 | 8 | LetterCredOp | Letter of Credit Open Date | |||
OR01075 | DATETIME | DATE | 0 | 0 | 8 | LetterCredDu | Letter of Credit Due Date | |||
OR01076 | NVARCHAR | VSTRING | 20 | 0 | 20 | LetteCredRef | Letter of Credit Reference | |||
OR01077 | DATETIME | DATE | 0 | 0 | 8 | BookEntrDate | Book-Entry Date | |||
OR01078 | NVARCHAR | VSTRING | 6 | 0 | 6 | CommWarehNo | Common Warehouse | |||
OR01079 | NCHAR | SWITCH | 1 | 0 | 1 | PartialDelCd | Allow Partial Delivery | |||
OR01080 | INT | INTEGER | 0 | 0 | 2 | EDITrmittCou | EDI Transmit Count | |||
OR01081 | INT | INTEGER | 0 | 0 | 2 | EDIReceivCou | EDI Receive Count | |||
OR01082 | NVARCHAR | VSTRING | 1 | 0 | 1 | EDIFlag1 | EDI Flag 1 | Currently not used for any specific functionality | ||
OR01083 | NVARCHAR | VSTRING | 1 | 0 | 1 | EDIFlag2 | EDI Flag 2 | Currently not used for any specific functionality | ||
OR01084 | NVARCHAR | VSTRING | 1 | 0 | 1 | EDIFlag3 | EDI Flag 3 | Currently not used for any specific functionality | ||
OR01085 | NVARCHAR | VSTRING | 1 | 0 | 1 | EDIFlag4 | EDI Flag 4 | Currently not used for any specific functionality | ||
OR01086 | NVARCHAR | VSTRING | 3 | 0 | 3 | SalesmanNo2 | Salesman 2 | |||
OR01087 | NVARCHAR | VSTRING | 3 | 0 | 3 | SalesmanNo3 | Salesman 3 | |||
OR01088 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Original Order Type | 0 - Quotation
1 - Normal Order 2 - Invoice Order 3 - Direct Order 4 - Back Order 5 - Repeat Order 6 - Work Order 7 - Direct Credit Order 8 - Credit Order 9 - Re-invoice Order |
||
OR01089 | NVARCHAR | VSTRING | 4 | 0 | 4 | SalesTaxRema | Sales Tax Remark | |||
OR01090 | NVARCHAR | VSTRING | 4 | 0 | 4 | Forwarder | Forwarder | |||
OR01091 | INT | INTEGER | 0 | 0 | 1 | OrderStatus | Order Status | |||
OR01092 | INT | INTEGER | 0 | 0 | 2 | VATCodeFreig | VAT Code Freight | |||
OR01093 | INT | INTEGER | 0 | 0 | 2 | VATCodePack | VAT Code Packing | |||
OR01094 | INT | INTEGER | 0 | 0 | 2 | VATCodeInsur | VAT Code Insurance | |||
OR01095 | NVARCHAR | VSTRING | 2 | 0 | 2 | OvrideSlTaxC | VAT Code Override | |||
OR01096 | NVARCHAR | VSTRING | 8 | 0 | 8 | OwnerCode | Entered By | |||
OR01097 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
OR01098 | NVARCHAR | VSTRING | 10 | 0 | 10 | SuborContrNo | Sub-Order Contract Number | |||
OR01099 | NVARCHAR | VSTRING | 10 | 0 | 10 | SuborderNo | Sub-Order Number | |||
OR01100 | INT | INTEGER | 0 | 0 | 1 | OrCreatModul | Order created from module | 5 or 7: Linked to project activity line | ||
OR01101 | NVARCHAR | VSTRING | 30 | 0 | 30 | OrigModLinID | Original Module Line ID | |||
OR01102 | INT | INTEGER | 0 | 0 | 1 | OrigModStatu | Original Module Status | |||
OR01103 | NVARCHAR | VSTRING | 27 | 0 | 27 | Contract | Contract | |||
OR01104 | NCHAR | STRING | 1 | 0 | 1 | VATFlag | VAT Option | |||
OR01105 | NCHAR | STRING | 3 | 0 | 3 | OrdHandler | Number of Printed Invoice Copies | |||
OR01106 | NCHAR | SWITCH | 1 | 0 | 1 | IntereBlock | Interest Block | |||
OR01107 | NVARCHAR | VSTRING | 6 | 0 | 6 | IntrLatePaym | Interest Late Payment | |||
OR01108 | NVARCHAR | ACCSTR | 50 | 0 | 50 | INTRDebit | Internal Debiting Accounting String | |||
OR01109 | NVARCHAR | VSTRING | 4 | 0 | 4 | InvPrefix | Invoice Prefix | |||
OR01110 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | OrderDateExchgRate1 | Order Date Exchange Rate 2 | |||
OR01111 | NCHAR | STRING | 3 | 0 | 3 | OrderDateExchgAlgtm | Order Date Exchange Algorithm | |||
OR01112 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | DlvryDateExchgRate2 | Delivery Date Exchange Rate 2 | |||
OR01113 | NCHAR | STRING | 3 | 0 | 3 | DlvryDateExchgAlgtm | Delivery Date Exchange Algorithm | |||
OR01114 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | FixedExchgRate2 | Fixed Exchange Rate 2 | |||
OR01115 | NCHAR | STRING | 3 | 0 | 3 | FixedExchgAlgtm | Fixed Exchange Algorithm | |||
OR01116 | INT | INTEGER | 0 | 0 | 2 | InvoiceCurrCode | Currency Code Invoice | |||
OR01117 | NCHAR | SWITCH | 1 | 0 | 1 | EDIContractSwitch | EDI-Contract | |||
OR01118 | INT | INTEGER | 0 | 0 | 2 | VATCodeInvFee | VAT Code Invoice Fee | |||
OR01119 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | InvCurrExchRate1 | Invoice Currency Exchange Rate | |||
OR01120 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | InvCurrExchRate2 | Invoice Currency Exchange Rate 2 | |||
OR01121 | NCHAR | STRING | 3 | 0 | 3 | InvCurrExchAlg | Invoice Currency Exchange Algorithm | |||
OR01122 | INT | INTEGER | 0 | 0 | 1 | InclInStat | Include in Billing Statement | |||
OR01123 | NUMERIC | MONEY | 28 | 8 | 20 | AllowAmICU | Allowance Amount | |||
OR01124 | NCHAR | STRING | 2 | 0 | 2 | AllowTaxRate | VAT Code Allowance | |||
OR01125 | NUMERIC | MONEY | 28 | 8 | 20 | SurchargeAmICU | Surcharge Amount (Order Currency) | |||
OR01126 | NCHAR | STRING | 2 | 0 | 2 | SurchargeTaxRate | VAT Code Surcharge | |||
OR01127 | NUMERIC | MONEY | 28 | 8 | 20 | AdvanceAmount | Advance Amount (Order Currency) | |||
OR01128 | NCHAR | SWITCH | 1 | 0 | 1 | ExternalControl | External Control | |||
OR01129 | INT | INTEGER | 0 | 0 | 1 | FLAGOrAcknXML | EDI/XML Order Acknowledgement Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01130 | INT | INTEGER | 0 | 0 | 1 | FLAGPickListXML | EDI/XML Picking List Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01131 | INT | INTEGER | 0 | 0 | 1 | FLAGDispNoteXML | EDI/XML Delivery Note Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01132 | INT | INTEGER | 0 | 0 | 1 | FLAGInvoiceXML | EDI/XML Invoice Status | 0 - Invoice not ready for sending
1 - Send invoice 2 - Invoice sent 3 - Send partial invoice 4 - Partial invoice sent |
||
OR01133 | INT | INTEGER | 0 | 0 | 1 | FLAGTranspDocXML | EDI/XML Transport Document Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01134 | INT | INTEGER | 0 | 0 | 1 | FLAGExpDocXML | EDI/XML Export Document Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01135 | INT | INTEGER | 0 | 0 | 1 | DeliPropFlagXML | EDI/XML Delivery Proposal Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01136 | INT | INTEGER | 0 | 0 | 1 | FLAGTaxInvoiceXML | EDI/XML Tax Invoice Status | 0 - Document not ready for sending
1 - Send document 2 - Document sent |
||
OR01137 | NCHAR | STRING | 12 | 0 | 12 | ProjectNumber | Project | |||
OR01138 | NCHAR | STRING | 25 | 0 | 25 | SiteCode | Site Code | |||
OR01139 | NCHAR | STRING | 15 | 0 | 15 | OriginalInvoiceNo | Original Invoice Number | |||
OR01140 | NCHAR | STRING | 10 | 0 | 10 | OriginalOrderNo | Original Order Number | |||
OR01141 | NVARCHAR | VSTRING | 1 | 0 | 1 | FlagCreateInvoice | Create Invoice | |||
OR01142 | NCHAR | STRING | 10 | 0 | 10 | PriReschedule | Order Priority Rescheduling ATP | |||
OR01143 | NCHAR | SWITCH | 1 | 0 | 1 | AccLineSplit | Accept Order Line Split ATP | |||
OR01144 | NCHAR | SWITCH | 1 | 0 | 1 | AccOrderSplit | Accept Order Split ATP | |||
OR01145 | DATETIME | DATE | 0 | 0 | 8 | QuoteDate | Quote Date | |||
OR01146 | INT | INTEGER | 0 | 0 | 1 | DetainOrdDisc | Detain Order Discount | |||
OR01147 | NVARCHAR | VSTRING | 20 | 0 | 20 | DelCustPONo | Delivery Customer Purchase Order Number | |||
OR01148 | INT | INTEGER | 0 | 0 | 9 | DiscountSchemeCode | Discount Schema Code | |||
OR01149 | NCHAR | STRING | 10 | 0 | 10 | RequestNo | Customer Request | |||
OR01150 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | MarkUp | Mark-up % | |||
OR01151 | DATETIME | DATE | 0 | 0 | 8 | Order Pricing Date | Order Pricing Date | |||
OR01152 | INT | INTEGER | 0 | 0 | 1 | Priority | Order Priority | |||
OR01153 | INT | INTEGER | 0 | 0 | 1 | Priority_Weighted | Weighted Priority | |||
OR01154 | NCHAR | STRING | 10 | 0 | 10 | Contract Number | Contract Number | |||
OR01155 | NCHAR | STRING | 4 | 0 | 4 | Version Number | Version Number | |||
OR01156 | NVARCHAR | VSTRING | 4 | 0 | 4 | Cancellation Code | Cancellation Code | |||
OR01157 | NCHAR | STRING | 6 | 0 | 6 | TaxLiability | Tax Liability Code | |||
OR01158 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeFreight | Tax Code for Freight | |||
OR01159 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeInsurance | Tax Code for Insurance | |||
OR01160 | NCHAR | STRING | 6 | 0 | 6 | TaxCodePacking | Tax Code for Packing | |||
OR01161 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeInvFee | Tax Code for Invoicing Fee | |||
OR01162 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeDistribution | Tax Code for Distribution | |||
OR01163 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeAllowance | Tax Code for Allowance | |||
OR01164 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeSurcharge | Tax Code for Surcharge | |||
OR01165 | NVARCHAR | VSTRING | 10 | 0 | 10 | CFOPCode | CFOP Code | |||
OR01166 | NVARCHAR | VSTRING | 10 | 0 | 10 | OperationType | Operation Code | |||
OR01167 | NVARCHAR | VSTRING | 10 | 0 | 10 | FOPFiscTxtCode | Fiscal Text Code | |||
OR01168 | NCHAR | STRING | 4 | 0 | 4 | Invoice Issuer | Invoice Issuer Code | |||
OR01169 | NCHAR | SWITCH | 1 | 0 | 1 | Invoice Category [A;B;C;E;Z] | Invoice Category | |||
OR01170 | NCHAR | SWITCH | 1 | 0 | 1 | Invoice Type [0;1;2] | Invoice Type | |||
OR01171 | NCHAR | SWITCH | 1 | 0 | 1 | Consolidated DS Delivery | Consolidated DS Delivery | |||
OR01172 | NCHAR | SWITCH | 1 | 0 | 1 | Consolidated cwh Delivery | Consolidated cwh Delivery | Consolidated cwh Delivery | ||
OR01173 | NVARCHAR | VSTRING | 10 | 0 | 10 | FinOperationCode2 | Financial Operation Code 2 | |||
OR01174 | NCHAR | STRING | 10 | 0 | 10 | DSSupplier | Drop Shipment Supplier | |||
OR01175 | NCHAR | SWITCH | 1 | 0 | 1 | Instalment | Instalment | |||
OR01176 | NVARCHAR | VSTRING | 6 | 0 | 6 | Interest | Interest | |||
OR01177 | NUMERIC | MONEY | 28 | 8 | 20 | FinCharge | ||||
OR01178 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeInterest | TaxCodeInterest | |||
OR01179 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeFinCharge | TaxCodeFinCharge | |||
OR01180 | DATETIME | DATE | 0 | 0 | 8 | ActivateNewInterest | ActivateNewInterest | |||
OR01181 | NVARCHAR | VSTRING | 6 | 0 | 6 | NewInterest% | NewInterest% | |||
OR01182 | INT | INTEGER | 0 | 0 | 1 | SalesReturnReasonCode | Sales Return Reason Code | |||
OR01183 | NCHAR | NUMERICSTRING | 10 | 0 | 10 | RMAReference | RMA Reference | |||
OR01184 | NVARCHAR | VSTRING | 50 | 0 | 50 | ReturnComment | Return Comment | |||
OR01185 | NVARCHAR | VSTRING | 15 | 0 | 15 | KindOfBox | Kind of Box | |||
OR01186 | NVARCHAR | VSTRING | 15 | 0 | 15 | BoxNumbering | Box numbering | |||
OR01187 | NVARCHAR | VSTRING | 15 | 0 | 15 | NumberOfPallets | Number of pallets | |||
OR01188 | NVARCHAR | VSTRING | 10 | 0 | 10 | TransportCompanyCode | Transport Company Code | |||
OR01189 | NVARCHAR | VSTRING | 10 | 0 | 10 | VehicleState | Vehicle State/Province | |||
OR01190 | NVARCHAR | VSTRING | 15 | 0 | 15 | VehicleLicensePlate | Vehicle License Plate | |||
OR01191 | NCHAR | SWITCH | 1 | 0 | 1 | FreightPayer | Freight Payer | |||
OR01192 | NCHAR | STRING | 6 | 0 | 6 | OwnFreightTaxCode | Own Freight Tax Code | |||
OR01193 | NVARCHAR | VSTRING | 2 | 0 | 2 | OrigTermsPayment | Orig Terms Payment | |||
OR01194 | NCHAR | STRING | 10 | 0 | 10 | ContractNumber | Contract Number | Sales Contract Number reference | ||
OR01195 | DATETIME | DATE | 0 | 0 | 8 | Shipment Date Actual | Shipment Date Actual | |||
OR01196 | DATETIME | DATE | 0 | 0 | 8 | Delivery Date Estimated | Delivery Date Estimated | |||
OR01197 | DATETIME | DATE | 0 | 0 | 8 | Title Pass Date | Title Pass Date | |||
OR01198 | NCHAR | SWITCH | 1 | 0 | 1 | Delivery Note, sort | Delivery Note, sort | |||
OR01199 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto print DN | Auto print DN | |||
OR01200 | NVARCHAR | VSTRING | 1 | 0 | 1 | Auto send DN | Auto send DN | |||
OR01201 | INT | INTEGER | 0 | 0 | 1 | Release for withdrawal | Release for withdrawal | |||
OR01202 | INT | INTEGER | 0 | 0 | 1 | Delivery note printing | Delivery note printing | |||
OR01203 | INT | INTEGER | 0 | 0 | 1 | Invoice printing | Invoice printing | |||
OR01204 | NCHAR | STRING | 1 | 0 | 1 | Create back-order | Create back-order | |||
OR01205 | NCHAR | STRING | 10 | 0 | 10 | Order Pricing Number | Order Pricing Number |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Sales Order | Sales Order Head