Customer Tables/Views

Customer CustCnt

PhaseID varchar(12) Company varchar(8)

BankBranchCode varchar(30) CustNum int
OrderNum int ShipToNum varchar(14)
OrderLine int ConNum int
PerCon RoleCd
OrderRelNum int PerConID int
RlsClassCode varchar(15) Company varchar(8) Company varchar(8)
FOB varchar(15) PerConID int PerConID int
BTCustNum int ShipTo RoleCode varchar(20)
BankID varchar(9) SalesRep
CustNum int CustNum int
SalesRepCode varchar(8) ShipToNum varchar(14) Company varchar(8)
ShipToNum varchar(14) CountryNum int SalesRepCode varchar(8)
TermsCode varchar(4) ConNum int RoleCode varchar(20)
ShipViaCode varchar(4) Company varchar(8) PerConID int
GroupCode varchar(4) RoleCode varchar(20)
MarkUpID varchar(4) PerConID int
CurrencyCode varchar(4) SalesRepCode varchar(8) Region
Country
TaxRegionCode varchar(4) TerritoryID varchar(8)
ChargeCode varchar(8) Company varchar(8) RegionCode varchar(12)
PMUID int CountryNum int CountryNum int
SalesTer
RACode varchar(30)
PerConID int Company varchar(8)
ConNum int TerritoryID varchar(8)
ICTypeID varchar(12) CustBank RoleCode varchar(20)
ICCode varchar(12) Company varchar(8) PerConID int
SeqNum int BankBranchCode varchar(30) SalesRepCode varchar(8)
TaxCode varchar(10) CustNum int
Company varchar(8) BankID varchar(9)
RateGrpCode varchar(12) BankBrnch
CountryNum int Company varchar(8)
RoleCode varchar(20) BankBranchCode varchar(30)

CustomerPriceLst CustBillTo
TaxRgn
CustNum int Company varchar(8)
TaxCode varchar(10)
ShipToNum varchar(14) CustNum int
TaxRegionCode varchar(4)
SeqNum int BTCustNum int
Company varchar(8) PerConID int
ListCode varchar(10) ShipToNum varchar(14)
ConNum int

SalesTax
ReservePri Company varchar(8) CustIC
TaxCode varchar(10)
PriorityCode varchar(6) Company varchar(8)
CustNum int
ShipToNum varchar(14)
ICTypeID varchar(12)
ICCode varchar(12)
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

QMarkUp

Company varchar(8) Currency

MarkUpID varchar(4)
Company varchar(8)
CurrencyCode varchar(4)
BookID varchar(12)
DocCurrency varchar(4)
CurrBalAcct varchar(200)
CustGrup FiscalYear int
SalesCat FiscalYearSuffix varchar(8)
Company varchar(8)
FiscalPeriod int
GroupCode varchar(4) Company varchar(8) FiscalCalendarID varchar(12)
SalesCatID varchar(4) SalesCatID varchar(4) GroupID varchar(9)

ShipVia

Company varchar(8)
ShipViaCode varchar(4) Terms

Company varchar(8) PriceLst

PriceLstGroups
TermsCode varchar(4)
Company varchar(8)
Company varchar(8)
ListCode varchar(10)
ListCode varchar(10)
ProdCode varchar(8)
ProdCode varchar(8)
UOMCode varchar(6)
UOMCode varchar(6)
PartNum varchar(50)

PriceLstParts
PayMethod Company varchar(8)
ListCode varchar(10)
Company varchar(8)
PartNum varchar(50)
PMUID int
FOB UOMCode varchar(6)

Company varchar(8)
FOB varchar(15)

RlsClass

Company varchar(8)
RlsClassCode varchar(15) FinCharge

Company varchar(8) Epicor 10 Data Map v3.0

ChargeCode varchar(8)
Epicor Corporation © 2016
www.epicor.com

ReminderGroup

Company varchar(8)
GroupCode varchar(8) RASchedCd

Company varchar(8)
RACode varchar(30)
 Part Tables/Views

UOM

Part Company varchar(8) UOMClass

UOMCode varchar(6)
UOMCode varchar(6) Company varchar(8)
Plant varchar(8) UOMCode varchar(6)
WarehouseCode varchar(8) UOMClassID varchar(12)
OwnerPlant varchar(8) PartSubs PartCost
PartNum varchar(50)
ClassID varchar(4) PartNum varchar(50) PartNum varchar(50)
ProdCode varchar(8) SubPart varchar(50) CostID varchar(8)
SubPart varchar(50) PONUM int ClassID varchar(4) ProdGrup ProdGrupPlt
UOMClassID varchar(12) POLine int SubPart varchar(50)
RevisionNum varchar(12) Company varchar(8) Company varchar(8)
SeqNum int Plant varchar(8) Plant
AltMethod varchar(12) ProdCode varchar(8) ProdCode varchar(8)
PORelNum int WarehouseCode varchar(8)
OprSeq int OwnerPlant varchar(8) OwnerPlant varchar(8)
OwnerPlant varchar(8) Company varchar(8)
MtlSeq int ProdCode varchar(8) ProdCode varchar(8)
BuyerID varchar(8) UOMCode varchar(6) OwnerPlant varchar(8)
PerConID int UOMClassID varchar(12) ClassID varchar(4)
PartPlant PartNum varchar(50)
PartClass Plant varchar(8)
Company varchar(8) PartClassPlt WarehouseCode varchar(8)
Plant varchar(8) Company varchar(8)
PerConID int Company varchar(8)
PartNum varchar(50)
ClassID varchar(4) ClassID varchar(4)
WarehouseCode varchar(8)
OwnerPlant varchar(8) OwnerPlant varchar(8)
VendorNum int
PurPoint varchar(4) BuyerID varchar(8)

PlantWhse

Company varchar(8) SerialNo

Plant varchar(8)
PartNum varchar(50) Company varchar(8)
WarehouseCode varchar(8) PartNum varchar(50)
SerialNumber varchar(40)
PartLot
PartWhse PartBin Company varchar(8)
Company varchar(8) Company varchar(8) PartNum varchar(50)
PartRev LotNum varchar(30)
PartNum varchar(50) PartNum varchar(50)
PartNum varchar(50) WarehouseCode varchar(8) SerialNumber varchar(40) Warehse
RevisionNum varchar(12) BinNum varchar(10) WarehouseCode varchar(8)
Company varchar(8)
MtlSeq int DimCode varchar(6) BinNum varchar(10)
WarehouseCode varchar(8)
OprSeq int LotNum varchar(30) LotNum varchar(30)
BinNum varchar(10)
AltMethod varchar(12) SerialNumber varchar(40) DimCode varchar(6)
ClassID varchar(4)
SubPart varchar(50)
Plant varchar(8) WhseBin
OwnerPlant varchar(8)
ProdCode varchar(8) BinNum varchar(10)
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

