lacoste

Tables (8)

Customer Master(Raw, Nonsendable in MCE) (Customer Master(Raw))

  • UserId (T_TIERS) — Text(13) — Primary key — NOT NULL — Subscriber Key
  • MasterId
  • Name (T_LIBELLE) — Text(13) — NOT NULL
  • Gender (T_SEXE) — Text(1) — NOT NULL
  • Email (T_EMAIL) — EmailAddress(254)
  • MobilePhone (T_TELEX) — Text(25)
  • TopVistedShop (ET_ETABLISSEMENT) — Text(6) — Foreign key → Store Master.ShopId
  • CreationShop (Creation POS) — Text(6) — NOT NULL
  • CreationDate (T_DATECREATION) — Date — NOT NULL
  • BirthYear — Text(4) — NOT NULL
  • BirthMonth — Text(2) — NOT NULL
  • BirthDay — Text(2) — NOT NULL
  • BirthDate (DATE_NAISSANCE) — Date — NOT NULL
  • Age — Number — NOT NULL
  • LoyaltyLevel (Loyalty_level) — Text(25) — NOT NULL
  • Mileage(LoyaltyBalance) (Loyalty_balance) — Number — NOT NULL
  • EmailOptIn (YTC_INFOEMAIL1) — Boolean
  • PhoneOptIn (YTC_INFOTEL2) — Boolean
  • PostalOptIn (YTC_INFOADRESSE) — Boolean
  • MailNPAI (T_NPAI) — Boolean
  • PhoneNPAI (YTC_TEL2VALIDE) — Boolean
  • Address1 (T_ADRESSE1) — Text(50)
  • Address2 (T_ADRESSE2) — Text(50)
  • zip code (T_CODEPOSTAL) — Text(9)
  • Country (T_PAYS) — Text(3) — NOT NULL
  • Language (T_LANGUE) — Text(3) — NOT NULL
  • Status (T_FERME) — Text(1)
  • IsMerged (123456666) — Boolean
  • UserType (T_NATUREAUXI) — Text(3) — NOT NULL
  • ModificationDate (T_DATEMODIF) — Date — NOT NULL

Customer Master(Sendable in MCE) (Customer Master)

  • UserId (T_TIERS) — Text(13) — Primary key — NOT NULL — Subscriber Key
  • MasterId (1234566)
  • Name (T_LIBELLE) — Text(13) — NOT NULL
  • Gender (T_SEXE) — Text(1) — NOT NULL
  • Email (T_EMAIL) — EmailAddress(254)
  • MobilePhone (T_TELEX) — Text(25)
  • TopVistedShop (ET_ETABLISSEMENT) — Text(6) — Foreign key → Store Master.ShopId
  • CreationShop (Creation POS) — Text(6) — NOT NULL
  • CreationDate (T_DATECREATION) — Date — NOT NULL
  • BirthYear (123) — Text(4) — NOT NULL — NEW
  • BirthMonth (1234) — Text(2) — NOT NULL — NEW
  • BirthDay (23455) — Text(2) — NOT NULL — NEW
  • BirthDate (DATE_NAISSANCE) — Date — NOT NULL
  • Age — Number — NOT NULL — NEW
  • LoyaltyLevel (Loyalty_level) — Text(25) — NOT NULL — NEW
  • Mileage(LoyaltyBalance) (Loyalty_balance) — Number — NOT NULL — NEW
  • EmailOptIn (YTC_INFOEMAIL1) — Boolean
  • PhoneOptIn (YTC_INFOTEL2) — Boolean
  • PostalOptIn (YTC_INFOADRESSE) — Boolean
  • MailNPAI (T_NPAI) — Boolean
  • PhoneNPAI (YTC_TEL2VALIDE) — Boolean
  • Address1 (T_ADRESSE1) — Text(50)
  • Address2 (T_ADRESSE2) — Text(50)
  • zip code (T_CODEPOSTAL) — Text(9)
  • Country (T_PAYS) — Text(3) — NOT NULL
  • Language (T_LANGUE) — Text(3) — NOT NULL
  • Status (T_FERME) — Text(1)
  • IsMerged (123456666) — Boolean — NEW
  • UserType (T_NATUREAUXI) — Text(3) — NOT NULL
  • ModificationDate (T_DATEMODIF) — Date — NOT NULL

Loyalty Master

  • UserId (T_TIERS) — Text(13) — Foreign key → Customer Master(Sendable in MCE).UserId — NOT NULL — Subscriber Key
  • LoyaltyCardId (loyalty card id) — Text — NOT NULL
  • LoyaltyBalance (Loyalty_balance) — Number — NOT NULL
  • LoyaltyBalanceDate (Loyalty_balance_date) — Date — NOT NULL
  • LoyaltyLevel (Loyalty_level) — Text(25) — NOT NULL
  • LoyaltyLevelDate (Loyalty_level_date) — Date — NOT NULL
  • ChangeReason — Text(25) — NOT NULL
  • ExpiringPoints (Expiring points) — Text(35) — NOT NULL
  • NextExpiryDate (Next expiry date) — Date — NOT NULL
  • Field
  • Field2

