| 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 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | No | LFA1 | LIFNR | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 4 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 5 | ERDAT | Date on which the Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT_RF | Allow NULL? |
| 6 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM_RF | Allow NULL? |
| 7 | SPERR | Posting block for company code | char | 1 | 0 | CHAR | (N' ') | Yes | | SPERB_B | Allow NULL? |
| 8 | LOEVM | Deletion Flag for Master Record (Company Code Level) | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_B | Allow NULL? |
| 9 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TZUN | DZUAWA | Allow NULL? |
| 10 | AKONT | Reconciliation Account in General Ledger | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | AKONT | Allow NULL? |
| 11 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRGRU | Allow NULL? |
| 12 | VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T056 | VZSKZ | Allow NULL? |
| 13 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | DZWELS | Allow NULL? |
| 14 | XVERR | Indicator: Clearing between customer and vendor? | char | 1 | 0 | CHAR | (N' ') | Yes | | XVERR_LFB1 | Allow NULL? |
| 15 | ZAHLS | Block Key for Payment | char | 1 | 0 | CHAR | (N' ') | Yes | T008 | DZAHLS | Allow NULL? |
| 16 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 17 | EIKTO | Our account number with the vendor | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EIKTO_K | Allow NULL? |
| 18 | ZSABE | Clerk at vendor | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | DZSABE_K | Allow NULL? |
| 19 | KVERM | Memo | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KVERM | Allow NULL? |
| 20 | FDGRV | Planning group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T035 | FDGRV | Allow NULL? |
| 21 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T001S | BUSAB | Allow NULL? |
| 22 | LNRZE | Head office account number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LNRZE | Allow NULL? |
| 23 | LNRZB | Account number of the alternative payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LNRZB | Allow NULL? |
| 24 | ZINDT | Key date of the last interest calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZINDT | Allow NULL? |
| 25 | ZINRT | Interest calculation frequency in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZINRT | Allow NULL? |
| 26 | DATLZ | Date of the last interest calculation run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATLZ | Allow NULL? |
| 27 | XDEZV | Indicator: Local processing? | char | 1 | 0 | CHAR | (N' ') | Yes | | XDEZV | Allow NULL? |
| 28 | WEBTR | Bill of exchange limit (in local currency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | WEBTR | |
| 29 | KULTG | Probable time until check is paid | decimal | 3 | 0 | DEC | ((0)) | Yes | | KULTG | |
| 30 | REPRF | Check Flag for Double Invoices or Credit Memos | char | 1 | 0 | CHAR | (N' ') | Yes | | REPRF | Allow NULL? |
| 31 | TOGRU | Tolerance group for the business partner/G/L account | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T043G | TOGRU | Allow NULL? |
| 32 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | HBKID | Allow NULL? |
| 33 | XPORE | Indicator: Pay all items separately ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XPORE | Allow NULL? |
| 34 | QSZNR | Certificate Number of the Withholding Tax Exemption | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | QSZNR | Allow NULL? |
| 35 | QSZDT | Validity Date for Withholding Tax Exemption Certificate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | QSZDT | Allow NULL? |
| 36 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QSSKZ | Allow NULL? |
| 37 | BLNKZ | Subsidy indicator for determining the reduction rates | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLNKZ | Allow NULL? |
| 38 | MINDK | Minority Indicators | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T059M | MINDK | Allow NULL? |
| 39 | ALTKN | Previous Master Record Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTKN | Allow NULL? |
| 40 | ZGRUP | Key for Payment Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TZGR | DZGRUP | Allow NULL? |
| 41 | MGRUP | Key for dunning notice grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T047R | MGRUP | Allow NULL? |
| 42 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T042F | UZAWE | Allow NULL? |
| 43 | QSREC | Vendor Recipient Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T059A | QSREC | Allow NULL? |
| 44 | QSBGR | Authority for Exemption from Withholding Tax | char | 1 | 0 | CHAR | (N' ') | Yes | | QSBGR | Allow NULL? |
| 45 | QLAND | Withholding Tax Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005Q | QLAND | Allow NULL? |
| 46 | XEDIP | Indicator: Send Payment Advices by EDI | char | 1 | 0 | CHAR | (N' ') | Yes | | XEDIP | Allow NULL? |
| 47 | FRGRP | Release Approval Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | VBWF08 | FRGRP | Allow NULL? |
| 48 | TOGRR | Tolerance group; Invoice Verification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T169L | TOGRR | Allow NULL? |
| 49 | TLFXS | Accounting clerk's fax number at the customer/vendor | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TLFXS | Allow NULL? |
| 50 | INTAD | Internet address of partner company clerk | nvarchar | 130 | 0 | CHAR | (N' ') | Yes | | INTAD | Allow NULL? |
| 51 | XLFZB | Indicator: Alternative payee using account number | char | 1 | 0 | CHAR | (N' ') | Yes | | XLFZB | Allow NULL? |
| 52 | GUZTE | Payment Terms Key for Credit Memos | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GUZTE | Allow NULL? |
| 53 | GRICD | Activity Code for Gross Income Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1AGICD | J_1AGICD_D | Allow NULL? |
| 54 | GRIDT | Distribution Type for Employment Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1ADTYP | J_1ADTYP_D | Allow NULL? |
| 55 | XAUSZ | Indicator for periodic account statements | char | 1 | 0 | CHAR | (N' ') | Yes | T048K | XAUSZ | Allow NULL? |
| 56 | CERDT | Certification date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CERDT | Allow NULL? |
| 57 | CONFS | Status of Change Authorization (Company Code Level) | char | 1 | 0 | CHAR | (N' ') | No | | CONFS_B | Allow NULL? |
| 58 | UPDAT | Date on Which the Changes Were Confirmed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | UPDAT_RF | Allow NULL? |
| 59 | UPTIM | Time of Last Change Confirmation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UPTIM_RF | Allow NULL? |
| 60 | NODEL | Deletion bock for master record (company code level) | char | 1 | 0 | CHAR | (N' ') | No | | NODEL_B | Allow NULL? |
| 61 | TLFNS | Accounting clerk's telephone number at business partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TLFNS | Allow NULL? |
| 62 | AVSND | Indicator: Send Payment Advice by XML | char | 1 | 0 | CHAR | (N' ') | Yes | | AVSND | Allow NULL? |
| 63 | AD_HASH | E-Mail Address for Avis: Hash Value | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ADHASH | Allow NULL? |
| 64 | CVP_XBLCK_B | Business Purpose Completed Flag | char | 1 | 0 | CHAR | (N' ') | No | | CVP_XBLCK | Allow NULL? |
| 65 | CIIUCODE | Main economic activity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CIIUCODE | Allow NULL? |
| 66 | ZBOKD | LEDGER MANAGEMENT EXPIRATION DATE | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /ATL/VBOKD | Allow NULL? |
| 67 | ZQSSKZ | Future Withholding tax code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T059Q | /ATL/VQSSKZ | Allow NULL? |
| 68 | ZQSZDT | Validity date for withholding tax exemption certificate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /ATL/VQSZDT | Allow NULL? |
| 69 | ZQSZNR | Certificate number of the withholding tax exemption | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /ATL/VQSZNR | Allow NULL? |
| 70 | ZMINDAT | Certification date for minimum wage | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /ATL/VMINDAT | Allow NULL? |
| 71 | J_SC_SUBCONTYPE | Subcontractor Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPNEA/J_SC_SUBCONTYPE | Allow NULL? |
| 72 | J_SC_COMPDATE | Completion Date Of Inspection | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /SAPNEA/J_SC_COMPLETIONDATE | Allow NULL? |
| 73 | J_SC_OFFSM | Offset Method | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPNEA/J_SC_OFFSM | Allow NULL? |
| 74 | J_SC_OFFSR | Offset Percentage | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /SAPNEA/J_SC_OFFSR | Allow NULL? |
| 75 | BASIS_PNT | Average daily basis points for purchase cards | decimal | 6 | 3 | DEC | ((0)) | Yes | | FMBASIS_POINTS | |
| 76 | GMVKZK | Vendor is in execution | char | 1 | 0 | CHAR | (N' ') | Yes | | GMVKZK | Allow NULL? |
| 77 | PREPAY_RELEVANT | Prepayment Relevance (Vendor Master) | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_PREPAY_RELEVANT | Allow NULL? |
| 78 | ASSIGN_TEST | Assignment Test Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | WRF_ASSIGN_GRP | WRF_MRM_ASSIGN_GROUP | Allow NULL? |
