| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| POPRCTNM | POP Receipt Number |
String | 18 | View | |
| RCPTLNNM | Receipt Line Number |
Long Integer | 4 | View | |
| LCLINENUMBER | LC Line Number |
Long Integer | 4 | View | |
| LCHDRNUMBER | LC Header Number |
Long Integer | 4 | View | |
| Landed_Cost_ID | Landed Cost ID |
String | 16 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| Long_Description | Long Description |
String | 52 | View | |
| Landed_Cost_Type | Landed Cost Type |
Integer | 2 | View | |
| VENDORID | Vendor ID |
String | 16 | View | |
| Vendor_Note_Index | Vendor Note Index |
Currency | 10 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| Currency_Note_Index | Currency Note Index |
Currency | 10 | 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 | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| ODECPLCU | Originating Decimal Places Currency |
Integer | 2 | View | |
| ACPURIDX | Accrued Purchases Index |
Long Integer | 4 | View | |
| DistRef | Distribution Reference |
String | 32 | View | |
| PURPVIDX | Purchase Price Variance Index |
Long Integer | 4 | View | |
| Invoice_Match | Invoice Match |
Boolean | 2 | View | |
| CALCMTHD | Calculation Method |
Integer | 2 | View | |
| Orig_Landed_Cost_Amount | Originating Landed Cost Amount |
Currency | 10 | View | |
| Calculation_Percentage | Calculation Percentage |
Long Integer | 4 | View | |
| Total_Landed_Cost_Amount | Total Landed Cost Amount |
Currency | 10 | View | |
| Orig_TotalLandedCostAmt | Originating Total Landed Cost Amount |
Currency | 10 | View | |
| Landed_Cost_Warnings | Landed Cost Warnings |
Integer | 2 | View | |
| Apportion_By | Apportion By |
Integer | 2 | View | |
| Orig_UnapportionedAmount | Originating Unapportioned Amount |
Currency | 10 | View | |
| INVINDX | Inventory Index |
Long Integer | 4 | View |