itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data Model|
SubledgerOpeningBalanceLines: XAF 3.2 Subledger Opening Balance Lines |
Contents Previous Home Next More |
Catalog: XAF
Label: Subledger Opening Balance Lines
The data in this table is partitioned per value of the COMPANY_NAME column.
This is a read-only table. 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.
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 |
Amount |
|
|
AMNTTP |
string(240) |
Amount Type |
|
|
ARTGRPID |
string(240) |
Article Group ID |
|
|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_CITY |
string(240) |
Company City |
☐ |
|
COMPANY_ID |
string(240) |
Company ID |
☐ |
|
COMPANY_NAME |
string(1000) |
Company Name |
☐ |
|
COMPANY_POSTAL_CODE |
string(240) |
Company Postal Code |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identification |
☐ |
|
COSTID |
string(240) |
Cost ID |
|
|
CUSTSUPID |
string(240) |
ID |
|
|
DESC |
string |
Description |
|
|
DOCREF |
string(999) |
Document Reference |
|
|
FILE_CURRENCY_CODE |
string(240) |
File Currency Code |
☐ |
|
FILE_DATE_CREATED |
string(240) |
File Creation Date |
☐ |
|
FISCAL_YEAR_END_DATE |
datetime |
Fiscal Year End Date |
☐ |
|
FISCAL_YEAR_NUMBER |
string(240) |
Fiscal Year Number |
☑ |
|
FISCAL_YEAR_START_DATE |
datetime |
Fiscal Year Start Date |
☐ |
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
INVDT |
datetime |
Invoice Date |
|
|
INVDUEDT |
datetime |
Invoice Due Date |
|
|
INVPURSALTP |
string(240) |
Purchase/Sales Type |
|
|
INVREF |
string(999) |
Invoice Reference |
|
|
INVTP |
string(240) |
|
|
|
MATCHKEYID |
string(240) |
Match Key ID |
|
|
MUTTP |
string(240) |
Mutation Type |
|
|
NR |
string(240) |
Number |
|
|
OBLINENR |
string(240) |
Line Number |
|
|
OBSUBLEDGER_LINESCOUNT |
int64 |
Opening Balance Subledger Lines Count |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_LINESCOUNT |
int64 |
Opening Balance Lines Count |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_OPBALDATE |
datetime |
Opening Balance Date |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_OPBALDESC |
string(999) |
Opening Balance Description |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_TOTALCREDIT |
decimal |
Opening Balance Total Credit |
|
|
OBSUBLEDGER_OBSUBLEDGERS_OPENINGBALANCE_TOTALDEBIT |
decimal |
Opening Balance Total Debit |
|
|
OBSUBLEDGER_SBDESC |
string |
Opening Balance Subledger Description |
|
|
OBSUBLEDGER_SBTYPE |
string(240) |
Opening Balance Subledger Type |
|
|
OBSUBLEDGER_TOTALCREDIT |
decimal |
Opening Balance Subledger Total Credit |
|
|
OBSUBLEDGER_TOTALDEBIT |
decimal |
Opening Balance Subledger Total Debit |
|
|
PRODID |
string(240) |
Product ID |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
PROJID |
string(240) |
Project ID |
|
|
QNTITY |
int64 |
Quantity |
|
|
QNTITYID |
string(240) |
Quantity ID |
|
|
RECREF |
string(999) |
Record Reference |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
