| 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 | KUNNR | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNAG | Allow NULL? |
| 3 | ABLAD | Unloading Point | nvarchar | 25 | 0 | CHAR | (N' ') | No | | ABLAD | Allow NULL? |
| 4 | ERSTL | Test run for incoming consignment issues | char | 1 | 0 | CHAR | (N' ') | Yes | | ERSTL | Allow NULL? |
| 5 | AUTOMO | Special rules for automobile industry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | AUTOMO | Allow NULL? |
| 6 | TXTML | Automatic Mail when Texts are Received by EDI | char | 1 | 0 | CHAR | (N' ') | Yes | | TXTML | Allow NULL? |
| 7 | AUARTGS | Sales document type for credit memo request | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | AUART_GS | Allow NULL? |
| 8 | AUARTLS | Sales document type for debit memo request | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | AUART_LS | Allow NULL? |
| 9 | FKARTRC | Billing type for invoice | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVFK | FKART_RC | Allow NULL? |
| 10 | FKARTGSM | Billing type for credit memo (quantity correction) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FKART_GSM | Allow NULL? |
| 11 | FKARTGS | Billing type for credit memo (retro-billing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVFK | FKART_GSN | Allow NULL? |
| 12 | FKARTLS | Billing type for debit memo (retro-billing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVFK | FKART_LSN | Allow NULL? |
| 13 | FKCREATE | Indicator: Always create billing document | char | 1 | 0 | CHAR | (N' ') | Yes | | FKCREATE | Allow NULL? |
| 14 | AUARTDEF | Default sales document category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVAK | AUART_DEFSBI | Allow NULL? |
| 15 | PSTYVDEF | Default item category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYV_DEFSBI | Allow NULL? |
| 16 | WERKSDEF | Default plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_DEFSBI | Allow NULL? |
| 17 | VKORGDEF | Default sales organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG_DEFSBI | Allow NULL? |
| 18 | VTWEGDEF | Default distribution channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG_DEFSBI | Allow NULL? |
| 19 | SPARTDEF | Default division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPART_DEFSBI | Allow NULL? |
