| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| PONUMBER | PO Number  | 
									String | 18 | View | |
| POSTATUS | PO Status 1 – New   | 
									Integer | 2 | View | |
| STATGRP | Status Group  | 
									Integer | 2 | View | |
| POTYPE | PO Type 1 = Standard   | 
									Integer | 2 | View | |
| USER2ENT | User To Enter  | 
									String | 16 | View | |
| CONFIRM1 | Confirm With  | 
									String | 22 | View | |
| DOCDATE | Document Date  | 
									Date | 4 | View | |
| LSTEDTDT | Last Edit Date  | 
									Date | 4 | View | |
| LSTPRTDT | Last Printed Date  | 
									Date | 4 | View | |
| PRMDATE | Promised Date  | 
									Date | 4 | View | |
| PRMSHPDTE | Promised Ship Date  | 
									Date | 4 | View | |
| REQDATE | Required Date  | 
									Date | 4 | View | |
| REQTNDT | Requisition Date  | 
									Date | 4 | View | |
| SHIPMTHD | Shipping Method  | 
									String | 16 | View | |
| TXRGNNUM | Tax Registration Number  | 
									String | 26 | View | |
| REMSUBTO | Remaining Subtotal  | 
									Currency | 10 | View | |
| SUBTOTAL | Subtotal  | 
									Currency | 10 | View | |
| TRDISAMT | Trade Discount Amount  | 
									Currency | 10 | View | |
| TRDPCTPR | Trade Discount Percent (Precise)  | 
									Currency (Variable) | 12 | View | |
| FRTAMNT | Freight Amount  | 
									Currency | 10 | View | |
| MSCCHAMT | Misc Charges Amount  | 
									Currency | 10 | View | |
| TAXAMNT | Tax Amount  | 
									Currency | 10 | View | |
| VENDORID | Vendor ID  | 
									String | 16 | View | |
| VENDNAME | Vendor Name  | 
									String | 66 | View | |
| MINORDER | Minimum Order  | 
									Currency | 10 | View | |
| VADCDPAD | Vendor Address Code - Purchase Address  | 
									String | 16 | View | |
| CMPANYID | Company ID  | 
									Integer | 2 | View | |
| PRBTADCD | Primary Billto Address Code  | 
									String | 16 | View | |
| PRSTADCD | Primary Shipto Address Code  | 
									String | 16 | View | |
| CMPNYNAM | Company Name  | 
									String | 66 | View | |
| CONTACT | Contact  | 
									String | 62 | View | |
| ADDRESS1 | Address 1  | 
									String | 62 | View | |
| ADDRESS2 | Address 2  | 
									String | 62 | View | |
| ADDRESS3 | Address 3  | 
									String | 62 | View | |
| CITY | City  | 
									String | 36 | View | |
| STATE | State  | 
									String | 30 | View | |
| ZIPCODE | Zip Code  | 
									String | 12 | View | |
| CCode | Country Code  | 
									String | 8 | View | |
| COUNTRY | Country  | 
									String | 62 | View | |
| PHONE1 | Phone 1  | 
									String | 22 | View | |
| PHONE2 | Phone 2  | 
									String | 22 | View | |
| PHONE3 | Phone 3  | 
									String | 22 | View | |
| FAX | Fax  | 
									String | 22 | View | |
| PYMTRMID | Payment Terms ID  | 
									String | 22 | View | |
| DSCDLRAM | Discount Dollar Amount  | 
									Currency | 10 | View | |
| DSCPCTAM | Discount Percent Amount  | 
									Integer | 2 | View | |
| DISAMTAV | Discount Amount Available  | 
									Currency | 10 | View | |
| DISCDATE | Discount Date  | 
									Date | 4 | View | |
| DUEDATE | Due Date  | 
									Date | 4 | View | |
| CUSTNMBR | Customer Number  | 
									String | 16 | View | |
| TIMESPRT | Times Printed  | 
									Integer | 2 | View | |
