N41B0270

GetReconciliationInformation

Major Business Rule

Object Name: N41B0270

Parent DLL: CLOG

Location: Client/Server

Language: NER

Data Structure

D41B0270 - Data Structure for N41B0270 - GetReconcilationInformation

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cEverestEventPoint01	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szCostCenter	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
mnIdentifierShortItem	ITM	MATH_NUMERIC	NONE	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szUnitOfMeasurePrimary	UOM1	char	NONE	NONE
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA (each) or KG (kilogram).
szUnitOfMeasureVolume	UVM1	char	NONE	NONE
A user defined code (00/UM) that indicates the unit of measure by metric conversion for ambient volume. For example, the unit of measure code for a gallon might be GL, or for a liter it might be LT.
szUnitOfMeasureWeight	UWUM	char	NONE	NONE
A user defined code (00/UM) that identifies the unit of measure that the system uses to indicate weight for this item. You can specify ounces, grams, kilograms, and so on, as weight standards. The system uses this unit of measure for the item or overrides it for an individual item or container.
mnThroughputSinceLastRec	TTRE	MATH_NUMERIC	NONE	NONE
The calculated volume that has passed through the meter since the last meter reading.
mnMeterCorrection	MCOR	MATH_NUMERIC	NONE	NONE
The amount of product that passed through while the meter was out of service.
cTemperatureCompensatedYN	TMCP	char	NONE	NONE
Indicates whether the throughput volume is already at the standard temperature and a temperature conversion is required. Valid values are: Y Yes. You may also use 1. N No. You may also use 0.
szTankID	TKID	char	NONE	NONE
An 8-character field identifying the tank as defined on the Branch/Plant Constants form.
jdOperationalReconciledDat	OPDT	JDEDATE	NONE	NONE
The date the transaction was operationally reconciled. The Update Operational Reconciliations process updates this field.
mnOpeningStock	OPNS	MATH_NUMERIC	NONE	NONE
The opening stock in the tank for that day. The opening stock is the same quantity as the closing stock volume from the prior reconciliation period.
mnOpeningStock_2	OPNS	MATH_NUMERIC	NONE	NONE
The opening stock in the tank for that day. The opening stock is the same quantity as the closing stock volume from the prior reconciliation period.
mnOpeningStock_3	OPNS	MATH_NUMERIC	NONE	NONE
The opening stock in the tank for that day. The opening stock is the same quantity as the closing stock volume from the prior reconciliation period.
mnClosingStock	CLOS	MATH_NUMERIC	NONE	NONE
The quantity from the most recent tank dip reading. The closing stock is based on the As Of Date for the reconciliation.
mnClosingStock_2	CLOS	MATH_NUMERIC	NONE	NONE
The quantity from the most recent tank dip reading. The closing stock is based on the As Of Date for the reconciliation.
mnClosingStock_3	CLOS	MATH_NUMERIC	NONE	NONE
The quantity from the most recent tank dip reading. The closing stock is based on the As Of Date for the reconciliation.
mnIncomings	INCN	MATH_NUMERIC	NONE	NONE
The total of all unreconciled incoming transactions for the document types listed in the processing options.
mnIncomings_2	INCN	MATH_NUMERIC	NONE	NONE
The total of all unreconciled incoming transactions for the document types listed in the processing options.
mnIncomings_3	INCN	MATH_NUMERIC	NONE	NONE
The total of all unreconciled incoming transactions for the document types listed in the processing options.
mnOutgoings	OUTG	MATH_NUMERIC	NONE	NONE
The total of all unreconciled outgoing transactions for the document types listed in the processing options.
mnOutgoings_2	OUTG	MATH_NUMERIC	NONE	NONE
The total of all unreconciled outgoing transactions for the document types listed in the processing options.
mnOutgoings_3	OUTG	MATH_NUMERIC	NONE	NONE
The total of all unreconciled outgoing transactions for the document types listed in the processing options.
mnVolumeGainLoss	GLQT	MATH_NUMERIC	NONE	NONE
The operational gain/loss calculated for that day. Gains are shown as positive and losses as negative.
mnVolumeGainLoss_2	GLQT	MATH_NUMERIC	NONE	NONE
The operational gain/loss calculated for that day. Gains are shown as positive and losses as negative.
mnVolumeGainLoss_3	GLQT	MATH_NUMERIC	NONE	NONE
The operational gain/loss calculated for that day. Gains are shown as positive and losses as negative.
mnTimeRead	RDTM	MATH_NUMERIC	NONE	NONE
The time when the readings were performed. Enter the time in either HHMMSS or HH:MM:SS format. If you leave this field blank, the system enters the current time used.
jdDateTransactionJulian	TRDJ	JDEDATE	NONE	NONE
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.
szProgramId	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
cEverestEventPoint01_4	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szDataItem	DTAI	char	NONE	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.
jdThroughputReconciledDate	THDT	JDEDATE	NONE	NONE
The date a transaction is throughput reconciled. This is updated in the Update Throughput Operations process.
mnVolumeAmbientInInventory	AMBI	MATH_NUMERIC	NONE	NONE
The ambient quantity (prior to conversion to standard volume) which has been converted to the inventory unit of measure for that item.
mnWeightResult	WGTR	MATH_NUMERIC	NONE	NONE
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying an air correction, if necessary (all at the base temperature).
mnVolumeAmbientInInventory_2	AMBI	MATH_NUMERIC	NONE	NONE
The ambient quantity (prior to conversion to standard volume) which has been converted to the inventory unit of measure for that item.
mnWeightResult_2	WGTR	MATH_NUMERIC	NONE	NONE
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying an air correction, if necessary (all at the base temperature).
mnVolumeAmbientInInventory_3	AMBI	MATH_NUMERIC	NONE	NONE
The ambient quantity (prior to conversion to standard volume) which has been converted to the inventory unit of measure for that item.
mnVolumeAmbientInInventory_4	AMBI	MATH_NUMERIC	NONE	NONE
The ambient quantity (prior to conversion to standard volume) which has been converted to the inventory unit of measure for that item.
mnVolumeAmbientInInventory_5	AMBI	MATH_NUMERIC	NONE	NONE
The ambient quantity (prior to conversion to standard volume) which has been converted to the inventory unit of measure for that item.
mnStockTotalinPrimaryUOM	STUM	MATH_NUMERIC	NONE	NONE
The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting unit can be either volume or weight.
mnStockTotalinPrimaryUOM_2	STUM	MATH_NUMERIC	NONE	NONE
The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting unit can be either volume or weight.
mnStockTotalinPrimaryUOM_3	STUM	MATH_NUMERIC	NONE	NONE
The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting unit can be either volume or weight.
mnWeightResult_3	WGTR	MATH_NUMERIC	NONE	NONE
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying an air correction, if necessary (all at the base temperature).
mnWeightResult_4	WGTR	MATH_NUMERIC	NONE	NONE
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying an air correction, if necessary (all at the base temperature).
mnWeightResult_5	WGTR	MATH_NUMERIC	NONE	NONE
The weight of the product at standard temperature. The system calculates the weight by multiplying the volume by the density and applying an air correction, if necessary (all at the base temperature).
szTemporaryItemFlashMessag	TFLA	char	NONE	NONE
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are: blank Use the item-specific unit of measure 1 Bypass the item-specific unit of measure and use the standard unit of measure
POOHBTRstatus	LRST	MATH_NUMERIC	NONE	NONE
Identifies the current status in the reconciliation process. Entries in this field are User Defined Codes (UDCs). Important note: Set up your Reconciliation Status - Current UDCs sequentially in the same order as the process flow. The same codes are used for Reconciliation Status - Next.
POOCStatus	LRST	MATH_NUMERIC	NONE	NONE
Identifies the current status in the reconciliation process. Entries in this field are User Defined Codes (UDCs). Important note: Set up your Reconciliation Status - Current UDCs sequentially in the same order as the process flow. The same codes are used for Reconciliation Status - Next.
POONStatus	NRST	MATH_NUMERIC	NONE	NONE
Identifies the next status in the reconciliation process. Important Note: Set up your Reconciliation Status - Next codes sequentially in the same order as the process flow. The same codes are used for Reconciliation Status - Current.
POTLCSsysc	SY	char	NONE	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
POTOMOsysc	SY	char	NONE	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
POTNMOsysc	SY	char	NONE	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
POTLRST	LRST	MATH_NUMERIC	NONE	NONE
Identifies the current status in the reconciliation process. Entries in this field are User Defined Codes (UDCs). Important note: Set up your Reconciliation Status - Current UDCs sequentially in the same order as the process flow. The same codes are used for Reconciliation Status - Next.
POTNRST	NRST	MATH_NUMERIC	NONE	NONE
Identifies the next status in the reconciliation process. Important Note: Set up your Reconciliation Status - Next codes sequentially in the same order as the process flow. The same codes are used for Reconciliation Status - Current.
POOIncsysc	SY	char	NONE	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
POOOutsysc	SY	char	NONE	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
POOMTRsysc	SY	char	NONE	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
szUserId	USER	char	NONE	NONE
The code that identifies a user profile.
szWorkStationId	JOBN	char	NONE	NONE
The code that identifies the work station ID that executed a particular job.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
POOMTRrt	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
POTLCSrt	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
POTOMOrt	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
POTNMOrt	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
POOIncrt	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
POOOutrt	RT	char	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
cReconcileTOB	RTOB	char	NONE	NONE
This code indicates whether the Item or Tank should be included in the reconciliation process as follows: T Include this item in the Throughput Reconciliation process only. You may also use 1. O Include this item or tank in the Operational Reconciliation process only. You may also use 0. B Include this item in both the Throughput and Operational Reconciliation processes. You may also use 3. N Do not include this item or tank in either of the Reconciliation processes. You may also use 0.
jdReconciledThruDate	RECD	JDEDATE	NONE	NONE
The date, up to and including this date, on which all transactions have been reconciled.
szSelectionValue2	SVL	char	NONE	NONE
The data selection value. A special facility has been provided to allow selection of multiple specific values. By entering 'VALUES' in the selection field, a special display screen will be displayed allowing the entry of up to 45 specific values. If you specify 'VALUES' in multiple selections of the original display, you will be prompted for multiple values lists. Enter the value 'BLANKS' if you are searching on a blank value. You cannot leave the values field blank to search on blanks, it will default to 'ALL'. Enter the value 'ZEROS' when searching for amounts equal to zero. The 'RANGE' keyword will display a special display screen which will allow the entry of a range of values (i.e., from 1 to 50). The first value MUST be LESS than the second value. If it is equal or greater than, it will not work. If you want to select all values for a field, enter '*ALL'.
cReconciliationStatus	RECS	char	NONE	NONE
Identifies whether the reading has been reconciled. Valid values are: Y The record has been fully reconciled. N The record has not been reconciled. I In process, the record has been throughput reconciled. P In process, the tank has an error condition or the reconciliation ended abnormally.
ReportTPrecondate	THDT	JDEDATE	NONE	NONE
The date a transaction is throughput reconciled. This is updated in the Update Throughput Operations process.
ReportOPrecondate	OPDT	JDEDATE	NONE	NONE
The date the transaction was operationally reconciled. The Update Operational Reconciliations process updates this field.
CacheJobNumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.

