| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | APPLK | Application area | char | 1 | 0 | | | | Allow NULL? |
| 4 | VKONA | Contract account number in legacy system | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | VKBEZ | Contract account name | nvarchar | 35 | 0 | | | | Allow NULL? |
| 6 | EXVKO | Reference number for business partner | nvarchar | 25 | 0 | | | | Allow NULL? |
| 7 | OPBUK | Company Code Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | STDBK | Standard Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | ABWRE | Alternative Payer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | ABWRA | Alternative Payee | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | ABWMA | Alternative dunning recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | EBVTY | Bank Details ID for Incoming Payments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ABVTY | Bank Details ID for Outgoing Payments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | EZAWE | Incoming Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 15 | AZAWE | Outgoing Payment Methods | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | VWNZA | Create Where-Used List For Line Items | char | 1 | 0 | | | | Allow NULL? |
| 17 | LOEVM | Mark Contract Account for Deletion | char | 1 | 0 | | | | Allow NULL? |
| 18 | ABWVK | Alternative contract account for collective bills | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | IKEY | Interest Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | MGRUP | Grouping fur Dunning Notices | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | FDGRP | Planning Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | FDZTG | Additional Days for Cash Management | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | VKPBZ | Relationship of Business Partner to Contract Account | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | VKONV | Contract account used for payment transactions | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | GPARV | Business Partner Acting as Payer in Payment Transactions | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | ABWRH | Alternative Invoice Recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | TOGRU | Tolerance group for contract account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 31 | COPRC | Correspondence Variant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | CCARD_ID | Payment Card ID for Incoming Payments | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | CCARD_OUT | Payment Card ID for Outgoing Payments | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | UEBTR | Items Transferred To Another Account | char | 1 | 0 | | | | Allow NULL? |
| 36 | DEF_REC | Alternative Correspondence Recipient for Standard Case | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | DEF_REC_IND | FI-CA correspondence - activity key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 38 | QSSKZ_A | Witholding Tax Code For Outgoing Payments | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | QSSKZ_E | Withholding Tax Code For Incoming Payments | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | QSZNR | Certificate Number of the Withholding Tax Exemption | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | QSZDT | Withholding tax exemption cert. valid-until date(YYYYMMDD) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | CORR_MAHNV | Correspondence Dunning Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | FITYP | Tax type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | PROVINCE | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | COUNTY | County Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | VERTYP | Clearing Category For Clearing Postings | nvarchar | 4 | 0 | | | | Allow NULL? |
| 47 | AUGRS_DEF | Clearing Restriction | char | 1 | 0 | | | | Allow NULL? |
| 48 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 49 | BUPLA | Business Place | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | BPTAXTYPE1 | Tax Number Type 1 for Business Partner | nvarchar | 4 | 0 | | | | Allow NULL? |
| 51 | BPTAXTYPE2 | Tax Number type 2 for Business Partner | nvarchar | 4 | 0 | | | | Allow NULL? |
| 52 | INV_CATEGORY | Invoicing Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 53 | INVTP | Invoice Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | FCALID | Factory Calendar | nvarchar | 2 | 0 | | | | Allow NULL? |
| 55 | XFIX_EZAWE | Apply Manual Setting for Incoming Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 56 | XFIX_AZAWE | Apply Manual Setting for Outgoing Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 57 | XFIX_OP_LOCK | Apply Manual Setting for Lock Reason for Outgoing Payment | char | 1 | 0 | | | | Allow NULL? |
| 58 | XFIX_IKEY | Apply Manual Setting for Interest Key | char | 1 | 0 | | | | Allow NULL? |
| 59 | XFIX_TOGRU | Apply Manual Setting for Tolerance Group | char | 1 | 0 | | | | Allow NULL? |
| 60 | XFIX_VERTYP | Apply Manual Setting for Clearing Category | char | 1 | 0 | | | | Allow NULL? |
| 61 | XFIX_MAHNV | Apply Manual Setting for Dunning Procedure | char | 1 | 0 | | | | Allow NULL? |
| 62 | XFIX_COPRC | Apply Manual Setting for Correspondence Variant | char | 1 | 0 | | | | Allow NULL? |
| 63 | XFIX_CORR_MAHNV | Apply Manual Setting for Correspondence Dunning Procedure | char | 1 | 0 | | | | Allow NULL? |
| 64 | XNO_AUTO_UPDATE | Deactivate Automatic Update of Student Account Entirely | char | 1 | 0 | | | | Allow NULL? |
