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 examples show the constituent and complete values for the Remote upload file name field:
| # | Field text | Part | Description | Example value | Expanded value |
|---|---|---|---|---|---|
| 1 | data_{Sys_No}_FROM_{Sender_name}_TO_{Receiver_name} |
data |
A literal string. | data |
data_508852261_FROM_na_640291_TO_3PL Central |
{Sys_No} |
Doc_Info_Sys_No (or eiCloudID). |
508852261 |
|||
FROM |
A literal string. | FROM |
|||
{Sender_name} |
Environment ID. | na_640291 |
|||
TO |
A literal string. | TO |
|||
{Receiver_name} |
Partner name. | 3PL Central |
|||
| 2 | {Sender}_{Receiver}_{Doc_Type} |
{Sender} |
Company ISA ID. | 02-9050999992211 |
02-9050999992211_12-3103413049_997 |
{Receiver} |
Partner ISA ID. | 12-3103413049 |
|||
{Doc_Type} |
Document type code. | 997 |
|||
| 3 | {Document_ID}_{Document_Date}_{Transaction_Date} |
{Document_ID} |
The document number (order number, invoice number, etc.). | 1062 |
1062_2025-10-08_2025-10-08 13_46_01 |
{Document_Date} |
The date on the document. | 2025-10-08 |
|||
{Transaction_Date} |
The date on the transaction. | 2025-10-08 13_46_01 |
|||
| 4 | {Reference_1}_{Reference_2}_{Integration_Reference} |
{Reference_1} |
Document reference (system generated, usually the purchase order number). | PO940949 |
PO940949_100-90000_P3688 |
{Reference_2} |
Additional document reference (system generated). | 100-90000 |
|||
{Integration_Reference} |
ref_number in Set Status. |
P3688 |
|||
| 5 | {Amount}_{Item_Count}_{ISA_Control_Number} |
{Amount} |
The dollar amount on the transaction. | 10 |
10_2_1065 |
{Item_Count} |
The total item count on the transaction. | 2 |
|||
{ISA_Control_Number} |
ISA control number of the document. | 1065 |
|||
| 6 | {GS_Control_Number}_{ST_Control_Number} |
{GS_Control_Number} |
GS06_Control_Number (a unique identifier assigned by the sender). |
1001 |
1001_0039000 |
{ST_Control_Number} |
ST02_Transaction_Set_Control_Number (set by the user or automatically by the system). |
0039000 |