J_1UFDI_FILE_TBL - Files for tax document register record
Files for tax document register record information is stored in SAP table J_1UFDI_FILE_TBL.
It is part of development package J1UF in software component FI-LOC-FI-UA. This development package consists of objects that can be grouped under "Localization Ukraine: FI".
It is part of development package J1UF in software component FI-LOC-FI-UA. This development package consists of objects that can be grouped under "Localization Ukraine: FI".
Fields for table J_1UFDI_FILE_TBL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
.INCLUDE | X | J_1UFDI_FILE_KEY | 0 | |||
.INCLUDE | X | J_1UFDI_TAXDOC_KEY | 0 | |||
BUKRS | Company Code | X | BUKRS | CHAR | 8 | * |
NUM | Entry Number | X | J_1UFDI_FILE_POS | NUMC | 20 | |
GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
.INCLUDE | X | J_1UFDI_FILE_DATA | 0 | |||
DOC_TYPE | Electronic Document Type | X | J_1UFDI_DOCTYPE | NUMC | 6 | |
.INCLUDE | J_1UFDI_FILE_FIELDS | 0 | ||||
BELNR_FI | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
GJAHR_FI | Fiscal Year | GJAHR | NUMC | 8 | ||
DIRECTION | Document Direction | J_1UFDI_DOC_DIRECTION | CHAR | 2 | ||
VERS | XML format version | J_1UFDI_DOCVERS | CHAR | 16 | ||
STATUS | Electronic document status | J_1UFDI_XML_STATUS | NUMC | 6 | ||
C_USER | User�who�entered�document | J_1UFDI_USER_C | CHAR | 24 | ||
C_TIMESTAMP | Timestamp of creation | J_1UFDI_TIMESTAMP_C | CHAR | 28 | ||
M_USER | User Who Modified the Document | J_1UFDI_USER_M | CHAR | 24 | ||
M_TIMESTAMP | Timestamp of Modification | J_1UFDI_TIMESTAMP_M | CHAR | 28 | ||
S_USER | User who signed document | J_1UFDI_USER_S | CHAR | 24 | ||
S_TIMESTAMP | Timestamp of signing | J_1UFDI_TIMESTAMP_S | CHAR | 28 | ||
FILENAME | Filename | J_1UFDI_XML_FILENAME | CHAR | 400 | ||
XML_ERROR_STATUS | XML Errors | J_1UFDI_XML_ERROR_STATUS | CHAR | 40 | ||
.INCLUDE | J_1UFDI_XML_HEADER_DATA | 0 | ||||
XML_SELLER_INN | Tax Payer Individual Number | J_1UFDI_TAX_PAYER_NUM | CHAR | 32 | ||
XML_BUYER_INN | Individual Tax Number of Buyer | J_1UFDI_TAX_BUYER_NUM | CHAR | 32 | ||
XML_HNUM | Tax Document Number | J_1UFDI_NUM | CHAR | 14 | ||
XML_ACT_TYPE | Activity Type | J_1UFDI_SPEC_TAXV | CHAR | 2 | ||
XML_BRANCH | Branch Number | J_1UFDI_BRANCH_NUM | NUMC | 8 | ||
XML_HNUM_PD | Number of Tax Invoice current Correction created for | J_1UFDI_NUM_TAXINV | CHAR | 14 | ||
XML_ACT_TYPE_PD | Activity�Type�in Inital�Tax�Invoice | J_1UFDI_ACTTYPE_TAXINV | CHAR | 2 | ||
XML_BRANCH_PD | Branch�Number�of�Tax�Invoice�in�Correction | J_1UFDI_BRANCH_NUM_TAXINV | NUMC | 8 | ||
XML_BLDAT_PD | Document Date of relevant Tax Invoice | J_1UF_TAXINV_DATE | DATS | 16 | ||
XML_BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
XML_BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
XML_XBLNR | Tax Document number | J_1UFDI_TAXDOC_NUM | CHAR | 32 | ||
XML_PARTNER | Counterparty | J_1UFDI_CONTRAGENT | CHAR | 20 | ||
XML_EXTCNUM | Contract Number | J_1UFDI_CNT_NUM | CHAR | 80 | ||
XML_TOTAL_AMOUNT | Total Document Amount in Local Currency | J_1UFDI_XML_TOTAL | CURR | 12 | ||
XML_TAX | Total Tax Amount | J_1UFDI_XML_TAX | CURR | 12 | ||
XML_TAXBASE | Tax�Base�at�Non-Zero�VAT�Rates� | J_1UFDI_XML_TAXBASE | CURR | 12 | ||
XML_TAXBASE_DEB | Debit�VAT�Base�at�Non-Zero�Rates | J_1UFDI_XML_TAXBASE_DEB | CURR | 12 | ||
XML_TAXBASE_CRED | Credit�VAT�Base�at�Non-Zero�Rates | J_1UFDI_XML_TAXBASE_CRED | CURR | 12 | ||
XML_TAXBASE0 | Total�Tax�Base�at�0%�VAT�Rate | J_1UFDI_XML_TAXBASE0 | CURR | 12 | ||
XML_TAXBASE0_DEB | Debit�VAT�Base�at�0%Rate | J_1UFDI_XML_TAXBASE0_DEB | CURR | 12 | ||
XML_TAXBASE0_CR | Credit Tax Base in Local Currency at 0% VAT Rate | J_1UFDI_XML_TAXBASE0_CRED | CURR | 12 | ||
XML_VAT_14 | Total Amount of Taxable Operations at 14% VAT Rate | J_1UFDI_VAT_14 | CURR | 12 | ||
XML_VAT_7 | Total Amount of Taxable Operations at 7% VAT Rate | J_1UFDI_VAT_7 | CURR | 12 | ||
XML_VAT_0 | VAT Rate 0% | J_1UFDI_VAT_0 | CURR | 12 | ||
XML_VAT_EXCL | Exempt from VAT | J_1UFDI_VAT_EXCL | CURR | 12 | ||
XML_VAT_14_TAX | Total Tax Amount | J_1UFDI_XML_TAX | CURR | 12 | ||
XML_VAT_7_TAX | Total Tax Amount | J_1UFDI_XML_TAX | CURR | 12 | ||
XML_VAT_OSNV_TAX | Total Tax Amount | J_1UFDI_XML_TAX | CURR | 12 | ||
XML_BRANCH_BUY | Customer Branch Number | J_1UF_CUST_BRANCH | CHAR | 36 | ||
XML_SUMMARY | Summary Tax Invoice Type | J_1UFDI_SUMMARY | CHAR | 2 | ||
XML_CASH_METHOD | Accounting Method | J_1UFDI_CASH_METHOD | CHAR | 2 | ||
.INCLUDE | J_1UFCM_XML_CASH_DATA | 0 | ||||
CASH_COEF | Distribution Coefficient | J_1UF_COEF_CASH | DEC | 3 | ||
XML_REP_DATE | XML Tax Reporting Date | J_1UF_XML_REP_DATE | DATS | 16 | ||
DMBTR_CM1_20 | Amount in local currency | DMBTR | CURR | 12 | ||
TAX_CM1_20 | Tax Amount in Local Currency | MWSTS | CURR | 12 | ||
DMBTR_CM1_14 | Amount in local currency | DMBTR | CURR | 12 | ||
TAX_CM1_14 | Tax Amount in Local Currency | MWSTS | CURR | 12 | ||
DMBTR_CM1_7 | Amount in local currency | DMBTR | CURR | 12 | ||
TAX_CM1_7 | Tax Amount in Local Currency | MWSTS | CURR | 12 | ||
DMBTR_CM1_0 | Amount in local currency | DMBTR | CURR | 12 | ||
DMBTR_CM1_NOVAT | Amount in local currency | DMBTR | CURR | 12 | ||
.INCLUDE | J_1UFDI_TI_XML_KEY | 0 | ||||
NUM_XML_TI | Tax Invoice Entry Number | J_1UFDI_FILE_POS_TI | NUMC | 20 | ||
GJAHR_XML_TI | Tax Invoice Fiscal Year | J_1UFDI_GJAHR_TI | NUMC | 8 | ||
DOC_TYPE_XML_TI | Electronic Document Type | J_1UFDI_DOCTYPE | NUMC | 6 | ||
TI_MANUAL_UPD | Indicator: Field content was updated manually | J_1UFDI_UPD_MNL | CHAR | 2 | ||
NO_DELTA | Correction with reversal/new items instead of delta items | J_1UF_NO_DELTA | CHAR | 2 | ||
XML_HTINSEL | Tax Number of Seller | J_1UF_SEL_LEGAL_ENT_CODE | CHAR | 20 | ||
XML_HTINBUY | Tax Number of Buyer | J_1UF_BUY_LEGAL_ENT_CODE | CHAR | 20 | ||
XML_USER_STATUS | Custom Status for XML Files | J_1UFCM_USER_STATUS | CHAR | 2 | J_1UFCM_USER | |
.INCLUDE | J_1UFDI_FILE_RAWS | 0 | ||||
SRCFILE | XML Data | J_1UFDI_XMLDATA | RSTR | 8 | ||
SRCFILE_SIGN | XML Data | J_1UFDI_XMLDATA | RSTR | 8 | ||
SIGN | XML Data | J_1UFDI_XMLDATA | RSTR | 8 |