Skip to main content
Mar 14, 2017 12:16 AM UTC
Solved

Where are the Amount Custom fields' labels & data type stored in the database ?

Where are the Amount Custom fields' labels & data type stored in the database ?

Thanks

Regards

Nate

crose-2Answer
Mar 17, 2017 9:04 AM UTC

Hi Nate

IPCS_STOCK_AMOUNT.AMOUNTCUSTOM1 to AMOUNTCUSTOM15. If you run out of fields then you can create additional ones using IPCSCUST_STOCK_AMOUNTS using the 'Create Custom Attributes' feature in the UI.

Regards

Chris

4 replies

crose-2Answer
Mar 17, 2017 9:04 AM UTC

Hi Nate

IPCS_STOCK_AMOUNT.AMOUNTCUSTOM1 to AMOUNTCUSTOM15. If you run out of fields then you can create additional ones using IPCSCUST_STOCK_AMOUNTS using the 'Create Custom Attributes' feature in the UI.

Regards

Chris

Mar 17, 2017 9:49 PM UTC

Thanks Chris ! to add to that the labels for those fields are stored in IPCS_CUSTOM_LABELS

The Amount Custom fields in IPCS_STOCK_AMOUNT table are of “nvarchar” type with size of 80 and can be null

Apr 20, 2017 12:49 PM UTC

Hi Nate

Did you sort this out?

Regards

Chris