Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
TRANSFERINDX | Transfer Index |
Long Integer | 4 | View | |
TRANSFEREVENT | Transfer Event |
Long Integer | 4 | View | |
ASSETINDEX | Asset Index |
Long Integer | 4 | View | |
ASSETID | Asset ID |
String | 16 | View | |
XFRDATESTAMP | Transfer Date Stamp |
Date | 4 | View | |
XFRTIMESTAMP | Transfer Time Stamp |
Time | 4 | View | |
TRANSFERSEQ | Transfer Sequence |
Integer | 2 | View | |
TRANSFERDATE | FA Transfer Date |
Date | 4 | View | |
FROMASSETINDX | From Asset Index |
Long Integer | 4 | View | |
FROMASSETID | From Asset ID |
String | 16 | View | |
FROMSTRUC | From Structure ID |
String | 32 | View | |
FROMLOC | From Location ID |
String | 16 | View | |
From_Physical_LocationID | From Physical Location ID |
String | 16 | View | |
From_Master_Asset_ID | From Master Asset ID |
String | 20 | View | |
FROMDEPREXPACCTINDX | From Depreciation Expense Account Index |
Long Integer | 4 | View | |
FROMDEPRRESVACCTINDX | From Depreciation Reserve Account Index |
Long Integer | 4 | View | |
FROMPRYRDEPRACCTINDX | From Prior Year Depreciation Account Index |
Long Integer | 4 | View | |
FROMASSETCOSTACCTINDX | From Asset Cost Account Index |
Long Integer | 4 | View | |
FROMPROCEEDSACCTINDX | From Proceeds Account Index |
Long Integer | 4 | View | |
FROMRECGAINLOSSACCTINDX | From Recognized Gain Loss Account Index |
Long Integer | 4 | View | |
FROMNONRECGAINLOSSACCTINDX | From Non Recognized Gain Loss Account Index |
Long Integer | 4 | View | |
FROMCLEARACCTINDX | From Clearing Account Index |
Long Integer | 4 | View | |
PARTIALQTY | Partial Quantity |
Long Integer | 4 | View | |
PARTIALCOST | Partial Cost |
Currency | 10 | View | |
PARTIALPCT | Partial Percentage |
Integer | 2 | View | |
TOASSETINDX | To Asset Index |
Long Integer | 4 | View | |
TOASSETID | To Asset ID |
String | 16 | View | |
TOSTRUC | To Structure ID |
String | 32 | View | |
TOLOC | To Location ID |
String | 16 | View | |
To_Physical_Location_ID | To Physical Location ID |
String | 16 | View | |
To_Master_Asset_ID | To Master Asset ID |
String | 20 | View | |
TODEPREXPACCTINDX | To Depreciation Expense Account Index |
Long Integer | 4 | View | |
TODEPRRESVACCTINDX | To Depreciation Reserve Account Index |
Long Integer | 4 | View | |
TOPRYRDEPRACCTINDX | To Prior Year Depreciation Account Index |
Long Integer | 4 | View | |
TOASSETCOSTACCTINDX | To Asset Cost Account Index |
Long Integer | 4 | View | |
TOPROCEEDSACCTINDX | To Proceeds Account Index |
Long Integer | 4 | View | |
TORECGAINLOSSACCTINDX | To Recognized Gain Loss Account Index |
Long Integer | 4 | View | |
TONONRECGAINLOSSACCTINDX | To Non Recognized Gain Loss Account Index |
Long Integer | 4 | View | |
TOCLEARACCTINDX | To Clearing Account Index |
Long Integer | 4 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
LASTMNTDDATE | Last Maintained Date |
Date | 4 | View | |
LASTMNTDTIME | Last Maintained Time |
Time | 4 | View | |
LASTMNTDUSERID | Last Maintained User ID |
String | 16 | View | |
RETIREEVENT | Retirement Event |
Long Integer | 4 | View | |
ALIAS | Alias |
Integer | 2 | View | |
DSTCOMID | Destination Company ID |
String | 6 | View | |
TOCLASSID | To Class ID |
String | 16 | View |