D90CA300F - Data Structure for Content - F4201 Sales Order Header
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCompanyKeyOrderNo | KCOO | char | REQ | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnDocumentOrderInvoiceE | DOCO | MATH_NUMERIC | REQ | 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
| ||||
szCostCenter | 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
| ||||
szCompany | 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
| ||||
szCompanyKeyOriginal | OKCO | char | OPT | NONE |
A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction. | ||||
szOriginalPoSoNumber | OORN | char | OPT | NONE |
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
| ||||
szOriginalOrderType | OCTO | char | OPT | NONE |
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
| ||||
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,
| ||||
mnAddressNumberParent | PA8 | MATH_NUMERIC | OPT | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
jdDateRequestedJulian | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
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. | ||||
jdScheduledPickDate | 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
| ||||
jdDateOriginalPromisde | OPDJ | JDEDATE | OPT | NONE |
The original promised delivery date for a purchase order. | ||||
jdActualShipDate | 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
| ||||
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
| ||||
jdDatePriceEffectiveDate | PEFJ | JDEDATE | OPT | NONE |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
jdDatePromisedShipJu | 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. | ||||
szReference1 | VR01 | char | OPT | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
szReference2Vendor | VR02 | char | OPT | NONE |
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or
| ||||
szDeliveryInstructLine1 | DEL1 | char | OPT | NONE |
One of two fields that you use to enter delivery instructions. | ||||
szDeliveryInstructLine2 | DEL2 | char | OPT | NONE |
The second of two fields that you use to enter delivery instructions. | ||||
szPrintMessage1 | INMG | char | OPT | NONE |
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
| ||||
szTaxArea1 | TXA1 | char | OPT | 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 | OPT | 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
| ||||
szHoldOrdersCode | HOLD | char | OPT | NONE |
A user defined code (42/HC) that identifies why an order is on hold. | ||||
mnAmountOrderGross | OTOT | MATH_NUMERIC | OPT | NONE |
The total value of all lines on the order that have not been shipped and billed to the customer. | ||||
mnAmountTotalCost | TOTC | MATH_NUMERIC | OPT | NONE |
szAuthorizationNoCredit | AUTN | char | OPT | NONE |
This field lets you record the authorization number provided by the credit card company or bank which issued the card. | ||||
szAcctNoCrBank | CACT | char | OPT | NONE |
The first of three fields available to record credit card transactions. This field allows you to record the customer's account number with the
| ||||
jdDateExpired | CEXP | JDEDATE | OPT | NONE |
This field is to record the account number and expiration date of credit cards used by your customers who make purchases from you. It is
| ||||
cCurrencyMode | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
mnAmountForeignOpen | FAP | MATH_NUMERIC | OPT | NONE |
The unpaid foreign amount of a transaction. | ||||
jdDateRequestedShip | RQSJ | JDEDATE | OPT | NONE |
Requested ship date. | ||||
szSoldToAttention | SDATTN | char | OPT | NONE |
Attention field for billing specifications. | ||||
szShipToAttention | SPATTN | char | OPT | NONE |
Attention field for shipping specifications. | ||||
mnCustomerContactLineNumbe | CCIDLN | MATH_NUMERIC | OPT | NONE |
mnShipToCusContactLineNumID | SHCCIDLN | MATH_NUMERIC | OPT | NONE |
Ship To Customer contact line number. | ||||
mnAmountForeignExtPrice | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
idReplacementTableToken | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idLineItemDataToken | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idSoldToFound | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idShipToFound | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
szMonthDayYearTime | STRNGVAL | char | OPT | NONE |
A value that holds a string data type. | ||||
szMonth | STRNGVAL | char | OPT | NONE |
A value that holds a string data type. | ||||
szDay | STRNGVAL | char | OPT | NONE |
A value that holds a string data type. | ||||
szYear | STRNGVAL | char | OPT | NONE |
A value that holds a string data type. |
None |
None |