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