Project Account Numbers
Field Name |
Caption |
Mask |
Description |
Field Type |
PX_ACT_FLG |
Active |
|
Active |
Boolean |
PX_AREA_CD |
Area Code |
10x |
Area Code |
String |
PX_AREA_TY |
Area Description |
40x |
Area Description |
String |
PX_CRT_BY |
Created By |
25x |
Created By |
Text |
PX_DIV_CD |
Division Code |
10x |
Division Code |
String |
PX_DIV_TY |
Division Description |
40x |
Division Description |
String |
PX_DPT_CD |
Department Code |
10x |
Department Code |
String |
PX_DPT_TY |
Department Description |
50x |
Department Description |
String |
PX_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PX_ID |
Project Rec # |
nnnnnnnn |
AutoNumber |
Long Integer |
PX_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PX_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PX_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PX_PNUMACT |
Project Number |
40x |
Project Account Number |
Text |
PX_PNUMDES |
Project Number Desc |
200x |
Project Account Number Descript |
Text |
PX_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PX_SAREACD |
Sub-Area Code |
10x |
Sub-Area Code |
String |
PX_SAREATY |
Sub-Area Description |
40x |
Sub-Area Description |
String |
PX_SDIV_CD |
SubDivision Code |
10x |
SubDivision Code |
String |
PX_SDIV_TY |
SubDivision Description |
40x |
SubDivision Description |
String |