| TR FK | 1 | AssetId | Fixed asset number | AssetId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| | 2 | Txt | Transaction text | LedgerJournalTransTxt | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | LedgerJournalTransTxt | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Txt | | SaveContents | Yes | | StringSize | 30 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| | 3 | TransDate | Transaction date. | AssetTransDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetTransDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | TransDate | | SaveContents | Yes | | Table | AssetTrans | | Type | Date | | Visible | Yes |
|
| FK | 4 | Dimension | Department | Dimension | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Dimension | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Dimension | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| | 5 | TransType | Transaction type | AssetTransType | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | AssetTransType | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | TransType | | SaveContents | Yes | | Table | AssetTrans | | Type | Enum | | Visible | Yes |
|
| | 6 | Voucher | Voucher | Voucher | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Voucher | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Voucher | | SaveContents | Yes | | StringSize | 20 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| | 7 | AmountCur | Amount currency | AmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AmountCur | | SaveContents | Yes | | Table | AssetTrans | | Type | Real | | Visible | Yes |
|
| FK | 8 | ApprovedBy | Approved by | EmplId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | EmplId | | GroupPrompt | | | HelpText | @SYS17308 (Employee who approves the transaction) | | Label | @SYS27489 (Approved by) | | Mandatory | No | | Name | ApprovedBy | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| FK | 9 | CurrencyCode | Currency | CurrencyCode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CurrencyCode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CurrencyCode | | SaveContents | Yes | | StringSize | 3 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| | 10 | AmountMST | Amount | AssetAmount | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetAmount | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AmountMST | | SaveContents | Yes | | Table | AssetTrans | | Type | Real | | Visible | Yes |
|
| FK | 11 | PostingProfile | Posting profile | AssetPostingProfile | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetPostingProfile | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PostingProfile | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| FK | 12 | AssetGroup | Fixed asset group | AssetGroupId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetGroupId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetGroup | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| TR FK | 13 | BookId | Value model | AssetBookId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetBookId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | BookId | | SaveContents | Yes | | StringSize | 10 | | Table | AssetTrans | | Type | String | | Visible | Yes |
|
| | 14 | ConsumptionQty | Consumption unit | AssetConsumption | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetConsumption | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ConsumptionQty | | SaveContents | Yes | | Table | AssetTrans | | Type | Real | | Visible | Yes |
|
| | 15 | RevaluationDone | Revaluation executed? | AssetRevaluationDone | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | AssetRevaluationDone | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RevaluationDone | | SaveContents | Yes | | Table | AssetTrans | | Type | Enum | | Visible | Yes |
|
| | 16 | RevaluationTrans | Revaluation transaction | AssetRevaluationTrans | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | AssetRevaluationTrans | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RevaluationTrans | | SaveContents | Yes | | Table | AssetTrans | | Type | Enum | | Visible | Yes |
|
| | 17 | RevaluationAmount | Revaluation amount | AssetRevaluationAmount | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetRevaluationAmount | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RevaluationAmount | | SaveContents | Yes | | Table | AssetTrans | | Type | Real | | Visible | Yes |
|
| | 18 | RevaluedTransID | Reference | RefRecId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | Asset | | ExtendedDataType | RefRecId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RevaluedTransID | | SaveContents | Yes | | Table | AssetTrans | | Type | Integer | | Visible | No |
|
| | 19 | Section179Trans | Section 179 write-off | AssetSection179Trans | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | AssetSection179Trans | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Section179Trans | | SaveContents | Yes | | Table | AssetTrans | | Type | Enum | | Visible | Yes |
|
| | 20 | ReserveTransferDone | Transfer from reserve executed? | AssetReserveTransferDone | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | AssetReserveTransferDone | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ReserveTransferDone | | SaveContents | Yes | | Table | AssetTrans | | Type | Enum | | Visible | Yes |
|
| | 21 | ReserveTransId | Reference | RefRecId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | Asset | | ExtendedDataType | RefRecId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ReserveTransId | | SaveContents | Yes | | Table | AssetTrans | | Type | Integer | | Visible | No |
|