Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
jdAsOfDate_ASDE1 | ASDE1 | JDEDATE | OPT | BOTH |
The date used for effectivity checking. Enter a specific date to display documents (orders, bills of material, routings, as applicable) that are
effective on or after that date. The current system date is the default, but you can enter any future or past date. |
szCurrencyCodeFrom_CRCD | CRCD | char | OPT | OUTPUT |
A code that identifies the currency of a transaction.
|
jdDateLastUpdated_UPMJ | UPMJ | JDEDATE | OPT | OUTPUT |
The date that specifies the last update to the file record. |
mnCreditLimit_ACL | 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
throughout the credit management programs. The system maintains the credit limit at the customer (child) level, not the parent level. The system
sends workflow messages for each customer who is over their credit limit. When you set up or change the credit limit, the system sends a
workflow message to the credit manager that the change is pending approval. The change to the credit limit is not reflected in the customer
record until it is approved by the credit manager. |
mnCreditBalance_AD | AD | MATH_NUMERIC | OPT | OUTPUT |
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
determine if a particular order exceeds a credit limit. See the documentation for the Order Processing system.
|
mnFutureAmtDue_AG | AG | MATH_NUMERIC | OPT | OUTPUT |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
the tax explanation code. The system does not decrease the gross amount when payments are applied. When you void a transaction, the
system clears the gross amount field.
|
mnAgingAmt1_AG1 | AG1 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the first category as defined in either the Accounts Receivable constants or the processing options
of Credit Analysis Refresh. If you age by days, the system determines the first aging category by using the days defined in the second and
third aging categories.
For example, if the second aging category is 0 and the third aging category is 30, the date on the invoice that you use
to age (invoice date, due date, statement date, or G/L date) must be equal to but no more than 30 days after the aging date that you define. |
mnAgingAmt2_AG2 | AG2 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the second category as defined in either the Accounts Receivable constants or the processing
options of Credit Analysis Refresh. If you age by days, the system determines the second aging category by using the days defined in the third
and fourth aging categories.
For example, if the third aging category is 30 and the fourth aging category is 60, the date on the invoice that you
use to age (invoice date, due date, statement date, or G/L date) must be between 30 and 60 days after the aging date that you define. |
mnAgingAmt3_AG3 | AG3 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the third category as defined in either the Accounts Receivable constants or the processing options
of Credit Analysis Refresh. If you age by days, the system determines the third aging category by using the days defined in the fourth and
fifth aging categories.
For example, if the fourth aging category is 60 and the fifth aging category is 90, the date on the invoice that you use to
age (invoice date, due date, statement date, or G/L date) must be between 60 and 90 days after the aging date that you define. |
mnAgingAmt4_AG4 | AG4 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the fourth category as defined in either the Accounts Receivable constants or the processing
options of Credit Analysis Refresh. If you age by days, the system determines the fourth aging category by using the days defined in the fifth and
sixth aging categories.
For example, if the fifth aging category is 90 and the sixth aging category is 120, the date on the invoice that you use to
age (invoice date, due date, statement date, or G/L date) must be between 90 and 120 days after the aging date that you define. |
mnAgingAmt5_AG5 | AG5 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the fifth category as defined in either the Accounts Receivable constants or the processing options
of Credit Analysis Refresh. If you age by days, the system determines the fifth aging category by using the days defined in the sixth and
seventh aging categories.
For example, if the sixth aging category is 120 and the seventh aging category is 150, the date on the invoice that you
use to age (invoice date, due date, statement date, or G/L date) must be between 120 and 150 days after the aging date that you define. |
mnAgingAmt6_AG6 | AG6 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the sixth category as defined in either the Accounts Receivable constants or the processing options
of Credit Analysis Refresh. If you age by days, the system determines the sixth aging category by using the days defined in the seventh
and eighth aging categories.
For example, if the seventh aging category is 150 and the eighth aging category is 180, the date on the invoice that
you use to age (invoice date, due date, statement date, or G/L date) must be between 150 and 180 days after the aging date that you
define. |
mnAgingAmt7_AG7 | AG7 | MATH_NUMERIC | OPT | OUTPUT |
The total open invoice amount that is in the seventh category as defined in either the Accounts Receivable constants or the processing
options of Credit Analysis Refresh. If you age by days, the system determines the seventh aging category by using the days defined in the
eighth aging category.
For example, if the eighth aging category is 180, the date on the invoice that you use to age (invoice date, due date,
statement date, or G/L date) must be more than 180 days after the aging date that you define. |
mnAgingAmt8_AG8 | AG8 | MATH_NUMERIC | OPT | OUTPUT |
The amount retained on your books for the number of days indicated by the category number. The system automatically computes aging
each time you inquire on an account or print a report. |
szFutureAmtDescription_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription1_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription2_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription3_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription4_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription5_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription6_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription7_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
szAgingDescription8_DL01 | DL01 | char | OPT | OUTPUT |
A user defined name or remark. |
mnAverageDaysLate_AVD | AVD | MATH_NUMERIC | OPT | OUTPUT |
The average number or days that it takes a customer to pay an invoice. The system calculates the average days late, which is
nonweighted, by determining the number of days that each invoice was past due, and then dividing that number by the total number of invoices. The
system calculates the average days late when you run the Statistics History Update program (R03B16).
|
mnPercentPaidLate_PE | PE | MATH_NUMERIC | OPT | OUTPUT |
The system treats the value in this field as a percentage. For example, enter 97 for 97%. You can enter percentages that include decimals.
For example,enter 95.75 for 95.75%. Negative values and values over 100% are also valid. |
jdDateLastPaid_DLP | DLP | JDEDATE | OPT | OUTPUT |
The date of the last premium payment. |
mnAmountLastPaid_ALP | 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
information from either the A/R Statistical Summary table (F03B16S) or the A/R Statistical History table (F03B16), depending on the form.
The system displays information from F03B16S on the Account Statistical Summary form and information from F03B16 on the Periodic Statistics
form. |
cProcessingScopeFlag_EV01 | EV01 | char | OPT | INPUT |
An option that specifies the type of processing for an event.
|
cCreditCheckLevel_ARTO | ARTO | char | OPT | BOTH |
A code that controls the way the system conducts credit checking.
Codes are:
P Credit check based on the customer's parent number (P
for Parent)
C Credit check against the customer number only
S Credit check against the customer number only
If you use method P, the
system compares the open accounts receivable and open sales orders for the sum of the children and the parent against the credit limit for the
parent number. Use this, for example, when a customer with multiple offices or branches, each of which order from you, asks that all credit
checking be reflected in a single account.
NOTE: Even though credit checking can be conducted at the parent or customer number level, all
accounts receivable will be posted to the customer number (SDAN8) during Sales Update (P42800). |
mnOpenOrderAmt_APRC | APRC | MATH_NUMERIC | OPT | 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
the discount tables or any override price. You cannot override this amount. |
mnTotalExposure_AMTU | AMTU | MATH_NUMERIC | OPT | NONE |
A quantity that represents the statistical or measurable information related to the code that is defined for the data type. For example, if the
data type relates to bid submittal codes, this field could be for bid amounts. Or, if the data type relates to Human Resources Benefits
Administration, this field could be for the cost of election coverage. If the data type relates to bonuses, this could be the bonus amount. |
jdDateFirstInvoice_DFIJ | DFIJ | JDEDATE | OPT | NONE |
The G/L date of the first invoice generated. |
jdDateLastInvoice_DLIJ | DLIJ | JDEDATE | OPT | NONE |
The G/L date of the last invoice generated for the customer. |
mnAmtInvoicedThisYr_ASTY | ASTY | MATH_NUMERIC | OPT | NONE |
The amount invoiced for the year. The system uses the gross amount of the invoice record (F03B11) regardless of whether taxes are
included. The system updates this field when you run the Statistics History Update program (R03B16). The system determines the current fiscal
year from the Date Fiscal Patterns - 52 Period Accounting table (F0008B). |
mnAmtInvoicedPriorYr_SPYE | SPYE | MATH_NUMERIC | OPT | NONE |
The gross amount invoiced for the previous year. The system updates this field only when you run the Statistics Annual Close program
(R03B161).
|