SYSPRO 8 - SQL Updates by Release
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 |
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 |
None.
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 |
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 |
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 |