UploadCfg_SF_FilesToServer

Upload Configurator S&&F Files To Server

Minor Business Rule

Object Name: B3201290

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
The Business Function is used during upload Store & Forward (configurator) files to server.
Note: local (configurator) records are deleted after successful upload.

1.2Setup Notes and Prerequisites
None

1.3Special Logic
None

2.Technical Specifications

2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
DOCOOriginal Order NumberIR
DOCONew Order NumberIR
DCTOOrder Type IR
KCOOCompany Key Order NoIR
LLEnvironment NameIO
SUPPSSuppress Error MessageIO
DTAIError Message IDOO
CFGIDmnServerConfigurationIDNoIR
SYszSystemCodeIRi.e. SY = 42

2.2Related Tables
Table Table Description
F3216Configurator Cost/Price Adj.
F3215Configurator Component
F3211Configurator Segment
F3201Configurator Master

2.3Related Business Functions
Source NameFunction Name

2.4Processing

Attempt to open all tables on Server and Locally.

If any table fails to open, exit program.
Select and Fetch record from local F3201

Using Order Number, System Code, Order Type, Company Key

If Fetch Return Value == fail, close tables, otherwise Retrieve Local Configuration ID#
If (Local Configuration ID # not equal zero)

While(Return value passed)

If (Local Configuration ID # not equal zero)

Select and Fetch record from local F3211,

Using Local Configuration ID

If Fetch Return Value == fail, close tables.
While(Return value passed)

    Insert to server table.
    If Insert passed
        Do another fetch on local table.
         If fetch failed
               Return value failed.
    Else
        Return value failed.

Select and Fetch record on local F3215,

Using Local Configuration ID

If Fetch Return Value == fail, close tables.
While(Return value passed)

     Insert to server table.
    If Insert passed
        Do another fetch on local table.
         If fetch failed
               Return value failed.
    Else
        Return value failed.

Select and Fetch record on local F3216,

Using Local Configuration ID

If Fetch Return Value == fail, close tables.
While(Return value passed)

    If NewConfiguration ID# was assigned, use it
    Insert to server table.
    If Insert passed
        Do another fetch on local table.
         If fetch failed
               Return value failed.
    Else
        Return value failed.

End If

    Insert to server table.
    If Insert passed
        Do another fetch on local table.
        Retrieve Local Configuration ID#
         If fetch failed then  Return value failed.
    End If
End while.

Set error
exit program

End If

Close server tables if not already closed
If there is no errors
Delete local records

(using similar logic as above)

End If

Close local tables if not already closed.

Data Structure

D3201290 - Upload Configurator S&F Files to Server

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnOriginalOrderNumber	DOCO	MATH_NUMERIC	OPT	NONE
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.
mnNewOrderNumber	DOCO	MATH_NUMERIC	OPT	NONE
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.
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 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
szCompanyKeyOrderNo	KCOO	char	OPT	NONE
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.
szEnvironmentName	LL	char	OPT	NONE
The name associated with a specific list of libraries. The J98INITA initial program uses these library list names to control environments that a user can sign on to. These configurations of library lists are maintained in the Library List Master File table (F0094). This field represents a valid environment that can be used to run in PeopleSoft EnterpriseOne. The environment encompasses both a path code (objects), and a data source (data). When put together, users have a valid workplace within the system.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageID	DTAI	char	OPT	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szSystemCode	SY	char	OPT	NONE
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
mnServerConfigurationIDNo	CFGID	MATH_NUMERIC	OPT	NONE
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables.

Related Functions

Related Tables

F32943 Needed for upgrade from Xe and below
F3296 Needed for upgrade from Xe and below
F32961 Needed for upgrade from Xe and below
F329611 Needed for upgrade from Xe and below
F3296T Needed for upgrade from Xe and below