Attachment 7 - SAMII Interface Layout.pdf

PDF 167 KB Posted

Attached to
Statewide Purchasing Card and Business Travel Card Services
Solicitation number
300000258340247
Issued by
Missouri

About this file

This is a technical specification document describing the P-Card (Purchasing Card) interface file layout for the SAMII (State Accounting and Management Information Interface) system, as currently received from UMB (U.S. Bank). The document outlines the data structure and field definitions for processing purchasing card transactions within the state's financial system. The interface layout defines record components including agency codes, masked card numbers, closing dates, vendor names, transaction dates, and associated accounting codes organized by fund, organization, sub-organization, function, approval, activity, object, and sub-object classifications. Each field is specified with its corresponding data type and character length, ranging from single-character fields to twelve-digit numeric fields with decimal precision for transaction amounts.

The document specifies transaction amount fields with signed nine(12)V99 formatting to accommodate amounts up to 999,999,999,999.99 with cent-level precision. The layout includes a filler field and establishes standardized naming conventions for all data elements captured in the P-Card processing interface. This technical specification serves as the foundation for data extraction, validation, and integration of purchasing card transactions into the state's accounting and management information system, ensuring consistent data formatting and field organization across all P-Card transactions processed through the SAMII platform.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

ATTACHMENT 7

SAMII INTERFACE LAYOUT

Current layout of P-Card interface file received from UMB.

01 WS-RECORD.

05 WS-AGENCY PIC X(03).

05 WS-CARD-NUM.

10 WS-CARD-FIRST10-MASKED PIC X(10). NAME CHANGE

10 WS-CARD-LAST6 PIC X(06).

05 WS-CLOSING-DATE.

10 WS-CLS-YYYY.

15 WS-CLS-CC PIC X(02).

15 WS-CLS-YY.

20 PIC X(01).

20 WS-CLS-Y PIC X(01).

10 WS-CLS-MM PIC X(02).

10 WS-CLS-DD PIC X(02).

05 WS-VENDOR-NAME PIC X(30).

05 WS-TRANS-DATE.

10 WS-TRAN-YYYY.

15 WS-TRAN-CC PIC X(02).

15 WS-TRAN-YY PIC X(02).

10 WS-TRAN-MM PIC X(02).

10 WS-TRAN-DD PIC X(02).

05 WS-FUND PIC X(04).

05 WS-ORGN PIC X(04).

05 WS-SUB-ORG PIC X(02).

05 WS-FUNCTION PIC X(04).

05 WS-APPR PIC X(04).

05 WS-ACTIVITY PIC X(04).

05 WS-OBJECT PIC X(04).

05 WS-SUB-OBJECT PIC X(02).

05 WS-JOB PIC X(08).

05 WS-REPT-CAT PIC X(04).

05 WS-AMOUNT PIC S9(12)V99.

05 FILLER PIC X(01).

File details come from the government source that posted it. Updated .