Unimarket Fillable Fields Character Limits

  • Updated

This guide details the maximum character counts for the most common fillable fields in Unimarket. These limits are designed to balance user flexibility with the database constraints of integrated ERP systems (such as Ellucian Banner).

 

Procurement & Checkout Fields

These fields are completed by users during the requisitioning and checkout process.

Field NameCharacter Limit
Attn (Ship-To/Bill-To)35 - 40 Characters
Special Instructions2,000 Characters
Non-Catalog Item Name255 Characters
Non-Catalog Item Desc.2,000 Characters
Product Code64 Characters
Manufacture Part ID64 Characters
Justification4,000 Characters
Approved/Declined Reason1,000 Characters
Reassign Note1,000 Characters

 

Supplier Management & Profile

Constraints for onboarding new vendors and managing existing profiles.

Field NameCharacter LimitUsage
Supplier Name255 CharactersLegal or DBA name.
Tax ID / EIN20 CharactersFinancial identifier.
Invite Message1,000 CharactersCustom text in the email invitation.
Internal Supplier Form2,000 CharactersAdministrator notes on the profile.

Supplier Settings Tab

  • Account Number: 64 Characters
  • Description Box: 1,000 Characters
  • Supplier Comments (Last Tab): 2,000 Characters
  • Alert Box: 500 Characters (Pop-up alert seen by users)

 

Item & Catalog Details

Limits for data provided via catalogs or for non-catalog requests.

Field NameCharacter LimitContext
Supplier Part ID (SKU)64 CharactersUnique product identifier.
Manufacturer Part ID64 CharactersOEM identifier.
Unit of Measure (UOM)32 Characterse.g., "EA", "BOX", "REAM".
Item Level Comments2,000 Characters.../ItemOut/Comments

 

Community Created Forms

Limits for elements when building custom request or qualification forms.

Form ElementCharacter LimitUse Case
Form Name100 CharactersTitle of the form.
Code Field50 CharactersInternal unique ID for the form.
Description Field500 CharactersOverview shown to users.
Help Text255 CharactersShort instructions under a field.
Help/Information Field4,000 CharactersRich text for detailed guidance.
Text Field255 CharactersSingle-line input.
Paragraph Text4,000 CharactersMulti-line text/essay input.

 

Contracts Module

The Unimarket Contracts module requires specific data entry for auditing, tracking, and searching agreements. Below are the character constraints for the primary contract management fields.

Contract Header Information

These fields define the primary identity of the contract record.

Field NameCharacter LimitUsage
Contract Name255 Characters

The primary title of the agreement. 

Searchability: If names are too long, they may be truncated in standard search result views, though the full data remains in the record.

Contract Number100 Characters

The unique identifier (Internal or Supplier provided).

Searchability: If names are too long, they may be truncated in standard search result views, though the full data remains in the record.

Reference255 CharactersSecondary identifier or legacy system cross-reference.
Description4,000 CharactersSummary of the contract scope and purpose.
Supplier Name255 CharactersSelected from the integrated supplier database.

Terms, Renewals & Notifications

Fields used to manage the lifecycle and automated alerts of the contract.

Field NameCharacter LimitUsage
Renewal Terms2,000 CharactersDescription of how the contract renews (e.g., "Auto-renew for 1 year").
Internal Notes2,000 CharactersInternal-only comments (not visible to suppliers).
Termination Notice500 CharactersBrief summary of the notice period requirements.

Workflow & Approval Fields

Comments and notes generated during the contract approval process.

Field NameCharacter LimitUsage
Workflow Level Name100 CharactersCustom name for the approval gate (e.g., "Legal Review").
Approval Comments1,000 CharactersNotes added by an approver during sign-off.
Decline Reason1,000 CharactersMandatory field when a contract is sent back for edits.

Contract Forms & Custom Fields

If your community uses Contract Forms to capture additional metadata (e.g., Insurance requirements, HIPAA compliance), the limits follow the standard Community Created Forms logic:

Form ElementCharacter Limit
Text Field (Single Line)255 Characters
Paragraph Text4,000 Characters
Help/Information Field4,000 Characters (Rich Text)
Help Text (Under field)255 Characters

Document Management

When uploading attachments (PDFs, Word Docs) to the contract record:

  • Document Title: 255 Characters.
  • Tags/Keywords: 100 Characters per tag (Used for search filtering).
  • File Size Limit: Generally 20MB per file (Check your specific community configuration for variations).

 

Invoicing Module

The Invoicing module handles data from various sources (e.g. Supplier cXML, manual entry). Maintaining these character limits is essential for successful matching and payment processing in your ERP.

 

Invoice Header Fields

These fields define the high-level metadata for the entire invoice or credit memo.

Field NameCharacter LimitUsage
Supplier Invoice Number50 CharactersThe unique ID assigned by the vendor.
Unimarket Invoice ID20 CharactersThe system-generated "I-xxxx" reference.
Reference Number50 CharactersTypically holds the Banner/ERP Invoice Number (I#).
Invoice Description1,000 CharactersGeneral summary of the invoice contents.
Currency Code3 CharactersISO Standard (e.g., USD, CAD).

Invoice Line Item Fields

Constraints for specific data at the commodity or service line level.

Field NameCharacter LimitContext
Item Description2,000 Characters 
Supplier Part ID (SKU)64 Characters 
Manufacturer Part ID64 Characters 
Unit of Measure (UOM)32 Characterse.g., "EA", "BOX", "HOUR".
Line Item Comments2,000 CharactersAdditional context per line.

Workflow & Approval Comments

Notes generated during the invoice matching or exception approval process.

Field NameCharacter LimitUsage
Approval Comment1,000 CharactersAdded by AP or Departmental approvers.
Decline Reason1,000 CharactersMandatory for rejected invoices.
Internal Notes2,000 CharactersAudit-only notes on the invoice record.

 

Expenses Module

The Expenses module allows users to submit travel, entertainment, and out-of-pocket spend for reimbursement. Ensuring data stays within these character limits is vital for accurate financial reporting and smooth integration with the ERP's Accounts Payable and General Ledger modules.

Expense Report Header

These fields establish the general context of the reimbursement request.

Field NameCharacter LimitUsage
Expense Report Name255 CharactersThe primary title (e.g., "NAEP Conference 2024").
Business Purpose4,000 CharactersDetailed explanation of why the expense was incurred.
Reference100 CharactersInternal tracking number or project code.
Description2,000 CharactersHigh-level summary of the overall claim.

Expense Line Item Details

Constraints for specific data entered for each individual receipt or charge.

Field NameCharacter LimitContext
Merchant Name255 CharactersThe name of the vendor (e.g., "Delta Airlines").
Line Description2,000 CharactersSpecific details for the line item.
Receipt Reference100 CharactersInvoice or receipt number from the merchant.
Expense Type/Category100 CharactersThe label for the category (e.g., "Lodging").

Approval & Workflow Comments

Notes generated during the review process by supervisors or the Finance office.

Field NameCharacter LimitUsage
Approval Comment1,000 CharactersJustification for approving an exception.
Decline/Return Reason1,000 CharactersMandatory explanation when a report is sent back.
Internal Finance Notes2,000 CharactersNotes added by AP/Audit during final review.

Receipts & Attachments

Digital evidence of spend must adhere to these naming and size constraints:

  • Attachment Title: 255 Characters.
  • Filename: 255 Characters (Avoid special characters like #, %, or &).
  • File Size: 20MB per file (typical).
  • Total Report Size: Some communities enforce a 100MB total limit per report for email/integration stability.