| 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 |