| CREATDDT | Created Date  | 
									Date | 4 | View | |
| MODIFDT | Modified Date  | 
									Date | 4 | View | |
| PONOTIDS_1 | PO Note ID Array[1]  | 
									Currency | 10 | View | |
| PONOTIDS_2 | PO Note ID Array[2]  | 
									Currency | 10 | View | |
| PONOTIDS_3 | PO Note ID Array[3]  | 
									Currency | 10 | View | |
| PONOTIDS_4 | PO Note ID Array[4]  | 
									Currency | 10 | View | |
| PONOTIDS_5 | PO Note ID Array[5]  | 
									Currency | 10 | View | |
| PONOTIDS_6 | PO Note ID Array[6]  | 
									Currency | 10 | View | |
| PONOTIDS_7 | PO Note ID Array[7]  | 
									Currency | 10 | View | |
| PONOTIDS_8 | PO Note ID Array[8]  | 
									Currency | 10 | View | |
| PONOTIDS_9 | PO Note ID Array[9]  | 
									Currency | 10 | View | |
| PONOTIDS_10 | PO Note ID Array[10]  | 
									Currency | 10 | View | |
| PONOTIDS_11 | PO Note ID Array[11]  | 
									Currency | 10 | View | |
| PONOTIDS_12 | PO Note ID Array[12]  | 
									Currency | 10 | View | |
| PONOTIDS_13 | PO Note ID Array[13]  | 
									Currency | 10 | View | |
| PONOTIDS_14 | PO Note ID Array[14]  | 
									Currency | 10 | View | |
| PONOTIDS_15 | PO Note ID Array[15]  | 
									Currency | 10 | View | |
| TRXSORCE | TRX Source  | 
									String | 14 | View | |
| COMMNTID | Comment ID  | 
									String | 16 | View | |
| CANCSUB | Canceled Subtotal  | 
									Currency | 10 | View | |
| CURNCYID | Currency ID  | 
									String | 16 | View | |
| CURRNIDX | Currency Index  | 
									Integer | 2 | View | |
| RATETPID | Rate Type ID  | 
									String | 16 | View | |
| EXGTBLID | Exchange Table ID  | 
									String | 16 | View | |
| XCHGRATE | Exchange Rate  | 
									Currency (Variable) | 10 | View | |
| EXCHDATE | Exchange Date  | 
									Date | 4 | View | |
| TIME1 | Time  | 
									Time | 4 | View | |
| RATECALC | Rate Calc Method  | 
									Integer | 2 | View | |
| DENXRATE | Denomination Exchange Rate  | 
									Currency (Variable) | 10 | View | |
| MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled.   | 
									Integer | 2 | View | |
| OREMSUBT | Originating Remaining Subtotal  | 
									Currency | 10 | View | |
| ORSUBTOT | Originating Subtotal  | 
									Currency | 10 | View | |
| Originating_Canceled_Sub | Originating Canceled Subtotal  | 
									Currency | 10 | View | |
| ORTDISAM | Originating Trade Discount Amount  | 
									Currency | 10 | View | |
| ORFRTAMT | Originating Freight Amount  | 
									Currency | 10 | View | |
| OMISCAMT | Originating Misc Charges Amount  | 
									Currency | 10 | View | |
| ORTAXAMT | Originating Tax Amount  | 
									Currency | 10 | View | |
| ORDDLRAT | Originating Discount Dollar Amount  | 
									Currency | 10 | View | |
| ODISAMTAV | Originating Discount Amount Available  | 
									Currency | 10 | View | |
| BUYERID | Buyer ID  | 
									String | 16 | View | |
| ALLOWSOCMTS | Allow SO Commitments  | 
									Boolean | 2 | View | |
| DISGRPER | Discount Grace Period  | 
									Integer | 2 | View | |
| DUEGRPER | Due Date Grace Period  | 
									Integer | 2 | View | |