UOMCode varchar(6) PartNum varchar(50)

UOMClassID varchar(12) SerialNumber varchar(40)
DimCode varchar(6)
LotNum varchar(30)
BinSize

Company varchar(8)
SizeID varchar(8)
BinNum varchar(10)
PartMtlInsp
VendorPP
WhseZone
Company varchar(8)
PartMtl Company varchar(8)
PartNum varchar(50) BinNum varchar(10)
PurPoint varchar(4)
RevisionNum varchar(12) ZoneID varchar(8)
PartNum varchar(50) VendorNum int
AltMethod varchar(12)
RevisionNum varchar(12) SysRowID varchar(36)
MtlSeq int
MtlSeq int PerConID int
PlanSeq int
AltMethod varchar(12) ConNum int
UOMCode varchar(6)
OprSeq int
ClassID varchar(4)
SubPart varchar(50)
Plant varchar(8) Capability
WarehouseCode varchar(8) OpCode varchar(8)
OwnerPlant varchar(8) OpStdID varchar(5)
ProdCode varchar(8) CapAddl
PartNum varchar(50)
UOMClassID varchar(12) RevisionNum varchar(12)
Company varchar(8) Company varchar(8)
AltMethod varchar(12) CapabilityID varchar(20)
PlanSeq int OprSeq int CapAddID varchar(8)
Company varchar(8)
CapabilityID varchar(20)
PartOpr CapAddID varchar(8)
PartOpDtl
ResourceTypeID varchar(8)
PartNum varchar(50)
PartNum varchar(50) ResourceID varchar(12)
RevisionNum varchar(12)
RevisionNum varchar(12) ResourceGrpID varchar(8)
OprSeq int
VendorNum int OprSeq int
PurPoint varchar(4) ResourceGrpID varchar(8)
AltMethod varchar(12) ResourceID varchar(12)
Company varchar(8) AltMethod varchar(12)
JCDept varchar(8)
ResourceTypeID varchar(8)

OpStd

Company varchar(8)
ResourceGrpID varchar(8)
OpCode varchar(8) OpMaster OpMasDtl
Resource_ ResourceGroup
OpStdID varchar(5)
Company varchar(8) Company varchar(8)
Company varchar(8) Company varchar(8)
VendorNum int PartNum varchar(50)
ResourceTypeID varchar(8) ResourceTypeID varchar(8)
PartNum varchar(50) RevisionNum varchar(12)
ResourceID varchar(12) ResourceID varchar(12)
OpCode varchar(8) AltMethod varchar(12)
JobNum varchar(14) ResourceGrpID varchar(8)
PUM varchar(6) OprSeq int
AssemblySeq int JCDept varchar(8) JCDept EffectiveDate datetime ResourceTypeID varchar(8)
OprSeq int OpCode varchar(8)
Company varchar(8) BreakQty decimal(22,8) ResourceID varchar(12)
OpDtlSeq int OpStdID varchar(5)
WhatIf tinyint JCDept varchar(8)
AllocNum int

Epicor 10 Data Map v3.0

ResourceType OpText
ProdCal ResourceCollection Epicor Corporation © 2016
Company varchar(8) Company varchar(8) www.epicor.com
Company varchar(8) ResourceTypeID varchar(8) Company varchar(8)
OpTextID varchar(4)
CalendarID varchar(8) CollectionID varchar(8)
JCDept varchar(8)
ResourceTypeID varchar(8)
ResourceID varchar(12)
ResourceGrpID varchar(8)
 Supplier Tables/Views
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

VendCnt
Vendor PerCon
Company varchar(8)
BankBranchCode varchar(30) VendorNum int Company varchar(8)
BankID varchar(9) PurPoint varchar(4) PerConID int
VendorNum int ConNum int
PurPoint varchar(4) SysRowID varchar(36)
TermsCode varchar(4) PerConID int
GroupCode varchar(4)
SysRowID varchar(36) VendGrup
ConNum int
PerConID int Company varchar(8)
PartNum varchar(50) VendorPP GroupCode varchar(4)
OpCode varchar(8) Company varchar(8)
PUM varchar(6) PurPoint varchar(4)
EffectiveDate datetime VendorNum int
BreakQty decimal(22,8) SysRowID varchar(36)
PurTerms
PerConID int
ConNum int Company varchar(8)
TermsCode varchar(4)

VendBank

Company varchar(8)
VendorNum int BankBrnch
BankID varchar(9) Company varchar(8)
BankBranchCode varchar(30) BankBranchCode varchar(30)

Manufacturer
VendPart
PartXRefMfg MfgPartNum varchar(50)
PartNum varchar(50)
OpCode varchar(8) PartNum varchar(50)
PUM varchar(6) MfgPartNum varchar(50)
EffectiveDate datetime
VendorNum int
BreakQty decimal(22,8) Lifecycle
MfgPartNum varchar(50)
Company varchar(8)
Code varchar(8)

VendPBrk
OpMaster
Company varchar(8)
PartNum varchar(50) Company varchar(8)
OpCode varchar(8) VendorNum int
PUM varchar(6) PartNum varchar(50)
VendorNum int OpCode varchar(8) Epicor 10 Data Map v3.0
EffectiveDate datetime PUM varchar(6)
BreakQty decimal(22,8)
Epicor Corporation © 2016
EffectiveDate datetime
BreakQty decimal(22,8)
www.epicor.com
 Quotes

QuoteHed Project
MtlSeq int Customer
ProjectID varchar(25)
QtyNum int QuoteQty
QuoteDtl PhaseID varchar(12) PhaseID varchar(12)
CustNum int QuoteMsc MilestoneID varchar(8)
Company varchar(8) BankBranchCode varchar(30)
CurrencyCode varchar(4) MtlSeq int
QuoteNum int OrderNum int
TaskSetID varchar(8) QtyNum int Company varchar(8)
QuoteLine int OrderLine int
ShipToNum varchar(14) ProjectID varchar(25) QuoteNum int
QtyNum int OrderRelNum int
ShipViaCode varchar(4) PhaseID varchar(12) QuoteLine int
SeqNum int RlsClassCode varchar(15)
MktgEvntSeq int SeqNum int QtyNum int
SeqNum int FOB varchar(15)
TermsCode varchar(4) MarkUpID varchar(4) QMarkUp BTCustNum int
BTCustNum int QuoteNum int
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

Company varchar(8) BankID varchar(9)

