One moment please...
 
 
Exact Financials (v3)   
 

Connectivity Manual C/S - DDCDSS - Small records to be transferred

DDCDSS - Small records to be transferred

In the DDCDSS table all records are stored with a length less than or equal to 256 characters

Field Description Format Data
Application Application char x(8) 'RELAPACK'
record_id Record ID inte >>>>>>>>>9 record_ID control record in DDCDAT
small_data Small record data char x(256) data string suppliers or financial entries

Figure 3 DDCDDS - Small records

  • application - Referenced to DDCAPP.application, same as DDCDAT.application
  • record_id - record_id generated using DDCENU, same as DDCDAT.record_id
  • small_data - datastring maximum length: 256

Example:

In the 'Relapack' à Exact interface the supplier can for example be is stored in DDCDSS.

The data string in small_data can for example have the following format:

suppliers

'Relapack' fieldname Exact fieldname Exact field name Seq.nr Data type length Offset Dec
REL_NUMBER CREDITOR Creditor 3 INTEGER 6 6  
REL_NAME NAME Name 4 CHARACTER 30 12  
REL_ADDRESS ADDRESS_1 Address-1 6 CHARACTER 30 52  
REL_CITY CITY City 9 CHARACTER 30 120  
REL_CREDIT_LINE SURCH Credit line 10 DECIMAL 21 131  
REL_PAY_METHOD PAY_METHOD Payment method 11 CHARACTER 2 133  

Figure 4 Example creditor layout in ddcdss

For the journal entries the data string in small_data can for example be in the following format.

In the actual transfer of data to Exact you can specify in the link rules whether this record should create a sub line or a header line in Exact.


Connectivity Manual C/S - Contents > EDIS > Database structure EDIS > DDCDSS - Small records to be transferred

     
 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.841
 Assortment:  Date: 26-04-2005
 Release:  Attachment:
 Disclaimer