Welcome to the Industrial Automation website!

NameDescriptionContent
XING-Automation
E-mail  
Password  
  
Forgot password?
  Register
当前位置:

Order information and status flow

F: | Au:佚名 | DA:2023-12-15 | 751 Br: | 🔊 点击朗读正文 ❚❚ ▶ | Share:

Order information

1. Key fields

The efficiency of order flow depends on the data flow of the information system combined with the commodity flow of the warehouse and express, so there are several key fields to pay attention to and understand in advance.

Where the order flows into the OMS (Order management System), that's where the order comes from. Different sources of order sales channels are different, and some flow is also different, such as orders shipped by a third party, the system needs to pass information according to the open platform, for delivery, logistics and other control is different from self-operated orders.

Different types of orders are processed differently in the OMS system. Some may be cross-node or reverse process. For example, the return order is a process from the user to the merchant. It is more complicated than the forward order, because it needs to obtain the information generated in the forward order flow process and then calculate and process according to the rules.

Warehouse, that is, where the orders should be sent to for operation processing, what standard processes are required for circulation in the warehouse, different warehouses may belong to different branches, and what are the differences in cost accounting? Although we do not pay attention to these information in the early stage of OMS, we must ensure the accuracy of these information. And for some merchants in A warehouse out of stock, may arrange B warehouse delivery that order transfer, not through the way of warehouse transfer, so the order to record the final delivery warehouse.

Payment status, this field is related to payment, different payment methods need to connect to different interfaces, whether the return of the status is timely, and so on. Payment status and order status can be combined into a single field.

Order status, that is, the status of the order on different operational nodes, some information is presented to the user and some is viewed internally. A detailed introduction will follow.

2. Order information

When the order is generated, it simply says that the order information includes basic order information and order product information, and also includes a lot of subsidiary information, such as payment details, associated users, and gift card details used

(1) Basic order information

Order information is the main order table information, I will be divided into order number, order user information, order basic information, payment information, receiving information and logistics information several small parts.

1) Order number: listed separately, we may have questions, here to explain.

Although the order number is only a document number, what kind of format of the number needs to be designed, because some companies order number is year month date + serial number or random number, so there is no problem in the design, because as long as the uniqueness is guaranteed. However, for some companies in order to avoid data leakage (such as friends by order number analysis of daily order volume) some processing in the document number format.

In addition, the order number is a very important field in the flow process. Therefore, if a good OMS system can distribute the flow according to the order number, the operator can also determine the order type or warehouse information based on the order number. Attachment: Amazon China order number format: C01-2442712-9062228; Jd order number: 106697775485; Taobao order number: 786699393282068525

The generation of order numbers needs to be supported by a component. First, it must be able to meet the requirements of the growth of order volume and user concurrency. Secondly, with the growth of data volume, the order table should be split horizontally or vertically for database and table classification, and the data should be distributed storage (if you are interested, please see the Practice of Database and Table Classification of Dianping Order System). We have started the practice of sub-library sub-table project, but for various reasons, the promotion is not smooth, and finally only the single number generator and some service components are online, it is a pity.

2) Basic Information:

Including the main information in addition to the order number such as source, classification, status, ownership, warehouse, etc., because the order table is the largest amount of data in the future, so the design of each field needs to consider its real meaning and whether it can meet the future expansion.

With the passage of time and the rapid change and growth of the business, there are many possibilities in the future that will force you to add fields or define the original fields twice, so that this table must be constantly escaped during the development process, which greatly increases the complexity of the code. Personal is more inclined to predefined a few reserved fields, the pros and cons of everyone in the design to measure it.

3) Payment information:

