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   CAC     [CAC]CAC0=[V]GCACFCY;ACCCOD;[V]GSUPCLE Block CPT
AUUID Single identifier   AUUID          
BIDNUM Bank acct. number   BID          
BPAADD Default address   ADR          
BPADCL Declaring site address   A 10       HRPAY
BPASGE Headquarters address   A 10       HRPAY
BPTNUM Carrier   A 10        
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CHEF Supervisors   A 10       HRPAY
CLLCVT Collective agreement   A 10       HRPAY
CNTDDS TDS contact   A 10       HRPAY
CNTNAM Contact   AIN     [AIN]AIN0=[FCY]CNTNAM Block  
CODCRA CRAM code   A 10       HRPAY
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 DAS
DADFLG DAS2   M 4 1     DAS
DIE Dimension type code   A 10       ANA
ENDHOU End   HM         TRSNE
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  
FLGAPP Apprenticeship tax   C 4       HRPAY
FLGFOR Prof. training   C 4       HRPAY
FLGPEC Housing levy   C 4       HRPAY
GEOCOD Geographic code   GEO         KUS
HRMDADFCY DADS site   A 10       HRPAY
HRMDADFLG DADS   C 4       HRPAY
HRMPAYBAN Bank   A 10       HRPAY
HRMTAXWAG Tax/salaries   C 4       HRPAY
INSCTYFLG City interior flag   A 1       KUS
IVYFCY Stock count site   FCY     [FCY]FCY0=[FCY]IVYFCY Other FAS
IVYFLG Count   M 4 1     FAS
LEG Legislation   ADI     [ADI]CODE=909;LEG Block  
LEGCPY Legal company   CPY     [CPY]CPY0=[FCY]LEGCPY Block  
MFGFLG Manufacturing   M 4 1      
MFGWRH Cons wareh   WRH     [WRH]WRH0=[FCY]MFGWRH Block WRH
MFPWRH WO receipt warehouse   WRH     [WRH]WRH0=[FCY]MFPWRH Block WRH
MFRWRH Reintegration whs   WRH     [WRH]WRH0=[FCY]MFRWRH Block WRH
NAF SIC code   NAF          
ORICERFLG Self-certification of origin   M 4 1     REX
PAYBAN Payment bank   BAN     [BAN]BAN0=[FCY]PAYBAN Block  
PAYFLG Payroll   C 4       HRPAY
PRF Profile   A 10       HRPAY
PURFLG Purchase   M 4 1      
RCPWRH Receipt warehouse   WRH     [WRH]WRH0=[FCY]RCPWRH Block WRH
REGPRH Industrial tribunal   C 4       HRPAY
REXNUM REX number   A 30       REX
RSKWRK Risk   A 10       HRPAY
RTNWRH Deliv return whs   WRH     [WRH]WRH0=[FCY]RTNWRH Block WRH
SALFLG Sales   M 4 1      
SCCWRH Sb-c cons warehouse   WRH     [WRH]WRH0=[FCY]SCCWRH Block WRH
SCOWRH Sub-ctrt ship wareh   WRH     [WRH]WRH0=[FCY]SCOWRH Block WRH
SECPRH Derogation polling subdivision   C 4       HRPAY
SERVICEID Service ID   A 100       EINV
SHIWRH Shipping warehouse   WRH     [WRH]WRH0=[FCY]SHIWRH Block WRH
SPAOPEIGIC IGIC operations   M 4 1     KSP
SRV Department   A 10       HRPAY
STRHOU Start   HM         TRSNE
TRAWRH Int rcpt warehouse   WRH     [WRH]WRH0=[FCY]TRAWRH Block WRH
TRFWRH Int issue warehouse   WRH     [WRH]WRH0=[FCY]TRFWRH Block WRH
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   AUS     [AUS]CODUSR=[FCY]UPDUSR Other  
UVYCOD Unavailable   UVY     [TUV]UVY0=[FCY]UVYCOD Block  
UVYDAY Unavail. (everyday) 7 M 4 1      
WRHFLG Warehouse   M 4 1      
WRHGES Warehouse management   M 4 1     WRH