Functional Description
Purpose
This function retrieves information from the Purchase Order Header F4301 table.
Technical Specification
2.Technical Specifications
Processing
Receive incoming parameters.
Open F4301 primary table or an index having following key fields : DOCO, DCTO, KCOO, SFXO
From F4301 table, select records with the key : DOCO, DCTO, KCOO, SFXO
If selection did complete successfuly
Return all output parms
Else
Return Error Code Message
Endif
D4300130B - Get Purchase Header Columns
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
| ||||
szOrderDocumentCompany | 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
| ||||
szOrderSuffix | SFXO | char | NONE | 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
| ||||
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
| ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szHoldOrdersCode | HOLD | char | NONE | NONE |
A user defined code (42/HC) that identifies why an order is on hold. | ||||
szToBranchPlant | 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
| ||||
mnSupplier | 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
| ||||
szReasonCode | RCD | char | NONE | NONE |
A user defined code (42/RC) that explains the purpose for a transaction. For example, you can indicate the reason that you are returning
| ||||
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
| ||||
cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
szOrderCurrency | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
mnExchangeRate | 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
| ||||
jdOrderDate | 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. | ||||
szReference1 | VR01 | char | NONE | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
szReference2 | 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
| ||||
szOrderedBy | ORBY | char | NONE | NONE |
SALES ORDER SYSTEM: An optional entry field, intended for the name of the customer placing the order. | ||||
jdRequestedDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
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
| ||||
mnChangeOrder | CORD | MATH_NUMERIC | NONE | NONE |
The number of times this purchase order has been modified. You can locate a specific change order number to review the fields that were
| ||||
szUserID | USER | char | NONE | NONE |
The code that identifies a user profile. | ||||
jdDateUpdated | UPMJ | JDEDATE | NONE | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeOfDay | TDAY | MATH_NUMERIC | NONE | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnShipToNumber | 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,
| ||||
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
| ||||
szNameRemark | RMK | char | OPT | NONE |
A generic field that you use for a remark, description, name, or address. |
None |
F4301 Purchase Order Header |