D3101600 - Cache,Parts List
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
nNumberOfKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
cProcessMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cCacheCodeError | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessages | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessagID | 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
| ||||
cReturnCursorFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnOrderNumber | 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,
| ||||
nCacheRowNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
cChangedFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
szOrderSuffix | 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
| ||||
szTypeBill | 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.
| ||||
cFixedOrVariableQty | 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
| ||||
cIssueTypeCode | 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
| ||||
cCoproductsByproducts | COBY | char | OPT | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
cComponentType | 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
| ||||
mnFromPotency | 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
| ||||
mnThruPotency | 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
| ||||
szFromGrade | 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
| ||||
szThruGrade | 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
| ||||
szRelatedCompany | RKCO | char | OPT | NONE |
The key company that is associated with the document number of the related order. | ||||
szRelatedOrderNumber | 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
| ||||
szRelatedOrderType | 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
| ||||
mnRelatedOrderLineNumber | 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
| ||||
mnSequenceNoOperations | 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
| ||||
mnPreviousOperationSequence | 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
| ||||
mnResourcePercent | RSCP | MATH_NUMERIC | OPT | NONE |
A number that indicates what percent of the ingredients should be issued separately to co-products and by-products. | ||||
mnPercentOfScrap | 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
| ||||
mnReworkPercent | REWP | MATH_NUMERIC | OPT | NONE |
mnAsIsPercent | ASIP | MATH_NUMERIC | OPT | NONE |
mnPercentCumulativePlanned | 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
| ||||
mnOperationScrapPercent | 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
| ||||
mnLeadtimeOffsetDays | 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
| ||||
mnIdentifierShortItem | 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
| ||||
szIdentifier2ndItem | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szIdentifier3rdItem | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szComponentBranchPlant | 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
| ||||
szItemDescription1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szItemDescription2 | DSC2 | char | OPT | NONE |
A second, 30-character description, remark, or explanation. | ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
mnAddressNumber | 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
| ||||
szLineType | 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
| ||||
szSerialNumber | SRL1 | char | OPT | NONE |
The first of two serial numbers which you can relate to a single item of inventory. | ||||
jdTransactionDate | 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. | ||||
jdRequestedDate | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnBeginTime | PBTM | MATH_NUMERIC | OPT | NONE |
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing. | ||||
mnQtyOrdered | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnQtyIssued | TRQT | MATH_NUMERIC | OPT | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnQtyScrapped | 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
| ||||
mnQtyBackOrdered | 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
| ||||
mnUnacctDirectLaborHrs | CTS1 | MATH_NUMERIC | OPT | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnQtyAtOperation | QNTA | MATH_NUMERIC | OPT | NONE |
szUnitOfMeasure | 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,
| ||||
mnEstimatedAmount | EA | MATH_NUMERIC | OPT | NONE |
A number that identifies the estimated unit cost of the part used on the work order. | ||||
cRouteSheet | RTG | char | OPT | NONE |
A code to inhibit printing or the routing instructions on the work order. | ||||
szMaterialStatusCode | MTST | char | OPT | NONE |
A user defined code (31/MS) that identifies the current status of a particular component on the work order. | ||||
szDocumentType | 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
| ||||
szMessageNumber | 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
| ||||
szBusinessUnit | 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
| ||||
szProjectBusinessUnit | 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
| ||||
szObjectAccount | 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
| ||||
szSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szComponentRevisionLevel | 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
| ||||
jdCompletionDate | STRX | JDEDATE | OPT | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
szParentOrderNumber | 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,
| ||||
cCommitted | 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
| ||||
szUserReservedCode | 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. | ||||
jdUserReservedDate | 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. | ||||
mnUserReservedAmount | 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. | ||||
szUserReservedReference | 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. | ||||
mnUserReservedNumber | 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. | ||||
mnUniqueKeyID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
szPrimaryItemNumber | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
szUserInputItemNumber | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
cInventoryInterfaceFlag | IVI | char | OPT | NONE |
A code that identifies the type of interface to the Inventory Management system. Valid values are:
Y The dollar or unit value of any activity
| ||||
cTextLineYN | TXYN | char | OPT | NONE |
A code that indicates whether the information with this order line type contains only text information.
In World software, valid values are:
Y
| ||||
szF4101Description | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szF4101PrimaryUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szF4101ComponentUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szStdUOMConversion | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
cStockingType | STKT | char | OPT | NONE |
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
| ||||
cF4102SourceLayerCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cF4102PotencyControl | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cF4102GradeControl | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cF4102IssueTypeCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnF4102StandardPotency | STDP | MATH_NUMERIC | OPT | NONE |
The percentage of active ingredients normally found in an item. | ||||
szLotGrade | LOTG | char | OPT | NONE |
A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following:
A1 Premium
| ||||
mnLotPotency | LOTP | MATH_NUMERIC | OPT | NONE |
A code that indicates the potency of the lot expressed as a percentage of active or useful material (for example, the percentage of alcohol
| ||||
szMemoLot1 | LOT1 | char | OPT | NONE |
A higher classification or grouping of serial number or lot processed items,maintained within the Lot Master (F4108). | ||||
szMemoLot2 | LOT2 | char | OPT | NONE |
A higher classification or grouping of memo lot 1 maintained within the lot master (F4108). | ||||
cF4101Retrieved | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cF4102Retrieved | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnOrigComponentShortItem | 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
| ||||
cF41021PBin | PBIN | char | OPT | NONE |
A code that indicates whether this is the primary or secondary location for this item within this stocking location. Valid values are:
P Primary
| ||||
cPartialsAllowedYN | PRTA | char | OPT | NONE |
When you specify component and substitute items on the bill of material, this field indicates whether the total quantity is required to be
| ||||
mnF3002CurrentLevelQty | CRQT | MATH_NUMERIC | OPT | NONE |
The current quantity for the valuation layer as defined by the Stock Valuation Method. | ||||
mnF3002OperationQty | QNTY | MATH_NUMERIC | OPT | NONE |
The number of units that the system applies to the transaction. | ||||
mnF3002ScrapQty | QNTY | MATH_NUMERIC | OPT | NONE |
The number of units that the system applies to the transaction. | ||||
mnQtyAvailable | QNTY | MATH_NUMERIC | OPT | NONE |
The number of units that the system applies to the transaction. | ||||
mnOrigQtyOrdered | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnOrigQtyIssued | TRQT | MATH_NUMERIC | OPT | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
szOrigLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szOrigLot | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szOrigCompBranchPlant | 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
| ||||
cCommitmentMethod | CMGL | char | OPT | NONE |
A code that indicates the method that the system uses to commit lot items from inventory. Valid codes are:
1 The normal commitment
| ||||
cCostLevel | CLEV | char | OPT | NONE |
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
| ||||
szOrigCompUOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnCompToPrimaryConvFactor | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
szF4211WORelatedNumber | 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
| ||||
mnOrigEstimatedAmount | EA | MATH_NUMERIC | OPT | NONE |
A number that identifies the estimated unit cost of the part used on the work order. | ||||
mnVendor | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
cPayOnConsumption | 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.
| ||||
cProcessWarehouse | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szWMSToLocation | TLOC | char | OPT | NONE |
The storage location to which goods will be moved. | ||||
szWMSFromLocation | FLOC | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szWMSFromLotNumber | FLOT | char | OPT | NONE |
The lot number of the goods being putaway, picked or replenished. | ||||
cF41001WarehouseControl | WCTL | char | OPT | NONE |
A code that determines whether the system creates warehouse transactions for the branch/plant. | ||||
cF4101BulkPackedFlag | BPFG | char | OPT | NONE |
A code that indicates if the item is a bulk liquid product. If it is a bulk product, you must perform temperature and density/gravity
| ||||
szUserOverrideLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szWMSToLotNumber | TLOT | char | OPT | NONE |
The lot number to which you are adding goods. In most cases, this will be the same as the From Lot number. | ||||
cLocationIsWorkCenter | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnActualParentItem | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szActualParentBranch | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
mnActualBatchQuantity | BQTY | MATH_NUMERIC | OPT | NONE |
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
| ||||
mnRequestedQtyWithShrink | RQTE1 | MATH_NUMERIC | OPT | NONE |
The number of parent items that you want to process. The system calculates lower level values in quantity per the number of parent items
| ||||
nCSMSCacheRowNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
mnUnacctDirectLaborAmt | CTS4 | MATH_NUMERIC | OPT | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnUnacctScrapAmt | CTS7 | MATH_NUMERIC | OPT | NONE |
The amount of unaccounted scrap dollars associated with a specific component for a work order. Manufacturing accounting uses this
| ||||
mnUnacctScrapUnits | 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
| ||||
mnComponentNumber | 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
| ||||
mnOrigComponentLineNumber | 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
| ||||
cActiveIngredientFlag | 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
| ||||
mnProjectNumber | PRJM | MATH_NUMERIC | OPT | NONE |
A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011). | ||||
cProjectSpecific | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnUnitCostReference | UNCS | MATH_NUMERIC | OPT | NONE |
| ||||
nDescendingCacheRowNumber | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
mnPickSlipNumber | 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
| ||||
mnOrigOperationSequence | 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
| ||||
cF4102APSConstraintsFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnConfigurationID | CFGID | MATH_NUMERIC | OPT | NONE |
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables. | ||||
mnConfigComponentID | CFGCID | MATH_NUMERIC | OPT | NONE |
A number that represents a component in a configuration. This number, which is generated by next numbers, always restarts at 1 and
|
B3101260 F3111 Parts List Master Business Function |
None |