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
:
