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 | ||||
INVORIMOD | Default inv module | M | 4 | 2128 | EINV | |||
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 | ||||||
REXNUM | REX number | A | 30 | REX | ||||
RITCOD | Withholding code | 30 | RTZ | [RTZ]RTZ0=[BPS]RITCOD | Block | WTHMG | ||
RITNBR | Number of codes | C | 4 | WTHMG | ||||
RITPARCOE | Partner held | 10 | DCB | 9.2 | WTHMG | |||
RITPARNAM | Name of partner | 10 | DES | WTHMG | ||||
RITPARNBR | No. of partners | C | 4 | WTHMG | ||||
RITRAT | Withholding tax allowance | DCB | 9.2 | WTHMG | ||||
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 |