Fixed Assets FAQ

Fixed Assets - Data Dictionary

01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASACTI                                 
                        File Description: Activity File                        

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    R_TAG          C     10     0   TAG NUMBER                              
   2    R_BOOK         C     15     0   BOOK AFFECTED IF ANY                    
   3    R_FIELD        C     10     0   FIELD THAT CHANGED                      
   4    R_USER         C     10     0   NETWORK USER NAME                       
   5    R_DATE         D      8     0   DATE OF ACTIVITY                        
   6    R_TIME         C      8     0   TIME OF ACTIVITY                        
   7    R_PREVIOUS     M      0     0   PREVIOUS VALUE                          
   8    R_CURRENT      M      0     0   CURRENT VALUE                           
   9    R_DELFLAG      C      1     0   * IF ASSET WAS DELETED                  
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL   9 FIELDS =   62

                                Related Indexes                                

ASACTI  : R_TAG+R_BOOK+DTOS(R_DATE)+R_TIME                                      .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASBMAS                                 
            File Description: Master Book File (One Record per Book)            

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    B_NAME         C     15     0   BOOK NAME                               
   2    B_DESCR        C     30     0   BOOK DESCRIPTION                        
   3    B_FISCAL       N      2     0   FISCAL MONTH                            
   4    B_DELFLAG      C      1     0   "*" IF RE-USEABLE                       
   5    B_NETSTAMP     N      2     0   NETWORK STAMP                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL   5 FIELDS =   50

                                Related Indexes                                

ASBMAS  : B_DELFLAG+B_NAME                                                      .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASBOOK                                 
                   File Description: Asset Listings for Books                   

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    K_TAG          C     10     0   ASSET ID #                              
   2    K_NAME         C     15     0   BOOK NAME                               
   3    K_BEGDATE      D      8     0   DATE TO BEGIN DEPRECIATION              
   4    K_ENDDATE      D      8     0   DATE TO END DEPRECIATION                
   5    K_STATUS       C      1     0   'T' IF THE ASSET IS FULLY DEPRECIATED   
   6    K_METHOD       C      4     0   METHOD USED FOR DEPRECIATION            
   7    K_CLASS        N      2     0   LIFE CLASS                              
   8    K_LIFE         N      4     0   LIFE IN MONTH, RECOVERY PERIOD          
   9    K_PERCENT      N      6     2   DEPRECIATION PERCENTAGE                 
  10    K_DEDUCTS      N     15     2   DEDUCTION AMOUNT                        
  11    K_YTD          N     15     2   YTD DEPRECIATION                        
  12    K_PRIOR        N     15     2   PRIOR TO CURRENT YEAR DEPRECIATION      
  13    K_ADJUST       N     15     2   ADJUSTMENT AMOUNT                       
  14    K_ADJDATE      D      8     0   DATE OF ADJUSTMENT                      
  15    K_AMTCONV      C      4     0   AMT CONVERSION METHOD FOR THIS DEP. METH
  16    K_AMTCLASS     C      2     0   AMT CLASS LIFE                          
  17    K_AMTLIFE      C      4     0   AMT LIFE IN MONTHS                      
  18    K_AMTPCNT      N      7     2   AMT CONVERSION DEPRECIATION RATE        
  19    K_DELFLAG      C      1     0   "*" IF REUSEABLE                        
  20    K_NETSTAMP     N      2     0   NETWORK STAMP                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  20 FIELDS =  146

                                Related Indexes                                

ASBOMD  : K_DELFLAG+K_NAME+K_METHOD+K_TAG                                       
ASBOOK  : K_DELFLAG+K_NAME+K_TAG                                                
ASBOTG  : K_DELFLAG+K_TAG+K_NAME                                                .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASPEND                                 
                   File Description: Pending New Fixed Assets                   

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    P_PURDATE      D      8     0   DATE PURCHASED                          
   2    P_COST         N     15     2   COST OF ASSET                           
   3    P_VENDNO       C      9     0   VENDOR NUMBER                           
   4    P_PONUM        C      8     0   PO NUMBER IF ANY                        
   5    P_NOTES        M      0     0   NOTES FOR THIS ASSET                    
   6    P_DELFLAG      C      1     0   DELETED FLAG                            
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL   6 FIELDS =   41

                                Related Indexes                                

