D3700310A - F3711 Table I/O
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | OPT | INPUT |
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 | INPUT |
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
| ||||
szCompanyKeyOrderNo | KCOO | char | OPT | INPUT |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szRelatedOrderType | RCTO | char | OPT | INPUT |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
szRelatedPoSoNumber | RORN | char | OPT | INPUT |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szCompanyKeyRelated | RKCO | char | OPT | INPUT |
The key company that is associated with the document number of the related order. | ||||
mnRelatedPoSoLineNo | RLLN | MATH_NUMERIC | OPT | INPUT |
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
| ||||
szBranchPlant | MCU | char | OPT | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szLocation | LOCN | char | OPT | INPUT |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | OPT | INPUT |
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 | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szTestID | QTST | char | OPT | INPUT |
The unique identification for a test to be performed on an item. For example: COL Color test DENS Density Test CL-2 Clarity Test | ||||
szBranchPlant2 | MCU2 | char | OPT | INPUT |
An accounting entity, such as a profit center, department, warehouse location, job, project, workcenter, and so on, required for management
| ||||
szSpecification | QSPC | char | OPT | INPUT |
The unique identification for a set of tests which need to be performed together. For example:
F-156 - FDA Specification 156
SP34 -
| ||||
szSpecBranchPlant | HMCU | char | OPT | INPUT |
The number of the business unit in which the employee generally resides. | ||||
mnTestSortSequenceNumber | TSRT | MATH_NUMERIC | OPT | INPUT |
A number used to determine the sort order of tests and specifications within preference profiles (item/test specifications). | ||||
szSpecificationRevisionLev | QREV | char | OPT | INPUT |
An alphanumeric character that represents the number of times a specification has changed. To avoid overlapping revisions, the system
| ||||
szTestValue | QVAL | char | OPT | INPUT |
The result of the performed test. | ||||
cPassFailPF | QPF | char | OPT | INPUT |
The value which identifies whether the test passed (P) or failed (F). | ||||
cTestoverrideflag | TOVR | char | OPT | INPUT |
The flag which designates whether a test has been overridden. Valid values are: 1 overridden 0 not overridden | ||||
szRecordUpdateByUserNa | MUSE | char | OPT | INPUT |
The IBM defined user identification. Used where a second User ID is required (in addition to USER), such as the Financial Reporting
| ||||
mnAddNoOriginator | ANO | MATH_NUMERIC | OPT | INPUT |
The address book number of the person who originated the change request. The system verifies this number against the Address Book. | ||||
jdDatetested | QDAT | JDEDATE | OPT | INPUT |
The date on which the test was performed. | ||||
mnTimetested | QTIM | MATH_NUMERIC | OPT | INPUT |
The time at which the test was performed. | ||||
szDispositionCodeQm | QDSP | char | OPT | INPUT |
mnSampleNumber9 | SNBR | MATH_NUMERIC | OPT | INPUT |
A number assigned to a group of tests within the same sample. | ||||
mnNumberofSamples | QSMP | MATH_NUMERIC | OPT | INPUT |
The number of samples to be taken for the test. | ||||
mnSamplePercentage | SMPC | MATH_NUMERIC | OPT | INPUT |
The percentage of an order quantity that determines the number of samples to create in Test Results Revisions. For example, if the sample
| ||||
mnAcceptQuantity | ACQT | MATH_NUMERIC | OPT | INPUT |
A flag that indicates the quantity of tests that must pass in order for the test sample to pass quality control. The system evaluates this value
| ||||
mnAcceptPercentage | ACPC | MATH_NUMERIC | OPT | INPUT |
A flag that indicates the percentage of tests that must pass in order for the sample to pass quality control. The system evaluates this value
| ||||
szSystemCode | SY | char | OPT | INPUT |
A user defined code (98/SY) that identifies a system. Valid values include:
01
Address Book
03B
Accounts Receivable
04
Accounts
| ||||
szUserDefinedCodes | RT | char | OPT | INPUT |
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type. | ||||
szAllowableMinimumValuefut | AMIN | char | OPT | INPUT |
The lowest value for a passing test result. | ||||
szAllowableMaximumValuefut | AMAX | char | OPT | INPUT |
The highest value for a passing test result. | ||||
szPreferableMinimumValue | PMIN | char | OPT | INPUT |
The lowest value for the preferred test result. This value must be greater than or equal to the allowed minimum value. Use the preferred
| ||||
szPreferableMaximumValue | PMAX | char | OPT | INPUT |
The highest value for the preferred test result. This value must be less than or equal to the allowed maximum value. Use the preferred
| ||||
jdEffectiveFromDate | EFFF | JDEDATE | OPT | INPUT |
A date that indicates one of the following:
o When a component part goes into effect on a bill of material
o When a routing step goes into
| ||||
jdEffectiveThruDate | EFFT | JDEDATE | OPT | INPUT |
A date that indicates one of the following:
o When a component part is no longer in effect on a bill of material
o When a routing step is no
| ||||
szTargetValue | QTRG | char | OPT | INPUT |
The preferable or target test result within the test results range. As the system does not test against a target value, this field is for your
| ||||
mnSampleSize | QSSZ | MATH_NUMERIC | OPT | INPUT |
The quantity of one sample to be taken for the test. As the system does not use this field, it is for your information only. | ||||
mnActualSampleSize | QASZ | MATH_NUMERIC | OPT | INPUT |
szQualityUnitofMeasure | QUM | char | OPT | INPUT |
Identifies the unit of measure for a sample you take to test. Examples of units of measure include barrels, gallons, hours, and cubic yards. | ||||
cPrintTest109 | PTTS | char | OPT | INPUT |
A code used to determine whether or not a test will be printed on the Certificate of Analysis. The valid values are:
0 The test will not be
| ||||
szTestCategoryCode1 | QTC1 | char | OPT | INPUT |
One of five reporting codes that can be assigned to each test defined. Use these codes to categorize tests into different groups. Category
| ||||
szTestCategoryCode2 | QTC2 | char | OPT | INPUT |
One of five reporting codes that can be assigned to each test defined. Use these codes to categorize tests into different groups. Category
| ||||
szTestCategoryCode3 | QTC3 | char | OPT | INPUT |
One of five reporting codes that can be assigned to each test defined. Use these codes to categorize tests into different groups. Category
| ||||
szTestCategoryCode4 | QTC4 | char | OPT | INPUT |
One of five reporting codes that can be assigned to each test defined. Use these codes to categorize tests into different groups. Category
| ||||
szTestCategoryCode5 | QTC5 | char | OPT | INPUT |
One of five reporting codes that can be assigned to each test defined. Use these codes to categorize tests into different groups. Category
| ||||
cTestType | TTTY | char | OPT | INPUT |
A value that specifies how the system processes tests as you enter test results. Valid values are:
R Required. Result values must be
| ||||
cManufacturingOperations | MFGR | char | OPT | INPUT |
A value that specifies whether the system displays the test on the Test Results Revisions form when you access the Test Results
| ||||
cManufacturingReceiptRouting | MRRR | char | OPT | INPUT |
A value that controls whether a test will display on the Test Results Revisions form when you access test results from the Routing
| ||||
cManufacturingCompletions | MFGC | char | OPT | INPUT |
A value that specifies whether the system displays the test on the Test Results Revisions form when you access the Test Results
| ||||
cPurchasingReceipts | PRCR | char | OPT | INPUT |
A value that controls whether a test will display on the Test Results Revisions form when you access test results from either Receipts by
| ||||
cPurchasingReceiptRouting | PRER | char | OPT | INPUT |
A value that controls whether the test will display on the Test Results Revisions form when you access test results from Routing Movement
| ||||
cShipConfirm | SHPR | char | OPT | INPUT |
A value that controls whether the test will display on the Test Results Revisions form when you access test results from the Ship
| ||||
cBulkLoadConfirm | BLKR | char | OPT | INPUT |
A value that controls whether the test will display on the Test Results Revisions form when you access test results from one of the following
| ||||
mnSequenceNoOperations | OPSQ | MATH_NUMERIC | OPT | INPUT |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
mnOperationSequence | OPRS | MATH_NUMERIC | OPT | INPUT |
The sequence in which the system performs the operations or steps of the route. | ||||
mnBubbleSequence | BSEQ | MATH_NUMERIC | OPT | INPUT |
A secondary bill of material sequence number that indicates the drawing bubble number. | ||||
szTypeRouting | TRT | char | OPT | INPUT |
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses.
For
| ||||
mnTripNumber | TRP | MATH_NUMERIC | OPT | INPUT |
The number assigned to a trip during direct assignment or trip building. The Trip Depot and the Trip Number fields identify the unique
| ||||
mnTripLegNumber | TRPL | MATH_NUMERIC | OPT | INPUT |
A specific leg of a trip. | ||||
mnLogicalCompartmentNumber | LCMP | MATH_NUMERIC | OPT | INPUT |
The compartment number in a connected vehicle.
A connected vehicle is a number of vehicles with compartments. The logical
| ||||
szVehicleId | VEHI | char | OPT | INPUT |
A unique identification number for a vehicle. This number serves as a primary identifier for a vehicle. | ||||
mnResultSortSequenceNumber | RSQQ | MATH_NUMERIC | OPT | INPUT |
A sequence number used within the Test Results Revisions programs to maintain the order of tests decided within Item/Test
| ||||
cTimingofTestFutureUse | TTST | char | OPT | INPUT |
cDefectWriteCode | DFCW | char | OPT | INPUT |
A code used to indicate that a failed test has been written to the Non-Conforming Material file. Valid values are:
1 The failed test has been
| ||||
szQualityApplicationCode | QPCD | char | OPT | INPUT |
A user defined code that identifies the calling application for Test Result Revisions, for example:
MC Manufacturing Completions
SO Ship
| ||||
mnQualityTextIDNumber | QTID | MATH_NUMERIC | OPT | INPUT |
A unique identifier associating a test result with it's generic text. | ||||
szTestMethod | TMHD | char | OPT | INPUT |
A description of how to run a quality test. The test method is useful to both your company's Quality Control department and your customers.
| ||||
szResultUnitofMeasure | RSUM | char | OPT | INPUT |
A user defined code (37/UM) that identifies the unit of measure for a test result. Examples of units of measure include barrels, boxes, cubic
| ||||
mnAssetItemNumber | NUMB | MATH_NUMERIC | OPT | INPUT |
An 8-digit number that uniquely identifies an asset. | ||||
szASTMReference | ASTM | char | OPT | INPUT |
Identifies a recommended testing procedure of the American Society of Testing Material. | ||||
szPropertyfutureuse | QPRP | char | OPT | INPUT |
The item attribute that is being tested. | ||||
szDefectSource | QDFC | char | OPT | INPUT |
szRootCauseQM | QRTC | char | OPT | INPUT |
szWorkCenter | MMCU | char | OPT | INPUT |
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
| ||||
cDataDisplayDecimals | CDEC | char | OPT | INPUT |
A value that designates the number of decimals in the currency, amount, or quantity fields the system displays. For example, U.S. Dollars
| ||||
mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | OPT | INPUT |
This field is a unique number used to identify a record in a file. | ||||
szDerivedCalculation | DERC | char | OPT | INPUT |
An algebraic formula that specifies the quantity, price, hours, or a value associated with a rule.
The following examples illustrate the syntax
| ||||
szUserReservedCode | URCD | char | OPT | INPUT |
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 | INPUT |
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 | INPUT |
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 | INPUT |
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 | INPUT |
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 | INPUT |
The code that identifies a user profile. | ||||
szProgramId | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. | ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | INPUT |
The computer clock in hours:minutes:seconds. | ||||
szWorkStationId | JOBN | char | OPT | INPUT |
The code that identifies the work station ID that executed a particular job. | ||||
cErrorCode | ERRC | char | OPT | OUTPUT |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szFromResultUM | FRMRSUM | char | OPT | NONE |
A user defined code (37/UM) that identifies the From unit of measure used to convert a test result. Examples of units of measure include
| ||||
szFromResultValue | FRMRSVAL | char | OPT | NONE |
Result used as the From value to convert the result. | ||||
mnQualityMgmtAB3 | QMAB3 | MATH_NUMERIC | OPT | NONE |
Reserved for Quality Management. | ||||
szQualityMgmtCode3 | QMCD3 | char | OPT | NONE |
Reserved for Quality Management. | ||||
jdQualityMgmtDate3 | QMDT3 | JDEDATE | OPT | NONE |
Reserved for Quality Management. | ||||
mnQualityMgmtNumeric3 | QMNUM3 | MATH_NUMERIC | OPT | NONE |
Reserved for Quality Management. | ||||
szQualityMgmtReference3 | QMRF3 | char | OPT | NONE |
Reserved for Quality Management. | ||||
jdResultExpirationDate | RSEXPD | JDEDATE | OPT | NONE |
The expiration date for a result. In Blend Management a result will not be carried forward if it has expired. The expiration date is calculated
| ||||
cResultEntryStatus | RSSTS | char | OPT | NONE |
A code used to determine if the test result was created from a blend rule. | ||||
szTestResultName | TSTRSNM | char | OPT | NONE |
Unique name used to group test results. | ||||
nOperationID | WOPID | integer | OPT | NONE |
mnVesselID | WVID | MATH_NUMERIC | OPT | NONE |
Unique identifier of any container used to store wine. | ||||
cVesselClass | WVTY | char | OPT | NONE |
Vessel Class specifies the kind of vessel. Examples of vessel classes are tanks, barrels, puncheons, barrel collections and VBTs. | ||||
szBlendLotNumber | WLOTN | char | OPT | NONE |
A number that identifies a Blend Lot. A lot is a group of items with similar characteristics. | ||||
szResultConversionID | RSCONVID | char | OPT | NONE |
Indicates the conversion table ID to use to convert a test result. For example, a test result is entered in Fahrenheit but must be recorded in
|
None |
None |