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
|