Purchase Orders
Field Name |
Caption |
Mask |
Description |
Field Type |
PO_ACCOUNT |
Account Number |
45x |
Account Number |
String |
PO_CO_ID |
|
|
Link to Comments Table |
Long Integer |
PO_CRT_BY |
Created By |
25x |
Created By |
Text |
PO_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PO_DATE |
Date |
mm/dd/yyyy |
Purchase Order Date: |
Date/Time |
PO_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
PO_EA_ID |
Link to Eden Account No |
nnnnnnnn |
Long Integer |
|
PO_EP_ID |
Link to Eden Project No |
nnnnnnnn |
Long Integer |
|
PO_ID |
|
|
Unique Identifier: |
Long Integer |
PO_INVOICE |
Vendor Invoice # |
30x |
Vendor Invoice Number |
Text |
PO_MOD_BY |
Last Modified By |
25x |
Modified By : Person that Last Modified Record |
Text |
PO_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date : Date Record Last Modified |
Date/Time |
PO_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PO_MSC_CST |
Misc. Costs |
nnnnnn.nn |
Miscellaneous costs |
Double |
PO_NUMBER |
PO Number |
15x |
Purchase Order Number |
Text |
PO_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
String |
PO_PV_ID |
Vendor Rec # |
nnnnnnnn |
Long Integer |
|
PO_PVDESC |
Description |
50x |
Vendor Name |
Text |
PO_PVNUMB |
Vendor ID |
15x |
Vendor Number |
Text |
PO_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
PO_SHIPCST |
Shipping Costs |
nnnnnn.nn |
Shipping Costs |
Double |
PO_STAT_CD |
Status Code |
nnn |
Status Code |
Integer |
PO_STAT_TY |
Status Type |
25x |
Status Type |
Text |
PO_SUM_CST |
Items Cost |
nnnnnn.nn |
Summary of line items |
Double |
PO_TAXES |
Taxes |
nnnnnn.nn |
Taxes |
Double |
PO_TOT_CST |
Total Costs |
nnnnnn.nn |
Total PO Costs |
Double |
PO_USER |
Created By |
25x |
User that created PO |
Text |
PO_USER10 |
User 10 |
mm/dd/yyyy |
User 10 - date |
Date/Time |
PO_USER11 |
User 11 |
mm/dd/yyyy |
User 11 - date |
Date/Time |
PO_USER12 |
User 12 |
mm/dd/yyyy |
User 12 - date |
Date/Time |
PO_USER13 |
User 13 |
|
User 13 - logical |
Boolean |
PO_USER14 |
User 14 |
|
User 14 - logical |
Boolean |
PO_USER15 |
User 15 |
|
User 15 - logical |
Boolean |
PO_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
PO_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
PO_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
PO_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
PO_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
PO_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
PO_USER4 |
User 4 |
30x |
User 4 - alphanumeric |
Text |
PO_USER5 |
User 5 |
30x |
User 5 - alphanumeric |
Text |
PO_USER6 |
User 6 |
30x |
User 6 - alphanumeric |
Text |
PO_USER7 |
User 7 |
nnnnnnnnn.nn |
User 7 - numeric |
Double |
PO_USER8 |
User 8 |
nnnnnnnnn.nn |
User 8 - numeric |
Double |
PO_USER9 |
User 9 |
nnnnnnnnn.nn |
User 9 - numeric |
Double |
PO_WDESC |
Warehouse Description |
50x |
Warehouse Description |
String |
PO_WNUMBER |
Warehouse ID |
20x |
Warehouse ID |
String |
PO_WO_NUMB |
Work Order # |
25x |
Text |