CopySOInfoToWorkFiles

Copy SO Info To Work Files

Major Business Rule

Object Name: B4200690

Parent DLL: CDIST

Location: Client/Server

Language: C

Functional Description

Purpose



Setup Notes and Prerequisites

• Use bullet points.
'b7

Special Logic


Technical Specification


2.1 Data Structure

szComputerIDCTID

mnJobnumberJOBS

mnLinenumberxrefLNIX

cSourceofdataEV02

cModeEV03

szCompanykeyordernoKCOO

szOrderTypeDCTO

mnDocumentorderinvoiceeDOCO

mnLineNumberLNID

szStatuscodenextNXTR

szErrormessageidDTAI

cSuppresserrormessageEV01

cReturnPtrEV04

idHeaderPtrGENLNG

idDetailPtrGENLNG

cWriteToWorkFileOrCacheEV05

cBasedOnStatusSTBOW

jdDateUpdatedUPMJ

mnTimeOfDayTDAY

szUderidUSER

cActionCodeACTN


2.2Related Tables 

F4001Z

F4011Z

F4201

F42019

F4211

F42119

F42199

F42UI01

F42UI11

F47011

F47012


2.3Related Business Functions

B9800181


2.4 Processing





Data Structure

D4200690 - Copy SO Info To Work Files





Special Input Expected


Parameters:


Data Item     Data Structure DescriptionI/O  Required     Notes

CTID        Computer ID            I/O     N   If not passed in,

                                                               GetLocalComputerID'

                                                               will be called

                                                               Required if Source

                                                               of Data is 5


JOBS        Job Number            I/O     N   Required if the

                                                               record(s) need to

                                                               be associated with

                                                               an existing

                                                               transaction or

                                                               Source of Data = 5


LNIX        Last Line Number Used      I/O     N   If not passed in,

                                                               starts from 1 Needs

                                                               to be stored in an

                                                               output field in ER


EV02        Source Of Data             I     Y   1 - F4201, F4211 

                                                               2 - F4201 or F42019

                                                                   F42199

                                                               3 - F4001Z, F4011Z

                                                               4 - F47011, F47012

                                                               5 - F42UI01,

                                                                   F42UI11

                                                                   Database File

                                                               6 - F42UI01,

                                                                   F42UI11 Cache


EV03        Mode                   I     N   0 - Both Header/

                                                                   Detail

                                                               1 - Only Header

                                                                   Record

                                                               2 - Only Detail

                                                                   Records


KCOO        Order Company             I     Y   Part of the Primary

                                                               Unique Key


DCTO        Order Type             I     Y   Part of the Primary

                                                               Unique Key


DOCO        Order Number             I     Y   Part of the Primary

                                                               Unique Key


LNID        Order Line Number       I     N   Part of the Primary

                                                               Unique Key Required

                                                               if Return Pointer
                                                               == '1' and Mode is

                                                               0 or 2 (11/26/96)


NXTR        Next Status             I     N   Used only if mode 

                                                               = 2 (when F42199

                                                               and F4201/F42019)

                                                               is used to copy the

                                                               records.


EV01       Suppress Error Message       I     N   0 - Don't suppress

                                                                   Error Mesg

                                                                   display

                                                               1 - Suppress Error

                                                                   Mesg display


EV04       Return Pointer             I     N   ' ' - Copy to

                                                                   F42UI01/F42UI11

                                                               '1' - Return

                                                                     pointers to

                                                                     F42UI01

                                                                     and/or

                                                                     F42UI11

                                                                     (doesn't copy

                                                                     to tables)

                                                                     (11/26/96)


EV05       Write to Cache or Work File I     N   If '2', write to

                                                               Cache.  If '1',

                                                               will write to work

                                                               file.  Any other

                                                               value will not

                                                               write an entry.

    

STBOW       Based On Status             I     N   If '1', the next

                                                               status paramter is

                                                               based on the Last

                                                               Status of F42199.

                                                               If any other value,

                                                               it will be based on

                                                               the Next Status.





Special Output Returned


Parameters:


Data Item     Data Structure DescriptionI/O  Required     Notes

CTID        Computer ID            I/O     N   If not passed in,

                                                               GetLocalComputerID'

                                                               will be called

                                                               Required if Source

                                                               of Data is 5


