Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnCostAmount | AA | MATH_NUMERIC | OPT | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
minus sign (-) either before or after the amount.
|
mnUnits | U | MATH_NUMERIC | OPT | NONE |
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons,
hours, and so on. |
mnOverrideRateInvoice | BRTI | MATH_NUMERIC | OPT | NONE |
A rate that the system uses to mark up the invoice amount reflected in the billing of professional services workers such as draftsmen,
engineers, or consultants. This rate does not affect the employee's paycheck. You can use the markup rate as an override rate or a maximum
rate.
The calculation of the override rate for the total invoice markup is as follows:
(Override Rate x Unit) x (1 + Markup Percent) + Markup
Amount
When you specify a maximum or cap rate, the system compares the rate override with the rate from the cost transaction. The system then
uses the lower rate as the override rate.
You set up the override or maximum unit rate using the Billing Rate / Markup Table program (P48096).
Within the Service Billing and Contract Billing systems, you can mark up the revenue amount at a different rate from the invoice amount. The
Independent Revenue/Invoice Amounts option in the Billing System Constants table (F48091) controls this function. Use generation type 1 to
specify a table for invoice, revenue, and component markup rates and use generation type 2 to specify a table for revenue and component
markup rates.
Use generation type 1 to specify the invoice and revenue markup rates only when the Independent Revenue/Invoice amounts
are set to not equal in the Billing Constants.
|
cCapFlagInvoice | CAPI | char | OPT | NONE |
A flag to indicate if the associated amount is the override rate or the cap of the rate. |
mnPercentageInvoice | PCIM | MATH_NUMERIC | OPT | NONE |
A number that specifies the percentage that the system uses to mark up the revenue amount reflected in the billing of professional services,
such as fees for draftsmen, engineers, and consultants. Enter the percentage as a whole number. For example, 50.275 percent would be
entered as 50.275. This percentage rate does not affect the employee's payment.
You set up this percentage in the Billing Rate / Markup
Table program (P48096). Use generation type 1 to specify a table for invoice, revenue, and component markup rates.
With the Service Billing and
Contract Billing systems, you can mark up the revenue amount at a different rate than the invoice amount. The Independent
Revenue/Invoice Amounts option in the Billing Constants program (P48091) controls this function. Use generation type 2 on the Billing Rate/Markup
Revisions form to specify a table for revenue and component markup rates.
|
mnAmountInvoiceMarkUp | ADCI | MATH_NUMERIC | OPT | NONE |
An amount that the system uses to mark up the invoice amount for the billing of professional services, such as the services of draftsmen,
engineers, or consultants. This amount does not affect the employee's payment.
You use the Billing Rate / Markup Table program (P48096) to
set up the amount. Use generation type 1 to specify a table for invoice, revenue, and component markup amounts.
With the Service Billing and
Contract Billing systems, you can mark up the revenue amount by a different amount than the invoice amount. The Independent
Revenue/Invoice Amounts option in the Billing System Constants table (F48091) controls this function. Use generation type 2 to specify a table for
revenue and component markup amounts.
|
mnTotalAmountInvoiced | ITOL | MATH_NUMERIC | OPT | NONE |
The invoice amount for a billing detail transaction. |
mnInvoiceTaxable | ITXA | MATH_NUMERIC | OPT | NONE |
The portion of the invoice amount that is subject to tax. |
mnInvoiceTaxAmount | ITAM | MATH_NUMERIC | OPT | NONE |
The tax amount in the invoice. This can be either the sales, use or VAT tax. |
mnInvoiceDiscountAvail | IDSC | MATH_NUMERIC | OPT | NONE |
The amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is based on the
invoice amount rather than the revenue amount. |
szTaxExplanationCode1 | EXR1 | char | OPT | NONE |
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
system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each
transaction pay item can be defined with a different tax explanation code. |
szTaxArea1 | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher. |
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
szCurrencyCodeOrigin | CRCF | char | OPT | NONE |
The currency code of the insured amount. |
mnForeignInvoiceAmount | CITL | MATH_NUMERIC | OPT | NONE |
The total amount of the invoice in foreign currency. |
mnForeignCostAmount | AA2 | MATH_NUMERIC | OPT | NONE |
Amount. |
mnInvoiceTaxableForeign | CITA | MATH_NUMERIC | OPT | NONE |
The portion of the foreign invoice amount that is subject to tax. |
mnInvoiceTaxForeign | CITX | MATH_NUMERIC | OPT | NONE |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. |
mnInvoiceDiscountForeign | CIDS | MATH_NUMERIC | OPT | NONE |
The foreign currency amount of the discount available, as opposed to the amount of the discount actually taken. The discount calculated is
based on the foreign invoice amount. |
mnAmountJournaledTax | JTAX | MATH_NUMERIC | OPT | NONE |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. |
mnAmountJournaledTaxFor | JTXF | MATH_NUMERIC | OPT | NONE |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. |
szPaymentTermsCode01 | PTC | char | OPT | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions
form. Examples of payment terms include:
Blank
Net 15
001
1/10 net 30
002
2/10 net 30
003
Due on the 10th day of every month
006
Due upon receipt
This code prints on customer invoices.
|
cCurrencyMode | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
foreign currency of the transaction.
Off
The system displays amounts in the domestic currency of the transaction.
|
mnUnitPricePerPrimaryForeign | PRIF | MATH_NUMERIC | OPT | NONE |
This field represents the Foreign Unit price. |
mnUnitPricePerPrimary | PRIC | MATH_NUMERIC | OPT | NONE |
A base or default price that is used with multipliers from the pricing rules to develop discounted prices. If no formula applies to an item or no
discounts apply to a customer, the system uses this price without adjustments.
|
cCapFlag | CAP | char | OPT | NONE |
This flag indicates whether the associated amount is the override rate or the cap of the rate.
Values are:
blank Override Rate.
1 Cap of
the Rate. If the cost rate is less than the cap rate, the cost rate will be used; if the cost rate is greater than the cap rate, the Cap Rate will be
used. |
mnOverrideRateRevenue | BRT | MATH_NUMERIC | OPT | NONE |
A rate that the system uses to mark up the revenue amount reflected in the billing of professional services such as draftsmen, engineers, or
consultants. This rate does not affect the employee's paycheck. You can use the markup rate as an override rate or as a maximum rate.
The
calculation of the rate override for the total revenue markup is as follows:
(Rate Override * Unit) * (1 + Markup Percent) + Markup
Amount
When you specify a maximum or cap rate, the system compares the rate override with the rate from the cost transaction. The system then uses
the lower rate as the override rate.
You set up the override or maximum unit rate using the Billing Rate / Markup Table program (P48096).
Within
the Service Billing and Contract Billing systems, you can mark up the revenue amount at a different rate from the invoice amount. The
Independent Revenue/Invoice Amounts option in the Billing System Constants table (F48091) controls this function. Use generation type 1 to
specify a table for invoice, revenue, and component markup rates and use generation type 2 to specify a table for revenue and component
markup rates.
Use generation type 1 to specify the invoice, revenue, and component markup rates only when the Independent Revenue/Invoice
Amounts are set to not equal in the Billing Constants.
|
mnPercentage | PERT | MATH_NUMERIC | OPT | NONE |
The percentage that you use to mark up the revenue amount reflected in the billing of professional services workers, such as draftsmen,
engineers, or consultants fees. This percentage rate does not affect the employee's paycheck. This percentage rate is set up in the Billing
Rate/Markup Table program (P48096) using generation type 1 to specify a table for revenue/invoice markup percentage rates.
Enter
percentages as whole numbers. For example, 50.275% would be entered as 50.275.
|
mnAmountRevenueMarkUp | ADCR | MATH_NUMERIC | OPT | NONE |
An amount that the system uses to mark up the revenue amount for the billing of professional services, such as the services of draftsmen,
engineers, or consultants. This amount does not affect the employee's payment.
You use the Billing Rate / Markup Table program (P48096) to
set up the amount. Use generation type 1 to specify a table for invoice, revenue, and component markup amounts. Use generation type 2
to specify a table for revenue and component markup amounts.
With the Service Billing and Contract Billing systems, you can mark up the
revenue amount by a different amount than the invoice amount. The Independent Revenue/Invoice Amounts option in the Billing System
Constants table (F48091) controls this function. Use generation type 2 to specify a table for revenue and component markup amounts.
|
mnTotalAmountRevenue | BTOL | MATH_NUMERIC | OPT | NONE |
The revenue amount for a billing detail transaction. |
mnTotalAmountRevFore | FTOL | MATH_NUMERIC | OPT | NONE |
The total amount of the invoice or bill. The total of the individual line items must match this amount. |
cDateExchangeRateDateBasi | ERDB | char | OPT | NONE |
A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are:
1
Use the invoice date
(default).
2
Use the G/L date of the invoice.
|
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions.
Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
|
jdDateExchangeRate | ERDT | JDEDATE | OPT | NONE |
This is the date that was used to establish the exchange rate at the time the billing detail transaction was being created. |
jdDateTableBasis | TBDT | JDEDATE | OPT | NONE |
This date is used as the basis for comparison to the effective dates of the various tables used by the Service Billing system. This date is
determined by the values set up in the Service Billing Constants at the time the Service Billing Work File (F4812) is generated. |
mnAddressNumberJobAr | AN8O | MATH_NUMERIC | OPT | NONE |
The address book number to which the system posts billing and accounts receivable transactions. |
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. |
mnExchangeRate | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
|
cReExtendOption | RXOP | char | OPT | NONE |
A code that specifies how the system should re-extend a transaction. You re-extend a transaction when you want to change or reapply the
markup for the transaction based on your specific overrides or on the information that you have defined in the markup tables. Valid values
are:
1
Reapply the established invoice markup rates from the Billing Rate/Markup table (F48096). The revenue amount is not
changed.
2
Reapply the established revenue markup rates from the F48096 table. The invoice amount is not changed.
3
Use the rates or amounts entered on the
Amounts/Units Information window or on the Billing Rate/Markup Revisions form. Do not apply the established invoice or revenue markup
rates from the F48096 table.
Blank
Reapply both the invoice and revenue markup rates using the established rates from the F48096
table.
Note: You cannot use codes 1 and 2 when the Independent Revenue/Invoice Amounts option in the system constants specifies that the invoice
and revenue amounts must be equal.
|
cTaxableYN1 | TX | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you purchase it. The system calculates tax on the item only if the supplier
is also taxable. |
jdDateServiceTax | DSVJ | JDEDATE | OPT | NONE |
A date that indicates when you purchased goods or services, or when you incurred a tax liability.
|
cAmountChanged | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnTotalAmountHistoricalRevenue | HBTL | MATH_NUMERIC | OPT | NONE |
This value represents the revenue amount prior to invoice generation. Use this value to restore the original revenue amount if the record is
deleted from an invoice batch. |
mnTotalAmountInvoicedHistorica | HITL | MATH_NUMERIC | OPT | NONE |
This value represents the invoice amount prior to invoice generation. Use this value to restore the original invoice amount if the record is
deleted from an invoice batch. |
mnInvoiceTaxableHistorical | HITX | MATH_NUMERIC | OPT | NONE |
This value represents the invoice taxable amount prior to invoice generation.
Use this value to restore the original invoice taxable amount if
the record is deleted from an invoice batch. |
mnInvoiceTaxAmountHistorical | HTAM | MATH_NUMERIC | OPT | NONE |
This value represents the invoice tax amount prior to invoice generation. Use this value to restore the original invoice tax amount if the
record is deleted from an invoice batch. |
mnDiscountPaymentTerms | DCP | MATH_NUMERIC | OPT | NONE |
The percent of the total invoice or voucher that you will discount if it is paid within the discount period. You enter the discount percent as a
decimal, for example, a 2 percent discount is .02. |
cCalcPreviewFlag | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cRevAmountChanged | EV03 | char | OPT | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
and IZ types. Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.
|
cIndependentInvoice | INDI | char | OPT | NONE |
An option that specifies whether you can mark up the invoice and revenue amounts in the billing detail transactions independent of each
other. If you choose this option, you can manipulate and process invoice amounts without affecting the associated revenue amounts, and vice
versa. If you do not choose this option, the system ensures that the invoice amounts and the revenue amounts in the billing detail transactions
are always equal.
|
szGeoCodeShipTo | TXA1 | char | OPT | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher. |
szGeoCodeShipFrom | TXA1 | char | OPT | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher. |
szGeoCodeOrderAccept | TXA1 | char | OPT | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax
and G/L distribution amounts when you create an invoice or voucher. |
szVertexTransactionType | VVTY | char | OPT | INPUT |
Vertex Sales and Use Tax transaction type. |
szLineType | LNTY | char | OPT | INPUT |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under
which a line prints on reports, and it is included in calculations. Codes include the following:
S
Stock item
J
Job cost
N
Nonstock item
F
Freight
T
Text information
M
Miscellaneous charges and credits
W
Work order |
szOrderType | DCTO | char | OPT | INPUT |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.)
The following document types are defined by J.D. Edwards and
should not be changed:
P
Accounts Payable documents
R
Accounts Receivable documents
T
Payroll documents
I
Inventory documents
O
Purchase Order Processing documents
J
General Accounting/Joint Interest Billing documents
S
Sales Order Processing documents
|
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:
o Item Number (short) - An eight-digit, computer-assigned item number
o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number
o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number |
szVertexProductCategory | VVTC | char | OPT | INPUT |
User defined code used in the Vertex Tax Decision Maker for products or services that are non-taxable or are at a non-stanard rate. |
cVertexActiveFlag | VVTX | char | OPT | INPUT |
This flag determines whether to use the Vertex Tax Compliance system for tax calculations. Values are:
Y
Use Vertex system to calculate
taxes.
N
Do not use Vertex system to calculate taxes. Instead, use JDE tax calculations.
|
mnVertexCacheJobNumber | JOBS | MATH_NUMERIC | OPT | INPUT |
The job number (work station ID) which executed the particular job. |
cEligibilityCode | ELGC | char | OPT | BOTH |
A code that specifies how the system processes a transaction at the single-transaction level. Valid values are:
0
Available for invoicing and
revenue.
1
Available for invoicing only.
2
Available for revenue only.
3
Non-billable.
4
Available for cost only.
5
Available for accounts payable
only.
The system assigns eligibility codes to workfile transactions based on the Billable (Y/N) field in the Account Master table (F0901) and the
Journal Generation Control field that you set up in your system constants. For example, if an account with a Y in the Billable (Y/N) field is
processed through the billing system and the Journal Generation Control field is set for billing only, the eligibility code for the transaction is 1. An
eligibility code of 1 specifies that the transaction is available for invoicing only.
|
cOrigCurrencyMode | CRRM | char | OPT | INPUT |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
foreign currency of the transaction.
Off
The system displays amounts in the domestic currency of the transaction.
|