SYSPRO 8 - SQL Updates by Release

This topic outlines the table changes that have been made for each release of SYSPRO 8.

SYSPRO 8 2024

New Tables

Database	Table Name	Description	MAX Table
System	AdmPorEntity	Admin Portal Entity	X
System	AdmPorEntityCompid	Admin Portal Entity Allowed Companies	X
System	AdmPorEntityCusSup	Admin Portal Entity Customer Supplier	X
System	AdmPorEntityPages	Admin Portal Entity Landing Pages	X
Company	ApNextKeyAudit	AP Next Key Audit
Company	ApNextKeys	AP Next Keys
Company	EftBankExtra	EFT Bank Extra Payment Details
Company	EftPayFormat	EFT Payment Format
Company	EftPayFormatDet	EFT Payment Format Details
Company	GenDimensionApport	GL Dimension Apportion
Company	GenDimensionBud	GL Dimension Budgets
Company	GenDimensionEntity	GL Dimension Entities
Company	GenDimensionSplit	GL Dimension Split
Company	InvPorQtyBal	Inventory To Purchase Quantity Balance	X
Company	InvPorQtyBalFix	Inventory To Purchase Quantity Balance Fix	X
Company	InvStockTakeLpn	Inventory Stock Take LPN
Company	SorDetailLpn	Sales Order Detail Line LPN
Company	SorMasterDocument	Sales Order Documents	X
Company	SorPriceCatPromo	SO Pricing Engine Catalog Promotions
Company	SqmArcNcAction	Non Conformance Archived Actions
Company	SqmArcNcReport	Non Conformance Archived Control
Company	SqmArcNcTran	Non Conformance Archived Transaction
Company	SqmCategory	Non Conformance Cause Category
Company	SqmNcActions	Non Conformance Actions
Company	SqmNcDepartment	Non Conformance Department
Company	SqmNcDoc	Non Conformance Document	X
Company	SqmNcNarration	Non Conformance Narrations Detail
Company	SqmNcPlan	Non Conformance Plan
Company	SqmNcReport	Non Conformance Control
Company	SqmNcStandard	Non Conformance Standard
Company	SqmNcStatus	Non Conformance Status
Company	SqmNcTrans	Non Conformance Transaction
Company	SqmNcType	Non Conformance Type
Company	SqmNextKeyAudit	Quality Management Next Key Audit
Company	SqmNextKeys	Quality Management Next Keys
Company	SqmProcess	Non Conformance Process
Company	SqmProsDoc	Non Conformance Process Document	X
Company	SqmSevLevel	Non Conformance Severity Level
Company	SqmStakeholder	Non Conformance Stakeholders
Company	SqmStanDoc	Non Conformance Standard Document	X
Company	SqmStanProcess	Non Conformance Process Per Standard
Company	SqmTrigger	Non Conformance Trigger
Company	TblCurrDatedRates	Admin Currency Dated Exchange Rates
Company	WhmContainerHist	WMS Container History
Company	WhmContainerType	WMS Container Type
Company	WhmLpnDetail	WMS LPN Detail
Company	WhmLpnHeader	WMS LPN Header
Company	WhmLpnMovements	WMS LPN Movements
Company	WipAllMatLpn	WIP Allocation LPN

New Columns

