| 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 | * | MANDT | Allow NULL? |
| 2 | APPL | Business Partner: Application Category | nvarchar | 4 | 0 | CHAR | (N' ') | No | TPZ12 | REBPAPPL | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 4 | ERDAT | Date on which the Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT_RF | Allow NULL? |
| 5 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM_RF | Allow NULL? |
| 6 | SPERR | Posting block for company code | char | 1 | 0 | CHAR | (N' ') | Yes | | SPERB_B | Allow NULL? |
| 7 | LOEVM | Deletion Flag for Master Record (Company Code Level) | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_B | Allow NULL? |
| 8 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TZUN | DZUAWA | Allow NULL? |
| 9 | AKONT | Reconciliation Account in General Ledger | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | AKONT | Allow NULL? |
| 10 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRGRU | Allow NULL? |
| 11 | VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T056 | VZSKZ | Allow NULL? |
| 12 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | DZWELS | Allow NULL? |
| 13 | XVERR | Indicator: Clearing between customer and vendor? | char | 1 | 0 | CHAR | (N' ') | Yes | | XVERR_LFB1 | Allow NULL? |
| 14 | ZAHLS | Block Key for Payment | char | 1 | 0 | CHAR | (N' ') | Yes | T008 | DZAHLS | Allow NULL? |
| 15 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 16 | EIKTO | Our account number with the vendor | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EIKTO_K | Allow NULL? |
| 17 | ZSABE | Clerk at vendor | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | DZSABE_K | Allow NULL? |
| 18 | KVERM | Memo | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KVERM | Allow NULL? |
| 19 | FDGRV | Planning group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T035 | FDGRV | Allow NULL? |
| 20 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T001S | BUSAB | Allow NULL? |
| 21 | LNRZE | Head office account number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LNRZE | Allow NULL? |
| 22 | LNRZB | Account number of the alternative payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LNRZB | Allow NULL? |
| 23 | ZINDT | Key date of the last interest calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZINDT | Allow NULL? |
| 24 | ZINRT | Interest calculation frequency in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZINRT | Allow NULL? |
| 25 | DATLZ | Date of the last interest calculation run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATLZ | Allow NULL? |
| 26 | XDEZV | Indicator: Local processing? | char | 1 | 0 | CHAR | (N' ') | Yes | | XDEZV | Allow NULL? |
| 27 | WEBTR | Bill of exchange limit (in local currency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | WEBTR | |
| 28 | KULTG | Probable time until check is paid | decimal | 3 | 0 | DEC | ((0)) | Yes | | KULTG | |
| 29 | REPRF | Check Flag for Double Invoices or Credit Memos | char | 1 | 0 | CHAR | (N' ') | Yes | | REPRF | Allow NULL? |
| 30 | TOGRU | Tolerance group for the business partner/G/L account | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T043G | TOGRU | Allow NULL? |
| 31 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | HBKID | Allow NULL? |
| 32 | XPORE | Indicator: Pay all items separately ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XPORE | Allow NULL? |
| 33 | QSZNR | Certificate Number of the Withholding Tax Exemption | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | QSZNR | Allow NULL? |
| 34 | QSZDT | Validity Date for Withholding Tax Exemption Certificate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QSZDT | Allow NULL? |
| 35 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QSSKZ | Allow NULL? |
| 36 | BLNKZ | Subsidy indicator for determining the reduction rates | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLNKZ | Allow NULL? |
| 37 | MINDK | Minority Indicators | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T059M | MINDK | Allow NULL? |
| 38 | ALTKN | Previous Master Record Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTKN | Allow NULL? |
| 39 | ZGRUP | Key for Payment Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TZGR | DZGRUP | Allow NULL? |
| 40 | MGRUP | Key for dunning notice grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T047R | MGRUP | Allow NULL? |
| 41 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T042F | UZAWE | Allow NULL? |
| 42 | QSREC | Vendor Recipient Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T059A | QSREC | Allow NULL? |
| 43 | QSBGR | Authority for Exemption from Withholding Tax | char | 1 | 0 | CHAR | (N' ') | Yes | | QSBGR | Allow NULL? |
| 44 | QLAND | Withholding Tax Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005Q | QLAND | Allow NULL? |
| 45 | XEDIP | Indicator: Send Payment Advices by EDI | char | 1 | 0 | CHAR | (N' ') | Yes | | XEDIP | Allow NULL? |
| 46 | FRGRP | Release Approval Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | VBWF08 | FRGRP | Allow NULL? |
| 47 | TOGRR | Tolerance group; Invoice Verification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T169L | TOGRR | Allow NULL? |
| 48 | TLFXS | Accounting clerk's fax number at the customer/vendor | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TLFXS | Allow NULL? |
| 49 | INTAD | Internet address of partner company clerk | nvarchar | 130 | 0 | CHAR | (N' ') | Yes | | INTAD | Allow NULL? |
| 50 | XLFZB | Indicator: Alternative payee using account number | char | 1 | 0 | CHAR | (N' ') | Yes | | XLFZB | Allow NULL? |
| 51 | GUZTE | Payment Terms Key for Credit Memos | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GUZTE | Allow NULL? |
| 52 | GRICD | Activity Code for Gross Income Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1AGICD | J_1AGICD_D | Allow NULL? |
| 53 | GRIDT | Distribution Type for Employment Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1ADTYP | J_1ADTYP_D | Allow NULL? |
| 54 | XAUSZ | Indicator for periodic account statements | char | 1 | 0 | CHAR | (N' ') | Yes | T048K | XAUSZ | Allow NULL? |
| 55 | CERDT | Certification date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CERDT | Allow NULL? |
| 56 | CONFS | Status of Change Authorization (Company Code Level) | char | 1 | 0 | CHAR | (N' ') | No | | CONFS_B | Allow NULL? |
| 57 | UPDAT | Date on Which the Changes Were Confirmed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | UPDAT_RF | Allow NULL? |
| 58 | UPTIM | Time of Last Change Confirmation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UPTIM_RF | Allow NULL? |
| 59 | NODEL | Deletion bock for master record (company code level) | char | 1 | 0 | CHAR | (N' ') | No | | NODEL_B | Allow NULL? |
| 60 | TLFNS | Accounting clerk's telephone number at business partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TLFNS | Allow NULL? |