SysRowID varchar(36) QuoteLine int
QuoteOpr MarkUpID varchar(4) CustNum int
CompNum int MilestoneID varchar(8)
SalesRepCode varchar(8)
QuoteNum int
QuoteAsm VendorNum int ShipToNum varchar(14)
ConNum int
PurPoint varchar(4) VendorPP TermsCode varchar(4)
RACode varchar(30)
MtlSeq int ShipViaCode varchar(4)
GroupCode varchar(4) TaskSet Company varchar(8)
GroupCode varchar(4)
ChargeCode varchar(8) QuoteMtl PurPoint varchar(4)
TaskSetID varchar(8) MarkUpID varchar(4)
RlsClassCode varchar(15) VendorNum int
TaskSetSeq int CurrencyCode varchar(4)
FOB varchar(15) AssemblySeq int SysRowID varchar(36)
RelatedToFile varchar(32) TaxRegionCode varchar(4)
PMUID int MtlSeq int PerConID int
Key1 varchar(50) ChargeCode varchar(8)
MarkUpID varchar(4) VendorNum int ConNum int
Key2 varchar(50) PMUID int
BankID varchar(9) PurPoint varchar(4)
Key3 varchar(50) RACode varchar(30)
RelatedToFile varchar(32) TaskSDtl Company varchar(8)
TaskSeqNum int PerConID int
Key1 varchar(50)
TaskID varchar(8) ConNum int
Key2 varchar(50) Company varchar(8)
TypeCode varchar(8) ICTypeID varchar(12)
Key3 varchar(50) TaskSetID varchar(8)
MktgCamp ICCode varchar(12)
TaskSeqNum int PerConLnkRowID varchar(36) TaskSetSeq int
SeqNum int
TaskID varchar(8) Company varchar(8)
TaxCode varchar(10)
TypeCode varchar(8) MktgCampaignID varchar(8)
Company varchar(8)
PerConLnkRowID varchar(36) SysRowID varchar(36)
RateGrpCode varchar(12)
TaskSetSeq int MktgEvntSeq int
CountryNum int
CallSeqNum int
RoleCode varchar(20)
SalesRepCode varchar(8)
SeqNum int QuoteCnt QSalesRP
PhaseID varchar(12) MktgEvnt
Company varchar(8) Company varchar(8)
Company varchar(8)
QuoteNum int QuoteNum int
BankBranchCode varchar(30) Company varchar(8)
CustNum int SalesRepCode varchar(8)
MktgCampaignID varchar(8)
ShipToNum varchar(14) RoleCode varchar(20) CustBillTo
MktgEvntSeq int
ConNum int PerConID int
SysRowID varchar(36) Company varchar(8)
PerConID int
CustNum int
BTCustNum int
PerConID int
ShipToNum varchar(14)
CustCnt ConNum int

Company varchar(8)
CustNum int SalesRep
CRMComp ShipToNum varchar(14) PerCon
ConNum int Company varchar(8)
Company varchar(8) PerConID int Company varchar(8) SalesRepCode varchar(8)
CRMCall
CompNum int PerConID int RoleCode varchar(20)
PerConID int RelatedToFile varchar(32)
Key1 varchar(50)
Key2 varchar(50)
Key3 varchar(50)
CRMCallCnt CallSeqNum int
RACode varchar(30)
RelatedToFile varchar(32) GroupCode varchar(4)
Key1 varchar(50) ChargeCode varchar(8)
Key2 varchar(50) RlsClassCode varchar(15)
Key3 varchar(50) FOB varchar(15)
CallSeqNum int PMUID int
TaskType Task TaskMast PerConLnkRowID varchar(36) ShipViaCode varchar(4)
PerConID int TermsCode varchar(4)
Company varchar(8) RelatedToFile varchar(32) TaskCnt Company varchar(8) CustNum int CurrencyCode varchar(4)
TypeCode varchar(8) Key1 varchar(50) TaskID varchar(8) ShipToNum varchar(14) BTCustNum int
Key2 varchar(50) Company varchar(8)
ConNum int MarkUpID varchar(4)
Key3 varchar(50) RelatedToFile varchar(32)
TaskID varchar(8) Key1 varchar(50) CustNum int
TaskSNxt BankID varchar(9)
PerConLnkRowID varchar(36) Key2 varchar(50)
TaskSeqNum int Key3 varchar(50) Company varchar(8) SeqNum int
NextTaskSeq int TaskSeqNum int TaskID varchar(8) PhaseID varchar(12)
TaskSetID varchar(8) PerConLnkRowID varchar(36) TaskSetID varchar(8) Company varchar(8)
TaskSetSeq int PerConID int TaskSetSeq int BankBranchCode varchar(30)
TypeCode varchar(8) CustNum int NextTaskSeq int
CallSeqNum int ShipToNum varchar(14)
ConNum int
Epicor 10 Data Map v3.0
Epicor Corporation © 2016
www.epicor.com
 CurrRateGrp

Company varchar(8)
RateGrpCode varchar(12)

Customer CustBillTo

PhaseID varchar(12) Company varchar(8)

Terms BankBranchCode varchar(30) CustNum int
OrderNum int BTCustNum int
OrderHed Company varchar(8)
OrderLine int PerConID int
TermsCode varchar(4) ShipToNum varchar(14)
Company varchar(8) OrderRelNum int
PhaseID varchar(12) RlsClassCode varchar(15) ConNum int
Currency
SeqNum int FOB varchar(15)
CustNum int BTCustNum int Company varchar(8)
ShipToNum varchar(14) BankID varchar(9) CurrencyCode varchar(4)
FOB varchar(15) ShipVia CustNum int BookID varchar(12)
ShipViaCode varchar(4) SalesRepCode varchar(8) DocCurrency varchar(4)
Company varchar(8)
TermsCode varchar(4) ShipToNum varchar(14) CurrBalAcct varchar(200)
ShipViaCode varchar(4)
CurrencyCode varchar(4) TermsCode varchar(4) FiscalYear int
BTCustNum int ShipViaCode varchar(4) FiscalYearSuffix varchar(8)
GroupCode varchar(4) CustCnt FiscalPeriod int
PerConID int
ConNum int MarkUpID varchar(4) Company varchar(8) FiscalCalendarID varchar(12)
CurrencyCode varchar(4) CustNum int GroupID varchar(9)
TaxRegionCode varchar(4) ShipToNum varchar(14)
ChargeCode varchar(8) ConNum int
FOB
PMUID int PerConID int
Company varchar(8) RACode varchar(30) PerCon
FOB varchar(15) PerConID int
OrderMsc Company varchar(8)
ConNum int
PerConID int
ICTypeID varchar(12)
Company varchar(8)
ICCode varchar(12)
OrderNum int
SeqNum int
OrderLine int
TaxCode varchar(10)
SeqNum int MiscChrg Company varchar(8)
RateGrpCode varchar(12)
Company varchar(8)
CountryNum int
MiscCode varchar(4)
RoleCode varchar(20)
OrderNum int
OrderLine int
SeqNum int
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

CustGrup