Database	Table Name	Table Data Type	Column Name	Description
Company	AdmCompanyDetails	char(1)	InstalledEfi	EFT Interface
Company	AdmCompanyDetails	char(1)	ProductionCompany	Production company
System	AdmOperator	char(1)	RunTimeIntegration	Run time integration
System	AdmOperator	char(1)	EntityType	Portal entity type
System	AdmOperator	varchar(20)	Entity	Supply chain portal entity
System	AdmOperator	decimal(1,0)	ApprovedStatus	Portal user approval state
System	AdmOperator	varchar(50)	RejectReason	Reason
Company	AdmRtpProduct	char(1)	RunTimeLinkedOper	Run time linked operators
Company	ApInvoiceReval	datetime	EffectiveDate	Effective date
Company	ApInvoiceReval	decimal(10,0)	EffectiveEntry	Effective date entry number
Company	ApJnlSummary	datetime	EffectiveDate	Effective date
Company	ApJnlSummary	decimal(10,0)	EffectiveEntry	Effective date entry number
Company	ApPayRunDet	char(1)	InvPayMulDiv	Multiply or divide
Company	ApPayRunHdr	char(1)	UseOriginalPayRate	Apply invoice payment rate
Company	ApPayRunHdr	char(1)	CdbApply	Apply dated ex rate
Company	ApPayRunHdr	datetime	CdbDate	Payment date
Company	ApPayRunHdr	decimal(12,6)	CdbRate	Exchange rate
Company	ApPayRunHdr	char(1)	CdbMulDiv	Multiply or divide
Company	ArCshJnlDet	datetime	EffectiveDate	Effective date
Company	ArCshJnlDet	decimal(10,0)	EffectiveEntry	Effective date entry number
Company	ArCshJnlDet	decimal(12,6)	BankRate	Conversion rate of bank
Company	ArCshJnlDet	char(1)	BankMulDiv	Multiply or divide.
Company	ArCustomer	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	ArCustomer	char(1)	ElectInvPrint	E-invoice print option
Company	ArCustomer	char(1)	ElectInvRequired	E-invoicing required
Company	ArCustomer	decimal(2,0)	DateFormat	Date format
Company	ArCustomer	decimal(1,0)	DecimalFormat	Decimal format
Company	ArInvoice	char(1)	ElectInvStatus	E-invoice status
Company	ArInvoiceReval	datetime	EffectiveDate	Effective date
Company	ArInvoiceReval	decimal(10,0)	EffectiveEntry	Effective date entry number
Company	ArTrnDetail	varchar(20)	Catalogue	Catalog
Company	ArTrnDetail	decimal(4,0)	CatLineNumber	Catalog line number
Company	CshJnl	datetime	EffectiveDate	Effective date
Company	CshJnl	decimal(10,0)	EffectiveEntry	Effective date entry number
Company	EamServiceGl	varchar(100)	ServiceNotes	Service notes
Company	EftApSupplier	char(2)	EftTrnCode	EFT Transaction Code
Company	EftApSupplier	varchar(9)	EftRoutingNo	Originator’s bank routing
Company	EftApSupplier	varchar(15)	EftAlternateId	Receivers identification
Company	EftApSupplier	char(3)	EftSupplierBankNo	Beneficiary's bank number
Company	EftBankCtl	varchar(10)	FormatCode	EFT Format code
Company	EftBankCtl	varchar(50)	CompanyName	Company
Company	EftBankCtl	varchar(30)	PayFileName	EFT Pay file name
Company	EftBankCtl	char(1)	PayLocation	Client or Server directory
Company	EftBankCtl	varchar(255)	PayDirectory	EFT Payment file directory
Company	EftBatchCtl	char(1)	EftPayLocation	Client or Server directory
Company	EftBatchCtl	varchar(255)	EftPayFile	Path and name of conversion
Company	EftBatchCtl	char(1)	EftFileId	Identifier if multiple input files
Company	EftCshSupplier	char(2)	EftTrnCode	EFT Transaction Code
Company	EftCshSupplier	varchar(9)	EftRoutingNo	Originator’s bank routing number
Company	GenDimensionCode	char(1)	TemplateFlag	Template
Company	GenDimensionDet	decimal(18,6)	DispatchedQty	Quantity dispatched
Company	GenDimensionDet	char(1)	EntityFor	Entity For
Company	GenDimensionDet	decimal(4,0)	OrderLine	Order line number
Company	GenDimensionDet	varchar(20)	OrderNumber	Order number
Company	GenDimensionDet	decimal(18,6)	OrderQty	Quantity ordered
Company	GenDimensionDet	decimal(18,6)	ReceivedQty	Quantity received
Company	GenDimensionDet	decimal(18,6)	ShipQty	Quantity to ship
Company	GenHistCur	decimal(8,0)	TimeRateChange	Time of rate change
Company	GenRecJnlDet	decimal(10,0)	DimensionEntry	Dimension entry number
Company	InvMaster	char(1)	LotExpiryOption	Check expired lots based on
Company	InvMaster	char(1)	SerExpiryOption	Check expired serials based on
Company	InvMaster	varchar(20)	DefaultContainer	Default container code
Company	MdnDetail	varchar(20)	Catalogue	Catalog
Company	MdnDetail	decimal(4,0)	CatLineNumber	Catalog line number
Company	MdnDetailCons	varchar(20)	Catalogue	Catalog
Company	MdnDetailCons	decimal(4,0)	CatLineNumber	Catalog line number
Company	MdnDetailRep	varchar(20)	Catalogue	Catalog
Company	MdnDetailRep	decimal(4,0)	CatLineNumber	Catalog line number
Company	MdnDetailRepCon	varchar(20)	Catalogue	Catalog
Company	MdnDetailRepCon	decimal(4,0)	CatLineNumber	Catalog line number
Company	MdnMaster	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	MdnMaster	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	MdnMaster	char(1)	GstExemptFlag	Canadian GST
Company	MdnMaster	varchar(15)	GstExemptNum	GST exemption number
Company	MdnMaster	char(1)	GstExemptORide	Canadian GST override
Company	MdnMasterCons	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	MdnMasterCons	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	MdnMasterCons	char(1)	ElectInvPrinted	E-invoice printed
Company	MdnMasterCons	char(1)	ElectInvStatus	E-invoice status
Company	MdnMasterCons	char(1)	EntityDimensions	Entity status
Company	MdnMasterRep	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	MdnMasterRep	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	MdnMasterRep	char(1)	ElectInvPrinted	E-invoice printed
Company	MdnMasterRep	char(1)	ElectInvStatus	E-invoice status
Company	MdnMasterRep	char(1)	EntityDimensions	Entity status
Company	MdnMasterRep	char(1)	GstExemptFlag	Canadian GST
Company	MdnMasterRep	varchar(15)	GstExemptNum	GST exemption number
Company	MdnMasterRep	char(1)	GstExemptORide	Canadian GST override
Company	MdnMasterRepCon	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	MdnMasterRepCon	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	MdnMasterRepCon	char(1)	ElectInvPrinted	E-invoice printed
Company	MdnMasterRepCon	char(1)	ElectInvStatus	E-invoice status
Company	MdnMasterRepCon	char(1)	EntityDimensions	Entity status
Company	MrpPoMasterHdr	char(1)	EntityDimensions	Entity status
Company	MrpQotOffer	varchar(20)	Catalogue	Catalog
Company	MrpQotOffer	decimal(4,0)	CatLineNumber	Catalog line number
Company	MrpQotSoDetail	varchar(20)	Catalogue	Catalog
Company	MrpQotSoDetail	decimal(4,0)	CatLineNumber	Catalog line number
Company	MrpQotSoMasterHdr	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	MrpQotSoMasterHdr	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	MrpQotSoMasterHdr	char(1)	EntityDimensions	Entity status
Company	MrpSoDetail	varchar(20)	Catalogue	Catalog
Company	MrpSoDetail	decimal(4,0)	CatLineNumber	Catalog line number
Company	MrpSoMasterHdr	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	MrpSoMasterHdr	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	MrpSoMasterHdr	char(1)	EntityDimensions	Entity status
Company	PorMasterHdr	char(1)	EntityDimensions	Entity status
Company	QotOffer	varchar(20)	Catalogue	Catalog
Company	QotOffer	decimal(4,0)	CatLineNumber	Catalog line number
Company	QotSoMasterHdr	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	QotSoMasterHdr	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	QotSoMasterHdr	char(1)	EntityDimensions	Entity status
Company	RtsJournal	decimal(10,0)	DimensionEntry	Dimension entry number
Company	SalHistorySource	varchar(20)	Catalogue	Catalog
Company	SalHistorySource	decimal(4,0)	CatLineNumber	Catalog line number
Company	SorArcDetail	varchar(20)	Catalogue	Catalog
Company	SorArcDetail	decimal(4,0)	CatLineNumber	Catalog line number
Company	SorArcMaster	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	SorArcMaster	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	SorArcMaster	char(1)	EntityDimensions	Entity status
Company	SorDetail	varchar(20)	Catalogue	Catalog
Company	SorDetail	decimal(4,0)	CatLineNumber	Catalog line number
Company	SorDetailRep	varchar(20)	Catalogue	Catalog
Company	SorDetailRep	decimal(4,0)	CatLineNumber	Catalog line number
Company	SorMaster	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	SorMaster	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	SorMaster	char(1)	EntityDimensions	Entity status
Company	SorMasterRep	char(1)	IncludeInMrp	Include order in MRP
Company	SorMasterRep	char(1)	User1	User field 1
Company	SorMasterRep	varchar(20)	LastOpInvPrt	Last operator to generate invoice
Company	SorMasterRep	char(1)	DispatchWholeSo	Dispatch whole sales orders
Company	SorMasterRep	char(1)	ElectInvPrinted	E-invoice printed
Company	SorMasterRep	char(1)	ElectInvStatus	E-invoice status
Company	SorMasterRep	char(1)	EntityDimensions	Entity status
Company	SorPriceCatDetail	decimal(5,2)	DiscPct1	Discount percentage 1
Company	SorPriceCatDetail	decimal(5,2)	DiscPct2	Discount percentage 2
Company	SorPriceCatDetail	decimal(5,2)	DiscPct3	Discount percentage 3
Company	SorPriceCatDetail	decimal(15,5)	GrossPrice	Gross price
Company	SorPriceCatDetail	decimal(6,3)	MarkUpPct	Mark-up percentage
Company	SorPriceCatDetail	decimal(14,2)	DiscValue	Discount value
Company	SorQuoteDet	varchar(20)	Catalogue	Catalog
Company	SorQuoteDet	decimal(4,0)	CatLineNumber	Catalog line number
Company	TblCurAmendmentJnl	datetime	EffectiveDate	Effective date
Company	TblCurAmendmentJnl	decimal(10,0)	EffectiveEntry	Entry number
Company	TblCurAmendmentJnl	char(1)	CurrencyRateType	Currency rate type
Company	TblCurrency	char(1)	CdbRateBasedOn	Dated ex rate based on
Company	TblCurrency	char(1)	CdbToleranceInd	Dated ex rate tolerance
Company	TblCurrency	decimal(14,2)	CdbTolerance	Dated ex rate maximum tolerance
Company	TblCurrency	datetime	EffDateRateChgBuy	Effective date last buying rate
Company	TblCurrency	decimal(10,0)	EffEntRateChgBuy	Effective date entry last buy rate
Company	TblCurrency	datetime	EffDateRateChgSell	Effective date last selling rate
Company	TblCurrency	decimal(10,0)	EffEntRateChgSell	Effective date entry last sell rate
Company	TpmJournal	decimal(10,0)	DimensionEntry	Dimension entry number
Company	WhmPickDetail	char(1)	FullContainer	Full container to pick
Company	WhmPickDetail	varchar(15)	LicensePlateNumber	License plate number

