SYSPRO 8 - SQL Updates by Release
SYSPRO 8 2021 R2
New Tables
| Table Name | Description | Database |
|---|---|---|
|
N/A This sequential file is retained on the file system and not in SQL. The data file for this is IMPGEB.IMP. |
Admin GL Entity Backed (IMPGEB.IMP) |
{Sequential} |
|
AdminUsageData |
Admin Usage Data |
System |
|
AdmPorUserRole |
Admin Portal User Role Definition |
System |
|
AdmTileAudit |
Admin Insight Tile Definition Audit |
System |
|
AdmTileDefinition |
Admin Insight Tile Definition |
System |
|
AdmViewAudit |
Admin Business View Audit |
System |
|
AdmViewColumns |
Admin Business View Columns |
System |
|
AdmViewColumnsPub |
Admin Published Business View Columns |
System |
|
AdmViewMaster |
Admin Business View Master |
System |
|
AdmViewMasterPub |
Admin Published Business View Master |
System |
|
AdmViewTables |
Admin Business View Tables |
System |
|
AdmViewTablesPub |
Admin Published Business View Tables |
System |
|
BomProdLine |
BOM Production Line |
Company |
|
BomShiftAll |
BOM Shift Allocation |
Company |
|
BomShiftDet |
BOM Shift Detail |
Company |
|
BomShiftEmp |
BOM Shift Employee |
Company |
|
BomShiftHdr |
BOM Shift Header |
Company |
|
BomShiftTeam |
BOM Shift Team |
Company |
|
BomSiteCode |
BOM Site Code |
Company |
|
GenDimensionCat |
GL Dimension Categories |
Company |
|
GenDimensionCode |
GL Dimension code |
Company |
|
GenDimensionDef |
GL Default dimension |
Company |
|
GenDimensionSrc |
GL Dimension Source |
Company |
|
GenNextKeyAudit |
GL Next Key Audit |
Company |
|
GenNextKeys |
GL Next Keys |
Company |
|
InvNextKeyAudit |
Inventory Next Key Audit |
Company |
|
InvNextKeys |
Inventory Next Keys |
Company |
|
SrsDocPrinterExc |
SRS Document Printer Exceptions |
System |
|
SwsMessagesExt |
Workflow Messages Extended |
Company |
|
SysMenu |
SYSPRO Menu Settings |
System |
|
SysRoles |
SYSPRO Role Settings |
System |
|
WipInspectBal |
Wip Inspection Balances |
Company |
New Columns
| Table Name | Column Name | Description |
|---|---|---|
|
AdmCompanyDetails |
InstalledOdata |
OData connected service |
|
AdmOperator |
Employee |
Employee |
| AdmOperator |
OdataAccount |
OData account flag |
|
ApPayRunHdr |
IntByBo |
AP to CB Integration performed by APSTCI |
| ApPayRunHdr |
RegPrinted |
Check register printed |
|
BomMachine |
ProdLine |
Production Line |
| BomMachine |
ShiftCode |
Shift code |
|
BomWorkCentre |
SiteCode |
Site code |
| BomWorkCentre |
ShiftCode |
Shift code |
|
InvCycleCountBin |
ConfirmedFlag |
Bin has been confirmed |
|
InvCycleCountLot |
ConfirmedFlag |
Lot has been confirmed |
|
InvCycleCountSer |
ConfirmedFlag |
Serial has been confirmed |
|
InvWhControl |
SiteCode |
Site code |
| InvWhControl |
ShiftCode |
Shift code |
|
MdnDetailCons |
PriceGroupRule |
Price Group Rule |
|
MdnDetail |
PriceGroupRule |
Price Group Rule |
|
MdnDetailRepCon |
PriceGroupRule |
Price Group Rule |
|
MdnDetailRep |
PriceGroupRule |
Price Group Rule |
|
SorDetailRep |
PriceGroupRule |
Price Group Rule |
|
WhmMissionTasks |
ToWarehouse |
To warehouse |
| WhmMissionTasks |
ToBin |
To bin |
|
WhmMissionTasks |
PutAwayQty |
Put-away quantity |
|
WhmMissionTasks |
QtyUnitOfMeasure |
Quantity unit of measure |
|
WhmMissionTasks |
XmlIn |
Put-away XML in |
|
WhmMissionTasks |
Lot |
Lot |
|
WhmMissionTasks |
Serial |
Serial |
New Indexes and Keys
| Table Name | Index Name | Columns |
|---|---|---|
|
ApGlDisburse |
ApGlDisburseIdxSta |
ChequeRegister |
|
|
|
DistrEntry |
|
|
|
EntryStatus |
|
|
|
GlCode |
|
|
|
GlPeriod |
|
|
|
GlYear |
|
|
|
Supplier |
|
ApJnlControl |
ApJnlControlIdxSta |
FinMonth |
|
|
|
FinYear |
|
|
|
Journal |
|
|
|
JournalStatus |
|
ApJnlSummary |
ApJnlSummaryIdxGiUpd |
EntryNumber |
|
|
|
GlIntPeriod |
|
|
|
GlIntUpdated |
|
|
|
GlIntYear |
|
|
|
GlJournal |
|
|
|
Journal |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
ArCshJnlCtl |
ArCshJnlCtlIdxRdep |
BankDepositPrt |
|
|
|
Journal |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
ArCshJnlCtl |
ArCshJnlCtlIdxStat |
Journal |
|
|
|
Status |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
ArCshJnlDet |
ArCshJnlDetIdxGiUpd |
EntryNumber |
|
|
|
GlIntUpdated |
|
|
|
Journal |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
ArTrnDetail |
ArTrnDetailIdxGiUpd |
DetailLine |
|
|
|
GlIntPeriod |
|
|
|
GlIntUpdated |
|
|
|
GlIntYear |
|
|
|
GlJournal |
|
|
|
Invoice |
|
|
|
Register |
|
|
|
SummaryLine |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
ArTrnDetail |
ArTrnDetailIdxHst |
DetailLine |
|
|
|
HistoryReqd |
|
|
|
Invoice |
|
|
|
Register |
|
|
|
SummaryLine |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
CshJnlCtl |
CshJnlCtlIdxPrt |
CbTrnMonth |
|
|
|
CbTrnYear |
|
|
|
Journal |
|
|
|
PrintedFlag |
|
CshJnlGl |
CshJnlGlIdxGlupd |
CbTrnMonth |
|
|
|
CbTrnYear |
|
|
|
EntryNumber |
|
|
|
GlUpdated |
|
|
|
Journal |
|
|
|
Line |
|
GrnJournal |
GrnJournalIdxGiUpd |
GlIntUpdated |
|
|
|
GrnJournal |
|
|
|
JournalEntry |
|
|
|
JournalMonth |
|
|
|
JournalYear |
|
InvJournalCtl |
InvJournalCtlIdxGiUpd |
GlIntUpdated |
|
|
|
Journal |
|
|
|
MonthPost |
|
|
|
YearPost |
|
InvJournalCtl |
InvJournalCtlIdxStat |
Journal |
|
|
|
MonthPost |
|
|
|
TrnType |
|
|
|
YearPost |
|
WipLabJnl |
WipLabJnlIdxGiUpd |
EntryNumber |
|
|
|
GlIntUpdated |
|
|
|
Journal |
|
|
|
TrnMonth |
|
|
|
TrnYear |
|
WipPartBill |
WipPartBillIdxPrt |
EntryNumber |
|
|
|
Job |
|
|
|
Journal |
|
|
|
JournalPrinted |
|
|
|
TrnMonth |
|
|
|
TrnYear |
SYSPRO 8 2021 R1
New Tables
| Table Name | Description |
|---|---|
|
AdmDiagBlackBox |
Admin System Diagnostic Black Box Info |
|
AdmDiagDetail |
Admin System Diagnostic Detail |
|
AdmDiagSummary |
Admin System Diagnostic Summary |
|
AdmProControl |
Admin List View and Form Captions |
|
AdmTaxCertXref |
Certcapture Cross Reference (Third Party |
|
AdmTaxFltrCountry |
Tax Country Filter (Third Party Tax) |
|
AdmTaxFltrPcls |
Tax Product Class Filter (Third Party) |
|
AdmTaxFltrUsState |
Tax Us State Filter (Third Party Tax) |
|
AdmTaxAuditLog |
Tax Submission Audit (Third Party Tax) |
|
AdmTaxNetGross |
Tax Base Net/Gross (Third Party Tax) |
|
AdmTaxZipRange |
Range Of Zip Codes (Third Party Tax) |
|
AdmUsaZipCodes |
USA Zip Codes |
|
ApGrpPayRunDet |
AP Group Payment Run Detail |
|
ApGrpPayRunSup |
AP Group Payment Run Supplier To Pay |
|
AssetHealthBal |
Asset Health Check Balances Check |
|
AssetHealthFix |
Asset Health Check Balances Fix |
|
SalPortAirport |
Port/Airport For Intrastat |
|
RegimeCode |
Regime Code For Intrastat |
|
SorPriceListDetail |
SO Pricing Engine Price List Detail |
|
SorPriceListHeader |
SO Pricing Engine Price List |
|
SorPriceDisc |
Sales Order Discounts By Group/Class |
|
SorPriceGroup |
SO Pricing Engine Price Group |
|
SorPriceGroupRules |
SO Pricing Engine Price Group Rules |
|
WhmMission |
WMS Missions |
|
WhmTeamEmployees |
WMS Team Employees |
|
WhmTeam |
WMS Team |
|
WhmMissionTasks |
Mission Tasks |
|
WipCopBal |
Wip Co-product Balances |
|
WipLabBal |
Wip Labor Balances |
|
WipMasBal |
Wip Master Balances |
|
WipMatBal |
Wip Material Balances |
|
WipResLotBal |
Wip Reserved Lot Balances |
New Columns
| Table Name | Column Name | Description |
|---|---|---|
|
AdmCompanyDetails |
InstalledBot | SYSPRO Ken the BOT |
| AdmCompanyDetails | InstalledTaxAva | Avalara tax connector |
| AdmCompanyDetails | InstalledTaxVer | Vertex tax connector |
|
AdmDiagDetail |
EnetSource | e.net source |
| AdmDiagDetail | SysproRelease | SYSPRO release |
| AdmDiagDetail | SysproCallStack | SYSPRO Call stack |
| AdmDiagDetail | RtsCallStack | RTS Call stack |
|
AdmDigitalTaxTemp |
Operator | Operator code |
|
AdmNotepad |
FileInSql | File is in the database |
|
AdmOperator |
ServiceAccount | Service account flag |
|
ApCheckIss |
GroupPayment | Group payment |
| GroupConvRate | Group exchange rate | |
| GroupPostMulDiv | Multiply or divide | |
|
ApSupplier |
PrimarySupplier | Primary supplier indicator |
|
ApInvoicePay |
GrpPayValue | Group payment amount |
| GrpPayCurrency | Group payment currency | |
| GrpPayConvRate | Group payment rate | |
| GrpPayPostMulDiv | Grp payment factor | |
| PrimarySupplier | Primary supplier (Grp pay) | |
|
ApPayRunHdr |
GroupPayCurrency | Group Payment currency |
| GroupConvRate | Group exchange rate | |
| GroupPostMulDiv | Multiply or divide | |
| GroupCheck | Group payment check no | |
| GrpCheckDate | Group payment check date | |
| XrefPaymentNumber | Void run number | |
|
ArCshJnlCtl |
GroupTotalAmount | Group payment total amount |
|
ArCustomer |
PrimaryCustomer | Primary customer indicator |
| PriceGroup | Price Group | |
|
CrmActivity |
FilesInSql | Body rtf and all |
|
AssetHealthBal |
SelfHealingFlag | Self healing flag |
|
AssetHealthFix |
SelfHealingFlag | Self healing flag |
|
CshApPayments |
GroupPayment | Group payment |
| GrpGrsValue | Gross payment value | |
| GrpNetValue | Net payment value | |
| GrpWithValue | Withholding tax value | |
| GrpDscValue | Discount value | |
| GrpCurrency | Payment currency | |
| GrpConvRate | Conversion rate of payment | |
| GrpPostMulDiv | Multiply or divide | |
|
InvMaster |
SuppUnitFactor | Supplementary units factor |
| SuppUnitsMulDiv | Supplementary units method | |
|
MdnDetailCons |
CommentSalesOrder | Sales order from which the dispatch comment is created |
|
MdnMasterCons |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
MdnDetail |
CommentSalesOrder | Sales order from which the dispatch comment is created |
|
MdnMaster |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
MdnDetailRepCon |
CommentSalesOrder | Sales order from which the dispatch comment is created |
|
MdnMasterRepCon |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
MdnDetailRep |
CommentSalesOrder | Sales order from which the dispatch comment is created |
|
MdnMasterRep |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
MrpJobMaster |
DifWipBranch | Different WIP Branch for Ops |
|
MrpPoMasterDet |
ServFlag | N - Not applicable |
|
MrpPoMasterHdr |
RegimeCode | Regime code |
| PortArrival | Port/Airport of arrival | |
|
MrpQotOffer |
PriceGroupRule | Price Group Rule |
|
MrpQotSoDetail |
PriceGroupRule | Price Group Rule |
|
MrpQotSoMasterHdr |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| MrpQotSoMasterHdr | PriceGroup | Price group |
| PriceGroupLevel | Price group level | |
|
MrpSugJobMaster |
DifWipBranch | Different WIP Branch for Ops |
|
MrpSoDetail |
PriceGroupRule | Price Group Rule |
|
MrpSoMasterHdr |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| MrpSoMasterHdr | PriceGroup | Price group |
| PriceGroupLevel | Price group level | |
|
QotOffer |
PriceGroupRule | Price Group Rule |
|
QotSoMasterHdr |
PriceGroup | Price group |
| PriceGroupLevel | Price group level | |
|
PorMasterDetail |
ServFlag | N - Not applicable |
|
PorEcReceipts |
TrnType | Transaction type |
| SupConvMulDiv | Supplementary unit factor | |
| SourceWarehouse | Source Warehouse code for SCT | |
| TargetWarehouse | Target Warehouse code for SCT | |
| Supplier | Supplier | |
|
PorMasterHdr |
RegimeCode | Regime code |
| PortArrival | Port/Airport of arrival | |
|
QotSoMasterHdr |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
|
SalEcSales |
IntrastatExempt | Intrastat exempt |
| RegimeCode | Regime code | |
| PortDispatch | Port/Airport of dispatch | |
| FrtMiscCost | Frt/Misc costs allocated to line | |
| IntrastatTranType | Intrastat transaction type | |
| SuppUnitFactor | Supplementary units factor | |
| SuppUnitsMulDiv | Supplementary units method | |
| SalesOrderLine | Originating sales order line | |
| DispatchNote | Originating dispatch note | |
| DispatchNoteLine | Originating DN line | |
|
SorArcDetail |
PriceGroupRule | Price Group Rule |
|
SorArcMaster |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
SorDetail |
PriceGroupRule | Price Group Rule |
|
SorMaster |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
SorQuoteDet |
PriceGroupRule | Price Group Rule |
|
SorQuote |
PriceGroup | Price group |
| PriceGroupLevel | Price group level | |
|
SorMasterRep |
RegimeCode | Regime code |
| PortDispatch | Port/Airport of dispatch | |
| PriceGroup | Price group | |
| PriceGroupLevel | Price group level | |
|
WipArcMaster |
DifWipBranch | Different WIP Branch for Ops |
|
WipMaster |
DifWipBranch | Different WIP Branch for Ops |
|
WhmPickDetail |
DestinationWhs | Destination warehouse |
| UnitOfMeasure | Unit of measure | |
| Version | Version | |
| Release | Release |
New Indexes and Keys
| Table Name | Index Name | Columns |
|---|---|---|
|
SalEcSales |
SalEcSalesIdxInv | Invoice |
| Nationality | ||
| CustVatRegnNum | ||
| TrnYear | ||
| InvoiceRegister | ||
| SummaryLine | ||
| InvoiceRegLine | ||
| SalEcSales | SalEcSalesIdxDat | TrnDate |
| Nationality | ||
| CustVatRegnNum | ||
| TrnYear | ||
| InvoiceRegister | ||
| SummaryLine | ||
| InvoiceRegLine | ||
| SalEcSales | SalEcSalesIdxCus | Customer |
| Nationality | ||
| CustVatRegnNum | ||
| TrnYear | ||
| InvoiceRegister | ||
| SummaryLine | ||
| InvoiceRegLine | ||
| SalEcSales | SalEcSalesIdxTariff | TariffCode |
| Nationality | ||
| CustVatRegnNum | ||
| TrnYear | ||
| InvoiceRegister | ||
| SummaryLine | ||
| InvoiceRegLine |
SYSPRO 8 2020 R2
New Tables
| Table Name | Description |
|---|---|
| AdmRtpProductAreas | Admin Run Time Product Functional Areas |
| AdmRtpProduct | Admin Run Time Products |
| AdmSamsCtl | Admin Sams Control |
| AdmSamsDetail | Admin Sams Extract Details |
| AdmSamsLog | Admin Sams Extract Log |
| AdmSamsSchedule | Admin Sams Extract Schedule |
| AdmNotepadData | Admin Generic Notepad Data |
| CrmActAttachData | Contact Activity Attachment Data |
| CrmActBodyData | Contact Activity Body RTF Document |
| CrmOrgListDefn | Organization List Definitions |
| MrpWipBranch | MRP Snapshot WIP Branch |
| SrsReportArchive | Syspro Reporting Service Archive |
| SrsDocuments | SRS Documents |
| SrsDocHistory | SRS Document History |
| SrsDocPrinters | SRS Document Printers |
| SrsDocArchiveSel | SRS Document Archive Selected Fields |
| SrsDocumentType | SRS Document Type |
| SrsReporting | Syspro Reporting Service Files |
| SrsRptSchedule | SRS System Report Schedule |
| SrsSettings | Syspro Reporting Service Settings |
| SysSettings | SYSPRO Settings |
| WipBranch | WIP Branch |
| WipBranchTransfer | WIP Branch Transfer Transaction |
New Columns
| Table Name | Column Name | Description |
|---|---|---|
| AdmCompanyDetails | InstalledSams | SYSPRO Application |
| SaaS | License is for SaaS | |
| BundleDistr | Distribution bundle flag | |
| BundleManuf | Manufacturing bundle flag | |
| SubscriptionMonths | Subscription period (months) | |
| StartDate | Subscription start date | |
| ExpiryDate | Subscription expiry date | |
| WarningDays | Subscription warning days | |
| DfmUsers | DFM users (SaaS only) | |
| BundleFoundAdv | Foundation+ bundle flag | |
| BundleFinanAdv | Financial+ bundle flag | |
| BundleDistrAdv | Distribution+ bundle flag | |
| BundleManufAdv | Manufacturing+ bundle flag | |
| SysproApiFinQry | Financial queries | |
| SysproApiDisQry | Distribution queries | |
| SysproApiOpeQry | Operation queries | |
| SysproApiMstMan | Master data management | |
| SysproApiProMan | Procurement management | |
| SysproApiSalMan | Sales management | |
| SysproApiOpeMan | Operations management | |
| SysproApiInvMan | Inventory management | |
| AdmSystemLicense | SaaS | Y - SYSPRO SaaS ERP license |
| SubscriptionPeriod | Subscription period (months) | |
| LicenseWarningDays | License expiry warning days | |
| ExcessUserFlag | Excess users detected | |
| ExcessUserExpiry | Excess users expiry date | |
| AdmOperator | DefaultWipBranch | Default WIP branch |
| WipBranchFilter | Only include WIP Branches | |
| NamedUserFlag | Named User flag | |
| LastWarningDate | Last license expiry warning | |
| AdmTax | RevChgCurTaxRate | Reverse charges current tax rate |
| RevChgPrvTaxRate | Reverse charges previous tax rate | |
| RevChgTaxEffDate | Reverse charges tax rate | |
| ApSupplier | DefRevChgTaxCode | Default reverse charge tax code |
| BomEmployee | WipBranch | WIP branch |
| BomMachine | WipBranch | WIP branch |
| BomRoute | WipBranch | WIP branch |
| BomWorkCentre | WipBranch | WIP branch |
| BpoDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of Origin | |
| GenJournalDetail | SubModWipBranch | Sub module WIP branch |
| GenTransaction | SubModWipBranch | Sub module WIP branch |
| GrnDetails | TariffCode | Tariff code |
| InvMovements | WipBranch | WIP branch |
| InvStockTake | DefaultBin | Warehouse default bin |
| LotArcWipInsp | WipBranch | WIP branch |
| LotArcWipInspDet | WipBranch | WIP branch |
| MdnDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| MdnDetailCons | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| MdnDetailRep | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| MdnDetailRepCon | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| MrpCoProducts | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| MrpJobAllLab | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| MrpJobAllMat | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| MrpJobClass | WipBranch | WIP branch |
| MrpJobMaster | WipBranch | WIP branch |
| WipCurBranch | Current WIP branch | |
| WipCtlCurGlCode | Current WIP control account | |
| MrpPoMasterDet | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of Origin | |
| MrpQotSoDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| MrpReqDetail | IntrastatExempt | Exempt from Intrastat |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of Origin | |
| MrpSoDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| MrpSugCoProducts | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| MrpSugJobAlLab | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| MrpSugJobAlMat | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| MrpSugJobMaster | WipBranch | WIP branch |
| WipCurBranch | Current WIP branch | |
| WipCtlCurGlCode | Current WIP control account | |
| MrpSugReqDetail | IntrastatExempt | Exempt from Intrastat |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of Origin | |
| MrpWipInspect | WipBranch | WIP branch |
| PorEcReceipts | TriangulationRole | Triangulation role |
| OrigCountry | Country of Origin | |
| InvValue | Invoice value | |
| PorMasterDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of Origin | |
| ReqDetail | IntrastatExempt | Exempt from Intrastat |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of Origin | |
| RmaCrossShipment | LineDiscPct1 | 1st Line Discount % |
| LineDiscPct2 | 2nd Line Discount % | |
| LineDiscPct3 | 3rd Line Discount % | |
| LineDiscValFlag | Discount flag | |
| LineDiscValue | Line discount value | |
| OrdDiscPct1 | 1st Order Discount % | |
| OrdDiscPct2 | 2nd Order Discount % | |
| OrdDiscPct3 | 3rd Order Discount % | |
| SalEcSales | TriangulationRole | Triangulation role |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| SorArcDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| SorDetail | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| SorQuoteDet | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDestState | Triangulation destination EU state | |
| TriangDispState | Triangulation dispatch EU state | |
| OrigCountry | Country of origin | |
| SorDetailRep | IntrastatExempt | Intrastat exempt |
| TriangulationRole | Triangulation role | |
| TriangDispState | Triangulation dispatch EU state | |
| TriangDestState | Triangulation destination EU state | |
| OrigCountry | Country of origin | |
| SrsDocHistory | ChangeDate | Date and time created |
| SrsDocPrinters | ClientServer | Client or Server printer |
| PrinterNumber | Printer number | |
| SrsDocuments | EncryptPassword | Password for PDF encryption |
| SrsDocumentType | CusXsdName | Schema file name |
| WhmBin | InCycleCount | Bin is in cycle count |
| InStockTake | Bin is in stock take | |
| WipArcCoProducts | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipArcJobAllLab | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipArcJobAllMat | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipArcJobPost | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipArcMaster | WipBranch | WIP branch |
| WipCurBranch | Current WIP branch | |
| WipCtlCurGlCode | Current WIP control account | |
| WipCoProducts | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipDistrMat | WipBranch | WIP branch |
| WipInspect | WipBranch | WIP branch |
| WipInspectDet | WipBranch | WIP branch |
| WipJobAllLab | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipJobAllMat | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipJobClass | WipBranch | WIP branch |
| WipJobPost | WipBranch | WIP branch |
| WipCtlGlCode | WIP control account | |
| WipLabJnl | WipBranch | WIP branch |
| WipMaster | WipBranch | WIP branch |
| WipCurBranch | Current WIP branch | |
| WipCtlCurGlCode | Current WIP control account |
New Indexes and Keys
None.
SYSPRO 8 2020 R1
New Tables
| Table Name | Description |
|---|---|
| AdmDigitalTaxTemp | Digital Tax Template |
| AdmOfficeTenants | Admin Office Tenants |
| AdmPidHistory | Admin Windows Process Id History |
| AdmSystemLicense | Admin System License |
| ApSupplierGroup | AP Supplier Groups |
| ArCustomerGroup | Ar Customer Groups |
| SorQuoteControl | Quick Quote Control |
New Columns
| Table Name | Column Name | Description |
|---|---|---|
| AdmOperator | PortalSupplier | Portal supplier |
| PortalCustomer | Portal customer | |
| TenantName | Office 365 tenant name | |
| AdmTax | CbDepTaxGlCode | CB Deposit Gl code |
| CbWthTaxGlCode | CB withdrawal GL control | |
| Reverse charge | Reverse charge | |
| GlRevChgGlCode | Reverse charge sales GL tax account | |
| ApRevChgGlCode | Reverse charge AP GL tax account | |
| AdmTaxReturn | DttStatus | Digital tax tool status |
| DttSubmitted | Digital tax tool submitted | |
| DttSubmittedDate | Digital tax tool submitted date | |
| DttYearSubmitted | Year digital tax tool submitted | |
| DttMthSubmitted | Month digital tax tool submitted | |
| RevChargeFlag | Reverse charge flag | |
| RevChargeTaxRate | Reverse charge tax rate | |
| RevChargeTaxValue | Reverse charge tax value | |
| ApGlDisburse | GroupPayment | Group payment |
| GrpPayConvRate | Group payment rate | |
| GrpPayCurrency | Group payment currency | |
| GrpPayPostMulDiv | Grp payment factor | |
| GrpPayValue | Group payment amount | |
| ApInvoice | RevChargeFlag | Reverse charge flag |
| ApJnlControl | TaxPortionDisc | Tax portion of discount |
| ApJnlDistrib | RevChargeFlag | Reverse charge flag |
| RevChargeTaxCode | Reverse charge tax code | |
| RevChargeTaxValue | Reverse charge tax value | |
| ApJnlSummary | TaxPortionDisc | Tax portion of settle disc |
| ApInvoicePay | GroupPayment | Group payment |
| ApPayRunDet | Journal | Jnl number of tax on settlement discount |
| EntryNumber | Entry number of tax on settlement discount | |
| SubEntry | Subentry number (1 up) of tax on settlement discount | |
| TaxBasedInv | Settlement disc tax based on invoice paid. | |
| TrnYear | Posting year of tax on settlement discount | |
| TrnMonth | Posting month of tax on settlement discount | |
| ApPayRunHdr | GroupPayment | Group payment |
| GroupSupplier | Group Supplier | |
| GroupValue | Group value | |
| ApTaxDistDet | RevChargeFlag | Reverse charge flag |
| RevChargeTaxCode | Reverse charge tax code | |
| RevChargeTaxValue | Reverse charge tax value | |
| ApTaxDistSum | RevChargeFlag | Reverse charge flag |
| ApTaxCodeDistDet | RevChargeFlag | Reverse charge flag |
| RevChargeTaxCode | Reverse charge tax code | |
| RevChargeTaxValue | Reverse charge tax value | |
| ApTaxCodeDistSum | RevChargeFlag | Reverse charge flag |
| ArCshJnlCtl | GroupPay | Group payment |
| PaymentNumber | Payment run number | |
| ArCshJnlDet | GroupPay | Group payment |
| ArPayHistory | GroupPay | Group payment |
| ArPayRunCus | Company | Company ID |
| Currency | Currency | |
| PaymentRate | Account conversion rate | |
| PaymentMulDiv | Account conversion rate MD | |
| GlExchVarCode | Exchange variance ledger code | |
| MultiPayFlag | Primary currency different | |
| MultiPayAmount | Allocated payment amount in primary customer currency | |
| ArPayRunHdr | Customer | Group payment customer |
| PaymentMulDiv | Account conversion rate MD | |
| ArInvoicePay | GroupPay | Group payment |
| CshArPayments | PaymentNumber | Payment run number |
| GroupPay | Group payment type | |
| CshGlEntries | TaxEntry | Tax entry flag |
| CshJnlGl | TaxGlCode | Tax Gl Code |
| CshTransactions | GroupPay | Group payment type |
| InvInspect | UseByDate | Use by date |
| SellByDate | Sell by date for retail | |
| InternalExpiryDate | Expiry date for wholesale | |
| ManufactureDate | Manufacture date | |
| DispatchDate | Dispatch date | |
| BestBeforeDate | Best before date | |
| InvMaster | SpecificGravity6 | Specific gravity with six decimals |
| IopSelSetAmendJnl | OldIncPlanBill | Include Planning bill part type |
| NewIncPlanBill | Include Planning bill part type | |
| MrpQotNonStock | SpecificGravity6 | Specific gravity with six decimals |
| MrpQotSoMasterHdr | QuickQuote | Quick Quote number |
| MrpSoMasterHdr | QuickQuote | Quick Quote number |
| QotNonStock | SpecificGravity6 | Specific gravity with six decimals |
| QotSoMasterHdr | QuickQuote | Quick Quote number |
| SalBranch | NextQuickQuote | Next Quick Quote number |
| QuickQuotePrefix | Quick Quote prefix | |
| VatRegistrationNo | Vat Registration number | |
| UserTaxReference | User defined tax reference | |
| SorArcMaster | QuickQuote | Quick Quote number |
| SorDetailLot | UseByDate | Use by date |
| SellByDate | Sell by date for retail | |
| InternalExpiryDate | Expiry date for wholesale | |
| ManufactureDate | Manufacture date | |
| DispatchDate | Dispatch date | |
| BestBeforeDate | Best before date | |
| SorMaster | QuickQuote | Quick Quote number |
| SorMasterRep | QuickQuote | Quick Quote number |
| SorQuote | QuickQuote | Quick Quote number |
| WipInspect | UseByDate | Use by date |
| SellByDate | Sell by date for retail | |
| InternalExpiryDate | Expiry date for wholesale | |
| ManufactureDate | Manufacture date | |
| DispatchDate | Dispatch date | |
| BestBeforeDate | Best before date | |
| WipReservedLots | UseByDate | Use by date |
| SellByDate | Sell by date for retail | |
| InternalExpiryDate | Expiry date for wholesale | |
| ManufactureDate | Manufacture date | |
| DispatchDate | Dispatch date | |
| BestBeforeDate | Best before date |
New Indexes and Keys
| Table Name | Index Name | Columns |
|---|---|---|
| SorQuote | SorQuoteIdxQkQuote |
QuickQuote |
| Customer | ||
| TrnDate | ||
| TrnTime |
SYSPRO 8 2019 R2
New Tables
| Table Name | Description |
|---|---|
| AdmMfaAuthConfig | Admin Authentication Configured |
| AdmMfaAuthEnabled | Admin Authentication Enabled |
| AdmMfaAuthHistory | Admin Authentication History |
| AdmSchDetail | Admin SYSPRO Scheduler Detail |
| AdmSchHeader | Admin SYSPRO Scheduler Header |
| AdmSsoUserSyncLog | Admin Single Sign On AD User Sync Log |
| AdmSsoUsers | Admin Single Sign On AD Users |
| AdmSchPrefs | Admin SYSPRO Scheduler Preferences |
| BotCardKeyfields | Bot Card Keyfields |
| BotCards | Bot Cards |
| BotCustomAccess | Bot Customization Access |
| BotSearchKeyfields | Bot Search Keyfields |
| BotSearches | Bot Searches |
| BotSkillButtons | Bot Skill Buttons |
| BotSkillKeyfields | Bot Skill Keyfields |
| BotSkills | Bot Skills |
| CrmCompActivities | Complaint Activities |
| CrmCompGroups | Complaints Groups |
| CrmCompMaster | Customer Complaints |
| CrmCompOwners | Complaints Owners |
| CrmCompRouting | Complaints Routing |
| CrmCompSeverity | Complaints Severity |
| CrmCompUsers | Complaints Users |
| GenHealthBal | General Ledger Balances |
| GenHealthFix | General Ledger Balances Fix |
| InvCycCntControl | Inventory Cycle Count Control |
| InvCycleCountBin | Inventory Cycle Count Bin |
| InvCycleCount | Inventory Cycle Count |
| InvCycleCountLot | Inventory Cycle Count Lots |
| InvCycleCountCapt | Inventory Cycle Count Capture |
| InvCycleCountSer | Inventory Cycle Count Serials |
| RtsControl | RTS Control |
| RtsDocumentFormat | Rts Document Format |
| RtsJournal | RTS Journal |
| RtsLastPrice | RTS Last Price Paid |
| RtsMaster | RTS Master |
| RtsNotes | RTS Notes |
New Columns
| Table Name | Column Name | Description |
|---|---|---|
| AdmCompanyDetails | InstalledRts | Return to Supplier Installed |
| AdmJobLogging | OperatorType | Operator type |
| AdmOperator | SqlGenOperLogin | Generate SQL login for operator |
| OperatorStatus | Operator status | |
| OperatorReason | Reason for current status | |
| OperatorType | Operator type | |
| AuthenticationType | Authentication type | |
| DateOperatorAdded | Date operator added | |
| DateStatusChanged | Date status changed | |
| AdmPassControl | MaxLength | Max length of password |
| MinSpecial | Min number of special characters | |
| ArInvoice | OrigTaxableDisc | Taxable discount amount |
| DrCrTaxDiscPortion | Settlement disc Dr/Cr tax portion | |
| ArPayRunDet | DrCrDiscValue | Accumulated Dr/Cr disc amount |
| DrCrInvoiceValue | Accumulated Dr/Cr amount | |
| DrCrTaxPortion | Accumulated Dr/Cr tax portion | |
| OrigTaxOnDisc | Original tax on discount | |
| OrigTaxableAmt | Taxable invoice amount | |
| OrigTaxableDisc | Taxable discount amount | |
| DrCrTaxDiscPortion | Settlement disc Dr/Cr tax portion | |
| OrigTaxPortion | Tax portion of current balance | |
| BotConnection | ConversationId | Last conversation ID |
| BotCustomization | SecurityType | Security type |
| BotVersion | StandardVersion | Standard data version |
| CrmControl | NextComplaint | Next Complaint number |
| EspDevice | Source | Product component source |
| EspSearch | DeviceId | Device id |
| GenHealthFix | Type | Type of account out of balance |
| GenHealthBal | Type | Type of account out of balance |
| IopSelectionSet | IncPlanBill | Include Byproduct part type |
| WhmBin | CycleCountVariance | Percentage cycle count variance |
New Indexes and Keys
| Table Name | Index Name | Columns |
|---|---|---|
| ArDiscDrCrDet | ArDiscDrCrDetIdxJnl | PostYear |
| PostPeriod | ||
| CashJournal | ||
| Customer | ||
| DiscDrCr | ||
| Sequence | ||
| DocumentType | ||
| Invoice | ||
| ArDiscDrCrHdr | ArDiscDrCrHdrIdxJnl | PostYear |
| PostPeriod | ||
| CashJournal | ||
| Customer | ||
| DiscDrCr | ||
| DocumentType |
SYSPRO 8 2019 R1
New Tables
| Table Name | Description |
|---|---|
| AdmPrograms | Admin Programs |
| AdmSecActFields | Admin Security Access Lists |
| DefnSignature | Electronic Signatures (IMPTRN.TXT) |
| DefnSignatureVar | Electronic Signature Variables (IMPTRN) |
| SrqDetail | RFQ Detail |
| SrqMaster | RFQ Master |
| SrqSupplier | RFQ Suppliers For RFQ/REQ Line |
| SrqSupplierTrans | RFQ Transaction Changes By Supplier |
New Columns
| Table Name | Column Name | Description |
|---|---|---|
| InvWhControl | ShortagesMethod | Method for dealing with shortages, only for a WMS wh |
| LostFoundWarehouse | Lost and found wh, only available if processing to L&F wh | |
| LotArcRecallAudit | Journal | Journal number |
| JournalLine | Journal Line | |
| JnlYear | Journal posting year | |
| JnlMonth | Journal posting month | |
| Version | Version | |
| Release | Release | |
| LotRecallAudit | Journal | Journal number |
| JournalLine | Journal Line | |
| JnlYear | Journal posting year | |
| JnlMonth | Journal posting month | |
| Version | Version | |
| Release | Release | |
| WhmBin | ReceivingBin | Can be a receiving bin |
| CycleCountVariance | Percentage cycle count variance |
New Indexes and Keys
None.
SYSPRO 8 2018
New Tables
| Database |
File Code |
Table Name |
Description |
|---|---|---|---|
|
Company |
ADMCMP |
AdmCompanyDetails |
Admin Company Details |
|
System |
ADMSTT | AdmState |
Admin Enet State |
|
Company |
APSBFC | ApCtlHealthFix |
AP Control Health Check Fix |
|
Company |
APSBFI | ApInvHealthFix |
AP Invoice Health Check Fix |
|
Company |
APSBFS | ApSuppHealthFix |
AP Supplier Health Check Fix |
|
Company |
APSHCC | ApCtlHealthBal |
AP Control Health Check Balance |
|
Company |
APSHCI | ApInvHealthBal |
AP Invoice Health Check Balance |
|
Company |
APSHCS | ApSuppHealthBal |
AP Supplier Health Check Balance |
|
Company |
ARSCHB | ArCustHealthBal |
AR Customer Health Balance |
|
Company |
ARSCHF | ArCustHealthFix |
AR Customer Health Fix |
|
Company |
ARSDGR | ArDunningGroup |
Dunning Group |
|
Company |
ARSDIN | ArDunningInvoices |
Dunning Invoices |
|
Company |
ARSDLF | ArDunningFormat |
Dunning Letter Format |
|
Company |
ARSDST | ArDunningStatus |
Dunning Status |
|
Company |
ARSHCB | ArCtlHealthBal |
AR Control Health Check |
|
Company |
ARSHCX | ArCtlHealthFix |
AR Control Health Check Fix |
|
Company |
ARSIHB | ArInvHealthBal |
AR Invoice Health Balance |
|
Company |
ARSIHF | ArInvHealthFix |
AR Invoice Health Fix |
|
Company |
BOMANA | BomArcNarration |
BOM Archived Narrations |
|
Company |
BOMAOP | BomArcOperations |
BOM Arhived Operations |
|
Company |
BOMAPR | BomArcParentInfo |
BOM Archived Parent Information |
|
Company |
BOMAST | BomArcStructure |
BOM Archived Structures |
|
Company |
CSHBBF | CshHealthFix |
Cash Book Bank Balances Fix |
|
Company |
CSHBBL | CshHealthBal |
Cash Book Bank Balances |
|
System |
DDSCVL | DdsColumnValues |
Data Dictionary Column Values |
|
System |
DFMQDP | DfmQueueDep |
Admin Doc Flow Manager Dependant Queue |
|
System |
DFMQDT | DfmQueueDetail |
Admin Doc Flow Manager Queue Detail |
|
System |
DFMQND | DfmQueueNonDep |
Admin Doc Flow Manager Non Dependant Que |
|
System |
DFMSVC | DfmServices |
Admin Doc Flow Manager Poller Services |
|
Company |
INVSPD | InvStkPolicyDetail |
Inv Stock Policy Detail |
|
Company |
INVSPM | InvStkPolicyMaster |
Inv Stock Policy Master |
|
Company |
LOTAIC | LotArcInvInsp |
Lot Archive Inventory Inspection Ctl |
|
Company |
LOTAID | LotArcInvInspDet |
Lot Archive Inventory Inspection Detail |
|
Company |
LOTAIS | LotArcInvInspSer |
Lot Archive Inventory Inspection Serials |
|
Company |
LOTASD | LotArcSerDet |
Lot Archive Serial Detail |
|
Company |
LOTATK | LotArcTracking |
Lot Archive Traceablility Tracking |
|
Company |
LOTATR | LotArcTransact |
Archived Lot Traceability Transactions |
|
Company |
LOTAWC | LotArcWipInsp |
Lot Archive WIP Inspection control |
|
Company |
LOTAWD | LotArcWipInspDet |
Lot Archive WIP Inspection details |
|
Company |
LOTAWS | LotArcWipInspSer |
Lot Archive WIP Inspection Serials |
|
Company |
PRJADT | PrjArcJobHierDet |
P&C Archive Job Hierarchy Detail |
|
Company |
SORADT | SorArcDetail |
SOR Archived Sales Order Detail |
|
Company |
SORAOH | SorArcMaster |
SOR Archived Sales Order Master |
|
Company |
WIPACL | WipArcCoPrdOpCost |
WIP Archive Co-product Labor Cost Apport |
|
Company |
WIPACM | WipArcCoPrdMatCst |
WIP Archive Co-product Mat Cost Apport |
|
Company |
WIPACO | WipArcCoProducts |
WIP Archive Job Co-products |
|
Company |
WIPAJB | WipArcJobPostBin |
WIP Archive Job Detail Line Bins |
|
Company |
WIPAJH | WipArcMaster |
WIP Archived Job Master |
|
Company |
WIPAJL | WipArcJobAllLab |
WIP Archive Labor Allocations |
|
Company |
WIPAJM | WipArcJobAllMat |
WIP Archive Material Allocations |
|
Company |
WIPAJP | WipArcJobPost |
WIP Archive Job Detail Posting |
|
Company |
WIPAJS | WipArcJobPostSer |
WIP Archive Job Detail Line Serials |
|
Company |
WIPAPB | WipArcPartBook |
WIP Archive Part Booking |
New Columns
| Database |
Table name |
Column Name |
Description |
|---|---|---|---|
|
Company |
ApBank |
CheckPrint |
Check print flag |
|
Company |
ApPayRunHdr | EftRemitPrint |
Eft remittance print flag |
|
Company |
ArcJobRef | Contract |
P&C Contract number |
|
Company |
ArInvoice | DunningDate |
Dunning date |
| DunningGroup |
Dunning group |
||
| DunningStatus |
Dunning status number |
||
|
Company |
ArCustomer | DunningEmail |
Dunning e-mail address |
| DunningFax |
Dunning Fax number |
||
| DunningGroup |
Dunning group |
||
|
Company |
ArInvoiceReval | DocumentType |
Document type |
|
Company |
CrmActivityAttach | AttachmentUrl |
Attachment url |
|
Company |
GtrSerialDetail | SourceBin |
Source bin |
|
Company |
GtrSerial | SourceBin |
Source bin |
|
Company |
InvMaster | UsesPrefSupplier |
Use preferred supplier |
|
Company |
InvOnHandBal | SerOnHand |
Quantity on hand in serials |
|
Company |
InvSerialTrack | Bin |
Bin location |
| ParentBin |
Parent bin location |
||
|
Company |
InvSerialTrn | Bin |
Bin location |
| PrvBin |
Previous BIN from BIN |
||
| TrnBin |
Bin location |
||
|
Company |
InvStockTakeSerial | Bin |
Bin location |
|
Company |
InvSerialHead | Bin |
Bin location |
| OnHoldReason |
Reason for hold |
||
| PrvBin |
Previous Bin from Bin |
||
| SerialOnHold |
Serial on hold flag |
||
|
Company |
InvWarehouse | UsesPrefSupplier |
Uses preferred supplier for demand |
|
Company |
MdnDetailSerCons | Bin |
Bin location |
|
Company |
MdnDetailSer | Bin |
Bin location |
|
Company |
MdnDetailSerRepCon | Bin |
Bin location |
|
Company |
MdnDetailSerRep | Bin |
Bin location |
|
Company |
MrpPoMasterDet | SourcingPolicy |
Sourcing Policy used |
|
|
SourcingPolicyType |
Sourcing policy type |
|
|
Company |
MrpAllMatSer | Bin |
Bin location |
|
Company |
MrpReqDetail | PolicyAvailable |
Sourcing policy available |
| SourcingPolicy |
Sourcing Policy used |
||
| SourcingPolicyType |
Type of sourcing policy used |
||
|
Company |
MrpSugReqDetail | PolicyAvailable |
Sourcing policy available |
| SourcingPolicy |
Sourcing Policy used |
||
| SourcingPolicyType |
Type of sourcing policy used |
||
|
Company |
MrpWarehouse | UsesPrefSupplier |
Uses preferred supplier for demand |
|
Company |
PorMasterDetail | SourcingPolicy |
Sourcing Policy used |
| SourcingPolicyType |
Sourcing policy type |
||
|
Company |
ReqDetail | PolicyAvailable |
Sourcing policy available |
| SourcingPolicy |
Sourcing Policy used |
||
| SourcingPolicyType |
Type of sourcing policy used |
||
|
Company |
RmaDetailSer | Bin |
Bin location |
|
Company |
SorDetailSer | Bin |
Bin location |
|
Company |
SorDetailSerRep | Bin |
Bin location |
|
Company |
WipAllMatSer | Bin |
Bin location |
|
Company |
WipJobPostSer | Bin |
Bin location |
Columns Changed
The following columns have changed for Company databases in SYSPRO 8:
|
Table Name |
Column Name |
Description |
Comment |
|---|---|---|---|
|
AdmSignatureLogDet |
VarNumericValue |
Numeric value of variable |
Old size = decimal (18,6) New size = decimal (26,6) |
| ApBank | BankAccount |
Bank account number |
Old size = varchar (20) New size = varchar (50) |
| ApSupplier | BankAccount |
Bank account of supplier |
Old size = varchar (20) New size = varchar (50) |
| EftCshSupplier | BankAccount |
Bank account of supplier |
Old size = varchar (20) New size = varchar (50) |
| GenAltCurDet | Reference |
Reference |
Old size = varchar (30) New size = varchar (50) |
| GenControl | CurBalAsset |
Current balance, Asset |
Old size = decimal (14,2) New size = decimal (17,2) |
| CurBalCapital |
Current balance, Capital |
Old size = decimal (14,2) New size = decimal (17,2) |
|
|
CurBalExpense |
Current balance, Expense |
Old size = decimal (14,2) New size = decimal (17,2) |
|
|
CurBalLiability |
Current balance, Liability |
Old size = decimal (14,2) New size = decimal (17,2) |
|
|
CurBalRevenue |
Current balance, Revenue |
Old size = decimal (14,2) New size = decimal (17,2) |
|
|
LotArcLibrary |
Archive |
Archive number |
Old size = decimal (3,0) New size = decimal (10,0) |
|
LotControl |
NextArchiveNum |
Next archive number |
Old size = decimal (3,0) New size = decimal (10,0) |
Copyright © 2022 SYSPRO PTY Ltd.