JOBS        Job Number            I/O     N   Required if the

                                                               record(s) need to

                                                               be associated with

                                                               an existing

                                                               transaction or

                                                               Source of Data = 5


LNIX        Last Line Number Used      I/O     N   If not passed in,

                                                               starts from 1 Needs

                                                               to be stored in an

                                                               output field in ER


GENLNG  Detail Record Pointer       O     N   Pointer to a

                                                               F42UI11 record

                                                               Required if Return

                                                               Pointer equals '1'

                                                               and Mode is 0 or 2

                                                               (11/26/96)


GENLNG  Header Record Pointer       O     N   Pointer to a

                                                               F42UI01 record

                                                               Required if Return

                                                               Pointer equals '1'

                                                               and Mode is 0 or 1

                                                               (11/26/96)



^

Parameter NameData ItemData TypeReq/OptI/O/Both
szComputeridCTIDcharNONENONE

mnJobnumberJOBSMATH_NUMERICNONENONE

The job number (work station ID) which executed the particular job.

mnLinenumberxrefLNIXMATH_NUMERICNONENONE

cSourceofdataEV02charNONENONE




1 - F4201, F4211

2 - F4201 or F42019, F42199

3 - F4001Z, F4011Z

4 - F47011, F47012

5 - F42UI01, F42UI11 Database File 

6 - F42UI01, F42UI11 Cache




^

cModeEV03charNONENONE




0 - Both Header/Detail 

1 - Only Header Record

2 - Only Detail Records



^

szCompanykeyordernoKCOOcharNONENONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a 
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the 
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order 
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to 
assign a next number. In this case, you probably would not use the order company to locate the document.

szOrdertypeDCTOcharNONENONE

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 
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post 
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and 
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents  
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

mnDocumentorderinvoiceeDOCOMATH_NUMERICNONENONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, 
and so on.

mnLinenumberLNIDMATH_NUMERICNONENONE

A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns 
this number,but in some cases you can override it.

szStatuscodenextNXTRcharNONENONE

A user defined code (system 40/type AT) indicating the next step in the order flow of the line type.

szErrormessageidDTAIcharNONENONE

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 
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cSuppresserrormessageEV01charNONENONE

An option that specifies the type of processing for an event.

cReturnPtrEV04charNONENONE




' ' - Copy to F42UI01/F42UI11

'1' - Return pointers to F42UI01 and/or F42UI11 (doesn't copy

      to tables) (11/26/96)



^

idHeaderPtrGENLNGIDNONENONE

General purpose ID variable.

idDetailPtrGENLNGIDNONENONE

General purpose ID variable.

cWriteToWorkFileOrCacheEV05charNONENONE




    If '2', write to Cache.  

    If '1', will write to work file.  

    Any other value will not write an entry.    



^

cBasedOnStatusSTBOWcharNONENONE

Code identifying which status codes you want the system to use when it selects information to display on this screen. The system retrieves 
this code from the processing options if you set it up. Valid codes are:    Blank Display all orders whose next status falls within this range.    1       
Display all orders whose last status falls within this range.

jdDateUpdatedUPMJJDEDATENONENONE

The date that specifies the last update to the file record.

mnTimeOfDayTDAYMATH_NUMERICNONENONE

The computer clock in hours:minutes:seconds.

szUserIdUSERcharOPTNONE

The code that identifies a user profile.

cActionCodeACTNcharOPTNONE

A code that specifies the action that is performed. Valid values are: A Add C Change

idDetailPtr2GENLNGIDOPTNONE

General purpose ID variable.

mnLastLineNumberUsedLNIXMATH_NUMERICOPTNONE

Related Functions

B9800181 Environment List Business Functions

Related Tables

F4001Z Batch Receiver File - Order Headings
F4011Z Batch Receiver File - Order Details
F4201 Sales Order Header File
F42019 Sales Order Header History File
F4211 Sales Order Detail File
F42119 Sales Order History File
F42199 S.O. Detail Ledger File
F42UI01 SO Header Cache File (MBF)
F42UI11 SO Detail Cache File (MBF)
F47011 EDI Purchase Order Header - Inbound
F47012 EDI Purchase Order Detail - Inbound