| 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 | PARTNR | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BP_PARTNR_NEW | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 4 | RANTYP | Contract Type | char | 1 | 0 | CHAR | (N' ') | No | | RANTYP | Allow NULL? |
| 5 | SANLF | Product Category | nvarchar | 3 | 0 | NUMC | (N'000') | No | TZAF | SANLF | Allow NULL? |
| 6 | SGSART | Product Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | TZPA | VVSART | Allow NULL? |
| 7 | SFHAART | Financial Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | AT10 | TB_SFHAART | Allow NULL? |
| 8 | CORTYP | Correspondence type | nvarchar | 3 | 0 | CHAR | (N' ') | No | AT81 | TB_CORTYP | Allow NULL? |
| 9 | DCRDAT | Entered On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DCRDAT | Allow NULL? |
| 10 | TCRTIM | Entry Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TCRTIM | Allow NULL? |
| 11 | CRUSER | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_CRUSER | Allow NULL? |
| 12 | DUPDAT | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DUPDAT | Allow NULL? |
| 13 | TUPTIM | Time changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TUPTIM | Allow NULL? |
| 14 | UPUSER | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_UPUSER | Allow NULL? |
| 15 | CORR_PR | Print Correspondence | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_CORR_PR | Allow NULL? |
| 16 | CORR_FX | Fax Correspondence | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_CORR_FX | Allow NULL? |
| 17 | CORR_SW | Generate Correspondence SWIFT File | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_CORR_SW | Allow NULL? |
| 18 | CORR_ID | Generate Correspondence IDoc | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_CORR_ID | Allow NULL? |
| 19 | CORR_EM | Activate Correspondence for E-Mail | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_CORR_EM | Allow NULL? |
| 20 | CORR_AD | Alternative Address for Correspondence | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TB009 | TB_CORR_AD_NEW | Allow NULL? |
| 21 | CORR_STAT | Principal correspondence medium for correspondence status | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_CORR_ST | Allow NULL? |
| 22 | SOBLRECONF | Counterconfirmation required? | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_OBLRECO | Allow NULL? |
| 23 | SNODUNNING | Block dunning? (no application) | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_NODUNNG | Allow NULL? |
| 24 | REPL_RE | Indicator: Correspondence reply required | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_REPL_RE | Allow NULL? |
| 25 | REPL_TI | Period in days for correspondence reply | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TB_REPL_TI | Allow NULL? |
| 26 | REPL_KU | Grace period in days for correspondence reply | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TB_REPL_KU | Allow NULL? |
