J_1UFDI_FILE_TBL

Files for tax document register record | #transactional | Component: Financials Ukraine
Column Name Description
MANDT Client
BUKRS Company Code
NUM Entry Number
GJAHR Fiscal Year
DOC_TYPE Electronic Document Type Show values
Column Name Description
💲 Currency Key (T001.WAERS):
XML_TOTAL_AMOUNT Total Document Amount in Local Currency
XML_TAX Total Tax Amount
XML_TAXBASE Tax Base at Non-Zero VAT Rates
XML_TAXBASE_DEB Debit VAT Base at Non-Zero Rates
XML_TAXBASE_CRED Credit VAT Base at Non-Zero Rates
XML_TAXBASE0 Total Tax Base at 0% VAT Rate
XML_TAXBASE0_DEB Debit VAT Base at 0%Rate
XML_TAXBASE0_CR Credit Tax Base in Local Currency at 0% VAT Rate
XML_VAT_14 Total Amount of Taxable Operations at 14% VAT Rate
XML_VAT_7 Total Amount of Taxable Operations at 7% VAT Rate
XML_VAT_0 VAT Rate 0%
XML_VAT_EXCL Exempt from VAT
XML_VAT_14_TAX Total Tax Amount
XML_VAT_7_TAX Total Tax Amount
XML_VAT_OSNV_TAX Total Tax Amount
DMBTR_CM1_20 Amount in local currency
TAX_CM1_20 Tax Amount in Local Currency
DMBTR_CM1_14 Amount in local currency
TAX_CM1_14 Tax Amount in Local Currency
DMBTR_CM1_7 Amount in local currency
TAX_CM1_7 Tax Amount in Local Currency
DMBTR_CM1_0 Amount in local currency
DMBTR_CM1_NOVAT Amount in local currency
Column Name Description
Column Name Description
XML_BLDAT_PD Document Date of relevant Tax Invoice
XML_BLDAT Document Date in Document
XML_BUDAT Posting Date in the Document
XML_REP_DATE XML Tax Reporting Date
Column Name Description
DOC_TYPE Electronic Document Type Show values
DIRECTION Document Direction Show values
STATUS Electronic document status Show values
XML_SUMMARY Summary Tax Invoice Type Show values
XML_CASH_METHOD Accounting Method Show values
DOC_TYPE_XML_TI Electronic Document Type Show values
TI_MANUAL_UPD Indicator: Field content was updated manually Show values
NO_DELTA Correction with reversal/new items instead of delta items Show values
Column Name Description Domain name
BELNR_FI Document Number of an Accounting Document BELNR
GJAHR_FI Fiscal Year GJAHR
VERS XML format version CHAR8
C_USER User who entered document SYCHAR12
C_TIMESTAMP Timestamp of creation J_1UFDI_TIMESTAMP
M_USER User Who Modified the Document SYCHAR12
M_TIMESTAMP Timestamp of Modification J_1UFDI_TIMESTAMP
S_USER User who signed document SYCHAR12
S_TIMESTAMP Timestamp of signing J_1UFDI_TIMESTAMP
FILENAME Filename CHAR200
XML_ERROR_STATUS XML Errors CHAR20
XML_SELLER_INN Tax Payer Individual Number STCD1
XML_BUYER_INN Individual Tax Number of Buyer STCD1
XML_HNUM Tax Document Number CHAR7
XML_ACT_TYPE Activity Type
XML_BRANCH Branch Number
XML_HNUM_PD Number of Tax Invoice current Correction created for CHAR7
XML_ACT_TYPE_PD Activity Type in Inital Tax Invoice
XML_BRANCH_PD Branch Number of Tax Invoice in Correction
XML_XBLNR Tax Document number XBLNR1
XML_PARTNER Counterparty J_1UFDI_CONTRAGENT
XML_EXTCNUM Contract Number CHAR40
XML_BRANCH_BUY Customer Branch Number STCD4
CASH_COEF Distribution Coefficient J_1UF_COEF_CASH
NUM_XML_TI Tax Invoice Entry Number J_1UFDI_FILE_POS
GJAHR_XML_TI Tax Invoice Fiscal Year GJAHR
XML_HTINSEL Tax Number of Seller J_1UF_LEGAL_ENT_CODE
XML_HTINBUY Tax Number of Buyer J_1UF_LEGAL_ENT_CODE
SRCFILE XML Data J_1UFDI_XMLDATA
SRCFILE_SIGN XML Data J_1UFDI_XMLDATA
SIGN XML Data J_1UFDI_XMLDATA
Master Data Relations Join Conditions
Custom Status for XML Files