itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data Model|
SubledgerTransactionLineVats: XAF 3.2 Subledger Transaction Line VATs |
Contents Previous Home Next More |
Catalog: XAF
Label: Subledger Transaction Line VATs
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: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) |
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 |
☐ |
|
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 |
☑ |
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
SBLINE_AMNT |
decimal |
Subledger Line Amount |
|
|
SBLINE_AMNTTP |
string(240) |
Subledger Line Amount Type |
|
|
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 ID |
|
|
SBLINE_DESC |
string |
Subledger Line Description |
|
|
SBLINE_DOCREF |
string(999) |
Subledger Line Document Reference |
|
|
SBLINE_INVDT |
datetime |
Subledger Line Invoice Date |
|
|
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 Product ID |
|
|
SBLINE_PROJID |
string(240) |
Subledger Line Project ID |
|
|
SBLINE_QNTITY |
int64 |
Subledger Line Quantity |
|
|
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 |
VAT Amount |
|
|
VATAMNTTP |
string(240) |
VAT Amount Type |
|
|
VATID |
string(240) |
ID |
|
|
VATPERC |
decimal |
VAT Percentage |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
