YK B2B (Eunji Ver)

Tables (29)

Account (고객, EndUser)

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

CBPaymentDetail__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

CBPaymentHeader__c (Chargeback Payment)

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

ChargebackDetail__c (Chargeback 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
  • Account__c (Account) — Lookup — Foreign key → Account.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
  • Product__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
  • Product__c (Product) — Lookup — Foreign key → Product2.Id — NOT NULL

Opportunity (기회)

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

Product2 (Product)

  • Id — SFId — Primary key — NOT NULL
  • ProductCategory__c (카테고리) — 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 (Untitled)

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

PromaxClaimPaymentItem__c (TP Payment 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 (TP Payment)

  • 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

PromaxTradingTerm__c (Trading Term)

  • Id — SFId — Primary key — NOT NULL
  • Account__c (고객) — Lookup — Foreign key → Account.Id — NOT NULL
  • RecordType — Id — EDLP CDC CRM

SoldTo__c (대리점)

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

TermEDLPUpload__c (Term EDLP Upload)

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

TradingTermCDCItem__c (TT CDC SKU)

  • 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

TradingTermCRMCat__c (TT 장려금 Category)

  • 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

TradingTermCRMItem__c (TT 장려금 SKU)

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

TradingTermEDLPItem__c (TT EDLP SKU)

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

TradingTermPaymentItem__c (TT Payment SKU)

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

TradingTermPayment__c (TT Payment)

  • 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