Attachment 7 - SAMII Interface Layout.pdf
PDF 167 KB Posted
- 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 .