GetNumetrixOutBoundControlInfo

Get/Set Numetrix Outbound Control Info

Minor Business Rule

Object Name: B34A0930

Parent DLL: CMFG

Location: Client/Server

Language: C

Data Structure

D34A0930 - Get/Set Numetrix Outbound Control Info

Data Item   Data Structure Description   I/O    Required    Notes
KEY         szF34A11Key                  I/O                Key to F34A11 table used to find control
file pathname
SUPPS       cSuppressErrorMessage        I/O                '1'  BSFN will not set errors, but will
return error ID
ERRC        cErrorCode                   I/O                '1'  errors, check error ID
DTAI        szErrorMessageId             I/O                error code, if any
BN01        mnBatchNumberArray001        I/O                Control file batch number
EV01        cBatchErrorStatus            I/O                Control file error status
DTSE        jdDateSent                   I/O                Control file date sent
PBTM        mnTimeSentHhMmSs             I/O                Control file time sent
END         jdDateAcknowledged           I/O                Control file date acknowledged
PETM        mnTimeAcknowledgedHhMmSs     I/O                Control file time acknowledged
EV02        cWeeklyMonthlyForecast       I/O                Control file weekly or monthly forecast
EV01        cForecastSent                I/O                Control file forecast sent flag
MATH01      mnForecastRecordCount        I/O                Control file forecast record count
EV01        cSalesOrderSent              I/O                Control file sales order sent flag
MATH01      cSalesOrderRecordCount       I/O                Control file sales order record count
EV01        cPurchaseOrderSent           I/O                Control file purchase order sent flag
MATH01      mnPurchaseOrderRecordCount   I/O                Control file purchase order record count
EV01        cWorkOrderSent               I/O                Control file work order sent flag
MATH01      mnWorkOrderRecordCount       I/O                Control file work order record count
EV01        cInventoryBalanceSent        I/O                Control file inventory balance sent flag
MATH01      mnInvBalanceRecordCount      I/O                Control file inventory balance record
count
EV01        cFacilitySent                I/O                Control file facility sent flag
MATH01      mnFacilityRecordCount        I/O                Control file facility record count
EV01        cItemExtractSent             I/O                Control file item extract sent flag
MATH01      mnItemRecordCount            I/O                Control file item extract record count
EV01        cItemUOMSent                 I/O                Control file item UOM sent flag
MATH01      mnItemUOMRecordCount         I/O                Control file item UOM record count
EV01        cSalesHistorySent            I/O                Control file sales history sent flag
MATH01      mnSalesHistorySent           I/O                Control file sales history record count

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cSuppressErrorMessage	SUPPS	char	OPT	INPUT
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.
cErrorCode	ERRC	char	OPT	OUTPUT
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
szErrorMessageId	DTAI	char	OPT	OUTPUT
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.
mnBatchNumberArray001	BN01	MATH_NUMERIC	OPT	BOTH
A number that identifies a group of transactions that are processed and balanced as a unit. You can let the system assign this number through Next Numbers, or you can assign it yourself.
cBatchErrorStatus	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
jdDateSent	DTSE	JDEDATE	OPT	BOTH
This is the date the information was sent from the source.
mnTimeSentHhMmSs	PBTM	MATH_NUMERIC	OPT	BOTH
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing.
jdDateAcknowledged	END	JDEDATE	OPT	BOTH
The date when an asset was removed or returned from a particular location.
mnTimeAcknowledgedHhMmSs	PETM	MATH_NUMERIC	OPT	BOTH
A field that is used to enter the ending time of the operation sequence for the work center operation on the routing.
cWeeklyMonthlyForecast	EV02	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnForecastRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnSalesOrderRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnPurchaseOrderRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnWorkOrderRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnInvBalanceRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnFacilityRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnItemRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnItemUOMRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cForecastSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cSalesOrderSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cPurchaseOrderSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cWorkOrderSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cInventoryBalanceSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cFacilitySent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cItemExtractSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cItemUOMSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
szF34A11Key	KEY	char	OPT	INPUT
A pre-established index or number the system uses to retrieve data from a file. For example, the keys to the Employee Master file might be: 1 Employee number, 2 Social Security number, or 3 Home Department
cSalesHistorySent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnSalesHistorySent	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cBillOfMaterialSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnBillOfMaterialRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cRoutingMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnRoutingMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cPartListSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnPartListRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cInstructionSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnInstructionRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cCustomerMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnCustomerMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cStorageCapacitySent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnStorageCapacityRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cProductSubstitutSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnProductSubstitutRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cAssetMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnAssetMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cWorkCenterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnWorkCenterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cBranchRelationsSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnBranchRelationsRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cItemDimensionSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnItemDimensionRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cCalendarSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnCalendarRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cItemBasePriceSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnItemBasePriceRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cSupplierMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnSupplierMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cSupplierItemRelSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnSupplierItemRelRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.

