order_line_property
- Sylvain Paillard
Properties of customer purchase orders as delivered from source (transactions). 'linu_num' is generated during load.
Field name | Type | Mode | 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 |
property_name | STRING | REQUIRED | PK, original field name in the source extract |
property_value | STRING | REQUIRED | Original field value |
property_ts | TIMESTAMP | REQUIRED | Timestamp of property extraction from source |
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 |
creation_tm | DATETIME | REQUIRED | technical field |
client_id | INTEGER | REQUIRED | technical field |
src_sys_id | INTEGER | REQUIRED | technical field |