SYSPRO Highlights > Detailed field size changes

Detailed field size changes

A key feature of SYSPRO 7 is that it caters for high volume transaction environments by extending field sizes throughout the product.

The following information is an overview of the detailed changes to field sizes in SYSPRO 7. This document is for informational purposes only and SYSPRO makes no warranties, express or implied.

System

The Datatype is an internal assignment in the SYSPRO data dictionary, used for consistency. The 6.1 size column is for informational purposes only. In some case there are multiple sizes (these are shown as comma-separated).

Field Datatype 6.1 size 7.0 size Comment
System fields        
System address format   20,30,40 40 All addresses have the following parts:
  AddressBuilding     1 x 40 Building.
  AddressStreet     1 x 40 Street.
  AddressLocality     1 x 40 Locality, suburb, other city.
  AddressCity     1 x 40 City.
  AddressState     1 x 40 State, province.
  AddressCountry     1 x 40 Country.
  AddressZip     1 x 10 Zip, postal code.
  GpsLatitude     1 x 2.6 Latitude.
  GpsLongitude     1 x 3.6 Longitude.
Company id Company 1 4 Can contain A-Z, 0-9, no embedded spaces.
Company name CompanyName 30 50  
Company address   3 lines Addr Uses system address format.
Operator code Operator 6 20  
Journal number JournalNumber 5 10 Journals and register numbers now 10 digits.
  AssetRegister      
  CheckRegister      
  InvoiceRegister      
Journal line number JournalLine 5 10 Line, entry, sub-entry numbers.
GL Analysis entry GlAnalysisEntry 7 10 Same as detail line/entry numbers.
Reference Reference 8,9,10,14 30 Caters for textual entries and when used to store fields such as 'check' in AR and AP payment reference.
Extra reference ReferenceExtra 30 50  
Tax percentages TaxRate 2.3 3.5 Includes Canadian FST and GST.
  TaxRateFst      
  TaxRateGst      
Tax code TaxCode 1 3 Including Canadian FST, GST, PST.
Email address Email 50,255 255  
Email subject Subject 40,100,255 255  
Lookup table descriptions DescriptionTable 14,15,30 50 TBL* (e.g. Invoice terms description, commission codes).
Audit log text AuditLogText 60 100 Log message.
Job log message LogMessage 40 100 Log message.
Document format DocumentFormat 1 2 AR statement is already 2. Other formats changed to 2, but only first character will be used in SYSPRO 7 (as some allow A-Z, a-z and 0-9).
Fixed width notes NoteText 30,45,60 100 Supplier and customer notes now 500 lines x 100 characters.

Sales order, purchase order and job notes now 100 lines x 100 characters.
Amendment jnl values AmendBeforeAfter 30,40,50 255  
Custom form alpha field CustomFormAlpha 100 255  
Custom form default value CustomFormAlphaDef 20 50  
Custom form lookup value CustomFormListVal 30 50  
Custom form lookup desc Description 40 50 Lookup value description.
Custom form drop down list UiDropDownList 30 50  

Financial

Field Datatype 6.1 size 7.0 size Comment
Customer Customer 7 15 Numeric size will be 15.
A/R Invoice number InvoiceAr 6 20 Allow for unique alphanumeric prefix of 10. Numeric size will be 15.
AR Invoice Prefix PrefixNextInv 1 10 In line with increase in branch code.
Customer name CustomerName 30 50  
Customer short name CustomerShortName 10 20  
Customer address       See system fields.
AR branch BranchAr 2 10  
AR branch address       See system fields.
AR Store number StoreNumber 7 20 Sub account store number.
Salesperson Salesperson 3 20  
Customer class CustomerClass 2 10  
Geographic area GeographicArea 2 10  
AR Drawers bank Bank 2 15 Same as AP Bank field.
AR Drawers bank branch BankBranchName 9 50 Same as AP Bank branch name field.
AR Check drawers name CheckDrawersName 30 50 Bank deposit slip (same as customer name).
AR statement print message --------   200 This field is not stored in a database.
AR perm entry extra desc PermEntryExtraDesc 30 50  
MTD no of invoices etc ItemCount 4 10 Number of invoices, debit and credit memos, payments, adjustments and discounts per customer.
Supplier Supplier 7 15 Numeric size will be 15.
Supplier name SupplierName 30 50  
Short name SupplierShortName 10 20  
AP branch BranchAp 2 10  
AP Branch address       See system fields.
Supplier Class SupplierClass 2 10  
AP Check number - alpha CheckNumberAlpha 6 15 Can contain 'none'.
AP Check number - numeric CheckNumberNumeric 6 15 Purely numeric check numbers.
AP Payment number PaymentNumber 7 15 In line with Check number.
Discount code AR, AP DiscountCode 2 5  
Discount percentage AR AP DiscountPct 3.2-/2.2- 3.2- 2nd and 3rd percentages same as 1st percentage Also settlement discount to 3.2.
Permanent entry description AR, AP & Cash Book DescriptionPermEnt 20 30  
Bank Bank 2 15  
Bank account number BankAccountNumber 12,15 20  
Bank name BankName 30 50  
Bank address       See system fields.
Bank branch name BankBranchName 8 50 Descriptive text.
EFT check number EftCheckNumber 6 15 Same as Check number.
GL Code GlCode 15 35  
GL Description GlDescription 30 50 Including Alternate description.
GL Line number GLLineNumber - 10 New 10 digit transaction line number. Previous 5 character alpha line number retained separately for backward compatibility.
GL Detail comment GlDetailComment 80 250 Join previously split 60 and 20 character comments to the new 250 one during conversion.
GL comment GlComment 60 120  
GL Reporting index GlReportIndex 15 35 Same as GL Code.
GL Group GlGroup 2 10  
GL Structure GlCodeSection 45 35 Same as GL Code.
GL Zoom key GlZoomKey 50 100 Stores compound keys from other tables.
GL Journal notation GlNotation 74 100  
Asset Number Asset 15 30  
Asset Description AssetDescription 30 50  
Asset Branch AssetBranch 6 10  
Asset Cost Center AssetCostCenter 6 20 Same as WIP Cost Center.
Asset Group AssetGroup 4 10  
Asset ID AssetId 20,30 30 Asset id/serial number.
Asset Owner AssetOwner 4 10  
Asset Mechanic AssetMechanic 6 20  
Asset Status AssetStatus 6 10  
Asset Reason Disposal AssetReasonDispose 6 10  
Asset Reason Reval AssetReasonReval 6 10  
Asset Depreciation AssetDepreciation 2 10  
Asset Expense Codes AssetExpense 15 15 These are not GL Codes and stay 'as is'.
Asset Chassis number AssetChassis 10 30  
Asset Engine number AssetEngine 10 30 Increased same as Asset chassis.
Account Account 7 15 Same as customer.
Account name AccountName 30 50 Same as customer.
Account short name AccountShortName 10 20 Same as customer.
Account class AccountClass 2 10 Same as customer.

