Data Log Report

The depreciation procedure presents a log with hash totals that helps you troubleshoot problems. The list below is a small section of the log.

Data Log Info:

 

fp_doc_header_t rowcount

3264590

cm_cptlast_t rowcount

246501

cm_ast_payment_t rowcount

546691

gl_pending_entry_t rowcount

22194

sum_ast_depr1_base_amt

3,496,359,697.80

sum_ast_acum_depr1_amt

1,859,780,744.22

sum_ast_prvyrdepr1_amt

94,985,363.99

sum_ast_prd1_depr1_amt

7,683,600.25

sum_ast_prd2_depr1_amt

7,634,410.60

sum_ast_prd3_depr1_amt

7,807,746.65

sum_ast_prd4_depr1_amt

7,699,533.67

sum_ast_prd5_depr1_amt

7,744,040.65

sum_ast_prd6_depr1_amt

9,067,154.04

sum_ast_prd7_depr1_amt

8,111,233.14

sum_ast_prd8_depr1_amt

10,398,474.93

sum_ast_prd9_depr1_amt

9,757,871.94

sum_ast_prd10_depr1_amt

8,048,359.24

sum_ast_prd11_depr1_amt

8,175,687.65

sum_ast_prd12_depr1_amt

9,179,094.25

sum_ast_ytd_depr1_amt:

101,307,207.01

sum_ast_depr1_base_amt:

34,718,287.46

sum_ast_acum_depr1_amt:

12,855,310.09

Assets eligible for Depreciation

16,751

Payments eligible for Depreciation

49,633

Assets with Pending AR/AT docs

321

Pymts eligible for depr after AR/AT

49,426

Pymts not eligible,but init'd

n/a

Rows in fp_dep_objs_mt

1,158

Rows in fp_plnt_acct_mt_build_lookup_table

41,974

(After) eligible payments build_pmt_mt

49,129

Sum of Trn_ldgr_entr_amt in fp_ple_mt befor update

8,103,254.54

Sum of Trn_ldgr_amt in fp_ple_mt after d/c adj

10,754,145.36

Document #

UX8134204

Check Sum

 

fp_doc_header_t rowcount

3264591

cm_cptlast_t rowcount

246501

cm_ast_payment_t rowcount

546691

gl_pending_entry_t rowcount

49935

sum_ast_depr1_base_amt:

3,496,359,697.80

sum_ast_acum_depr1_amt:

1,867,883,998.76

sum_ast_prvyrdepr1_amt:

101,307,207.01

sum_ast_prd1_depr1_amt:

8,103,254.54

sum_ast_prd2_depr1_amt:

 

sum_ast_prd3_depr1_amt:

 

sum_ast_prd4_depr1_amt:

 

sum_ast_prd5_depr1_amt:

 

sum_ast_prd6_depr1_amt:

 

sum_ast_prd7_depr1_amt:

 

sum_ast_prd8_depr1_amt:

 

sum_ast_prd9_depr1_amt:

 

sum_ast_prd10_depr1_amt:

 

sum_ast_prd11_depr1_amt:

 

sum_ast_prd12_depr1_amt:

 

sum_ast_ytd_depr1_amt:

8,103,254.54

sum_ast_depre1_base_amt:

34,718,287.46

sum_ast_acum_depr1_amt:

12,855,310.09

gl_pending_511*_C

1,325,445.41

gl_pending_511*_D

9,428,699.95

gl_pending_not511*_C

9,428,699.95

gl_pending_not511*_D

1,325,445.41

balance_check C= (so far so good)

9,428,699.95

balance_check D= (so far so good)

9,428,699.95

Current Month

8,103,254.54

Credit Amount (negative Depr)

1,325,445.41

Debit Amount (positive Depr)

9,428,699.95

Check Current Month (Debit-Credit)

8,103,254.54

Difference Current Months

0.00

More:

Accessing CAM Functions