Functional Description
Purpose
To perform all table I/O for the F3111.
Open F3111 Table
Retrieve Audit Information
Add, Change or Delete F3111 record depending on Action Code
'b7'b7'b7'b7
Setup Notes and Prerequisites
This is a Master File Master Business Function. It will process one record at a time. No cache is
used. Interoperability processing is included in the function.
A) When adding/updating/deleting multiple records:
nIndexNumber = 8
nNumberOfKeys = 1
cReturnHrequest = '1'
cProcessEdits = '1'
cProcessTagFile = '1'
szTypeTransaction = Interoperability Processing Option
idF3111HrequestID = Work idF3111HrequestID
idF3111TagHrequestID = Work idF3111TagHrequestID
szProgramID = Program ID
All table fields for update or add
B) When fetching multiple records by order number:
nIndexNumber = 1
nNumberOfKeys = 1
cReturnHrequest = '1'
cProcessEdits = '3'
cProcessTagFile = '1'
idF3111HrequestID = Work idF3111HrequestID
idF3111TagHrequestID = Work idF3111TagHrequestID
mnOrderNumber = F4801 Order Number
C) When fetching multiple records by unique key:
nIndexNumber = 8
nNumberOfKeys = 1
cReturnHrequest = '1'
cProcessEdits = '1'
cProcessTagFile = '1'
idF3111HrequestID = Work idF3111HrequestID
idF3111TagHrequestID = Work idF3111TagHrequestID
mnUniqueKeyID = F3111 Unique Key ID
D) When determining if a parts list (excluding Co/Bys) exists for a given Order Number:
nIndexNumber = 6
nNumberOfKeys = 2
cReturnHrequest = '0'
cProcessEdits = '1'
cProcessTagFile = '0'
cCOBY = ' '
mnOrderNumber = F4801 Order Number
E) When multiple processing is completed, close the tables:
cReturnHrequest = '0'
cProcessTagFile = '1'
idF3111HrequestID = Work idF3111HrequestID
Special Logic
If calling this function numerous times to add or change multiple records, set the return hrequest
parameter to '1' and return the F3111 Table Hrequest ID with each subsequent call. This will eliminate
the need to open and close the F3111 table for each call. NOTE: After all processing is completed,
call this business function with Action Code = '5' Close Table and Return Hrequest Flag = '0' to close
the table. If this is not completed, a memory leak will occur because of the open table.
All Tag File processing and parameters will be removed in B8.1
Technical Specification
Data Structure Desc I/OReq'd Notes
cActionCode I Y A/1 - Add C/2 - Change D/3 - Delete I/4 - Inquire 5 - Close
cProcessEdits I N For Action Code = Add, Update and Delete Modes
'0' - No Edits (Default)
'1' - All Edits
'2' - Partial Edits (No Data Dictionary)
For Action Code = Inquiry
'1' - Fetch Keyed (Default)
'2' - Fetch Matching Key
'3' - Select Records and Fetch 1st record
'4' - Fetch Next record
NOTE: Action Code = 2 or 4 require a previous call to this
function with Action Code = 1 or 3. Also, the pointer
must be returned with Action Code = 2 or 4
cSuppressErrorMessageI N 1 - Error Messages Suppressed
nNumberOfKeys I Y Number of keys to be used from the index.
Required only for Action Code = Inquiry, Update or Delete
NOTE: If this field is not set to 7 for Update and Delete
Modes,
action could be performed on multiple records.
nIndexNumber I Y Number of which Table Index to be used.
Required only for Action Code = Inquiry
Add, Update, Delete Modes use the Index 1 only
szErrorMessageID O N
szProgramID I N
cReturnHrequest I N '1' - Returns F3111 Hrequest Default - Does Not Return Hrequest
idF3111Hrequest I/O N F3111 pointer
szTransactionType I N Required for Interoperability
mnOrderNumber I/O Y F3111 Data Field
szOrderType I/O N " " "
szOrderSuffix I/O N " " "
szTypeBill I/O N " " "
cFixedOrVariableQtyI/O N " " "
cIssueTypeCode I/O N " " "
cCOBY I/O N " " "
mnComponentNumber I/O N " " "
mnFromPotency I/O N " " "
mnThruPotency I/O N " " "
szFromGrade I/O N " " "
szThruGrade I/O N " " "
szCompanyKeyRelatedI/O N " " "
szRelatedPoSoNumberI/O N " " "
szRelatedOrderTypeI/O N " " "
mnRelatedPoSoLineNoI/O N " " "
mnSequenceNoOperationsI/O N " " "
mnBubbleSequence I/O N " " "
mnResourcePercent I/O N " " "
mnPercentOfScrap I/O N " " "
mnReworkPercent I/O N " " "
mnAsIsPercent I/O N " " "
mnPercentCumulativePlaI/O N " " "
mnStepScrapPercentI/O N " " "
mnLeadtimeOffsetDaysI/O N " " "
mnComponentItemNoShortI/O N " " "
szComponentItemNo2ndI/O N " " "
Component 3rd ItemI/O N " " "
szComponentThirdNumberI/O N " " "
szDescriptionLine1I/O N " " "
szDescriptionLine2I/O N " " "
szLocation I/O N " " "
szLot I/O N " " "
mnAddressNumber I/O N " " "
szLineType I/O N " " "
szSerialNumberLot I/O N " " "
jdDateTransactionJulianI/O N " " "
jdDateRequestedJulianI/O N " " "
mnBeginningHhMmSs I/O N " " "
mnUnitsTransactionQtyI/O N " " " (Order Qty)
mnQuantityTransactionI/O N " " " (Qty Issued)
mnUnitsQuantityCanceledI/O N " " " (Qty Canceled)
mnUnitsQuanBackorHeldI/O N " " " (Qty Backordered)
mnUnacctDirectLaborHrsI/O N " " "
mnUnitsQuantityAllocatI/O N " " " (Qty At Operation)
szUnitOfMeasure I/O N " " "
mnEstimatedAmount I/O N " " "
cRouteSheetN I/O N " " "
szMaterialStatusCodeWoI/O N " " "
szDocumentType I/O N " " "
szMessageNo I/O N " " "
szBusinessUnit I/O N " " "
Project Business UnitI/O N " " "
szObjectAccount I/O N " " "
szSubsidiary I/O N " " "
szComponentRevisionLevel I/O N " " "
jdDateCompletion I/O N " " "
szParentWoNumber I/O N " " "
cCommittedHS I/O N " " "
szUserReservedCodeI/O N " " "
jdUserReservedDateI/O N " " "
mnUserReservedAmountI/O N " " "
mnUserReservedNumberI/O N " " "
szUserId I/O N " " "
szWorkStationId I/O N " " "
jdDateUpdated I/O N " " "
mnTimeOfDay I/O N " " "
mnUniqueKeyID I/O N " " "
cPayOnConsumption I/O N " " "
mnVendor I/O N " " "
cComponentType I/O N " " "
szProjectBusinessUnitI/O N " " "
szUserReservedReferenceI/O N " " "
cProcessTagFile I N Set to 1 to include Tag Table processing
idF3111TagHrequestIDI/O N F3111T Pointer
cInteractiveBatchFlagI N FUTURE
szVersion I N FUTURE
idControlData I N Required for Interoperability
- pointer to the Z1 table.
If processing multiple records,
this pointer must be returned.
F3111 Process Master Data
If the input F3111 Hrequest does is not NULL
Retrieve the F3111 Pointer
If Retrieve Pointer is succesful and the F3111 Tag Hrequest is not Null
Retrieve the F3111 Tag Table Pointer
End If
Else
Open F3111 and F3111T Tables
End If
If the Table Pointer is not NULL
If the input Type Transaction is not blank
/* If interoperability is on, Work Order must be fetched */
If input Process Edits = FULL EDITS and the Action Code is Add/Update/Delete
Fetch the F4801 record
End If
If input Action Code = 'A' or '1'
Copy input F3111 parameters to F3111 data structure
Get Audit Information
Add record to F3111
If input Process Tag File = '1'
Add record to F3111T
End If
Else if input Action Code = 'C' or '2'
Update the F3111 record
If input Process Tag File = '1'
Update the F3111T record
End If
Else if input Action Code = 'D' or '3'
Delete record from the F3111T
End If
Else if input Action Code = 'I' or '4'
and number of keys used
If Process Edits = 2
Fetch Next Keyed based on input Index and Number of Keys
Else If Process Edits = 3
Select Records based on input Index and Number of Keys
Fetch Record
Else If Process Edits = 4
Fetch Next record
Else
Fetch Record based on input Index and Number of Keys
If successful
Copy F3111 fields to output parameters
Else
Set error
End If
Fetch record from F3111T using UKID
End If
Else if input Action Code = 5
Set input error - 0001 Action Invalid
End If
End If
If Action Code = Add/Update/Delete and input Type Transaction is not blank and processing was
successful
Call B3101430 to update the interoperability tables
End If
If input Return Hrequest Flag = '1'
Store F3111 Hrequest in output F3111 Hrequest ID parameter
If F3111 Tag Hrequest is not Null
Store F3111T Hrequest in output F3111Tag Hrequest ID parameter
End If
Else
If the tables were closed and input Type Transaction is not blank
Call B3101430 to close all interoperability tables
End If
DX3111 - F3111 Process Master Data
Data Structure Desc I/OReq'd Notes
cActionCode I Y A/1 Add C/2 Change D/3 Delete I/4 Inquire 5 - Close
cProcessEdits I N For Action Code = Add, Update and Delete Modes
'0' No Edits (Default)
'1' All Edits
'2' Partial Edits (No Data Dictionary)
For Action Code = Inquiry
'1' Fetch Keyed (Default)
'2' Fetch Matching Key
'3' Select Records and Fetch 1st record
'4' Fetch Next record
NOTE: Action Code = 2 or 4 require a previous call to this
function with Action Code = 1 or 3. Also, the pointer
must be returned with Action Code = 2 or 4
cSuppressErrorMessageI N 1 Error Messages Suppressed
nNumberOfKeys I Y Number of keys to be used from the index.
Required only for Action Code = Inquiry, Update or Delete
NOTE: If this field is not set to 7 for Update and Delete
Modes,
action could be performed on multiple records.
nIndexNumber I Y Number of which Table Index to be used.
Required only for Action Code = Inquiry
Add, Update, Delete Modes use the Index 1 only
szErrorMessageID O N
szProgramID I N
cReturnHrequest I N '1' Returns F3111 Hrequest Default Does Not Return Hrequest
idF3111Hrequest I/O N F3111 pointer
szTransactionType I N Required for Interoperability
mnOrderNumber I/O Y F3111 Data Field
szOrderType I/O N " " "
szOrderSuffix I/O N " " "
szTypeBill I/O N " " "
cFixedOrVariableQtyI/O N " " "
cIssueTypeCode I/O N " " "
cCOBY I/O N " " "
mnComponentNumber I/O N " " "
mnFromPotency I/O N " " "
mnThruPotency I/O N " " "
szFromGrade I/O N " " "
szThruGrade I/O N " " "
szCompanyKeyRelatedI/O N " " "
szRelatedPoSoNumberI/O N " " "
szRelatedOrderTypeI/O N " " "
mnRelatedPoSoLineNoI/O N " " "
mnSequenceNoOperationsI/O N " " "
mnBubbleSequence I/O N " " "
mnResourcePercent I/O N " " "
mnPercentOfScrap I/O N " " "
mnReworkPercent I/O N " " "
mnAsIsPercent I/O N " " "
mnPercentCumulativePlaI/O N " " "
mnStepScrapPercentI/O N " " "
mnLeadtimeOffsetDaysI/O N " " "
mnComponentItemNoShortI/O N " " "
szComponentItemNo2ndI/O N " " "
Component 3rd ItemI/O N " " "
szComponentThirdNumberI/O N " " "
szDescriptionLine1I/O N " " "
szDescriptionLine2I/O N " " "
szLocation I/O N " " "
szLot I/O N " " "
mnAddressNumber I/O N " " "
szLineType I/O N " " "
szSerialNumberLot I/O N " " "
jdDateTransactionJulianI/O N " " "
jdDateRequestedJulianI/O N " " "
mnBeginningHhMmSs I/O N " " "
mnUnitsTransactionQtyI/O N " " " (Order Qty)
mnQuantityTransactionI/O N " " " (Qty Issued)
mnUnitsQuantityCanceledI/O N " " " (Qty Canceled)
mnUnitsQuanBackorHeldI/O N " " " (Qty Backordered)
mnUnacctDirectLaborHrsI/O N " " "
mnUnitsQuantityAllocatI/O N " " " (Qty At Operation)
szUnitOfMeasure I/O N " " "
mnEstimatedAmount I/O N " " "
cRouteSheetN I/O N " " "
szMaterialStatusCodeWoI/O N " " "
szDocumentType I/O N " " "
szMessageNo I/O N " " "
szBusinessUnit I/O N " " "
Project Business UnitI/O N " " "
szObjectAccount I/O N " " "
szSubsidiary I/O N " " "
szComponentRevisionLevel I/O N " " "
jdDateCompletion I/O N " " "
szParentWoNumber I/O N " " "
cCommittedHS I/O N " " "
szUserReservedCodeI/O N " " "
jdUserReservedDateI/O N " " "
mnUserReservedAmountI/O N " " "
mnUserReservedNumberI/O N " " "
szUserId I/O N " " "
szWorkStationId I/O N " " "
jdDateUpdated I/O N " " "
mnTimeOfDay I/O N " " "
mnUniqueKeyID I/O N " " "
cPayOnConsumption I/O N " " "
mnVendor I/O N " " "
cComponentType I/O N " " "
szProjectBusinessUnitI/O N " " "
szUserReservedReferenceI/O N " " "
cProcessTagFile I N Set to 1 to include Tag Table processing
idF3111TagHrequestIDI/O N F3111T Pointer
cInteractiveBatchFlagI N FUTURE
szVersion I N FUTURE
idControlData I N Required for Interoperability
pointer to the Z1 table.
If processing multiple records,
this pointer must be returned.
^
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 | ||||
cProcessEdits | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
nNumberOfKeys | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
nIndexNumber | INT02 | integer | OPT | NONE |
Number of Days in the Past to Query for Quote Requests Received. | ||||
szErrorMessageID | 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
| ||||
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
| ||||
cReturnHrequest | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idF3111HrequestID | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
szTypeTransaction | TYTN | char | OPT | NONE |
The qualifier used to identify a specific type of transaction. | ||||
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
| ||||
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
| ||||
cCOBY | COBY | char | OPT | NONE |
A code that distinguishes standard components or ingredients from co-products,by-products, and intermediates. Co-products are
| ||||
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
| ||||
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
| ||||
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
| ||||
mnBubbleSequence | BSEQ | MATH_NUMERIC | OPT | NONE |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
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 |
mnPercentCumulativePla | 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 | 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
| ||||
mnComponentItemNoShort | CPIT | MATH_NUMERIC | OPT | NONE |
The short identifier for the component item number. | ||||
szComponentItemNo2nd | CPIL | char | OPT | NONE |
The system provides three separate item numbers.
They are:
1. Item Number (short) - An eight digit, computer assigned, completely
| ||||
szComponentThirdNumber | CPIA | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross reference capability to alternate item numbers.
These item
| ||||
szBranchComponent | 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
| ||||
szDescriptionLine1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDescriptionLine2 | 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
| ||||
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
| ||||
jdDateTransactionJulian | 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. | ||||
jdDateRequestedJulian | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnUnitsTransactionQty | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnQuantityTransaction | TRQT | MATH_NUMERIC | OPT | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnUnitsQuantityCanceled | 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
| ||||
mnUnitsQuanBackorHeld | 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. | ||||
mnUnitsQuantityAllocat | 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. | ||||
cRouteSheetN | RTG | char | OPT | NONE |
A code to inhibit printing or the routing instructions on the work order. | ||||
szMaterialStatusCodeWo | 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
| ||||
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
| ||||
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
| ||||
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
| ||||
jdDateCompletion | STRX | JDEDATE | OPT | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
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,
| ||||
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
| ||||
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. | ||||
szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
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. | ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnUniqueKeyID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
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.
| ||||
mnVendor | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
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
| ||||
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
| ||||
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. | ||||
cProcessTagFile | EV04 | char | OPT | NONE |
PeopleSoft event point processing flag 04. | ||||
idF3111TagHrequestID | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cInteractiveBatchFlag | EV05 | char | OPT | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
szVersion | VERS | char | OPT | NONE |
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
| ||||
idControlData | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
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
| ||||
mnSecondaryQtyCompleted | 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
| ||||
szSecondaryUnitOfMeasure | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
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
| ||||
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
| ||||
jdPlannedEffectiveDate | 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
| ||||
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
|
None |
None |