YK B2B

Tables (33)

Account(Customer) (고객)

  • Id — SFId — Primary key — NOT NULL

Account(EndUser) (EndUser)

  • Id — SFId — Primary key — NOT NULL

ApprovalConditionPath__c (결재 순위)

  • Id — SFId — Primary key — NOT NULL
  • ApprovalCondition__c (결재 Condition) — MD — Foreign key → ApprovalCondition__c.Id — NOT NULL

ApprovalCondition__c (결재 경로와 순서 설정)

  • Id — SFId — Primary key — NOT NULL
  • ApprovalWorkflow__c (결재 워크플로우) — MD — Foreign key → ApprovalWorkflow__c.Id — NOT NULL

ApprovalProcessPath__c (승인 라인)

  • Id — SFId — Primary key — NOT NULL
  • ApprovalProcess__c (승인 처리) — MD — Foreign key → ApprovalProcess__c.Id — NOT NULL

ApprovalProcess__c (승인 처리 내역)

  • Id — SFId — Primary key — NOT NULL
  • ApprovalCondition__c (승인 조건) — Lookup — Foreign key → ApprovalCondition__c.Id — NOT NULL

ApprovalWorkflow__c (결재 조건과 권한 설정)

  • Id — SFId — Primary key — NOT NULL

CBPaymentHeader__c (Chargeback Payment)

  • Id — SFId — Primary key — NOT NULL
  • ChargebackHeader__c (Chargeback) — Lookup — Foreign key → ChargebackHeader__c.Id — NOT NULL
  • CBPaymentWMA__c (CB Payment WMA) — MD — Foreign key → CBPaymentWMA__c.Id — NOT NULL

CBPaymentItem__c (Chargeback Payment SKU)

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

CBPaymentWMA__c (CB Payment WMA)

  • Id — SFId — Primary key — NOT NULL

ChargebackHeader__c (Chargeback)

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

ChargebackItem__c (Chargeback SKU)

  • Id — SFId — Primary key — NOT NULL
  • ChargebackHeader__c (Chargeback Header) — MD — Foreign key → ChargebackHeader__c.Id — NOT NULL
  • Product — Lookup — Foreign key → Product2.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(EndUser).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(Customer).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(Customer).Id — NOT NULL
  • EndUser__c (EndUser) — Lookup — Foreign key → Account(Customer).Id — NOT NULL

OpportunityCategory__c (기회 카테고리)

  • Id — SFId — Primary key — NOT NULL
  • Opportunity (기회) — MD — Foreign key → Opportunity.Id — NOT NULL
  • ProductCategory__c (제품 카테고리) — Lookup — Foreign key → ProductCategory__c.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

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
  • TradePromotion__c (판촉계획) — Lookup — Foreign key → PromaxTradePromotion__c.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(Customer).Id — NOT NULL

PromaxTradingTermItem__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

PromaxTradingTerm__c (Trading Term)

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

SoldTo__c (대리점)

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

TradingTermCRMItemItem__c (TT 장려금 SKU)

  • 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 장려금 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

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 → TradingTermCRMItemItem__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
  • TradingTerm__c (Term) — Lookup — Foreign key → PromaxTradingTerm__c.Id — NOT NULL

Vendor__c (벤더)

  • Id — SFId — Primary key — NOT NULL