D1702980 - Parts List Real Time Template
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnF3111Doco | 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,
| ||||
szF3111DCTO | 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
| ||||
szF3111SFXO | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
szF3111TBM | TBM | char | OPT | NONE |
A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
| ||||
cF3111FORQ | FORQ | char | OPT | NONE |
A code that indicates if the quantity per assembly for an item on the bill of material varies according to the quantity of the parent item
| ||||
cF3111ITC | ITC | char | OPT | NONE |
A code that indicates how the system issues each component in the bill of material from stock. In Shop Floor Management, it indicates how
| ||||
cF3111COBY | COBY | char | OPT | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
cF3111COTY | COTY | char | OPT | NONE |
The component type determines what the component is used for in a bill of material. For example:
A Active ingredient
C Standard
| ||||
mnF3111CPNT | CPNT | MATH_NUMERIC | OPT | NONE |
A number that indicates the sequence of the components on a bill of material.
It initially indicates the relative sequence in which a
| ||||
mnF3111FRMP | FRMP | MATH_NUMERIC | OPT | NONE |
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.
The system displays a warning
| ||||
mnF3111THRP | THRP | MATH_NUMERIC | OPT | NONE |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
| ||||
szF3111FRGD | FRGD | char | OPT | NONE |
A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item.
The system displays a warning message if
| ||||
szF3111THGD | THGD | char | OPT | NONE |
A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item.
The system displays a warning message if
| ||||
szF3111RKCO | RKCO | char | OPT | NONE |
The key company that is associated with the document number of the related order. | ||||
szF3111RORN | RORN | char | OPT | NONE |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szF3111RCTO | RCTO | char | OPT | NONE |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
mnF3111RLLN | RLLN | MATH_NUMERIC | OPT | NONE |
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
| ||||
mnF3111OPSQ | OPSQ | MATH_NUMERIC | OPT | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
mnF3111BSEQ | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
mnF3111RSCP | RSCP | MATH_NUMERIC | OPT | NONE |
A number that indicates what percent of the ingredients should be issued separately to co-products and by-products. | ||||
mnF3111SCRP | SCRP | MATH_NUMERIC | OPT | NONE |
The percentage of unusable component material that is created during the manufacture of a particular parent item.
During DRP/MPS/MRP
| ||||
mnF3111REWP | REWP | MATH_NUMERIC | OPT | NONE |
mnF3111ASIP | ASIP | MATH_NUMERIC | OPT | NONE |
mnF3111CPYP | CPYP | MATH_NUMERIC | OPT | NONE |
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the
| ||||
mnF3111STPP | STPP | MATH_NUMERIC | OPT | NONE |
A value that the system uses to increase or decrease the amount of materials to account for loss within the operation. The system updates
| ||||
mnF3111LOVD | LOVD | MATH_NUMERIC | OPT | NONE |
The number of days that a part is needed before or after the start date of a manufacturing work order. The system adds the leadtime offset
| ||||
mnF3111CPIT | CPIT | MATH_NUMERIC | OPT | NONE |
The short identifier for the component item number. | ||||
szF3111CPIL | CPIL | char | OPT | NONE |
The system provides three separate item numbers.
They are:
1. Item Number (short) - An eight digit, computer assigned, completely
| ||||
szF3111CPIA | CPIA | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross reference capability to alternate item numbers.
These item
| ||||
szF3111CMCU | CMCU | char | OPT | NONE |
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
| ||||
szF3111DSC1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szF3111DSC2 | DSC2 | char | OPT | NONE |
A second, 30-character description, remark, or explanation. | ||||
szF3111LOCN | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szF3111LOTN | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnF3111AN8 | 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
| ||||
szF3111LNTY | LNTY | char | OPT | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
szF3111SERN | SERN | char | OPT | NONE |
A 30 character field to be used to additionally identify a specific lot of inventory; this may be the manufacturer's production run number or
| ||||
jdF3111TRDJ | 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. | ||||
jdF3111DRQJ | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnF3111UORG | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnF3111TRQT | TRQT | MATH_NUMERIC | OPT | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnF3111SOCN | 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
| ||||
mnF3111SOBK | 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
| ||||
mnF3111CTS1 | CTS1 | MATH_NUMERIC | OPT | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnF3111QNTA | QNTA | MATH_NUMERIC | OPT | NONE |
szF3111UM | UM | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
mnF3111EA | EA | MATH_NUMERIC | OPT | NONE |
A number that identifies the estimated unit cost of the part used on the work order. | ||||
cF3111RTG | RTG | char | OPT | NONE |
A code to inhibit printing or the routing instructions on the work order. | ||||
szF3111MTST | MTST | char | OPT | NONE |
A user defined code (31/MS) that identifies the current status of a particular component on the work order. | ||||
szF3111DCT | 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
| ||||
szF3111SHNO | SHNO | char | OPT | NONE |
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use
| ||||
szF3111MCU | 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
| ||||
szF3111OMCU | OMCU | char | OPT | NONE |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
szF3111OBJ | OBJ | char | OPT | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szF3111SUB | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szF3111CMRV | CMRV | char | OPT | NONE |
A code that indicates the current revision level of a component on the bill of material. It is usually used with an engineering change notice
| ||||
jdF3111STRX | STRX | JDEDATE | OPT | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
szF3111PARS | PARS | char | OPT | NONE |
A number that identifies the parent work order. You can use this number to do the following:
o Enter default values for new work orders,
| ||||
cF3111COMM | COMM | char | OPT | NONE |
A value that indicates whether you specified from which Location and Lot a particular item was to come. If you specified a storage area, the
| ||||
szF3111URCD | URCD | char | OPT | NONE |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
jdF3111URDT | URDT | JDEDATE | OPT | NONE |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnF3111URAT | URAT | MATH_NUMERIC | OPT | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szF3111URRF | URRF | char | OPT | NONE |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
mnF3111URAB | URAB | MATH_NUMERIC | OPT | NONE |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szF3111USER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szF3111PID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szF3111JOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdF3111UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnF3111TDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnF3111UKID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnF3111VEND | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
mnF3111CTS4 | CTS4 | MATH_NUMERIC | OPT | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnF3111CTS7 | CTS7 | MATH_NUMERIC | OPT | NONE |
The amount of unaccounted scrap dollars associated with a specific component for a work order. Manufacturing accounting uses this
| ||||
mnF3111CTS8 | CTS8 | MATH_NUMERIC | OPT | NONE |
The number of units of unaccounted scrap that the system associates with a specific component for a work order. Manufacturing
| ||||
jdF3111GLD | GLD | JDEDATE | OPT | NONE |
Determines the date used for the journal entry. If you leave this field blank,the system uses the current period date. If the Current Period
| ||||
cF3111SBLF | SBLF | char | OPT | NONE |
Reserved for future use. | ||||
cF3111AING | AING | char | OPT | NONE |
A code that indicates whether an item is an active component of a parent item. When the item is an active component, the system can
| ||||
mnF3111SSTQ | SSTQ | MATH_NUMERIC | OPT | NONE |
The number of units, expressed in the secondary unit of measure, that the system has recorded as completed or issued. This value can
| ||||
szF3111UOM2 | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
cF3111APSC | APSC | char | OPT | NONE |
A code that specifies that the entity is constraint-based and can be planned by SCP. | ||||
mnF3111PSN | 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
| ||||
jdF3111DLEJ | DLEJ | JDEDATE | OPT | NONE |
The date on which a lot becomes available. The system uses this date for availability and commitment processing to indicate that the lot is
| ||||
szF3111COST | COST | char | OPT | NONE |
A code that designates each element of cost for an item. Examples of the cost object types are:
o A1 Purchased raw material
o B1
| ||||
cF3111CHPP | CHPP | char | OPT | NONE |
An option that indicates whether a critical hold has been placed on a part that is on the work order parts list. | ||||
mnF3111CPNB | CPNB | MATH_NUMERIC | OPT | NONE |
A number that specifies how the system displays the sequence of components on a single-level bill of material. This number initially
| ||||
szF3111BSEQAN | BSEQAN | char | OPT | NONE |
A sequence number on a secondary bill of material that indicates the drawing bubble number or the location identifier for an engineering
| ||||
mnF31171ESUNC | ESUNC | MATH_NUMERIC | OPT | NONE |
Estimated unit cost associated with a transaction. | ||||
mnF31171ESUNB | ESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit cost for billing. | ||||
mnF31171ESUNP | ESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit cost of the payable. | ||||
mnF31171EPAAP | EPAAP | MATH_NUMERIC | OPT | NONE |
This is the estimated payment amount used in service billing. | ||||
mnF31171AMTO | AMTO | MATH_NUMERIC | OPT | NONE |
The estimated monetary amount that is budgeted for this work order. | ||||
mnF31171EBILL | EBILL | MATH_NUMERIC | OPT | NONE |
mnF31171ACUNC | ACUNC | MATH_NUMERIC | OPT | NONE |
The actual unit cost associated with a transaction. | ||||
mnF31171ACUNB | ACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit billable amount. | ||||
mnF31171ACUNP | ACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit payable amount. | ||||
mnF31171AMTA | AMTA | MATH_NUMERIC | OPT | NONE |
The actual dollars accumulated for the work order. | ||||
mnF31171TOTB | TOTB | MATH_NUMERIC | OPT | NONE |
The total amount billed through this application number. | ||||
mnF31171PAAP | PAAP | MATH_NUMERIC | OPT | NONE |
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount
| ||||
mnF31171CLAMT | CLAMT | MATH_NUMERIC | OPT | NONE |
The amount requested for providing a service. | ||||
mnF31171VEND | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
cF31171PAYAB | PAYAB | char | OPT | NONE |
This field specifies whether a general ledger account should be paid. Valid values are:
Y The account should be paid.
N The account
| ||||
cF31171BILL | BILL | char | OPT | NONE |
Specifies whether a general ledger account should be billed. Valid codes are:
Y Yes, the account should be billed.
N No, it should not be
| ||||
jdF31171DTPAY | DTPAY | JDEDATE | OPT | NONE |
The date a service provider was paid for a service. | ||||
jdF31171DTBIL | DTBIL | JDEDATE | OPT | NONE |
In service billing, the date a customer was billed for a service. | ||||
szF31171COST | COST | char | OPT | NONE |
A code that designates each element of cost for an item. Examples of the cost object types are:
o A1 Purchased raw material
o B1
| ||||
szF31171GLCCV | GLCCV | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the covered
| ||||
szF31171GLCNC | GLCNC | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the
| ||||
szF31171ENTCK | ENTCK | char | OPT | NONE |
A user defined code (17/ER) to indicate the results of an entitlement check.
Valid values are:
0 Not entitled
1 Transaction entitled
2
| ||||
szF31171VRO2 | VR02 | char | OPT | NONE |
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or
| ||||
szF31171PID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szF31171JOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdF31171UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnF31171TDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
szF31171ASN4 | ASN4 | char | OPT | NONE |
A user defined code (40/AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szF31171ASN2 | ASN2 | char | OPT | NONE |
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
mnF31171PCOVR | PCOVR | MATH_NUMERIC | OPT | NONE |
The percentage covered under warranty or contract. This is used to calculate the amount to bill or the amount to cost for the line item being
| ||||
cF31171MTHPR | MTHPR | char | OPT | NONE |
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values
| ||||
mnF31171SAID | SAID | MATH_NUMERIC | OPT | NONE |
A unique numeric identifier for a physical location at which utility service is delivered. A service address often corresponds to a parcel of
| ||||
szF31171PRODF | PRODF | char | OPT | NONE |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. | ||||
szF31171PRODM | PRODM | char | OPT | NONE |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
szF31171COVGR | COVGR | char | OPT | NONE |
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage
| ||||
cF31171PMTHP | PMTHP | char | OPT | NONE |
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values
| ||||
cF31171PYPRT | PYPRT | char | OPT | NONE |
A code to indicate if the service provider should be paid for parts used during a repair.
Valid values are:
Y or 1 - Pay the service provider
| ||||
szF31171CRDC | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
szF31171BCRCD | BCRCD | char | OPT | NONE |
The currency for the billable amounts of a service order. | ||||
mnF31171BCRR | BCRR | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for
| ||||
cF31171BCRRM | BCRRM | char | OPT | NONE |
A code that specifies whether the system uses the foreign currency (currency of the customer) or the domestic currency for billable
| ||||
mnF31171FESUNB | FESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is billable in the currency of the customer. | ||||
mnF31171FEBILL | FEBILL | MATH_NUMERIC | OPT | NONE |
The estimated billable amount in the currency of the customer. | ||||
mnF31171FACUNB | FACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is billable in the currency of the customer. | ||||
mnF31171FTOTB | FTOTB | MATH_NUMERIC | OPT | NONE |
The actual amount that is billable in the currency of the customer. | ||||
szF31171PCRCD | PCRCD | char | OPT | NONE |
A code that indicates the currency of the payable amounts on a work order or claim. | ||||
mnF31171PCRR | PCRR | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for
| ||||
cF31171PCRRM | PCRRM | char | OPT | NONE |
A code that specifies whether payable amounts are in the foreign currency (currency of the service provider) or in the domestic currency.
| ||||
mnF31171FESUNP | FESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is payable in the currency of the service provider. | ||||
mnF31171FEPAAP | FPAAP | MATH_NUMERIC | OPT | NONE |
The actual payable amount that is recorded in the foreign currency of the service provider. | ||||
mnF31171FACUNP | FACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is payable in the currency of the service provider. | ||||
mnF31171FPAAP | FPAAP | MATH_NUMERIC | OPT | NONE |
The actual payable amount that is recorded in the foreign currency of the service provider. | ||||
szF31171FAILCD | FAILCD | char | OPT | NONE |
A user defined code (17/FC) that indicates the type of defect. | ||||
cF31171RETPOL | RETPOL | char | OPT | NONE |
A user defined code (17/RT) that specifies whether to return the part with the claim. | ||||
jdF31171DTSUB | DTSUB | JDEDATE | OPT | NONE |
The date that a supplier recovery claim was submitted to the interoperability tables for Warranty Claim/Supplier Recovery
| ||||
mnF31171TMSUB | TMSUB | MATH_NUMERIC | OPT | NONE |
The time that a supplier recovery claim was submitted to the interoperability tables. | ||||
mnF31171CSLPRT | CSLPRT | MATH_NUMERIC | OPT | NONE |
The item number that indicates which part failed and caused the equipment failure. | ||||
szF31171VMRS33 | VMRS33 | char | OPT | NONE |
A user defined code (17/C8) that indicates the location of a specific part, such as the fuse to the air conditioning compressor clutch, within a
| ||||
mnF31171SRVEND | SRVEND | MATH_NUMERIC | OPT | NONE |
The address book number of the vendor to be used for supplier recovery. | ||||
szF31171RLOT | RLOT | char | OPT | NONE |
The supplier's lot number for the item. | ||||
szF31171MCUCSL | MCUCSL | char | OPT | NONE |
The business unit that is related to the causal portion of the claim. | ||||
cF31171TAX1 | 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
| ||||
mnF31171UKIDP | UKIDP | MATH_NUMERIC | OPT | NONE |
szF31171VMRS31 | VMRS31 | char | OPT | NONE |
A user defined code (17/C6) that indicates a specific system, such as the air conditioning system, that is associated with a piece of
| ||||
szF31171VMRS32 | VMRS32 | char | OPT | NONE |
A user defined code (17/C7) that indicates the location of a specific assembly, such as the air conditioning compressor, within a piece of
| ||||
cF3111POC | POC | char | OPT | NONE |
A code that indicates whether an item is received at the time of inventory issues or if the system uses the Move and Disposition program.
| ||||
cEventNotificationActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change |
None |
None |