Retirement Notice
|
|
User login
|
|
Frontpage Sponsor
|
|
Poll
|
What do you expect from your SI Implementation partner for the success of ERP implementation. Bring best practices - Not to offer more CR's Leveraging standard functions 20% Need more honesty to work with the Users until their processes are fully mapped & Users are trained 40% Focus on process automation/ integrations/ Real time data/ BI analytics 13% Stick to basics 27% Total votes: 15 |
|
|
 |

10th June 2016, 12:39
|
Member
|
|
Join Date: Jan 2016
Posts: 59
|
|
Baan: BAAN IV,FP7,LN 10.2,LN 10.3,10.4 -
DB: SQL SERVER -
OS: WINDOWS
|
Error while opening opening purchase order
Baan: Other/Unknown DB: Other/Unknown OS: Other/Unknown C/S: None/Unknown
Hi all,
I am getting table does not exist error (506) error while opening Purchase Order.but while checking in GTM the table is existed. please help me what could be the reason for this?
Regards,
Naga
|

10th June 2016, 12:53
|
 |
Guru
|
|
Join Date: Apr 2002
Posts: 1,982
|
|
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7/D.3 -
DB: tbase, ms-sql7, oracle10gV1, 11g, 12c, 19c -
OS: HP-UX, W2K3, SLES, RHLE
|
DLL read.department.....
Quote:
Originally Posted by naga ch
Hi all,
I am getting table does not exist error (506) error while opening Purchase Order.but while checking in GTM the table is existed. please help me what could be the reason for this?
Regards,
Naga
|
Hello,
check if table Departments exist.
Check also all to tdsls401 related tables are existing.
Regards
__________________
//Bernd
Last edited by bdittmar : 10th June 2016 at 12:54.
Reason: Related
|

10th June 2016, 21:07
|
Member
|
|
Join Date: Jan 2016
Posts: 59
|
|
Baan: BAAN IV,FP7,LN 10.2,LN 10.3,10.4 -
DB: SQL SERVER -
OS: WINDOWS
|
Hi ,
Thank you for the Reply.
i have checked Departments table and tdpur401 and tdsls401 table also,all are existed .but still i am getting the same error.
Regards,
Naga
|

10th June 2016, 22:49
|
Senior Member
|
|
Join Date: Sep 2001
Location: CT, USA
Posts: 164
|
|
Baan: 4c4 sp 30 -
DB: SQL 2008 R2 -
OS: Windows 2008 R2
|
Windows event viewer should tell you the table that is missing.
__________________
Gary
|

11th June 2016, 13:20
|
 |
