Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing 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.

XML-Schema Name:CogsDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For CogsDesc
Table Name Column Name API Type Column Length API Required 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.
ExtOfCogsDesc:ExtOfCogsDesc * 0 1 Provide an extension hook to customize CogsDesc. NA NA NA NA NA NA
LocOfCogsDesc:LocOfCogsDesc * 0 1 Provide an extension hook to localize CogsDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfCogsDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfCogsDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfCogsDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfCogsDesc
Table Name Column Name API Type Column Length API Required API Description
InCogsDesc:InCogsDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrCogsDesc:BrCogsDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA