Agreements (bi_agreements)

Overview: This is a daily full file of all agreement (AMB) items on file.

Frequency: Daily

Data Source: Advantage

Delivery Method: SFTP to csv import work

Filename: Agreements_<LyticsGroup>_<Date>_<Time>.csv

LQL Advice: Most of these fields will need to be mapped to Item_Number for context.

Field Name	Description	Source Field	Sample Value
Agreement_ID	Advantage identifier for this agreement record	AMBVER_M.AGR_ID	000012345678
Agreement_Term	The number of times the item has been purchased/renewed	AMBVER_M.AGR_TRM	1
Agreement_Version	Each change in the current agreement term creates a new version	AMBVER_M.AGR_VER	2
Customer_Number	Advantage identifier for this customer	AMBVER_M.BIL_CTM	000012345678
Email_Address	Email address from the agreement	CDSEML_M.ADR_EML (through AMBEML_M)	test@example.com
Item_Number	The agreement item purchased	AMBAPT_M.SRV_TYP	AGR012
Agreement_Status	Indicates whether the agreement is active or otherwise	AMBSTS_N.AGR_STS	Active Expired Cancelled Non-pay Cancelled Suspended Billing Suspended Waiting Not Released Extension Days Reversed
Final_Expiration_Date	The date that this agreement will expire, including any future terms	AMBSTS_N.AFIN_EXP	2020-12-31
Term_Expiration_Date	The date that the current term will expire	AMBSTS_N.AEXP_DTE	2020-12-31
Amount	The monetary amount from the current term	AMBAPT_M.UNIT_PRC	500.00
Promotion_Code	Promo Code from the current term of the agreement	AMBVER_M.PMO_CDE	EABCS100
Agreement_Days	The total number of days this agreement will be active	AMBVER_M.AGR_DAY	365
Renewal_Flag	Indicator of whether and when the subscription will be renewed	AMBVER_M.AGR_REN	C
Order_Date	The date that the current term was ordered	MSTORD_M.ORDR_DTE	2020-12-31
Affiliate	The owner of the agreement item		Agora Financial
Operation_Time	Timestamp that the file was generated		2021-01-01 06:29:21.363000000
Email_Status	Status of this email address with this agreement	AMBEML_M.EML_STA	A