This Business Function Retrieves TKBY (Order Taken By) From F4201 (Sales Order header) using Order
Number,Order Type, Key Company and Order Suffix as the key . It returns 4810 as the error code if no
record is found.
The parameters for this function are:
DOCO Order Number INPUT
DCTO Order Type INPUT
KCOO Key Company INPUT
TKBY Taken By OUTPUT
DTAI Error Message ID OUTPUT
EV01 Suppress Error Message INPUT
SFXO Order Suffix INPUT
D4200200 - Get F4201 Order Info
Special Input Expected
DELETE THIS SECTION IF IT DOES NOT APPLY.
Special Output Returned
DELETE THIS SECTION IF IT DOES NOT APPLY.
Significant Data Values
x - xxxxxxxxxxxxx
x - xxxxxxxxxxxxx
x - xxxxxxxxxxxxx
DELETE THIS SECTION IF IT DOES NOT APPLY.
^
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
| ||||
szKeyCompany | 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
| ||||
szTakenBy | TKBY | char | NONE | NONE |
SALES ORDER SYSTEM: An optional entry field, intended for the name of the individual taking the customer's order. If you do not enter a
| ||||
szErrorMesgID | 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
| ||||
cSuppressErrorMesg | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnOrderTotal | OTOT | MATH_NUMERIC | NONE | NONE |
The total value of all lines on the order that have not been shipped and billed to the customer. | ||||
mnForeignOrderTotal | FAP | MATH_NUMERIC | NONE | NONE |
The unpaid foreign amount of a transaction. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szCustomerPO | VR01 | char | NONE | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
szHoldCode | HOLD | char | NONE | NONE |
A user defined code (42/HC) that identifies why an order is on hold. | ||||
mnSoldToAddrNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnShipToAddrNumber | SHAN | MATH_NUMERIC | NONE | NONE |
The address number of the location to which you want to ship this order. The address book provides default values for customer address,
| ||||
szPaymentTermsCode | PTC | char | NONE | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
szDisplayWeightUOM | WUMD | char | NONE | NONE |
A user defined code (00/UM) that identifies which unit of measure the system should use to display the weight of individual order lines and
| ||||
szDisplayVolumeUOM | VUMD | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to display volume for this branch/plant. The system
| ||||
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
| ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnCurrencyConvRate | 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
| ||||
szTaxArea1 | TXA1 | char | NONE | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode1 | EXR1 | char | NONE | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
szVendorReference2 | VR02 | char | NONE | NONE |
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or
| ||||
cBackOrderedYN | 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
| ||||
jdRequestedDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdPromisedDelDate | PDDJ | JDEDATE | NONE | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
mnCarrierNumber | 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
| ||||
mnBuyerNumber | ANBY | MATH_NUMERIC | NONE | NONE |
The address book number that identifies who is responsible for setting up and maintaining the correct stocking levels for each inventory
| ||||
szRouteCode | ROUT | char | NONE | NONE |
The route field is a user defined code (system 42, type RT) that represents the delivery route on which the customer resides. This field is
| ||||
szStopCode | STOP | char | NONE | NONE |
The stop code is a user defined code (system 42, type SP) that represents the stop on a delivery route. This field is one of several factors
| ||||
szZoneNumber | ZON | char | NONE | NONE |
The zone field is a user defined code (system 40, type ZN) that represents the delivery area in which the customer resides. This field is one
| ||||
mnTradeDiscount | TRDC | MATH_NUMERIC | NONE | NONE |
Percentage by which the system reduces the price of each item. This is the only discount that will be applied. You can override it if you
| ||||
mnCommissionCode1 | CMC1 | MATH_NUMERIC | NONE | NONE |
The first of two eight-character codes used to designate the salespeople who should receive credit for a sale to the customer. This code is
| ||||
mnCommissionCode2 | CMC2 | MATH_NUMERIC | NONE | NONE |
The second of two eight-character codes used to designate the salespeople who should receive credit for a sale to the customer. This
| ||||
mnCommissionRate1 | CMR1 | MATH_NUMERIC | NONE | NONE |
The first of two percentages to be applied to either the gross sales amount or the gross margin for an order or order line in computing your
| ||||
mnCommissionRate2 | CMR2 | MATH_NUMERIC | NONE | NONE |
The second of two commission percentages to be applied to either the gross sales amount or the gross margin for an order or order line in
| ||||
jdOriginalPromiseDate | OPDJ | JDEDATE | NONE | NONE |
The original promised delivery date for a purchase order. | ||||
cSubstitutesAllowedYN | SBAL | char | NONE | NONE |
Code associated with each customer specifying whether that customer will accept substitute items. Enter N to disallow or Y to allow
| ||||
cPriorityProcessing | PRIO | char | NONE | NONE |
A code that tells the system to handle this customer's orders on a priority basis. Use this value to set up print pick slips so you can choose
| ||||
szPrintMesg | INMG | char | NONE | NONE |
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
| ||||
szTaxExemptionCode | TXCT | char | NONE | NONE |
The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status. | ||||
szDeliveryInstrns1 | DEL1 | char | NONE | NONE |
One of two fields that you use to enter delivery instructions. | ||||
szDeliveryInstrns2 | DEL2 | char | NONE | NONE |
The second of two fields that you use to enter delivery instructions. | ||||
szFreightHandlingCode | FRTH | char | NONE | NONE |
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
| ||||
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
szComputerID | CTID | char | OPT | NONE |
mnProcessID | PEID | MATH_NUMERIC | OPT | NONE |
A code that identifies the Inter-Process Communication ID. | ||||
mnTransactionID | TCID | MATH_NUMERIC | OPT | NONE |
mnFutureUse3Numeric | CFS3 | MATH_NUMERIC | OPT | NONE |
mnFutureUse3Numeric_2 | CFS3 | MATH_NUMERIC | OPT | NONE |
mnFutureUse3Numeric_3 | CFS3 | MATH_NUMERIC | OPT | NONE |
mnFutureUse3Numeric_4 | CFS3 | MATH_NUMERIC | OPT | NONE |
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
| ||||
mnPromisedPickTime | PDTT | MATH_NUMERIC | OPT | NONE |
The time when the order is scheduled to be picked. Enter the time in the 24-hour format and include a leading zero if necessary. For
|
None |
F4201 Sales Order Header File | ||||
F42019 Sales Order Header History File |