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 |