Table BPCUSTOMER
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BPCUSTOMER | BPC | Customers | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BPC0 | BPCNUM | No | |
| BPC1 | BPCNAM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABCCLS | ABC class | M | 15 | 212 | ||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=2;ACCCOD;[V]GSUPCLE | Block | ||||
| AEIFLG | Electronic invoice | C | 4 | ELINV | ||||
| AGTPCP | VAT collection agent | C | 4 | KAG | ||||
| AGTSATTAX | Regional taxes | C | 4 | KAG | ||||
| AUUID | Single identifier | AUUID | ||||||
| BCGCOD | Category | BCG | [BCG]BCG0=[BPC]BCGCOD | Block | ||||
| BELVATSUB | Subject to tax | M | 4 | 1 | KBE | |||
| BPAADD | Default address | ADR | ||||||
| BPAINV | Address | ADR | ||||||
| BPAPYR | Address | ADR | ||||||
| BPCBPSNUM | Our supplier no. | A | 15 | |||||
| BPCCDTISR | Insurance company | BPR | [BPR]BPR0=[BPC]BPCCDTISR | Block | ||||
| BPCGRU | Group customer | BPR | [BPR]BPR0=[BPC]BPCGRU | Block | ||||
| BPCINV | Bill-to customer | BPR | [BPR]BPR0=[BPC]BPCINV | Block | ||||
| BPCNAM | Company name | NAM | ||||||
| BPCNUM | Customer | BPR | [BPR]BPR0=[BPC]BPCNUM | Delete | ||||
| BPCPYR | Pay-by customer | BPR | [BPR]BPR0=[BPC]BPCPYR | Block | ||||
| BPCREM | Notes | A | 250 | |||||
| BPCRSK | Risk customer | BPR | [BPR]BPR0=[BPC]BPCRSK | Block | ||||
| BPCSHO | Short description | SHO | ||||||
| BPCSNCDAT | Customer since | D | ||||||
| BPCSTA | Active customer | M | 4 | 1 | ||||
| BPCTYP | Type | M | 15 | 401 | ||||
| BPDADD | Ship-to customer address | ADR | ||||||
| BUS | Business | ADI | [ADI]CODE=425;BUS | RTZ | ||||
| CCE | Dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CDTISR | Credit insurance | MD1 | ||||||
| CDTISRDAT | Insurance date | D | ||||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CNTEFAT | Contact | AIN | [AIN]AIN0=[BPC]CNTEFAT | Block | EFAT | |||
| CNTFIRDAT | First contact date | D | ||||||
| CNTLASDAT | Last contact date | D | PPT | |||||
| CNTLASTYP | Last contact type | M | 10 | 431 | PPT | |||
| CNTNAM | Default contact | NAM | ||||||
| CNTNEXDAT | Next contact date | D | PPT | |||||
| CNTNEXTYP | Next contact type | M | 10 | 431 | PPT | |||
| COMCAT | Commission category | M | 15 | 403 | ||||
| COTCHX | Service contract | COT | [COT]COT0=COTCHX | RTZ | ||||
| COTPITRQD | Tokens necessary | L | 8 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CSHVATRGM | Tax rule | 9 | M | 4 | 1 | KPO | ||
| CUR | Currency | CUR | [TCU]TCU0=[BPC]CUR | Block | ||||
| DAYMON | Day of the month | 6 | C | 2 | ||||
| DEP | Settlement discount | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DIA | Account structure | GDA | [GDA]GDA0=[BPC]DIA | Block | ||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[BPC]DIE | Block | ANA | |||
| DME | Partial delivery | M | 15 | 414 | ||||
| DUDCLC | Due date origin | M | 15 | 407 | ||||
| ELECTINV | Electronic invoice | M | 4 | 1 | EFAT | |||
| EXPNUM | Export number | L | 8 | |||||
| FCTNUM | Factor | FCT | [FCT]FCT0=[BPC]FCTNUM | Block | FCT | |||
| FLGSATTAX | Collection agent | C | 4 | KAG | ||||
| FREINV | Freight invoicing | M | 15 | 402 | ||||
| FUPMINAMT | Minimum reminder | MD1 | FUP | |||||
| FUPTYP | Reminder type | M | 15 | 235 | FUP | |||
| GRP | Group | FGP | [FGP]FGP0=[BPC]GRP | Block | FUP | |||
| IME | Invoicing mode | M | 15 | 408 | ||||
| INVCND | Invoic. term | INVCND | [INVCND]INVCND0=INVCND;[V]GSUPCLE | Block | ||||
| INVDTA | Invoicing element | SFI | [SFI]SFI0=[BPC]INVDTA | Other | SFI | |||
| INVDTAAMT | % or amt inv el | DCB | 11.4 | SFI | ||||
| INVPER | Invoice period | M | 15 | 406 | ||||
| INVTEX | Invoice header text | TXC | ||||||
| LNDAUZ | Loan authorized | M | 4 | 1 | LND | |||
| MTCFLG | Matchable | M | 4 | 1 | ||||
| OCNFLG | Print acknowledgment | M | 4 | 1 | ||||
| ODL | One order per delivery | M | 4 | 1 | ||||
| ORDCLE | Close unfilled lines | M | 4 | 1 | ||||
| ORDFIRDAT | First order date | D | ||||||
| ORDMINAMT | Min order amt | MD1 | ||||||
| ORDTEX | Ord header text | TXC | ||||||
| ORIPPT | Source | ADI | [ADI]CODE=413;ORIPPT | RTZ | ||||
| OSTAUZ | Authorized credit | MD1 | ||||||
| OSTCTL | Credit control | M | 15 | 234 | ||||
| PAYBAN | Payment bank | BAN | [BAN]BAN0=[BPC]PAYBAN | BSRA | ||||
| PITCDT | Token credits | L | 8 | |||||
| PITCPT | Additional info | L | 8 | |||||
| PPTFLG | Prospect | M | 4 | 1 | PPT | |||
| PRITYP | Price - / +tax | M | 6 | 243 | ||||
| PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Block | ||||
| QUOLASDAT | Last quote date | D | PPT | |||||
| REP | Sales rep | REP | [REP]REP0=[BPC]REP | Block | REC | |||
| SATTAX | Provinces | A | 1 | KAG | ||||
| SOIPER | Note type | M | 15 | 404 | ||||
| STRDATEFAT | Start date | D | EFAT | |||||
| TOTPIT | Total credit | L | 8 | |||||
| TPMCOD | Template code | TPM | [TPM]TPM0=TPMCOD | RTZ | ||||
| TSCCOD | Statistical group | ADI | [ADI]CODE=indice+30;TSCCOD(indice) | Block | STC | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| UVYCOD2 | Unavailable period | UVY | [TUV]UVY0=[BPC]UVYCOD2 | Block | ||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
| VATENDDAT | VAT end date | 9 | D | KPO | ||||
| VATEXN | Exemption no. | A | 15 | |||||
| VATSTRDAT | VAT start date | 9 | D | KPO |