Product Content

  • Barcode (GA_CODEBARRE) — Text(13) — Foreign key → Product Master.Barcode — NOT NULL — PK
  • LongName (LIB_LONG) — Text(50) — NOT NULL
  • PictureURL (URL_REFCOL) — Text(255) — NOT NULL
  • Field

Product Master

  • Barcode (GA_CODEBARRE) — Text(13) — Primary key — NOT NULL
  • Season (GA_Collection) — Text(3) — NOT NULL
  • ProductId (GA_CODEARTICLE) — Text(18) — NOT NULL
  • StyleGender (GA2_STATART2) — Text(3) — NOT NULL
  • Universe (GA_LIBREART5) — Text(35) — NOT NULL
  • Activity (GA_FAMILLENIV5) — Number — NOT NULL
  • Brand (GA_LIBREART4) — NOT NULL
  • ProductLine (GA_LIBREART7) — NOT NULL
  • Theme (GA_LIBREART1) — NOT NULL
  • ProductName — Text(200) — If possible, it shall be a product name in Korean.
  • Size (GDI_DIMORLI) — Text(10) — NOT NULL
  • Color (GDI_DIMORLI_1) — Text(100) — NOT NULL
  • Field3

Promocode

  • UserId (T_TIERS) — Text(13) — Foreign key → Customer Master(Sendable in MCE).UserId — NOT NULL — Subscriber Key
  • CRPC1 (ID) — Text(6) — NOT NULL
  • UserType (Nature auxiliaire) — Text(3) — NOT NULL
  • Name (T_LIBELLE) — Text(13) — NOT NULL
  • Couponcode (Field4) — Text(6) — NOT NULL
  • CouponCreationDate (Field5) — Date — NOT NULL
  • CouponExpirationDate (Field6) — Date — NOT NULL
  • Ticket_LineId (GL_NUMERO + GL_NUMLIGNE) — Number — NOT NULL
  • CouponStatus — Text(35) — NOT NULL

Sales Master

  • Ticket_LineId (GL_NUMERO + GL_NUMLIGNE) — Number — Primary key — NOT NULL
  • PurchasedShop (ETABLISSEMENT) — Text(6) — NOT NULL — *SFMC attribute name - Transaction/Purchased
  • TicketId (GL_NUMERO) — Number — NOT NULL
  • PurchasedDate (GL_DATEPIECE) — DATE — NOT NULL
  • UserId (T_TIERS) — Text(13) — Foreign key → Customer Master(Sendable in MCE).UserId — NOT NULL — Subscriber Key
  • ProductId (GL_CODEARTICLE) — Text(18) — NOT NULL
  • Qty (GL_QTEFACT) — Number — NOT NULL
  • LineAmount (GL_TOTALTTCDEV) — Number — NOT NULL
  • CouponDiscount (GL_REMISELIBRE2) — Number — *SFMC attribute name - Promo/Coupon
  • LoyaltyDiscount (Loyalty_points) — Text(35) — NOT NULL
  • PromoPrice — Season-off price
  • TotalDiscountAmount (GL_TOTREMLIGNE) — Number — NOT NULL
  • ProductPrice (GL_PUTTC) — Number — NOT NULL
  • CouponCode1 (GL_TYPEREMISE) — Text(6) — It is necessary to check how CBR will deliver the used coupon data.
  • CouponCode2 (Field14) — It is necessary to check how CBR will deliver the used coupon data.
  • CouponCode3 (Field15) — It is necessary to check how CBR will deliver the used coupon data.
  • Barcode (GA_CODEBARRE) — Text(13) — Foreign key → Product Master.Barcode — NOT NULL
  • Field
  • Field2

Store Master

  • ShopId (ET_ETABLISSEMENT) — Text(6) — Primary key — NOT NULL
  • ShopName (ET_LIBELLE) — Text(35) — NOT NULL
  • ShopAddress1 (ET_ADRESSE1) — Text(35) — NOT NULL
  • State (ET_REGION) — Text(9) — NOT NULL
  • City (ET_VILLE) — Text(35) — NOT NULL
  • Country (ET_PAYS) — Text(3) — NOT NULL
  • Phone (ETABLISSEMENT SECONDAIRE) — Text(25) — NOT NULL
  • ShopEmail (ET_EMAIL) — EmailAddress(254) — NOT NULL
  • ShopType (ET_LIBREET1) — Text(6) — NOT NULL
  • ClosedStatus (ET_FERME) — Text(1) — NOT NULL
  • POSType (POS TYPE) — NOT NULL — NEW