Customer - Attachments
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/06/01 09:16:32.498
RxWorks
MSACCESS
ODBC
RxWorks
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Customer AttachmentsSelect valuesY Transform FilenameCustomer Attachment OutputY Select valuesTransform FilenameY
Customer Attachment Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsID<act.customerDocumentAttachment>startTimefalsefalse<act.customerDocumentAttachment>descriptionfalsefalse<act.customerDocumentAttachment>fileNamefalsefalse<act.customerDocumentAttachment>statusfalseCOMPLETEDfalse<act.customerDocumentAttachment>customer[0]<participation.customer>entityfalse<party.customer*>$valuefalse<act.customerDocumentAttachment>customer[0]<participation.customer>actfalse<act.customerDocumentAttachment>$valuefalsefalsetrue1000
488
151
Y
Customer Attachments
TableInput
Y
1
none
RxWorks
SELECT *
FROM Attachment WHERE (((Attachment.[Object Type])=1));
0
N
N
86
152
Y
Select values
SelectValues
Y
1
none
Attachment Code
ID
-2
-2
Object Number
CUSTOMERID
-2
-2
Path
FILENAME
-2
-2
Notes
DESCRIPTION
-2
-2
Created Date
DATE
-2
-2
207
151
Y
Transform Filename
ScriptValueMod
Y
1
none
0
Script 1
//Script here
328
151
Y