Connectivity Manual - 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' r 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 >
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: |
18.326.628 |
| Assortment: |
Exact Financials
|
Date: |
05-12-2008 |
| Release: |
|
Attachment: |
|
| Disclaimer |