B03B0085
F03B16S - Update Stat Summary Parent
Functional Description
Purpose
This function summarize the records on the F03B16S for a Parent/Child relationship.  When a Customer 
Number and Company Number are passed into the function, the function will read the F0150 to determine 
if the Customer is part of a Parent/Child relationship.  If the Customer has a parent, the function 
will add the current Customer's, a child, amounts the parent's totals.  These amounts are rolled up to 
the top of the Parent/Child tree.  Additionally, if currency processing is "ON", the amounts are 
converted into the parent's currency before they are accumulate.
Setup Notes and Preqeruisites
Special Logic
Technical Specifications
Data Structure Parameters
Data ItemData Structure DescriptionI/ORequiredNotes
AN8mnCustomerNumberI
CO     szCompanyI
AHB    mnHighBalanceAmountI
DHBJ    jdDateHighBalanceJulianI
ACLH    mnHighCreditLimitAmountI
AG     mnInvoicedAmountI
NINV   mnNumberInvoicesI
SAG    mnSalesAmountI
CREE   mnCreditsEnteredI
ADSC   mnDiscountsAvailableI
DFEE    mnDelinquencyFeesAmountI
ECBA   mnChargebackAmountsI
NCB    mnNumberChargebacksI
DFIJ    jdDateFirstInvoiceJulianI
DLIJ    jdDateLastInvoiceJulianI
DT1J    jdDateLastStatementJulianI
ASTY    mnAmountInvoicedThisYearI
SPYE    mnAmountInvoicedPriorYearI
PAAP   mnPaymntAmountI
UDSC   mnDiscountsUnearnedI
EDSC   mnDiscountsEarnedI
AIPL    mnInvoiceAmountPaidLateI
NIPL    mnNumberInvoicesPaidLateI
DDCA   mnAmountDeductionsI
DDCN   mnNumberDeductionsI
MWO    mnAmountMinorWriteOffI
BDBT   mnAmountBadDebtI
ANSF   mnNSFAmountI
NNSF   mnNumberNSFsI
DLP    jdDateLastPaidI
ALP    mnAmountLastPaidI
CRCD   szCurrencyCodeFromI
CHGA   mnAmountChangedI
AVDL   mnAverageDaysLateI
NBR1   mnNoSentReminders1I
DLQJ    jdDateLastDunningLetterJulI
NINP    mnNumberOfInvoicesPaidI
NXPD   jdThruDateI
NUMDAY mnNumberDaysLateI
AVDL   mnChildPrevAVDLI
PAAP   mnChildPrevPaymntAmtI
PAAP   mnChildCurrPaymntAmtI
AVDL   mnChildCurrAVDLI
Related Tables
F03B16SA/R Statistical Summary
F0150Address Organization Structure Master File - OSTP, PA8, AN8
Related Business Functions
N0100042Customer Master -MBF
B1100006Decimal Trigger Get By Currency
B0000027CurrencyConvForAndDom
B0000033Get Exchange Rate
B9800100Get Audit Information
JDEAPPApplications Global Definitions - include file only
Processing
^
D03B0085 - Update Stat Summary Parent
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both | 
|---|---|---|---|---|
| mnCustomerNumber | AN8 | MATH_NUMERIC | NONE | NONE | 
| A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or 
 | ||||
| szCompany | CO | char | NONE | NONE | 
| A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company 
 | ||||
| mnHighBalanceAmount | AHB | MATH_NUMERIC | NONE | NONE | 
| The invoice record with the highest gross amount from the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table 
 | ||||
| jdDateHighBalanceJulian | DHBJ | JDEDATE | NONE | NONE | 
| The invoice date of the record that has the highest gross amount from either the A/R Statistical History (F03B16) or A/R Statistical Summary 
 | ||||
| mnHighCreditLimitAmount | ACLH | MATH_NUMERIC | NONE | NONE | 
| The highest credit limit that has been extended to the customer. | ||||
| mnInvoicedAmount | AG | MATH_NUMERIC | NONE | NONE | 
| A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on 
 | ||||
| mnNumberInvoices | NINV | MATH_NUMERIC | NONE | NONE | 
| Depending on the form, the number of posted invoices entered for the customer at the time the Statistics History Update program (R03B16) 
 | ||||
| mnSalesAmount | SAG | MATH_NUMERIC | NONE | NONE | 
| The total amount of sales orders from the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table (F03B16), depending 
 | ||||
| mnCreditsEntered | CREE | MATH_NUMERIC | NONE | NONE | 
| A value that indicates the total amount of invoices with a gross amount less than zero, excluding invoices with document types R1, R5, and 
 | ||||
| mnDiscountsAvailable | ADSC | MATH_NUMERIC | NONE | NONE | 
| The amount of the invoice or voucher pay item that is eligible to be subtracted from the gross amount when the transaction is paid. The 
 | ||||
| mnDelinquencyFeesAmount | DFEE | MATH_NUMERIC | NONE | NONE | 
| The total amount of the delinquency fee invoice records (RF). The system displays this information from either the A/R Statistical Summary 
 | ||||
| mnChargebackAmounts | ECBA | MATH_NUMERIC | NONE | NONE | 
| An unpaid invoice amount for which you want to create a new invoice record so that you can charge the customer. | ||||
| mnNumberChargebacks | NCB | MATH_NUMERIC | NONE | NONE | 
| The total number of chargeback invoices (document type RB) from either the A/R Statistical Summary table (F03B16S) or the A/R Statistical 
 | ||||
