SYSPRO 8 - SQL Updates by Release


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 |

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 |

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 |


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 |

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 |

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 |


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 |

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 |

None.


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 |

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 |

Table Name | Index Name | Columns |
---|---|---|
SorQuote | SorQuoteIdxQkQuote |
QuickQuote |
Customer | ||
TrnDate | ||
TrnTime |


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 |

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 |

Table Name | Index Name | Columns |
---|---|---|
ArDiscDrCrDet | ArDiscDrCrDetIdxJnl | PostYear |
PostPeriod | ||
CashJournal | ||
Customer | ||
DiscDrCr | ||
Sequence | ||
DocumentType | ||
Invoice | ||
ArDiscDrCrHdr | ArDiscDrCrHdrIdxJnl | PostYear |
PostPeriod | ||
CashJournal | ||
Customer | ||
DiscDrCr | ||
DocumentType |


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 |

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 |

None.


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 |

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 |

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.