Short Description
Retrieves all employees.
Stored Procedure
com_get_employees
Functionality
SAP POS retrieves all employee data and outputs the result to OutputFile
based on the CollectionFormat
. CollectionFormat
is a comma
delimited field list defining the employee data that you want to output.
If CollectionFormat
is empty (you do not specify any fields) SAP POS outputs all employee data fields.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
Short Description
Retrieves a choice list.
Functionality
SAP POS performs file manipulations; this method does not provide database access.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
Short Description
Retrieves a store list.
Stored Procedure
com_get_stores
Functionality
SAP POS retrieves store data and outputs the data to OutputFile
.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
Short Description
Retrieves a vendor list.
Stored Procedure
com_get_vendors
Functionality
SAP POS retrieves vendor data and outputs the data to OutputFile
.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
Short Description
Updates receiving document to retrieve employee data.
Stored Procedure
com_get_employees2
Functionality
SAP POS retrieves employee data using the parameters CashierNum
and StoreNum
and outputs the result to OutputFile
based on the CollectionFormat
. CollectionFormat
is
a comma delimited field list defining the employee data that you want to output.
CollectionFormat
contains field list tokens that are the names of the database fields from the employee tables and has the following characteristics:
If CollectionFormat
is empty (you do not specify any fields) SAP POS outputs all employee data fields.
You can define the order of the fields in the CollectionFormat
string to meet your specific requirements.
If you want to output all employee data for all stores enter -1 for both StoreNum
(store number) and CashierNum
(cashier number).
If you want to output all employee data for one store enter the specific store number in StoreNum
and -1 for the CashierNum
(cashier number).
If you want to output one employee's data for one store enter the specific store number in StoreNum
and the specific cashier number in CashierNum
.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
|
IN |
|
|
IN |
|
Short Description
Retrieves the list of PLU cross references.
Stored Procedure
com_get_plucrossrefs
Functionality
SAP POS retrieves the PLU cross reference records and outputs the result to OutputFile
based on the CollectionFormat
. CollectionFormat
is
a comma delimited field list defining the PLU cross reference data that you want to output.
CollectionFormat
contains field list tokens that are the names of the database fields from the table plu_cross_ref
. If CollectionFormat
is empty (you do not specify any fields) SAP POS outputs all PLU
cross reference database fields.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
Short Description
Retrieve updates to PLU cross references.
Stored Procedure
com_get_pluxrefupdates
Functionality
SAP POS performs the following actions:
Retrieves PLU cross reference update records from the table update_audit
using StartingDate
(Timeof update>StartingDate
) and SeqNum
(SeqNum>SeqNum
).
Outputs the result to OutputFile
based on the CollectionFormat
. CollectionFormat
is a comma delimited field defining the PLU cross reference update data you want to output.
The
three possible output fields are plunum
,xrefnum
, and updateditem
. Since there are only three output fields, in most cases the collection format is not required.
If CollectionFormat
is empty (you do not specify any fields) SAP POS outputs all PLU cross reference update database fields.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
|
IN |
|
|
IN |
|
Short Description
Retrieves all PLU data.
Stored Procedure
com_get_all_plu
Functionality
SAP POS retrieves all PLU data and outputs the result to OutputFile
based on the CollectionFormat
. CollectionFormat
is a comma delimited
field list defining the PLU data you want to output. CollectionFormat
contains field list tokens are the names of the database fields from the table plu
.
If CollectionFormat
is empty (you do not specify any fields) SAP POS outputs all PLU database fields.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
Short Description
Retrieves vendor update data.
Stored Procedure
com_get_vendorupdates
Functionality
SAP POS performs the following actions:
Retrieves vendor update records using StartingDate
and SeqNum
.
Outputs the result to OutputFile
based on CollectionFormat
. CollectionFormat
is a comma delimited field list defining the vendor record update data you want to output. The two possible output
fields are vendorid
and updateditem
. Since there are only two output fields, in most cases the collection format is not required.
If CollectionFormat
is empty (you do not specify any fields)
SAP POS outputs all vendor update database fields.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
|
IN |
|
|
IN |
|
Short Description
Retrieves all category data.
Stored Procedure
com_get_all_categories
Functionality
SAP POS retrieve all category data and outputs the result to OutputFile
. The format of the output is catagoryNum,description
.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
Short Description
Retrieve all department group data.
Stored Procedure
com_get_all_deptgroups
Functionality
SAP POS retrieves all department group data and outputs the result to OutputFile
. The format of the output is groupNum,catagorynum,description
.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
Short Description
Retrieve tax table data.
Stored Procedure
com_get_all_tax
Functionality
SAP POS retrieves tax table data and outputs the result to OutputFile
. The format of the output is as follows:
storenum,0,regionnum,taxid,taxdesc,taxclassid,receiptcode(receiptcode=taxRate),breakptamt,mintax,0,0,0,prnrectaxzero,prnrePtaxzero,prnmanTaxzero,vat,vatitemprice,vatrecprnstyle,taxontax,taxthreshold,thresitemamt,thresdiffer,0
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
Short Description
Retrieve inventory update data.
Stored Procedure
com_get_inventorycountupdates
Functionality
SAP performs the following actions:
Retrieves inventory count update records using StartingDate
and SeqNum
.
Outputs the result to OutputFile
based on CollectionFormat
. CollectionFormat
is a comma delimited field list defining the inventory count update data that you want to output.
The
two possible output fields are plunum
and qtycurrent
. Since there are only two output fields, in most cases the collection format is not required.
If CollectionFormat
is empty (you do not specify any fields) SAP POS outputs all inventory count update database fields.
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|
|
IN |
|
|
IN |
|
|
IN |
|
Short Description
Retrieve the choice list data for the back office database.
Stored Procedure
com_get_bochoicelist
Functionality
SAP POS retrieves the data from the choice list table and outputs the result to OutputFile
. The format of the output is as follows:
choicetype,storenum,choicecode,description,linkid,linktype,choicedata
Preconditions
You must register TmxAPI.DLL
.
Result
HRESULT
Parameter Name |
Parameter Type |
Data Type |
---|---|---|
|
IN |
|