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