SubledgerOpeningBalanceLines |
Catalog: XAF
The data in this table is partitioned per value of the COMPANY_NAME column.
Retrieve: true
Topic: auditfile
Base XPath: /xaf:auditfile/xaf:company/xaf:openingBalance
XPath: /xaf:obSubledgers/xaf:obSubledger/xaf:obSbLine
Table Columns
The columns of the table SubledgerOpeningBalanceLines are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AMNT |
decimal |
|
|
|
AMNTTP |
string(240) |
|
|
|
ARTGRPID |
string(240) |
|
|
|
AUDIT_FILE_VERSION |
string(240) |
|
☐ |
|
COMPANY_ADDRESS |
string(240) |
|
☐ |
|
COMPANY_CITY |
string(240) |
|
☐ |
|
COMPANY_ID |
string(240) |
|
☐ |
|
COMPANY_NAME |
string(1000) |
|
☐ |
|
COMPANY_POSTAL_CODE |
string(240) |
|
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
|
☐ |
|
COSTID |
string(240) |
|
|
|
CUSTSUPID |
string(240) |
|
|
|
DESC |
string |
|
|
|
DOCREF |
string(999) |
|
|
|
FILE_CURRENCY_CODE |
string(240) |
|
☐ |
|
FILE_DATE_CREATED |
string(240) |
|
☐ |
|
FISCAL_YEAR_END_DATE |
datetime |
|
☐ |
|
FISCAL_YEAR_NUMBER |
string(240) |
|
☑ |
|
FISCAL_YEAR_START_DATE |
datetime |
|
☐ |
|
INTERFACE_URL |
string(4000) |
|
☑ |
|
INVDT |
datetime |
|
|
|
INVDUEDT |
datetime |
|
|
|
INVPURSALTP |
string(240) |
|
|
|
INVREF |
string(999) |
|
|
|
INVTP |
string(240) |
|
|
|
MATCHKEYID |
string(240) |
|
|
|
MUTTP |
string(240) |
|
|
|
NR |
string(240) |
|
|
|
OBLINENR |
string(240) |
|
|
|
OBSUBLEDGER_LINESCOUNT |
int64 |
Opening Balance Subledger Lines Count |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_LINESCOUNT |
int64 |
Anfangsbestand Lines Count |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_OPBALDATE |
datetime |
Anfangsbestand Datum |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_OPBALDESC |
string(999) |
Anfangsbestand Beschreibung |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_TOTALCREDIT |
decimal |
Anfangsbestand Gesamtguthaben |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_TOTALDEBIT |
decimal |
Anfangsbestand Total Debit |
|
|
OBSUBLEDGER_SBDESC |
string |
Opening Balance Subledger Beschreibung |
|
|
OBSUBLEDGER_SBTYPE |
string(240) |
Opening Balance Subledger Art |
|
|
OBSUBLEDGER_TOTALCREDIT |
decimal |
Opening Balance Subledger Gesamtguthaben |
|
|
OBSUBLEDGER_TOTALDEBIT |
decimal |
Opening Balance Subledger Total Debit |
|
|
PRODID |
string(240) |
|
|
|
PRODUCT_ID |
string(240) |
|
☐ |
|
PRODUCT_VERSION |
string(240) |
|
☐ |
|
PROJID |
string(240) |
|
|
|
QNTITY |
int64 |
|
|
|
QNTITYID |
string(240) |
|
|
|
RECREF |
string(999) |
|
|
|
29-05-2022 00:55 Version 22.0.196-PROD+3400