| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PONUMBER | PO Number |
String | 18 | View | |
| ORD | Ord |
Long Integer | 4 | View | |
| POLNESTA | PO Line Status 1 – New |
Integer | 2 | View | |
| POTYPE | PO Type 1 = Standard |
Integer | 2 | View | |
| ITEMNMBR | Item Number |
String | 32 | View | |
| ITEMDESC | Item Description |
String | 102 | View | |
| VENDORID | Vendor ID |
String | 16 | View | |
| VNDITNUM | Vendor Item Number |
String | 32 | View | |
| VNDITDSC | Vendor Item Description |
String | 102 | View | |
| NONINVEN | Non IV |
Integer | 2 | View | |
| LOCNCODE | Location Code |
String | 12 | View | |
| UOFM | U Of M |
String | 10 | View | |
| UMQTYINB | U Of M QTY In Base |
Currency | 10 | View | |
| QTYORDER | QTY Ordered |
Currency | 10 | View | |
| QTYCANCE | QTY Canceled |
Currency | 10 | View | |
| UNITCOST | Unit Cost |
Currency | 10 | View | |
| EXTDCOST | Extended Cost |
Currency | 10 | View | |
| INVINDX | Inventory Index |
Long Integer | 4 | View | |
| REQDATE | Required Date |
Date | 4 | View | |
| PRMDATE | Promised Date |
Date | 4 | View | |
| PRMSHPDTE | Promised Ship Date |
Date | 4 | View | |
| REQSTDBY | Requested By |
String | 22 | View | |
| COMMNTID | Comment ID |
String | 16 | View | |
| DOCTYPE | Document Type |
Integer | 2 | View | |
| POLNEARY_1 | PO Line Note ID Array[1] |
Currency | 10 | View | |
| POLNEARY_2 | PO Line Note ID Array[2] |
Currency | 10 | View | |
| POLNEARY_3 | PO Line Note ID Array[3] |
Currency | 10 | View | |
| POLNEARY_4 | PO Line Note ID Array[4] |
Currency | 10 | View | |
| POLNEARY_5 | PO Line Note ID Array[5] |
Currency | 10 | View | |
| POLNEARY_6 | PO Line Note ID Array[6] |
Currency | 10 | View | |
| POLNEARY_7 | PO Line Note ID Array[7] |
Currency | 10 | View | |
| POLNEARY_8 | PO Line Note ID Array[8] |
Currency | 10 | View | |
| POLNEARY_9 | PO Line Note ID Array[9] |
Currency | 10 | View | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
| BRKFLD1 | Break Field 1 |
Integer | 2 | View | |
| JOBNUMBR | Job Number |
String | 18 | View | |
| COSTCODE | Cost Code |
String | 28 | View | |
| COSTTYPE | Cost Code Type |
Integer | 2 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| ORUNTCST | Originating Unit Cost |
Currency | 10 | View | |
| OREXTCST | Originating Extended Cost |
Currency | 10 | View | |
| LINEORIGIN | Line Origin |
Integer | 2 | View | |
| FREEONBOARD | Free On Board |
Integer | 2 | View | |
| ODECPLCU | Originating Decimal Places Currency |
Integer | 2 | View | |
| Product_Indicator | Product Indicator |
Integer | 2 | View | |
| Source_Document_Number | Source Document Number |
String | 12 | View | |
| Source_Document_Line_Num | Source Document Line Number |
Integer | 2 | View | |
| RELEASEBYDATE | Release By Date |
Date | 4 | View | |
| Released_Date | Released Date |
Date | 4 | View | |
| Purchase_IV_Item_Taxable | Purchase IV Item Taxable 1 – Taxable |
Integer | 2 | View | |
| Purchase_Item_Tax_Schedu | Purchase Item Tax Schedule ID |
String | 16 | View | |
| Purchase_Site_Tax_Schedu | Purchase Site Tax Schedule ID |
String | 16 | View | |
| PURCHSITETXSCHSRC | Purchase Site Tax Schedule Source |
Integer | 2 | View | |
| BSIVCTTL | Based On Invoice Total |
Boolean | 2 | View | |
| TAXAMNT | Tax Amount |
Currency | 10 | View | |
| ORTAXAMT | Originating Tax Amount |
Currency | 10 | View | |
| BCKTXAMT | Backout Tax Amount |
Currency | 10 | View | |
| OBTAXAMT | Originating Backout Tax Amount |
Currency | 10 | View | |
| Landed_Cost_Group_ID | Landed Cost Group ID |
String | 16 | View | |
| SHIPMTHD | Shipping Method |
String | 16 | View | |
| LineNumber | LineNumber |
Integer | 2 | View | |
| ORIGPRMDATE | Original Promised Date |
Date | 4 | View | |
| FSTRCPTDT | First Receipt Date |
Date | 4 | View | |
| LSTRCPTDT | Last Receipt Date |
Date | 4 | View | |
| RELEASE | Release |
Integer | 2 | View | |
| ADRSCODE | 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 | |
| ADDRSOURCE | Address Source |
Integer | 2 | View | |
| Flags | Flags |
Integer | 2 | View | |
| ProjNum | Project Number |
String | 16 | View | |
| CostCatID | Cost Category ID |
String | 16 | View | |
| ITMTRKOP | Item Tracking Option 1. None |
Integer | 2 | View | |
| VCTNMTHD | Valuation Method 1. FIFO Perpetual |
Integer | 2 | View | |
| Print_Phone_NumberGB | Print Phone Number GB |
Integer | 2 | View |