Part

A Part is a basic element of replenishment and rough cut capacity scheduling.

Column Name
Type
Max Length
Required
Values

PartNumber

text

50

Yes

The combination of PartNumber, Revision, and Location must be unique.

Revision

text

10

No

Location

text

32

No

Description

text

250

No

UnitOfMeasure

text

20

No

PartType

integer

Yes

  • 1 = Buy

  • 2 = Make

  • 3 = Distributed

InventoryPlanning

text

10

No

Valid Buffer Profile from the Buffer Profile record for the matching Location. Or

  • RO = Replenishment Override

  • MM = Min/Max

  • NB = Non-Buffered

  • LTM = Lead Time Managed

FixedLeadTime

integer

No

0 to 1095

GoodsReceiptTime

integer

No

0 to 1095

AverageDailyUsage

decimal

18.5

No

>= 0

ForecastedDailyUsage

decimal

18.5

No

(This imported value will be used over a calculated version based on global setting)

OrderCycle

integer

No

>= 0

OrderMinimumQty

decimal

18.5

No

>= 0

OrderMaximumQty

decimal

18.5

No

>= 0 (and if > 0, must be > OrderMinimumQty)

OrderMultipleQty

decimal

18.5

No

>= 0 (and, if > 0 and OrderMinimumQty is > 0 and are not evenly divisible, then OrderMultipleQty will be set to 0)

CycleDayAdjustmentFactors

text

1024

No

If specified for Replenished, RO or MM must match the Name and Location of a CycleDayAdjustmentFactor record. Multiple values can be entered, separated by comma.

PlannedAdjustmentFactor

text

50

No

If specified for Replenished, RO or MM must match the Name and Location of a PlannedAdjustmentFactor record.

PlannerCode

text

25

No

PlanningCalendar

text

50

No

Name of a valid planning calendar

MaterialType

text

50

No

RawMaterialsCost

decimal

18.5

No

>= 0

OutSourceCost

decimal

18.5

No

>= 0

Vendor

text

100

No

VendorIdentifier

text

100

No

UserDefined1

text

400

No

UserDefined2

text

400

No

UserDefined3

text

400

No

UserDefined4

text

400

No

UserDefined5

text

400

No

UserDefined6

text

400

No

UserDefined7

text

400

No

UserDefined8

text

400

No

DecoupledLeadTime

boolean

No

0 or 1, True or False

DailyUsageType

Text

10

No

  • 0 or ADU = AverageDailyUsage

  • 1 or FDU = ForecastedDailyUsage

  • 2 or Blend = Blended Daily Usage

Notes

text

32767

No

AlertHorizon

integer

No

AutoApproveRecommendedOrders

boolean

No

0 or 1, True or False

UserDefined9

text

400

No

UserDefined10

text

400

No

UserDefined11

text

400

No

UserDefined12

text

400

No

UserDefined13

text

400

No

UserDefined14

text

400

No

UserDefined15

text

400

No

UserDefined16

text

400

No

DisableAutoProfile

boolean

No

SourceErp

text

100

No

SourceLocation

text

32

No

IncludeInMAC

boolean

No

FixedReorderCycle

boolean

No

ShelfLife

integer

No

BoMType

integer

No

SourceInformation1

text

400

No

SourceInformation2

text

400

No

SourceInformation3

text

400

No

ForecastedDailyUsageHorizonOverride

integer

No

AverageDailyUsageHorizonOverride

integer

No

Last updated