itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data ModelCatalog: XAF
Schema: Views
Label: Trial Balance per Period
This is a read-only view. The XAF 3.2 API may not support changing the data or the Invantive SQL driver for XAF 3.2 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the XAF 3.2 API.
View Columns
The columns of the view TrialBalancePerPeriod are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
ACCDESC |
string(999) |
Description |
|
|
ACCID |
string(240) |
Account ID |
|
|
BALANCE |
decimal |
|
☐ |
|
COMPANY_NAME |
string(1000) |
Company Name |
☐ |
|
FISCAL_YEAR_NUMBER |
string(240) |
Fiscal Year Number |
☑ |
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
OPENING_BALANCE |
decimal |
Opening Balance |
☐ |
|
total_balance |
decimal |
|
☐ |
|
TRANSACTION_PERIODNUMBER |
int64 |
Period Number |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
