FTP communications filename parameters in Jitterbit EDI
Introduction
In addition to static strings, you can use parameters in the Remote upload file name field for FTP connections defined on the Communication settings tab. When an FTP connection is established, the system replaces these parameters with values and saves the files with the expanded names. This page describes these parameters.
FTP parameters
You can use the following parameters in the Remote upload file name field:
| Parameter | Type | Description |
|---|---|---|
Sys_No |
Bigint | |
Sender_name |
Varchar(250) | |
Receiver_name |
Varchar(250) | |
Sender |
Varchar(250) | |
Receiver |
Varchar(250) | |
Doc_Type |
Varchar(100) | Document type |
Document_ID |
Varchar(100) | |
Document_Date |
Datetime (yyyy-mm-dd) |
|
Transaction_Date |
Datetime (yyyy-mm-dd time hh:mm:ss) |
|
Reference_1 |
Varchar(200) | |
Reference_2 |
Varchar(200) | |
Integration_Reference |
Varchar(200) | |
Amount |
Money | |
Item_Count |
Integer | |
ISA_Control_Number |
Varchar(50) | Interchange control header number |
GS_Control_Number |
Varchar(50) | Functional group control number |
ST_Control_Number |
Varchar(50) | Transaction set control number |
To use a parameter, enclose it in braces (for example, {Sys_No}).
Examples
The following are example values for the Remote upload file name field:
Example 1
data_{Receiver}_{Sender}_{Doc_Part}_{Doc_Type}_{Document_ID}
data: Static string.{Receiver}: Parameter that expands to the name of the receiver.{Sender}: Parameter that expands to the name of the sender.{Doc_Part}: Parameter that expands to the document part.{Doc_Type}: Parameter that expands to the document type.{Document_ID}: Parameter that expands to the document ID._: Static separator characters.
Example 2
{GS_Control_Number}.{Document_Date}.{Transaction_Date}.{ISA_Control_Number}_RECEIVED
{GS_Control_Number}: Parameter that expands to the GS control number.{Document_Date}: Parameter that expands to the document date.{Transaction_Date}: Parameter that expands to the transaction date.{ISA_Control_Number}: Parameter that expands to the ISA control number..: Static separator characters._RECEIVED: Static string.