| 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 | BKTXT | Header Text | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | J_1UF_BKTXT | Allow NULL? |
| 11 | BELNR | Complex Document Number | nvarchar | 21 | 0 | CHAR | (N' ') | Yes | | J_1UF_DOKORR | Allow NULL? |
| 12 | LIFNR | Account Number of Vendor | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1UF_LAND_LIFNR | Allow NULL? |
| 13 | XBLNR | Accounting document number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_1UF_BELNR | Allow NULL? |
| 14 | NAME1 | Vendor Name | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | J_1UF_NAME | Allow NULL? |
| 15 | NAME2 | Name 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME2 | Allow NULL? |
| 16 | NAME3 | Name 3 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME3 | Allow NULL? |
| 17 | NAME4 | Name 4 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME4 | Allow NULL? |
| 18 | STCD1 | Individual Tax Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_1UF_STCD1 | Allow NULL? |
| 19 | WINHW | Total Amount Including VAT | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_TOTAL | |
| 20 | PUR07 | Tax Base of Taxable Operations at Base VAT Rate | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI07 | |
| 21 | PUR08 | VAT Amount of Taxable Operations at Base VAT Rate | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI08 | |
| 22 | PUR09 | Base of Non-Taxable Operations | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI09 | |
| 23 | PUR10 | VAT for Non-Taxable Operations | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI10 | |
| 24 | PUR11 | Base for Non-Business Operations | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI11 | |
| 25 | PUR12 | VAT for Non-Business Operations | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI12 | |
| 26 | PUR13 | Base for Services Outside the Customs Territory | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI13 | |
| 27 | PUR14 | VAT for Services Performed Outside Customs Territory | decimal | 15 | 2 | CURR | ((0)) | Yes | | J_1UF_REEI14 | |
| 28 | PYDAT | Payment Date for Inbound Goods | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1UF_PYDAT | Allow NULL? |
| 29 | DOCTYP | Document Type | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | J_1UF_DOCTYP | Allow NULL? |
| 30 | ADJUSTMENTS | VAT Adjustments/Distribution Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_ADJUSTMENT | Allow NULL? |
| 31 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 32 | ERPN | Status in Single Register of Tax Invoices | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_DOC_ERPN | Allow NULL? |
| 33 | ACTIVITY | Code of Special Taxation Activity | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_CO_ACTIVITY | Allow NULL? |
| 34 | BRANCH | Company Branch | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | J_1UF_CO_BRANCH | Allow NULL? |
| 35 | USRFLAG | User-defined field: Indicator for reports | char | 1 | 0 | CHAR | (N' ') | Yes | | USRFLAG | Allow NULL? |
| 36 | BUSINESS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 37 | VAT_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 38 | INTCNUM | Internal Contract Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | J_1UF_INTCNTNUM | Allow NULL? |
| 39 | EXTCNUM | External Contract Number | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | J_1UF_EXTCNTNUM | Allow NULL? |
| 40 | NON_VAT | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 41 | NON_RESIDENT | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 42 | CORR | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
| 43 | DOC_TYPE | Character length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR_01 | Allow NULL? |
