FA00701 - Asset Retirement Master WORK
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| RETIREMENTINDX | Retirement Index |
Long Integer | 4 | View | |
| RETIRESEQ | Retirement Sequence |
Integer | 2 | View | |
| RETIREEVENT | Retirement Event |
Long Integer | 4 | View | |
| ASSETINDEX | Asset Index |
Long Integer | 4 | View | |
| ASSETID | Asset ID |
String | 16 | View | |
| RETDATESTAMP | Retirement Date Stamp |
Date | 4 | View | |
| RETTIMESTAMP | Retirement Time Stamp |
Time | 4 | View | |
| RETIREMENTTYPE | Retirement Type |
Integer | 2 | View | |
| RETIREMENTDATE | Retirement Date |
Date | 4 | View | |
| RETIREMENTCODE | Retirement Code |
String | 10 | View | |
| CASHPROCEEDS | Cash Proceeds |
Currency | 10 | View | |
| Orig_Cash_Proceeds | Originating Cash Proceeds |
Currency | 10 | View | |
| NONCASHPROCEEDS | Non Cash Proceeds |
Currency | 10 | View | |
| Orig_Non_Cash_Proceeds | Originating Non Cash Proceeds |
Currency | 10 | View | |
| EXPOFSALE | Expenses of Sale |
Currency | 10 | View | |
| Orig_Expenses_of_Sale | Originating Expenses of Sale |
Currency | 10 | View | |
| PARTIALQTY | Partial Quantity |
Long Integer | 4 | View | |
| PARTIALCOST | Partial Cost |
Currency | 10 | View | |
| PARTIALPCT | Partial Percentage |
Integer | 2 | View | |
| ASSETINDXAFTRET | Asset Index After Retire |
Long Integer | 4 | View | |
| NOTEINDX | Note Index |
Currency | 10 | 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 |