| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PARART | Partner Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | KONTO | Partner number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | KTBUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | MWSTINCL | EDI: Calculate Tax | char | 1 | 0 | | | | Allow NULL? |
| 6 | KOKSEPA | EDI: Display Surcharges/Discounts at Header Level Separately | char | 1 | 0 | | | | Allow NULL? |
| 7 | KOPSEPA | EDI: Display Surcharges/Discounts at Item Level Separately | char | 1 | 0 | | | | Allow NULL? |
| 8 | EDITXJ | EDI: Tax Jurisdiction Code Transferred | char | 1 | 0 | | | | Allow NULL? |
| 9 | EDIPRP | EDI: Park Document | char | 1 | 0 | | | | Allow NULL? |
| 10 | EDIBDCK | EDI: Generate Batch Input Sess.(Instead of Posting Directly) | char | 1 | 0 | | | | Allow NULL? |
| 11 | EDIBDCA | EDI: Process Batch Input Session Immediately | char | 1 | 0 | | | | Allow NULL? |
| 12 | CBSCHLSS | EDI: G/L Account Debit Posting Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | CBSCHLSH | EDI: G/L Account Credit Posting Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | CBSCHLKS | EDI: Vendor Debit Posting Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | CBSCHLKH | EDI: Vendor Credit Posting Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | CBLARTKR | EDI: Invoice Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | CBLARTKG | EDI: Credit Memo Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | CMWSKZFREI | EDI: Tax Code for Tax-Exempt Transactions | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | CMEINS | EDI: Standard Unit of Measure if not Transferred | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | CEDIVRKS | EDI: Clearing Account for Debit Document Division | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | CEDIVRKH | EDI: Clearing Account for Credit Document Division | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | MRMKORR | EDI: Indicator for Automatic Correction | char | 1 | 0 | | | | Allow NULL? |
| 23 | MRMCONSMATNR | Indicates that material number consistency is checked (EDI) | char | 1 | 0 | | | | Allow NULL? |
| 24 | MRMCONSMEINS | Indicates that unit of measure consistency is checked (EDI) | char | 1 | 0 | | | | Allow NULL? |
| 25 | EDINEGDIFF | EDI: Indicator for Check for Negative Unclarified Errors | char | 1 | 0 | | | | Allow NULL? |
| 26 | DINVKORR | EDI: Indicator for Automatic Correction (Diff. Invoicing) | char | 1 | 0 | | | | Allow NULL? |
| 27 | DINVCONSBTR | Check Credit Memo Amount and Currency for Consistency | char | 1 | 0 | | | | Allow NULL? |
| 28 | DINVCONSMNG | Check Credit Memo Qty and Unit of Measure for Consistency | char | 1 | 0 | | | | Allow NULL? |
| 29 | DINVCONSXBLNR | Indicator: Check Credit Memo Reference to External Doc. No. | char | 1 | 0 | | | | Allow NULL? |