YK B2C

Tables (27)

Account (고객, EndUser)

  • Id — SFId — Primary key — NOT NULL
  • RecordType — 고객 EndUser

CBPaymentHeader__c (Chargeback Payment)

  • Id — SFId — Primary key — NOT NULL
  • ChargebackHeader__c (Chargeback) — Lookup — Foreign key → ChargebackHeader__c.Id — NOT NULL

CBPaymenyDetail__c (Chargeback Payment SKU)

  • Id — SFId — Primary key — NOT NULL
  • CBPaymentHeader__c (CB payment Header) — MD — Foreign key → CBPaymentHeader__c.Id — NOT NULL
  • ChargebackDetail__c (Chargeback SKU) — Lookup — Foreign key → ChargebackDetail__c.Id — NOT NULL

ChargebackDetail__c (Chageback SKU)

  • Id — SFId — Primary key — NOT NULL
  • ChargebackHeader__c (Chargeback Header) — MD — Foreign key → ChargebackHeader__c.Id — NOT NULL
  • Product2 (Product) — Lookup — Foreign key → Product2.Id — NOT NULL

ChargebackHeader__c (Chargeback)

  • Id — SFId — Primary key — NOT NULL
  • SoldTo__c (대리점) — Lookup — Foreign key → SoldTo__c.Id — NOT NULL
  • EndUser__c (EndUser) — Lookup — Foreign key → Account.Id — NOT NULL

Dummy

  • Id — SFId — Primary key — NOT NULL

EndUser_SoldTo

  • Id — SFId — Primary key — NOT NULL
  • SoldTo__c (대리점) — MD — Foreign key → SoldTo__c.Id — NOT NULL
  • EndUser__c (EndUser) — MD — Foreign key → Account.Id — NOT NULL

FloorPrice__c (Floor Price)

  • Id — SFId — Primary key — NOT NULL
  • Product2__c (Product) — Lookup — Foreign key → Product2.Id — NOT NULL
  • Account__c (Account) — Lookup — Foreign key → Account.Id — NOT NULL

ListPrice__c (List Price)

  • Id — SFId — Primary key — NOT NULL
  • Product2__c (Product) — Lookup — Foreign key → Product2.Id — NOT NULL

Opportunity (기회)

  • Id — SFId — Primary key — NOT NULL
  • Account — Lookup — Foreign key → Account.Id — NOT NULL

Product2 (Product)

  • Id — SFId — Primary key — NOT NULL
  • Id (카테고리) — Lookup — Foreign key → ProductCategory__c.Id — NOT NULL
  • ProductGlobalCategory__c (카테고리(글로벌)) — Lookup — Foreign key → ProductGlobalCategory__c.Id — NOT NULL

ProductCategory__c (제품 카테고리)

  • Id — SFId — Primary key — NOT NULL

ProductGlobalCategory__c (제품 카테고리(글로벌))

  • Id — SFId — Primary key — NOT NULL
  • ProductCategory__c (제품 카테고리) — Lookup — Foreign key → ProductCategory__c.Id — NOT NULL

Program__c (프로그램)

  • Id — SFId — Primary key — NOT NULL

PromaxClaimPaymentItem__c (PY SKU 상세)

  • Id — SFId — Primary key — NOT NULL
  • ClaimPayment__c (상위 페이먼트) — MD — Foreign key → PromaxClaimPayment__c.Id — NOT NULL
  • TradePromotionItem__c (TP ITEM NO) — MD — Foreign key → PromaxTradePromotionItem__c.Id — NOT NULL

PromaxClaimPayment__c (판촉결과)

  • Id — SFId — Primary key — NOT NULL
  • SoldTo__c (지불대상판매처) — Lookup — Foreign key → SoldTo__c.Id — NOT NULL
  • Vendor__c (지불대상벤더) — Lookup — Foreign key → Vendor__c.Id — NOT NULL
  • Deduction__c (비용증빙) — MD — Foreign key → PromaxDeduction__c.Id — NOT NULL
  • TradePromotion__c (판촉계획) — Lookup — Foreign key → PromaxTradePromotion__c.Id — NOT NULL

PromaxDeduction__c (비용증빙)

  • Id — SFId — Primary key — NOT NULL
  • Account (고객) — Lookup — Foreign key → Account.Id — NOT NULL

PromaxTradePromotionItem__c (TP SKU 상세)

  • Id — SFId — Primary key — NOT NULL
  • TradePromotion__c (상위 판촉계획) — MD — Foreign key → PromaxTradePromotion__c.Id — NOT NULL
  • Product__c (자재) — Lookup — Foreign key → Product2.Id — NOT NULL

PromaxTradePromotion__c (판촉계획)

  • Id — SFId — Primary key — NOT NULL
  • Account__c (고객) — Lookup — Foreign key → Account.Id — NOT NULL
  • Program__c (프로그램) — MD — Foreign key → Program__c.Id — NOT NULL

PromaxTradingTermItem__c (TT 가격할인 상세)

  • Id — SFId — Primary key — NOT NULL
  • TradingTerm__c (거래약정) — MD — Foreign key → PromaxTradingTerm__c.Id — NOT NULL
  • Product__c (자재) — Lookup — Foreign key → Product2.Id — NOT NULL

PromaxTradingTerm__c (Trading Term)

  • Id — SFId — Primary key — NOT NULL
  • Account__c (고객) — Lookup — Foreign key → Account.Id — NOT NULL
  • Program__c (프로그램) — Lookup — Foreign key → Program__c.Id — NOT NULL

SoldTo__c (대리점)

  • Id — SFId — Primary key — NOT NULL
  • Account__c (Account) — Lookup — Foreign key → Account.Id — NOT NULL

TradingTermCRMItemItem__c (TT 장려금 상세 실적)

  • Id — SFId — Primary key — NOT NULL
  • TradingTermCRMItem__c (상위 TT 장려금 CTG) — MD — Foreign key → TradingTermCRMItem__c.Id — NOT NULL
  • Product__c (자재) — Lookup — Foreign key → Product2.Id — NOT NULL

TradingTermCRMItem__c (TT 장려금 상세)

  • Id — SFId — Primary key — NOT NULL
  • TradingTerm__c (거래약정) — MD — Foreign key → PromaxTradingTerm__c.Id — NOT NULL
  • Category__c (카테고리) — Lookup — Foreign key → ProductCategory__c.Id — NOT NULL
  • CategoryGlobal__c (카테고리(글로벌)) — Lookup — Foreign key → ProductGlobalCategory__c.Id — NOT NULL

TradingTermPaymentItem__c (PY SKU 상세(TT))

  • Id — SFId — Primary key — NOT NULL
  • TradingTermPayment__c (판촉결과) — MD — Foreign key → TradingTermPayment__c.Id — NOT NULL
  • TradingTermCRMItemItem__c (Term SKU) — MD — Foreign key → TradingTermCRMItemItem__c.Id — NOT NULL

TradingTermPayment__c (판촉결과(TT))

  • Id — SFId — Primary key — NOT NULL
  • SoldTo__c (지불대상판매처) — Lookup — Foreign key → SoldTo__c.Id — NOT NULL
  • Vendor__c (지불대상벤더) — Lookup — Foreign key → Vendor__c.Id — NOT NULL
  • Deduction__c (비용증빙) — MD — Foreign key → PromaxDeduction__c.Id — NOT NULL
  • TradingTerm__c (Term) — Lookup — Foreign key → PromaxTradingTerm__c.Id — NOT NULL

Vendor__c (벤더)

  • Id — SFId — Primary key — NOT NULL