order_line
- Sylvain Paillard
Represents the purchase order details (individual positions on the order)
Field name | Type | Mode | Policy tags | Description |
|---|---|---|---|---|
order_id | STRING | REQUIRED |
| PK |
line_num | INTEGER | REQUIRED |
| PK, generated sequence to distinguish order positions for reporting purposes. Currently it equals the line number of a record in the file extract |
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 |
product_id | STRING | NULLABLE |
|
|
line_status_cd | STRING | NULLABLE |
| line item status as provided from the e-commerce system |
product_qty | NUMERIC | NULLABLE |
| Product quantity |
currency_cd | STRING | NULLABLE |
|
|
list_crncy_amt | NUMERIC | NULLABLE |
|
|
discount_crncy_amt | NUMERIC | NULLABLE |
|
|
creation_tm | DATETIME | REQUIRED |
| technical field |
client_id | INTEGER | REQUIRED |
| technical field |
src_sys_id | INTEGER | REQUIRED |
| technical field |