Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/CogsDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.
XSD Structure

XML-Schema Name:CogsDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for CogsDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
trans_date xs:dateTime 1 1 Idenfies the date the transaction was created. tran_data tran_date null null Yes Idenfies the date the transaction was created.
item varchar225 1 1 Unique alphanumeric value that identifies the item. This value must be a valid item in RMS. tran_data item null null Yes Unique alphanumeric value that identifies the item. This value must be a valid item in RMS.
store number10 1 1 Unique value representing the store where the cogs transaction occurred. This must be a valid store within RMS. tran_data location null null Yes Unique value representing the store where the cogs transaction occurred. This must be a valid store within RMS.
units number12_4 1 1 Contains the number of units sold. This value is also used to update the stock on hand for the store. tran_data units null null Yes Contains the number of units sold. This value is also used to update the stock on hand for the store.
header_media number5 1 1 Concatinated with line_media and put into ref_no_1 column of tran_data. Note that both fields header_media and line_media should be numeric. tran_data ref_no_1 null null Yes Concatenated with line_media and put into ref_no_1 column of tran_data. Note that both fields header_media and line_media should be numeric.
line_media number5 1 1 Concatinated with header_media and put into ref_no_1 column of tran_data. Note that both fields header_media and line_media should be numeric. tran_data ref_no_1 null null Yes Concatinated with header_media and put into ref_no_1 column of tran_data. Note that both fields header_media and line_media should be numeric.
reason_code varchar26 1 1 Valid values are 1 or 2. tran_code ref_no_2 null null Yes Valid values are 1 or 2.
supplier varchar210 0 1 Not used by RMS. n/a n/a null null No Not used by RMS.