Column Changes

Table Name	Column	Change
AdmFormControl	ColumnName	Increased in size from 18 to 30
AdmFormControl	TableName	Increased in size from 18 to 30
AdmJobLoggingDet	DatabaseTable	Increased in size from 18 to 30
AdmOperAmendJnl	ColumnName	Increased in size from 18 to 30
AdmSignatureCon	ConditionCol1	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol10	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol11	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol12	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol13	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol14	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol15	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol16	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol17	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol18	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol19	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol2	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol20	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol21	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol22	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol23	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol24	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol25	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol26	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol27	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol28	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol29	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol3	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol30	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol4	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol5	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol6	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol7	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol8	Increased in size from 37 to 61
AdmSignatureCon	ConditionCol9	Increased in size from 37 to 61
AdmSignatureCon	ConditionParam1	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam10	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam11	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam12	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam13	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam14	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam15	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam16	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam17	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam18	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam19	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam2	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam20	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam21	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam22	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam23	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam24	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam25	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam26	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam27	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam28	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam29	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam3	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam30	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam4	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam5	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam6	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam7	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam8	Increased in size from 50 to 61
AdmSignatureCon	ConditionParam9	Increased in size from 50 to 61
AdmSignatureLog	TableName	Increased in size from 18 to 30
AdmViewAudit	ViewName	Increased in size from 18 to 30
AdmViewColumns	ColumnAlias	Increased in size from 18 to 30
AdmViewColumns	ColumnName	Increased in size from 18 to 30
AdmViewColumns	ViewName	Increased in size from 18 to 30
AdmViewColumnsPub	ColumnAlias	Increased in size from 18 to 30
AdmViewColumnsPub	ColumnName	Increased in size from 18 to 30
AdmViewColumnsPub	ViewName	Increased in size from 18 to 30
AdmViewMaster	PrimaryDataSource	Increased in size from 19 to 30
AdmViewMaster	ViewName	Increased in size from 18 to 30
AdmViewMasterPub	PrimaryDataSource	Increased in size from 19 to 30
AdmViewMasterPub	ViewName	Increased in size from 18 to 30
AdmViewTables	DataSource	Increased in size from 19 to 30
AdmViewTables	DataSourceAlias	Increased in size from 19 to 30
AdmViewTables	ViewName	Increased in size from 18 to 30
AdmViewTablesPub	DataSource	Increased in size from 19 to 30
AdmViewTablesPub	DataSourceAlias	Increased in size from 19 to 30
AdmViewTablesPub	ViewName	Increased in size from 18 to 30
DdsApiAccess	ColumnName	Increased in size from 18 to 30
DdsApiAccess	TableName	Increased in size from 18 to 30
DdsColumns	ColumnName	Increased in size from 18 to 30
DdsColumns	ColumnNameUpper	Increased in size from 18 to 30
DdsColumns	TableName	Increased in size from 18 to 30
DdsColumnValues	ColumnName	Increased in size from 18 to 30
DdsColumnValues	TableName	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc1	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc10	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc11	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc12	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc13	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc14	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc15	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc16	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc17	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc18	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc19	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc2	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc20	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc3	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc4	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc5	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc6	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc7	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc8	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameSrc9	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt1	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt10	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt11	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt12	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt13	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt14	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt15	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt16	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt17	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt18	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt19	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt2	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt20	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt3	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt4	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt5	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt6	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt7	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt8	Increased in size from 18 to 30
DdsForeignKeys	ColumnNameTgt9	Increased in size from 18 to 30
DdsForeignKeys	TableName	Increased in size from 18 to 30
DdsForeignKeys	TargetTableName	Increased in size from 18 to 30
DdsIndexes	ColumnName	Increased in size from 18 to 30
DdsIndexes	IndexName	Increased in size from 30 to 50
DdsIndexes	TableName	Increased in size from 18 to 30
DdsTables	MasterTable	Increased in size from 18 to 30
DdsTables	TableName	Increased in size from 18 to 30
DdsTables	TableNameUpper	Increased in size from 18 to 30
DdsUserColumns	ColumnName	Increased in size from 18 to 30
DdsUserColumns	TableName	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc1	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc10	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc11	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc12	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc13	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc14	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc15	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc16	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc17	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc18	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc19	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc2	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc20	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc3	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc4	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc5	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc6	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc7	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc8	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameSrc9	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt1	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt10	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt11	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt12	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt13	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt14	Increased in size from 18 to 30
DdsUserForeignKey	ColumNameTgt15	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt16	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt17	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt18	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt19	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt2	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt20	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt3	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt4	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt5	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt6	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt7	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt8	Increased in size from 18 to 30
DdsUserForeignKey	ColumnNameTgt9	Increased in size from 18 to 30
DdsUserForeignKey	TableName	Increased in size from 18 to 30
DdsUserForeignKey	TargetTableName	Increased in size from 18 to 30
DdsUserIndexes	ColumnName	Increased in size from 18 to 30
DdsUserIndexes	IndexName	Increased in size from 30 to 50
DdsUserIndexes	TableName	Increased in size from 18 to 30
DdsUserTables	TableName	Increased in size from 18 to 30
DefnSignature	TableName	Increased in size from 18 to 30
EspBarcode	BarcodeColumn	Increased in size from 18 to 30
EspBarcode	TableName	Increased in size from 18 to 30
EspKeyField	TableName	Increased in size from 18 to 30
EspSearchCriteria	ColumnName	Increased in size from 18 to 30
EspSearchCriteria	TableName	Increased in size from 18 to 30
GenDimensionDef	TableName	Increased in size from 18 to 30
GenDimensionPri	ColumnName	Increased in size from 18 to 30
InvClassAttribCtl	TableName	Increased in size from 18 to 30
RepColumn	ColumnName	Increased in size from 18 to 30
RepColumn	ColumnNameUpper	Increased in size from 18 to 30
RepColumn	TableName	Increased in size from 18 to 30
RepKeys	ColumnName	Increased in size from 18 to 30
RepKeys	TableName	Increased in size from 18 to 30
RepLink	ColumnNameSrc1	Increased in size from 18 to 30
RepLink	ColumnNameSrc10	Increased in size from 18 to 30
RepLink	ColumnNameSrc2	Increased in size from 18 to 30
RepLink	ColumnNameSrc3	Increased in size from 18 to 30
RepLink	ColumnNameSrc4	Increased in size from 18 to 30
RepLink	ColumnNameSrc5	Increased in size from 18 to 30
RepLink	ColumnNameSrc6	Increased in size from 18 to 30
RepLink	ColumnNameSrc7	Increased in size from 18 to 30
RepLink	ColumnNameSrc8	Increased in size from 18 to 30
RepLink	ColumnNameSrc9	Increased in size from 18 to 30
RepLink	ColumnNameTgt1	Increased in size from 18 to 30
RepLink	ColumnNameTgt10	Increased in size from 18 to 30
RepLink	ColumnNameTgt2	Increased in size from 18 to 30
RepLink	ColumnNameTgt3	Increased in size from 18 to 30
RepLink	ColumnNameTgt4	Increased in size from 18 to 30
RepLink	ColumnNameTgt5	Increased in size from 18 to 30
RepLink	ColumnNameTgt6	Increased in size from 18 to 30
RepLink	ColumnNameTgt7	Increased in size from 18 to 30
RepLink	ColumnNameTgt8	Increased in size from 18 to 30
RepLink	ColumnNameTgt9	Increased in size from 18 to 30
RepLink	TableName	Increased in size from 18 to 30
RepLink	TargetTableName	Increased in size from 18 to 30
RepTable	SqlTableName	Increased in size from 18 to 30
RepTable	TableName	Increased in size from 18 to 30
RepTable	TableNameUpper	Increased in size from 18 to 30
WipJobAmendJnl	TableName	Increased in size from 18 to 30

