Oracle® Retail Store Inventory Management Operations Guide Release 15.0 E65670-03 |
|
Previous |
Next |
This chapter describes the batch file layout specification.
This section includes the import file layout specification.
DEX/NEX uses the EDI Standard 894 Transaction Set to communicate with the direct delivery receiving system. The basic format for the file is as shown in Table A-1:
Table A-1 DexnexFileParser Batch File Structure
Header | |
---|---|
ST = Transaction Set Header G82 = Delivery/Return Base Record N9 = Reference Identification |
|
Detail (repeating…) LS = Loop Header G83 = Line Item Detail DSD G72 = Allowance or Charge at Detail Level LE = Loop Trailer |
|
Summary G84 = Delivery/Return Record Totals G86 = Signature G85 = Record Integrity Check SE = Transaction Set Trailer |
ST – Contains the transaction set number (for example, 894) and a control number.
G82 – Contains the type of delivery (Delivery or Return), supplier information, and delivery date.
N9 – Contains additional supplier information (Canada only).
LS – Contains an ID for the details loops to follow.
G83 – Contains the item #, quantity, UOM, unit cost, and item description.
G72 – Contains allowance (for example, 10% off) or charge (for example, environmental levy) information.
LE – Contains the loop trailer.
G84 – Contains the total quantity and cost of the delivery.
G86 – Contains the suppliers UCC signature.
G85 – Contains an authentication identifier.
SE – Contains the number of transactions in the transmission.
Table A-2 provides details of the DexnexFileParser batch file:
Table A-2 DexnexFileParser Batch File Details
Segment | Sub-Segment | Name | Required? | SIM value |
---|---|---|---|---|
ST |
Transaction Set Header |
Yes |
||
ST |
ST01 |
Transaction Set ID Code |
Yes |
894 - identifies the EDI file type, use to validate. |
ST |
ST02 |
Transaction Set Control # |
Yes |
Ignore |
G82 |
Delivery/Return Base Record |
Yes |
||
G82 |
G8201 |
Credit/Debit Flag Code |
Yes |
D=Delivery, C=Return. |
G82 |
G8202 |
Supplier's Delivery/Return Number |
Yes |
Use as supplier's purchase order number. |
G82 |
G8203 |
DUNS Number |
Yes |
Ignore |
G82 |
G8204 |
Receiver's Location Number |
Yes |
Contains the Store # |
G82 |
G8205 |
DUNS Number |
Yes |
Supplier's DUNS Number - use to determine supplier |
G82 |
G8206 |
Supplier's Location Number |
Yes |
Supplier's DUNS Location - use with DUNS Number to determine supplier |
G82 |
G8207 |
Delivery/Return Date |
Yes |
Delivery Date |
N9 |
Reference Identification |
No |
||
N9 |
N901 |
Reference Identifier Qualifier |
Yes |
Ignore |
N9 |
N902 |
Reference Number |
Yes |
Use as SIM invoice number |
N9 |
N903 |
Free-Form Description |
No |
Ignore |
LS |
LS01 |
Loop Header |
Yes |
Provides an ID for the loop to follow in the file |
G83 |
Line Item Detail |
Yes |
||
G83 |
G8301 |
DSD Number |
Yes |
Ignore |
G83 |
G8302 |
Quantity |
Yes |
Unit Quantity |
G83 |
G8303 |
Unit of Measure Code |
Yes |
CA = Case, EA = Each |
G83 |
G8304 |
UPC Item Number |
||
G83 |
G8305 |
Product ID Qualifier |
||
G83 |
G8306 |
Product ID Number |
||
G83 |
G8307 |
UPC Case Code |
No |
Pack Number |
G83 |
G8308 |
Item List Cost |
No |
Unit Cost |
G83 |
G8309 |
Pack |
No |
|
G83 |
G8310 |
Cash Register Description |
No |
Ignore |
G72 |
Allowance or Charge at Detail Level |
No |
Ignore |
|
G72 |
G7201 |
Allowance or Charge Code |
Ignore |
|
G72 |
G7202 |
Allowance/Charge Handling Code |
Ignore |
|
G72 |
G7203 |
Allowance or Charge Number |
Ignore |
|
G72 |
G7205 |
Allowance/Charge Rate |
Ignore |
|
G72 |
G7206 |
Allowance/Charge Quantity |
Ignore |
|
G72 |
G7207 |
Unit of Measure Code |
Ignore |
|
G72 |
G7208 |
Allowance/Charge Total Amount |
Ignore |
|
G72 |
G7209 |
Allowance/Charge Percent |
Ignore |
|
G72 |
G7210 |
Dollar Basis for Allow/Charge % |
Ignore |
|
LE |
LE01 |
Loop Identifier |
Loop Trailer, will contain same ID as loop header |
|
G84 |
Delivery/Return Record Totals |
Yes |
||
G84 |
G8401 |
Quantity |
Yes |
Sum of all G8302 values |
G84 |
G8402 |
Total Invoice Amount |
Yes |
Total Cost, inclusive of charges and net of allowances. |
G86 |
G8601 |
Signature |
Yes |
Ignore |
G85 |
G8501 |
Integrity Check Value |
Yes |
Ignore |
SE |
SE01 |
Number of Included Segments |
Yes |
Total # of segments between ST and SE, used for validation |
SE |
SE02 |
Transaction Set Control # |
Yes |
Same as ST02, used for validation |
GE |
GE01 |
Number of transaction sets included |
Yes |
# of sets in functional group, used for validation |
GE |
GE02 |
Group Control Number |
Yes |
Same as GS06, used for validation |
Third Party Stock Count Import File Format:
Pipe-delimited ( | ) file contains store count data for a store and stock count ID as shown in Table A-3:
Table A-3 Third Party Stock Count Import File
Record Name | Field Name | Field Type | Default Value | Description |
---|---|---|---|---|
FHEAD |
Record Descriptor |
Char(5) |
FHEAD |
File head marker |
Store Number |
Char(10) |
Store number file was uploaded for. It is assumed only one store is passed in per file. (Required) |
||
Stock Count ID |
Number(12) |
Unique identifier for item. Assumption is SIM will always take first stock count ID listed. (Required) |
||
FDETL |
Record Descriptor |
Char(5) |
FDETL |
Detail record marker. |
Stock Count Date |
Date(14) |
Indicates date/time item was physically counted by the third party. (YYYYMMDDHH24MISS) For example, 20091019134600 (Required) Note: If not using timestamp, use 00 for time. |
||
Area Number |
Char(10) |
10-digit code indicating where in the store the item is located. (Optional) |
||
UPC or Item Number |
Char(25) |
25-digit universal product code. (Required) |
||
Count Quantity |
Number (12,4) |
Quantity counted for item, required. This field must allow for decimals when counting in UOM other than each. (Required) |
||
UIN(Item Serial Number) |
Char(128) |
Unique identification serial number for item, required if current item requires serial number. |
||
FTAIL |
Record Descriptor |
Char(5) |
FTAIL |
File tail marker. |
The following is a sample Third Party Stock Count Import File:
FHEAD|5000|1074| FDETL|20091014235959|1|100665085|1|ItemSerialNum1234| FDETL|20091014140000|1|100665085|1|ItemSerialNum9999| FDETL|20091014000000|1|100665085|1|| FTAIL|
Filename Format
<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'.
File Record Types:
FHEAD (required): File identification, one line per file.
FDETL (optional): Price Change Event (Create or Modify).
FDELE (optional): Price Change Event (Delete).
FTAIL (required): End of file marker, one line per file.
Table A-4 ClearancePriceChange File Layout
Record Name | Field Name | Field Type | Default Value | Description |
---|---|---|---|---|
FHEAD |
Record Descriptor |
Char(5) |
FHEAD |
File head marker |
Line ID |
Number(10) |
1 |
Unique line ID |
|
File Type |
Char(5) |
CLRPC |
Clearance Price Changes |
|
Export timestamp |
Timestamp |
System clock timestamp (YYYYMMDDHHMISS) |
||
Location |
Number(10) |
Location identifier |
||
Location Type |
Char(1) |
S = Store, W = Warehouse |
||
FDETL |
Record Descriptor |
Char(5) |
FDETL |
File Detail Marker (one per clearance create or modify) |
Line ID |
Number(10) |
Unique line ID |
||
Event Type |
Char(3) |
CRE = Create MOD = Modify |
||
ID |
Number(15) |
Clearance identifier |
||
Item |
Char(25) |
Item identifier |
||
Effective Date |
Date |
Clearance Effective Date (YYYMMDDHHMISS) |
||
Selling Retail |
Number(20,4) |
Selling retail with price change applied |
||
Selling Retail UOM |
Char(4) |
Selling retail unit of measure |
||
Selling Retail Currency |
Char(3) |
Selling retail currency |
||
Reset Clearance ID |
Number(15) |
ID of clearance reset |
||
FDELE |
Record Descriptor |
Char(5) |
FDELE |
File Detail Delete Marker (one per clearance delete) |
Line ID |
Number(10) |
Unique line ID |
||
ID |
Number(15) |
Clearance identifier |
||
Item |
Char(25) |
Item identifier |
||
FTAIL |
Record Descriptor |
Char(5) |
FTAIL |
File tail marker |
Line ID |
Number(10) |
Unique line ID |
||
Number of lines |
Number(10) |
Number of lines in file not counting FHEAD and FTAIL |
Filename Format<event type>_<date in YYYYMMDDHH24MISS format>_<loc id>_<loc type>.datWhere event type is "REGPC" (regular price changes). The loc type field would be either 'S' or 'W'.
Files Record Types:
FHEAD (required): File identification, one line per file.
FDETL (optional): Price Change Event (Create or Modify).
FDELE (optional): Price Change Event (Delete).
FTAIL (required): End of file marker, one line per file.
Table A-5 RegularPriceChange File Layout
Record Name | Field Name | Field Type | Default Value | Description |
---|---|---|---|---|
FHEAD |
Record Descriptor |
Char(5) |
FHEAD |
File head marker |
Line ID |
Number(10) |
1 |
Unique line ID |
|
File Type |
Char(5) |
REGPC |
Regular Price Changes |
|
Export timestamp |
Timestamp |
System clock timestamp (YYYYMMDDHHMISS) |
||
Location |
Number(10) |
Location identifier |
||
Location Type |
Char(1) |
S = Store W= Warehouse |
||
FDETL |
Record Descriptor |
Char(5) |
FDETL |
File Detail Marker (one per price change create or modify) |
Line ID |
Number(10) |
Unique line ID |
||
Event Type |
Char(3) |
CRE = Create MOD = Modify |
||
ID |
Number(15) |
Price Change identifier |
||
Item |
Char(25) |
Item identifier |
||
Effective Date |
Date |
Effective Date of price change (YYYYMMDDHHMISS) |
||
Selling Unit Change Ind |
Number(1) |
Did selling unit retail change with this price event (0 = no change, 1 = changed) |
||
Selling Retail |
Number(20,4) |
Selling retail with price change applied |
||
Selling Retail UOM |
Char(4) |
Selling retail unit of measure |
||
Selling Retail Currency |
Char(3) |
Selling retail currency |
||
Multi-Unit Change Ind |
Number(1) |
Did multi unit retail change with this price event (0 = no change, 1 = changed) |
||
Multi-Units |
Number(12,4) |
Number Multi Units |
||
Multi-Unit Retail |
Number(20,4) |
Multi Unit Retail |
||
Multi-Unit UOM |
Char(4) |
Multi Unit Retail Unit Of Measure |
||
Multi-Unit Currency |
Char(3) |
Multi Unit Retail Currency |
||
FDELE |
Record Descriptor |
Char(5) |
FDELE |
File Detail Delete Marker (one per price change delete) |
Line ID |
Number(10) |
Unique line ID |
||
ID |
Number(15) |
Price Change identifier |
||
Item |
Char(25) |
Item identifier |
||
FTAIL |
Record Descriptor |
Char(5) |
FTAIL |
File tail marker |
Line ID |
Number(10) |
Unique line ID |
||
Number of lines |
Number(10) |
Number of lines in file not counting FHEAD and FTAIL |
Filename Format
<event type>_<date in YYYYMMDDHH24MISS format>_<loc id>_<loc type>.datWhere event type is ”PRMPC” (promotions). The loc type field would be either ’S' or ’W'.
File Record Types
FHEAD (required): File identification, one line per file.
TMBPE (optional): Event Type.
TPDTL (required): Promotion Component Detail.
TPGRP (required): Promotion Group (one or more per TPDTL).
TGLST (required): Promotion List (one or more per TPGRP).
TLITM (required): Promotion Item (one or more per TGLST).
TPDSC (required): Promotion Discount (one or more per TGLST).
TPISR (optional): Promotion Item Selling retail (one or more per TPDTL).
TPCDT (optional): Promotion Credit Detail (one or more per TPDTL).
TTAIL (required): Transaction tail (one per promotion).
TPCIL (optional): Promotion Cancel Item Location
FPDEL (optional): Promotion Delete.
FTAIL (required): End of file marker, one line per file.
Table A-6 PromotionPriceChange Output File Layout
Record Name | Field Name | Field Type | Default Value | Description |
---|---|---|---|---|
FHEAD |
Record Descriptor |
Char(5) |
FHEAD |
File head marker |
Line ID |
Number(10) |
1 |
Unique line Identifier |
|
File Type |
Char(5) |
PROMO |
Promotions |
|
Export timestamp |
Timestamp |
System clock timestamp (YYYYMMDDHHMISS) |
||
Location |
Number(10) |
Location identifier |
||
Location Type |
Char(1) |
S = Store, W = Warehouse |
||
TMBPE |
Record Descriptor |
Char(5) |
TMBPE |
Promotion (transaction head) |
Line ID |
Number(10) |
Unique line identifier |
||
Event Type |
Char(3) |
CRE = Create MOD= Modify |
||
TPDTL |
Record Descriptor |
Char(5) |
TPDTL |
Promotion Detail Component |
Line ID |
Number(10) |
Unique line identifier |
||
Promo ID |
Number(10) |
Promotion identifier |
||
Promo Comp ID |
Number(10) |
Promotion Component ID |
||
Promo Name |
Char(160) |
Promotion Header Name |
||
Promo Desc |
Char(640) |
Promotion Header Description |
||
Promo Comp Desc |
Char(160) |
Promotion Component Name |
||
Promo Type |
Number(2) |
Valid values will be modified to be as follows: 0 - Multi-Buy Promotion; 1 - Simple Promotion; 2 - Threshold Promotion; 3 - Finance Promotion (formerly tied to a value of 6); 4 - Transaction Promotion |
||
Promo Comp Detail ID |
Number(10) |
Promotion Component Detail identifier |
||
Start Date |
Date |
Start Date of Promotion Component Detail (YYYYMMDDHH24MISS) |
||
End Date |
Date |
End Date of Promotion Component Detail (YYYYMMDDHH24MISS) |
||
Apply To Code |
Number(1) |
Holds the apply to code for the promotion detail. Determines if the promotion is applied to regular retail only (no clearances in effect), clearance retail only (only when a clearance is in effect) or both regular and clearance retail. Valid values are 0 - Regular Only; 1 - Clearance Only; 2 - Regular and Clearance. |
||
Discount Limit |
Number(3) |
The number of times that the promotion that can be applied to a transaction. |
||
Apply Order |
Number(1) |
Application Order of the Promotion |
||
Threshold ID |
Number(6) |
Threshold identifier |
||
Customer Type ID |
Number(10) |
Customer Type identifier |
||
Threshold Qualification Type |
Number(1) |
The qualification type for the threshold. Will only be populated for threshold promotions. Valid values are 0 for item level and 1 for threshold level. |
||
Exception Parent ID |
Number(10) |
The promotion component detail ID for the parent event that this event is a child to. Used only for transaction promotion detail exclusions to be able to connect the child exclusion to it's parent promotion detail. |
||
TPGRP |
Record Descriptor |
Char(5) |
TPGRP |
Promotion Detail Group |
Line ID |
Number(10) |
Unique line identifier |
||
Group ID |
Number(10) |
Group Number |
||
TGLIST |
Record Descriptor |
Char(5) |
TGLIST |
Promotion Group List |
Line ID |
Number(10) |
Unique line identifier |
||
List ID |
Number(10) |
List identifier |
||
Reward Application |
Number(1) |
How this reward is applied to the promotion detail. |
||
Description |
Char(120) |
Description |
||
Price Range Min |
Number (20,4) |
Contains price range promotion minimum valid retail value. |
||
Price Range Max |
Number (20,4) |
Contains price range promotion maximum valid retail value. |
||
TLITM |
Record Descriptor |
Char(5) |
TLITM |
Promotion Group List |
Line ID |
Number(10) |
Unique line identifier |
||
Item ID |
Char(25) |
Transaction Item Identifier |
||
TPDSC |
Record Descriptor |
Char(5) |
TPDSC |
Discount Detail for List |
Line ID |
Number(10) |
Unique line identifier |
||
Change Type |
Number(2) |
Change Type |
||
Change Amount |
Number(20,4) |
Change Amount |
||
Change Currency |
Char(3) |
Change Currency |
||
Change Percent |
Number(20,4) |
Change Percent |
||
Change Selling UOM |
Char(4) |
Change Selling UOM |
||
Qual Type |
Number(2) |
Qualification Type |
||
Qual Value |
Number(2) |
Qualification Value |
||
Change Duration |
Number(20,4) |
Change Duration |
||
TPILSR |
Record Descriptor |
Char(5) |
TPILSR |
Items in Promotion |
Line ID |
Number(10) |
Unique line identifier |
||
Item ID |
Char(25) |
TTAIL |
Transaction Item Identifier |
|
Selling Retail |
Number(20,4) |
Selling retail of the item |
||
Selling UOM |
Char(4) |
Selling UOM of the item |
||
Effective Date |
Date |
Effective Date of the selling retail - YYYYMMDDHH24MISS |
||
Selling Retail Currency |
Char(3) |
Selling retail currency |
||
TPCDT |
Record Descriptor |
Char(5) |
TPCDT |
Credit Detail |
Credit Detail ID |
Number(10) |
Credit Detail ID |
||
Line ID |
Number(10) |
Unique line ID |
||
Credit Type |
Char(40) |
Credit Type |
||
binNumberFrom |
Number(10) |
BinNumber From |
||
binNumberTo |
Number(10) |
Bin Number To |
||
Commission Rate |
Number(10) |
Commission Rate |
||
Comments |
Char(160) |
Comments |
||
TTAIL |
Record Descriptor |
Char(5) |
TTAIL |
Transaction Tail |
Line ID |
Number(10) |
Unique line identifier |
||
TPCIL |
Record Descriptor |
Char(5) |
TPCIL |
Cancel Item Loc |
Line ID |
Number(10) |
Unique line identifier |
||
Promo ID |
Number(10) |
The ID of the promotion |
||
Promo Comp ID |
Number(10) |
Promotion Component ID |
||
Promo Comp Detail ID |
Number(10) |
Promotion Component Detail identifier |
||
Item ID |
Char(25) |
Transaction Item Identifier for item |
||
Cancellation Date |
Date |
Cancellation effective date - YYYYMMDDHH24MISS |
||
FPDEL |
Record Descriptor |
Char(5) |
FPDEL |
Delete Promotion |
Line ID |
Number(10) |
Unique line identifier |
||
Promo ID |
Number(10) |
The ID of the promotion |
||
Promo Comp ID |
Number(10) |
Promotion Component ID |
||
Promo Comp Detail ID |
Number(10) |
Promotion Component Detail ID |
||
Group ID |
Number(10) |
Group Number |
||
List ID |
Number(10) |
List ID |
||
Item ID |
Char(25) |
Transaction Item Identifier for item |
||
FTAIL |
Record Descriptor |
Char(5) |
FTAIL |
File tail marker |
Line ID |
Number(10) |
Unique line identifier |
||
Number of lines |
Number(10) |
Number of lines in file not counting FHEAD and FTAIL |
The input file would be in Pipe ('|') delimited format.
Table A-7 SIMT-LOG file
Record Name | Field Name | Field Type | Default Value | Description |
---|---|---|---|---|
FILE HEADER |
FILE HEADER File Type Record Descriptor |
VARCHAR2(5) |
FHEAD |
Identifies the File Record Type |
Location Number |
NUMBER(10) |
Store Number |
||
Business Date |
VARCHAR2(14) |
Business Date of transactions in YYYYMMDDHHSS format |
||
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 Number |
VARCHAR2(128) |
The unique transaction reference number generated by ORXPOS/OMS. |
||
Transaction Date and Time |
VARCHAR2(14) |
Date transactions were processed in ORXPOS/OMS |
||
Customer Order ID |
VARCHAR2(128) |
External customer order ID, if transaction is a customer order |
||
Customer Order Comments |
VARCHAR(512) |
Comments on the customer order |
||
TRANSACTION DETAIL |
File Type Record Descriptor |
VARCHAR2(5) |
TDETL |
Identifies the File Record Type |
Item ID |
VARCHAR2(25) |
ID number of the item. |
||
UIN |
VARCHAR2(128) |
This is the UNIQUE_ID value from RTLOG |
||
Item Quantity |
NUMBER(12,4) |
Quantity of the item on this transaction |
||
Selling UOM |
VARCHAR2(4) |
UOM at which this item was sold |
||
Reason Code |
NUMBER(4) |
Reason entered by cashier for some transaction types. Required for voids, returns, for example. |
||
Comments |
VARCHAR(512) |
Comments for this line item |
||
Transaction Code |
VARCHAR2(25) |
The type of sale represented by this line item. Valid value are SALE,RETURN,VOID_SALE,VOID_RETURN,ORDER_NEW,ORDER_FULFILL,ORDER_CANCEL,ORDER_CANCEL_FULFILL |
||
Reservation Type |
VARCHAR(25) |
Reservation type if POS transaction is a customer order. Valid values are SPECIAL_ORDER, WEB_ORDER, PICKUP_AND DELIVERY,LAYAWAY |
||
Fulfillment Order Number |
VARCHAR2(48) |
Fulfillment Order Number from OMS |
||
Drop Ship Indicator |
VARCHAR(1) |
'P' if it is drop ship otherwise 'N' |
||
TRANSACTION TAIL |
File Record Type Descriptor |
VARCHAR2(5) |
TTAIL |
Identifies the File Record Type |
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 Record Counter |
NUMBER(10) |
Number of records/transactions processed in current file (only records between head and tail) |
The input file would be in Pipe ('|') delimited format.
Table A-8 SIM-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 Line ID |
VARCHAR(10) |
Sequential file line number |
||
File Type Definition |
VARCHAR2(4) |
SIMT |
Identifies the File Type |
|
Location Number |
NUMBER(10) |
Store Number |
||
Business Date |
VARCHAR2(14) |
Business Date of transactions in YYYYMMDDHHSS format |
||
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 |
File Line ID |
VARCHAR(10) |
Sequential file line number |
||
Transaction Number |
NUMBER(10) |
The unique transaction reference number generated by ORXPOS/OMS |
||
Register Number |
NUMBER(10) |
The register reference number generated by ORXPOS |
||
Revision Number |
NUMBER(3) |
The version of the transaction being sent |
||
Transaction Date and Time |
VARCHAR2(14) |
Date transactions were processed in ORXPOS/OMS |
||
Transaction Type |
VARCHAR2(14) |
Transaction Type Code (for example, SALE, RETURN, SPLORD) |
||
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 |
File Line ID |
VARCHAR(10) |
Sequential file line number. |
||
Item Sequence Number |
NUMBER(4) |
The order in which items were entered during a transaction |
||
Item |
VARCHAR2(25) |
ID number of the item. |
||
Item Type |
VARCHAR2(6) |
Type of Item sold. Can be 'ITEM', 'REF', 'GCN', 'NMITEM' |
||
Reference Item |
VARCHAR2(25) |
Identified sub-transaction level merchandise item. |
||
Non-Merchandise Item |
VARCHAR2(25) |
Identifies non-merchandise item |
||
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) |
||
Serial Number |
VARCHAR2(128) |
This is the UNIQUE_ID value from RTLOG |
||
Pack Indicator |
VARCHAR2(1) |
Pack indicator of item sold or returned |
||
Catch Weight Indicator |
VARCHAR2(1) |
Indicates if item is a catchweight item |
||
Item Quantity Sign |
VARCHAR2(1) |
Determines if the Total Sale Quantity is positive or negative 'P' - Positive 'N' - Negative |
||
Item Quantity Value |
NUMBER(20) |
Total sales value of goods sold/returned (4 implied decimal places), for example, Total Quantity * 10000 |
||
Standard UOM |
VARCHAR2(4) |
Standard UOM of the Item |
||
Selling UOM |
VARCHAR2(4) |
UOM at which this item was sold |
||
Wastage Type |
VARCHAR2(6) |
Wastage type of item sold or returned |
||
Wastage Percentage |
NUMBER(12) |
Wastage Percent*10000 (4 implied decimal places), wastage percent of item sold or returned |
||
Drop Ship Indicator |
VARCHAR2(1) |
N |
This will always be N for SIM Export |
|
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' |
||
Reason Code |
VARCHAR2(6) |
Reason entered by cashier for some transaction types |
||
Sale Value |
NUMBER(20) |
Total Sales Value * 10000 (4 implied decimal places), sales value, net sales value of goods sold |
||
Sales Sign |
VARCHAR2(1) |
Determines if the Total Sales Value is positive or negative 'P' - Positive 'N' - Negative |
||
Unit Retail |
NUMBER(20,4) |
Unit retail with 4 implied decimal places |
||
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 SIM (In-Store CO) |
||
Customer Order Number |
VARCHAR2(50) |
Customer Order Number |
||
Customer Order Type |
Customer order type |
|||
Fulfillment Order Number |
VARCHAR2(50) |
Fulfillment Order Number from OMS |
||
TRANSACTION TAIL |
File Record Type Descriptor |
VARCHAR2(5) |
TTAIL |
Identifies the File Record Type |
File Line ID |
NUMBER(10) |
Sequential file line number |
||
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 Line ID |
NUMBER(10) |
Sequential file line number |
||
File Record Counter |
NUMBER(10) |
Number of records/transactions processed in current file (only records between head and tail) |
The input file will have the following comma-separated values:
Table A-9 UIN Attribute File
Record Name | Field Name | FieldType | Default Value | Description |
---|---|---|---|---|
1 |
Store ID |
Number |
NA |
ID of the Store, for example, 1111 |
2 |
Department ID |
Number |
NA |
ID of the Department, for example, 2222 |
3 |
Class ID |
Number |
NA |
ID of the Class, for example, 2 |
4 |
Type |
Varchar2 |
NA |
Type of UIN, for example, Serial Number |
5 |
Label |
Varchar2 |
NA |
Label of UIN, for example, Serial Number |
6 |
Capture_Time_ID |
Number |
NA |
Capture Time ID, for example, 2 |
7 |
External_Create_Allowed |
Varchar2 |
NA |
External Create Allowed or not, for example, Y or N |
The following is a sample input file:
3000,3023,2,'Auto Generate SN','Serial Number',2,False
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 A-10 SIMT-ReSA File
Record Name | Field Name | Field Type | Description |
---|---|---|---|
File Header |
file type record descriptor |
Char(5) |
hardcode FHEAD |
file line identifier |
Number(10) |
ID of current line being processed, hardcode 000000001 |
|
file type |
Char(4) |
hardcode STKU |
|
file create date |
Date(14)YYYYMMDDHHMISS |
date written by convert program |
|
stocktake_date |
Date(14)YYYYMMDDHHMISS |
take_head.stocktake_date |
|
cycle count |
Number(8) |
stake_head.cycle_count |
|
loc_type |
Char(1) |
hardcode W or S |
|
location |
Number(10) |
stake_location.wh or stake_location.store |
|
Transaction record |
file type record descriptor |
Char(5) |
hardcode FDETL |
file line identifier |
Number(10) |
ID of current line being processed, internally incremented |
|
item type |
Char(3) |
hardcode ITM |
|
item value |
Char(25) |
item ID |
|
inventory quantity |
Number(12,4) |
total units or total weight |
|
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 line identifier |
Number(10) |
ID of current line being processed, internally incremented |
|
file record count |
Number(10) |
Number of detail records |
The input file would be in pipe ('|') delimited format.
Table A-11 StoreSequenceImport File
Record Name | Field Name | FieldType | Description |
---|---|---|---|
File Header |
file type record descriptor |
Char(5) |
hardcode FHEAD |
Store ID |
Number(10) |
Store identifier |
|
Sequence record |
file type record descriptor |
Char(5) |
hardcode SHEAD |
Area type |
Number(9) |
The Store Sequence Area. 0 = None, 1 = Shopfloor, 2 = Backroom |
|
Child sequenced |
Varchar2(1) |
’Y' if child is sequenced, ’N' if not |
|
Department ID |
Number(12) |
Department ID |
|
Class ID |
Number(12) |
Class ID |
|
Description |
Varchar2(255) |
Description of Store Sequence |
|
Not sequenced |
Varchar2(1) |
The order the store sequence is in compared to other store sequences |
|
Sequence Order |
Number(20) |
Y indicates a default sequence containing all items that have not been sequenced elsewhere |
|
Sequence detail |
file type record descriptor |
Char(5) |
hardcode SDETL |
Item ID |
Varchar2(25) |
Item ID |
|
Primary location |
Varchar2(1) |
Indicator if the location specified is the primary location for the item, Y if is primary location for item, N otherwise |
|
Item sequence order |
Number(20) |
Order of item within store sequence |
|
Capacity |
Number(11,2) |
The size of the location appropriate to unit of measure |
|
Ticket quantity |
Number(11,2) |
The quantity of tickets that need to be printed or used for the item inventory location |
|
Ticket format ID |
Number(10) |
Item ticket format identifier |
|
Uom mode |
Number(2) |
The Unit Of Measure display mode: 1 = Units, 2 = Cases |
|
Width |
Number(12) |
Width value to indicate how many items can fit across the width of the shelf |
|
Sequence trailer |
File type record descriptor |
Char(5) |
hardcode STAIL |
File trailer |
File type record descriptor |
Char(5) |
hardcode FTAIL |