Company varchar(8)
GroupCode varchar(4)
OrderDtl SalesCatID varchar(4)
PhaseID varchar(12) Part
SeqNum int UOMCode varchar(6)
PartNum varchar(50) SalesCat
Plant varchar(8)
ClassID varchar(4) WarehouseCode varchar(8) Company varchar(8)
SubPart varchar(50) OwnerPlant varchar(8) SalesCatID varchar(4)
Plant varchar(8) PartNum varchar(50)
WarehouseCode varchar(8) ClassID varchar(4)
UOMCode varchar(6) ProdCode varchar(8)
UOMClassID varchar(12) SubPart varchar(50)
MtlSeq int UOMClassID varchar(12)
QtyNum int RevisionNum varchar(12)
Company varchar(8) AltMethod varchar(12)
MktgCampaignID varchar(8) OprSeq int
MktgEvntSeq int MtlSeq int
SysRowID varchar(36) ProdGrup
BuyerID varchar(8)
SalesCatID varchar(4) PerConID int Company varchar(8)
ProdCode varchar(8) ProdCode varchar(8)
OwnerPlant varchar(8) OwnerPlant varchar(8) MktgCamp
ProjectID varchar(25)
MilestoneID varchar(8) Company varchar(8)
MktgCampaignID varchar(8)
SysRowID varchar(36)
MktgEvntSeq int

MktgEvnt

Company varchar(8)
MktgCampaignID varchar(8)
QuoteDtl MktgEvntSeq int
SysRowID varchar(36)
MtlSeq int
QtyNum int
ProjectID varchar(25)
PhaseID varchar(12)
SeqNum int Project ProjPhase ShipTo
MarkUpID varchar(4)
QuoteNum int ProjectID varchar(25) ProjectID varchar(25) CustNum int
QuoteLine int PhaseID varchar(12) PhaseID varchar(12) ShipToNum varchar(14)
MilestoneID varchar(8) MilestoneID varchar(8) MtlSeq int CountryNum int
OprSeq int ConNum int
ProjectMilestone OpDtlSeq int Company varchar(8)
RoleCode varchar(20)
Company varchar(8) PerConID int
ProjectID varchar(25) SalesRepCode varchar(8)
MilestoneID varchar(8) TerritoryID varchar(8)

OrderRel

Company varchar(8)
OrderNum int
OrderLine int Plant
OrderRelNum int PartWhse
Company varchar(8)
ShipToNum varchar(14)
ProdCode varchar(8) Company varchar(8)
WarehouseCode varchar(8)
OwnerPlant varchar(8) JobProd PartNum varchar(50)
PartNum varchar(50)
ClassID varchar(4) WarehouseCode varchar(8)
PONum int Company varchar(8)
PartNum varchar(50) BinNum varchar(10) Epicor 10 Data Map v3.0
POLine int WarehouseCode varchar(8)
Plant varchar(8) DimCode varchar(6)
PORelNum int
WarehouseCode varchar(8) TargetJobNum varchar(14) Epicor Corporation © 2016
TargetJobNum varchar(14) LotNum varchar(30)
TargetAssemblySeq int www.epicor.com
TargetAssemblySeq int TargetMtlSeq int SerialNumber varchar(40)
TargetMtlSeq int PartNum varchar(50) ClassID varchar(4)
CustNum int MtlSeq int SubPart varchar(50)
ProjectID varchar(25) Plant varchar(8)
PhaseID varchar(12) OwnerPlant varchar(8)
CountryNum int ProdCode varchar(8)
UOMCode varchar(6)
UOMClassID varchar(12)
Sales Orders
 JobHead ProjPhase Project

MtlSeq int ProjectID varchar(25) ProjectID varchar(25)

OprSeq int PhaseID varchar(12) PhaseID varchar(12)
OpDtlSeq int MtlSeq int MilestoneID varchar(8) Epicor 10 Data Map v3.0
PartNum varchar(50) OprSeq int Epicor Corporation © 2016
ProdCode varchar(8) OpDtlSeq int www.epicor.com
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

ProjectID varchar(25)
JobOper
Plant varchar(8) JobAsmbl
PhaseID varchar(12) Company varchar(8)
WarehouseCode
TargetJobNum
varchar(8)
varchar(14)
MtlSeq
OprSeq
int
int
JobNum varchar(14)
OpMaster
Jobs
OpDtlSeq int
TargetAssemblySeq int OpDtlSeq int AssemblySeq int
Company varchar(8)
TargetMtlSeq int OprSeq int
VendorNum int Capability
ClassID varchar(4)
PartNum varchar(50)
SubPart varchar(50)
OpCode varchar(8) OpCode varchar(8)
OwnerPlant varchar(8)
PUM varchar(6) OpStdID varchar(5)
UOMCode varchar(6) JobMtl JobOpDtl EffectiveDate datetime PartNum varchar(50)
UOMClassID varchar(12)
MtlSeq int Company varchar(8) BreakQty decimal(22,8) RevisionNum varchar(12)
Company varchar(8)
PartNum varchar(50) JobNum varchar(14) AltMethod varchar(12)
WarehouseCode varchar(8) AssemblySeq int OprSeq int
JobProd VendorNum int OprSeq int Company varchar(8)
PurPoint varchar(4) OpDtlSeq int CapabilityID varchar(20)
Company varchar(8) CapAddID varchar(8)
Plant varchar(8) ResourceGrpID varchar(8)
WarehouseCode varchar(8) ResourceTypeID varchar(8)
ProdCode varchar(8) ResourceID varchar(12)
TargetJobNum varchar(14) ResourceID varchar(12)
ClassID varchar(4) JCDept varchar(8)
TargetAssemblySeq int ResourceGrpID varchar(8)
SubPart varchar(50) ResourceTypeID varchar(8)
TargetMtlSeq int
OwnerPlant varchar(8)
PartNum varchar(50)
UOMCode varchar(6)
MtlSeq int Resource_
UOMClassID varchar(12)
BuyerID varchar(8)
Company varchar(8)
PerConID int VendorPP ResourceTypeID varchar(8)
TargetJobNum varchar(14) ResourceGroup
Company varchar(8) ResourceID varchar(12)
TargetAssemblySeq int
PurPoint varchar(4) JobNum varchar(14)
TargetMtlSeq int Company varchar(8)
VendorNum int AssemblySeq int
Company varchar(8) ResourceTypeID varchar(8)
SysRowID varchar(36) OprSeq int
JobNum varchar(14) ResourceID varchar(12)
PerConID int OpDtlSeq int
AssemblySeq int ResourceGrpID varchar(8)
ConNum int WhatIf tinyint
OprSeq int JCDept varchar(8)
AllocNum int
OpDtlSeq int OpCode varchar(8)
OpStdID varchar(5)

