Exact Financials

 

Connectivity Manual - DDCDAT - control record for records to be created

DDCDAT - control record for records to be created

In the DDCDAT table for each record in DDCDSS, DDCDSM or DDCDSL a control record is created.

In the control record the kind of transaction is indicated by the table name. Through the record_ID the link is made to DDCDSS or DDCDSM. The record state indicates whether it has been processed, refused. Through the master_id and the detail_records the interface knows which records belong to one transaction.

Field	Description	Format	Data
Application	Application	char x(8)	"Application"
record_id	Record ID	inte >>>>>>>>>9	Fetch record ID number from DDCENU
table_name	Table name	char x(25)	"Relations"
field_name	Field name	char x(50)	Leave empty
record_state	State	Inte >>>>>>>>>9	See record states
Action	Action	Inte >>>>>>>>>9	Create = 2001 Assign 2004 Modify = 2002 Remove = 2003
date_created	Date created	Date 99/99/9999	Date of creation just for logging purposes
time_created	Time created	Inte >>>>>>>>>9	Time of creation just for logging purposes, in seconds
master_id	Master record ID	Inte >>>>>>>>>9	Record_id of master:e.g. record id of header record when current record is line record
detail_records	Number of detail records	Inte >>>>>>>>>9	Quantity of detail records; e.g. number of lines, if this is the header record
transaction_number	Transaction number	Inte >>>>>>>>>9	Leave empty or to be determined. See example.

Use the following Progress logic, or an equivalent in another development language, to determine the transaction number:

/*find the number to be used*/
FIND LAST DDCENU
	WHERE DDCENU.application = "EDIS":U
	AND DDCENU.number_type = 3003
EXCLUSIVE-LOCK NO-ERROR.
IF NOT AVAILABLE ddcenu THEN DO:
	CREATE ddcenu.
	ASSIGN
		DDCENU.application = "EDIS":U
		DDCENU.number_value = 1
		DDCENU.number_type = 3003 /*3003 is for transactions*/
		.
END.
ddcenu.number_value = ddcenu.number_value + 1.
/*end of example*/

Record state	Value
WAITING-FOR-PICKUP	1001
DONE	1002
FAILURE	1003
WAITING-FOR-PROCESSING	1004
WAITING-FOR-CONFIRMATION	1005
REFUSED	1006
DONE-WAITING-FOR-PICKUP	1007
REFUSED-WAITING-FOR-PICKUP	1008

---

Connectivity Manual > Contents > EDIS > Database structure EDIS > DDCDAT - control record for records to be created

---

     

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security  level:	All - 0
Sub category:	Details	Document ID:	18.326.614
Assortment:	Exact Financials	Date:	05-12-2008
Release:		Attachment:
Disclaimer