Guru
|
|
Join Date: Apr 2002
Posts: 1,982
|
|
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7/D.3 -
DB: tbase, ms-sql7, oracle10gV1, 11g, 12c, 19c -
OS: HP-UX, W2K3, SLES, RHLE
|
Check table exists and Logfiles
Hello,
as Gary suggested, check the logfiles for further information.
Also check to tdpur401 related tables :
Code:
tdpur400,tccom120,tccom121,tccom130,tccom140,tdipu001,
tcuef002,tcibd006,tdipu046,tcmcs060,tcmcs001,tcmcs005,tcmcs048,
tcmcs003,tcmcs004,tdpur054,tcmcs080,tdpur097,tdpur098,tcmcs010,
tctax016,tcmcs075,tccom705,tcmcs201,tcmcs206,tcmcs013,tcmcs041,
tcmcs042,tccom100,tclct020,tdpur414,tdipu045
Code:
Library tdpurdll0401
Integration to Common - Logistic Data
(49 Functions available)
Function Summary
boolean
tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
long
tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
long
tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
long
tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
void
tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
boolean
tdpur.dll0401.employee.exists( domain tcemno i.employee )
domain tcncmp
tdpur.dll0401.financial.company.project( domain tccprj i.project )
domain tcncmp
tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
void
tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
domain tcdsca
tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
domain tcctit
tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
domain tcdsca
tdpur.dll0401.get.country.description( domain tcccty i.country )
domain tcemm.enty
tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
domain tcemno
tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
domain tcncmp
tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
domain tcncmp
tdpur.dll0401.get.operational.company( domain tccwoc i.department )
long
tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
domain tcdsca
tdpur.dll0401.get.title.description( domain tcctit i.title )
domain tccom.cadr
tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
void
tdpur.dll0401.read.address( domain tccom.cadr i.address )
void
tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
void
tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
void
tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
void
tdpur.dll0401.read.country( domain tcccty i.country )
void
tdpur.dll0401.read.currency( domain tcccur i.currency )
void
tdpur.dll0401.read.department( domain tccwoc i.department )
void
tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
void
tdpur.dll0401.read.employee( domain tcemno i.employee )
void
tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
void
tdpur.dll0401.read.item.group( domain tccitg i.item.group )
void
tdpur.dll0401.read.language( domain tcclan i.language )
void
tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
void
tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
void
tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
void
tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
void
tdpur.dll0401.read.price.group( domain tccprg i.price.group )
void
tdpur.dll0401.read.project( domain tccprj i.project )
void
tdpur.dll0401.read.purchase.order.number.group( )
void
tdpur.dll0401.read.reason( domain tccdis i.reason )
boolean
tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
void
tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
void
tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
void
tdpur.dll0401.read.title( domain tcctit i.title )
void
tdpur.dll0401.read.unit( domain tccprj i.unit )
void
tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
void
tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
domain tcamnt
tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
domain tcamnt
tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
boolean
tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
Function Detail
tdpur.dll0401.carrier.transport.category.is.none
boolean tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
Expl: If transport category of the carrier is not
applicable then intrastat cannot handle the carrier.
However: data is allowed so no dal check.
Input: Carrier to be checked
Return: True if transport category is none, false otherwise
tdpur.dll0401.check.carrier
long tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
Expl.: This function checks if the business partner of the
carrier is valid on a given date.
Input: i.carrier
i.delivery.date
Return: 0 if carrier is valid,
DALHOOKERROR if carrier cannot be used
tdpur.dll0401.check.not.financial.warehouse
long tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
Expl.: Checks if the warehouse is not a financial warehouse.
Financial warehouses should not be used within TD,
they do not represent actual warehouses but are used.
tdpur.dll0401.check.order.series
long tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
Expl.: This function checks if a series has been defined for the
specified number group.
Pre: NA
Post: For return value 1-4, error message is set in buffer.
This message is filled to be displayed when the order series
is not defined or blocked.
Input: i.number.group -> number group for which the series to
be checked.
i.series -> serie that must be checked
Output: o.error.message
Return: 0 if the order series is defined and not blocked,
1 if the order series is not defined,
2 if the order series is blocked,
3 if the series length does not correspond to number group,
4 if the series for a numbergroup is full.
tdpur.dll0401.check.order.series.filter
void tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
Expl.: Function returns a query in the form of a string,
which can be used to set a filter to get the valid
series for a given number group.
Pre: NA
Post: NA
Input: i.number.group
Output: o.select.filter
o.from.filter
o.where.filter
Return: NA
tdpur.dll0401.employee.exists
boolean tdpur.dll0401.employee.exists( domain tcemno i.employee )
Expl.: The purpose of this function is to see if the
employee exists.
Input: i.employee
Return: true - employee is present
false - employee is not present
tdpur.dll0401.financial.company.project
domain tcncmp tdpur.dll0401.financial.company.project( domain tccprj i.project )
Expl.: This function determines the financial company associated
with the project.
Input: i.project
Return: Financial Company
tdpur.dll0401.financial.company.purchase.office
domain tcncmp tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
Expl.: This function determines the financial company
associated to the purchase office. If
i.purchase.office is empty, the current company is
returned.
Input: i.purchase.office
Return: financial company
tdpur.dll0401.get.city.desc.of.company
void tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
Expl.: Use the function to read the city description of the current
company
Input: NA
Output: City Description
tdpur.dll0401.get.city.desc.of.department
domain tcdsca tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
Expl.: Use the function to read the city description of the
department.
Input: i.department
Return: City description
tdpur.dll0401.get.contact.title
domain tcctit tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
Expl. : Use the function to get the contact title.
Input : i.contact
Return: contact title
tdpur.dll0401.get.country.description
domain tcdsca tdpur.dll0401.get.country.description( domain tcccty i.country )
Expl.: Use the function to read the country description.
Input: i.country
tdpur.dll0401.get.department.entity.type
domain tcemm.enty tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
Expl. : This function determines the department type of the
i.department.
Pre :
Post :
Input : i.department
Output : NA
Return : department type
tdpur.dll0401.get.employee.for.logon.code
domain tcemno tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
Expl.: Function can be used to retrieve the employee code
for a given logon code.
Pre: NA
Post: NA
Input: i.logon.code
Output: NA
Return: Employee code
tdpur.dll0401.get.financial.company.of.department
domain tcncmp tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
Expl.: Function retrieves the financial company of a
department. First the department type is determent
(which can be purchase office or accounting office).
Next the operational company is determined. For
purchase offices the operational company always
equals the current logistic company (get.compnr()).
For accounting offices the operational company number
is retrieved via function
tcint.dlltcemm.get.loco.grid.of.entity.
Finaly the financial company is determined via the
enterprise unit details.
Input: i.department
Output: NA
Return: financial.company
tdpur.dll0401.get.operational.company
domain tcncmp tdpur.dll0401.get.operational.company( domain tccwoc i.department )
Expl.: This function determines the operation company of a
department based on the department's entity type.
For departments other then type 'accounting office' the
current logistic company is the operational company.
For an accounting office its financial company is its
operational company.
Pre: NA
Post: NA
Input: i.department
Output: NA
Return: the department's operational company.
tdpur.dll0401.get.project.status
long tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
Expl.: This function will get the status & description for a
Project.
Input: i.project
Output: o.status - project status
Return: 0
tdpur.dll0401.get.title.description
domain tcdsca tdpur.dll0401.get.title.description( domain tcctit i.title )
Expl. : Use the function to get the title description.
Input : i.title
Return: title description
tdpur.dll0401.get.warehouse.address
domain tccom.cadr tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
Expl. : This function returns the address code of the warehouse.
tdpur.dll0401.read.address
void tdpur.dll0401.read.address( domain tccom.cadr i.address )
Expl.: Use the function to read the address.
Input: i.address
tdpur.dll0401.read.carrier
void tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
Expl.: Use the function to read the carrier data.
Input: i.carrier
tdpur.dll0401.read.contact
void tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
Expl.: Use the function to read the contact data.
Input: i.contact
tdpur.dll0401.read.cost.component
void tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
Expl.: Use the function to read the cost component data.
Input: i.cost.component
tdpur.dll0401.read.country
void tdpur.dll0401.read.country( domain tcccty i.country )
Expl.: Use the function to read the country data.
Input: i.country
tdpur.dll0401.read.currency
void tdpur.dll0401.read.currency( domain tcccur i.currency )
Expl.: Use the function to read the currency data.
Input: i.currency
tdpur.dll0401.read.department
void tdpur.dll0401.read.department( domain tccwoc i.department )
Expl.: Use the function to read the department data.
Input: i.department
tdpur.dll0401.read.discount.code
void tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
Expl.: Use the function to read the discount code data.
Input: i.discount.code
tdpur.dll0401.read.employee
void tdpur.dll0401.read.employee( domain tcemno i.employee )
Expl.: Use the function to read the employee data.
Input: i.employee
tdpur.dll0401.read.first.free.numbers
void tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
Expl.: Use the function to read the first free number data.
Input: i.project
tdpur.dll0401.read.item.group
void tdpur.dll0401.read.item.group( domain tccitg i.item.group )
Expl.: Use the function to read the item group data.
Input: i.item.group
tdpur.dll0401.read.language
void tdpur.dll0401.read.language( domain tcclan i.language )
Expl.: Use the function to read the language data.
Input: i.language
tdpur.dll0401.read.late.payment.surcharge
void tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
Expl.: Use the function to read the late payment surcharges.
Input: i.late.payment.surcharge
tdpur.dll0401.read.manufacturer
void tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
Expl.: Use the function to read the manufacturer data.
Input: i.manufacturer
tdpur.dll0401.read.number.group
void tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
Expl. : Use the function to read the number group.
tdpur.dll0401.read.point.of.title.passage
void tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
Expl.: Use the function to read the point of title passage
Input: i.point.of.title.passage
tdpur.dll0401.read.price.group
void tdpur.dll0401.read.price.group( domain tccprg i.price.group )
Expl.: Use the function to read the price group data.
Input: i.price.group
tdpur.dll0401.read.project
void tdpur.dll0401.read.project( domain tccprj i.project )
Expl.: Use the function to read the project data.
Input: i.project
tdpur.dll0401.read.purchase.order.number.group
void tdpur.dll0401.read.purchase.order.number.group( )
Expl.: Use the function to read the number group for
purchase orders.
tdpur.dll0401.read.reason
void tdpur.dll0401.read.reason( domain tccdis i.reason )
Expl.: Use the function to read the reason.
Input: i.reason
tdpur.dll0401.read.rounding.factor
boolean tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
Expl.: Read the rounding factor of the currency belonging to
a certain company.
If company = 0 then the current company will be used.
Input: i.company (optional)
i.currency
Output: o.rounding.factor
Return: if found TRUE, otherwise FALSE
tdpur.dll0401.read.terms.of.delivery
void tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
Expl.: Use the function to read the terms of delivery.
Input: i.terms.of.delivery
tdpur.dll0401.read.terms.of.payment
void tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
Expl.: Use the function to read the terms of payment
Input: i.terms.of.payment
tdpur.dll0401.read.title
void tdpur.dll0401.read.title( domain tcctit i.title )
Expl.: Use the function to read the title data.
Input: i.title
tdpur.dll0401.read.unit
void tdpur.dll0401.read.unit( domain tccprj i.unit )
Expl.: Use the function to read the unit data.
Input: i.unit
tdpur.dll0401.read.units.by.language
void tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
Expl.: Use the function to read the units by language
Input: i.unit
i.language
tdpur.dll0401.read.warehouse
void tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
Expl.: Use the function to read the warehouse.
Input: i.warehouse
tdpur.dll0401.round.amount
domain tcamnt tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
Expl.: The purpose of this function is to round, if applicable,
the incoming amount based on the incoming currency.
Pre: NA
Post: NA
Input: i.amount - amoumt that must be rounded
i.currency - round amount based on this currency
Output: NA
Return: rounded amount is returned
tdpur.dll0401.round.price
domain tcamnt tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
Expl.: The purpose of this function is to round, if applicable,
the incoming price based on the incoming currency.
Pre: NA
Post: NA
Input: i.price -> price that must be rounded
i.currency -> round price based on this currency
Output: NA
Return: rounded price is returned
tdpur.dll0401.rounding.factor.present
boolean tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
Expl: The purpose of this function is to check if a rounding
factor is linked to the incoming currency.
Input: i.currency
Return: true -> rounding factor found
false -> no rounding factor found
Is any customization there ?
Regards
__________________
//Bernd
Last edited by bdittmar : 11th June 2016 at 18:11.
Reason: tdpurdll0401 added / Codetags
|

