Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
SCAR_Number | SCAR Number |
String | 22 | View | |
nsrnum | NSR Number |
String | 22 | View | |
DATEENTERED_I | Date Entered |
Date | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
ORIGINATOR | Originator |
String | 16 | View | |
POPRCTNM | POP Receipt Number |
String | 18 | View | |
RCPTLNNM | Receipt Line Number |
Long Integer | 4 | View | |
PONUMBER | PO Number |
String | 18 | View | |
POLNENUM | PO Line Number |
Long Integer | 4 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
VENDNAME | Vendor Name |
String | 66 | View | |
ADDRESS1 | Address 1 |
String | 62 | View | |
ADDRESS2 | Address 2 |
String | 62 | View | |
CITY | City |
String | 36 | View | |
STATE | State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
PHNUMBR1 | Phone Number 1 |
String | 22 | View | |
PHNUMBR2 | Phone Number 2 |
String | 22 | View | |
FAXNUMBR | Fax Number |
String | 22 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
VNDITNUM | Vendor Item Number |
String | 32 | View | |
QTYRECEIVED2_I | QTY Received2 |
Currency | 10 | View | |
BASEUOFM | Base U Of M |
String | 10 | View | |
DATEDUE_I | Date Due |
Date | 4 | View | |
DATEIN_I | Date In |
Date | 4 | View | |
VNDCNTCT | Vendor Contact |
String | 62 | View | |
PHONNAME | Phone Number |
String | 22 | View | |
USERID | User ID |
String | 16 | View | |
CHANGEDATE_I | Change Date |
Date | 4 | View | |
MFGNOTEINDEX_I | MFG Note Index |
Currency | 10 | View | |
MFGNOTEINDEX2_I | MFG Note Index2 |
Currency | 10 | View | |
MFGNOTEINDEX3_I | MFG Note Index3 |
Currency | 10 | View | |
MFGNOTEINDEX4I | MFG Note Index4 |
Currency | 10 | View | |
MFGNOTEINDEX5I | MFG Note Index5 |
Currency | 10 | View | |
MFGNOTEINDEX6I | MFG Note Index6 |
Currency | 10 | View |