Parts Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
PA_ACCOUNT |
Account |
45x |
Account |
Text |
PA_ALLOCD |
|
|
Quantity allocated |
Double |
PA_AVECOST |
Average Cost |
nnnnnnnn.nn |
Current Average Cost of Part: |
Double |
PA_BARCODE |
Barcode |
30x |
Parts Bar Code Number |
Text |
PA_CMET_CD |
Cost Method |
nnn |
|
Integer |
PA_CMET_TY |
Cost Method Type |
25x |
Cost Method (1=FIFO, 2=LIFO, 3=Average) |
Text |
PA_CO_ID |
|
|
Comments : |
Long Integer |
PA_COMMENT1 |
Long Note |
|
Long Note |
Memo |
PA_CONSUM |
Consumable |
|
Consumable |
Boolean |
PA_CRT_BY |
Created By |
25x |
Created By |
Text |
PA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PA_DEF_LC |
Default Location |
nnnnnnn |
Default Location ID |
Long Integer |
PA_DESC |
Description |
75x |
Description of the part |
Text |
PA_DIM |
Dimensions |
30x |
Dimensions |
Text |
PA_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
PA_END_DT |
End Date |
mm/dd/yyyy |
End Date |
Date/Time |
PA_F_UC |
Fixed Unit Cost |
nnnnn.nn |
Fixed Unit Cost |
Double |
PA_FLT_FLD |
Fluid Code |
20x |
Material Code Matching Fleet\Equip Fluid CD |
Text |
PA_FLT_PT |
|
15x |
Material Code Matching Fleet\Equip Part CD |
Text |
PA_ID |
AutoNumber |
nnnnnnnn |
Unique Identifier : |
Long Integer |
PA_IMG_FLG |
|
|
Image Available: Image open 0 = False, 1 = True |
Boolean |
PA_INV_C |
Inventory Controlled |
|
Inventory Controlled |
Boolean |
PA_LDESC |
Long Description |
255x |
Long Description |
Text |
PA_MAMOUNT |
Markup Amount |
-nnnnn.nn |
Markup Amount |
Double |
PA_MAT_CD |
Material Code |
20x |
Material Code matching to Work Flow Setup |
Text |
PA_MAXQTY |
Max On-Hand Qty |
nnnnn.nn |
Maximum ON-Hand Quantity |
Double |
PA_MOD_BY |
Last Modified By |
25x |
Modified By : Person that Last Modified Record |
Text |
PA_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date : Date Record Last Modified |
Date/Time |
PA_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PA_MOV_FLG |
|
|
Movie Available: Movie open 0 = False, 1 = True |
Boolean |
PA_MTYP_CD |
Markup Type |
nnn |
Markup Method (1=Percentage, 2=Flat Rate) |
Integer |
PA_MTYP_TY |
Markup Type Text |
25x |
Markup Method Text (1=Percentage, 2=Flat Rate) |
Text |
PA_NUMBER |
Part ID |
20x |
Number of the Part |
Text |
PA_ONHAND |
Qty On Hand |
-nnnnn.nn |
Quantity on hand |
Double |
PA_ONORDER |
Qty On Order |
nnnnn.nn |
Quantity on order |
Double |
PA_ORDQTY |
Reorder Qty. |
nnnnn.nn |
Reorder quantity |
Double |
PA_PNUMACT |
Proj No - Acct |
40x |
Project Number Account |
Text |
PA_REORDER |
Reorder Point |
nnnnn.nn |
Reorder Point |
Double |
PA_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PA_STRT_DT |
Start Date |
mm/dd/yyyy |
Start Date |
Date/Time |
PA_TAX |
Taxable |
|
Taxable |
Boolean |
PA_UOM_CD |
Unit of Measure |
5x |
Unit of Measure |
Text |
PA_UOM_TY |
Unit of Measure Text |
25x |
Unit of Measure |
Text |
PA_USER10 |
User 10 |
mm/dd/yyyy |
User 10 : User Defined Date |
Date/Time |
PA_USER11 |
User 11 |
mm/dd/yyyy |
User 11 : User Defined Date |
Date/Time |
PA_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 : User Defined Double |
Double |
PA_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 : User Defined Double |
Double |
PA_USER14 |
User 14 |
30x |
User 14 : User Defined Alphanumeric |
Text |
PA_USER15 |
User 15 |
30x |
User 15 : User Defined Alphanumeric |
Text |
PA_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
PA_USER16TY |
User 16 Text |
25x |
User 16 Text |
Text |
PA_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
PA_USER17TY |
User 17 Text |
25x |
User 17 Text |
Text |
PA_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
PA_USER18TY |
User 18 Text |
25x |
User 18 Text |
Text |
PA_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
PA_USER19TY |
User 19 Text |
25x |
User 19 Text |
Text |
PA_USER1CD |
User 1 |
nnn |
User 1 : User Defined Code 1 |
Integer |
PA_USER1TY |
User 1 Text |
25x |
User 1 Text : User Defined Description 1 |
Text |
PA_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
PA_USER20TY |
User 20 Text |
25x |
User 20 Text |
Text |
PA_USER21 |
User 21 |
30x |
User 21 |
Text |
PA_USER22 |
User 22 |
30x |
User 22 |
Text |
PA_USER23 |
User 23 |
30x |
User 23 |
Text |
PA_USER24 |
User 24 |
30x |
User 24 |
Text |
PA_USER25 |
User 25 |
30x |
User 25 |
Text |
PA_USER26 |
User 26 |
nnnnnnnnn.nn |
User 26 |
Double |
PA_USER27 |
User 27 |
-nnnnnnnnn.nn |
User 27 |
Double |
PA_USER28 |
User 28 |
-nnnnnnnnn.nn |
User 28 |
Double |
PA_USER29 |
User 29 |
-nnnnnnnnn.nn |
User 29 |
Double |
PA_USER2CD |
User 2 |
nnn |
User 2 : User Defined Code 2 |
Integer |
PA_USER2TY |
User 2 Text |
25x |
User 2 Text : User Defined Description 2 |
Text |
PA_USER30 |
User 30 |
-nnnnnnnnn.nn |
User 30 |
Double |
PA_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
Date/Time |
PA_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
Date/Time |
PA_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
Date/Time |
PA_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
Date/Time |
PA_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
Date/Time |
PA_USER36 |
User 36 |
|
User 36 |
Boolean |
PA_USER37 |
User 37 |
|
User 37 |
Boolean |
PA_USER38 |
User 38 |
|
User 38 |
Boolean |
PA_USER39 |
User 39 |
|
User 39 |
Boolean |
PA_USER3CD |
User 3 |
nnn |
User 3 : User Defined Code 3 |
Integer |
PA_USER3TY |
User 3 Text |
25x |
User 3 Text : User Defined Description 3 |
Text |
PA_USER4 |
User 4 |
nnnnnnnnn.nn |
User 4 : User Defined Numeric Value |
Double |
PA_USER40 |
User 40 |
|
User 40 |
Boolean |
PA_USER5 |
User 5 |
30x |
User 5 : User Defined Alphanumeric |
Text |
PA_USER6 |
User 6 |
|
User 6 : User Defined Logical 1 |
Boolean |
PA_USER7 |
User 7 |
|
User 7 : User Defined Logical 2 |
Boolean |
PA_USER8 |
User 8 |
|
User 8 : User Defined Logical 3 |
Boolean |
PA_USER9 |
User 9 |
mm/dd/yyyy |
User 9 : User Defined Date |
Date/Time |
PA_WEIGHT |
Weight |
nnnnnn.nn |
Weight |
Double |