Payment is mainly for coupons, gift cards, points and discounts used at the order level. When the front-end order enters the settlement page, it will be calculated and recorded according to relevant information. At the same time, it generally follows: order amount - coupon - gift card - points = amount payable; Order amount = order amount + freight amount; Order amount = actual selling price * Quantity of goods sold.

  • Mannesmann Rexroth VT3006-36 Analog Amplifier Card
  • Bosch Rexroth R900086160 PGF1 Gear Pump
  • Bosch Rexroth R911173263 VDP15.3 Touch Display
  • Bosch Rexroth PPC-R22.1 RJ522 Industrial Controller
  • Bosch Rexroth MSK060C-0300-NN-S1-UG0-NNNN Servo Motor
  • Bosch Rexroth R911325068 NYS04.1 Controller
  • Bosch Rexroth R911335439 CSH01.1C Control Unit
  • Bosch Rexroth R917010287 BODAS RC10 Controller
  • Bosch Rexroth R911329791 CSH01.1C Drive Controller
  • Bosch Rexroth R182432310 Runner Block Guide
  • Bosch Rexroth VT-VSPA2-1-11 Amplifier Card R900021909
  • Bosch Rexroth MKD090B-047-KG1-KN Servo Motor
  • Bosch Rexroth LTU350 Servo Amplifier 0608750108
  • Bosch Rexroth 5610102050 Pneumatic Vacuum Regulator
  • Bosch Rexroth VT5041-23/3-OV PLC Control Board
  • Bosch Rexroth VT3015 S10/E Servo Amplifier Board
  • Bosch Rexroth MSK070D-0300-NN-M2-UG1 Servo Motor
  • Bosch Rexroth 3DREP6C-21 Valve R900955887
  • Bosch Rexroth R151244013 Ball Screw Bearing Unit
  • Bosch Rexroth MSM031C-0300 Servomotor R911325140
  • Bosch Rexroth EMD-B16.1-DC024N Box R911291681
  • Bosch Rexroth MKD071B-061-GP0-KN Servo Motor
  • Bosch Rexroth MSK030C-0900-NN-M1-UG1 Servo Motor
  • Bosch Rexroth EcoDrive DKC01.3-004-3-MGP-01 Servo Controller (299772)
  • Bosch Rexroth DKC02.3-040-7 EcoDrive Controller
  • Bosch Rexroth CLC-D02.3 CLC Motion Control Board
  • Bosch Rexroth HDS05.2-W300N Drive R911190019
  • Bosch Rexroth DKCXX.3-100-7 Servo Drive Unit
  • Bosch Rexroth CSE02.1A-S3-EC Control Unit R911339030
  • Bosch Rexroth MSK040C-0600-NN-S1-UP0 Servo Motor
  • Bosch Rexroth VT3013 S36 R5 Circuit Board Card
  • Bosch Rexroth VT3000-36A Amplifier Card R90020298
  • Bosch Rexroth VPB40.3 IndraControl Module R911374113
  • Bosch Rexroth HCS02.1E-W0054-A-03-NNNN Converter with R911332574 Control Unit
  • Bosch Rexroth MHD071B-061-PG1-UN Servo Motor
  • Bosch Rexroth A2F5/60W-B3-S Piston Motor R909418904
  • Bosch Rexroth HCS01.1E-W0018-A-03-B-ET-EC-NN-NN-NN-FW IndraDrive Cs Converter
  • Bosch Rexroth 4WRPEH 6 C4B40P-2X/G24K0/A1M Proportional Directional Valve (0 811 404 647)
  • Bosch Rexroth R911405975 ctrlX OS PLC Controller
  • Bosch Rexroth CSB02.1B-ET-EC-NN-S4-NN-NN-FW Servo Control Card R911338543
  • Rexroth MSK050B-0300-NN-M1-UG0-NNN Servo Motor
  • Rexroth IndraControl VEPXX.5-ATOM Set R911374889 Panel
  • Rexroth 1070089906-GC1 1070089907-201 Board
  • Rexroth CSB01.1C-SE-ENS-EN2-NN-S-NN-FW Control Unit
  • Rexroth MKD071B-024-KG3-KN Servo Motor
  • Rexroth Indramat DKC02.3-040-7-FW Controller
  • Rexroth HCS02.1E-W0028-A-03-NNNN Servo Module
  • Rexroth HMD01.1N-W0036-A-07-NNNN Drive Module
  • Rexroth MSK050C-0600-NN-M1-UG0-NNN Servo Motor
  • Rexroth DKC02.3-040-7-FW Servo Controller
  • Bosch Rexroth VT-5014S30-R1 Amplifier Card
  • Bosch Rexroth MSK040C-0600-NN-M1-UG1 Servo Motor
  • Bosch Rexroth MKD071B-061-GG0-KN Servo Motor
  • Bosch Rexroth VT5012-S45-R1 Amplifier Card
  • Bosch Rexroth SHL03.1-NNN-S-NNN Encoder Module
  • Bosch Rexroth EFC3600-0K75 Frequency Converter
  • Bosch Rexroth VFC3610-1K50-3P4-MNA-7P-NNNNN-NNNN 1.5kW Frequency Inverter
  • Bosch Rexroth EFC5610-2K20-3P4-MDA-7P-NNNNN-L1NN 2.2kW Frequency Converter
  • Bosch Rexroth XM21 XM2100.01 PLC Control Unit
  • Rexroth CSH01.1C-ET-ENS R911328178 HMS01.1N-W0020 Drive Package
  • April AXI0010 - Single Axis Servo Controller
  • Rexroth DKC10.3-004-3-MGP-01VRS Servo Drive
  • Bosch DKC02.3-040-7-FW Servo Drive
  • Rexroth DKC06.3-040-7-FW Servo Drive Controller
  • Rexroth VPB40.3 SE T R911374113 Control Module
  • Rexroth S20-SSI-AO-1/1 R911172544-AB1 Module
  • Rexroth R911173004 AC1 GH1 PLC Control Set
  • Rexroth VPB40.3D1L-1G0NN-D1D-DN-NN-FW Module
  • Rexroth MDD071B-N-040-N2T-095GB1 Servo Motor
  • Bosch Rexroth DM15K1101-D Servo Drive Module
  • Rexroth CSH01.3C-PB-ENS-MA1-CCD-S2-S-NN-FW Drive
  • Rexroth HMS01.1N-W0036 CSB02.1B Drive Package
  • Rexroth MSK070E-0300-NN-M2-UG0-RNN Servo Motor
  • Rexroth AZPF-1X-004RCB20KB Gear Pump
  • Rexroth NFD03.1-480-055 Powerline Filter
  • Rexroth VT-VARAP1-537-20/V0 Valve Amplifier
  • Rexroth HVE04.2-W075N Supply Module
  • Rexroth HMD01.1N-W0020-A-07-NNNN Drive Controller
  • Rexroth VDP40.3DIN-D1-NN-CG HMI Computer
  • Rexroth HDS05.2-W300N-HS12-01FW Drive Module
  • Rexroth HMS01.1N-W0070-A-07-NNNN Power Section
  • Rexroth Indramat MKD071B-061-GP0-KN Servo Motor
  • Rexroth HDS03.2-W075N-HS12-01-FW Control Unit
  • Rexroth HCS02.1E-W0054-A-03-NNNN Servo Drive
  • Rexroth CML40.2-SP-330-NA-NNNN-NW IndraControl
  • Rexroth CSH01.1C-PB-ENS-NNN-MA1-S2-S-NN-FW Drive
  • Rexroth PPC-R22.1 DAQ03 Servo Drive
  • Rexroth HCS02.1E-W0070-A-03-NNNN Servo Drive
  • Rexroth RF-FLS PB M12 DIO 8/8 M12 Module
  • Rexroth Indramat TBM 1.2-40-W1-024 Servo Bleeder
  • Rexroth Indramat MKD071B-061-KG1-KN Servo Motor
  • Rexroth CML40.2-SP-330-NA-NNNN-NW IndraControl L40
  • Rexroth VCP08.2DTN-003-NN-NN-PW Operator Panel
  • Bosch Rexroth DM30K1101-D Servo Drive 670V DC
  • Rexroth PPC-R22.1N-N-Q1-NN-NN-FW Motion Controller
  • Rexroth MSK040C-0600-NN-M1-UG1-NNNN Servo Motor
  • Rexroth CSH01.1C-S3-ENS-NNN-NNN-S2-S-NN-FW Drive Controller
  • Rexroth PPC-R22.1 Motion Control Module 004566384
  • Rexroth CSH01.1C-PB-ENS-NNN-MA1-S2-S-NN-FW Controller
  • Rexroth CML25.1-3N-400-NN-NNC1-NW IndraControl L25
  • Rexroth MSK030C-0900-NN-M1-UP1-NSNN Servo Motor
  • Rexroth HCS02.1E-W0028-A-03 CSH01.1C-PB Drive Package
  • Bosch Rexroth VT-VARAP 1-537-20/V0 Amplifier
  • Bosch Rexroth PPC-R02.2N R911285402 Control Unit
  • National Instruments PCI-7342 Motion Controller
  • National Instruments PXIe-6535 Digital I/O Module
  • National Instruments PCIe-6738 Analog Output Card
  • National Instruments NI-6583 Digital I/O Adapter Module
  • National Instruments NI TB-9214 Terminal Block
  • National Instruments NI 9222 Simultaneous Analog Input Module
  • National Instruments PXIe-8364 MXI-Express Module
  • National Instruments PXI-8185 Embedded Controller
  • National Instruments PCI-1405 Device
  • National Instruments SCXI-1160 Module
  • National Instruments PCI-MIO-16E-1 Device
  • National Instruments USB-6216 Device
  • National Instruments PXIe-2543 Module
  • National Instruments PCI-5102 Digitizer
  • National Instruments PXI-6284 DAQ Device
  • National Instruments PXI-7330 Controller
  • National Instruments cFP-2100 Controller
  • National Instruments USB-6002 DAQ Device
  • National Instruments PCIe-6374 Multifunction DAQ Card
  • National Instruments PXIe-4610 Power Amplifier Module
  • National Instruments PXIe-4154 Battery Simulator
  • National Instruments PXIe-7858R Reconfigurable I/O Module
  • National Instruments BNC-2090A BNC Terminal Block
  • National Instruments cRIO-9066 CompactRIO Controller