Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnBatchNumber | ICU | MATH_NUMERIC | OPT | INPUT |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program. |
mnDocumentOrderAlt | DOCZ | MATH_NUMERIC | OPT | INPUT |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, etc. Matching document
numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. See matching document
(DOCM). This document number (DOCO) is always the original document number, and the matching document number (DOCM) is the check,
adjustment, or credit to be applied against the original document.
For example:
A/P Automated/Manual Payment: Original (DOCO) - Voucher;
Matching Document (DOCM) - Payment
A/R Original Invoice: Original (DOCO) - Invoice
Receipt Application: Original (DOCO) - Invoice; Matching
Document (DOCM) - Receipt
Credit Memo/Adjustment: Original (DOCO) - Invoice; Matching Document (DOCM) -Credit Memo
Unapplied
Case: Original (DOCO) - Receipt |
szDocTypeInvoiceOnly | DCTI | char | OPT | INPUT |
A user defined (00/DI) document type for invoice entry. Any document type set up for invoice-only entry should begin with the letter R
(receivables). The default is RI, RR, or RM. Reserved document types have been defined for vouchers, invoices, receipts, and time sheets.
The
reserved document types are:
P_
Accounts Payable Documents R_Accounts Receivable Documents
T_
Payroll Documents I_Inventory
Documents
O_
Order Processing Documents
Note: Verify that the default document type for invoices is set up in both UDC 00/DT and UDC 00/DI.
|
szDocumentCompanyInvoice | KCOI | char | OPT | INPUT |
Invoice Document Company. |
szDocumentPayItem | SFX | char | OPT | INPUT |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
multiple pay items, the numbers are sequential. |
szErrorMessage | DTAI | char | OPT | OUTPUT |
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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
|
szUserId | USER | char | REQ | INPUT |
The code that identifies a user profile.
|
szWorkStationId | JOBN | char | REQ | INPUT |
The code that identifies the work station ID that executed a particular job.
|
szProgramId | PID | char | REQ | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
mnTimeLastUpdated | UPMT | MATH_NUMERIC | REQ | INPUT |
The time that specifies when the program executed the last update to this record. |
jdDateUpdated | UPMJ | JDEDATE | REQ | INPUT |
The date that specifies the last update to the file record. |
cClearMode | EV01 | char | REQ | INPUT |
An option that specifies the type of processing for an event.
|
mnBillingControlId | BCI | MATH_NUMERIC | OPT | INPUT |
A unique number that the system assigns to each billing record. The system assigns the number from the Next Numbers - Automatic table
(F0002) for system 15, line 2 (Billing Control).
|
mnParentSequenceNbr | PRSQ | MATH_NUMERIC | OPT | INPUT |
A number that provides an audit trail to the original transaction of a billing detail transaction. The system initially assigns 000 as the parent
sequence number. The number remains 000 unless you split the transaction. In this case,the sequence number (SBSQ) of the original
transaction becomes the parent sequence number (PRSQ) for the resulting transactions. |
mnSequenceNbrServiceBilling | SBSQ | MATH_NUMERIC | OPT | INPUT |
A number that provides an audit trail for the billing detail transactions related to the same billing control ID. The system initially assigns 001
as the sequence number (SBSQ) of the original transaction. If you split a transaction, the system increments the number to the next available
sequence numbers (SBSQ) for the resulting transactions. |
mnSecondarySequence | SCSQ | MATH_NUMERIC | OPT | INPUT |
A number you can use to track the changes applied to a billing detail transaction. The system initially assigns 001 as the secondary
sequence number (SCSQ). Each time you modify the billing detail transaction, the system increases the number by 1. |
jdGLDate | DGL | JDEDATE | OPT | INPUT |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for
PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.
|
mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on. |
szOrderType | DCTO | char | OPT | NONE |
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
|
szCompanyKeyOrderNo | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on).
If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document.
If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document. |
szContractChangeNum | COCH | char | OPT | NONE |
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a
change order for a contract, the system automatically increases the change order number by one.
For example, the base contract is the change
order number 000, the first change order is 001, the second is 002, and so on. |
mnLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it. |
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.
|
szGlClass | GLC | char | OPT | NONE |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For
example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables).
You can assign up to four
alphanumeric characters to represent the G/L offset or you can assign the three-character currency code (if you enter transactions in a
multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L
offset and uses the account that is set up for PC or RC for the company specified.
If you set up a default value in the G/L Offset field of the
customer or supplier record, the system uses the value during transaction entry unless you override it.
Note: Do not use code 9999. It is reserved for
the post program and indicates that offsets should not be created.
|
jdDateBillFrom | BTFR | JDEDATE | OPT | NONE |
The from date used to determine if a transaction is billed. The transaction is billed if the general ledger date falls between the from date and
the through date. |
jdBilledThroughDate | BTDT | JDEDATE | OPT | NONE |
This field will be used in the Recurring Billing module as part of a date-oriented billing method, as opposed to period-oriented billing. This
field will contain the latest date for which billings have been generated for the associated billing line. |
jdDtForGLAndVouch1_2 | 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
financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for
PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages.
|
jdDateDueJulian | DDJ | JDEDATE | OPT | NONE |
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount
or, if no discount is offered, the net due date.
The system calculates the due date based on the payment term entered, or you can enter it
manually. If you enter a negative voucher or invoice (debit or credit memo), the system might use the G/L date as the due date regardless of the
payment term entered. A processing option in the master business function (P0400047 for vouchers and P03B0011 for invoices) controls how
the system calculates the due date for debit and credit memos.
|
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. |
mnThisPeriod | THPD | MATH_NUMERIC | OPT | NONE |
The amount that is being billed for this contract pay item. |
mnThisPeriodForeign | FHPD | MATH_NUMERIC | OPT | NONE |
The amount that is being billed for this contract pay item. On entry screens,you can enter this amount one of three ways:
o A Dollar
Amount.
o A Percent Complete. Enter a percent sign % before or after the percent complete amount. For example, you can enter 10% complete as
%10 or 10%.
The system calculates this amount as the Schedule of Values minus prior payments.
o Number of Units. Enter a forward
slash / before or after the number of units. For example, you can enter 10 units as /10 or 10/. The system calculates this amount as the number
of units multiplied by the unit rate. You must have a unit rate payment type and a valid unit price for the contract pay item in order to use this
entry method. |
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. |
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. |
mnAmtTax2 | STAM | MATH_NUMERIC | OPT | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). |
mnForeignTaxAmount | CTAM | MATH_NUMERIC | OPT | NONE |
The tax amount in foreign currency. This can be the sales, use, or VAT tax.
|
mnAmountTaxable | ATXA | MATH_NUMERIC | OPT | NONE |
The amount on which taxes are assessed. |
mnForeignTaxableAmount | CTXA | MATH_NUMERIC | OPT | NONE |
That portion of the sale that is subject to tax in foreign currency. |
szGlOffsetRetention | RGLC | char | OPT | NONE |
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting
instruction.
Note: Do not use code 9999. This is reserved for the post program and indicates that offsets should not be created. |
mnPercntRetainage | PRET | MATH_NUMERIC | OPT | NONE |
The retainage rate for the contract. The rate is a percentage that is expressed as a whole number. For example, you enter a retainage rate
of 10.5 percent as 10.5. |
szRetainageRule | RTNR | char | OPT | NONE |
A rule the system uses to calculate retainage on a contract. For example:
Retn % - 10.00; Percent Complete - 50.00
Retn % - 5.00; Percent
Complete - 95.00
This rule indicates that there is a 10% retainage until 50% of the job is complete. Then a 5% retainage is calculated for the next
45% of the job until 95% of the job is complete. Once 95% of the job is complete, retainage is no longer withheld. |
cRetainageControlFlag | RCTL | char | OPT | NONE |
An option that determines whether the retainage amount is stored in the Accounts Receivable or General Accounting system and whether
tax is calculated on the whole amount, including the retainage, or on each amount as it is billed. Valid values are:
Blank
The retainage is
stored in the Accounts Receivable system and the tax is computed from the total taxable amount.
1
The retainage is stored in the Accounts
Receivable system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is
deferred until the retainage is released.
2
The retainage is stored in the General Accounting system and the tax is computed from the total taxable
amount.
3
The retainage is stored in the General Accounting system and the tax on the retainage amount is calculated and then subtracted from
the total tax amount. This tax on retainage is deferred until the retainage is released. |
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.
|
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. |
mnCurrencyConverRateOv | 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.
|
mnCurrencyConverRateDiv | CRRD | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
|
jdDateRecordUpdated | MUPM | JDEDATE | OPT | NONE |
The date of last update. Used in the Financial Reporting Merge file (F1011) where field name is duplicated. |
szGeoCodeShipFrom | 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. |
szGeoCodeOrderAccept | 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. |
szVertexTransactionType | VVTY | char | OPT | NONE |
Vertex Sales and Use Tax transaction type. |
szVertexProductCategory | VVTC | char | OPT | NONE |
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. |
cDeleteInvoiceFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
szOwnerPayItem | OPIM | char | OPT | NONE |
The pay item number as defined by the owner. This field is alphanumeric and can be up to 15 characters in length. It is recommended that
you use numeric information for this pay item number. |