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