SubledgerTransactionLineVats |
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:transactions/xaf:subledgers/xaf:subledger/xaf:sbLine
XPath: /xaf:vat
Table Columns
The columns of the table SubledgerTransactionLineVats are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
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) |
|
☐ |
|
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) |
|
☑ |
|
PRODUCT_ID |
string(240) |
|
☐ |
|
PRODUCT_VERSION |
string(240) |
|
☐ |
|
SBLINE_AMNT |
decimal |
Subledger Line Betrag |
|
|
SBLINE_AMNTTP |
string(240) |
Subledger Line Summe Typ |
|
|
SBLINE_ARTGRPID |
string(240) |
Subledger Line Article Group ID |
|
|
SBLINE_COSTID |
string(240) |
Subledger Line Cost ID |
|
|
SBLINE_CURRENCY_CURAMNT |
decimal |
|
|
|
SBLINE_CURRENCY_CURCODE |
string(240) |
|
|
|
SBLINE_CUSTSUPID |
string(240) |
Subledger Line Identifikation |
|
|
SBLINE_DESC |
string |
Subledger Line Beschreibung |
|
|
SBLINE_DOCREF |
string(999) |
Subledger Line Document Reference |
|
|
SBLINE_INVDT |
datetime |
Subledger Line Rechnungsdatum |
|
|
SBLINE_INVDUEDT |
datetime |
Subledger Line Invoice Due Date |
|
|
SBLINE_INVPURSALTP |
string(240) |
Subledger Line Purchase/Sales Type |
|
|
SBLINE_INVREF |
string(999) |
Subledger Line Invoice Reference |
|
|
SBLINE_INVTP |
string(240) |
|
|
|
SBLINE_JRNID |
string(240) |
Subledger Line Journal ID |
|
|
SBLINE_MATCHKEYID |
string(240) |
Subledger Line Match Key ID |
|
|
SBLINE_MUTTP |
string(240) |
Subledger Line Mutation Type |
|
|
SBLINE_NR |
string(240) |
Subledger Line Number |
|
|
SBLINE_PRODID |
string(240) |
Subledger Line Produkt ID |
|
|
SBLINE_PROJID |
string(240) |
Subledger Line Projekt ID |
|
|
SBLINE_QNTITY |
int64 |
Subledger Line Menge |
|
|
SBLINE_QNTITYID |
string(240) |
Subledger Line Quantity ID |
|
|
SBLINE_RECREF |
string(999) |
Subledger Line Record Reference |
|
|
SBLINE_TRLINENR |
string(240) |
|
|
|
SBLINE_TRNR |
string(240) |
|
|
|
VATAMNT |
decimal |
|
|
|
VATAMNTTP |
string(240) |
|
|
|
VATID |
string(240) |
|
|
|
VATPERC |
decimal |
|
|
|
29-05-2022 00:55 Version 22.0.196-PROD+3400