Document and Table Interface Information
P1 - Vendor Payment Voucher
Summary of Changes
-
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
- Document Type (Columns 3-6)
-
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.
-
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.
-
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 -
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.