| jdDateFirstInvoiceJulian | DFIJ | JDEDATE | NONE | NONE | 
| The G/L date of the first invoice generated. | ||||
| jdDateLastInvoiceJulian | DLIJ | JDEDATE | NONE | NONE | 
| The G/L date of the last invoice generated for the customer. | ||||
| jdDateLastStatementJulian | DT1J | JDEDATE | NONE | NONE | 
| The date that the last statement was processed. The system displays this information from the A/R Statistical Summary table (F03B16S). | ||||
| mnAmountInvoicedThisYear | ASTY | MATH_NUMERIC | NONE | NONE | 
| The amount invoiced for the year. The system uses the gross amount of the invoice record (F03B11) regardless of whether taxes are 
 | ||||
| mnAmountInvoicedPriorYear | SPYE | MATH_NUMERIC | NONE | NONE | 
| The gross amount invoiced for the previous year. The system updates this field only when you run the Statistics Annual Close program 
 | ||||
| mnPaymntAmount | PAAP | MATH_NUMERIC | NONE | NONE | 
| In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount 
 | ||||
| mnDiscountsUnearned | UDSC | MATH_NUMERIC | NONE | NONE | 
| The total amount of the discounts taken after the discount due date. The system displays this amount from either the A/R Statistical 
 | ||||
| mnDiscountsEarned | EDSC | MATH_NUMERIC | NONE | NONE | 
| The amount of the discount that is taken on or before the discount due date. | ||||
| mnInvoiceAmountPaidLate | AIPL | MATH_NUMERIC | NONE | NONE | 
| The total amount of invoices that have been paid late from the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table 
 | ||||
| mnNumberInvoicesPaidLate | NIPL | MATH_NUMERIC | NONE | NONE | 
| The total number of invoices that were paid after the due date. The system displays this number from either the A/R Statistical Summary 
 | ||||
| mnAmountDeductions | DDCA | MATH_NUMERIC | NONE | NONE | 
| The total amount of the deduction records from the Receipts Detail table (F03B14) for the specified period. | ||||
| mnNumberDeductions | DDCN | MATH_NUMERIC | NONE | NONE | 
| The total number of deductions that have been applied to an account. | ||||
| mnAmountMinorWriteOff | MWO | MATH_NUMERIC | NONE | NONE | 
| The total write-off amount accumulated from the Receipts Detail table (F03B14) for all reason codes in UDC 03B/RC that have 1 in the 
 | ||||
| mnAmountBadDebt | BDBT | MATH_NUMERIC | NONE | NONE | 
| The total write-off amount accumulated from the Receipts Detail table (F03B14) for all reason codes in UDC 03B/RC that have no value in 
 | ||||
| mnNSFAmount | ANSF | MATH_NUMERIC | NONE | NONE | 
| The total amount of the receipts that were returned for insufficient funds (document type RV). The system displays this information from 
 | ||||
| mnNumberNSFs | NNSF | MATH_NUMERIC | NONE | NONE | 
| The total number of receipts returned for non-sufficient funds (document type RV) from the A/R Statistical Summary table (F03B16S) or the 
 | ||||
| jdDateLastPaid | DLP | JDEDATE | NONE | NONE | 
| The date of the last premium payment. | ||||
| mnAmountLastPaid | ALP | MATH_NUMERIC | NONE | NONE | 
| The amount of the last payment applied to invoices based on the G/L date of the Receipt Detail record (F03B14). The system displays this 
 | ||||
| szCurrencyCodeFrom | CRCD | char | NONE | NONE | 
| A code that identifies the currency of a transaction. | ||||
| mnAmountChanged | CHGA | MATH_NUMERIC | NONE | NONE | 
| The net change amount. | ||||
| mnAverageDaysLate | AVDL | MATH_NUMERIC | NONE | NONE | 
| The average length of time, in days, that it took the customer to pay an invoice. | ||||
| mnNoSentReminders1 | NBR1 | MATH_NUMERIC | NONE | NONE | 
| The total number of delinquency notices that were sent to a customer. | ||||
| jdDateLastDunningLetterJul | DLQJ | JDEDATE | NONE | NONE | 
| The date of the last deliquency notice that was sent to the customer. The system displays this information from either the A/R Statistical 
 | ||||
| mnNumberOfInvoicesPaid | NINP | MATH_NUMERIC | NONE | NONE | 
| The number of invoices that were paid in the period specified at the time the Statistics History Update program (R03B16) was run. | ||||
| jdThruDate | NXPD | JDEDATE | NONE | NONE | 
| The date that was entered for the Thru Date processing option on the Summary Record tab when the Statistics History Update program 
 | ||||
| mnNumberDaysLate | NUMDAY | MATH_NUMERIC | NONE | NONE | 
| The number of days back from the calculate balance date that will be used to calculate the Statistical History Balance.  For example, if the 
 | ||||
| mnChildPrevAVDL | AVDL | MATH_NUMERIC | NONE | NONE | 
| The average length of time, in days, that it took the customer to pay an invoice. | ||||
| mnChildPrevPaymntAmt | PAAP | MATH_NUMERIC | NONE | NONE | 
| In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount 
 | ||||
| mnChildCurrPaymntAmt | PAAP | MATH_NUMERIC | NONE | NONE | 
| In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount 
 | ||||
| mnChildCurrAVDL | AVDL | MATH_NUMERIC | NONE | NONE | 
| The average length of time, in days, that it took the customer to pay an invoice. | ||||
| B0000027 CurrencyConvForAndDom | ||||
| B0000033 Get Exchange Rate | ||||
| B1100006 Decimal Trigger Get By Currency | ||||
| B9800100 Get Audit Information | ||||
| N0100042 Customer Master -MBF | 
| F0150 Address Organization Structure Master | ||||
| F03B16S A/R Statistical Summary |