| 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 | BELNR_ORIG | Number of Original VAT Invoice | nvarchar | 10 | 0 | CHAR | (N' ') | No | BKPF | J_3RFINV_ORIGS | Allow NULL? |
| 4 | GJAHR_ORIG | Year of Original VAT Invoice | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | J_3RFINV_ORIGY | Allow NULL? |
| 5 | BELNR_CORR | Number of Corrective VAT Invoice | nvarchar | 10 | 0 | CHAR | (N' ') | No | BKPF | J_3RFINV_CORRS | Allow NULL? |
| 6 | GJAHR_CORR | Year of Corrective VAT Invoice | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | J_3RFINV_CORRY | Allow NULL? |
| 7 | REVNO | Revision Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | J_3RFINV_REVNO | Allow NULL? |
| 8 | REVNO_ORIG | Revision Number of Original VAT Invoice for Correction | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | J_3RFINV_REVNO_ORIG | Allow NULL? |
| 9 | EXT_ORIG | External Number of Original VAT Invoice | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_ORIGE | Allow NULL? |
| 10 | EXT_CORR | External Number of Corrective VAT Invoice | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_CORRE | Allow NULL? |
| 11 | BELNR_REV | Number of Revised VAT Invoice | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BKPF | J_3RFINV_REVS | Allow NULL? |
| 12 | GJAHR_REV | Year of Revised VAT Invoice | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | J_3RFINV_REVY | Allow NULL? |
| 13 | DATE_ORIG | Date of Original VAT Invoice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_ORIGD | Allow NULL? |
| 14 | DATE_CORR | Date of Corrective VAT Invoice | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_CORRD | Allow NULL? |
| 15 | DATE_REV | Revision Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_REVD | Allow NULL? |
| 16 | DATE_ORIG_REV | Revision Date of Original VAT Invoice for Correction | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_ORIG_REVD | Allow NULL? |
| 17 | DATE_SEND | Send Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_SEND | Allow NULL? |
| 18 | DATE_REG | Registration Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_REG | Allow NULL? |
| 19 | EXCH_TYP | Exchange Format | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_EXCHTYP | Allow NULL? |
| 20 | OPER_TYP | Operation Type | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_OPERTYP | Allow NULL? |
| 21 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNNR | Allow NULL? |
| 22 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 23 | NAME | Partner Name | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_NAME | Allow NULL? |
| 24 | INN | Partner INN | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_INN | Allow NULL? |
| 25 | KPP | Partner KPP | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_KPP | Allow NULL? |
| 26 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 27 | FWBTR | Gross Amount in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_3RFINV_FWBTR | |
| 28 | FWSTE | Tax Amount in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_3RFINV_FWSTE | |
| 29 | FWBTR_DIFF | Gross Amount Difference in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_3RFINV_FWBTRDIFF | |
| 30 | FWSTE_DIFF | Tax Amount Difference in Document Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_3RFINV_FWSTEDIFF | |
| 31 | NONTAX | Flag: Document Is Nontaxable | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_NONTAX | Allow NULL? |
| 32 | FLAG_REG | Register in Journal | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_REGFLAG | Allow NULL? |
| 33 | USNAM | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USNAM | Allow NULL? |
| 34 | TMSTMP | Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_TMSTMP | Allow NULL? |
| 35 | FLAG_DEL | Flag: Entry Is Deleted | char | 1 | 0 | CHAR | (N' ') | No | | J_3RFINV_DELFLAG | Allow NULL? |
| 36 | DOC_STATUS | Electronic Invoice Document Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_DOC_STATUS | Allow NULL? |
| 37 | CLARIF_STATUS | Electronic Invoice Clarification Request Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_CLARIF_STATUS | Allow NULL? |
| 38 | EVENT | Identification for Correspondence | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T048 | EVENT_KORR | Allow NULL? |
| 39 | KSCHL | Output Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | NA_KSCHL | Allow NULL? |
| 40 | SEQNUM | Sequential Number of Entry | int | 10 | 0 | INT4 | ((0)) | Yes | | J_3RFINV_SEQNUM | Allow NULL? |
| 41 | UTD_STATUS | Document Type and Status (UTD or VAT Invoice) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_INVSTAT | Allow NULL? |
| 42 | COMM_TRADE | Trade Type | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_COMM_TRADE | Allow NULL? |
| 43 | SELLER_LIFNR | Seller in a Commission Trade Deal | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | J_3RFINV_SELLER_LIFNR | Allow NULL? |
| 44 | SELLER_NAME | Name of Seller in a Commission Trade Deal | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_SELLER_NAME | Allow NULL? |
| 45 | SELLER_INN | INN of Seller in a Commission Trade Deal | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_SELLER_INN | Allow NULL? |
| 46 | SELLER_KPP | KPP of a Seller in a Commission Trade Deal | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_SELLER_KPP | Allow NULL? |
| 47 | SELLER_EXT_ORIG | External Number of Seller VAT Invoice in Commission Trade | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_SELLER_EXTNUM | Allow NULL? |
| 48 | SELLER_DATE_ORIG | Date of VAT Invoice of Seller in a Commission Trade Deal | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFINV_SELLER_EXTDATE | Allow NULL? |
| 49 | FI_KUNNR | Customer in Accounting Document in a Commission Trade Deal | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | J_3RFINV_FI_KUNNR | Allow NULL? |
