IsColumnInPymtTermsTable

Is Payment Terms Code in Payment Terms Table

Minor Business Rule

Object Name: ISCOLPT

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function checks for the existence of the payment term in the F0014 - Payment Terms Master Table.

Setup Notes and Prerequisites
None

Special Logic
None

Technical Specification






Parameters


ItemDescriptionI/OReq?Notes


BHVRERRIDidBhvrErrorIdNANId associated with an 

error


BHVREDTSTszBehaviorEditStringI/OYBehavior edit String. 


Usually contains the same value as the 

szPaymentTermsCode


DL01szDescription001ONDescription of the Due 


 Date Rule.


 


PTCszPaymentTermsCodeIYPayment terms code to 

be located in thePayment terms table.








Related Tables


F0014





Related Functions


None





Processing


If szPaymenttermscode01 is null then


 Return ER_ERROR


Else


 If szBehaviorEditString is null


 Return ER_ERROR


 else


Open F0014  Payment Terms Codes table


If F0014 did not open


 Return ER_ERROR


else


Fetch the record from the F0014 table corresponding to the 


szPaymentTermsCode


If record exists


 Load szDescription


 IdReturnValue = ER_SUCCESS


Else


 IdReturnValue = ER_FAILURE


Close F0014 table

Data Structure

DXX00010 - Is Payment Term Code In Payment Terms Table

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
idBhvrErrorId	BHVRERRID	ID	NONE	NONE
A long integer representing an error that has occurred in a behavior.
szBehaviorEditString	BHVREDTST	char	NONE	NONE
Character representation of the data in a control on a form.
szDescription001	DL01	char	NONE	NONE
A user defined name or remark.
szPaymenttermscode01	PTC	char	NONE	NONE
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include: Blank Net 15 001 1/10 net 30 002 2/10 net 30 003 Due on the 10th day of every month 006 Due upon receipt This code prints on customer invoices.

Related Functions

None

Related Tables

F0014 Payment Terms