Related Functions

None

Related Tables

None

RetroCacheInterface

GetReconciliationInformation

Minor Business Rule

Object Name: N41B0270

Parent DLL: CLOG

Location: Client/Server

Language: NER

Functional Description

Purpose

Setup Notes and Prerequisites

Special Logic

Technical Specification

Parameters
Data Item Data Structure Description I/O Required Notes

Related Tables

Related Business Fuctions

Processing

Data Structure

D41B0270B - Retro Cache Interface

Parameter Name Data Item Data Type Req/Opt I/O/Both

szCacheActionCode CACTN char REQ INPUT

A code that indicates the activity you want to perform. Valid codes:     o Get - Retrieve the cache element     o Add - Add a cache element     o
Update - Update a cache element     o Delete - Delete a cache element     o Delete All - Delete all cache elements     o Get Next - Retrieve the
next cache element     o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist     o Terminate -
Terminate Cache

mnNumberKeys NKEYS MATH_NUMERIC REQ INPUT

The number of keys in an index that will be used to retrieve, delete, or update a record.

cSuppressErrorMessage EV01 char OPT INPUT

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

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.

idCacheCursor GENLNG ID OPT NONE

General purpose ID variable.

mnJobnumberA JOBS MATH_NUMERIC OPT NONE

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