SYSPRO 8 2023

New Tables

Table Name	Description	MAX Table	Database
AdmLicenseDetail	Admin Consumption Based License Detail	X	System
AdmDataApiAmendJnl	Admin Data API Amendment Journal	X	Company
AdmSsoAttributes	Admin SSO Identity Provider Attributes	X	System
AdmSsoProviders	Admin SSO Identity Providers	X	System
AdmSsoUserXref	Admin SSO User Cross Reference	X	System
ApInvoiceDocument	AP Supplier Invoice Document	X	Company
CshNextKeyAudit	Cashbook Next Key Audit	X	Company
CshNextKeys	Cashbook Next Keys	X	Company
DdsApiAccess	Data Dictionary Data Access Security	X	System
DdsUserColumns	Data Dictionary User Columns		System
DdsUserForeignKey	Data Dictionary User Foreign Key Links		System
DdsUserIndexes	Data Dictionary User Defined Indexes		System
DdsUserTables	Data Dictionary User Tables		System
EamAmendmentJnl	EAM Structure Amendment Journal		Company
EamEquipReg	EAM Equipment Code		Company
EamEquipType	EAM Equipment Type		Company
EamOperations	EAM Maintenance Operations		Company
EamOpsAmendJnl	EAM Operations Amendment Journal		Company
EamSchedule	EAM Schedule		Company
EamServiceGl	EAM Service Ledger Codes		Company
EamServiceType	EAM Service Type Master		Company
EamStructure	EAM Maintenance Structure		Company
GenDimensionExtCat	GL Dimension Extracted Categories		Company
EamOperations	Sales Order Next Key Audit		Company
SorNextKeys	Sales Order Next Keys		Company
SorPriceCatDetail	SO Pricing Engine Catalog Details		Company
SorPriceCatHeader	SO Pricing Engine Catalog		Company
SorPriceCatSel	Sales Order Pricing Catalog Selection	X	Company
WhmOuterDetail	WMS Packing Outer Detail		Company
WhmOuterHeader	WMS Packing Outer Header		Company
WipAllMatBin	WIP Booked Bins For Allocations		Company