Related Functions

None

Related Tables

None

SetNumetrixOutBoundControlInfo

Get/Set Numetrix Outbound Control Info

Minor Business Rule

Object Name: B34A0930

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This business function will be used to create the outbound control file. The outbound control file
contains status information about the last outbound data export from OneWorld to Numetrix. The control
file is a one-line text file.

1.2Setup Notes and Prerequisites
The text file will be created with the fields in the order as shown in the data structure below,
starting with batch number. The fields will be seperated with the field seperator as specified in the
F34A10 record with key "34A". Any non-numeric fields (dates, strings, characters) will also be enclosed in
the text qualifier from the F34A10 record.

2.Technical Specifications

2.4Processing

Open tables F34A10 and F34A11. Exit with error if fail

Get Parameters

Use key "34A" to fetch F34A10 record  exit with error if fail.
Use field delimiter (FFDL) from F34A10 record
Use text qualifier (TC056) from F34A10 record
Use date format (FRMT) from F34A10 record to fetch  date format mask. Call
GetDateStringOrMaskFromUDC. Exit with error if fail

Use input szF34A11Key to fetch F34A11 record  exit with error if fail. Use NFLF as flat file name.

Open the flat file from F34A11. Exit with error if fail.

Write Line to Text File

Write the line to the text file. Text file line should have fields in the order as specified in
the data structure, beginning with batch number. For each field in the text file, use the
corresponding data structure member. Non-numeric fields (dates, characters, strings) will be enclosed in the
text qualifier, all fields will be seperated with the field seperator. Date fields should be
converted to strings using the FormatDate API and the date format mask.

Clean up

Close F34A10, F34A11, text file.
Set any applicable errors and return

Data Structure

D34A0930 - Get/Set Numetrix Outbound Control Info

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cSuppressErrorMessage	SUPPS	char	OPT	INPUT
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.
cErrorCode	ERRC	char	OPT	OUTPUT
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
szErrorMessageId	DTAI	char	OPT	OUTPUT
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.
mnBatchNumberArray001	BN01	MATH_NUMERIC	OPT	BOTH
A number that identifies a group of transactions that are processed and balanced as a unit. You can let the system assign this number through Next Numbers, or you can assign it yourself.
cBatchErrorStatus	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
jdDateSent	DTSE	JDEDATE	OPT	BOTH
This is the date the information was sent from the source.
mnTimeSentHhMmSs	PBTM	MATH_NUMERIC	OPT	BOTH
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing.
jdDateAcknowledged	END	JDEDATE	OPT	BOTH
The date when an asset was removed or returned from a particular location.
mnTimeAcknowledgedHhMmSs	PETM	MATH_NUMERIC	OPT	BOTH
A field that is used to enter the ending time of the operation sequence for the work center operation on the routing.
cWeeklyMonthlyForecast	EV02	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnForecastRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnSalesOrderRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnPurchaseOrderRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnWorkOrderRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnInvBalanceRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnFacilityRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnItemRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
mnItemUOMRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cForecastSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cSalesOrderSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cPurchaseOrderSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cWorkOrderSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cInventoryBalanceSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cFacilitySent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cItemExtractSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
cItemUOMSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
szF34A11Key	KEY	char	OPT	INPUT
A pre-established index or number the system uses to retrieve data from a file. For example, the keys to the Employee Master file might be: 1 Employee number, 2 Social Security number, or 3 Home Department
cSalesHistorySent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnSalesHistorySent	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cBillOfMaterialSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnBillOfMaterialRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cRoutingMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnRoutingMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cPartListSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnPartListRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cInstructionSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnInstructionRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cCustomerMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnCustomerMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cStorageCapacitySent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnStorageCapacityRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cProductSubstitutSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnProductSubstitutRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cAssetMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnAssetMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cWorkCenterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnWorkCenterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cBranchRelationsSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnBranchRelationsRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cItemDimensionSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnItemDimensionRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cCalendarSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnCalendarRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cItemBasePriceSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnItemBasePriceRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cSupplierMasterSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnSupplierMasterRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cSupplierItemRelSent	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnSupplierItemRelRecordCount	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.

Related Functions

None

Related Tables

None