Business Function Specification
Source NameB0100023DesignerFiona Martin
Data Structure D0100023ProgrammerFiona Martin
Function NameABCustomerAmtsDatesSystem Code01
Function CategoryCUR
Function UseGET
Revisions Log
DateProgrammerSAR NumberDescription
04/15/95F. MartinCreated
08/07/95 F. Martin Created
10/26/95 J. Cahill added Error Message ID Field
08/01/96 G. Brown1236808******
1.Functional Description
1.1Purpose
This function will retrieve key Accounts Receivable dates and amounts from the Customer Master table, and will return them to the calling
application via data structure parameters. The function will determine whether a user is running the new A/R system (03B), or the old system (03) and retrieve
the customer's information from the correct table (i.e. either F03B01 or F0301).
The caller can specify what currency the amounts should be returned in. This function will perform any conversion required to return amounts
in the requested currency. If no currency is specified, the amounts will be returned in the customer's default currency. Please note, all amounts returned to
the calling application will always be denominated in the same currency, regardless of whether the caller nominates a currency or not.
1.2Setup Notes and Prerequisites
For this function to perform currency conversion, the Currency Conversion flag in the General Constants must be set to either "Y" or "Z". If this flag is
set to "N", no currency conversion can occur. Also, if no conversion rate exists between the customer's default currency in F0301 and the caller's specified
currency, no conversion can occur. In both cases all amounts returned will be set to zero.
1.3Special Logic
2.Technical Specifications
2.1Parameters:
Data Item Data Structure Description I/ORequired Notes
AN8 mnAddressNumber IRequired
CRCA szCurrencyCode IN/R If not entered, the customer's currency from
F0301 will be used.
TRDT jdERDate IN/R Required if a specific currency code is passed.
This parameter is used to retrieve the exchange
rate effective at this given date for conversion
calculations.
DLIJ jdDateLastInvoice O
DFIJ jdDateFirstInvoice O
DHBJ jdDateHighBalance O
DLP jdDateLastPaid O
ACL mnAmountCreditLimit O
AD mnAmountDue O
AFCP mnAmtFinanceChargesPY O
AFCY mnAmtFinanceChargesYTD O
SPYE mnAmtInvoicedPY O
ASTY mnAmtInvoicedYTD O
AHB mnAmountHighBalance O
ALP mnAmountLastPaid O
ABAM mnAmountAddressBook O
ABA1 mnAmount1 O
APRC mnAmountOpenOrder O
MINO mnMinimumOrderValue O
MAXO mnMaximumOrderValue O
URAT mnUserReservedAmount O
CO szCompany IRequired Used as part of the unique key to retrieve a
customer's information from F03B01.
2.2Related Tables
Table Table Description
F0301Customer Master
F03B01Customer Master
2.3Related Business Functions
Source NameFunction Name
B0000027Currency Conversion
B0000033Get Exchange Rate
2.4Processing
1. If the customer master row for the given Address Number cannot be found then error message 0037 will be returned.
2. If the database or the table cannot be found then error message 3143 will be returned.
3. If an error occurs loading any of the dates or amounts to the output parameters, error message 4376 will be returned.
4. If an error occurs converting amounts to the output parameters, error message 0488 will be returned.
^
D0100023 - A/B Customer Header Amounts and Dates F0301
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | 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
| ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
jdERDate | TRDT | JDEDATE | NONE | NONE |
The date an order line is loaded onto a vehicle for delivery. | ||||
jdDateLastInvoice | DLIJ | JDEDATE | NONE | NONE |
The G/L date of the last invoice generated for the customer. | ||||
jdDateFirstInvoice | DFIJ | JDEDATE | NONE | NONE |
The G/L date of the first invoice generated. | ||||
jdDateHighBalance | 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
| ||||
jdDateLastPaid | DLP | JDEDATE | NONE | NONE |
The date of the last premium payment. | ||||
mnAmountCreditLimit | ACL | MATH_NUMERIC | NONE | NONE |
The total amount that you allow the customer to spend on purchases before the system sends a workflow message. This value is used
| ||||
mnAmountDue | AD | MATH_NUMERIC | NONE | NONE |
The balance or amount due on an open invoice or voucher. In the Address Book Master file (F0101), this is a memo amount field used to
| ||||
mnAmtFinanceChargesPY | AFCP | MATH_NUMERIC | NONE | NONE |
This is the prior year amount of finance charges for a customer.
This field is updated by the Accounts Receivable Annual Close program
| ||||
mnAmtFinanceChargesYTD | AFCY | MATH_NUMERIC | NONE | NONE |
The year-to-date finance charges. This field is updated by the Finance Charge Journal program (P03435). | ||||
mnAmtInvoicedPY | 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
| ||||
mnAmtInvoicedYTD | 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
| ||||
mnAmountHighBalance | 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
| ||||
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
| ||||
mnAmountAddressBook | ABAM | MATH_NUMERIC | NONE | NONE |
A field that stores an amount in the Address Book system. This field has no predefined use. You can use this field to record a bank service
| ||||
mnAmount1 | ABA1 | MATH_NUMERIC | NONE | NONE |
Future use. | ||||
mnAmountOpenOrder | APRC | MATH_NUMERIC | NONE | NONE |
The total amount of open orders for a supplier or customer. The system uses the list price from the Item Location (F41021) table adjusted by
| ||||
mnMinimumOrderValue | MINO | MATH_NUMERIC | NONE | NONE |
Value below which an order is placed on hold. If you try to enter an order whose total is less than the minimum order value, the system
| ||||
mnMaximumOrderValue | MAXO | MATH_NUMERIC | NONE | NONE |
Value above which an order is placed on hold. If you try to enter an order whose total is more than the maximum order value, the system
| ||||
mnUserReservedAmount | URAT | MATH_NUMERIC | NONE | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
jdDateUserReserved | URDT | JDEDATE | NONE | NONE |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szErrorMessageID | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks 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
| ||||
jdGLDate | DGL | JDEDATE | OPT | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
|
B0000027 CurrencyConvForAndDom | ||||
B0000033 Get Exchange Rate | ||||
N0100042 Customer Master -MBF |
None |