|
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
|
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.
|
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
|