PartWhse OrderRel ResourceTimeUsed

Part
Company varchar(8) Company varchar(8) Company varchar(8)
OrderNum int UOMCode varchar(6) PartClass
PartNum varchar(50) JobNum varchar(14)
WarehouseCode varchar(8) OrderLine int Plant varchar(8) AssemblySeq int
Company varchar(8)
BinNum varchar(10) OrderRelNum int WarehouseCode varchar(8) OprSeq int
PerConID int
DimCode varchar(6) ShipToNum varchar(14) OwnerPlant varchar(8) OpDtlSeq int
ClassID varchar(4)
LotNum varchar(30) WarehouseCode varchar(8) PartNum varchar(50) WhatIf tinyint
OwnerPlant varchar(8)
SerialNumber varchar(40) PartNum varchar(50) ClassID varchar(4) AllocNum int
BuyerID varchar(8)
ClassID varchar(4) PONum int ProdCode varchar(8)
SubPart varchar(50) POLine int SubPart varchar(50)
Plant varchar(8) PORelNum int UOMClassID varchar(12) ProdGrup
OwnerPlant varchar(8) TargetJobNum varchar(14) RevisionNum varchar(12)
TargetAssemblySeq int AltMethod varchar(12) Company varchar(8)
ProdCode varchar(8)
TargetMtlSeq int OprSeq int ProdCode varchar(8)
UOMCode varchar(6)
CustNum int MtlSeq int OwnerPlant varchar(8)
UOMClassID varchar(12)
ProjectID varchar(25) BuyerID varchar(8)
PhaseID varchar(12) PerConID int
CountryNum int
 VendorPP
PurAgent
PerCon
POHeader Currency Company varchar(8)
Company varchar(8)
Company varchar(8) PurPoint varchar(4)
POLine int BuyerID varchar(8)
Company varchar(8) PerConID int VendorNum int
SeqNum int PerConID int
CurrencyCode varchar(4) SysRowID varchar(36)
PORelNum int BookID varchar(12) PerConID int
PONum int DocCurrency varchar(4) ConNum int
BuyerID varchar(8) CurrBalAcct varchar(200)
VendorNum int FiscalYear int
PurPoint varchar(4) FiscalYearSuffix varchar(8)
CurrencyCode varchar(4) CurrRateGrp FiscalPeriod int VendCnt
RateGrpCode varchar(12) FiscalCalendarID varchar(12)
Company varchar(8)
SysRowID varchar(36) GroupID varchar(9) Company varchar(8)
RateGrpCode varchar(12)
PerConID int VendorNum int
ConNum int PurPoint varchar(4)
ConNum int
SysRowID varchar(36)
PerConID int
POMisc

Company varchar(8)
PurMisc
PONum int
POLine int Company varchar(8) Vendor
SeqNum int MiscCode varchar(4)
BankBranchCode varchar(30)
PONum int
BankID varchar(9)
POLine int
VendorNum int
SeqNum int
PurPoint varchar(4)
TermsCode varchar(4)
GroupCode varchar(4)
PartSubs Part SysRowID varchar(36)
PODetail ConNum int
PartNum varchar(50) UOMCode varchar(6)
PerConID int
SeqNum int SubPart varchar(50) Plant varchar(8)
PartNum varchar(50)
PORelNum int PONUM int WarehouseCode varchar(8)
OpCode varchar(8)
PONUM int POLine int OwnerPlant varchar(8)
PUM varchar(6)
POLine int SeqNum int PartNum varchar(50)
EffectiveDate datetime
PUM varchar(6) PORelNum int ClassID varchar(4)
BreakQty decimal(22,8)
PartNum varchar(50) ProdCode varchar(8)
ClassID varchar(4) SubPart varchar(50)
VendorNum int UOMClassID varchar(12)
PartClass
OwnerPlant varchar(8) RevisionNum varchar(12)
OpCode varchar(8) Company varchar(8) AltMethod varchar(12)
EffectiveDate datetime PerConID int OprSeq int
BreakQty decimal(22,8) ClassID varchar(4) MtlSeq int
BuyerID varchar(8) OwnerPlant varchar(8) BuyerID varchar(8)
VendPart
PerConID int BuyerID varchar(8) PerConID int
PartNum varchar(50)
OpCode varchar(8)
PUM varchar(6)
EffectiveDate datetime
VendorNum int
Manufacturer BreakQty decimal(22,8)
MfgPartNum varchar(50)
MfgPartNum varchar(50)

PartWhse

Company varchar(8)
PartNum varchar(50) ReqDetail
WarehouseCode varchar(8)
BinNum varchar(10) ReqNum int ReqHead
DimCode varchar(6) ReqLine int
LotNum varchar(30) PONUM int ReqLine int
SerialNumber varchar(40) POLine int ReqNum int
ClassID varchar(4) PORelNum int Company varchar(8)
SubPart varchar(50) BuyerID varchar(8) VendorNum int
Plant varchar(8) ClassID varchar(4) PurPoint varchar(4)
OwnerPlant varchar(8) OwnerPlant varchar(8)
PORel PerConID int
ProdCode varchar(8)
PONum int UOMCode varchar(6)
POLine int UOMClassID varchar(12)
PORelNum int JobOper
WarehouseCode varchar(8)
ProjectID varchar(25) Company varchar(8)
PhaseID varchar(12) JobNum varchar(14)
MtlSeq int OpDtlSeq int
PartNum varchar(50) AssemblySeq int
OprSeq int OprSeq int
OpDtlSeq int ContainerDetail ContainerHeader
RelatedToFile varchar(32)
Key1 varchar(50) ContainerID int ContainerID int
Key2 varchar(50) PONum int PONum int
Key3 varchar(50) POLine int POLine int
Key4 varchar(50) PORelNum int PORelNum int
Key5 varchar(50)
Key6 varchar(50)
TGLCTranNum int

ProjPhase
Project
OrderRel ProjectID varchar(25)
PhaseID varchar(12) ProjectID varchar(25)
Company varchar(8) MtlSeq int PhaseID varchar(12)
OrderNum int JobMtl OprSeq int MilestoneID varchar(8)
OrderLine int TranGLC
OpDtlSeq int
OrderRelNum int MtlSeq int
Company varchar(8)
ShipToNum varchar(14) PartNum varchar(50)
RelatedToFile varchar(32)
WarehouseCode varchar(8) WarehouseCode varchar(8)
Key1 varchar(50)
PartNum varchar(50) VendorNum int
Key2 varchar(50)
PONum int PurPoint varchar(4)
Key3 varchar(50)
POLine
PORelNum
int
int
Key4
Key5
varchar(50)
varchar(50)
Plant
ProdCode
varchar(8)
varchar(8) Purchase Orders
TargetJobNum varchar(14) ClassID varchar(4)
Key6 varchar(50)
TargetAssemblySeq int SubPart varchar(50)
TGLCTranNum int
TargetMtlSeq int OwnerPlant varchar(8)
CustNum int UOMCode varchar(6)
ProjectID varchar(25) UOMClassID varchar(12)
BuyerID varchar(8) Epicor 10 Data Map v3.0
PhaseID varchar(12)
CountryNum int PerConID int Epicor Corporation © 2016
TargetJobNum varchar(14) www.epicor.com
TargetAssemblySeq int
TargetMtlSeq int
Company varchar(8)
JobNum varchar(14)
AssemblySeq int
OprSeq int
OpDtlSeq int
 COA