14th June 2016, 10:01
|
Member
|
|
Join Date: Jan 2016
Posts: 59
|
|
Baan: BAAN IV,FP7,LN 10.2,LN 10.3,10.4 -
DB: SQL SERVER -
OS: WINDOWS
|
Quote:
Originally Posted by bdittmar
Hello,
as Gary suggested, check the logfiles for further information.
Also check to tdpur401 related tables :
Code:
tdpur400,tccom120,tccom121,tccom130,tccom140,tdipu001,
tcuef002,tcibd006,tdipu046,tcmcs060,tcmcs001,tcmcs005,tcmcs048,
tcmcs003,tcmcs004,tdpur054,tcmcs080,tdpur097,tdpur098,tcmcs010,
tctax016,tcmcs075,tccom705,tcmcs201,tcmcs206,tcmcs013,tcmcs041,
tcmcs042,tccom100,tclct020,tdpur414,tdipu045
Code:
Library tdpurdll0401
Integration to Common - Logistic Data
(49 Functions available)
Function Summary
boolean
tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
long
tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
long
tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
long
tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
void
tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
boolean
tdpur.dll0401.employee.exists( domain tcemno i.employee )
domain tcncmp
tdpur.dll0401.financial.company.project( domain tccprj i.project )
domain tcncmp
tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
void
tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
domain tcdsca
tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
domain tcctit
tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
domain tcdsca
tdpur.dll0401.get.country.description( domain tcccty i.country )
domain tcemm.enty
tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
domain tcemno
tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
domain tcncmp
tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
domain tcncmp
tdpur.dll0401.get.operational.company( domain tccwoc i.department )
long
tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
domain tcdsca
tdpur.dll0401.get.title.description( domain tcctit i.title )
domain tccom.cadr
tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
void
tdpur.dll0401.read.address( domain tccom.cadr i.address )
void
tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
void
tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
void
tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
void
tdpur.dll0401.read.country( domain tcccty i.country )
void
tdpur.dll0401.read.currency( domain tcccur i.currency )
void
tdpur.dll0401.read.department( domain tccwoc i.department )
void
tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
void
tdpur.dll0401.read.employee( domain tcemno i.employee )
void
tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
void
tdpur.dll0401.read.item.group( domain tccitg i.item.group )
void
tdpur.dll0401.read.language( domain tcclan i.language )
void
tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
void
tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
void
tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
void
tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
void
tdpur.dll0401.read.price.group( domain tccprg i.price.group )
void
tdpur.dll0401.read.project( domain tccprj i.project )
void
tdpur.dll0401.read.purchase.order.number.group( )
void
tdpur.dll0401.read.reason( domain tccdis i.reason )
boolean
tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
void
tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
void
tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
void
tdpur.dll0401.read.title( domain tcctit i.title )
void
tdpur.dll0401.read.unit( domain tccprj i.unit )
void
tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
void
tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
domain tcamnt
tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
domain tcamnt
tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
boolean
tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
Function Detail
tdpur.dll0401.carrier.transport.category.is.none
boolean tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
Expl: If transport category of the carrier is not
applicable then intrastat cannot handle the carrier.
However: data is allowed so no dal check.
Input: Carrier to be checked
Return: True if transport category is none, false otherwise
tdpur.dll0401.check.carrier
long tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
Expl.: This function checks if the business partner of the
carrier is valid on a given date.
Input: i.carrier
i.delivery.date
Return: 0 if carrier is valid,
DALHOOKERROR if carrier cannot be used
tdpur.dll0401.check.not.financial.warehouse
long tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
Expl.: Checks if the warehouse is not a financial warehouse.
Financial warehouses should not be used within TD,
they do not represent actual warehouses but are used.
tdpur.dll0401.check.order.series
long tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
Expl.: This function checks if a series has been defined for the
specified number group.
Pre: NA
Post: For return value 1-4, error message is set in buffer.
This message is filled to be displayed when the order series
is not defined or blocked.
Input: i.number.group -> number group for which the series to
be checked.
i.series -> serie that must be checked
Output: o.error.message
Return: 0 if the order series is defined and not blocked,
1 if the order series is not defined,
2 if the order series is blocked,
3 if the series length does not correspond to number group,
4 if the series for a numbergroup is full.
tdpur.dll0401.check.order.series.filter
void tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
Expl.: Function returns a query in the form of a string,
which can be used to set a filter to get the valid
series for a given number group.
Pre: NA
Post: NA
Input: i.number.group
Output: o.select.filter
o.from.filter
o.where.filter
Return: NA
tdpur.dll0401.employee.exists
boolean tdpur.dll0401.employee.exists( domain tcemno i.employee )
Expl.: The purpose of this function is to see if the
employee exists.
Input: i.employee
Return: true - employee is present
false - employee is not present
tdpur.dll0401.financial.company.project
domain tcncmp tdpur.dll0401.financial.company.project( domain tccprj i.project )
Expl.: This function determines the financial company associated
with the project.
Input: i.project
Return: Financial Company
tdpur.dll0401.financial.company.purchase.office
domain tcncmp tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
Expl.: This function determines the financial company
associated to the purchase office. If
i.purchase.office is empty, the current company is
returned.
Input: i.purchase.office
Return: financial company
tdpur.dll0401.get.city.desc.of.company
void tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
Expl.: Use the function to read the city description of the current
company
Input: NA
Output: City Description
tdpur.dll0401.get.city.desc.of.department
domain tcdsca tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
Expl.: Use the function to read the city description of the
department.
Input: i.department
Return: City description
tdpur.dll0401.get.contact.title
domain tcctit tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
Expl. : Use the function to get the contact title.
Input : i.contact
Return: contact title
tdpur.dll0401.get.country.description
domain tcdsca tdpur.dll0401.get.country.description( domain tcccty i.country )
Expl.: Use the function to read the country description.
Input: i.country
tdpur.dll0401.get.department.entity.type
domain tcemm.enty tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
Expl. : This function determines the department type of the
i.department.
Pre :
Post :
Input : i.department
Output : NA
Return : department type
tdpur.dll0401.get.employee.for.logon.code
domain tcemno tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
Expl.: Function can be used to retrieve the employee code
for a given logon code.
Pre: NA
Post: NA
Input: i.logon.code
Output: NA
Return: Employee code
tdpur.dll0401.get.financial.company.of.department
domain tcncmp tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
Expl.: Function retrieves the financial company of a
department. First the department type is determent
(which can be purchase office or accounting office).
Next the operational company is determined. For
purchase offices the operational company always
equals the current logistic company (get.compnr()).
For accounting offices the operational company number
is retrieved via function
tcint.dlltcemm.get.loco.grid.of.entity.
Finaly the financial company is determined via the
enterprise unit details.
Input: i.department
Output: NA
Return: financial.company
tdpur.dll0401.get.operational.company
domain tcncmp tdpur.dll0401.get.operational.company( domain tccwoc i.department )
Expl.: This function determines the operation company of a
department based on the department's entity type.
For departments other then type 'accounting office' the
current logistic company is the operational company.
For an accounting office its financial company is its
operational company.
Pre: NA
Post: NA
Input: i.department
Output: NA
Return: the department's operational company.
tdpur.dll0401.get.project.status
long tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
Expl.: This function will get the status & description for a
Project.
Input: i.project
Output: o.status - project status
Return: 0
tdpur.dll0401.get.title.description
domain tcdsca tdpur.dll0401.get.title.description( domain tcctit i.title )
Expl. : Use the function to get the title description.
Input : i.title
Return: title description
tdpur.dll0401.get.warehouse.address
domain tccom.cadr tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
Expl. : This function returns the address code of the warehouse.
tdpur.dll0401.read.address
void tdpur.dll0401.read.address( domain tccom.cadr i.address )
Expl.: Use the function to read the address.
Input: i.address
tdpur.dll0401.read.carrier
void tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
Expl.: Use the function to read the carrier data.
Input: i.carrier
tdpur.dll0401.read.contact
void tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
Expl.: Use the function to read the contact data.
Input: i.contact
tdpur.dll0401.read.cost.component
void tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
Expl.: Use the function to read the cost component data.
Input: i.cost.component
tdpur.dll0401.read.country
void tdpur.dll0401.read.country( domain tcccty i.country )
Expl.: Use the function to read the country data.
Input: i.country
tdpur.dll0401.read.currency
void tdpur.dll0401.read.currency( domain tcccur i.currency )
Expl.: Use the function to read the currency data.
Input: i.currency
tdpur.dll0401.read.department
void tdpur.dll0401.read.department( domain tccwoc i.department )
Expl.: Use the function to read the department data.
Input: i.department
tdpur.dll0401.read.discount.code
void tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
Expl.: Use the function to read the discount code data.
Input: i.discount.code
tdpur.dll0401.read.employee
void tdpur.dll0401.read.employee( domain tcemno i.employee )
Expl.: Use the function to read the employee data.
Input: i.employee
tdpur.dll0401.read.first.free.numbers
void tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
Expl.: Use the function to read the first free number data.
Input: i.project
tdpur.dll0401.read.item.group
void tdpur.dll0401.read.item.group( domain tccitg i.item.group )
Expl.: Use the function to read the item group data.
Input: i.item.group
tdpur.dll0401.read.language
void tdpur.dll0401.read.language( domain tcclan i.language )
Expl.: Use the function to read the language data.
Input: i.language
tdpur.dll0401.read.late.payment.surcharge
void tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
Expl.: Use the function to read the late payment surcharges.
Input: i.late.payment.surcharge
tdpur.dll0401.read.manufacturer
void tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
Expl.: Use the function to read the manufacturer data.
Input: i.manufacturer
tdpur.dll0401.read.number.group
void tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
Expl. : Use the function to read the number group.
tdpur.dll0401.read.point.of.title.passage
void tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
Expl.: Use the function to read the point of title passage
Input: i.point.of.title.passage
tdpur.dll0401.read.price.group
void tdpur.dll0401.read.price.group( domain tccprg i.price.group )
Expl.: Use the function to read the price group data.
Input: i.price.group
tdpur.dll0401.read.project
void tdpur.dll0401.read.project( domain tccprj i.project )
Expl.: Use the function to read the project data.
Input: i.project
tdpur.dll0401.read.purchase.order.number.group
void tdpur.dll0401.read.purchase.order.number.group( )
Expl.: Use the function to read the number group for
purchase orders.
tdpur.dll0401.read.reason
void tdpur.dll0401.read.reason( domain tccdis i.reason )
Expl.: Use the function to read the reason.
Input: i.reason
tdpur.dll0401.read.rounding.factor
boolean tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
Expl.: Read the rounding factor of the currency belonging to
a certain company.
If company = 0 then the current company will be used.
Input: i.company (optional)
i.currency
Output: o.rounding.factor
Return: if found TRUE, otherwise FALSE
tdpur.dll0401.read.terms.of.delivery
void tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
Expl.: Use the function to read the terms of delivery.
Input: i.terms.of.delivery
tdpur.dll0401.read.terms.of.payment
void tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
Expl.: Use the function to read the terms of payment
Input: i.terms.of.payment
tdpur.dll0401.read.title
void tdpur.dll0401.read.title( domain tcctit i.title )
Expl.: Use the function to read the title data.
Input: i.title
tdpur.dll0401.read.unit
void tdpur.dll0401.read.unit( domain tccprj i.unit )
Expl.: Use the function to read the unit data.
Input: i.unit
tdpur.dll0401.read.units.by.language
void tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
Expl.: Use the function to read the units by language
Input: i.unit
i.language
tdpur.dll0401.read.warehouse
void tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
Expl.: Use the function to read the warehouse.
Input: i.warehouse
tdpur.dll0401.round.amount
domain tcamnt tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
Expl.: The purpose of this function is to round, if applicable,
the incoming amount based on the incoming currency.
Pre: NA
Post: NA
Input: i.amount - amoumt that must be rounded
i.currency - round amount based on this currency
Output: NA
Return: rounded amount is returned
tdpur.dll0401.round.price
domain tcamnt tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
Expl.: The purpose of this function is to round, if applicable,
the incoming price based on the incoming currency.
Pre: NA
Post: NA
Input: i.price -> price that must be rounded
i.currency -> round price based on this currency
Output: NA
Return: rounded price is returned
tdpur.dll0401.rounding.factor.present
boolean tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
Expl: The purpose of this function is to check if a rounding
factor is linked to the incoming currency.
Input: i.currency
Return: true -> rounding factor found
false -> no rounding factor found
Is any customization there ?
Regards
|
Hi,
No customization's done till now.But i am getting this type of error(table does not exist) for more sessions like
1.Item ordering(tcibd2500m000)
2.Item planning((cprpd1100m000)
3.Creation of production order(tisfc0101m100)
Please help me how to resolve all this??
Regards,
Naga.
|

17th June 2016, 23:42
|
Junior Member
|
|
Join Date: Jun 2002
Location: San Jose
Posts: 6
|
|
Baan: Baan IV, Baan ERP, LN 10.4 -
DB: Oracle, SQL Server 2008, 2012, 2014 -
OS: UNIX, Windows
|
These types of errors don't usually occur at random. Were any actions taken recently on the server?
Hard to tell which table is missing based on your screenshot. The LN server's Event Viewer would certainly help.
It could be the warehouse table or any other number of tables.
Is this your PROD environment? If not, worst case scenario, you could run the "Create table" Session full range. It will create any missing tables.
Also, if you are sharing tables, you might want to review those as well.
|

31st August 2022, 17:25
|
Junior Member
|
|
Join Date: Jun 2002
Location: NL
Posts: 11
|
|
Baan: Baan IVc, BaanERP, ERPLN 6.1, Basware IP and Alusta, Palette Arena (P2P), AX 3-4-2009-2012-AX7-AX365 -
DB: Oracle,Informix,SQL7/2k/2k3/2k8/2k12 -
OS: UNIX, NT, 2000, 2003,2008,2012, 2016
|
Late to the party, but nevermind...
Step 1 As other suggested already: this should be checking the Event Viewer on the LN-hostserver. That will tell you which table exactly is supposedly missing (and in which company)
Step 2 Is analyze the reason behind what you found at step 1
NOTE: Most common culprit (based on my experience) for this error popping up is the LN-logic refers to company 000 (Tools) for the table indicated. So in this case this becomes a matter of finding out why/where the 000 is coming from that's dynamically determined often (in multisite setups especially, although this may well occur for single-log/single-fin environments as well !). That on it's turn could well be a table field in some other table that's filled with company '000' . Reasons for that will differ from situation to situation. Sometimes a data migration from one feature pack to another and having forgotten to run all conversion scripts in order to fill all (new) table fields could well be the reason for this effect....
In any case, if you fill the related company field with an actual and proper value, you should be able to fix the 'collateral damage' error message 'table does not exist' as well.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|