YK B2B Backup
Tables (36)
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
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) — Lookup — Foreign key → ChargebackItem__c.Id — NOT NULL
ChargebackEndUser__c (Chargeback EndUser)
- Id — SFId — Primary key — NOT NULL
- EndUser__c (EndUser) — Lookup — Foreign key → Account(Customer).Id — NOT NULL
- ChargebackHeader__c (Chargeback Header) — MD — Foreign key → ChargebackHeader__c.Id — 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
- 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(Customer).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
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
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
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(Customer).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 → 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
- 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