Table Abbreviation Description Module Activity code
BPCUSTOMERXT BPCTX Customers Common Data  

Key Description Duplicates Activity code
BPC0 UIDSES+BPCNUM No  

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  
ACCNONREI Non resident account   ADR          
ACS Report access code   ACS     [ACS]ACS0=[BPCTX]ACS 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=[BPCTX]BCGCOD Block  
BELVATSUB Subject to tax   M 4 1     KBE
BETFCY Intersite   M 4 1      
BPAADD Default address   ADR          
BPAINV Address   ADR          
BPAPYR Address   ADR          
BPCBPSNUM Our supplier no.   A 15        
BPCCDTISR Insurance company   BPR     [BPR]BPR0=[BPCTX]BPCCDTISR Block  
BPCGRU Group customer   BPR     [BPR]BPR0=[BPCTX]BPCGRU Block  
BPCINV Bill-to customer   BPR     [BPR]BPR0=[BPCTX]BPCINV Block  
BPCNAM Company name   NAM          
BPCNUM Customer   BPR     [BPR]BPR0=[BPCTX]BPCNUM Delete  
BPCPYR Pay-by customer   BPR     [BPR]BPR0=[BPCTX]BPCPYR Block  
BPCREM Notes   A 250        
BPCRSK Risk customer   BPR     [BPR]BPR0=[BPCTX]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          
BPPFLG Public sector   M 4 1      
BPRFBDMAG Mailing prohibited   M 4 1      
BPRLOG Acronym   A 10        
BRGCOD Category   BCG     [BCG]BCG0=[BPCTX]BRGCOD Block  
BRGOBJ Cust/suppl cat   A 3        
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          
CFOEXD Cash excluded   M 4 1     CFOM
CHGTYP Rate type   M 15 202      
CNTEFAT Contact   AIN     [AIN]AIN0=[BPCTX]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        
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          
CRUD Create/Read/Update/Delete   A 1        
CRY Country   CRY     [TCY]TCY0=[BPCTX]CRY Block  
CSHVATRGM Tax rule 9 M 4 1     KPO
CSLBPR Partner   BPR     [BPR]BPR0=[BPCTX]CSLBPR Block PRCSL
CUR Currency   CUR     [TCU]TCU0=[BPCTX]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=[BPCTX]DIA Block  
DIE Dimension type code   DIE     [DIE]DIE0=[BPCTX]DIE Block ANA
DME Partial delivery   M 15 414      
DOCTYP Document type   M 4 2004     KSP
DOOFLG Service caller   M 4 1      
DUDCLC Due date origin   M 15 407      
EECNUM EU VAT no.   A 20       DEB
ELECTINV Electronic invoice   M 4 1     EFAT
EORINUM EORI number   A 35       EORI
EXPNUM Export number   L 8        
FCTNUM Factor   FCT     [FCT]FCT0=[BPCTX]FCTNUM Block FCT
FCY Site   FCY     [FCY]FCY0=[BPCTX]FCY Block  
FISCOD Fiscal code   A 20       KIT
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=[BPCTX]GRP Block FUP
GRUCOD Consolidation   A 10       CSL
GRUGPY Consolidation group   A 5        
IME Invoicing mode   M 15 408      
INVCND Invoic. term   INVCND     [INVCND]INVCND0=INVCND;[V]GSUPCLE Block  
INVDTA Invoicing element   SFI     [SFI]SFI0=[BPCTX]INVDTA Other SFI
INVDTAAMT % or amt inv el   DCB 11.4       SFI
INVPER Invoice period   M 15 406      
INVTEX Invoice header text   TXC          
LAN Language   LAN     [TLA]TLA0=[BPCTX]LAN Block  
LEGETT Natural person   M 4 1      
LNDAUZ Loan authorized   M 4 1     LND
MODPAM CFONB payment   ADI     [ADI]CODE=311;MODPAM Block  
MTCFLG Matchable   M 4 1      
NAF SIC code   NAF         KFR
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=[BPCTX]PAYBAN BSRA  
PITCDT Token credits   L 8        
PITCPT Additional info   L 8        
PPTFLG Prospect   M 4 1     PPT
PRITYP Price - / +tax   M 6 243      
PRVFLG Service supplier   M 4 1      
PTE Payment term   PTE     [TPT]TPT0=PTE;[V]GCURLEG;1 Block  
QUOLASDAT Last quote date   D         PPT
REGNUM Registration number   A 14       KZA
REP Sales rep   REP     [REP]REP0=[BPCTX]REP Block REC
SATTAX Provinces   A 10       KAG
SOIPER Note type   M 15 404      
STRDATEFAT Start date   D         EFAT
TECIMP Import status   C 4        
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
UIDSES Session   L 8        
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
UVYCOD2 Unavailable period   UVY     [TUV]UVY0=[BPCTX]UVYCOD2 Block  
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VATENDDAT VAT end date 9 D         KPO
VATEXN Exemption no.   A 15        
VATNO VAT number   A 10       KZA
VATNUM IVA partita   A 15       KIT
VATSTRDAT VAT start date 9 D         KPO