View for Exporting Orders from MySales
RPM_ORDER_EXPORT_V – a view table for exporting orders from MySales to the accounting system.
Update Period: Orders are exported according to internal regulations (independent of MySales). Order calculation is completed by the agreed-upon time.
Column Name | Data Type | Description | Notes |
ID | int | Order number generated by MySales |
|
STORE_ID | int | Store Number MySales |
|
SUPPLIER_ID | int | Supplier number | Displayed only for orders with a distribution center (DC) to an external recipient |
WHS_ID | int | Warehouse number | Warehouse number for internal picking orders |
WHS_ORDER_ID | int | Warehouse order number for cross-dock | Displayed only for store cross-dock orders |
PUSH_ID | int | Push number | Displayed only for push orders |
ADD_LOAD_ID | int | Additional download number | Displayed only if the order falls within the additional loading period |
ORDER_DATE | datetime | Order date |
|
DELIVERY_DATE | datetime | Scheduled delivery date |
|
EXT_MANAGER_ID | int | The number of the person responsible for the nomenclature |
|
CONTRACT_ID | int | Contract number |
|
STORE_CROSS_DOCK_ORDERS | varchar | Cross-dock store order numbers of the warehouse order | Displayed only for warehouse cross-dock orders |
SKU_ID | int | Number SKU MySales |
|
ORDER_VOLUME | number(11,2) | Order quantity |
|
UPDATE_DATE | datetime | The date of the last modification of the order |
|
SEPARATE_ORDER_TYPE | varchar | Split order sign | pz – Pick to Zero, pr – Promo, pzpr – Pick to Zero Promo, t – Tender, pzt – Pick to Zero Tender, prt – Promo Tender |