New Columns

Table Name	Column Name	Description	Data Type	Database
AdmCompanyDetails	CustomerId	Customer id	varchar(20)	Company
AdmCompanyDetails	SrsClientServer	SRS Client or Server flag	char(1)	Company
AdmOperator	OperatorSsoStatus	SSO with provider status:	char(1)	System
AdmPrograms	SetupFileCode	File code being maintained	varchar(6)	System
AdmCurrentUsers	AuthType	Authentication type	char(1)	System
AdmCurrentUsers	SsoProviderDesc	SSO Identity provider desc	varchar(100)	System
AdmCurrentUsers	SsoProviderName	SSO Identity provider name	varchar(50)	System
ArCustomer	PickMarshalling	Pick marshalling	char(1)	Company
BomArcOperations	ProductionBin	Production bin	varchar(20)	Inventory
BomOperations	ProductionBin	Production bin	varchar(20)	Inventory
DdsForeignKeys	FkeyName	Name if user defined	varchar(128)	System
DdsIndexes	Direction	Ascending or descending	char(1)	System
DdsIndexes	IncludeColumn	Column is part of INCLUDE	char(1)	System
EccOperations	ProductionBin	Production bin	varchar(20)	Inventory
GenDimensionEnt	GlIntYear	GL year	decimal(4,0)	Ledger
GenDimensionEnt	GlIntPeriod	GL period number	decimal(2,0)	Ledger
GenDimensionEnt	GlJournal	Journal number	decimal(10,0)	Ledger
GenDimensionDet	ExtractOperator	Last extracted by operator	varchar(20)	Ledger
GenDimensionDet	ExtractDateTime	Last extract run date and time	datetime	Ledger
GenDimensionDet	ExtractStatus	Extract Status	char(1)	Ledger
GenDimensionCat	CategoryKey	Category key	decimal(10,0)	Ledger
GenDimensionSrc	BusinessProcess11	Type of business process 11	char(3)	Ledger
GenDimensionSrc	BusinessProcess12	Type of business process 12	char(3)	Ledger
GenDimensionSrc	BusinessProcess13	Type of business process 13	char(3)	Ledger
GenDimensionSrc	BusinessProcess14	Type of business process 14	char(3)	Ledger
GenDimensionSrc	BusinessProcess15	Type of business process 15	char(3)	Ledger
GenDimensionSrc	BusinessProcess16	Type of business process 16	char(3)	Ledger
GenDimensionSrc	BusinessProcess17	Type of business process 17	char(3)	Ledger
GenDimensionSrc	BusinessProcess18	Type of business process 18	char(3)	Ledger
GenDimensionSrc	BusinessProcess19	Type of business process 19	char(3)	Ledger
GenDimensionSrc	BusinessProcess20	Type of business process 20	char(3)	Ledger
GenDimensionSrc	BusinessProcess21	Type of business process 21	char(3)	Ledger
GenDimensionSrc	BusinessProcess22	Type of business process 22	char(3)	Ledger
GenDimensionSrc	BusinessProcess23	Type of business process 23	char(3)	Ledger
GenDimensionSrc	BusinessProcess24	Type of business process 24	char(3)	Ledger
GenDimensionSrc	BusinessProcess25	Type of business process 25	char(3)	Ledger
GenDimensionSrc	BusinessProcess26	Type of business process 26	char(3)	Ledger
GenDimensionSrc	BusinessProcess27	Type of business process 27	char(3)	Ledger
GenDimensionSrc	BusinessProcess28	Type of business process 28	char(3)	Ledger
GenDimensionSrc	BusinessProcess29	Type of business process 29	char(3)	Ledger
GenDimensionSrc	BusinessProcess30	Type of business process 30	char(3)	Ledger
GenDimensionSrc	BusinessProcess31	Type of business process 31	char(3)	Ledger
GenDimensionSrc	BusinessProcess32	Type of business process 32	char(3)	Ledger
GenDimensionSrc	BusinessProcess33	Type of business process 33	char(3)	Ledger
GenDimensionSrc	BusinessProcess34	Type of business process 34	char(3)	Ledger
GenDimensionSrc	BusinessProcess35	Type of business process 35	char(3)	Ledger
GenDimensionSrc	BusinessProcess36	Type of business process 36	char(3)	Ledger
GenDimensionSrc	BusinessProcess37	Type of business process 37	char(3)	Ledger
GenDimensionSrc	BusinessProcess38	Type of business process 38	char(3)	Ledger
GenDimensionSrc	BusinessProcess39	Type of business process 39	char(3)	Ledger
GenDimensionSrc	BusinessProcess40	Type of business process 40	char(3)	Ledger
GenDimensionSrc	SourceModule11	Module name 11	char(3)	Ledger
GenDimensionSrc	SourceModule12	Module name 12	char(3)	Ledger
GenDimensionSrc	SourceModule13	Module name 13	char(3)	Ledger
GenDimensionSrc	SourceModule14	Module name 14	char(3)	Ledger
GenDimensionSrc	SourceModule15	Module name 15	char(3)	Ledger
GenDimensionSrc	SourceModule16	Module name 16	char(3)	Ledger
GenDimensionSrc	SourceModule17	Module name 17	char(3)	Ledger
GenDimensionSrc	SourceModule18	Module name 18	char(3)	Ledger
GenDimensionSrc	SourceModule19	Module name 19	char(3)	Ledger
GenDimensionSrc	SourceModule20	Module name 20	char(3)	Ledger
GenDimensionSrc	SourceModule21	Module name 21	char(3)	Ledger
GenDimensionSrc	SourceModule22	Module name 22	char(3)	Ledger
GenDimensionSrc	SourceModule23	Module name 23	char(3)	Ledger
GenDimensionSrc	SourceModule24	Module name 24	char(3)	Ledger
GenDimensionSrc	SourceModule25	Module name 25	char(3)	Ledger
GenDimensionSrc	SourceModule26	Module name 26	char(3)	Ledger
GenDimensionSrc	SourceModule27	Module name 27	char(3)	Ledger
GenDimensionSrc	SourceModule28	Module name 28	char(3)	Ledger
GenDimensionSrc	SourceModule29	Module name 29	char(3)	Ledger
GenDimensionSrc	SourceModule30	Module name 30	char(3)	Ledger
GenDimensionSrc	SourceModule31	Module name 31	char(3)	Ledger
GenDimensionSrc	SourceModule32	Module name 32	char(3)	Ledger
GenDimensionSrc	SourceModule33	Module name 33	char(3)	Ledger
GenDimensionSrc	SourceModule34	Module name 34	char(3)	Ledger
GenDimensionSrc	SourceModule35	Module name 35	char(3)	Ledger
GenDimensionSrc	SourceModule36	Module name 36	char(3)	Ledger
GenDimensionSrc	SourceModule37	Module name 37	char(3)	Ledger
GenDimensionSrc	SourceModule38	Module name 38	char(3)	Ledger
GenDimensionSrc	SourceModule39	Module name 39	char(3)	Ledger
GenDimensionSrc	SourceModule40	Module name 40	char(3)	Ledger
InvSerialTrn	SalesOrderLine	Sales order line number	decimal(4,0)	Inventory
InvSerialTrn	DispatchNoteLine	Dispatch note line number	decimal(4,0)	Inventory
InvWhControl	UseWipPicking	Use WIP picking in wh	char(1)	Inventory
InvWhControl	AutoIssuePick	Issue material to job after pick	char(1)	Inventory
InvWhControl	MaintWarehouse	Maintenance warehouse	char(1)	Inventory
InvWhControl	PickConfirmation	Pick confirmation	char(1)	Inventory
InvWhControl	PickMarshalling	Pick marshalling	char(1)	Inventory
InvWarehouse	ProductionBin	Production bin	varchar(20)	Inventory
MrpJobMaster	MaintJob	Maintenance job	char(1)	Company
MrpJobMaster	MaintJobType	Maintenance job type	char(1)	Company
MrpJobMaster