Warehouses
Field Name |
Caption |
Mask |
Description |
Field Type |
PW_ADDR1 |
Shipping Address |
75x |
Shipping Address |
Text |
PW_ADDR2 |
Shipping Address 2 |
75x |
Shipping Address 2 |
Text |
PW_CITY |
Shipping City |
25x |
Shipping City |
Text |
PW_CRT_BY |
Created By |
25x |
Created By |
Text |
PW_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PW_DEFAULT |
Default |
|
Is this the Default Warehouse: |
Boolean |
PW_DESC |
Warehouse Desc. |
50x |
Warehouse Description: |
Text |
PW_DFLOCID |
Location |
nnnnnnnn |
The Default Location for this Warehouse: |
Long Integer |
PW_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
PW_EMAIL |
150x |
String |
||
PW_EQ_ID |
Link to Equipment |
nnnnnnnn |
Long Integer |
|
PW_EQPT_CD |
Equipment Code |
20x |
Equipment Code in WKUEQT.EQ_EQPT_CD |
Text |
PW_EQPT_TY |
Equipment Description |
50x |
Equipment Description in WKUEQT.EQ_EQPT_TY |
Text |
PW_ID |
AutoNumber |
nnnnnnnn |
Unique Identifier: |
Long Integer |
PW_IMG_FLG |
|
|
Image Available: Image open 0 = False, 1 = True |
Boolean |
PW_MOD_BY |
Last Modified By |
25x |
Modified By : Person that Last Modified Record |
Text |
PW_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date : Date Record Last Modified |
Date/Time |
PW_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PW_MOV_FLG |
|
|
Movie Available: Movie open 0 = False, 1 = True |
Boolean |
PW_NUMBER |
Warehouse ID |
20x |
Warehouse Number: |
Text |
PW_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PW_STAT_CD |
Status Code |
nnn |
Status Code |
Integer |
PW_STAT_TY |
Status Type |
25x |
Status Type |
Text |
PW_STATE |
Shipping State |
20x |
Shipping State |
Text |
PW_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
PW_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
PW_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
PW_USER13 |
User 13 |
|
User 13 |
Boolean |
PW_USER14 |
User 14 |
|
User 14 |
Boolean |
PW_USER15 |
User 15 |
|
User 15 |
Boolean |
PW_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
PW_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
PW_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
PW_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
PW_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
PW_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
PW_USER4 |
User 4 |
30x |
User 4 |
Text |
PW_USER5 |
User 5 |
30x |
User 5 |
Text |
PW_USER6 |
User 6 |
30x |
User 6 |
Text |
PW_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
PW_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
PW_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
PW_ZIP |
Shipping Zip |
15x |
Shipping Zip |
Text |