order
Order is a purchase order by a customer. The source is the transactions extract
Field name | Type | Mode | Description |
---|---|---|---|
order_id | STRING | REQUIRED | PK |
order_tm | TIMESTAMP | REQUIRED |
|
order_sys_cd | STRING | REQUIRED | ERP stands for ERP system, ECM for e-commerce system, provides a general distinction between types of systems providing orders |
persona_id | STRING | NULLABLE | type of persona stored in this field is dependent on the where the order comes from ERP vs ECM, in case of ECM it is the user_persona_id, in case of ERP it is erp_persona_id |
order_qty | NUMERIC | NULLABLE | Order quantity indicates the total amount of all ordered products |
currency_cd | STRING | NULLABLE |
|
list_crncy_amt | NUMERIC | NULLABLE |
|
discount_crncy_amt | NUMERIC | NULLABLE |
|
total_crncy_amt | NUMERIC | NULLABLE |
|
creation_tm | DATETIME | REQUIRED | technical field |
client_id | INTEGER | REQUIRED | technical field |
src_sys_id | INTEGER | REQUIRED | technical field |