Company
ReportID
varchar(8)
varchar(15)
General Ledger
LineNum int GLBook
SeqNum int
COACode varchar(10) GroupID varchar(9)
SegmentNbr int BookID varchar(12)
GroupID varchar(9) GLControlType varchar(30) Currency
BookID varchar(12) GLCTAcctNum int
Company varchar(8) GlRptMas
CurrencyCode varchar(4) GLRptCol
Company varchar(8)
COASegment BookID varchar(12) GLCurBal
ReportID varchar(15) Company varchar(8)
DocCurrency varchar(4)
LineNum int ReportID varchar(15)
Company varchar(8) CurrBalAcct varchar(200) Company varchar(8)
SeqNum int ColSetID varchar(8)
COACode varchar(10) FiscalYear int BookID varchar(12)
SysRowID varchar(36) ColumnNum int
SegmentNbr int FiscalYearSuffix varchar(8) DocCurrency varchar(4)
ColSetID varchar(8) SysRowID varchar(36)
SegmentParent varchar(8) FiscalPeriod int CurrBalAcct varchar(200)
ColumnNum int
SegSequence int FiscalCalendarID varchar(12) FiscalYear int
SegValue varchar(50) GroupID varchar(9) FiscalPeriod int
FiscalYearSuffix varchar(8)
GlRptRow FiscalCalendarID varchar(12)
FiscalCal Company varchar(8) ReportID varchar(15)
ReportID varchar(15) LineNum int
Company varchar(8) COAActCat SeqNum int
FiscalCalendarID varchar(12) LineNum int
FiscalYear int SeqNum int
Company varchar(8)
FiscalYearSuffix varchar(8) COACode varchar(10)
FiscalPeriod int CategoryID varchar(10) GLRptRowAcct
GroupID varchar(9) ReportID varchar(15)
GLAcctSegValues BookID varchar(12) LineNum int Company varchar(8)
SeqNum int GLDailyBal
ReportID varchar(15)
Company varchar(8) LineNum int Company varchar(8)
SegmentParent varchar(8) SeqNum int BookID varchar(12)
SegSequence int BalanceAcct varchar(200)
SegValue varchar(50) FiscalYear int
COACode varchar(10) FiscalYr FiscalPeriod int
GLAccount varchar(200) periodDate datetime
CategoryID varchar(10) Company varchar(8)
FiscalYearSuffix varchar(8)
ReportID varchar(15) GroupID varchar(9)
FiscalCalendarID varchar(12)
LineNum int FiscalCalendarID varchar(12)
GLJrnHed GLJrnDtl ReportID varchar(15)
SeqNum int FiscalYear int
LineNum int
FiscalYearSuffix varchar(8) Company varchar(8)
Company varchar(8) SeqNum int
FiscalPeriod int FiscalYear int
FiscalYear int
JournalNum int JournalNum int
FiscalPer JournalCode varchar(4) JournalLine int
GLJrnGrp FiscalPeriod int
BookID varchar(12)
GLAccount Company varchar(8) JournalCode varchar(4)
Company varchar(8) FiscalYearSuffix varchar(8)
GroupID varchar(9) COACode varchar(10) GLPeriodBal
Company varchar(8) GroupID varchar(9) FiscalCalendarID varchar(12)
FiscalCalendarID varchar(12) GLAccount varchar(200)
COACode varchar(10) BookID varchar(12) SysRowID varchar(36) Company varchar(8)
FiscalYear int BookID varchar(12)
GLAccount varchar(200) FiscalYear int JournalLine int BookID varchar(12)
FiscalYearSuffix varchar(8) FiscalYearSuffix varchar(8)
ReportID varchar(15) FiscalPeriod int JournalCode varchar(4) BalanceAcct varchar(200)
FiscalCalendarID varchar(12)
LineNum int SysRowID varchar(36) FiscalYearSuffix varchar(8) BalanceType varchar(1)
SysRowID varchar(36)
SeqNum int BookID varchar(12) FiscalCalendarID varchar(12) FiscalYear int
BalanceAcct varchar(200)
GLControlType varchar(30) JournalCode varchar(4) SysRowID varchar(36) FiscalPeriod int
periodDate datetime
GLControlCode varchar(12) JournalNum int JournalNum int FiscalYearSuffix varchar(8)
BalanceType varchar(1)
GLAcctContext varchar(30) DocCurrency varchar(4) FiscalCalendarID varchar(12)
BookID varchar(12) CurrBalAcct varchar(200)

GLCntrlType GLCntrl
BusinessEntity varchar(30) GLControlType varchar(30) GLCntrlAcct
GLCTAcctNum int GLControlCode varchar(12)
JrnlContext varchar(30) GLControlType varchar(30)
GLControlCode varchar(12) TranGLC
GLAcctContext varchar(30)
GLCTEntity Epicor 10 Data Map v3.0
BookID varchar(12) GLAcctContext varchar(30) Company varchar(8)
Company varchar(8) BookID varchar(12) RelatedToFile varchar(32) Epicor Corporation © 2016
GLControlType varchar(30) SysRowID varchar(36) Key1 varchar(50) www.epicor.com
BusinessEntity varchar(30) Company varchar(8) Key2 varchar(50)
GLCntrlJrnl FiscalYear int Key3 varchar(50)
GLCTAcctCntxt GLCTJrnlCntxt JournalCode varchar(4) Key4 varchar(50)
Company varchar(8)
JournalNum int Key5 varchar(50)
Company varchar(8) Company varchar(8) GLControlType varchar(30)
JournalLine int Key6 varchar(50)
GLControlType varchar(30) GLControlType varchar(30) GLControlCode varchar(12)
JrnlContext varchar(30) TGLCTranNum int
GLCTAcctNum int JrnlContext varchar(30)
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

InvcHead InvcMisc CheckHed APTran BankTran LaborDtl InvcDtl

