D4200810 - Load Or Unload Ship Confirm Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | 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 | NONE | 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
| ||||
szOrderCompany | KCOO | char | NONE | NONE |
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 | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnReferenceLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szLineType | LNTY | char | NONE | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
mnQuantityOrdered | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnQuantityShipped | SOQS | MATH_NUMERIC | NONE | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnQuantityBackordered | SOBK | MATH_NUMERIC | NONE | NONE |
The number of units backordered in Sales Order Management or in Work Order Processing, using either the entered or the primary unit of
| ||||
mnQuantityCanceled | SOCN | MATH_NUMERIC | NONE | 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
| ||||
szBranchPlant | MCU | char | NONE | NONE |
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 | NONE | NONE |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
cCommitmentFlag | COMM | char | NONE | 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
| ||||
cOtherQuantityFlag | OTQY | char | NONE | NONE |
SALES ORDER PROCESSING DEFINITION: This field determines if the Quantity on Other Sales Order 1 or 2 field in the Item Location file is
| ||||
szLastStatus | LTTR | char | NONE | NONE |
A code (system 40/type AT) specifying the last step in the processing cycle that this order line has successfully completed. | ||||
szNextStatus | NXTR | char | NONE | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
cOnHandFlag | SO02 | char | NONE | NONE |
A code that indicates if the committed inventory for this sales detail line has been relieved from the On Hand Quantity. A value of 1 reflects
| ||||
jdActualShipDate | ADDJ | JDEDATE | NONE | NONE |
The date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales
| ||||
cCostLevel | CLEV | char | NONE | 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
| ||||
mnUnitCost | UNCS | MATH_NUMERIC | NONE | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnExtendedCost | ECST | MATH_NUMERIC | NONE | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnForeignUnitCost | FUC | MATH_NUMERIC | NONE | NONE |
Amount - Foreign Unit Cost | ||||
mnForeignExtendedCost | FEC | MATH_NUMERIC | NONE | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnUnitPrice | UPRC | MATH_NUMERIC | NONE | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
| ||||
mnExtendedAmount | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnForeignUnitPrice | FPRC | MATH_NUMERIC | NONE | NONE |
The list price in the unit of measure of the base price retrieved from the Base Price File (F4106). This is the price the customer would pay if
| ||||
mnForeignExtendedPrice | FEA | MATH_NUMERIC | NONE | NONE |
The product of the foreign price times the number of units. | ||||
szContainerID | CNID | char | NONE | NONE |
A code on the container or that you assign to the container in which the items on this purchase order or order line were shipped to you. You
| ||||
mnCarrierID | CARS | MATH_NUMERIC | NONE | NONE |
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or
| ||||
mnItemWeight | ITWT | MATH_NUMERIC | NONE | NONE |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
szWeightUOM | WTUM | char | NONE | NONE |
The unit of measure that indicates the weight of an individual item. Typical weight units of measure are:
GM Gram
OZ Ounce
LB Pound
| ||||
cApplyFreightFlag | AFT | char | NONE | NONE |
An option that specifies whether the system performs freight calculations during processing. Valid values are:
On
The system performs
| ||||
mnCurrencyConverRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
cFreightCalculated | FRTC | char | NONE | NONE |
Indicator typically updated by the freight calculation facility so that freight, once calculated and added to an order, will not be added again
| ||||
szFreightRateCode | FRAT | char | NONE | NONE |
The user defined code (system 41/type RT) for freight rate. This designates the amount that the customer is charged for postage, freight, or
| ||||
cAllowPartialShipments | APTS | char | NONE | NONE |
An option that indicates whether the customer accepts partial line shipments. Valid values are:
On
The customer accepts partial line
| ||||
cSalesDetailBackorderFlag | BACK | char | NONE | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
szRelatedItemNumber | RLIT | char | NONE | NONE |
If an individual item of inventory is sold as a component of a kit or assembly (single level bill-of-materials), the item number of that kit is the
| ||||
szSecondaryUOM | UOM2 | char | NONE | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
szPricingUOM | UOM4 | char | NONE | NONE |
A user defined code (00/UM) that indicates the unit of measure in which you usually price the item. | ||||
szVolumeUOM | VLUM | char | NONE | NONE |
The unit of measure for the cubic space occupied by an inventory item. Typical volume unit of measures are:
ML Milliliter
OZ Fluid Ounce
| ||||
cItemMasterBackorderFlag | BACK | char | NONE | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
cItemBalanceBackorderFlag | BACK | char | NONE | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
cPotencyControl | OT1Y | char | NONE | NONE |
A code that indicates whether you control the item by potency. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | NONE | NONE |
The percentage of active ingredients normally found in an item. | ||||
cLotProcessingCode | SRCE | char | NONE | NONE |
A code that indicates whether lot or serial number is assigned. Lot and serial number processes use the Lot Master table (F4108).
Valid
| ||||
cInventoryInterface | IVI | char | NONE | 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
| ||||
cEditsProcessedFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID | DTAI | char | NONE | 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
| ||||
mnCacheLineNumber | XLIN | MATH_NUMERIC | NONE | NONE |
Line number. | ||||
cObsoleteCode | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
cOpenCacheCursorFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cWriteLedgerFlag | WRTH | char | NONE | NONE |
A code that tells the system to write a record to the history table (F42199 for Sales Order Management and F43199 for Purchase Order
| ||||
mnConversionFactor | CONV | MATH_NUMERIC | NONE | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
cCallType | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnLastLineNumAssign | LINX | MATH_NUMERIC | NONE | NONE |
This is the index that was last used to calculate the annual escalated amount from the previous escalation generation. This field is updated
| ||||
mnJobNumberA | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
szComputerID | CTID | char | NONE | NONE |
idCacheCursor | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cBatchInteractiveFlag | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnX4111Z1CacheLineNum | LNIX | MATH_NUMERIC | NONE | NONE |
mnB4200310CacheLineNum | LNIX | MATH_NUMERIC | NONE | NONE |
cRecordWrittenToWFB4200310 | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cSODetailActionCode | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnActualShipTime | ADTM | MATH_NUMERIC | NONE | NONE |
The actual time of shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter 7:00
| ||||
jdActualDeliveryDate | DLDT | JDEDATE | NONE | NONE |
The delivery date of a shipment. | ||||
cInventoryAffectFlag | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
mnShipmentNumber | PTNR | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system. The partner is the entity or company with whom you have a contract or
| ||||
mnAmbientVolume | AMBR | MATH_NUMERIC | NONE | NONE |
The volume as measured for density and temperature prior to conversion. You can enter the ambient quantity or let the system
| ||||
szAmbientVolumeUOM | BUM3 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.
Note that
| ||||
mnStandardVolume | STOK | MATH_NUMERIC | NONE | NONE |
The volume after it has been converted to a standard base. Conversions are made according to published standard routines for density
| ||||
szStandardVolumeUOM | BUM4 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.
Note that
| ||||
mnWeightQuantity | WGTR | MATH_NUMERIC | NONE | NONE |
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying
| ||||
szWeightQuantityUOM | BUM5 | char | NONE | NONE |
A user defined code (system 00, type UM) that identifies the unit of measurement for pressure, volume, weight, diameter, or height.
Note that
| ||||
mnTemperature | TEMP | MATH_NUMERIC | NONE | NONE |
The temperature of the product. | ||||
cTemperatureType | STPU | char | NONE | NONE |
A code used to identify the type of temperature. Valid values are: F Fahrenheit C Celsius | ||||
mnDensity | DEND | MATH_NUMERIC | NONE | NONE |
Identifies your company's standard for density. You can also use this field for pack size and weight information. | ||||
cDensityType | DNTP | char | NONE | NONE |
A code used to identify the type of density. Valid values are: A Absolute Density G API Specific Gravity R Relative Density | ||||
mnDensityTemperature | DETP | MATH_NUMERIC | NONE | NONE |
Indicates the temperature at which the density was measured. The system uses the density temperature type from Branch/Plant Constants -
| ||||
cDensityTemperatureType | DTPU | char | NONE | NONE |
Identifies the type of temperature. Valid values are: F Fahrenheit C Celsius | ||||
mnTransactionTime | TDAY | MATH_NUMERIC | NONE | NONE |
The computer clock in hours:minutes:seconds. | ||||
szBranchComponent | CMCU | char | NONE | 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
| ||||
mnLineNumberKitMaster | KTLN | MATH_NUMERIC | NONE | NONE |
This line number indicates the relative sequence in which a component is added to a kit or single level bill of materials. For example, the
| ||||
mnComponentNumber | CPNT | MATH_NUMERIC | NONE | NONE |
A number that indicates the sequence of the components on a bill of material.
It initially indicates the relative sequence in which a
| ||||
mnRelatedKitComponent | RKIT | MATH_NUMERIC | NONE | NONE |
In the Sales Order Processing System, when a kit component is defined in the Bill of Materials Master (F3002) as a second level or higher
| ||||
mnNumbOfCpntPerParent | KTP | MATH_NUMERIC | NONE | NONE |
The total number of the current component needed per unit of the parent kit. | ||||
cOHInventoryRelievedFlag | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
mnVolumeCorrectionFactors | VCF | MATH_NUMERIC | NONE | NONE |
A calculated number to convert ambient volume to volume at standard density and temperature. This value identifies the primary stock
| ||||
szMemoLotField1 | LOT1 | char | NONE | NONE |
A higher classification or grouping of serial number or lot processed items,maintained within the Lot Master (F4108). | ||||
szMemoLotField2 | LOT2 | char | NONE | NONE |
A higher classification or grouping of memo lot 1 maintained within the lot master (F4108). | ||||
szVendorLotNumber | RLOT | char | NONE | NONE |
The supplier's lot number for the item. | ||||
mnOriginalLineNumber | OGNO | MATH_NUMERIC | NONE | NONE |
A number identifying which line on the original order that the current line matches. | ||||
cValidateStatusCode | BST | char | NONE | NONE |
A code that indicates whether a batch of transactions has been posted, is ready to post, is still open for entry, and so on. | ||||
cSerialNumberRequired | SRNR | char | OPT | NONE |
A code that specifies whether you must attach a serial number to this item at receipt or sale for basic serial number processing, or whether
| ||||
szUnitOfMeasureAsInput | 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). | ||||
cPlanTimeFenceRule | MPSP | char | OPT | NONE |
A code (system 34, table TF) that the system uses in conjunction with the Planning Time Fence Days field to determine how forecast
| ||||
mnQtyCountedInPrimary | PCNT | MATH_NUMERIC | OPT | NONE |
The number of units counted in the primary units of measure. | ||||
mnAmountUnitVolume | ITVL | MATH_NUMERIC | OPT | NONE |
The cubic units occupied by one inventory item. The definition of the unit itself (cubic feet, yards, meters, and so on) is defined in the volume
| ||||
mnUnitsSecondaryQtyOr | SQOR | MATH_NUMERIC | OPT | NONE |
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens. | ||||
mnNumberKeys | NKEYS | MATH_NUMERIC | OPT | NONE |
The number of keys in an index that will be used to retrieve, delete, or update a record. | ||||
szCacheActionCode | CACTN | char | OPT | NONE |
A code that indicates the activity you want to perform. Valid codes:
o Get - Retrieve the cache element
o Add - Add a cache element
o
| ||||
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
| ||||
mnAddressNumberShipTo | SHAN | MATH_NUMERIC | OPT | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
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. | ||||
mnExtendedCostTransfer | TCST | MATH_NUMERIC | OPT | NONE |
This is the cost of transferring inventory from one branch to another. The method of calculating this transfer cost is maintained in the Inter
| ||||
cInterbranchSalesFlag | SO01 | char | OPT | NONE |
A value of 1 indicates that this sales detail line contains an inter branch item.
Interbranch sales orders allow the user to record the
| ||||
szNextStatusCodeSplit | NXTR | char | OPT | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
szSellingCompanyCurrecyCode | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
mnContractSupplementDistri | DMCS | MATH_NUMERIC | OPT | NONE |
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
| ||||
szContractNumberDistributi | DMCT | char | OPT | NONE |
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
| ||||
szPrimaryVehicleId | PVEH | char | OPT | NONE |
Represents either the primary vehicle identification number in a connected vehicle or the identification number for a single vehicle. | ||||
szRegistrationLicenseNumbe | RLNO | char | OPT | NONE |
Identifies the identification number that appears on the license, permit, or certificate. | ||||
szUpdateSalesAgreement | EV03 | char | OPT | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
jdLoadConfirmDate | LDDT | JDEDATE | OPT | NONE |
The date this order line is load confirmed. | ||||
mnTimeLoad | LDTM | MATH_NUMERIC | OPT | NONE |
The actual time that the vehicle was loaded. | ||||
cBulkPackedFlag | 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
| ||||
szAGREE_ProductSource | PSR | char | OPT | NONE |
A value that identifies the location that supplies the item to fulfill the agreement. The value must match the Source Type code, as follows:
o
| ||||
szAGREE_ProductSourceType | PSRY | char | OPT | NONE |
A code that specifies the type of source entered in the Transaction Source field, as follows:
o If the transaction source is an address book
| ||||
mnAGREE_SequenceNumber1 | SEQ | MATH_NUMERIC | OPT | NONE |
A number that specifies the sequence of information. | ||||
cShipDateOverridden | SO07 | char | OPT | NONE |
Indicates which date fields were entered in Order Entry.
Values are:
1 Pick date (PDDJ) entered
2 Delivery date (RSDJ) entered
3
| ||||
szModeOfTransport | MOT | char | OPT | NONE |
A user defined code (00/TM) that describes the nature of the carrier being used to transport goods to the customer. For example, by rail, by
| ||||
szPurchasingReportCode1 | PRP1 | char | OPT | NONE |
A code (table 41/P1) that represents an item property type or classification,such as commodity type, planning family, or so forth. The
| ||||
szTranOverride_NXTR | NXTR | char | OPT | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
cDualUnitOfMeasureItem | DUAL | char | OPT | NONE |
An option that indicates that the system must maintain inventory balances and record transactions for an item in a secondary unit of
| ||||
cDualPickingProcessOption | DPPO | char | OPT | NONE |
An option that determines for a dual unit of measure item whether the system uses the primary or secondary unit of measure for the following
| ||||
mnConversionFactorTrantoSecnd | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
mnConvFactorSecondarytoTrans | CNV1 | MATH_NUMERIC | OPT | NONE |
The mathematical relationship showing the conversion between the primary and secondary units of measure. | ||||
mnConvFactorScndrytoScndPrime | CNV1 | MATH_NUMERIC | OPT | NONE |
The mathematical relationship showing the conversion between the primary and secondary units of measure. | ||||
mnOrderQuantityinSecondaryUOM | SQOR | MATH_NUMERIC | OPT | NONE |
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens. | ||||
cCheckExpirationDate | EDCK | char | OPT | NONE |
An option that determines whether the system ensures that a lot be shipped in ascending order in relation to other lots that have already
| ||||
cCheckSellByDate | SBCK | char | OPT | NONE |
An option that indicates whether the system ensures that a lot being shipped to a customer is shipped in ascending order by the sell by
| ||||
cCheckBestBeforeDate | BBCK | char | OPT | NONE |
An option that specifies whether the system ensures that the lot that you are shipping to a customer has a value in the Best Before Date field
| ||||
jdBestBeforeDate | BBDJ | JDEDATE | OPT | NONE |
The last date on which the products in a lot should be consumed. The system calculates the date by retrieving the value from the Best
| ||||
jdSellByDate | SBDJ | JDEDATE | OPT | NONE |
The date by which a lot should be completely sold. The system uses this date as a "through" date for commitment processing. The system
| ||||
cPrefLotBasedOnDates | SO06 | char | OPT | NONE |
A value of 1 in this field indicates the line has already ran through preference inventory commitment. | ||||
jdDateLotExpiration | MMEJ | JDEDATE | OPT | NONE |
The date on which a lot of items expires.
The system automatically enters this date if you have specified the shelf life days for the item on
| ||||
cCommitmentDateMethod | CMDM | char | OPT | NONE |
A user defined code (H40/CD) that specifies which date the system uses to commit inventory when an item is committed by date. The
| ||||
szLineTypeTable_LNTY | 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
| ||||
mnOrderQtyTable_UORG | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
mnShipQtyTable_SOQS | SOQS | MATH_NUMERIC | OPT | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnBackorderQtyTable_SOBK | 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
| ||||
mnCancelQtyTable_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
| ||||
szBranchPlantTable_MCU | 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
| ||||
szLocationTable_LOCN | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szLotNumberTable_LOTN | LOTN | char | OPT | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
cCommitFlagTable_COMM | 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
| ||||
szNextStatusTable_NXTR | NXTR | char | OPT | NONE |
A user defined code (system 40/type AT) indicating the next step in the order flow of the line type. | ||||
cOnHandFlagF4211_SO02 | SO02 | char | OPT | NONE |
A code that indicates if the committed inventory for this sales detail line has been relieved from the On Hand Quantity. A value of 1 reflects
| ||||
mnUnitCostTable_UNCS | UNCS | MATH_NUMERIC | OPT | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnCostExtendedTable_ECST | ECST | MATH_NUMERIC | OPT | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnForeignUnitCostTable_FUC | FUC | MATH_NUMERIC | OPT | NONE |
Amount - Foreign Unit Cost | ||||
mnForeignExtCostTable_FEC | FEC | MATH_NUMERIC | OPT | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnExtendedPriceTable_AEXP | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnForeignExtPriceTable_FAP | FAP | MATH_NUMERIC | OPT | NONE |
The unpaid foreign amount of a transaction. | ||||
szContainerIDTable_CNID | CNID | char | OPT | NONE |
A code on the container or that you assign to the container in which the items on this purchase order or order line were shipped to you. You
| ||||
mnCarrierTable_CARS | CARS | MATH_NUMERIC | OPT | NONE |
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or
| ||||
mnItemWeightTable_ITWT | ITWT | MATH_NUMERIC | OPT | NONE |
The weight of one unit of an item, expressed in the primary unit of measure. | ||||
szCurrencyCodeTable_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szPrimaryUoMTable_UOM1 | UOM1 | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
| ||||
jdSchedPickDateTable_PDDJ | PDDJ | JDEDATE | OPT | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
szItemNumber2nd_LITM | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szItemNumber3rd_AITM | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szCompany_Table_CO | 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
| ||||
mnPickSlipNumbTable_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
| ||||
mnItemVolumeTable_ITVL | ITVL | MATH_NUMERIC | OPT | NONE |
The cubic units occupied by one inventory item. The definition of the unit itself (cubic feet, yards, meters, and so on) is defined in the volume
| ||||
cCostOverrideFlagTable_CSTO | CSTO | char | OPT | NONE |
A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a
| ||||
mnPrimaryOrderQtyTable_PQOR | PQOR | MATH_NUMERIC | OPT | NONE |
The quantity ordered by the customer expressed in the primary stocking unit of measure. | ||||
mnSecondOrderQtyTable_SQOR | SQOR | MATH_NUMERIC | OPT | NONE |
If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens. | ||||
jdDateRequestedTable_DRQJ | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdDateReleaseTable_RSDJ | RSDJ | JDEDATE | OPT | NONE |
The date an item will be delivered to the customer. | ||||
szSalesAgreementNumb_DMCT | DMCT | char | OPT | NONE |
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement
| ||||
mnSalesAgreementSupp_DMCS | DMCS | MATH_NUMERIC | OPT | NONE |
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual
| ||||
cUpdateGLAccommodations_UPGL | UPGL | char | OPT | NONE |
Indicates when the system updates the general ledger. Valid values are:
Y Journal entries will be written as soon as the quantity moves
| ||||
mnConvFactPricToPrim_CNV1 | CNV1 | MATH_NUMERIC | OPT | NONE |
The mathematical relationship showing the conversion between the primary and secondary units of measure. | ||||
szStandardUOMConversion_TFLA | TFLA | char | OPT | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
cWarehouseOnFlag_WCTL | WCTL | char | OPT | NONE |
A code that determines whether the system creates warehouse transactions for the branch/plant. | ||||
cTextLineYN | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
jdShipDateF4211Table_ADDJ | ADDJ | JDEDATE | OPT | NONE |
The date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales
| ||||
szPortOfEntryExit | POE | char | OPT | NONE |
The port from which or to which the goods were shipped. For VAT reporting, certain countries require information about the port of exit or
| ||||
cFutureUseChar01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFutureUseChar02 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFutureUseChar03 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFutureUseChar04 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFutureUseChar05 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cFutureUseChar06 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szFutureUseString01 | DESC | char | OPT | NONE |
A description, remark, name, or address. | ||||
szFutureUseString02 | DESC | char | OPT | NONE |
A description, remark, name, or address. | ||||
szFutureUseString03 | DESC | char | OPT | NONE |
A description, remark, name, or address. | ||||
szFutureUseString04 | DESC | char | OPT | NONE |
A description, remark, name, or address. | ||||
szFutureUseString05 | DESC | char | OPT | NONE |
A description, remark, name, or address. | ||||
szFutureUseString06 | DESC | char | OPT | NONE |
A description, remark, name, or address. | ||||
mnFutureUseMathNum01 | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnFutureUseMathNum02 | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnFutureUseMathNum03 | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
jdFutureUseDate01 | DATE01 | JDEDATE | OPT | NONE |
Event point for JDE Date. | ||||
jdFutureUseDate02 | DATE01 | JDEDATE | OPT | NONE |
Event point for JDE Date. | ||||
jdDatePromisedPickTable | PPDJ | JDEDATE | OPT | NONE |
The promised shipment date for a sales order. This date represents the day that the item can be shipped from the warehouse. | ||||
szFreightHandlingCodeTable | FRTH | char | OPT | NONE |
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
| ||||
szSecondaryPrimaryUOM | 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). | ||||
mnActualShipTimeP4205Cache | ADTM | MATH_NUMERIC | OPT | NONE |
The actual time of shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter 7:00
| ||||
mnActualShipTimeTable | ADTM | MATH_NUMERIC | OPT | NONE |
The actual time of shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter 7:00
| ||||
mnRequestedDeliveryTime | DRQT | MATH_NUMERIC | OPT | NONE |
The time requested for delivery. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and enter
| ||||
mnPromisedShipmentTime | PMDT | MATH_NUMERIC | OPT | NONE |
The scheduled time of a shipment. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and
| ||||
mnPromisedDeliveryTime | RSDT | MATH_NUMERIC | OPT | NONE |
The promised time for a delivery. Enter the time using the 24-hour time format (HHMMSS). For example, enter 6:00 a.m. as 060000, and
| ||||
cCacheIndex | CIDX | char | OPT | NONE |
A parameter that allows a cache to be sorted on multiple indexes to allow for faster data retrieval based upon different key information. | ||||
cPriceatAmbiantorStandard | PRAS | char | OPT | NONE |
Identifies the price extension calculation method. Valid Values are:
A Unit price X delivered volume at ambient temperature
S Unit price X
| ||||
szItemNumberPrimary | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
szCompany_Cache_CO | 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
| ||||
cStatusInWarehouse | SWMS | char | OPT | NONE |
This flag can contain the following values:
blank Sales Order line which has not entered warehousing.
I Sales Order line inside the
| ||||
jdCancelDate | CNDJ | JDEDATE | OPT | NONE |
The date that the order should be canceled if the goods have not been sent to the customer or the goods have not been received from the
| ||||
szGlCategory_Cache | GLPT | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If
|
None |
None |