| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| ASSETINDEX | Asset Index |
Long Integer | 4 | View | |
| PURCHLINESEQ | Purchase Line Sequence |
Long Integer | 4 | View | |
| PURCHDESC | Asset Purchase Description |
String | 42 | View | |
| Acquisition_Cost | Acquisition Cost |
Currency | 10 | View | |
| Orig_Acquisition_Cost | Originating Acquisition Cost |
Currency | 10 | View | |
| VENDORID | Vendor ID |
String | 16 | View | |
| DOCNUMBR | Document Number |
String | 22 | View | |
| DOCDATE | Document Date |
Date | 4 | View | |
| TRXSORCE | TRX Source |
String | 14 | View | |
| ORCTRNUM | Originating Control Number |
String | 22 | View | |
| FA_AP_Post_Index | FA AP Post Index |
Long Integer | 4 | View | |
| PORDNMBR | Purchase Order Number |
String | 22 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| EXCHDATE | Exchange Date |
Date | 4 | View | |
| TIME1 | Time |
Time | 4 | View | |
| EXGTBLID | Exchange Table ID |
String | 16 | View | |
| RATETPID | Rate Type ID |
String | 16 | View | |
| RTCLCMTD | Rate Calculation 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 | |
| LASTMNTDDATE | Last Maintained Date |
Date | 4 | View | |
| LASTMNTDTIME | Last Maintained Time |
Time | 4 | View | |
| LASTMNTDUSERID | Last Maintained User ID |
String | 16 | View |