| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | INDEX_REC | Loop Index | int | 10 | 0 | INT4 | ((0)) | No | | SYINDEX | Allow NULL? |
| 2 | UMKRS | Sales/Purchases Tax Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | UMKRS | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 4 | QUART | Calendar year / quarter | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | RSCALQUART | Allow NULL? |
| 5 | PERIO | Fiscal Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MONAT | Allow NULL? |
| 6 | SEQNR | Item Number (for Sequence) | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | BU_POSNR | Allow NULL? |
| 7 | BELNR_ORIG | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 8 | BUDAT | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1UF_BUDAT | Allow NULL? |
| 9 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 10 | BELNR | Complex Document Number | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | J_1UF_DOKORR | Allow NULL? |
| 11 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 12 | NAME1 | Customer Name | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | J_1UF_CNAME | Allow NULL? |
| 13 | NAME2 | Name 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME2 | Allow NULL? |
| 14 | NAME3 | Name 3 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME3 | Allow NULL? |
| 15 | NAME4 | Name 4 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME4 | Allow NULL? |
| 16 | STKZU | Liable for VAT | char | 1 | 0 | CHAR | (N' ') | Yes | | STKZU | Allow NULL? |
| 17 | XBLNR | Accounting document number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_1UF_BELNR | Allow NULL? |
| 18 | XBLN2 | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 19 | LIFNR | Account Number of Vendor | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1UF_LAND_LIFNR | Allow NULL? |
| 20 | LIFNR_NAME1 | Vendor Name | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | J_1UF_NAME | Allow NULL? |
| 21 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_1UF_STCD1 | Allow NULL? |
| 22 | SAS07 | Total Amount Including VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_TOTAL | |
| 23 | SAS08 | Tax Base of Taxable Operations at 20% VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEII07 | |
| 24 | SAS09 | VAT Amount of Taxable Operations at 20% VAT Rate | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEII08 | |
| 25 | SAS10 | Tax Base of Taxable Operations at 7% VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_7PERC_TAX_OP | |
| 26 | SAS11 | VAT Amount of Taxable Operations at 7% VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_7PERC_TAX_OP_VAT | |
| 27 | SAS12 | Tax Base of Taxable Operations at 0% VAT Rate | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEII09 | |
| 28 | SAS13 | Base of Operations Exempt from VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEII10 | |
| 29 | SAS14 | Total of Non-Taxable Operations | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_NONT_TAX_OP | |
| 30 | SAS15 | Base for Export Goods | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEII11 | |
| 31 | SAS16 | Base for Export Services | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEII12 | |
| 32 | PYDAT | Payment Date for Inbound Goods | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1UF_PYDAT | Allow NULL? |
| 33 | DOCTYP | Document Type | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | J_1UF_DOCTYP | Allow NULL? |
| 34 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_ADJUSTMENT | Allow NULL? |
| 35 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 36 | DOC_STATUS | Document Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_1UFDI_DOC_STATUS | Allow NULL? |
| 37 | ERPN | Status in Single Register of Tax Invoices | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_DOC_ERPN | Allow NULL? |
| 38 | ACTIVITY | Code of Special Taxation Activity | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_CO_ACTIVITY | Allow NULL? |
| 39 | BRANCH | Company Branch | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | J_1UF_CO_BRANCH | Allow NULL? |
| 40 | USRFLAG | User-defined field: Indicator for reports | char | 1 | 0 | CHAR | (N' ') | Yes | | USRFLAG | Allow NULL? |
| 41 | TI_TYPE | Tax Invoice Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | J_1UF_TAX_INV_TYPE | Allow NULL? |
| 42 | BUSINESS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 43 | VAT_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 44 | BASE_TAX_INV | Base Tax Invoice Document Number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | J_1UF_BASE_TAX_INV | Allow NULL? |
| 45 | GOODS | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 46 | INTCNUM | Internal Contract Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | J_1UF_INTCNTNUM | Allow NULL? |
| 47 | EXTCNUM | External Contract Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | J_1UF_EXTCNTNUM | Allow NULL? |
| 48 | NEGATIVE_COR | General Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | FLAG | Allow NULL? |
| 49 | NON_RESIDENT | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 50 | CORR | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 51 | DOC_TYPE | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 52 | NON_VAT | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 53 | TV_REASON | 2-Digit Numeric Value | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | NUM2 | Allow NULL? |
