| Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Release 22.1.103.0 F52084-02 |
|
 Previous |
 Next |
| Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Release 22.1.103.0 F52084-02 |
|
Previous |
Next |
This chapter describes the batch file layout specification.
SIMT_< YYYYMMDDHH24MISS>.zip
The zip file can contain one or more files:
SIMT_<YYYYMMDDHH24MISS>_<loc id>.dat
Where loc id is the store identifier.
Example:
SIMT_20180129133250_1111.dat
The input file would be in Pipe ('|') delimited format.
Table B-1 ReSA File Layout
| Record Name | Field Name | Field Type | Default Value | Description |
|---|---|---|---|---|
|
�FILE HEADER |
FILE Type Record Descriptor |
VARCHAR2(5) |
FHEAD |
Identifies the File Record Type |
|
FILE HEADER |
File Line ID |
VARCHAR(10) |
Sequential file line number |
|
|
FILE HEADER |
File Type Definition |
VARCHAR2(4) |
SIMT |
Identifies the File Type |
|
FILE HEADER |
Location Number |
NUMBER(10) |
Store Number |
|
|
FILE HEADER |
Business Date |
VARCHAR2(14) |
Business Date of transactions in YYYYMMDDHHSS format |
|
|
FILE HEADER |
File Creation Date |
VARCHAR2(14) |
SYSDATE |
File Create Date in YYYMMDDHHMSS format |
|
TRANSACTION HEADER |
File Type Record Descriptor |
VARCHAR2 (5) |
THEAD |
Identifies the File Record Type |
|
TRANSACTION HEADER |
File Line ID |
VARCHAR(10) |
Sequential file line number |
|
|
TRANSACTION HEADER |
Transaction Number |
NUMBER(10) |
The unique transaction reference number generated by ORXPOS/OMS |
|
|
TRANSACTION HEADER |
Register Number |
NUMBER(10) |
The register reference number generated by ORXPOS |
|
|
TRANSACTION HEADER |
Revision Number |
NUMBER(3) |
The version of the transaction being sent |
|
|
TRANSACTION HEADER |
Transaction Date and Time |
VARCHAR2(14) |
Date transactions were processed in ORXPOS/OMS |
|
|
TRANSACTION HEADER |
Transaction Type |
VARCHAR2(14) |
Transaction Type Code (for example, SALE, RETURN, SPLORD) |
|
|
TRANSACTION HEADER |
Pos created flag |
VARCHAR2(1) |
'Y' identifies that the transaction occurred at ORXPOS, 'N' identifies that the transaction was created in ReSA |
|
|
TRANSACTION DETAIL |
File Type Record Descriptor |
VARCHAR2(5) |
TDETL |
Identifies the File Record Type |
|
TRANSACTION DETAIL |
File Line ID |
VARCHAR(10) |
Sequential file line number. |
|
|
TRANSACTION DETAIL |
Item Sequence Number |
NUMBER(4) |
The order in which items were entered during a transaction |
|
|
TRANSACTION DETAIL |
Item |
VARCHAR2(25) |
ID number of the item. |
|
|
TRANSACTION DETAIL |
Item Type |
VARCHAR2(6) |
Type of Item sold. Can be 'ITEM', 'REF', 'GCN', 'NMITEM' |
|
|
TRANSACTION DETAIL |
Reference Item |
VARCHAR2(25) |
Identified sub-transaction level merchandise item. |
|
|
TRANSACTION DETAIL |
Non-Merchandise Item |
VARCHAR2(25) |
Identifies non-merchandise item |
|
|
TRANSACTION DETAIL |
Item Status |
VARCHAR2(6) |
Status of the item within the transaction, V for item void, S for sold item, R for returned item, Layaway Initiate (LIN), Layaway Cancel, Layaway Complete (LCO), Order Initiate (ORI), Order Cancel (ORC) Order Complete (ORD) |
|
|
TRANSACTION DETAIL |
Serial Number |
VARCHAR2(128) |
This is the UNIQUE_ID value from RTLOG |
|
|
TRANSACTION DETAIL |
Pack Indicator |
VARCHAR2(1) |
Pack indicator of item sold or returned |
|
|
TRANSACTION DETAIL |
Catch Weight Indicator |
VARCHAR2(1) |
Indicates if item is a catch weight item |
|
|
TRANSACTION DETAIL |
Item Quantity Sign |
VARCHAR2(1) |
Determines if the Total Sale Quantity is positive or negative 'P' - Positive 'N' - Negative |
|
|
TRANSACTION DETAIL |
Item Quantity Value |
NUMBER(20) |
Total sales value of goods sold/returned (4 implied decimal places), for example, Total Quantity * 10000 |
|
|
TRANSACTION DETAIL |
Standard UOM |
VARCHAR2(4) |
Standard UOM of the Item |
|
|
TRANSACTION DETAIL |
Selling UOM |
VARCHAR2(4) |
UOM at which this item was sold |
|
|
TRANSACTION DETAIL |
Wastage Type |
VARCHAR2(6) |
Wastage type of item sold or returned |
|
|
TRANSACTION DETAIL |
Wastage Percentage |
NUMBER(12) |
Wastage Percent*10000 (4 implied decimal places), wastage percent of item sold or returned |
|
|
TRANSACTION DETAIL |
Drop Ship Indicator |
VARCHAR2(1) |
N |
This will always be N for Export |
|
TRANSACTION DETAIL |
Actual Weight Quantity |
NUMBER(12) |
Actual Weight Quantity*10000 (4 implied decimal places), the actual weight of the item, only populated if catchweight_ind = 'Y' |
|
|
TRANSACTION DETAIL |
Reason Code |
VARCHAR2(6) |
Reason entered by cashier for some transaction types |
|
|
TRANSACTION DETAIL |
Sale Value |
NUMBER(20) |
Total Sales Value * 10000 (4 implied decimal places), sales value, net sales value of goods sold |
|
|
TRANSACTION DETAIL |
Sales Sign |
VARCHAR2(1) |
Determines if the Total Sales Value is positive or negative 'P' - Positive 'N' - Negative |
|
|
TRANSACTION DETAIL |
Unit Retail |
NUMBER(20,4) |
Unit retail with 4 implied decimal places |
|
|
TRANSACTION DETAIL |
Sales Type |
VARCHAR2(1) |
Indicates if the line item is a Regular Sale, a CO serviced by OMS (External CO), or a CO serviced by Inventory management application (In-Store CO) |
|
|
TRANSACTION DETAIL |
Customer Order Number |
VARCHAR2(50) |
Customer Order Number |
|
|
TRANSACTION DETAIL |
Customer Order Type |
Customer order type |
||
|
TRANSACTION DETAIL |
Fulfillment Order Number |
VARCHAR2(50) |
Fulfillment Order Number from OMS |
|
|
TRANSACTION TAIL |
File Record Type Descriptor |
VARCHAR2(5) |
TTAIL |
Identifies the File Record Type |
|
TRANSACTION TAIL |
File Line ID |
NUMBER(10) |
Sequential file line number |
|
|
TRANSACTION TAIL |
Transaction Record Counter |
NUMBER(6) |
Number of TDETL records in this transaction set |
|
|
FILE TAIL |
File Record Type Descriptor |
VARCHAR2(5) |
FTAIL |
Identifies the File Record Type |
|
FILE TAIL |
File Line ID |
NUMBER(10) |
Sequential file line number |
|
|
FILE TAIL |
File Record Counter |
NUMBER(10) |
Number of records/transactions processed in current file (only records between head and tail) |
The stock count result export file is generated when unit amount stock count authorization completes. The stock count authorization process can be a manual authorization or invoked by third party stock count batch for an auto-authorized unit amount stock count. This export file can be uploaded to RMS by RMS file to update their inventory with the actual physical stock count.
Table B-2 Stock Count Export File
| Record Name | Field Name | Field Type | Description |
|---|---|---|---|
|
File Header |
file type record descriptor |
Char(5) |
hardcode FHEAD |
|
File Header |
file line identifier |
Number(10) |
ID of current line being processed, hardcode 000000001 |
|
File Header |
file type |
Char(4) |
hardcode STKU |
|
File Header |
file create date |
Date(14)YYYYMMDDHHMISS |
date written by convert program |
|
File Header |
stocktake_date |
Date(14)YYYYMMDDHHMISS |
take_head.stocktake_date |
|
File Header |
cycle count |
Number(8) |
stake_head.cycle_count |
|
File Header |
loc_type |
Char(1) |
hardcode W or S |
|
File Header |
location |
Number(10) |
stake_location.wh or stake_location.store |
|
Transaction record |
file type record descriptor |
Char(5) |
hardcode FDETL |
|
Transaction record |
file line identifier |
Number(10) |
ID of current line being processed, internally incremented |
|
Transaction record |
item type |
Char(3) |
hardcode ITM |
|
Transaction record |
item value |
Char(25) |
item ID |
|
Transaction record |
inventory quantity |
Number(12,4) |
total units or total weight |
|
Transaction record |
location description |
Char(30) |
Where in the location the item exists. For example, Back Stockroom or Front Window Display |
|
File trailer |
file type record descriptor |
Char(5) |
hardcode FTAIL |
|
File trailer |
file line identifier |
Number(10) |
ID of current line being processed, internally incremented |
|
File trailer |
file record count |
Number(10) |
Number of detail records |
