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