itemLocationConfiguration
The ItemLocationConfiguration table.
Columns
Name | Type | Description |
id [KEY] | Integer | Internal ID |
advancewarningthreshold | Integer | AdvanceWarningThreshold |
atpleadtime | Integer | Atpleadtime |
backwardconsumptiondays | Integer | Backwardconsumptiondays |
buildtime | Double | Buildtime |
cost | Decimal | Cost |
costinglotsize | Double | Costinglotsize |
customform | String | Customform |
defaultreturncost | Decimal | Defaultreturncost |
demandsource | String | Demandsource |
demandtimefence | Integer | Demandtimefence |
externalid | String | Externalid |
fixedlotsize | Double | Fixedlotsize |
forwardconsumptiondays | Integer | Forwardconsumptiondays |
inventorycosttemplate | String | Inventorycosttemplate |
invtclassification | String | Invtclassification |
invtcountinterval | Integer | Invtcountinterval |
isautolocassignmentallowed | Boolean | Isautolocassignmentallowed |
isautolocassignmentsuspended | Boolean | Isautolocassignmentsuspended |
iswip | Boolean | Iswip |
item | String | Item |
latedemandthreshold | Double | Latedemandthreshold |
leadtime | Integer | Leadtime |
location | String | Location |
locationallowstorepickup | Boolean | Locationallowstorepickup |
locationstorepickupbufferstock | Integer | Locationstorepickupbufferstock |
memo | String | Memo |
minimumrescheduledays | Integer | Minimumrescheduledays |
name | String | Name |
nextinvtcountdate | Date | Nextinvtcountdate |
pastdueforecastdays | Integer | Pastdueforecastdays |
periodiclotsizedays | Integer | Periodiclotsizedays |
periodiclotsizetype | String | Periodiclotsizetype |
poreceiptcost | Decimal | Poreceiptcost |
preferredstocklevel | Double | Preferredstocklevel |
reorderpoint | Double | Reorderpoint |
rescheduleindays | Integer | Rescheduleindays |
rescheduleoutdays | Integer | Rescheduleoutdays |
safetystocklevel | Double | Safetystocklevel |
savedleadtime | Integer | Savedleadtime |
savedpreferredstocklevel | Double | Savedpreferredstocklevel |
savedreorderpoint | Double | Savedreorderpoint |
subsidiary | String | Subsidiary |
supplylotsizingmethod | String | Supplylotsizingmethod |
supplytimefence | Integer | Supplytimefence |
supplytype | String | Supplytype |
templatestored | Boolean | Templatestored |