| 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 | T000 | MANDT | Allow NULL? |
| 2 | WEMPF | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNNR | Allow NULL? |
| 3 | EDART | Excise Duty Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | /BEV2/ED901 | /BEV2/EDART | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 5 | EDSLAGER | Tax Warehouse Registration | nvarchar | 15 | 0 | CHAR | (N' ') | No | /BEV2/ED902 | /BEV2/EDSLAGER | Allow NULL? |
| 6 | DATAB | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | /BEV2/EDDATAB | Allow NULL? |
| 7 | DATBI | Valid To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | /BEV2/EDDATBI | Allow NULL? |
| 8 | EDSLAGERE | External Excise Duty Warehouse Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BEV2/EDSLAGERE | Allow NULL? |
| 9 | EDVBSNRE | External Excise Duty Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BEV2/EDSNRSL | Allow NULL? |
| 10 | EDSLAGERIHE | Number of Tax Warehouse Owner | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BEV2/EDSLAGERIHE | Allow NULL? |
| 11 | EDPARTNER | ED Special Partner Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /BEV2/ED961 | /BEV2/EDPARTNERTYP | Allow NULL? |
| 12 | EDEXPORT | Indicator: Delivery to Third Country | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV2/EDKEXPORT | Allow NULL? |
| 13 | EDEXP_COUNTRY | Country of Vendor/Ship-To Party | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | /BEV2/EDLAND_EXTERN | Allow NULL? |
| 14 | EDNOLDS | Setting for Legal Document for Movement/EMCS | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV2/EDKNOLDS | Allow NULL? |
| 15 | REG_RECEIVER | Registered Consignee | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | /BEV2/EDREG_RECEIVER | Allow NULL? |
| 16 | AVG_MOVE_TIME | Average Transfer Time in Days | decimal | 5 | 2 | DEC | ((0)) | Yes | | /BEV2/ED_AVG_MOVE | |
| 17 | ERLAUBNISART | Type of Permission for Management of Taxed/Untaxed Goods | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV2/ED_K_ERLAUBNISART | Allow NULL? |
| 18 | ITEPC1 | EMCS: Excise Duty Product Code According to SEED File | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BEV2/CS_C_PCODE | /BEV2/CS_PRODUCT_CODE_SEED | Allow NULL? |
| 19 | ITEPC2 | EMCS: Excise Duty Product Code According to SEED File | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BEV2/CS_C_PCODE | /BEV2/CS_PRODUCT_CODE_SEED | Allow NULL? |
| 20 | ITEPC3 | EMCS: Excise Duty Product Code According to SEED File | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BEV2/CS_C_PCODE | /BEV2/CS_PRODUCT_CODE_SEED | Allow NULL? |
| 21 | ITEPC4 | EMCS: Excise Duty Product Code According to SEED File | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BEV2/CS_C_PCODE | /BEV2/CS_PRODUCT_CODE_SEED | Allow NULL? |