FIKZD_REGINV_IN

Incoming Invoice Registration Journal | #transactional | Component: Financials Kazakhastan

Column Name	Description
💲 Local Currency (CURR_CODE):
VAT_AMNT_DEDUCT	VAT Amount to be Deducted
EXCISE_AMNT	Excise Amount in Local Currency
BASE_AMNT_LC	Invoice Amount Without VAT in Local Currency
VAT_AMNT_LC	VAT Amount in Local Currency
GROSS_AMNT_LC	Total Invoice Amount, Including VAT in Local Currency
💲 Document Currency (CURR_CODE_F):
BASE_AMNT_FC	Invoice Amount without VAT in Document Currency
VAT_AMNT_FC	VAT Amount in Document Currency
GROSS_AMNT_FC	Total Invoice Amount, Including VAT, in Document Currency

Column Name	Description

Column Name	Description
EWAYBILL_DATE	Delivery Document Date
DATE_REG	Turnover Date in Journal
INV_DATE	VAT Invoice Registration Date
INVADD_DATE	Additional VAT Invoice Registration Date
CORR_DATE	Revised VAT Invoice Registration Date
CONTR_DATE	Contract Date
VATOFFSET_DATE	VAT Reporting Date
DECL_SUBMIT_DATE	Declaration Submit Date in Tax Office
HP_REGDATE	Registration date of the hard-copy

Column Name	Description
VEND_TYPE	Resident Vendor	Show values
INV_TYPE	Invoice Journal Line Type	Show values
ACTIVITY_TYPE	Activity Type	Show values
DECL_QUART	Declaration Quarter	Show values
DECL_MONTH	Month	Show values
DECL_TYPE	Declaration Type	Show values
AUTOPOST	Mark when Document was Modified Automatically	Show values
REVERSAL	Mark that Document is Reversal	Show values
DOC_STATUS	Electronic Invoice Document Status	Show values
EXCH_TYP	Exchange Format	Show values
JNT_VENT_INV	Joint Venture Invoice	Show values

Column Name	Description	Domain name
CUSTOMS_DECL	Customs Declaration Info	TEXT255
INV_GJAHR	FI Document Year	GJAHR
CORR_GJAHR	Revised FI Document Year	GJAHR
EWAYBILL_NUM	Delivery Document Number	CHAR50
INV_NUM	VAT Invoice Number	TEXT50
INVADD_NUM	Additional VAT Invoice Number	TEXT50
CORR_NUM	Revised VAT Invoice Number	TEXT50
CONTR_NUM	External Contract Number	J_3RF_EXTCNTNUM
PARTN_NAME	Partner Name	CHAR160_LOWER_CASE
PARTN_RNN	BIN of a Reorganized Legal Entity	CHAR12
PARTN_INN	Partner INN	CHAR12
PARTN_KPP	Partner KPP	CHAR9
PARTN_UNP	Partner UNP	CHAR9
PARTN_BIN	Business Identification Number of Partner	CHAR12
PARTN_IIN	Individual Identification Number	CHAR12
EXCH_RATE	Exchange Rate for Postings to Financial Accounting	KURRF
USNAM	User Name	XUBNAME
TMSTMP	Time Stamp	TIMESTAMP
STAT	Vendor Category	FIKZ_REGINV_VEND_CAT
APPX7_SEQ_NUM	Document Sequence Number in Declaration	NUM8
DECL_YEAR	Declaration Year	GJAHR
APPD_NUM	Appendix Number	NUMC2
ADD_INFO	Additional Information	TEXT140
EINVOICE_ID	Electronic invoice number assigned by EIIS	CHAR34
EXTERNAL_INVOICE_ID	External VAT Invoice ID Assigned by EIIS	FIKZ_DI_LONG
REGISTRATION_NUMBER	Registration Number	FIKZ_DI_REGISTRATION_NUMBER
CUST_CAT	Customer Category

Master Data Relations	Join Conditions
Company Code	`FIKZD_REGINV_IN.MANDT == T001.MANDT` `FIKZD_REGINV_IN.BUKRS == T001.BUKRS`
Local Currency	`FIKZD_REGINV_IN.MANDT == TCURC.MANDT` `FIKZD_REGINV_IN.CURR_CODE == TCURC.WAERS`
Document Currency	`FIKZD_REGINV_IN.MANDT == TCURC.MANDT` `FIKZD_REGINV_IN.CURR_CODE_F == TCURC.WAERS`
Customer Number	`FIKZD_REGINV_IN.MANDT == KNA1.MANDT` `FIKZD_REGINV_IN.KUNNR == KNA1.KUNNR`
Partner Country/Region of Registration Partner Country/Region of Registration Client	`FIKZD_REGINV_IN.LAND == T005.LAND1` `FIKZD_REGINV_IN.MANDT == T005.MANDT`
Account Number of Supplier	`FIKZD_REGINV_IN.MANDT == LFA1.MANDT` `FIKZD_REGINV_IN.LIFNR == LFA1.LIFNR`