| Oracle® Retail Store Inventory Management Operations Guide Release 14.0 E50034-02 |
|
 Previous |
 Next |
| Oracle® Retail Store Inventory Management Operations Guide Release 14.0 E50034-02 |
|
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|
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) |
||
|
Format Version |
Char(5) |
1.0 |
File Format Version |
|
|
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 |
||
|
Location |
Number(10) |
Location identifier |
||
|
Location Type |
Char(1) |
S = Store W = Warehouse |
||
|
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 |
||
|
Location |
Number(10) |
Location identifier |
||
|
Location Type |
Char(1) |
S = Store W = Warehouse |
||
|
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 |
Table A-5 RegularPriceChange 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 ID |
|
|
File Type |
Char(5) |
REGPC |
Regular Price Changes |
|
|
Export timestamp |
Timestamp |
System clock timestamp (YYYYMMDDHHMISS) |
||
|
Format Version |
Char(5) |
1.0 |
File Format Version |
|
|
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 |
||
|
Location |
Number(10) |
Location identifier |
||
|
Location Type |
Char(1) |
S = Store W = Warehouse |
||
|
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 |
||
|
Location |
Number(10) |
Location identifier |
||
|
Location Type |
Char(1) |
S = Store W= Warehouse |
||
|
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 |
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) |
||
|
Format Version |
Char(5) |
1.0 |
File Format Version |
|
|
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. |
||
|
TLLST |
Record Descriptor |
Char(5) |
TLLST |
Promotion Detail Component |
|
Line ID |
Number(10) |
Unique line identifier |
||
|
Location ID |
Number(10) |
Org Node [Store or Warehouse] identifier |
||
|
Location Type |
Char(1) |
Org Node Type [Store or Warehouse] |
||
|
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 |
||
|
Location ID |
Number(10) |
Org Node [Store or Warehouse] identifier |
||
|
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 |
|
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 |
||
|
Location Id |
Number(10) |
Org Node (Store or Warehouse) identifier |
||
|
Location Type |
Char(1) |
Org Node Type (Store or Warehouse). Valid values are 'S' and 'W' |
||
|
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 |
||
|
Location ID |
Number(10) |
Org Node [Store or Warehouse] identifier |
||
|
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 POS/OMS. |
||
|
Transaction Date and Time |
VARCHAR2(14) |
Date transactions were processed in POS/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 SIMT-ReSA File
| 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 POS/OMS. |
||
|
Revision Number |
NUMBER(3) |
The version of the transaction being sent. |
||
|
Transaction Date and Time |
VARCHAR2(14) |
Date transactions were processed in POS/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 POS, '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. |
|
 Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|