Contract Pricing Export

You use this program to export the Sales Order contract pricing file. The exported file is used to update contract prices at another site using the Contract Pricing Import program.

Toolbar and menu

Field

Description

Browse on

This option only applies in a client-server environment.

Client

Select this if the export file resides on the client machine.

The browse will open on the client machine.

Server

Select this if the export file resides on the server.

The browse will open on the server machine.

Start Export

Select this to export the pricing information to the specified file.

The number of records exported is displayed in a separate window at the end of the export process.

EDI Contract Pricing Export

Field

Description

Selections

Export selection

Option	Description
Modified contract prices only	Select this to export only customer and buying group contracts deleted since the last export was run.
All contract prices	Select this to export all records in the contract pricing file held at the current site.

Export file name

You use this field to indicate the name of the file to be exported.

This defaults to xORDPOC.EDI (where x refers to the company id).

If you do not specify the full path to where the file is located, the program assumes that the file must reside in your working directory on the server.

Option

Export option

This applies only if the system detects that the export file name exists and that it is a valid contract price export file.

Option	Description
Create export file	Select this to overwrite the existing file with the new information to be exported.
Append export file	Select this to add the new information to the end of the existing export file.

Last export information

The following fields display information relating to the previous export processed.

Date of export

This displays the date the last export was performed.

SYSPRO version

This indicates the version of the SYSPRO Contract Pricing Export program used to perform the export.

Company ID

This indicates the company code from which the last export was processed.

Company name

This displays the company name from which the last export was processed.

Import/Export File Structure

The following tables indicate the structure of the contract pricing import/export file.

The first two records in the file must be header records, followed by the contract detail records.

Header records

1st Header record:

Field	Start Position	Field Length	Value
Header			;SYSPRO IMPORT - Version=001 - INTP40 Mandatory entry of this comment on the first line of the import file to distinguish it from a SYSPRO 6.1 layout file. This comment is not case-sensitive.
Header record	1	2	# indicates that this is a header record.
Constant message	3	10	SYSPRO.EDI - this is a constant message to make the header more readable when viewing the file.
Space	13	1	This field is set to a space to make the header more readable.
Version	14	16	This is the SYSPRO version number of the program (e.g. Version 7.0.001).
Constant message	30	9	Format.
Constant message	39	8	Format code 'ORDPOC'.
Date	47	21	This field indicates the date on which the file was created. The format is the normal edited SYSPRO date.

2nd Header record:

Field	Start Position	Field Length	Value
Header record	1	2	# indicates that this is a header record.
Constant message	3	10	'Company :'
Company id	13	2	Company id from which the export file was created.
Constant message	15	2	'-'
Company name	17	30	SYSPRO company name.

Detail records

Field	Start Position	Field Length	Value
Contract type	1	1	If this contract is based on the customer, then this is C. If based on buying groups, then this is B.
Customer/Buying Group	2	15	If the contract type is C, then this field contains a seven character customer number. If the contract type is B, then this field is a two character valid buying group followed by five spaces.
Stock code	17	30	This field is a 30 character valid stock code.
Contract number	47	20	This field contains the contract number.
Record Type	67	1	Normal records = blank, Quantity breaks = Q
Contract start date	68	10	This contains the date on which the contract starts, in the format CCYY/MM/DD.
Contract end date	78	10	This contains the date on which the contract ends, in the format CCYY/MM/DD.
Pricing method	88	1	A single character from one of the following: F - flat price C - coded price L - list less % price M - mark up cost by % price Q - quantity discount breaks D - list less chain discount P - coded less chain discount U - coded less unit discount x - delete contract after import

The following fields are used if the pricing method is not set to Q:

Field	Start Position	Field Length	Value
Unit of measure	89	10	If the pricing method is F, then this is the pricing unit of measure.
Price code	99	10	If the pricing method is set to C, P or U, then this is the price code to use.
Fixed price	109	16 (10.5)	If the pricing method is F, then this field contains the fixed price of the contract. If the pricing method is U, then this field contains the discount value.

The following fields are used only if the pricing method is set to M, L or D:

Field	Start Position	Field Length	Value
Discount % 1	125	6	If the pricing method is M, then this is the % by which the cost must be marked up. The format of the field is 999.99. If the pricing method is L, then this is the % by which the list price must be reduced. The format of the field is 999.99. If the pricing method is D, then this is the first discount of the chain discount by which the list price must be reduced. The format of the field is 999.99. If the pricing method is P, then this is the first discount of the chain discount by which the specified price code must be reduced. The format of the field is 999.99.
Discount % 2	131	5	This field is used if the pricing method is D and it is the second discount by which the list price must be reduced. The format of the field is 99.99. If the pricing method is P, then this is the first discount of the chain discount by which the specified price code must be reduced. The format of the field is 999.99.
Discount % 3	136	5	This field is used if the pricing method is D and it is the third discount by which the list price must be reduced. The format of the field is 99.99. If the pricing method is P, then this is the second discount of the chain discount by which the specified price code must be reduced. The format of the field is 999.99.
Space	141	10	The next 10 characters are blank.
Customer list price	151	17 (10.5)	This field is used for a pricing method of F and a contract type of C.

Quantity Break Record

Field	Start Position	Field Length	Value
Contract Type	1	1	B=Buying group, C=Customer.
Customer/Buying Group	2	15	Customer number if Contract Type is C; Buying Group if Contract Type is B.
Stock Code	17	30	This field is a 30 character valid stock code.
Contract Number	47	20	This field contains the contract number.
Record Type	67	1	Quantity break=Q.
Quantity	68	19 (12.6)
Price code	87	10

Notes and warnings

Setup considerations

You must enable the Export/import contract price modifications setup option (Interface Setup) to enable the import facility.

* product-authoring@syspro.com