One moment please...
 
 
Exact Financials (v3)   
 

Connectivity Manual C/S - 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 stateValue
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 C/S - 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: 01.642.840
 Assortment:  Date: 25-04-2005
 Release:  Attachment:
 Disclaimer