| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| POPIVCNO | POP Invoice Number |
String | 18 | View | |
| IVCLINNO | Invoice Line Number |
Long Integer | 4 | View | |
| POPRCTNM | POP Receipt Number |
String | 18 | View | |
| RCPTLNNM | Receipt Line Number |
Long Integer | 4 | View | |
| LCLINENUMBER | LC Line Number |
Long Integer | 4 | View | |
| Status | Status |
Integer | 2 | View | |
| QTYINVCD | QTY Invoiced |
Currency | 10 | View | |
| QTYINVRESERVE | QTY Invoice Reserve |
Currency | 10 | View | |
| ORUNTCST | Originating Unit Cost |
Currency | 10 | View | |
| RCPTCOST | Receipt Cost |
Currency | 10 | View | |
| ORCPTCOST | Originating Receipt Cost |
Currency | 10 | View | |
| ACPURTOT | Accrued Purchases Total |
Currency | 10 | View | |
| UPPVTOTL | Unrealized Purchase Price Variance Total |
Currency | 10 | View | |
| PURPVIDX | Purchase Price Variance Index |
Long Integer | 4 | View | |
| PCHRPTCT | Purchase Receipt Cost |
Currency | 10 | View | |
| SPRCPTCT | Split Receipt Cost |
Currency | 10 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| RATECALC | Rate Calc Method |
Integer | 2 | View | |
| DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| Revalue_Inventory | Revalue Inventory |
Boolean | 2 | View | |
| PPVTotal | Purchase Price Variance Total |
Currency | 10 | View |