P Appendix: SFTP File Directory and Filename Format

This section lists the sFTP directories where user can upload and download batch files via sFTP server.

For additional details on sFTP account setup, see Oracle® Retail Enterprise Inventory Cloud Service Security Guide Nightly Batch File Uploads and Export File Downloads sections.

File Upload Directory and Filename Format

Table P-1 File Upload Directory and Filename Format

Import File Name	sFTP Directory	Filename Format
Clearance Price Change Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <event type>_<date in YYYYMMDDHH24MISS format>_<loc type>.zip Where event type value is "CLRPC". The loc type field would be either 'S' or 'W'. The zip file can contain one or more files from same or different stores. The complete file needs to be added for zip file for job to pick it for processing. Example: CLRPC_20180129133250_S.zip CLRPC_20180129133250_S.zip.complete Filename Inside Zip <event type>_<date in YYYYMMDDHH24MISS format>_<loc id>_<loc type>.dat Where event type value is "CLRPC" (clearances), the loc type field would be either 'S' or 'W'. Example: CLRPC_20180129133250_1111_S.dat
Initial Inventory Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <file prefix>_<date in YYYYMMDDHH24MISS format>.zip Where file prefix value is EXTSTK_. The zip file can contain one or more .date files. The complete file needs to be added for zip file for job to pick it for processing. Example: EXTSTK _20180129133250.zip EXTSTK_20180129133250.zip.complete Filename Inside Zip <file prefix>_<date in YYYYMMDDHH24MISS format>_<loc id>.dat Where file prefix value is EXTSTK_ and loc id is the store identifier. This allows file to be unique for every upload. Example: EXTSTK_20180129133250_1111.dat
POS Sale Transaction Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <file prefix>_<date in YYYYMMDDHH24MISS format>.zip Where file prefix value is "SIMTLOG". The zip file can contain one or more files from same or different stores. The complete file needs to be added for zip file for job to pick it for processing. Example: SIMTLOG_20180129133250.zip SIMTLOG_20180129133250.zip.complete Filename Inside Zip <file prefix>_<date in YYYYMMDDHH24MISS format>_<loc id>.dat Where file prefix value is "SIMTLOG" and loc id is the store identifier. This allows file to be unique for every upload. Example: SIMTLOG_20180129133250_1111.dat
Promotion Price Change Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <event type>_<date in YYYYMMDDHH24MISS format>_<loc type>.zip Where event type value is "PRMPC". The loc type field would be either 'S' or 'W'. The zip file can contain one or more files from same or different stores. The complete file needs to be added for zip file for job to pick it for processing. Example: PRMPC_20180129133250_S.zip PRMPC_20180129133250_S.zip.complete Filename Inside Zip <event type>_<date in YYYYMMDDHH24MISS format>_<loc id>_<loc type>.dat Where event type is "PRMPC" (promotional price change). The loc type field would be either 'S' or 'W'. Example: PRMPC_20180129133250_1111_S.dat
Regular Price Change Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <event type>_<date in YYYYMMDDHH24MISS format>_<loc type>.zip Where event type value is "REGPC". The loc type field would be either 'S' or 'W'. The zip file can contain one or more files from same or different stores. The complete file needs to be added for zip file for job to pick it for processing. Example: REGPC_20180129133250_S.zip REGPC_20180129133250_S.zip.complete Filename Inside Zip <event type>_<date in YYYYMMDDHH24MISS format>_<loc id>_<loc type>.dat Where event type is "REGPC" (regular price changes). The loc type field would be either 'S' or 'W'. Example: REGPC_20180129133250_1111_S.dat
Retail Sale Audit Import File	Notes: When Retail Sale Audit Import File from MFCS will be auto-pushed to SIOCS sFTP server directory /{sftp user} For third-party provided ReSA file, user logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <file prefix>_<date in YYYYMMDDHH24MISS format>.zip Where file prefix value is "SIMT". The zip file can contain one or more files from same or different stores. The complete file needs to be added for zip file for job to pick it for processing. Example: SIMT_20180129133250.zip SIMT_20180129133250.zip.complete Filename Inside Zip <file prefix>_<date in YYYYMMDDHH24MISS format>_<loc id>.dat Where file prefix value is "SIMT" and loc id is the store identifier. This allows file to be unique for every upload. Example: SIMT_20180129133250_1111.dat
Store Sequence Data Parser Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <file prefix>_<date in YYYYMMDDHH24MISS format>.zip Where file prefix value is "SSEQ". The zip file can contain one or more files from same or different stores. The complete file needs to be added for zip file for job to pick it for processing. Example: SSEQ_20180129133250.zip SSEQ_20180129133250.zip.complete Filename Inside Zip <file prefix>_<date in YYYYMMDDHH24MISS format>_<loc id>.dat Where file prefix value is "SSEQ" and loc id is the store identifier. This allows file to be unique for every upload. Example: SSEQ_20180129133250_1111.dat
Third Party Stock Count Parser Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <file prefix>_<date in YYYYMMDDHH24MISS format>.zip Where file prefix value is STK. The zip file can contain one or more .date files (for example, STK_20180129133250_1111.dat). The complete file needs to be added for zip file for job to pick it for processing. Example: STK_20180129133250.zip STK_20180129133250.zip.complete Filename Inside Zip <file prefix>_<date in YYYYMMDDHH24MISS format>_<loc id>.dat Where file prefix value is STK and loc id is the store identifier. This allows file to be unique for every upload. Example: STK_20180129133250_1111.dat
Warehouse Stock Import File	User logs into the SFTP server, and transfer data files to the directory: /{sftp user}/from_thirdparty	Zip Filename Format <file prefix>_<date in YYYYMMDDHH24MISS format>.zip Where file prefix value is "WHIMS". The zip file can contain one or more files. The complete file needs to be added for zip file for job to pick it for processing. Example: WHIMS_20180129133250.zip WHIMS_20180129133250.zip.complete Filename Inside Zip <file prefix>_<date in YYYYMMDDHH24MISS format>.dat Where file prefix value is "WHIMS". The prefix and date combination allows file to be unique for every upload. Example: WHIMS_20180129133250_1111.dat

File Download Directory and Filename Format

Table P-2 File Download Directory and Filename Format

Export File Name	sFTP Directory	Filename Format
Inventory Extract	User logs into the SFTP server, and download data files from directory: /{sftp user}/EXPORT/to_thirdparty	<file prefix>_<store Id>_<extract date in yyyyMMddHHmmss>.TXT Where file prefix value is PRODUCT_LOCATION_INV, store Id is the store identifier. Example: PRODUCT_LOCATION_INV_1111_20180129133250.TXT PRODUCT_LOCATION_INV_1111_20180129133250.TXT.complete
Stock Count Export File	When Stock count is unit and amount and authorization succeeded, the stock count authorize process attempts to create an export file. By default, SIOCS system stock count export file is sent to MFCS sFTP server when sftp push is enabled, and stock count export system configuration is as /<mfcsFtpUser> From where, MFCS batch will process the stock count file.	Zip Filename Format <file prefix>_<store id>_<stock count schedule date in yyyyMMddHHmmss> _<export date in yyyyMMddHHmmss>.zip Where file prefix value is STK_. The zip file can contain one or more .date files. The complete file is added for job to pick it for processing. Example: STK _1111_20180128133250_20180129133250.zip STK_1111_20180128133250_20180129133250.zip.complete Filename Inside Zip <file prefix>_<store id>_<stock count schedule date in yyyyMMddHHmmss> _<export date in yyyyMMddHHmmss>.DAT The complete file is added for job to pick it for processing. Example: STK _1111_20180128133250_20180129133250.dat