Default Maintenance

From
Jump to: navigation, search
for Sage Data Exchange

Sage Data Exchange Wiki Home Launch SageDataExchange.com

To help cut down on network traffic, you can define column defaults for any Sage Data Exchange Resource.

For example, if your application creates Customers in Sage 100, you would need to pass at least the A/R Division Number and the Customer Number. If you wanted all those Customers to be created in A/R Division "01", you could add the ARDivisionNo column to the Customer Resource and assign it the value "01". Then your application would only have to pass the Customer Number.

DefaultMaintenance.png

Default Fields

Resource

Default columns are created for each Resource. (Resources are added in Resource Maintenance.) Select a Resource to maintain the Default columns.

Data Source

Data Sources are links to the tables associated with the Resource. For Sage 100 Resources, the name of the Data Source for main table of a Resource is always "MAIN". If the Resource has an associated detail table, as in Sales Orders or Sales Invoice History, the Data Source is "DETAIL".

Other Data Sources are tables that are linked to the main or detail. For example, the Terms Code Description for a Customer is not in the main Customer table. You would find it in the linked TermsCode Data Source, linked by the Default Terms Code.

Column Name

Select the Column Name to default.

Expression

Enter a PxPlus Expression to assign the value to the column. Character string expressions are evaluated with the EVS and numeric expressions are evaluated with EVN. Simply, if you are entering characters, surround them with quotes. If you are entering numbers, just enter the numbers.

Table Name (Read Only)

Table Name is just a reference to the table in Sage 100.

Column Type (Read Only)

Stings and numerics need to be handled differently.

Personal tools
MediaWiki Appliance - Powered by TurnKey Linux