| POTYPE | smallint | Yes | PO Type 1=Standard, 2=Drop Ship | IN |
| PONUMBER | char(17) | Yes | PO Number Unique identifier for the PO | IN |
| VENDORID | char(15) | Yes | Vendor ID ID of the Vendor you are purchasing from | IN |
| VENDNAME | char(64) | No | Vendor Name Name of the Vendor | IN |
| DOCDATE | datetime | Yes | Document Date Date of the PO | IN |
| BUYERID | char(15) | No | Buyer Id Buyer who is responsible for the purchase order | IN |
| ALLOWSOCMTS | tinyint | No | Allow Sales Commitments 1=Allow PO to be committed to SOP line items | IN |
| TRDISAMT | numeric(19,5) | No | Trade Discount Amount | IN |
| FRTAMNT | numeric(19,5) | No | Freight Amount | IN |
| MSCCHAMT | numeric(19,5) | No | Miscellaneous Charge Amount | IN |
| TAXAMNT | numeric(19,5) | No | Tax Amount | IN |
| SUBTOTAL | numeric(19,5) | No | Subtotal = Total before taxes | IN |
| CUSTNMBR | char(15) | No | Customer ID to which the vendor is shipping the items on a drop ship | IN |
| PRSTADCD | char(15) | No | Primary Ship to Address Code address to which the order is being sent | IN |
| CMPNYNAM | char(64) | No | Company Name associated with the Ship to Address ID | IN |
| CONTACT | char(60) | No | Contact person for the Ship to Address ID | IN |
| ADDRESS1 | char(60) | No | Address line 1 for the Ship to Address ID | IN |
| ADDRESS2 | char(60) | No | Address line 2 for the Ship to Address ID | IN |
| ADDRESS3 | char(60) | No | Address line 3 for the Ship to Address ID | IN |
| CITY | char(35) | No | City for the Ship to Address ID | IN |
| STATE | char(29) | No | State for the Ship to Address ID | IN |
| ZIPCODE | char(10) | No | Zip code for the Ship to Address ID | IN |
| CCode | char(6) | No | Country Code for the Ship to Address ID | IN |
| COUNTRY | char(60) | No | Country for the Ship to Address ID | IN |
| PHONE1 | char(21) | No | Phone number 1 for the Ship to Address ID | IN |
| PHONE2 | char(21) | No | Phone number 2 for the Ship to Address ID | IN |
| PHONE3 | char(21) | No | Phone number 3 for the Ship to Address ID | IN |
| FAX | char(21) | No | Fax number for the Ship to Address ID | IN |
| Print_Phone_NumberGB | smallint | No | Print_Phone_NumberGB valid 0-4 on POTYPE 2,4 | IN |
| VADCDPAD | char(15) | No | Vendor Address Code Purchase Address ID | IN |
| PURCHCMPNYNAM | char(64) | No | Purchase Company Name | IN |
| PURCHCONTACT | char(60) | No | Purchase Contact | IN |
| PURCHADDRESS1 | char(60) | No | Purchase Address 1 | IN |
| PURCHADDRESS2 | char(60) | No | Purchase Address 2 | IN |
| PURCHADDRESS3 | char(60) | No | Purchase Address 3 | IN |
| PURCHCITY | char(35) | No | Purchase City | IN |
| PURCHSTATE | char(29) | No | Purchase State | IN |
| PURCHZIPCODE | char(10) | No | Purchase Zip Code | IN |
| PURCHCCode | char(6) | No | Purchase Country Code | IN |
| PURCHCOUNTRY | char(60) | No | Purchase Country | IN |
| PURCHPHONE1 | char(21) | No | Purchase Phone 1 | IN |
| PURCHPHONE2 | char(21) | No | Purchase Phone 2 | IN |
| PURCHPHONE3 | char(21) | No | Purchase Phone 3 | IN |
| PURCHFAX | char(21) | No | Purchase Fax | IN |
| PRBTADCD | char(15) | No | Bill to Address ID | IN |
| SHIPMTHD | char(15) | No | Shipping method | IN |
| PYMTRMID | char(20) | No | Payment term ID extended to your company by the vendor | IN |
| DSCPCTAM | numeric(19,5) | No | Discount Percent Amount | IN |
| DSCDLRAM | numeric(19,5) | No | Discount Dollar Amount | IN |
| DISAMTAV | numeric(19,5) | No | Discount Available Amount | IN |
| DUEDATE | datetime | No | Due Date | IN |
| DISCDATE | datetime | No | Discount Date | IN |
| TXRGNNUM | char(25) | No | Vendor's tax registration number | IN |
| CONFIRM1 | char(20) | No | Confirm 1 Name of the person the order should be approved by | 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 |
| HOLD | tinyint | No | Hold Flag 0 = not on hold, 1 = on hold | IN |
| TAXSCHID | char(15) | No | Tax Schedule ID | IN |
| Purchase_Freight_Taxable | smallint | No | Purchase Freight Taxable 1=Taxable, 2=NonTaxable, 3=Based on Vendor | IN |
| Purchase_Misc_Taxable | smallint | No | Purchase Misc Taxable 1=Taxable, 2=NonTaxable, 3=Based on Vendor | IN |
| FRTSCHID | char(15) | No | Freight Tax Schedule ID | IN |
| MSCSCHID | char(15) | No | Misc Tax Schedule ID | IN |
| FRTTXAMT | numeric(19,5) | No | Freight Tax Amount | IN |
| MSCTXAMT | numeric(19,5) | No | Misc Tax Amount | IN |
| BCKTXAMT | numeric(19,5) | No | Back Tax Amount | IN |
| BackoutFreightTaxAmt | numeric(19,5) | No | Backout Freight Tax Amount | IN |
| BackoutMiscTaxAmt | numeric(19,5) | No | Backout Misc Tax Amount | IN |
| BackoutTradeDiscTax | numeric(19,5) | No | Backout Trade Disc Tax Amount | IN |
| USINGHEADERLEVELTAXES | smallint | No | Using Header Level Taxes Flag 0 = no (default), 1 = yes | IN |
| CURNCYID | char(15) | No | Currency ID | IN |
| XCHGRATE | numeric(19,5) | No | Exchange Rate | IN |
| RATETPID | char(15) | No | Rate Type ID | IN |
| EXPNDATE | datetime | No | Expiration Date | IN |
| EXCHDATE | datetime | No | Exchange Date | IN |
| EXGTBDSC | char(30) | No | Exchange ID Desc. | IN |
| EXTBLSRC | char(50) | No | Exchange Rate Source | IN |
| RATEEXPR | smallint | No | Rate Expiration 1=Daily, 2=Weekly, 3=Bi-Weekly, 4=Semi-Monthly, 5=Monthly, | IN |
| DYSTINCR | smallint | No | Days to Increment | IN |
| RATEVARC | numeric(19,5) | No | Rate Variance | IN |
| TRXDTDEF | smallint | No | Trx Date Default 0=Exact Date, 1=Next Date, 2=Previous Date | IN |
| RTCLCMTD | smallint | No | Rate Calc. Method The breakdown is: 0=Multiply, 1= Divide | IN |
| PRVDSLMT | smallint | No | Previous Days Limits Added for Multi-Currency - MC40300 | IN |
| DATELMTS | smallint | No | Date Limits 0=Unlimited, 1=Limited | IN |
| TIME1 | datetime | No | Time 1 | IN |
| USERID | char(15) | No | User to Enter (USER2ENT) | IN |
| POSTATUS | 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 |
| PRMDATE | datetime | No | Promise Date | IN |
| PRMSHPDTE | datetime | No | Promise Ship Date | IN |
| REQDATE | datetime | Yes | Required Date | IN |
| CONTENDDTE | datetime | No | Contract Expiration Date | IN |
| CNTRLBLKTBY | smallint | No | Control Blanket By 0=Quantity, 1=Value | IN |
| REQTNDT | datetime | No | Requisition Date | 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 | List of errors encountered | INOUT |
| oErrString | varchar(255) | No | List of errors encountered | INOUT |