| Revision_Number | Revision Number  | 
									Integer | 2 | View | |
| TAXSCHID | Tax Schedule ID  | 
									String | 16 | View | |
| TXSCHSRC | Tax Schedule Source  | 
									Integer | 2 | View | |
| BSIVCTTL | Based On Invoice Total  | 
									Boolean | 2 | View | |
| Purchase_Freight_Taxable | Purchase Freight Taxable  | 
									Integer | 2 | View | |
| Purchase_Misc_Taxable | Purchase Misc Taxable  | 
									Integer | 2 | View | |
| FRTSCHID | Freight Schedule ID  | 
									String | 16 | View | |
| MSCSCHID | Misc Schedule ID  | 
									String | 16 | View | |
| FRTTXAMT | Freight Tax Amount  | 
									Currency | 10 | View | |
| ORFRTTAX | Originating Freight Tax Amount  | 
									Currency | 10 | View | |
| MSCTXAMT | Misc Tax Amount  | 
									Currency | 10 | View | |
| ORMSCTAX | Originating Misc Tax Amount  | 
									Currency | 10 | View | |
| BCKTXAMT | Backout Tax Amount  | 
									Currency | 10 | View | |
| OBTAXAMT | Originating Backout Tax Amount  | 
									Currency | 10 | View | |
| BackoutFreightTaxAmt | Backout Freight Tax Amount  | 
									Currency | 10 | View | |
| OrigBackoutFreightTaxAmt | Originating Backout Freight Tax Amount  | 
									Currency | 10 | View | |
| BackoutMiscTaxAmt | Backout Misc Tax Amount  | 
									Currency | 10 | View | |
| OrigBackoutMiscTaxAmt | Originating Backout Misc Tax Amount  | 
									Currency | 10 | View | |
| Flags | Flags  | 
									Integer | 2 | View | |
| POPCONTNUM | POP Contract Number  | 
									String | 22 | View | |
| CONTENDDTE | Contract End Date  | 
									Date | 4 | View | |
| CNTRLBLKTBY | Control Blanket By  | 
									Integer | 2 | View | |
| PURCHCMPNYNAM | Purchase Company Name  | 
									String | 66 | View | |
| PURCHCONTACT | Purchase Contact  | 
									String | 62 | View | |
| PURCHADDRESS1 | Purchase Address 1  | 
									String | 62 | View | |
| PURCHADDRESS2 | Purchase Address 2  | 
									String | 62 | View | |
| PURCHADDRESS3 | Purchase Address 3  | 
									String | 62 | View | |
| PURCHCITY | Purchase City  | 
									String | 36 | View | |
| PURCHSTATE | Purchase State  | 
									String | 30 | View | |
| PURCHZIPCODE | Purchase Zip Code  | 
									String | 12 | View | |
| PURCHCCode | Purchase Country Code  | 
									String | 8 | View | |
| PURCHCOUNTRY | Purchase Country  | 
									String | 62 | View | |
| PURCHPHONE1 | Purchase Phone 1  | 
									String | 22 | View | |
| PURCHPHONE2 | Purchase Phone 2  | 
									String | 22 | View | |
| PURCHPHONE3 | Purchase Phone 3  | 
									String | 22 | View | |
| PURCHFAX | Purchase Fax  | 
									String | 22 | View | |
| BLNKTLINEEXTQTYSUM | Total Blanket Line Ext Qty  | 
									Currency | 10 | View | |
| Workflow_Approval_Status | Workflow Approval Status 1 – Not Submitted   | 
									Integer | 2 | View | |
| Workflow_Priority | Workflow Priority  | 
									Integer | 2 | View | |
| Print_Phone_NumberGB | Print Phone Number GB  | 
									Integer | 2 | View | |
| PrepaymentAmount | Prepayment Amount  | 
									Currency | 10 | View | |
| OriginatingPrepaymentAmt | Originating Prepayment Amount  | 
									Currency | 10 | View |