acquisition_line_items


Description

A list of all acquisition ordered items.

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idint410null

Primary key.

acquisition_campaign_idvarchar255null
acquisition_campaigns.idDefined in XMLR

Id of the acquisition campaign the record belongs to.

acquisition_product_idvarchar255null
acquisition_products.idDefined in XMLR

Id of the acquisition product the record belongs to.

company_idint410null
companies.idDefined in XMLR

Id of the company the record belongs to.

created_attimestamp29,6null

Date the record was created.

delivered_attimestamp29,6null

Date the order was delivered.

price_eurint410null

Price in Euro.

price_gbpint410null

Price in British pound.

price_usdint410null

Price in United States dollar.

statusvarchar255null

Order status.

updated_attimestamp29,6null

Date the record was updated.

Relationships