| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 4 | NUM | Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | FIKZ_NUM | Allow NULL? |
| 5 | VEND_TYPE | Resident Vendor | char | 1 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_VEND_TYPE | Allow NULL? |
| 6 | VAT_AMNT_DEDUCT | VAT Amount to be Deducted | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_VAT_AMNT_DEDUCT | |
| 7 | CUSTOMS_DECL | Customs Declaration Info | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_DECL_NUM | Allow NULL? |
| 8 | EXCISE_AMNT | Excise Amount in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_EXCISE | |
| 9 | INV_BELNR | Original FI Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BKPF | FIKZ_REGINV_INV_BELNR | Allow NULL? |
| 10 | INV_GJAHR | Original FI Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FIKZ_REGINV_INV_GJAHR | Allow NULL? |
| 11 | INVADD_BELNR | Additional FI Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BKPF | FIKZ_REGINV_INVADD_BELNR | Allow NULL? |
| 12 | INVADD_GJAHR | Additional FI Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | BKPF | FIKZ_REGINV_INVADD_GJAHR | Allow NULL? |
| 13 | CORR_BELNR | Revised FI Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BKPF | FIKZ_REGINV_CORR_BELNR | Allow NULL? |
| 14 | CORR_GJAHR | Revised FI Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FIKZ_REGINV_CORR_GJAHR | Allow NULL? |
| 15 | INV_TYPE | Line Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_INV_TYPE | Allow NULL? |
| 16 | DATE_REG | Registration Date in Journal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIKZ_REGINV_INV_REGDATE | Allow NULL? |
| 17 | INV_NUM | VAT Invoice Number | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_INV_NUM | Allow NULL? |
| 18 | INV_DATE | VAT Invoice Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIKZ_REGINV_INV_DATE | Allow NULL? |
| 19 | INVADD_NUM | Additional VAT Invoice Number | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_INVADD_NUM | Allow NULL? |
| 20 | INVADD_DATE | Additional VAT Invoice Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIKZ_REGINV_INVADD_DATE | Allow NULL? |
| 21 | CORR_DATE | Revision Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIKZ_REGINV_CORR_DATE | Allow NULL? |
| 22 | CONTR_NUM | External Contract Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | J_3RF_EXTCNTNUM | Allow NULL? |
| 23 | CONTR_DATE | Contract Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RF_CNTDAT | Allow NULL? |
| 24 | PARTN_NAME | Partner Name | nvarchar | 160 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_CUST_NAME | Allow NULL? |
| 25 | PARTN_RNN | Partner RNN | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIKZ_RNN | Allow NULL? |
| 26 | PARTN_INN | Partner INN | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIKZ_INN | Allow NULL? |
| 27 | PARTN_KPP | Partner KPP | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | FIKZ_KPP | Allow NULL? |
| 28 | PARTN_UNP | Partner UNP | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_CUST_UNP | Allow NULL? |
| 29 | PARTN_BIN | Business Identification Number of Partner | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIKZ_BIN | Allow NULL? |
| 30 | PARTN_IIN | Individual Identification Number of Partner | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIKZ_IIN | Allow NULL? |
| 31 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 32 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNNR | Allow NULL? |
| 33 | CURR_CODE | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER_CURD | Allow NULL? |
| 34 | CURR_CODE_F | Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TWCUR | Allow NULL? |
| 35 | EXCH_RATE | Exchange rate for FI postings | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURRF | |
| 36 | BASE_AMNT_LC | Invoice Amount Without VAT in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_BASE_AMNT_LC | |
| 37 | VAT_AMNT_LC | VAT Amount in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_VAT_AMNT_LC | |
| 38 | GROSS_AMNT_LC | Total Invoice Amount, Including VAT in Local Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_GROSS_AMNT_LC | |
| 39 | BASE_AMNT_FC | Invoice Amount without VAT in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_BASE_AMNT_FC | |
| 40 | VAT_AMNT_FC | VAT Amount in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_VAT_AMNT_FC | |
| 41 | GROSS_AMNT_FC | Total Invoice Amount, Including VAT, in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | FIKZ_REGINV_GROSS_AMNT_FC | |
| 42 | ACTIVITY_TYPE | Activity Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_ACTIVITY_TYPE | Allow NULL? |
| 43 | USNAM | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USNAM | Allow NULL? |
| 44 | TMSTMP | Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | FIKZ_TMSTMP | Allow NULL? |
| 45 | LAND | Partner country of registration | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | FIKZ_PARTN_REG_COUNTRY | Allow NULL? |
| 46 | STAT | Vendor Status | char | 1 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_PARTNERSTAT | Allow NULL? |
| 47 | VATOFFSET_DATE | VAT Reporting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIKZ_REGINV_VATOFFSET_DATE | Allow NULL? |
| 48 | APPX7_SEQ_NUM | Document Sequence Number in Declaration | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | FIKZ_REGINV_APPX7_SEQ_NUM | Allow NULL? |
| 49 | DECL_QUART | Declaration Quarter | char | 1 | 0 | NUMC | (N'0') | Yes | | FIKZ_REGINV_DECL_QUART | Allow NULL? |
| 50 | DECL_MONTH | Month | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FIKZ_MONTH | Allow NULL? |
| 51 | DECL_YEAR | Declaration Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | FIKZ_REGINV_DECL_YEAR | Allow NULL? |
| 52 | DECL_TYPE | Declaration Type | char | 1 | 0 | NUMC | (N'0') | Yes | | FIKZ_RETTYPE | Allow NULL? |
| 53 | DECL_SUBMIT_DATE | Declaration Submit Date in Tax Office | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIKZ_REGINV_DECL_SUBMIT_DATE | Allow NULL? |
| 54 | AUTOPOST | Mark when Document was Modified Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_AUTOPOST | Allow NULL? |
| 55 | REVERSAL | Mark that Document is Reversal | char | 1 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_REVERSAL | Allow NULL? |
| 56 | APPD_NUM | Appendix Number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FIKZ_APP_NUM | Allow NULL? |
| 57 | ADD_INFO | Additional Information | nvarchar | 140 | 0 | CHAR | (N' ') | Yes | | FIKZ_REGINV_ADD_INFO | Allow NULL? |
| 58 | DOC_STATUS | Electronic Invoice Document Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FIKZ_INV_DOC_STATUS | Allow NULL? |
| 59 | EINVOICE_ID | Electronic invoice number assigned by EIIS | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | FIKZ_EINVOICE_ID | Allow NULL? |
| 60 | EXCH_TYP | Exchange Format | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_EXCHTYP | Allow NULL? |