Distribution

Field Datatype 6.1 size 7.0 size Comment
Stock description StockDescription 30 50  
Long description StockLongDesc 30 100 Also supplier's stock code long description.
Alternate key 2 StockCodeAltKey 6 20 Alt key 1 was already 20 (update alt key 2).
Stock code user field 1 StockUserField1 10 30  
Unit of Measure UnitOfMeasure 3 10  
Factors UomFactor 4.3,4.6 6.6 All UOM conversion factors.
Cost multiplier CostMultiplier 3.3 3.6  
Product class ProductClass 4 20  
Price code PriceCode 2 10  
Warehouse Warehouse 2 10  
Warehouse address       See system fields.
Bin Bin 6 20  
FIFO bucket FifoLifoBucket 6 10 FIFO and LIFO buckets.
Buyer Buyer 3 20  
Planner Planner 3 20  
Buying group BuyingGroup 2 10  
Buying group description DescriptionTable 15 50  
Quantities Quantity 7.3-,6.6- 12.6- All Quantity fields including Qty per and Scrap/Yield quantity in BOM, etc.
Mass Mass 6.6 12.6 Increased to match quantity.
Volume Volume 6.6 12.6 Increased to match quantity.
Various day fields Days4Unsigned 3 4 AR discount days allowed and due date, AP days discount allowed and days until due, Shelf life days, Customer highest days overdue and average days to pay.
Dock to Stock

Lead Times

 DockToStock 3 10 In future may allow a user defined Uom.
Serial number Serial 20 50  
Serial description SerialDescription 30 50  
Serial location SerialLocation 8 20  
Sales order number SalesOrder 6 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
Sales order (next number) SalesOrderNext 6 15  
Sales order prefix PrefixNextSo 1 10 In line with branch.
Sales order comment Comment 45 100  
Delivery note number DeliveryNote 6 20 Includes unique alphanumeric prefix of10. Maximum numeric size will be 15. Supplier and Customer delivery note.
Dispatch note number DispatchNote 15 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
Purchase order number PurchaseOrder 6 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
Purchase order prefix PoPrefix 1 10 In line with warehouse and branch.
Purchase order (next num) PurchaseOrderNext 6 15  
Return Merchandise number RmaNumber 8 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
RMA Prefix PrefixNextRma 1 10 In line with branch.
GTR Reference GtrReference 9 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
GTR Prefix GtrPrefix 2 10 In line with warehouse.
GRN Number Grn 9 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
GRN Prefix GrnPrefix 2 10 In line with Branch and Warehouse.
Requisition movement no RequisitionRoute 2 3  
Requisition user RequisitionUser 3 20  
Customer stock code CustomerStockCode 30 30 Originally would have changed but will remain the same, new fields added.
Customer stock description CustomerStockDesc New 50 New field.
Customer stock long desc CustomerStockDescL New 100 New field.
Approved Manufacturers part number StockCodeApprovMan 30 50  
Supplier catalogue number SupplierCatalogue 30 50  
Supplier contract SupplierContract 6 20  
Sales contract CustomerContract 6 20 Contract number used in S/O contract pricing.
Standard comment codes CommentCode 3 10 Sales and Purchases.
Shipping instructions code ShippingInstrsCode 2 6  
Shipping instruction ShippingInstrs 30 50 Separate code and text in all files.
Minimum Price Pct MinimumPricePct 2.0/2.2 3.2 Min pct above cost for margin checking.
Shipment reference Reference 15 30  
Delivery route description DeliveryRouteDesc 30 50 Same as BOM route description.
LCT route description LctRouteDesc 30 50 Same as BOM route description.

