N03B0185
F03012 Get Customer Master
Functional Description
Purpose
The purpose of the F03012 Get Customer Master is to retrieve information from Customer Master table
(F03012). This function is written to replace the Customer Master - MBF (N0100042) for the inquire
mode because of the performance concern of the MBF. The function is design for use only in Financial -
A/R programs.
Setup Notes and Prerequisites
The Customer Master _ MBF is not replaceable with the business function if the MBF is used to
retrieve Address Number 5th (AN85), or PA8 (Parent Number). The reason is AN85 and PA8 are not in Customer
Master table. Payor Address Number (PYR) is not in Customer Master table either, but Alternate Payor
(ARPY) can be retrieved in stead.
Special Logic
If the Line Of Business is off or the pair of Customer Number and Company does not exist in the
Customer Master table, the record of the Customer Number and Company 00000 will be fetched.
Insured credit limit is retrieved based upon Customer Number, Policy Date, and Credit Limit Option.
If policy date is blank, the date will be set to today's date. If credit limit option is blank,
insured credit limit will be passed out in the Amount Credit Limit (Regular Credit Limit). Therefore, the
regular credit limit will be overridden. If the credit limit option is equal to 1, insured credit
limit will be passed out in Insured Credit Limit and the regular credit limit will be passed out in
Amount Credit limit.
Technical Specifications
Parameters
Item DescriptionI/OReq?Notes
AN8 Customer NumberIYes
CO CompanyI Yes
PLY mnPolicyNumberAONo
AFC cApplyFinChargesYNONo
HDAR cArHoldInvoicesONo
ACL mnAmountCreditLimitONo
TSTA szTempCreditMessageONo
CMGR szCreditManagerONo
CLMG szCollectionManagerONo
CRCD szCurrencyCodeFromONo
CRCA szCurrencyCodeAmountsONo
DLC jdDateLastCreditReviewONo
RVDJ jdDateRecallforReviewONo
COLL cCollectionReportONo
DNLT cDelinquencyLetterONo
DT1J DateLastStatementDateONo
STTO cSendStatementToCPONo
STMT cPrintStatementYNONo
DFIJ jdDateFirstInvoiceJulianONo
RYIN cPaymentInstrumentAONo
SITO cSendInvoiceToCPONo
DAOJ jdDateAccountOpenedJulianONo
AC01 szReportCodeAddBook001ONo
AC02 szReportCodeAddBook002ONo
AC03 szReportCodeAddBook003ONo
AC04 szReportCodeAddBook004ONo
AC05 szReportCodeAddBook005ONo
AC06 szReportCodeAddBook006ONo
AC07 szReportCodeAddBook007ONo
AC08 szReportCodeAddBook008ONo
AC09 szReportCodeAddBook009ONo
AC10 szReportCodeAddBook010ONo
AC11 szReportCodeAddBook011ONo
TRAR szPaymentTermsARONo
ARC szARClassONo
ARPY mnAltPayorONo
TXA1 szTaxArea1ONo
EXR1 szTaxExplanationCode1ONo
DLIJ jdDateLastInvoiceJulianONo
DLP jdDateLastPaidONo
DLQJ jdDateLastDunningLetterJulONo
ALP mnAmountLastPaidONo
ATCS cAutoCashONo
ARL szReceiptsExecutionListONo
MCUR szCostCenterArDefaultONo
OBAR szObjectAcctsReceivableONo
AIDR szSubsidiaryAcctsReceivONo
DCAR mnDocArDefaultJeONo
DTAR szDocTyArDefaultJeONo
KCOR szCompanyKeyARModelONo
EV01 cErrorFlagONo
AMCR mnInsuredCreditLimitONo
DGJ jdPolicyDateINoBlank is today's date
EV01 cCreditLimitOption INo
Related Tables
F03012Customer Master Information
F03B29Credit Insurance Table
Related Business Functions
Processing
- Call F0009 Get SEPF Flag
- If SEPF flag = 2 (LOB is on)
- If not fetch successfully
- If Policy Date is blank, assign today's date to Policy Date
- Use Customer Number and Policy Date to fetch Insured Amount and insure amount currency code
(Policy Date >= Effective Date
Policy Date <= Expiration Date
Customer # = Customer #)
- If fetch successfully
- If insure amount currency code is not equal to customer currency code
- Call F0015 Get Exchange Rate (B0000033) to get exchange rate
- Call Currency Conversion, Calculate (B0000027) to convert to customer currency code
- End if
- If Credit Limit Option is blank and policy type is 2, assign insured amount to Amount Credit
Limit
- If Credit Limit Option is 1, assign insured amount to Insured Amount
- End if
D03B0185 - F03012 Get Customer Master
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | AN8 | MATH_NUMERIC | REQ | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szCompany | CO | char | REQ | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
cApplyFinChargesYN | AFC | char | OPT | OUTPUT |
An option to specify whether to process delinquency fees for the customer.
On
Process delinquency fees
Off
Do not process delinquency
| ||||
cArHoldInvoices | HDAR | char | OPT | OUTPUT |
An option that allows you to prevent anyone from entering invoices manually. Valid values are:
On
Hold invoices. The system issues an
| ||||
cCollectionReport | COLL | char | OPT | OUTPUT |
An option that specifies whether the customer's overdue invoices are eligible to appear on the collection report that you send to an external
| ||||
cDelinquencyLetter | DNLT | char | OPT | OUTPUT |
An option that specifies whether to print delinquency notices for the customer or company based on the notification instructions that are set
| ||||
cPrintStatementYN | STMT | char | OPT | OUTPUT |
An option that specifies whether to print statements for the customer or company. Valid settings are:
On
Print statements.
Off
Do not print
| ||||
cSendStatementToCP | STTO | char | OPT | OUTPUT |
A code that identifies the billing address to print on statements. Valid values are:
C
Customer (AN8)
P
Parent (PA8)
R
Payor (PYR)
1
First
| ||||
jdDateLastCreditReview | DLC | JDEDATE | OPT | OUTPUT |
The date on which the credit manager last examined this customer's payment record and assigned a credit status to the account. | ||||
jdDateLastStatementDate | DT1J | JDEDATE | OPT | OUTPUT |
The date that the last statement was processed. The system displays this information from the A/R Statistical Summary table (F03B16S). | ||||
jdDateRecallforReview | RVDJ | JDEDATE | OPT | OUTPUT |
The review date for the customer's credit information. | ||||
mnAmountCreditLimit | ACL | MATH_NUMERIC | OPT | OUTPUT |
The total amount that you allow the customer to spend on purchases before the system sends a workflow message. This value is used
| ||||
szCollectionManager | CLMG | char | OPT | OUTPUT |
The name of the collection manager responsible for managing this customer's account. You must set up the collection manager in the
| ||||
szCreditManager | CMGR | char | OPT | OUTPUT |
The name of the credit manager responsible for approving changes to the credit limit. You must set up the credit manager in the address
| ||||
szCurrencyCodeAmounts | CRCA | char | OPT | OUTPUT |
The currency in which amounts are stored in the address book. For example, the credit limit, invoiced this year, invoiced prior year, and so
| ||||
szCurrencyCodeFrom | CRCD | char | OPT | OUTPUT |
A code that identifies the currency of a transaction. | ||||
szTempCreditMessage | TSTA | char | OPT | OUTPUT |
A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The
| ||||
cAutoCash | ATCS | char | OPT | OUTPUT |
An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
| ||||
cPaymentInstrumentA | RYIN | char | OPT | OUTPUT |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
cSendInvoiceToCP | SITO | char | OPT | OUTPUT |
A code that identifies the billing name and address to print on the invoice. Valid codes are:
C
Customer (AN8)
N
Do not print. The Real
| ||||
jdDateAccountOpenedJulian | DAOJ | JDEDATE | OPT | OUTPUT |
The date that the customer record was created. | ||||
jdDateFirstInvoiceJulian | DFIJ | JDEDATE | OPT | OUTPUT |
The G/L date of the first invoice generated. | ||||
jdDateLastDunningLetterJul | DLQJ | JDEDATE | OPT | OUTPUT |
The date of the last deliquency notice that was sent to the customer. The system displays this information from either the A/R Statistical
| ||||
jdDateLastPaid | DLP | JDEDATE | OPT | OUTPUT |
The date of the last premium payment. | ||||
mnAltPayor | ARPY | MATH_NUMERIC | OPT | OUTPUT |
A person or company other than the customer that the system assigns to the Payor field (PYR) on Customer Ledger records (F03B11) that
| ||||
mnAmountLastPaid | ALP | MATH_NUMERIC | OPT | OUTPUT |
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
| ||||
szARClass | ARC | char | OPT | OUTPUT |
A code that determines the A/R trade account that the system will use as the offset when you post invoices. The system concatenates the
| ||||
szPaymentTermsAR | TRAR | char | OPT | OUTPUT |
A code that indicates the default payment terms for a customer. Payment terms determine the due date, discount amount, and discount due
| ||||
szReportCodeAddBook001 | AC01 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to group address book
| ||||
szReportCodeAddBook002 | AC02 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook003 | AC03 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook004 | AC04 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook005 | AC05 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook006 | AC06 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook007 | AC07 | char | OPT | OUTPUT |
One of 30 reporting codes that you can assign to an address in the Address Book system. Category Code 07 is used in the 1099 process to
| ||||
szReportCodeAddBook008 | AC08 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook009 | AC09 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook010 | AC10 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook011 | AC11 | char | OPT | OUTPUT |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
jdDateLastInvoiceJulian | DLIJ | JDEDATE | OPT | OUTPUT |
The G/L date of the last invoice generated for the customer. | ||||
szTaxExplanationCode1 | EXR1 | char | OPT | OUTPUT |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
szTaxArea1 | TXA1 | char | OPT | OUTPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
mnPolicyNumberA | PLY | MATH_NUMERIC | OPT | OUTPUT |
A number that the system assigns to each policy record to identify it. | ||||
szAutoReceiptsExecutionList | ARL | char | OPT | OUTPUT |
The name assigned to a list of algorithms that define the order in which the programs should be run. | ||||
szCostCenterArDefault | MCUR | char | OPT | OUTPUT |
The business unit for the journal entry account number for a customer (A/P).
The system uses this business unit number, the default object
| ||||
szObjectAcctsReceivable | OBAR | char | OPT | OUTPUT |
Object is a synonym for the General Ledger Account Number.
The data entry programs will use this object, plus the default subsidiary
| ||||
szSubsidiaryAcctsReceiv | AIDR | char | OPT | OUTPUT |
An accounting term referring to an account which is a subdivision of an object account. You may establish subsidiary accounts to keep
| ||||
mnDocArDefaultJe | DCAR | MATH_NUMERIC | OPT | OUTPUT |
A code that identifies the document number of the model journal entry to use for a particular customer. | ||||
szDocTyArDefaultJe | DTAR | char | OPT | OUTPUT |
A code that identifies the type of model journal entry to use for a particular customer. | ||||
szCompanyKeyARModel | KCOR | char | OPT | OUTPUT |
A number that, along with A/R Model Document Type (DTAR) and A/R Model Document Number (DCAR), uniquely identifies the model
| ||||
cErrorFlag | EV01 | char | OPT | OUTPUT |
An option that specifies the type of processing for an event. | ||||
mnInsuredCreditLimit | AMCR | MATH_NUMERIC | OPT | OUTPUT |
Reserved for J.D. Edwards. | ||||
jdGLdate | DGJ | JDEDATE | OPT | INPUT |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
| ||||
cCreditLimitOption | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event. | ||||
mnAddNoAlternatePayee | AN8J | MATH_NUMERIC | OPT | INPUT |
An alternate address to which accounts payable can send payments due. |
None |
None |