| FK | 1 | AccountNum | Ledger account | LedgerAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | LedgerAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | AccountNum | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| | 2 | StartDate | Date | TransDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TransDate | | GroupPrompt | | | HelpText | @SYS14005 (Date which the budget amount applies from.) | | Label | | | Mandatory | Yes | | Name | StartDate | | SaveContents | Yes | | Table | LedgerBudget | | Type | Date | | Visible | Yes |
|
| | 3 | EndDate | End | EndDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | LedgerBasicBudget | | ExtendedDataType | EndDate | | GroupPrompt | | | HelpText | @SYS28026 (Last date on which to make a budget transaction in case of periodic reiteration) | | Label | @SYS14401 (End) | | Mandatory | No | | Name | EndDate | | SaveContents | Yes | | Table | LedgerBudget | | Type | Date | | Visible | Yes |
|
| | 4 | FreqCode | Unit | PeriodUnit | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | LedgerBasicBudget | | EnumType | PeriodUnit | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | FreqCode | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| | 5 | Active | Active | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS25088 (Include amount?) | | Label | @SYS14584 (Active) | | Mandatory | No | | Name | Active | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| | 6 | Amount | Amount | AmountCurDebCred | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCurDebCred | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS2817 (Amount by which the line contributes to the budget.) | | Label | @SYS12227 (Amount) | | Mandatory | No | | Name | Amount | | SaveContents | Yes | | Table | LedgerBudget | | Type | Real | | Visible | Yes |
|
| FK | 8 | 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 | LedgerBudget | | Type | String | | Visible | Yes |
|
| | 9 | AutoTrans | Allocated | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS16881 (Is the transaction generated automatically, based on budget allocation?) | | Label | @SYS15031 (Allocated) | | Mandatory | No | | Name | AutoTrans | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | No |
|
| FK | 10 | Currency | Currency | CurrencyCode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CurrencyCode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | Currency | | SaveContents | Yes | | StringSize | 3 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| | 11 | Qty | Quantity | LedgerQty | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | LedgerQty | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS15832 (Specify quantity, if any, for the budgeted amount.) | | Label | | | Mandatory | No | | Name | Qty | | SaveContents | Yes | | Table | LedgerBudget | | Type | Real | | Visible | Yes |
|
| | 12 | Price | Price | AmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS2165 (Price used when budgeting quantities) | | Label | @SYS11865 (Price) | | Mandatory | No | | Name | Price | | SaveContents | Yes | | Table | LedgerBudget | | Type | Real | | Visible | Yes |
|
| | 13 | Stop | Stop | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS7396 (Exclude the current transaction from the allocation?) | | Label | @SYS12348 (Stop) | | Mandatory | No | | Name | Stop | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| FK | 14 | Key | Period key | LedgerAllocateKeyId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | LedgerBasicBudget | | ExtendedDataType | LedgerAllocateKeyId | | GroupPrompt | | | HelpText | @SYS16394 (Allocation key, if any, according to which transaction is allocated.) | | Label | | | Mandatory | No | | Name | Key | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| TR PK | 15 | ExpandId | --- | LedgerBudgetRecId | Integer | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | LedgerBudgetRecId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS1894 (Record ID of transaction that generated the item.) | | Label | | | Mandatory | No | | Name | ExpandId | | SaveContents | Yes | | Table | LedgerBudget | | Type | Integer | | Visible | No |
|
| | 16 | Report | Report | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS10846 (Include transaction when reporting?) | | Label | @SYS15111 (Report) | | Mandatory | No | | Name | Report | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | No |
|
| | 17 | Cov | Cashflow forecast | LedgerAppropriation | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | LedgerAppropriation | | GroupPrompt | | | HelpText | @SYS7656 (Should the current forecast transaction be coverage planned in ledger?) | | Label | @SYS5727 (Cashflow forecast) | | Mandatory | No | | Name | Cov | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| | 18 | CovStatus | Cashflow forecast status | CovStatus | Integer | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | CovStatus | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CovStatus | | SaveContents | Yes | | Table | LedgerBudget | | Type | Integer | | Visible | Yes |
|
| | 19 | Crediting | Crediting | LedgerCrediting | Enum | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | LedgerCrediting | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Crediting | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| | 20 | Freq | Quantity | Periods | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | LedgerBasicBudget | | ExtendedDataType | Periods | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS6752 (How many units is the jump for (per transaction)?) | | Label | @SYS14578 (Quantity) | | Mandatory | No | | Name | Freq | | SaveContents | Yes | | Table | LedgerBudget | | Type | Integer | | Visible | Yes |
|
| FK | 21 | TaxGroup | Sales tax group | TaxGroup | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TaxGroup | | GroupPrompt | | | HelpText | @SYS23385 (Sales tax group, if any, for specification of sales tax on the current budget transaction.) | | Label | | | Mandatory | No | | Name | TaxGroup | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| FK | 22 | ModelNum | Model | BudgetModelHeadId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BudgetModelHeadId | | GroupPrompt | | | HelpText | | | Label | @SYS9923 (Model) | | Mandatory | Yes | | Name | ModelNum | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| | 23 | InventRecId | --- | recId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | Forecast | | ExtendedDataType | recId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | InventRecId | | SaveContents | Yes | | Table | LedgerBudget | | Type | Integer | | Visible | No |
|
| | 24 | InventTableId | --- | tableId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | Forecast | | ExtendedDataType | tableId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | InventTableId | | SaveContents | Yes | | Table | LedgerBudget | | Type | Integer | | Visible | No |
|
| | 25 | AllocateMethod | Method | BudgetAllocateMethod | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | BudgetAllocateMethod | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AllocateMethod | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| FK | 26 | ForecastModelId | Model | ForecastModelId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ForecastModelId | | GroupPrompt | | | HelpText | @SYS26897 (Forecast model transferred from) | | Label | | | Mandatory | No | | Name | ForecastModelId | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| FK | 27 | AssetId | Fixed asset number | AssetId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetId | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|
| | 28 | AssetTransType | Transaction type | AssetTransType | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | AssetTransType | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetTransType | | SaveContents | Yes | | Table | LedgerBudget | | Type | Enum | | Visible | Yes |
|
| FK | 29 | AssetBookId | Value model | AssetBookId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AssetBookId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AssetBookId | | SaveContents | Yes | | StringSize | 10 | | Table | LedgerBudget | | Type | String | | Visible | Yes |
|