Manufacturing

Field Datatype 6.1 size 7.0 size Comment
Quotation number Quote 8 20 Includes unique alphanumeric prefix. Maximum numeric size will be 15.
Quote description QuoteDescription 30 50  
Quotation address       See system fields.
Job number Job 8 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15.
Job number prefix ClassJobPrefix 5 10 In line with job classification.
Job description JobDescription 30 50  
Inspection document number InspectionDocument 10 20 Includes unique alphanumeric prefix of 10. Maximum numeric size will be 15. We need to include prefix in Job Classification.
WIP Inspection prefix PrefixInspect   10 New field on job classification.
ECC Change Order Number EccChangeOrder 10 15 No prefix.
Next ECC change number EccChangeOrderNext 10 15  
Toolset number ToolsetNumber 15 30  
Toolset description ToolsetDescription 30 50  
BOM Route number Route 1 2 Quote route also changed to 2, but only single character to be used in SYSPRO 7.
BOM Route description RouteDescription 30 50  
BOM % of wet weight WetWeightPct 2.2- 2.6-  
Head HierHead 3 10  
Section HierSection 3 10  
Head/section description HierHeadDesc 30 50  
Lot number Lot 10 50 Maximum numeric size will be 15.
Labor times LaborTime 5.4- 8.6- Also capacity and hours.
Labor times (unsigned) LaborTimeUnsigned 5.4 8.6  
Labor rates LaborRate 8.4 8.6  
Lead times LeadTime 3 10 In future may allow a user defined Uom.
Elapsed time ElapsedTime 3 10 In future may allow a user defined Uom.
Subcontract offsite SubOffsite 3 10  
Labor value required UnitValueLabor 12.4- 12.5-  
Operation number Operation 3,4 5 BOM, WIP and Quotations.
Operation move time MovementTime 3 10 In future may allow a user defined Uom.
Look ahead window LookAheadWin 3 10 SFS look ahead window.
Pieces field in operations Pieces 5 12.6  
Total pieces for job PiecesTotal 7- 12.6-  
Cost center CostCenter 6 20  
Cost center description CostCenterDesc 30 50  
Revision Revision 3 5 Revision also known as 'Version'.
Release Release 3 5  
Work center WorkCenter 6 20  
Work center description WorkCenterDesc 30 50  
Machine code Machine 6 30  
Machine description MachineDescription 30 50  
Work center cell (APS) WorkCenterCell 16 20  
Tool Tool 15 30  
Tool description ToolDescription 30 50  
Job classification JobClass 4 10  
Job class description JobClassDesc 30 50  
Nonproductive code NonProductiveCode 2 10  
Reject code RejectCode 2 10  
Scrap code ScrapCode 2 10  
Scrap description ScrapDescription 30 50  
Employee code Employee 6 N 20 A Convert from numeric to alphanumeric.
Employee name EmployeeName 30 50  
BOM narration code - man NarrationCode 4 10 Manual narration code.
BOM narration code - auto NarrationCodeAuto 7 10 Automatic narration code.
ABC Element AbcElement 6 10  
ABC Element description AbcElementDesc 30 50  
QOT Non-stock {various}     Changes in line with Stock Codes.
QOT Estimates {various}     Changes in line with BOM.
Quote Route description QuoteRouteDesc 30 50 Same as BOM Route description.
P&C Description ContractDesc 5 x 30 5 x 50 Now 5 x Lines of 50 characters.
P&C Responsibility code Responsibility 3 10  
P&C Responsibility name ResponsibilityName 30 50  
P&C Hierarchy Hierarchy 8 10  
MRP Forecast description ForecastDesc 30 50  
Resource code Resource 15 30  
Resource description ResourceDesc 30 50  
ECC Notes description EccNotesDesc 50 100  
ECC status events desc EccStatusEventDesc 30 50  
ECC status code EccStatus 6 20  
ECC user code EccUser 6 20  
Product description ProductDescription 30 50  
Configurator selection description ConfigSelectDesc 30 50  
Configurator selection short description ConfigSelectShDesc 15 50  
Configurator selection value prompt ConfigSelectPrompt 30 60  
Configurator option description ConfigOptionDesc 30 50  
Configurator criterion name ConfigCritName 6 20  
Configurator criterion comment ConfigCritComment 45 100  
Configurator engineer Engineer 10 20  
Reason for change ReasonForChange 10,20 30 BOM, ECC, QOT structure changes, AP invoice registration, GL history.