order

Order is a purchase order by a customer. The source is the transactions extract

Field name

Type

Mode

Description

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