FA00701 - Asset Retirement Master WORK
SQL Query Builder
35 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| RETIREMENTINDX | int 0 | |||
| RETIRESEQ | smallint 0 | |||
| RETIREEVENT | int 0 | |||
| ASSETINDEX | int 0 | |||
| ASSETID | char(15) '' | |||
| RETDATESTAMP | datetime '1/1/1900' | |||
| RETTIMESTAMP | datetime '1/1/1900' | |||
| RETIREMENTTYPE | smallint 0 | |||
| RETIREMENTDATE | datetime '1/1/1900' | |||
| RETIREMENTCODE | char(9) '' | |||
| CASHPROCEEDS | numeric(19,5) 0.00 | |||
| Orig_Cash_Proceeds | numeric(19,5) 0.00 | |||
| NONCASHPROCEEDS | numeric(19,5) 0.00 | |||
| Orig_Non_Cash_Proceeds | numeric(19,5) 0.00 | |||
| EXPOFSALE | numeric(19,5) 0.00 | |||
| Orig_Expenses_of_Sale | numeric(19,5) 0.00 | |||
| PARTIALQTY | int 0 | |||
| PARTIALCOST | numeric(19,5) 0.00 | |||
| PARTIALPCT | smallint 0 | |||
| ASSETINDXAFTRET | int 0 | |||
| NOTEINDX | numeric(19,5) 0.00 | |||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) '' | ||
| CURRNIDX | smallint 0 | |||
| XCHGRATE | numeric(19,7) 0.00 | |||
| EXCHDATE | datetime '1/1/1900' | |||
| TIME1 | datetime '1/1/1900' | |||
| EXGTBLID | char(15) '' | |||
| RATETPID | char(15) '' | |||
| RTCLCMTD | smallint 0 | |||
| DENXRATE | numeric(19,7) 0.00 | |||
| MCTRXSTT | smallint 0 | |||
| LASTMNTDDATE | datetime '1/1/1900' | |||
| LASTMNTDTIME | datetime '1/1/1900' | |||
| LASTMNTDUSERID | char(15) '' | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with FA00701. Click "Join" to add to your query.