PTVRANKS

Vendor Rankings for Parts

Field Name

Caption

Mask

Description

Field Type

PB_CRT_BY

 

25x

Created By

Text

PB_CRT_DTTM

 

 

Creation Date Time

Date/Time

PB_END_DT

End Date

mm/dd/yyyy

Preferred Vendor Expiration Date

Date/Time

PB_ID

Vendor Rank Rec #

nnnnn

Unique Identifier:

Long Integer

PB_MOD_BY

 

25x

Last Modified By

Text

PB_MOD_DT

 

 

Last Modified Date

Date/Time

PB_MOD_TM

 

 

Modified Time

Date/Time

PB_PA_ID

Vendor Rank Rec #

nnnnn

Link to PTPARTS.PA_ID

Long Integer

PB_PV_DSC

Vendor Rank Desc

30x

Store Vendor Desc Redundantly

Text

PB_PV_ID

Vendor Rec #

nnnnn

Link to PTVENDOR.PV_ID

Long Integer

PB_PV_NBR

Vendor Rank Number

15x

Store Vendor Number Redundantly

Text

PB_RANK

Rank

nnnnn

Rank of Vendor for this Part

Integer