Dictionary >  Module Fixed Assets >  Table Physical assets  

Display all Hide all

Table Abbreviation Description Module Activity code
PHYELT PHY Physical assets Fixed Assets PHY

Key Description Duplicates Activity code
PHY0 PHYREF No  
PHY3 BAC+CPY Yes  
PHY4 CPY+FCY+PHYREF No  
PHY5 AASREF+PHYREF No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AASREF Assignment asset   FAS     [FAS]FAS0=[PHY]AASREF Block  
AUUID Single identifier   AUUID          
BAC Barcode   BAC          
BPS Supplier   BPS     [BPS]BPS0=[PHY]BPS Block  
CNTNUM Contact   ADI     [ADI]CODE=630;CNTNUM Block  
COMMENT Comments   ACRTF 1        
CPY Company   CPY     [CPY]CPY0=[PHY]CPY Block  
CREDATTIM Date time   ADATIM          
CREORI Entry origin   M 15 3162      
CREUSR Creation user   A 5        
CURCND Current status   ADI     [ADI]CODE=538;CURCND Block  
DNUMRECEP Receipt date   D4          
DORDBUY Order date   D4          
ENAFLG Active   M 4 1      
FCY Financial site   FCY     [FCY]FCY0=[PHY]FCY Block  
GEOLOC Geolocation   A 250        
GRUORIPHY IGS source element   A 20        
ISSDAT Issue date   D4          
ISSTYP Disposal reason   M 15 3175      
IVYDAT Note date   D4          
IVYRES Phys asset count result   M 15 3194      
IVYTIM Note time   HS          
LCTCOD Location   LCT     [LCT]LCT0=LCTCOD Block  
NUMRECEP Receipt number   A 20        
ORDBUY Order number   A 20        
PHYCAT Category   ADI     [ADI]CODE=537;PHYCAT Block  
PHYDES1 Description   DCO          
PHYDES2 Description 2   DCO          
PHYREF Reference   PHY     [PHY]PHY0=[PHY]PHYREF Other  
PHYREFORI Original reference   A 20        
REFTAB1 Reference FF1   C 4        
REFTAB10 Reference FF10   C 4        
REFTAB2 Reference FF2   C 4        
REFTAB3 Reference FF3   C 4        
REFTAB4 Reference FF4   C 4        
REFTAB5 Reference FF5   C 4        
REFTAB6 Reference FF6   C 4        
REFTAB7 Reference FF7   C 4        
REFTAB8 Reference FF8   C 4        
REFTAB9 Reference FF9   C 4        
SRLNBR Serial number   SRL          
TRFDAT Last transfer   D4          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USRFLDA1 Free field 1   ADI     [ADI]CODE=REFTAB1;USRFLDA1 Block  
USRFLDA10 Free field 10   ADI     [ADI]CODE=REFTAB10;USRFLDA10 Block  
USRFLDA2 Free field 2   ADI     [ADI]CODE=REFTAB2;USRFLDA2 Block  
USRFLDA3 Free field 3   ADI     [ADI]CODE=REFTAB3;USRFLDA3 Block  
USRFLDA4 Free field 4   ADI     [ADI]CODE=REFTAB4;USRFLDA4 Block  
USRFLDA5 Free field 5   ADI     [ADI]CODE=REFTAB5;USRFLDA5 Block  
USRFLDA6 Free field 6   ADI     [ADI]CODE=REFTAB6;USRFLDA6 Block  
USRFLDA7 Free field 7   ADI     [ADI]CODE=REFTAB7;USRFLDA7 Block  
USRFLDA8 Free field 8   ADI     [ADI]CODE=REFTAB8;USRFLDA8 Block  
USRFLDA9 Free field 9   ADI     [ADI]CODE=REFTAB9;USRFLDA9 Block  
USRFLDC1 Free field 1 coef   COE          
USRFLDC2 Fr field coeff 2   COE          
USRFLDD1 Free field date 1   D4          
USRFLDD2 Free field date 2   D4          
USRFLDD3 Free field date 3   D4          
USRFLDD4 Free field date 4   D4          
USRFLDM1 Free field amount 1   MD1          
USRFLDM2 Free field amount 2   MD1          
USRFLDM3 Free field amount 3   MD1          
USRFLDM4 Free field amount 4   MD1          
USRFLDM5 Free field amount 5   MD1          
USRFLDM6 Free field 6 amount   MD1