| POTYPE | smallint | No | PO Type - 1 = Standard, 2 = Drop Ship, 3 = Blanket, 4 = Drop Ship Blanket | IN |
| PONUMBER | char(17) | No | PO Number - Unique identifier for the PO | IN |
| DOCDATE | datetime | Yes | Document Date Date of the PO Required for PA | IN |
| VENDORID | char(15) | No | Vendor ID - ID of the vendor you're purchasing items from | IN |
| LOCNCODE | char(10) | No | Location Code - ID of the site for which you're purchasing the items | IN |
| VNDITNUM | char(30) | No | Vendor Item Number | IN |
| ITEMNMBR | char(30) | No | Item Number | IN |
| QUANTITY | numeric(19,5) | No | Quantity - Total Quantity for line Item | IN |
| QTYCANCE | numeric(19,5) | No | Quantity Cancelled - Quantity that is to be canceled | IN |
| FREEONBOARD | smallint | No | Terms of sale - identify point at which ownership of goods passes to buyer. 1=None,2=Origin,3=Destination | IN |
| REQSTDBY | char(20) | No | Requested by - Person or department who requested this line item | IN |
| COMMNTID | char(15) | No | Comment ID | IN |
| COMMENT_1 | char(50) | No | Comment part 1 | IN |
| COMMENT_2 | char(50) | No | Comment part 2 | IN |
| COMMENT_3 | char(50) | No | Comment part 3 | IN |
| COMMENT_4 | char(50) | No | Comment part 4 | IN |
| REQDATE | datetime | Yes | Required date by which the items must be received | IN |
| RELEASEBYDATE | datetime | Yes | Date the purchase order line needs to be released to the vendor to receive the item by the Required Date | IN |
| PRMDATE | datetime | No | Date the vendor promised you would receive merchandise or services | IN |
| PRMSHPDTE | datetime | No | Date the vendor promised the merchandise would be shipped | IN |
| NONINVEN | smallint | No | 0=Inventory item, 1=Non Inventory item | IN |
| IVIVINDX | int | No | Inventory Account Index | IN |
| InventoryAccount | varchar(75) | No | Inventory Account Number String | IN |
| ITEMDESC | char(100) | No | Item Description for the line item | IN |
| UNITCOST | numeric(19,5) | No | Unit Cost for the item in the specified unit of measure | IN |
| VNDITDSC | char(100) | No | Vendor Item Description for the line item | IN |
| UOFM | char(8) | No | Unit of Measure in which this item is being purchased | IN |
| Purchase_IV_Item_Taxable | smallint | No | Purchase Inventory Item Taxable 1=Taxable,2=Nontaxable,3=Base on Vendor | IN |
| Purchase_Item_Tax_Schedu | char(15) | No | Purchase Item Tax Schedule - blank unless @I_vPurchase_IV_Item_Taxable = 1 | IN |
| Purchase_Site_Tax_Schedu | char(15) | No | Purchase Site Tax Schedule | IN |
| BSIVCTTL | smallint | No | Based on invoice total | IN |
| TAXAMNT | numeric(19,5) | No | Tax Amount | IN |
| BCKTXAMT | numeric(19,5) | No | Backout Tax Amount | IN |
| Landed_Cost_Group_ID | char(15) | No | Landed Cost Group ID | IN |
| PLNNDSPPLID | smallint | No | Planned Supplier ID | IN |
| SHIPMTHD | char(15) | No | Shipping Method | IN |
| BackoutTradeDiscTax | numeric(19,5) | No | Backout Trade Discount Tax Amount | IN |
| POLNESTA | smallint | No | PO Line Status - (valid: 1=new, 2=released 3=change order, 4=received, 5=closed, 6 =cancelled) | IN |
| CMMTTEXT | varchar(500) | No | Comment Text; only use if not using @I_vCOMMENT_1 thu @I_vCOMMENT_4 | IN |
| ORD | int | No | Sequence number used to track each item. Must be unique per PO | IN |
| CUSTNMBR | char(15) | Yes | Customer Number | IN |
| ADRSCODE | char(15) | No | Address Code | IN |
| CMPNYNAM | char(64) | No | Name | IN |
| CONTACT | char(60) | No | Contact | IN |
| ADDRESS1 | char(60) | No | Address Line 1 | IN |
| ADDRESS2 | char(60) | No | Address Line 2 | IN |
| ADDRESS3 | char(60) | No | Address Line 3 | IN |
| CITY | char(35) | No | City | IN |
| STATE | char(29) | No | State | IN |
| ZIPCODE | char(10) | No | Zip Code | IN |
| CCode | char(6) | No | Country Code | IN |
| COUNTRY | char(60) | No | Country | IN |
| PHONE1 | char(21) | No | Phone 1 | IN |
| PHONE2 | char(21) | No | Phone 2 | IN |
| PHONE3 | char(21) | No | Phone 3 | IN |
| FAX | char(21) | No | Fax | IN |
| Print_Phone_NumberGB | smallint | No | Print_Phone_NumberGB (0-4 valid) used on drop ship PO's for 12.0 | IN |
| CURNCYID | char(15) | No | Currency ID | IN |
| ProjNum | char(15) | No | Project Number, for use with Project Accounting only | IN |
| CostCatID | char(15) | No | Cost Category ID, for use with Project Accounting only | IN |
| LineNumber | int | No | Line Number, Blanket PO's | IN |
| UpdateIfExists | smallint | No | Used to Add/Modify existing documents - 1=Add/Modify - partial updates allowed | IN |
| NOTETEXT | varchar(8000) | No | Notes field | IN |
| RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true then populates Requester shadow table | IN |
| USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
| USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
| ErrorState | int | No | Error Code | INOUT |
| oErrString | varchar(255) | No | List of errors encountered | INOUT |