| 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 | VKTYP | Contract Account Category | nvarchar | 2 | 0 | CHAR | (N' ') | No | TFK002A | VKTYP_KK | Allow NULL? |
| 3 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | No | | APPLK_KK | Allow NULL? |
| 4 | VKONA | Contract account number in legacy system | nvarchar | 20 | 0 | CHAR | (N' ') | No | | VKONA_KK | Allow NULL? |
| 5 | VKBEZ | Contract account name | nvarchar | 35 | 0 | CHAR | (N' ') | No | | VKBEZ_KK | Allow NULL? |
| 6 | EXVKO | Reference number for business partner | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXVKO_KK | Allow NULL? |
| 7 | OPBUK | Company Code Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK001G | OPBUK_KK | Allow NULL? |
| 8 | STDBK | Standard Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | STDBK_KK | Allow NULL? |
| 9 | ABWRE | Alternative Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | ABWRE_KK | Allow NULL? |
| 10 | ABWRA | Alternative Payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | ABWRA_KK | Allow NULL? |
| 11 | ABWMA | Alternative dunning recipient | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | ABWMA_KK | Allow NULL? |
| 12 | EBVTY | Bank Details ID for Incoming Payments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | EBVTY_KK | Allow NULL? |
| 13 | ABVTY | Bank Details ID for Outgoing Payments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ABVTY_KK | Allow NULL? |
| 14 | EZAWE | Incoming Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | | EZAWE_KK | Allow NULL? |
| 15 | AZAWE | Outgoing Payment Methods | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | AZAWE_KK | Allow NULL? |
| 16 | VWNZA | Create Where-Used List For Line Items | char | 1 | 0 | CHAR | (N' ') | Yes | | VWNZA_KK | Allow NULL? |
| 17 | LOEVM | Mark Contract Account for Deletion | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_KK | Allow NULL? |
| 18 | ABWVK | Alternative contract account for collective bills | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | FKKVK | ABWVK_KK | Allow NULL? |
| 19 | IKEY | Interest Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK056A | IKEY_KK | Allow NULL? |
| 20 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK047A | MAHNV_KK | Allow NULL? |
| 21 | MGRUP | Grouping fur Dunning Notices | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK047F | MGRUP_KK | Allow NULL? |
| 22 | FDGRP | Planning Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T035 | FDGRP_KK | Allow NULL? |
| 23 | FDZTG | Additional Days for Cash Management | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FDZTG_KK | Allow NULL? |
| 24 | VKPBZ | Relationship of Business Partner to Contract Account | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK002F | VKPBZ_KK | Allow NULL? |
| 25 | VKONV | Contract account used for payment transactions | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | FKKVK | VKONV_KK | Allow NULL? |
| 26 | GPARV | Business Partner Acting as Payer in Payment Transactions | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | GPARV_KK | Allow NULL? |
| 27 | ABWRH | Alternative Invoice Recipient | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | ABWRH_KK | Allow NULL? |
| 28 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 29 | TOGRU | Tolerance group for contract account | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK043 | TOGRU_KK | Allow NULL? |
| 30 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | TTXJ | TXJCD | Allow NULL? |
| 31 | COPRC | Correspondence Variant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK070B | COPRC_KK | Allow NULL? |
| 32 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 33 | CCARD_ID | Payment Card ID for Incoming Payments | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CCID_IN_KK | Allow NULL? |
| 34 | CCARD_OUT | Payment Card ID for Outgoing Payments | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CCID_OUT_KK | Allow NULL? |
| 35 | UEBTR | Items Transferred To Another Account | char | 1 | 0 | CHAR | (N' ') | Yes | | XUEBTR_KK | Allow NULL? |
| 36 | DEF_REC | Alternative Correspondence Recipient for Standard Case | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | DEF_CORR_PARTNER_KK | Allow NULL? |
| 37 | DEF_REC_IND | FI-CA correspondence - activity key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK070L | DEF_CORR_ACKEY_KK | Allow NULL? |
| 38 | QSSKZ_A | Witholding Tax Code For Outgoing Payments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QSSKZ_A_KK | Allow NULL? |
| 39 | QSSKZ_E | Withholding Tax Code For Incoming Payments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QSSKZ_E_KK | Allow NULL? |
| 40 | QSZNR | Certificate Number of the Withholding Tax Exemption | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | QSZNR | Allow NULL? |
| 41 | QSZDT | Withholding tax exemption cert. valid-until date(YYYYMMDD) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | QSZDT_DI_KK | Allow NULL? |
| 42 | CORR_MAHNV | Correspondence Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CORR_MAHNV_KK | Allow NULL? |
| 43 | FITYP | Tax type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1AFITPV | J_1AFITP_D | Allow NULL? |
| 44 | PROVINCE | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 45 | COUNTY | County Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005E | COUNC | Allow NULL? |
| 46 | VERTYP | Clearing Category For Clearing Postings | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK111 | VERTYP_KK | Allow NULL? |
| 47 | AUGRS_DEF | Clearing Restriction | char | 1 | 0 | CHAR | (N' ') | Yes | | AUGRS_DEF_KK | Allow NULL? |
| 48 | LANDL | Country Supplied (for Tax Notifications) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LANDL_KK | Allow NULL? |
| 49 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1BBRANCH | BUPLA | Allow NULL? |
| 50 | BPTAXTYPE1 | Tax Number Type 1 for Business Partner | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BPTAXTYPE1 | Allow NULL? |
| 51 | BPTAXTYPE2 | Tax Number type 2 for Business Partner | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BPTAXTYPE2 | Allow NULL? |
| 52 | INV_CATEGORY | Invoicing Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK2604 | INV_CATEGORY_KK | Allow NULL? |
| 53 | INVTP | Invoice Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | INVTP_PS | Allow NULL? |
| 54 | FCALID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WFCID | Allow NULL? |
| 55 | XFIX_EZAWE | Apply Manual Setting for Incoming Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_EZAWE_PS | Allow NULL? |
| 56 | XFIX_AZAWE | Apply Manual Setting for Outgoing Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_AZAWE_PS | Allow NULL? |
| 57 | XFIX_OP_LOCK | Apply Manual Setting for Lock Reason for Outgoing Payment | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_OP_LOCK_PS | Allow NULL? |
| 58 | XFIX_IKEY | Apply Manual Setting for Interest Key | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_IKEY_PS | Allow NULL? |
| 59 | XFIX_TOGRU | Apply Manual Setting for Tolerance Group | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_TOGRU_PS | Allow NULL? |
| 60 | XFIX_VERTYP | Apply Manual Setting for Clearing Category | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_VERTYP_PS | Allow NULL? |
| 61 | XFIX_MAHNV | Apply Manual Setting for Dunning Procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_MAHNV_PS | Allow NULL? |
| 62 | XFIX_COPRC | Apply Manual Setting for Correspondence Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_COPRC_PS | Allow NULL? |
| 63 | XFIX_CORR_MAHNV | Apply Manual Setting for Correspondence Dunning Procedure | char | 1 | 0 | CHAR | (N' ') | Yes | | XFIX_CORR_MAHNV_PS | Allow NULL? |
| 64 | XNO_AUTO_UPDATE | Deactivate Automatic Update of Student Account Entirely | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQSTUPD_NO_AUTOUPDATE | Allow NULL? |
