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.
| 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 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: |
Exact Financials (v3)
|
Date: |
25-04-2005 |
| Release: |
|
Attachment: |
|
| Disclaimer |