This function performs a field by field value comparison between two table formats and write the
differences to a work file.
D4700180A - Compare And Write Net Change Values
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szComputerID | CTID | char | NONE | NONE |
mnJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnEdiOrderNumber | EDOC | MATH_NUMERIC | NONE | NONE |
The document number that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the
| ||||
szEdiOrderType | EDCT | char | NONE | NONE |
The document type that is assigned by the transmitter in an EDI transaction.
In a non EDI environment, this would be consistent with the order
| ||||
szEdiOrderCompany | EKCO | char | NONE | NONE |
Company - Key (EDI - Document Key Co) | ||||
mnEdiLineNumber | EDLN | MATH_NUMERIC | NONE | NONE |
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
| ||||
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
| ||||
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
| ||||
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
| ||||
szComparisonMode | VC02 | char | NONE | NONE |
Federal Additional Tax Return Code 02 | ||||
szCustomerPO | VR01 | char | NONE | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
mnAddressNumber | 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
| ||||
szFileName | FILE | char | NONE | NONE |
The number of a specific table. For example, the Account Master table name is F0901. See the Standards Manual on the programmers'
| ||||
mnTextLineNumber | LINS | MATH_NUMERIC | NONE | NONE |
The Line Number associated with Work Order text information. | ||||
cAddressType | ANTY | char | NONE | NONE |
This will indicate the address number that is associated with the order address information. The possible values are as follows:
1 Sold-to
| ||||
cOrderChangedFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessage | EV02 | 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
| ||||
cActionCode | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change |
B4700170 Load and Unload Table Detail Cache |
F4006 Order Address Information | ||||
F4201 Sales Order Header File | ||||
F4211 Sales Order Detail File | ||||
F4301 Purchase Order Header | ||||
F4311 Purchase Order Detail File | ||||
F4314 Sales Order/Purchasing Text Detail Lines | ||||
F47003 EDI Discrepancy Report Work File | ||||
F47011 EDI Purchase Order Header - Inbound | ||||
F47012 EDI Purchase Order Detail - Inbound | ||||
F47016 EDI Purchase Order Header - Outbound | ||||
F47017 EDI Purchase Order Detail - Outbound | ||||
F47021 EDI P.O. Acknowledgment Header - Inbound | ||||
F47022 EDI P.O. Acknowledgment Detail - Inbound | ||||
F4706 EDI Order Address Information | ||||
F47131 EDI Purchase Order Change Header - Inbound | ||||
F47132 EDI Purchase Order Change Detail - Inbound | ||||
F47136 EDI Purchase Order Change Header - Outbound | ||||
F47137 EDI Purchase Order Change Detail - Outbound | ||||
F4714 EDI Order Text Lines - Header | ||||
F47141 EDI P.O. Change Acknowledgment Header - Inbound | ||||
F47142 EDI P.O. Change Acknowledgment Detail - Inbound | ||||
F4715 EDI Order Text Lines - Detail |