Company varchar(8) Company varchar(8) Company varchar(8) Company varchar(8) Company varchar(8) Company varchar(8) Company varchar(8)
InvoiceNum int InvoiceNum int HeadNum int HeadNum int BankAcctID varchar(5) LaborHedSeq int InvoiceNum int
InvoiceLine int APTranNo int TranNum int LaborDtlSeq int InvoiceLine int
InvcDtl SeqNum int InvoiceNum varchar(20) Voided tinyint
Voided tinyint PartTran LaborDtl
Company varchar(8)
InvoiceNum int Company varchar(8) Company varchar(8)
APPNHead APPNDtl
InvoiceLine int SysDate_ datetime LaborHedSeq int
Company varchar(8) Company varchar(8) SysTime int LaborDtlSeq int
InvcTax HeadNum int InvoiceNum varchar(20) TranNum int
GroupID varchar(8) HeadNum int
Company varchar(8) GroupID varchar(8) PORel
InvcDtl
InvoiceNum int
InvoiceLine int PONum int
APInvHed APInvTax LogAPInv Company varchar(8)
TaxCode varchar(10) POLine int
InvoiceNum int
RateCode varchar(10) PORelNum int
Company varchar(8) Company varchar(8) Company varchar(8) InvoiceLine int
ECAcquisitionSeq int WarehouseCode varchar(8)
VendorNum int VendorNum int VendorNum int
ProjectID varchar(25)
InvoiceNum varchar(20) InvoiceNum varchar(20) InvoiceNum varchar(20)
PhaseID varchar(12)
TaxCode varchar(10)
CashHead CashDtl MtlSeq int
APInvExp ECAcquisitionSeq int
PartNum varchar(50)
Company varchar(8) Company varchar(8) RateCode varchar(10) FAAddition
Company varchar(8) OprSeq int
GroupID varchar(8) GroupID varchar(8)
VendorNum int Company varchar(8) OpDtlSeq int
HeadNum int HeadNum int
InvoiceNum varchar(20) LogAPInvTax AssetNum varchar(20) RelatedToFile varchar(32)
InvoiceNum int APInvJob
InvoiceLine int AdditionNum int Key1 varchar(50)
InvoiceRef int Company varchar(8)
BankTran InvExpSeq int Company varchar(8) Key2 varchar(50)
VendorNum int VendorNum int Key3 varchar(50)
Company varchar(8) InvoiceNum varchar(20) InvoiceNum varchar(20) FADisposal Key4 varchar(50)
BankAcctID varchar(5) APInvMsc
InvoiceLine int TaxCode varchar(10) Key5 varchar(50)
TranNum int Company varchar(8) JobNum varchar(14) ECAcquisitionSeq int Company varchar(8) Key6 varchar(50)
Voided tinyint VendorNum int AssemblySeq int RateCode varchar(10) AssetNum varchar(20) TGLCTranNum int
InvoiceNum varchar(20) MtlSeq int Void tinyint DisposalNum int
InvoiceLine int SysRowID varchar(36)
MscNum int FATran
SysRowID varchar(36)
Company varchar(8) BankAcct
AssetNum varchar(20)
AssetRegID varchar(12) Company varchar(8)
DetailNum int BankAcctID varchar(5)
SeqNum int
 Epicor 10 Data Map v3.0
TranGLC Relationships
Epicor Corporation © 2016
www.epicor.com

Module Document RealtedtoFile Key Field Indexes and relationships (Company, BookID, Key*)
Key1 Key2 Key3 Key4 Key5 Key6

AP AP Invoice ApInvExp VendorNum APInvHed InvoiceLine Sequence

APInvHead VendorNum APInvHed
APInvTax VendorNum InvoiceNUm TaxCode RateCode
APInvJob VendorNum APInvHed InvoiceLine Job Number Assembly Material
APTran APHeadNUm APTranNo APInvoiceNumAPTranVoided
APInvMisc VendorNum APInvHed InvoiceLine
BankTran BankTran BankAcctID BankTranNum Voided BankGroupID
Check CheckHed CheckHedNum
Logged AP Invoice LogAPInv VendorNum InvoiceNum
LogAPInvTax VendorNum InvoiceNum InvoiceLine
AP Promissary Notes APPNHead GroupID HeadNum
APPNDtl GroupID HeadNum

AR BankTran BankTran BankAcctID BankTranNum Voided BankGroupID

Cash CashDtl GroupID CashHeadNumARInvoiceNUmCashInvRef
CashHead GroupID CashHeadNumARInvoiceNUmCashInvRef
AR Invoice InvcDtl InvoiceNum InvoiceLine
InvcHed InvoiceNum
InvcDtl InvoiceNum InvoiceLine
InvcMisc InvoiceNum InvoiceLine Sequence
InvcTax InvoiceNum InvoiceLine TaxCode RateCode

BK BankTran BankTran BankAcctID BankTranNum Voided BankGroupID

FA Asset Addition FAAddition AssetNum AdditionNum

Asset Disposal FADisposal AssetNUm DisposalNum
Asset Transaction FATran AssetNum AssetSeq

JC AR Invoice InvcDtl InvoiceNum InvoiceLine

Labor LaborDtl LaborHedSeq LaborDtlSeq
PartTran PartTran SysDate SysTime TranNum

PJ AR Invoice InvcDtl InvoiceNum InvoiceLine

Labor LaborDtl LaborHedSeq LaborDtlSeq
PO PORelease PONum POLine PORelNum

Use at own risk as this is to be used as Reference Only and any

subsequent data sets should be verified before use
 QuoteHed
