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.
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*/ |
|
|
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 |