Table BPSUPPLIER
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BPSUPPLIER | BPS | Suppliers | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BPS0 | BPSNUM | No | |
| BPS1 | BPSNAM | Yes | |
| BPS2 | BPSSHO | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABCCLS | ABC class | M | 15 | 212 | ||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=3;ACCCOD;[V]GSUPCLE | Block | ||||
| AGTPCP | VAT collection agent | C | 4 | KAG | ||||
| AGTSATTAX | Regional taxes | C | 4 | KAG | ||||
| AMTCOD | Amount code | M | 10 | 269 | PFI | |||
| AUTINVCOD | Auto invoice code | A | 5 | KPO | ||||
| AUUID | Single identifier | AUUID | ||||||
| BOX1099 | 1099 box | A | 4 | S1099 | ||||
| BPAADD | Default address | ADR | ||||||
| BPAINV | Billing address | ADR | ||||||
| BPAPAY | Pay-to BP address | ADR | ||||||
| BPCNUM | Customer number | BPN | KDE | |||||
| BPCNUMBPS | Our customer no. | A | 15 | |||||
| BPRDSP | Payroll interface distribution | DSP | [DSP]DSP0=BPRDSP;1 | Block | MURAN | |||
| BPRPAY | Pay-to | BPR | [BPR]BPR0=[BPS]BPRPAY | Block | ||||
| BPSGRU | Supplier group | BPR | [BPR]BPR0=[BPS]BPSGRU | Block | ||||
| BPSINV | Supplier invoice | BPR | [BPR]BPR0=[BPS]BPSINV | Block | ||||
| BPSNAM | Company name | NAM | ||||||
| BPSNUM | Supplier | BPR | [BPR]BPR0=[BPS]BPSNUM | Delete | ||||
| BPSREM | Notes | A | 250 | |||||
| BPSRSK | Risk BP | BPR | [BPR]BPR0=[BPS]BPSRSK | Block | ||||
| BPSSHO | Short description | SHO | ||||||
| BPSTYP | Supplier type | M | 15 | 501 | ||||
| BPTNUM | Carrier | BPT | [BPT]BPT0=[BPS]BPTNUM | Block | ||||
| BSGCOD | Category | BSG | [BSG]BSG0=[BPS]BSGCOD | Block | ||||
| CAI | CAI number | A | 10 | KAG | ||||
| CCE | Dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CNTNAM | Default contact | NAM | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CSHDAT | Cash VAT limit date | D | KSP | |||||
| CSHVAT | Cash VAT tax rule | M | 4 | 1 | KSP | |||
| CUR | Currency | CUR | [TCU]TCU0=[BPS]CUR | Block | ||||
| CURCLC | Rate determination | M | 15 | 503 | ||||
| DADFLG | DAS2 | M | 4 | 1 | DAS | |||
| DATVLYCAI | CAI validity date | D | 1 | KAG | ||||
| DEP | Settlement discount | TDA | [TDA]TDA0=DEP;[V]GSUPCLE | Block | ||||
| DIA | Account structure | GDA | [GDA]GDA0=[BPS]DIA | Block | ||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[BPS]DIE | Block | ANA | |||
| DOUFLG | Dispute | M | 15 | 516 | ||||
| DUDCLC | Due date origin | M | 15 | 502 | ||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[BPS]EECICT | Block | ||||
| EECINCRAT | Intrastat increase | RAT | DEB | |||||
| EECLOC | Intrastat transport location | M | 15 | 236 | DEB | |||
| ENAFLG | Active | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FLG281 | 281.5 | M | 4 | 1 | BE281 | |||
| FLGSATTAX | Collection agent | C | 4 | KAG | ||||
| FRM1099 | 1099 form | M | 15 | 3601 | S1099 | |||
| FUPFLG | Delivery reminder | M | 4 | 1 | ||||
| GENMRK | Total rank | DCB | 3.2 | |||||
| INVDTA | Invoicing element | PFI | [PFI]PFI0=[BPS]INVDTA | Block | PFI | |||
| INVDTAAMT | % or amount | DCB | 11.4 | PFI | ||||
| IPTEXS | Expense allocation | ADI | [ADI]CODE=312;IPTEXS | Block | ||||
| LOC | Location | EMP | ||||||
| LTIMRK | LT rank | DCB | 2.2 | |||||
| LTIMRKCOE | Lead time coefficient | COE | ||||||
| MATTOL | Matching tolerance | MAT | [MAT]MAT0=[BPS]MATTOL | Block | ||||
| MDL | Delivery mode | MDL | [TMD]TMD0=[BPS]MDL | Block | ||||
| NORPRNFLG | Order form | M | 4 | 1 | ||||
| NREPRNFLG | Receipt note | M | 4 | 1 | ||||
| NRTPRNFLG | Return slip | M | 4 | 1 | ||||
| OCNFLG | Ack. reminder | M | 4 | 1 | ||||
| ORDFREFRT | Free freight threshold | MD1 | ||||||
| ORDMINAMT | Minimum order | MD1 | ||||||
| ORDTEX | Order acknowledgement | TXC | ||||||
| OSTAUZAMT | Authorized credit | MD1 | ||||||
| OSTCTL | Credit control | M | 15 | 234 | ||||
| PAYBAN | Payment bank | BAN | [BAN]BAN0=[BPS]PAYBAN | BSRA | ||||
| PAYLOKFLG | Payment hold | M | 4 | 1 | ||||
| PLISTC | Price list structure | PRS | [PRS]PRS0=2;PLISTC | Block | ||||
| PRIMRK | Price rank | DCB | 2.2 | |||||
| PRIMRKCOE | Price coefficient | COE | ||||||
| PRVNUM | Service supplier code | PRV | [PRV]PRV0=[BPS]PRVNUM | Block | FEE2 | |||
| PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Block | ||||
| PURPRITYP | Amount type | M | 10 | 243 | ||||
| QLYMRK | Quality rank | DCB | 2.2 | |||||
| QLYMRKCOE | Quality coefficient | COE | ||||||
| QTYMRK | Quantity rank | DCB | 2.2 | |||||
| QTYMRKCOE | Quantity coefficient | COE | ||||||
| RITCOD | Withholding code | 30 | RTZ | [RTZ]RTZ0=[BPS]RITCOD | Block | KIT | ||
| RITNBR | Number of codes | C | 4 | KIT | ||||
| RITPARCOE | Partner held | 10 | DCB | 9.2 | KIT | |||
| RITPARNAM | Name of partner | 10 | DES | KIT | ||||
| RITPARNBR | No. of partners | C | 4 | KIT | ||||
| RITRAT | Withholding tax allowance | DCB | 9.2 | KIT | ||||
| RSKMRK | Free rank | DCB | 2.2 | |||||
| RSKMRKCOE | Free coefficient | COE | ||||||
| RTNTEX | Return order | TXC | ||||||
| SATTAX | Provinces | A | 10 | KAG | ||||
| SEVLIN | Multi-line order | M | 4 | 1 | ||||
| TPMCOD | Template code | TPM | [TPM]TPM0=TPMCOD | RTZ | ||||
| TSSCOD | Statistical group | ADI | [ADI]CODE=indice+40;TSSCOD(indice) | Block | STS | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| UVYCOD | Unavailable | UVY | [TUV]UVY0=[BPS]UVYCOD | Block | ||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
| WLFLG | No WL verification | M | 4 | 1 | KPL |