product
Defines the product being produced by the events.
The fields in the product table are listed in the following table.
| Field | Type | Comments |
|---|---|---|
product_cd |
string(50) | Required |
product_name |
string(200) | Required |
language_cd |
string(50) | Optional. This value must reference a row in the language table. |
tenant_cd |
string(50) | Optional. This value must reference a row in the tenant table. |
IS_ACTIVE |
0 or 1 | Optional. A value of 0 indicates that the record is inactive. No value, or a value of 1, indicates that the record is active. |
product code snippet
You can use the following SQL Code snippet to retrieve master data in the format that is required by the upsert API.
For example, if you lost the original files that are used to load master data, you can use the snippet to retrieve the data, make changes, and submit the changes by using the upsert API.
The command must be on a single line, not as shown here.
SELECT M.PRODUCT_CD, M.PRODUCT_NAME, L.LANGUAGE_CD, T.TENANT_CD, M.ISACTIVE FROM
SYSREC.MASTER_PRODUCT M JOIN SYSREC.LANGUAGE L ON M.LANGUAGE_ID =
L.LANGUAGE_ID JOIN SYSREC.TENANT T ON M.TENANT_ID = T.TENANT_ID;