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