jdDateTransactionJulian TRDJ JDEDATE OPT NONE

The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.

mnRetroQty STUM MATH_NUMERIC OPT NONE

The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting
unit can be either volume or weight.

cRecordType TRCD char OPT NONE

This field is used internally in the Bulk Product Transaction file (F41511). The valid record types are:    F  FROM record in General Stock
Movements    T  TO record in General Stock Movements    B  BEFORE record in Dip Volume Calculations    A  AFTER record in Dip Volume
Calculations    M  METER reading record in Discharge Meter Reading (Simultaneous Withdrawals only)    D  DIP record from Multi-Tank Dip
Readings    S  SALES record - either from load or delivery confirm    P  PURCHASE record from P.O. Receipts    W  WEIGHBRIDGE record from
Weighbridge Information screen

szProgramId PID char OPT NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

mnUniqueKeyIDInternal UKID MATH_NUMERIC OPT NONE

This field is a unique number used to identify a record in a file.

szSpecificRecordType A303 char OPT NONE

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCacheActionCode	CACTN	char	REQ	INPUT
A code that indicates the activity you want to perform. Valid codes: o Get - Retrieve the cache element o Add - Add a cache element o Update - Update a cache element o Delete - Delete a cache element o Delete All - Delete all cache elements o Get Next - Retrieve the next cache element o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist o Terminate - Terminate Cache
mnNumberKeys	NKEYS	MATH_NUMERIC	REQ	INPUT
The number of keys in an index that will be used to retrieve, delete, or update a record.
cSuppressErrorMessage	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
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.
idCacheCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
mnJobnumberA	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
jdDateTransactionJulian	TRDJ	JDEDATE	OPT	NONE
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.
mnRetroQty	STUM	MATH_NUMERIC	OPT	NONE
The quantity as converted to the primary stock accounting unit of measure identified for this item (product). This primary stock accounting unit can be either volume or weight.
cRecordType	TRCD	char	OPT	NONE
This field is used internally in the Bulk Product Transaction file (F41511). The valid record types are: F FROM record in General Stock Movements T TO record in General Stock Movements B BEFORE record in Dip Volume Calculations A AFTER record in Dip Volume Calculations M METER reading record in Discharge Meter Reading (Simultaneous Withdrawals only) D DIP record from Multi-Tank Dip Readings S SALES record - either from load or delivery confirm P PURCHASE record from P.O. Receipts W WEIGHBRIDGE record from Weighbridge Information screen
szProgramId	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	OPT	NONE
This field is a unique number used to identify a record in a file.
szSpecificRecordType	A303	char	OPT	NONE