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