trans_date |
tran_data |
tran_date |
Yes |
Idenfies the
date the transaction was created. |
item |
tran_data |
item |
Yes |
Unique
alphanumeric value that identifies the item. This value must be a valid
item in RMS. |
store |
tran_data |
location |
Yes |
Unique value
representing the store where the cogs transaction occurred. This must be a
valid store within RMS. |
units |
tran_data |
units |
Yes |
Contains the
number of units sold. This value is also used to update the stock on hand
for the store. |
header_media |
tran_data |
ref_no_1 |
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 |
tran_data |
ref_no_1 |
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 |
tran_code |
ref_no_2 |
Yes |
Valid values are
1 or 2. |
supplier |
n/a |
n/a |
No |
Not used by
RMS. |