Table BPARTNER
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BPARTNER | BPR | Business partner | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BPR0 | BPRNUM | No | |
| BPR1 | BPRSHO | Yes | |
| BPR2 | BETFCY+FCY+BPRNUM | No | |
| BPR3 | BPSFLG+CRN+EECNUM | Yes | EINV |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=17;ACCCOD;[V]GSUPCLE | Block | ||||
| ACCNONREI | Non resident account | ADR | ||||||
| ACS | Report access code | ACS | [ACS]ACS0=[BPR]ACS | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| BETFCY | Intersite | M | 4 | 1 | ||||
| BIDCRY | Bank acct. country | CRY | [TCY]TCY0=[BPR]BIDCRY | Block | ||||
| BIDNUM | Dft. bank details | BID | ||||||
| BPAADD | Default address | ADR | ||||||
| BPCFLG | Customer | M | 4 | 1 | ||||
| BPPFLG | Public sector | M | 4 | 1 | ||||
| BPRACC | Miscellaneous BP | M | 4 | 1 | ||||
| BPRFBDMAG | Mailing prohibited | M | 4 | 1 | ||||
| BPRFLG | Miscellaneous | 4 | M | 4 | 1 | |||
| BPRGTETYP | Entry type | GTE | [GTE]GTE0=BPRGTETYP;[V]GSUPCLE | Block | ||||
| BPRLOG | Acronym | A | 10 | |||||
| BPRNAM | Company name | 2 | NAM | |||||
| BPRNUM | BP | BPR | [BPR]BPR0=[BPR]BPRNUM | Other | ||||
| BPRSHO | Short description | SHO | ||||||
| BPSFLG | Supplier | M | 4 | 1 | ||||
| BPTFLG | Carrier | M | 4 | 1 | ||||
| BRGCOD | Category | BCG | [BCG]BCG0=[BPR]BRGCOD | BSRA | ||||
| BRGOBJ | Cust/suppl cat | A | 3 | |||||
| CCNFLG | Grantor | M | 4 | 1 | CCN | |||
| CFOEXD | Cash excluded | M | 4 | 1 | CFOM | |||
| CNTNAM | Default contact | NAM | ||||||
| CPYREL | Related company | M | 15 | 3664 | PBDPO | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRN | Site tax ID no. | CRT | ||||||
| CRY | Country | CRY | [TCY]TCY0=[BPR]CRY | Block | ||||
| CSLBPR | Partner | BPR | [BPR]BPR0=[BPR]CSLBPR | Block | PRCSL | |||
| CUR | Currency | CUR | [TCU]TCU0=[BPR]CUR | Block | ||||
| DOCTYP | Document type | M | 4 | 2004 | KSP | |||
| DOOFLG | Service caller | M | 4 | 1 | ||||
| EECNUM | EU VAT no. | A | 20 | DEB | ||||
| EINVTYP | Electronic invoice type | M | 15 | 2127 | EINV | |||
| ENAFLG | Active | M | 4 | 1 | ||||
| EORINUM | EORI number | A | 35 | EORI | ||||
| EXPNUM | Export number | L | 8 | |||||
| FCTFLG | Factor | M | 4 | 1 | ||||
| FCY | Site | FCY | [FCY]FCY0=[BPR]FCY | Block | ||||
| FISCOD | Fiscal code | A | 20 | KIT | ||||
| GRUCOD | Consolidation | A | 10 | CSL | ||||
| GRUGPY | Consolidation group | A | 5 | |||||
| INTSRVCOD | Service code | A | 100 | EINV | ||||
| LAN | Language | LAN | [TLA]TLA0=[BPR]LAN | Block | ||||
| LEGETT | Natural person | M | 4 | 1 | ||||
| MAPCOD | E-invoicing mapping code | MAPNAM | [EINVMAP]EINVMAP0=[BPR]MAPCOD | Block | EINV | |||
| MODPAM | CFONB payment | ADI | [ADI]CODE=311;MODPAM | Block | ||||
| NAF | SIC code | NAF | KFR | |||||
| PPTFLG | Prospect | M | 4 | 1 | ||||
| PRVFLG | Service supplier | M | 4 | 1 | ||||
| PTHFLG | Ship-to | C | 4 | KAG | ||||
| REGNUM | Registration number | A | 14 | KZA | ||||
| REPFLG | Sales rep | M | 4 | 1 | ||||
| RTGCOD | Routing code | A | 100 | EINV | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VATNO | VAT number | A | 10 | KZA | ||||
| VATNUM | IVA partita | A | 15 | KIT |