Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
mnCacheKey_UK01 | UK01 | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. |
idPointerToInvoiceCache_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
idPointerToF4201Header_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
idPointerToF4211Detail_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
idPointerToF004201l_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
mnInvoiceNumber_DOC | DOC | MATH_NUMERIC | OPT | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents
in the Accounts Receivable and Accounts Payable systems. Examples of original and matching documents are:
Accounts Payable
o
Original document - voucher
o Matching document - payment
Accounts Receivable
o Original document - invoice
o Matching document -
receipt
Note: In the Accounts Receivable system, the following transactions simultaneously generate original and matching documents:
deductions, unapplied receipts, chargebacks, and drafts. |
szInvoiceType_DCT | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are:
P
Accounts payable
documents
R
Accounts receivable documents
T
Time and Pay documents
I
Inventory documents
O
Purchase order documents
S
Sales order
documents
|
szInvoiceCompany_KCO | KCO | char | OPT | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
or journal entry.
If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the
document company to retrieve the correct next number for that company.
If two or more original documents have the same document number and
document type, you can use the document company to locate the desired document. |
mnInvoiceLineNumber_LNID | 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. |
mnDocumentOrderInvoiceE_DOCO | 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 | 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
|
szOrderCompanyKey_KCOO | 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. |
szHeaderBusinessUnit_MCU | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szCompany_CO | 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.
|
mnSoldToAddressBook_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
szSoldToDescriptive_ALKY | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field.
For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
|
szSoldToTaxId_TAX | TAX | char | OPT | NONE |
The identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax
number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC
(Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.
Attention Accounts Payable users: The Supplier Master
record supplies the default value for the tax ID for 1099 processing. |
szSoldToMailingName_MLNM | MLNM | char | OPT | NONE |
The company or person to whom billing or correspondence is addressed. |
szSoldToAddressLine1_ADD1 | ADD1 | char | OPT | NONE |
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service
(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the
following restrictions:
o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.
o On
1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.
o On other U.S. federal magnetic
media, the system prints only the last nonblank address line plus the city, state, and postal code.
|
szSoldToAddressLine2_ADD2 | ADD2 | char | OPT | NONE |
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state,
and postal code. |
szSoldToAddressLine3_ADD3 | ADD3 | char | OPT | NONE |
The third line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints
on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szSoldToAddressLine4_ADD4 | ADD4 | char | OPT | NONE |
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szSoldToCity_CTY1 | CTY1 | char | OPT | NONE |
A name that indicates the city associated with the address. |
szSoldToCounty_COUN | COUN | char | OPT | NONE |
The name of a county, parish, or other political district that is necessary for the address or for tax purposes. |
szSoldToState_ADDS | ADDS | char | OPT | NONE |
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation. |
szSoldToCountry_CTR | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
uses the country code for data selection and address formatting. |
szSoldToZipCodePostal_ADDZ | ADDZ | char | OPT | NONE |
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in
other countries. This code is used as the low end value when doing Postal Code Transaction range processing. |
mnRemitToAddressBook_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
szRemitToAlternateKey_ALKY | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field.
For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
|
szRemitToTaxId_TAX | TAX | char | OPT | NONE |
The identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax
number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC
(Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.
Attention Accounts Payable users: The Supplier Master
record supplies the default value for the tax ID for 1099 processing. |
szRemitToNameMailing_MLNM | MLNM | char | OPT | NONE |
The company or person to whom billing or correspondence is addressed. |
szRemitToAddressLine1_ADD1 | ADD1 | char | OPT | NONE |
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service
(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the
following restrictions:
o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.
o On
1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.
o On other U.S. federal magnetic
media, the system prints only the last nonblank address line plus the city, state, and postal code.
|
szRemitToAddressLine2_ADD2 | ADD2 | char | OPT | NONE |
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state,
and postal code. |
szRemitToAddressLine3_ADD3 | ADD3 | char | OPT | NONE |
The third line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints
on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szRemitToAddressLine4_ADD4 | ADD4 | char | OPT | NONE |
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szRemitToCity_CTY1 | CTY1 | char | OPT | NONE |
A name that indicates the city associated with the address. |
szRemitToCounty_COUN | COUN | char | OPT | NONE |
The name of a county, parish, or other political district that is necessary for the address or for tax purposes. |
szRemitToState_ADDS | ADDS | char | OPT | NONE |
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation. |
szRemitToCountry_CTR | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
uses the country code for data selection and address formatting. |
szRemitToZipCodePostal_ADDZ | ADDZ | char | OPT | NONE |
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in
other countries. This code is used as the low end value when doing Postal Code Transaction range processing. |
szShipFrom_MCU | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szHeaderCurrencyCode_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
mnTotalInvoiceAmount_ITOL | ITOL | MATH_NUMERIC | OPT | NONE |
The invoice amount for a billing detail transaction. |
szHeaderPaymentTermsCode_PTC | 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.
|
jdHeaderDueDate_DDJ | 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.
|
mnTotalInvoiceDiscount_IDSC | 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. |
jdInvoiceDate_IND | IND | JDEDATE | OPT | NONE |
The date the asset was installed which need not be the date acquired. The date acquired initiates the depreciation calculations, whereas,
the date installed is for memorandum purposes only. |
cHeaderSalesTaxable_TAX1 | TAX1 | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
also taxable. |
szHeaderTaxRateArea_TXA1 | 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. |
szHeaderTaxExplCode_EXR1 | 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. |
mnInvoiceTotalTaxAmount_STAM | 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). |
szTextAttachment_VR01 | VR01 | char | OPT | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
number, or job number. |
cReBill_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnShipToAddressBook_SHAN | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
szShipToAlternateKey_ALKY | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field.
For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
|
szShipToTaxId_TAX | TAX | char | OPT | NONE |
The identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax
number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC
(Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.
Attention Accounts Payable users: The Supplier Master
record supplies the default value for the tax ID for 1099 processing. |
szShipToMailingName_MLNM | MLNM | char | OPT | NONE |
The company or person to whom billing or correspondence is addressed. |
szShipToAddressLine1_ADD1 | ADD1 | char | OPT | NONE |
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service
(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the
following restrictions:
o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.
o On
1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.
o On other U.S. federal magnetic
media, the system prints only the last nonblank address line plus the city, state, and postal code.
|
szShipToAddressLine2_ADD2 | ADD2 | char | OPT | NONE |
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state,
and postal code. |
szShipToAddressLine3_ADD3 | ADD3 | char | OPT | NONE |
The third line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints
on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szShipToAddressLine4_ADD4 | ADD4 | char | OPT | NONE |
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szShipToCity_CTY1 | CTY1 | char | OPT | NONE |
A name that indicates the city associated with the address. |
szShipToCounty_COUN | COUN | char | OPT | NONE |
The name of a county, parish, or other political district that is necessary for the address or for tax purposes. |
szShipToState_ADDS | ADDS | char | OPT | NONE |
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation. |
szShipToCountry_CTR | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
uses the country code for data selection and address formatting. |
szShipToZipCodePostal_ADDZ | ADDZ | char | OPT | NONE |
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in
other countries. This code is used as the low end value when doing Postal Code Transaction range processing. |
jdActualShipDate_ADDJ | ADDJ | JDEDATE | OPT | NONE |
The date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales
Order Detail table (F4211) with this date.
|
jdOrderDate_TRDJ | TRDJ | JDEDATE | OPT | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. |
mnShortItemNumber_ITM | ITM | MATH_NUMERIC | OPT | NONE |
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 |
sz2ndItemNumber_LITM | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
alternative item numbers. The three types of item numbers are:
Item Number (short)
An 8-digit, computer-assigned item number.
2nd Item Number
A
25-digit, user defined, alphanumeric item number.
3rd Item Number
Another 25-digit, user defined, alphanumeric item number.
In addition to
these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous
cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or
supplier numbers.
|
sz3rdItemNumber_AITM | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
numbers are as follows:
1. Item Number (short) - An 8-digit, computer-assigned item number.
2. 2nd Item Number - The 25-digit, free-form, user
defined alphanumeric item number.
3. 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number.
In addition to
these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to
alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier
numbers. |
szPartnerItemNumber_CITM | CITM | char | OPT | NONE |
The cross-reference item number that the system assigns to an item number. A cross-reference number allows you to use a supplier's item
number if it is different from your own item number when you are processing an order or printing. |
szUPCItemNumber_UPCN | UPCN | char | OPT | NONE |
The Universal Product Code number which must conform to the UCC structure for UPC numbers. |
mnQuantityShipped_SOQS | SOQS | MATH_NUMERIC | OPT | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
item.
In the Manufacturing system and Work Order Time Entry, this field can indicate completed or scrapped quantities. The quantity type is
determined by the type code entered. |
mnQuantityBackorHeld_SOBK | SOBK | MATH_NUMERIC | OPT | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
measure defined for this item. |
mnQuantityCanceled_SOCN | SOCN | MATH_NUMERIC | OPT | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
this item.
In manufacturing, this can also be the number of units scrapped to date. |
szUnitOfMeasurePricing_UOM4 | UOM4 | char | OPT | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. |
szDetailCurrencyCode_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
mnDetailUnitPrice_UPRC | UPRC | MATH_NUMERIC | OPT | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
(F4106). |
mnDetailExtendedPrice_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. |
mnDetailPrepaymentAmt_ATAT | ATAT | MATH_NUMERIC | OPT | NONE |
This is the prepayment amount for each line. |
mnDetailAdjustmentAmt_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. |
cDetailSalesTaxable_TAX1 | TAX1 | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
also taxable. |
szTotalTaxAreaAuthority_TXA1 | 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. |
szTaxExplanationCode_EXR1 | 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. |
mnTotalDetailLineTaxAmt_STAM | 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). |
mnTaxAuthority1_TA1 | TA1 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority1TaxAmt_STAM | 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). |
mnTaxAuthority1TaxRate_TXR1 | TXR1 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxAuthority2_TA2 | TA2 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority2TaxAmt_STAM | 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). |
mnTaxAuthority2TaxRate_TXR2 | TXR2 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxAuthority3_TA3 | TA3 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. This is the agency to whom you pay and report sales, use,
or VAT taxes. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax
authorities for a single tax area.
|
mnTaxAuthority3TaxAmt_STAM | 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). |
mnTaxAuthority3TaxRate_TXR3 | TXR3 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxAuthority4_TA4 | TA4 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority4TaxAmt_STAM | 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). |
mnTaxAuthority4TaxRate_TXR4 | TXR4 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnTaxAuthority5_TA5 | TA5 | MATH_NUMERIC | OPT | NONE |
The address book number of the tax agency that has jurisdiction in the tax area. You pay and report sales, use, or VAT taxes to this
agency. Examples include states, counties, cities, transportation districts, provinces, and so on. You can specify up to five tax authorities for a single
tax area.
|
mnTaxAuthority5TaxAmt_STAM | 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). |
mnTaxAuthority5TaxRate_TXR5 | TXR5 | MATH_NUMERIC | OPT | NONE |
A number that identifies the percentage of tax that should be assessed or paid to the corresponding tax authority, based on the tax area.
Enter the percentage as a whole number and not as the decimal equivalent. For example, to specify 7 percent, enter 7, not .07.
|
mnShipmentNumber_SHPN | SHPN | MATH_NUMERIC | OPT | NONE |
A "next number" that uniquely identifies a shipment. |
szModeOfTransport_MOT | MOT | char | OPT | NONE |
A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by
road, and so on. |
mnCarrier_CARS | CARS | MATH_NUMERIC | OPT | NONE |
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or
special handling requirements. |
szCarrierAlternateKey_ALKY | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field.
For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
|
cSuppressErrorMessage_SUPPS | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
runtime error message handling.
1 = suppress runtime error message handling. |
szErrorMessageID_DTAI | DTAI | char | OPT | 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
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
|
cErrorCode_ERRC | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
Set Server program (XT4914). |
cFutureUseChar01_CM01 | CM01 | char | OPT | NONE |
|
cFutureUseChar02_CM02 | CM02 | char | OPT | NONE |
|
cFutureUseChar03_CM03 | CM03 | char | OPT | NONE |
|
mnFutureUseNumeric01_FUT2 | FUT2 | MATH_NUMERIC | OPT | NONE |
This field is for future use. |
szFutureUseString_FUT3 | FUT3 | char | OPT | NONE |
This field is for future use. |
idFutureUsePointer01_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
idFutureUsePointer02_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
mnOrderLineNumber_LNID | 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. |
szCacheActionCode_CACTN | CACTN | char | OPT | NONE |
A code that indicates the activity you want to perform. Valid codes:
o Get - Retrieve the cache element
o Add - Add a cache element
o
Update - Update a cache element
o Delete - Delete a cache element
o Delete All - Delete all cache elements
o Get Next - Retrieve the
next cache element
o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist
o Terminate -
Terminate Cache |
cHeaderDetailFlag_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
mnBillToAddressNumber_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.
|
szBillToAlternateKey_ALKY | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field.
For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
|
szBillToTaxId_TAX | TAX | char | OPT | NONE |
The identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax
number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC
(Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.
Attention Accounts Payable users: The Supplier Master
record supplies the default value for the tax ID for 1099 processing. |
szBillToMailingName_MLNM | MLNM | char | OPT | NONE |
The company or person to whom billing or correspondence is addressed. |
szBillToAddressLine1_ADD1 | ADD1 | char | OPT | NONE |
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service
(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the
following restrictions:
o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.
o On
1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.
o On other U.S. federal magnetic
media, the system prints only the last nonblank address line plus the city, state, and postal code.
|
szBillToAddressLine2_ADD2 | ADD2 | char | OPT | NONE |
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state,
and postal code. |
szBillToAddressLine3_ADD3 | ADD3 | char | OPT | NONE |
The third line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints
on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szBillToAddressLine4_ADD4 | ADD4 | char | OPT | NONE |
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szBillToCity_CTY1 | CTY1 | char | OPT | NONE |
A name that indicates the city associated with the address. |
szBillToCounty_COUN | COUN | char | OPT | NONE |
The name of a county, parish, or other political district that is necessary for the address or for tax purposes. |
szBillToState_ADDS | ADDS | char | OPT | NONE |
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation. |
szBillToPostalCode_ADDZ | ADDZ | char | OPT | NONE |
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in
other countries. This code is used as the low end value when doing Postal Code Transaction range processing. |
szBillToCountry_CTR | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
uses the country code for data selection and address formatting. |
szComputerID_CTID | CTID | char | OPT | NONE |
|
szDetailBranchPlant_MCU | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szFreightHandlingCode_FRTH | FRTH | char | OPT | NONE |
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
your dock, or you could pick up the shipment at the supplier's dock. You can also use these codes to indicate who has responsibility for
freight charges. For example, you can have a code indicating that the customer legally takes possession of goods as soon as they leave the
supplier warehouse and is responsible for transportation charges to the destination. |
mnFutureUseNumeric02_FUT2 | FUT2 | MATH_NUMERIC | OPT | NONE |
This field is for future use. |
szFutureUseString2_FUT3 | FUT3 | char | OPT | NONE |
This field is for future use. |
jdFutureUseDate1_CMDT | CMDT | JDEDATE | OPT | NONE |
|
jdFutureUseDate2_CMDT | CMDT | JDEDATE | OPT | NONE |
|
mnPickSlipNumber_PSN | PSN | MATH_NUMERIC | OPT | NONE |
A automatic next number assigned by the system that can be used to track picking information through the system. This number is
assigned during the printing of pick slips. The shipment confirmation program allows inquiry and confirmation by this number. |