Purchase Order Template

PurchaseOrderTemplate

81 columns Fetched February 27, 2026

Related Reports

Purchase Order 11 shared Invoice Header 5 shared Invoices 5 shared Warehouse 5 shared Project Header 4 shared

n8n

Columns

Purchase_Order_RecID Numeric
Also in 1 report
Purchase Order
PO_Number Text nullable
Purchase_Date DateTime nullable
Billing_Terms_RecID Numeric nullable
Also in 7 reports
Agr Type Billing Terms Company Invoice Header Invoices Portal Invoices Purchase Order
Billing_Terms_Description Text nullable
Total Numeric nullable
Freight_Cost Numeric nullable
Freight_Packing_Slip Text nullable
Owner_Level_RecID Numeric nullable
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Time Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location
Billing_Unit_RecID Numeric nullable
Also in 29 reports
Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Member Portal Agr Type Project Header Purchase Order Service Code Service Item Service Status Service Sub Type Service Team Service Type Time User Defined Field Billing Units Warehouse Warehouse Bin
Entered_By Text nullable
ShipmentMethod_RecID Numeric nullable
Also in 2 reports
Purchase Order Shipment Method
ShipMethodDescription Text nullable
Ship_Date DateTime nullable
Tracking_Number Text nullable
Shipping_Instructions Text
Internal_Notes Text
Vendor_Order_Number Text nullable
Vendor_Invoice_Number Text nullable
Vendor_Invoice_Date DateTime nullable
Vendor_Company_RecID Numeric
Also in 1 report
Purchase Order
Vendor_Contact_RecID Numeric nullable
Also in 1 report
Purchase Order
Vendor_Address_RecID Numeric nullable
Also in 1 report
Purchase Order
Customer_Company_RecID Numeric nullable
Also in 1 report
Purchase Order
Customer_Contact_RecID Numeric nullable
Also in 1 report
Purchase Order
Customer_Address_RecID Numeric nullable
Also in 1 report
Purchase Order
Last_Update DateTime
Updated_By Text nullable
TimeZone Text nullable
Closed_Flag Boolean nullable
Vendor_Company_Name Text nullable
Vendor_Contact_First_Name Text
Vendor_Contact_Last_Name Text
Vendor_Contact_Full_Name Text
Vendor_PhoneNbr Text nullable
Vendor_Site_Name Text nullable
Vendor_Address_Line1 Text nullable
Vendor_Address_Line2 Text nullable
Vendor_City Text nullable
Vendor_State Text nullable
Vendor_Zip Text nullable
Vendor_Country Text nullable
Customer_Company_Name Text nullable
Customer_Contact_First_Name Text nullable
Customer_Contact_Last_Name Text nullable
Customer_Contact_Full_Name Text nullable
Customer_Site_Name Text nullable
Customer_Address_Line1 Text nullable
Customer_Address_Line2 Text nullable
Customer_City Text nullable
Customer_State Text nullable
Customer_Zip Text nullable
Customer_Country Text nullable
Customer_Contact_PhoneNbr Text nullable
Customer_Contact_Extension Text nullable
Bill_To_Company_Name Text nullable
Bill_To_Address_Line1 Text nullable
Bill_To_Address_Line2 Text nullable
Bill_To_City Text nullable
Bill_To_State Text nullable
Bill_To_Zip Text nullable
Bill_To_PhoneNbr Text nullable
Bill_To_Country Text nullable
Company_RecID Numeric nullable
Also in 44 reports
Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Portal Invoices Pricing Schedule Project Header Sales Commission Sales Order Service Location Service Summary Service Summary Open Time Unposted Expense Unposted Invoice Warehouse
Company_Address_RecID Numeric nullable
Also in 9 reports
Company Address Company Work Types Contact Invoice Header Invoices Project Header Sales Order Service Location Warehouse
Tax_ID Text nullable
Warehouse_RecID Numeric nullable
Also in 3 reports
Member Warehouse Warehouse Bin
Owner_Level_Name Text nullable
BusGroup Text nullable
PO_SubTotal Numeric nullable
Tax_Total Numeric
Freight_Tax_Total Numeric
PO_Total Numeric nullable
Drop_Shipped Text
My_Company Text nullable
Site_Name Text nullable
Customer_Contact_Email Text nullable
Warehouse_Contact_Email Text nullable
Vendor_Contact_Email Text nullable
Email Text nullable
Currency_Symbol Text nullable