Entity Definition

Logical Name : CustomerAccountTermsAndConditions
Physical Name : RU_CT_ACNT_TRM_CN

This entity captures and maintains the contract language associated with a customer account. As modeled here it is a generic placeholder and should be extended by the retailer to meet their specific legal and regulatory requirements. This entity is intended to store the contract provisions governing the account relationship established between a RETAILER and a KEY CUSTOMER.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerAccount(LE_CTAC)
RevisionNumber (PK) The sequential version of a CustomerAccountTermsAndConditions agreement. Used to track different versions of a base document. This can be important where previous versions of a contract are in place along with newer versions. AI_RVSN_NMB Number integer
CustomerAccountContractNarrative A business narrative description of the contract and its terms and conditions. NA_CT_ACNT_CNTRT DescriptionNarrative varchar(4000)
EffectiveDate Date this contract revision is in force. DC_EF_DT EffectiveDate date
ExpirationDate Date this contract revision is no longer in force DC_EP_DT ExpirationDate date
StatusCode Current status of this contract revision. Retailers need to exercise care in assigning status codes. While a contract may be modified prior versions tied to older customer accounts may remain in force. Retailers need to define an appropriate contract life cycle management strategy as part of implementing this entity. CD_STS_CD Code2Status char(2)


Parent Entity Verb Phrase Child Entity
CustomerAccount terms defined by CustomerAccountTermsAndConditions

Logical Views containing CustomerAccountTermsAndConditions

Logical View
Logical 07010 - Customer Account Information Extended