SAM II Financial SAM II HR/Payroll SAM II Data Warehouse
SAM II
bar

Document and Table Interface Information

P1 - Vendor Payment Voucher
Summary of Changes

09/17/2001

Changed both Document Header (Type D) and Document Line (Type L) records as follows:
Document Type (Columns 3-6)
R/O - Changed to: Optional
Description - Changed to: Enter document type or leave blank.
Field Value - Changed to: P1, Space
Agency Code (Columns 7-10)
R/O - Changed to: Optional
Description - Changed to: Enter agency code of submitting agency or leave blank.
Field Value - Changed to: Removed contents
Batch Number (Columns 11-16)
R/O - Changed to: Required
Description - Changed to: Leave blank.
Field Value - Changed to: Spaces

07/01/2001

Removed Batch Header Information as follows:

Batch Header (Record Type B) - Completely removed from the layout

Document Header Record (Record Type D) - Changed Document Type, Agency Code, and Batch Number fields (Columns 3-16) to Filler fields.

Document Line Record (Record Type L) - Changed Document Type, Agency Code, and Batch Number fields (Columns 3-16) to Filler fields.


05/15/2001

  • Financial Release 2.2

Fixed Asset Type field added to the Document Line Record, column 237. Subsequent filler adjusted down. This field will not be used by Missouri. Spaces should be entered.

  • Descriptions

Accounting Period Description changed to: Input Optional. Defaults to the current accounting period for the current fiscal year. Nothing will appear in this field when processing the document.

Budget Fiscal Year Description changed to: Input Optional. Defaults to the current fiscal year. During the second year of a biennial appropriation, enter the first fiscal year of the biennium.

  • Other Modifications

Filler on the Document Header, columns 53-58, has been changed to a Date of Record field and descriptive information has been included which explains how to use it for the invoice date.


01/14/1999

Document Line Record

  • Added Field
>

Field Name R/O Description Field
Values
Format Size Decimal
Places
Start
Pos.
End
Pos.
Filler R Leave blank Spaces AN 14 0 145 158
  • Moved Field
Field Name Current
Starting
Position
New
Starting
Position
Current
Ending
Position
New
Ending
Position
Amount 145 204 158 217
Filler 186 >186 217 203
  • Size
Field Name Starting
Position
From To
Filler 186 32 18

01/06/1999

  • Field Names

Field names were changed to clarify their meaning. Some examples from the Document Header Record are as follows:

      Trans Code to Document Type
      Trans Agency Number to Agency Number
      Trans Number Number to Document Number

  • Descriptions

Many field descriptions were changed to include additional coding instructions or to adapt it to the Missouri installation

  • Required/Optional Indicators (C-Conditional, O-Optional, R- Required, S-System Maintained)

Document Line Record


Field Name
Starting
Position

From

To
Vendor Invoice 57 O >R
Organization 76 C R
Sub Organization 80 C O
Activity 82 C O
Object 86 C R
Sub Object 90 C >O
Job/Project 98 C O
Rept Cat 106 C O
Amount 145 C R
Partial/Final 160 C O
Appr Unit 173 C R
Function 182 C R
Inventory Line 218 C R
  • Field Values

Document Line Record


Field Name
Starting
Position

From

To
Line 37 00-99 01-99
  • Field Format

Batch Header


Field Name
Starting
Position

From

To
Net Amount 39 AN NM
Batch Control Count 65 AN NM

Document Header Record


Field Name
Starting
Position

From

To
Document Total 92 AN NM

Document Line Record


Field Name
Starting
Position

From

To
Amount 145 AN NM
Quantity 161 AN NM
  • Decimal Position Changes

Document Header


Field Name
Starting
Position

From
>
To
Document Total 92 0 2

Document Line Record


Field Name
Starting
Position

From

To
Quantity 161 0 3
  • Other Changes

Document Header

Starting in Column 226 - Filler, Calculated Total, Filler, Tax Code, and Use Tax Total combined into one Filler field - Length of 97.

Starting in Column 326 - All fields after Application Type were combined into one Filler Field - Length of 605.

Document Line Record

Starting in Column 92 - Rev Srce and Sub-Rev Srce combined into one Filler field - Length of 6.

Starting in Column 110 - Bs Account and Discount Type combined into one Filler field - Length of 5.

Starting in Column 186 - Filler , Tax Code, Total Amount, and Tax Amount combined into one Filler Field - Length of 32.

Starting in Column 221 - Def/Inc/Dec (Quantity), Freight, Def/Inc/Dec (Freight), and Filler combined into one Filler field - Length of 710.

Home    Missouri State Home    OA Home    Privacy    Advanced Search