OrderHed
MtlSeq int
QtyNum
CustNum
int
int
Company
PhaseID
varchar(8)
varchar(12)
System Overview
CurrencyCode varchar(4) SeqNum int
TaskSetID varchar(8) CustNum int
ShipToNum varchar(14) ShipToNum varchar(14)
ShipViaCode varchar(4) FOB varchar(15)
MktgEvntSeq int ShipViaCode varchar(4)
TermsCode varchar(4) TermsCode varchar(4)
BTCustNum int CurrencyCode varchar(4)
QuoteDtl
SysRowID varchar(36) BTCustNum int
CompNum int MtlSeq int PerConID int ECOGroup
QuoteNum int QtyNum int ConNum int
ConNum int ProjectID varchar(25) Company varchar(8)
RACode varchar(30) PhaseID varchar(12) GroupID varchar(30)
GroupCode varchar(4) SeqNum int PartNum varchar(50)
ChargeCode varchar(8) MarkUpID varchar(4) OrderDtl RevisionNum varchar(12)
RlsClassCode varchar(15) QuoteNum int OrderRel AltMethod varchar(12)
FOB varchar(15) QuoteLine int PhaseID varchar(12) MtlSeq int
PMUID int MilestoneID varchar(8) SeqNum int Company varchar(8) OprSeq int
MarkUpID varchar(4) OrderRelNum int OrderNum int
BankID varchar(9) OrderNum int OrderLine int Part PartRev
RelatedToFile varchar(32) OrderLine int OrderRelNum int
Key1 varchar(50) QuoteAsm PartNum varchar(50) ShipToNum varchar(14) UOMCode varchar(6) PartNum varchar(50)
Key2 varchar(50) ClassID varchar(4) WarehouseCode varchar(8) Plant varchar(8) RevisionNum varchar(12)
MtlSeq int SubPart varchar(50) ECORev
Key3 varchar(50) PartNum varchar(50) WarehouseCode varchar(8) MtlSeq int
TaskSeqNum int Plant varchar(8) PONum int OwnerPlant varchar(8) OprSeq int Company varchar(8)
TaskID varchar(8) WarehouseCode varchar(8) POLine int PartNum varchar(50) AltMethod varchar(12) GroupID varchar(30)
TypeCode varchar(8) QuoteOpr UOMCode varchar(6) PORelNum int ClassID varchar(4) PartNum varchar(50)
PerConLnkRowID varchar(36) UOMClassID varchar(12) TargetJobNum varchar(14) ProdCode varchar(8) RevisionNum varchar(12)
VendorNum int MtlSeq int TargetAssemblySeq int SubPart varchar(50) PartOpr
TaskSetSeq int AltMethod varchar(12)
PurPoint varchar(4) QtyNum int TargetMtlSeq int UOMClassID varchar(12)
CallSeqNum int MtlSeq int
Company varchar(8) RevisionNum varchar(12) PartNum varchar(50)
SalesRepCode varchar(8) CustNum int OprSeq int
MktgCampaignID varchar(8) AltMethod varchar(12) RevisionNum varchar(12)
OrderNum int ProjectID varchar(25)
MktgEvntSeq int OprSeq int OprSeq int
OrderLine int PhaseID varchar(12)
QuoteMtl SysRowID varchar(36) MtlSeq int VendorNum int
OrderRelNum int CountryNum int
SalesCatID varchar(4) BuyerID varchar(8) PurPoint varchar(4)
SeqNum int AssemblySeq int ProdCode varchar(8) PerConID int AltMethod varchar(12)
PhaseID varchar(12) MtlSeq int ECOOpr
OwnerPlant varchar(8) Company varchar(8)
Company varchar(8) VendorNum int
BankBranchCode varchar(30) ProjectID varchar(25) Company varchar(8)
PurPoint varchar(4) MilestoneID varchar(8) PartWhse PartNum varchar(50)
Company varchar(8) PartMtl RevisionNum varchar(12)
Company varchar(8)
OprSeq int
PartNum varchar(50) PartNum varchar(50)
GroupID varchar(30)
WarehouseCode varchar(8) RevisionNum varchar(12)
AltMethod varchar(12)
BinNum varchar(10) MtlSeq int
DimCode varchar(6) AltMethod varchar(12)
LotNum varchar(30) UOMCode varchar(6)
SerialNumber varchar(40) OprSeq int
ClassID varchar(4) ClassID varchar(4)
PartSug SubPart varchar(50) SubPart varchar(50) ECOMtl
JobProd Plant varchar(8) Plant varchar(8)
Company varchar(8) OwnerPlant varchar(8) WarehouseCode varchar(8) Company varchar(8)
Epicor 10 Data Map v3.0 Company varchar(8)
Use at own risk as this is to be used as Reference Only and any subsequent data sets should be verified before use

Classifier varchar(3) ProdCode varchar(8) OwnerPlant varchar(8) PartNum varchar(50)

Epicor Corporation © 2016 WarehouseCode varchar(8) Type varchar(3) UOMCode varchar(6) ProdCode varchar(8) RevisionNum varchar(12)
www.epicor.com TargetJobNum varchar(14) PartNum varchar(50) UOMClassID varchar(12) MtlSeq int
UOMClassID varchar(12)
TargetAssemblySeq int TargetJobNum varchar(14) GroupID varchar(30)
Company varchar(8)
TargetMtlSeq int TargetAssemblySeq int AltMethod varchar(12)
PlanSeq int
PartNum varchar(50) TargetMtlSeq int
MtlSeq int JobNum varchar(14)
AssemblySeq int
JobSeq int
OrderNum int
OrderLine int
OrderRelNum int
WarehouseCode varchar(8)
DueDate datetime
SugNum int

POHeader PODetail
JobHead JobAsmbl
POLine int SeqNum int
MtlSeq int MtlSeq int SeqNum int PORelNum int
OprSeq int OprSeq int PORelNum int PONUM int
OpDtlSeq int OpDtlSeq int PONum int POLine int
PartNum varchar(50) BuyerID varchar(8) PUM varchar(6)
ProdCode varchar(8) VendorNum int PartNum varchar(50)
ProjectID varchar(25) JobOper PurPoint varchar(4) ClassID varchar(4)
Plant varchar(8) CurrencyCode varchar(4) VendorNum int
Company varchar(8)
PhaseID varchar(12) RateGrpCode varchar(12) OwnerPlant varchar(8)
JobNum varchar(14)
WarehouseCode varchar(8) SysRowID varchar(36) OpCode varchar(8)
OpDtlSeq int
TargetJobNum varchar(14) PerConID int EffectiveDate datetime
AssemblySeq int
TargetAssemblySeq int ConNum int BreakQty decimal(22,8)
OprSeq int
TargetMtlSeq int BuyerID varchar(8)
ClassID varchar(4) PerConID int
SubPart varchar(50) JobMtl
OwnerPlant varchar(8)
UOMCode varchar(6) MtlSeq int SugPoDtl
UOMClassID varchar(12) PartNum varchar(50)
WarehouseCode varchar(8) PORel Company varchar(8)
Company varchar(8)
VendorNum int SugNum int
PONum int PONUM int
PurPoint varchar(4)
POLine int POLine int
Plant varchar(8)
PORelNum int PORelNum int
ProdCode varchar(8)
WarehouseCode varchar(8)
ClassID varchar(4)
ProjectID varchar(25)
SubPart varchar(50)
PhaseID varchar(12)
OwnerPlant varchar(8)
MtlSeq int
UOMCode varchar(6)
PartNum varchar(50)
UOMClassID varchar(12)
OprSeq int
BuyerID varchar(8)
OpDtlSeq int
PerConID int SugPOChg
RelatedToFile varchar(32)
OrderNum int
Key1 varchar(50)
OrderLine int Company varchar(8)
Key2 varchar(50)
OrderRelNum int PONum int
Key3 varchar(50)
TargetJobNum varchar(14) POLine int
Key4 varchar(50)
TargetAssemblySeq int PORelNum int
Key5 varchar(50)
TargetMtlSeq int VendorChange tinyint
Key6 varchar(50)
Company varchar(8)
TGLCTranNum int
JobNum varchar(14)
AssemblySeq int
OprSeq int
OpDtlSeq int