acquisition_line_items


Description

A list of all acquisition ordered items.

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint410null

Primary key.

acquisition_campaign_idvarchar255√null
acquisition_campaigns.idDefined in XMLR

Id of the acquisition campaign the record belongs to.

acquisition_product_idvarchar255√null
acquisition_products.idDefined in XMLR

Id of the acquisition product the record belongs to.

company_idint410√null
companies.idDefined in XMLR

Id of the company the record belongs to.

created_attimestamp29,6√null

Date the record was created.

delivered_attimestamp29,6√null

Date the order was delivered.

price_eurint410√null

Price in Euro.

price_gbpint410√null

Price in British pound.

price_usdint410√null

Price in United States dollar.

statusvarchar255√null

Order status.

updated_attimestamp29,6√null

Date the record was updated.

Relationships