| 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 | USMDKBPBP_HEADER | Technical Key | int | 10 | 0 | INT4 | ((0)) | No | /1MD/MD______0B4 | USMD_TECH_KEY | Allow NULL? |
| 3 | /1MD/BPCOMPANY | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 4 | /1MD/BPASSGNM_ID | Multiple Assignment ID (Number) | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | MDG_BP_ASSIGNMENT_ID | Allow NULL? |
| 5 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 6 | /1MD/BPCUS_AKONT | Reconciliation Account in General Ledger | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AKONT | Allow NULL? |
| 7 | /1MD/BPCUS_BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRGRU | Allow NULL? |
| 8 | /1MD/BPCUS_BROBJ | Authorization object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BROBJ | Allow NULL? |
| 9 | /1MD/BPCUS_BUSAB | Accounting clerk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BUSAB | Allow NULL? |
| 10 | /1MD/BPCUS_BWBER | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BWBER | Allow NULL? |
| 11 | /1MD/BPCUS_CESSN | Accounts Receivable Pledging Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CESSION_KZ | Allow NULL? |
| 12 | /1MD/BPCUS_FUTUR | Future | char | 1 | 0 | CHAR | (N' ') | Yes | | FFUTURE | Allow NULL? |
| 13 | /1MD/BPCUS_HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HBKID | Allow NULL? |
| 14 | /1MD/BPCUS_KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KTOPL | Allow NULL? |
| 15 | /1MD/BPCUS_LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 16 | /1MD/BPLOCKB | Key of the Lockbox to Which the Customer Is To Pay | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | * | LOCKB | Allow NULL? |
| 17 | /1MD/BPCUS_OVDUE | Days Overdue | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OVDUE | Allow NULL? |
| 18 | /1MD/BPCUS_TOGRU | Tolerance group for the business partner/G/L account | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TOGRU | Allow NULL? |
| 19 | /1MD/BPWBRSL | Value Adjustment Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WBRSL | Allow NULL? |
| 20 | USMD_O_BP_CUS_CC | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 21 | /1MD/BPCUS_ALTKN | Previous Master Record Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTKN | Allow NULL? |
| 22 | /1MD/BPCUS_BLNKZ | (Obsolete) Subsidy Ind. for Determining the Reduction Rate | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | MDG_BP_BLNKZ | Allow NULL? |
| 23 | /1MD/BPCUS_DATLZ | Date of the last interest calculation run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATLZ | Allow NULL? |
| 24 | /1MD/BPCUS_EIKTO | Our account number at customer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EIKTO_D | Allow NULL? |
| 25 | /1MD/BPCUS_FDGRV | Planning group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FDGRV | Allow NULL? |
| 26 | /1MD/BPCUS_FRGRP | Release Approval Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FRGRP | Allow NULL? |
| 27 | /1MD/BPCUS_GUZTE | Payment Terms Key for Credit Memos | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GUZTE | Allow NULL? |
| 28 | /1MD/BPCUS_HWAER | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 29 | /1MD/BPCUS_INTAD | Internet address of partner company clerk | nvarchar | 130 | 0 | CHAR | (N' ') | Yes | | INTAD | Allow NULL? |
| 30 | /1MD/BPCUS_KULTG | Probable time until check is paid | decimal | 3 | 0 | DEC | ((0)) | Yes | | KULTG | |
| 31 | /1MD/BPCUS_KVERM | Memo | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KVERM | Allow NULL? |
| 32 | /1MD/BPCUS_LOEVB | Deletion Flag for Master Record (Company Code Level) | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_B | Allow NULL? |
| 33 | /1MD/BPCUS_MGRUP | Key for dunning notice grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MGRUP | Allow NULL? |
| 34 | /1MD/BPCUS_NDELC | Deletion bock for master record (company code level) | char | 1 | 0 | CHAR | (N' ') | Yes | | NODEL_B | Allow NULL? |
| 35 | /1MD/BPCUS_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 36 | /1MD/BPCUS_SPERB | Posting block for company code | char | 1 | 0 | CHAR | (N' ') | Yes | | SPERB_B | Allow NULL? |
| 37 | /1MD/BPCUS_TLFNS | Accounting clerk's telephone number at business partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TLFNS | Allow NULL? |
| 38 | /1MD/BPCUS_TLFXS | Accounting clerk's fax number at the customer/vendor | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TLFXS | Allow NULL? |
| 39 | /1MD/BPCUS_UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
| 40 | /1MD/BPCUS_VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VZSKZ | Allow NULL? |
| 41 | /1MD/BPCUS_WEBTR | Bill of exchange limit (in local currency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | WEBTR | |
| 42 | /1MD/BPCUS_XAUSZ | Indicator for periodic account statements | char | 1 | 0 | CHAR | (N' ') | Yes | * | XAUSZ | Allow NULL? |
| 43 | /1MD/BPCUS_XDEZV | Indicator: Local processing? | char | 1 | 0 | CHAR | (N' ') | Yes | | XDEZV | Allow NULL? |
| 44 | /1MD/BPCUS_XEDIP | Indicator: Send Payment Advices by EDI | char | 1 | 0 | CHAR | (N' ') | Yes | | XEDIP | Allow NULL? |
| 45 | /1MD/BPCUS_XPORE | Indicator: Pay all items separately ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XPORE | Allow NULL? |
| 46 | /1MD/BPCUS_XVERR | Indicator: Clearing between customer and vendor ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XVERR_KNB1 | Allow NULL? |
| 47 | /1MD/BPCUS_ZAHLS | Block Key for Payment | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZAHLS | Allow NULL? |
| 48 | /1MD/BPCUS_ZGRUP | Key for Payment Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | DZGRUP | Allow NULL? |
| 49 | /1MD/BPCUS_ZINDT | Key date of the last interest calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZINDT | Allow NULL? |
| 50 | /1MD/BPCUS_ZINRT | Interest calculation frequency in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZINRT | Allow NULL? |
| 51 | /1MD/BPCUS_ZSABE | User at customer | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | DZSABE_D | Allow NULL? |
| 52 | /1MD/BPCUS_ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 53 | /1MD/BPCUS_ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DZUAWA | Allow NULL? |
| 54 | /1MD/BPCUS_ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | DZWELS | Allow NULL? |
| 55 | /1MD/BPEKVBD | Account Number of Buying Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EKVBD | Allow NULL? |
| 56 | /1MD/BPKNRZB | Account number of an alternative payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KNRZB | Allow NULL? |
| 57 | /1MD/BPKNRZE | Head office account number (in branch accounts) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KNRZE | Allow NULL? |
| 58 | /1MD/BPPERKZ | Collective invoice variant | char | 1 | 0 | CHAR | (N' ') | Yes | | PERKZ_KNB1 | Allow NULL? |
| 59 | /1MD/BPREMIT | Next payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | REMIT | Allow NULL? |
| 60 | /1MD/BPSREGL | Selection Rule for Payment Advices | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | SREGL | Allow NULL? |
| 61 | /1MD/BPURLID | Short Key for Known/Negotiated Leave | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | URLID | Allow NULL? |
| 62 | /1MD/BPVERDT | Insurance validity date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VERDT | Allow NULL? |
| 63 | /1MD/BPVLIBB | Amount Insured | decimal | 13 | 2 | CURR | ((0)) | Yes | | VLIBB | |
| 64 | /1MD/BPVRBKZ | Export credit insurance institution number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VRBKZ | Allow NULL? |
| 65 | /1MD/BPVRSDG | Reason Code Conversion Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VRSDG | Allow NULL? |
| 66 | /1MD/BPVRSNR | Insurance number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VRSNR | Allow NULL? |
| 67 | /1MD/BPVRSPR | Deductible percentage rate | decimal | 3 | 0 | DEC | ((0)) | Yes | | VRSPR | |
| 68 | /1MD/BPVRSZL | Insurance lead months | decimal | 3 | 0 | DEC | ((0)) | Yes | | VRSZL | |
| 69 | /1MD/BPWAKON | Terms of payment key for bill of exchange charges | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WAKON | Allow NULL? |
| 70 | /1MD/BPXZVER | Indicator: Record Payment History ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XZVER | Allow NULL? |
| 71 | /1MD/BPZAMIB | Indicator: Payment notice to the accounting department ? | char | 1 | 0 | CHAR | (N' ') | Yes | | DZAMIB | Allow NULL? |
| 72 | /1MD/BPZAMIM | Indicator: Payment notice to customer (with cleared items)? | char | 1 | 0 | CHAR | (N' ') | Yes | | DZAMIM | Allow NULL? |
| 73 | /1MD/BPZAMIO | Indicator: payment notice to customer (w/o cleared items)? | char | 1 | 0 | CHAR | (N' ') | Yes | | DZAMIO | Allow NULL? |
| 74 | /1MD/BPZAMIR | Indicator: payment notice to legal department? | char | 1 | 0 | CHAR | (N' ') | Yes | | DZAMIR | Allow NULL? |
| 75 | /1MD/BPZAMIV | Indicator: payment notice to sales department? | char | 1 | 0 | CHAR | (N' ') | Yes | | DZAMIV | Allow NULL? |
