Importing Company Apex sales numbers into Plant Focus from database table.
The database table will have the following columns
Column | Description |
|---|---|
DATA_DATE | date data was inserting into the transfer table |
COMPANY | company |
LOCATIONID | Specifies location by numeric value. |
PRODUCTID | Unique productid that can be used to relate directly to a Plant Focus DOR Item. |
MOD_DATE | MOD_DATE – distinct per productid and date |
LOAD_DATE | LOAD_DATE - distinct per productid and date, this will be the date that is saved to Plant Focus DOR item. |
SITE | description of locationid |
PRODUCT | description of productid |
SELLORBUY | this data has values (S, T) but the data appears to be distinct with only productid as the transfer and sold “products” are distinct. It is assumed S is sold and should be treated as a negative number and T is transferred and should be treated as a positive number when it is at a terminal and treated as a negative number when it is at a Plant or Production Facility. |
TONS | tons |
Expected payload for the day
...
One data point for each day with the timestamp matching the date/time format yyyy-MM-dd 00:00:00.000 will denote the value for that day.
This value will be uniquely identified by the PRODUCTID for purposes of linking that specific item to a DOR item inside of Plant Focus.
Values will be available at a given time range each day for consumption.
...