Table FACILITY

Table Abbreviation Description Module Activity code
FACILITY FCY Sites Supervisor  

Key Description Duplicates Activity code
FCY0 FCY No  
FCY1 LEGCPY+FCY No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCCOD Accounting code   A 10       CPT
AUUID Single identifier   AUUID          
BIDNUM Bank ID number   BID          
BPAADD Default address   ADR          
BPTNUM Carrier   A 10        
CCE Analytical dimension   A 10        
CNTNAM Contact   A 10        
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   AUS     [AUS]CODUSR=[FCY]CREUSR Other  
CRN Site registration number   CRT          
CRY Country   CRY     [TCY]TCY0=[FCY]CRY Block  
DADFCY DAS2 site   FCY     [FCY]FCY0=[FCY]DADFCY Other  
DADFLG DAS2   M 4 1      
EORINUM EORI number   A 35       EORI
FCY Site   FCY     [FCY]FCY0=[FCY]FCY Delete  
FCYNAM Name   NAM          
FCYSHO Short description   SHO          
FINFLG Accounting   M 4 1      
FINRSPFCY Financial site   FCY     [FCY]FCY0=[FCY]FINRSPFCY Other  
GEOCOD Geographic code   A 10       KUS
INSCTYFLG City interior flag   A 10       KUS
LEG Legislation   ADI     [ADI]CODE=909;LEG Block  
LEGCPY Legal company   CPY     [CPY]CPY0=[FCY]LEGCPY Block  
MFGFLG Manufacturing   M 4 1      
NAF SIC code   NAF          
PAYBAN Payment bank   A 10        
PURFLG Purchase   M 4 1      
SALFLG Sales   M 4 1      
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   AUS     [AUS]CODUSR=[FCY]UPDUSR Other  
UVYCOD Unavailable   UVY          
UVYDAY Unavail. (everyday) 7 M 4 1      
WRHFLG Warehouse   M 4 1