D1702690C - CRM Integration Parts List Cache Processing
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
cErrorCode | 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
| ||||
szErrorMessage | 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
| ||||
cSuppressErrorMessage | 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
| ||||
mnUniqueKeyID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
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,
| ||||
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
| ||||
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
| ||||
szCompanyKeyRelated | RKCO | char | OPT | NONE |
The key company that is associated with the document number of the related order. | ||||
szRelatedPoSoNumber | 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
| ||||
mnRelatedPoSoLineNo | 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
| ||||
mnItemNumber | CPIT | MATH_NUMERIC | OPT | NONE |
The short identifier for the component item number. | ||||
sz2ndItemNumber | CPIL | char | OPT | NONE |
The system provides three separate item numbers.
They are:
1. Item Number (short) - An eight digit, computer assigned, completely
| ||||
szThirdItemNumber | CPIA | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross reference capability to alternate item numbers.
These item
| ||||
szBranch | 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
| ||||
szDescription | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDescription2 | 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. | ||||
mnCustomer | 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
| ||||
jdOrderDate | 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. | ||||
mnEstimatedQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnActualQuantity | TRQT | MATH_NUMERIC | OPT | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnQuantityBackOrdered | 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
| ||||
mnAllocatedQuantity | QNTA | MATH_NUMERIC | OPT | NONE |
cCommittedHS | 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
| ||||
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. | ||||
szMaterialStatus | MTST | char | OPT | NONE |
A user defined code (31/MS) that identifies the current status of a particular component on the work order. | ||||
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
| ||||
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
| ||||
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
| ||||
szParentWoNumber | 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,
| ||||
mnEstUnitBillAmnt | ESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit cost for billing. | ||||
mnEstBillAmount | EBILL | MATH_NUMERIC | OPT | NONE |
mnActUnitBillAmnt | ACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit billable amount. | ||||
mnActBillAmnt | TOTB | MATH_NUMERIC | OPT | NONE |
The total amount billed through this application number. | ||||
mnPrimaryLastVendor | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
cPayableYN | 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
| ||||
cBillableYN | 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
| ||||
jdDatePaid | DTPAY | JDEDATE | OPT | NONE |
The date a service provider was paid for a service. | ||||
jdDateBilled | DTBIL | JDEDATE | OPT | NONE |
In service billing, the date a customer was billed for a service. | ||||
szCostType | 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
| ||||
szGLCategoryCovered | 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
| ||||
szGLCategoryNonCovered | 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
| ||||
szEntitlementCheck | 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
| ||||
szAdjSchedService | 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
| ||||
szAdjSchedFour | 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
| ||||
mnPercentCovered | 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
| ||||
cMethodofPricing | 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
| ||||
mnSiteNumber | 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
| ||||
szProductFamily | 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. | ||||
szProductModel | 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. | ||||
szCoverageGroup | COVGR | char | OPT | NONE |
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage
| ||||
cPayPricingMethod | 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
| ||||
cPayServProviderForParts | 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
| ||||
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szProgramId | 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
| ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. | ||||
idCursorPointer | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
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. | ||||
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. | ||||
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. | ||||
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. | ||||
mnUnacctDirectLaborHrs | CTS1 | MATH_NUMERIC | OPT | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
szMessageNo | 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
| ||||
jdDateCompletion | STRX | JDEDATE | OPT | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
mnBeginningHhMmSs | 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. | ||||
szSerialNumberLot | 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
| ||||
mnEstUnitCost | ESUNC | MATH_NUMERIC | OPT | NONE |
Estimated unit cost associated with a transaction. | ||||
mnActUnitCost | ACUNC | MATH_NUMERIC | OPT | NONE |
The actual unit cost associated with a transaction. | ||||
mnAmountOriginalDollars | AMTO | MATH_NUMERIC | OPT | NONE |
The estimated monetary amount that is budgeted for this work order. | ||||
mnAmountActual | AMTA | MATH_NUMERIC | OPT | NONE |
The actual dollars accumulated for the work order. | ||||
mnClaimAmount | CLAMT | MATH_NUMERIC | OPT | NONE |
The amount requested for providing a service. | ||||
szReference | 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
| ||||
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
| ||||
mnSupplier | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
cDBActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
szBaseCurrency | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szBillableCurrency | BCRCD | char | OPT | NONE |
The currency for the billable amounts of a service order. | ||||
mnBillableExchangeRate | 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
| ||||
cBillableCurrencyMode | 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
| ||||
szPayableCurrency | PCRCD | char | OPT | NONE |
A code that indicates the currency of the payable amounts on a work order or claim. | ||||
mnPayableExchangeRate | 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
| ||||
cPayableCurrencyMode | 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.
| ||||
mnUniqueKeyPricing | UKIDP | MATH_NUMERIC | OPT | NONE |
mnForeignEstimatedBillableUnit | FESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is billable in the currency of the customer. | ||||
mnForeignEstimatedBillableAmt | FEBILL | MATH_NUMERIC | OPT | NONE |
The estimated billable amount in the currency of the customer. | ||||
mnForeignActualBillableUnit | FACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is billable in the currency of the customer. | ||||
mnForeignActualBillableAmt | FTOTB | MATH_NUMERIC | OPT | NONE |
The actual amount that is billable in the currency of the customer. | ||||
szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnLineNumber | 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
| ||||
cPOCommitmentProcessing | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szHeaderBranch | 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
| ||||
cHeaderWoPickListPrinted | SHTY | char | OPT | NONE |
A code to designate whether or not the Work Order Pick List has been printed for a Work Order. If a 1 is in this code, the Work Order Pick
| ||||
cF3009AllocationsControl | FLD1 | char | OPT | NONE |
An option that determines how the system commits inventory to a work order, and specifies the inventory location to which commitments are
| ||||
cF3009HardSoftCommit | FLD2 | char | OPT | NONE |
An option that determines how the Shop Floor Management system commits inventory. The options are as follows:
o Hard commitment at
| ||||
szOrderSuffix_SFXO | 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
| ||||
cCoproductsByproducts_COBY | COBY | char | OPT | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
cComponentType_COTY | 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
| ||||
mnComponentNumber_CPNT | 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
| ||||
mnSequenceNoOperations_OPSQ | 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
| ||||
mnBubbleSequence_BSEQ | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
mnResourcePercent_RSCP | 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 | 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 | REWP | MATH_NUMERIC | OPT | NONE |
mnAsIsPercent_ASIP | ASIP | MATH_NUMERIC | OPT | NONE |
mnPercentCumulativePla_CPYP | 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
| ||||
mnStepScrapPercent_STPP | 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 | 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
| ||||
mnUnitsQuantityCanceled_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
| ||||
mnTimeOfDay_TDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnUnacctDirectLaborAmt_CTS4 | CTS4 | MATH_NUMERIC | OPT | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnUnacctScrapAmt_CTS7 | 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 | 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
| ||||
mnSecondaryIssued_Compl_SSTQ | 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
| ||||
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
| ||||
mnEstUnitPay_ESUNP | ESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit cost of the payable. | ||||
mnEstPaymntAmount_EPAAP | EPAAP | MATH_NUMERIC | OPT | NONE |
This is the estimated payment amount used in service billing. | ||||
mnActUnitPayable_ACUNP | ACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit payable amount. | ||||
mnPaymntAmount_PAAP | 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
| ||||
mnForeignEstimaPayableU_FESUNP | FESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is payable in the currency of the service provider. | ||||
mnForeignEstimdPayableA_FEPAAP | FEPAAP | MATH_NUMERIC | OPT | NONE |
The estimated payable amount in the currency of the service provider. | ||||
mnForeignActualPayeUnit_FACUNP | FACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is payable in the currency of the service provider. | ||||
mnForeignActualPayleAmou_FPAAP | FPAAP | MATH_NUMERIC | OPT | NONE |
The actual payable amount that is recorded in the foreign currency of the service provider. | ||||
mnTimeSubmitted_TMSUB | TMSUB | MATH_NUMERIC | OPT | NONE |
The time that a supplier recovery claim was submitted to the interoperability tables. | ||||
mnCausalPart_CSLPRT | CSLPRT | MATH_NUMERIC | OPT | NONE |
The item number that indicates which part failed and caused the equipment failure. | ||||
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
| ||||
cRouteSheetN_RTG | RTG | char | OPT | NONE |
A code to inhibit printing or the routing instructions on the work order. | ||||
szPurchasingCostCenter_OMCU | 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
| ||||
szComponentRevisionLevel_CMRV | 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
| ||||
szCompCode_Grp_Sys_VMRS31 | 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
| ||||
szCompCode_Assembly_VMRS32 | 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
| ||||
cTaxableYN_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
| ||||
szCostCenterCsl_MCUCSL | MCUCSL | char | OPT | NONE |
The business unit that is related to the causal portion of the claim. | ||||
szVendorLotNumber_RLOT | RLOT | char | OPT | NONE |
The supplier's lot number for the item. | ||||
szCompCode_Part_VMRS33 | 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
| ||||
cReturnPolicy_RETPOL | RETPOL | char | OPT | NONE |
A user defined code (17/RT) that specifies whether to return the part with the claim. | ||||
szDefectCode_FAILCD | FAILCD | char | OPT | NONE |
A user defined code (17/FC) that indicates the type of defect. |
None |
None |