Status Status of Purchase Order 10 Alphanumeric Required From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Name: Status Valid values: Ordered, Received, Receiving, Cancelling and Canceled Title Agency entered title of the purchase order. 128 Alphanumeric Required From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Name: Title Total Purchase Order Amount Total of all Line Item Totals 13.2 Numeric Required From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Name: Total PO Amount Can be zero, positive and negative
Vendor’s Name Vendor’s name as it appears in FLAIR’s vendor files. 60 Alphanumeric System Generated Retrieve from FLAIR's Vendor files for external vendors. Not actually stored in the this table Vendor’s Street Address Vendor’s address as it appears in FLAIR’s vendor files. 60 Alphanumeric System Generated Retrieve from FLAIR's Vendor files for external vendors. Not actually stored in the this table Vendor’s City Vendor’s city as it appears in FLAIR’s vendor files. 30 Alphanumeric System Generated Retrieve from FLAIR's Vendor files for external vendors. Not actually stored in the this table
Line Item Total Amount Quantity of item ordered times Price per Unit/Qty of item ordered. 13.2 Numeric Required From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Total Name: Line Item Amount Can be zero, positive and negative State Term Contract Number DMS’ State Term Contract Number, if available 50 Alphanumeric Optional From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Name: State Term Contract Number Solicitation Number Agency’s solicitation number, if available 50 Alphanumeric Optional From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Name: Agency Solicitation Number Line Item Description Description of item ordered. 2,000 Alphanumeric Required From MFMP file MFMP_Purchase_Order_Data_DFS.cvs.gz Column Name: Line Item Description
Warrant Issue Date (MM/DD/YYYY) FALIR Voucher Date 8 MMDDYYYY Optional From MFMP file MFMP_Purchase_Order_Invoice_Data_DFS.csv.gz Column name: Warrant Issue Date Fiscal Year (YY-YY) Payment fiscal year 5 Alphanumeric Optional Calculate by FACTS base on the Warrant Date and CFI indicator in the FLAIR Account Code. If CFI = “C”, Fiscal Year is prior fiscal year. MFMP Paid Date MFMP recorded payment date 8 MMDDYYYY Required From MFMP file MFMP_Purchase_Order_Invoice_Data_DFS.csv.gz Column name: MFMP Paid Date Invoice Number MFMP invoice number 50 Alphanumeric Optional From MFMP file MFMP_Purchase_Order_Invoice_Data_DFS.csv.gz Column name: Invoice Number Payment Line Number MFMP payment line number 8 Alphanumeric Required From MFMP file MFMP_Purchase_Order_Invoice_Data_DFS.csv.gz Column name: Line Item Number Payment Spit Accounting Number MFMP split accounting number 10 Alphanumeric Required From MFMP file MFMP_Purchase_Order_Invoice_Data_DFS.csv.gz Column name: Split Accounting Number
“Vendor Name” becomes the 5th column on the results page. Rename “Contract Total Amount” to “Total Amount” and it becomes the 6th column of the results page. “Commodity/Service Type description” becomes the 7th column on the result page. “View Audits’ becomes the 8th column on the result page. Add “PO Title/Long Title” as the 9th column on the result page; PO Title is from the purchase order database and Long Title is from the contracts database. “Contract Short Title” becomes 10th column on the results page. Add “FLAIR Contract ID” the 11th column on the results page. “Execution Date” becomes the 12th column on the result page. “PO Order Date becomes the 13th column on the results page. “Beginning Date” becomes the 14th column on the result page. “Ending Date” becomes the 15th column on the result page. “Status” becomes the 16th column on the result page. “Method of Procurement” becomes the 17th column on the results page. “State Term ID” becomes the 18th column on the results page. “Agency Service Area” becomes the 19th column on the result page. “Advance Payment” becomes the 20th column on the results page. “Recipient Type” becomes the 21th column on the results page. “Agency Reference Number” becomes the 22st column on the results page. Add “CFDA” as the 23nd column on the results page; display ‘Multiple” if multiple records are found. Add “CSFA” as the 24rd column on the results page; display ‘Multiple” if multiple records are found. “Admin Costs?” becomes the 25th column on the results page; display “Yes” and “No” values. Advanced Search web page messages The “ Search results may display a contract amount more than once. Agencies may be recording contracted amounts on a Contract, on a Purchase Order, or on both in FACTS. FACTS must provide querying assistance such as Commodity/Service Type download, as well as drop down pick lists for available data values similar to that available for contracts in FACTS.
Bill DuBose Update Method of Payment comments to include; If MFMP sends a “9”….” code display FACTS code “9” code description. If MFMP sends a “W”….” code display FACTS code “W2” code description. 10/28/13 Bill DuBose Added “Include Inactive” check box for MOP codes. 10/30/13 Bill Dubose Added “PO Order Date becomes the 13th column on the advance results page and added Purchase Order Fiscal Year to “Detail” “Main Information” section 11/8/13 Bill DuBose Remove Vendor Line 2 from requirements 11/13/13