ASPEND  : P_DELFLAG+DTOS(P_PURDATE)                                             .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASSETS                                 
                          File Description: Asset File                          

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    A_TAG          C     10     0   ASSET NUMBER                            
   2    A_DESC         C     40     0   ASSET DESCRIPTION                       
   3    A_QUANTITY     N     10     2   QUANTITY IN ONE ASSET IE: 10 UNIFORMS   
   4    A_ASSET        C     25     0   G/L ASSET ACCOUNT (ASSET)               
   5    A_LIAB         C     25     0   G/L LIABILITY ACCOUNT (LIABILITY)       
   6    A_DEPRE        C     25     0   G/L DEPRECIATION EXPENSE (EXPENSE)      
   7    A_ACCUM        C     25     0   G/L ACCUM. DEPRECIATION (CONTRA ASSET)  
   8    A_CASH         C     25     0   G/L CASH ACCOUNT                        
   9    A_INCOME       C     25     0   G/L INCOME OR LOSS FROM SALE            
  10    A_MANUFACT     C     25     0   MANFACTURER                             
  11    A_MODEL        C     25     0   MODEL NUMBER OF THIS ASSET              
  12    A_SERIAL       C     30     0   SERIAL NUMBER OF THE ASSET              
  13    A_USER         C     30     0   CUSTODIAN/USER OF THE ASSET             
  14    A_NEWASSET     C      1     0   'Y' IF A NEW ASSET                      
  15    A_INSURED      C      1     0   LETTER IF ISSURED (LETTER SIGNIFIES CO.)
  16    A_PURFROM      C     30     0   PURCHASED FROM?                         
  17    A_PURDATE      D      8     0   PURCHASE DATE                           
  18    A_SVCDATE      D      8     0   DATE IN SERVICE (MUST BE >= S_PURDATE)  
  19    A_SOLDDATE     D      8     0   DATE SOLD (MUST BE BLANK OR >= S_SVCDATE
  20    A_SOLDAMT      N     15     2   SALE PRICE                              
  21    A_COST         N     15     2   COST OF ASSET                           
  22    A_SALVAGE      N     15     2   SALVAGE VALUE (MUST BE BETW(0,S_COST))  
  23    A_REPLACE      N     15     2   REPLACEMENT COST (FOR INSURANCE)        
  24    A_VENDNO       C      9     0   AP VENDOR NUMBER                        
  25    A_PONUM        C      8     0   PURCHASE ORDER #                        
  26    A_RETIRE       D      8     0   ASSET RETIREMENT DATE                   
  27    A_WARRANTY     D      8     0   WARRANTY EXPIRATION DATE                
  28    A_SERVICE      D      8     0   DATE SERVICE CONTRACT IS OVER           
  29    A_NOTES        M      0     0   NOTES ON THIS ASSET                     
  30    A_MISC0        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  31    A_MISC1        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  32    A_MISC2        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  33    A_MISC3        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  34    A_MISC4        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  35    A_MISC5        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  36    A_MISC6        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  37    A_MISC7        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  38    A_MISC8        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  39    A_MISC9        C     20     0   MISC ACCORDING TO INSTALLATION SETTING  
  40    A_NMISC0       N     15     2   NUMBERIC MISC FIELD                     
  41    A_NMISC1       N     15     2   NUMBERIC MISC FIELD                     
  42    A_NMISC2       N     15     2   NUMBERIC MISC FIELD                     
  43    A_NMISC3       N     15     2   NUMBERIC MISC FIELD                     
  44    A_NMISC4       N     15     2   NUMBERIC MISC FIELD                     
  45    A_NMISC5       N     15     2   NUMBERIC MISC FIELD                     
  46    A_NMISC6       N     15     2   NUMBERIC MISC FIELD                     
  47    A_NMISC7       N     15     2   NUMBERIC MISC FIELD                     
  48    A_NMISC8       N     15     2   NUMBERIC MISC FIELD                     
  49    A_NMISC9       N     15     2   NUMBERIC MISC FIELD                     
  50    A_DELFLAG      C      1     0   "*" IF REUSEABLE                        
  51    A_NETSTAMP     N      2     0   NETWORK STAMP                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  51 FIELDS =  830

                                Related Indexes                                

ASSETS  : A_DELFLAG+A_TAG                                                       
ASNAME  : A_DELFLAG+A_DESC                                                      .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASSYST                                 
                      File Description: Assets System File                      

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    S_PERIOD       N      2     0   CURRENT PERIOD IN CR                    
   2    S_GLLINK       C      1     0   ARE G/L FILES GOING TO BE USED?         
   3    S_GLXFER       C      1     0   "Y"ES IF DATE DETAIL TO THE G/L         
   4    S_GLNXTBAT     N      3     0   NEXT BATCH NUMBER FOR TRANSFER TO G/L   
   5    S_GLCOMP       C      2     0   GL COMPANY NUMBER                       
   6    S_DUETO        C     25     0   DUE TO OTHER FUNDS                      
   7    S_DUEFROM      C     25     0   DUE FROM OTHER FUNDS                    
   8    S_YEAR         N      4     0   CURRENT YEAR IN CR                      
   9    S_F05          C     30     0   FUNCTION KEY F5                         
  10    S_F06          C     30     0   FUNCTION KEY F6                         
  11    S_F07          C     30     0   FUNCTION KEY F7                         
  12    S_F08          C     30     0   FUNCTION KEY F8                         
  13    S_F09          C     30     0   FUNCTION KEY F9                         
  14    S_F10          C     30     0   FUNCTION KEY F10                        
  15    S_F11          C     30     0   FUNCTION KEY F11                        
  16    S_F12          C     30     0   FUNCTION KEY F12                        
  17    S_MISC0        C     10     0   MISC DESCRIPTION                        
  18    S_MISC1        C     10     0   MISC DESCRIPTION                        
  19    S_MISC2        C     10     0   MISC DESCRIPTION                        
  20    S_MISC3        C     10     0   MISC DESCRIPTION                        
  21    S_MISC4        C     10     0   MISC DESCRIPTION                        
  22    S_MISC5        C     10     0   MISC DESCRIPTION                        
  23    S_MISC6        C     10     0   MISC DESCRIPTION                        
  24    S_MISC7        C     10     0   MISC DESCRIPTION                        
  25    S_MISC8        C     10     0   MISC DESCRIPTION                        
  26    S_MISC9        C     10     0   MISC DESCRIPTION                        
  27    S_NMISC0       C     10     0   MISC DESCRIPTION                        
  28    S_NMISC1       C     10     0   MISC DESCRIPTION                        
  29    S_NMISC2       C     10     0   MISC DESCRIPTION                        
  30    S_NMISC3       C     10     0   MISC DESCRIPTION                        
  31    S_NMISC4       C     10     0   MISC DESCRIPTION                        
  32    S_NMISC5       C     10     0   MISC DESCRIPTION                        
  33    S_NMISC6       C     10     0   MISC DESCRIPTION                        
  34    S_NMISC7       C     10     0   MISC DESCRIPTION                        
  35    S_NMISC8       C     10     0   MISC DESCRIPTION                        
  36    S_NMISC9       C     10     0   MISC DESCRIPTION                        
  37    S_ALLOW0       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  38    S_ALLOW1       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  39    S_ALLOW2       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  40    S_ALLOW3       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  41    S_ALLOW4       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  42    S_ALLOW5       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  43    S_ALLOW6       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  44    S_ALLOW7       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  45    S_ALLOW8       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  46    S_ALLOW9       C      1     0   ALLOW REPORT/PROCEDURE RANGES (Y/N)     
  47    S_NETSTAMP     N      2     0   NETWORK STAMP                           
  48    S_JANUARY      N      2     0   JAN IS WHAT PERIOD FOR UPPER LEFT CORNER
  49    S_VERSION      C      4     0   NEMRC EXECUTABLE THAT MATCHES THIS DATA 
  50    S_OLDVER       C      4     0   PREVIOUS INSTALLED VERSION OF THE MODULE
  51    S_UPVER        D      8     0   DATE THE NEW VERSION WAS INSTALLED      
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  51 FIELDS =  533

        :                                                                       .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASTRAX                                 
                       File Description: Transaction File                       

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    T_TAG          C     10     0   ASSET NUMBER                            
   2    T_TYPE         C      1     0   TRANSACTION TYPE (SEE BELOW)            
   3    T_NAME         C     15     0   BOOK THAT WAS DEPRECIATED FOR THIS ASSET
   4    T_DATE         D      8     0   TRANSACTION DATE                        
   5    T_OLDDATE      D      8     0   LAST DEPRECIATION POSTING DATE          
   6    T_NEWDATE      D      8     0   NEW DEPRECIATION POSTING DATE           
   7    T_COMPLETE     C      1     0   'Y'ES WHEN COMPLETE                     
   8    T_AMOUNT       N     15     2   TRANSACTION AMOUNT                      
   9    T_BATCH        C      3     0   G/L BATCH TRANSFER #                    
  10    T_COMMENT      C     30     0   COMMENTS                                
  11    T_DELFLAG      C      1     0   "*" IF RE-USEABLE                       
  12    T_NETSTAMP     N      2     0   NETWORK STAMP                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  12 FIELDS =  102

                                Related Indexes                                

ASDATE  : T_DELFLAG+DTOS(T_DATE)                                                
ASPOST  : T_DELFLAG+T_BATCH                                                     
ASTRAX  : T_DELFLAG+T_TAG+T_NAME+DTOS(T_DATE)                                   .
01/07/02                     NEMRC Customer Support                       Page 1
04:21 pm                       Filename: ASX2GL                                 
                  File Description: Transfer to General Ledger                  

  No   Field Name   Type   Len   Dec    Description of field                
--------------------------------------------------------------------------------
   1    TRSACT         C     25     0   ACCOUNT NUMBER                          
   2    TRSDES         C     25     0   TRANSACTION DESCRIPTION                 
   3    TRSREF         C     12     0   REFERENCE NUMBER                        
   4    TRSDATE        D      8     0   TRANSACTION DATE                        
   5    TRSAMT         N     15     2   AMOUNT                                  
   6    TRSID          C      1     0   0=SPECIAL,1=POSTING,2=REFERENCE         
   7    TRSMODU        C      2     0   MODULE THAT GENERATED THIS POSTING      
   8    TRSCOMPID      C      2     0   COMPANY ID THAT GENERATED THIS POSTING  
   9    TRSTYPE        C      1     0   TRANSACTION TYPE (SEE BELOW)            
  10    TRSPD          C      2     0   G/L PERIOD OF POSTING                   
  11    TRSDELFLAG     C      1     0                                           
--------------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL  11 FIELDS =   94

        :                                                                       
							

© NEMRC 2010-2023 | Privacy Policy