PURCHASING GROUP Table
Contains codes, descriptions and phone numbers for MIT's Purchasing Groups
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
PURCHASING_GROUP |
Code identifying a Purchasing Group. |
VARCHAR2 |
3 |
PURCHASING_GROUP_DESCRIPTION |
Long name for purchasing group. |
VARCHAR2 |
18 |
PURCHASING_GROUP_KEY |
Key identifying a Purchasing Group. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
3 |
PURCHASING_GROUP_PHONE |
Telephone number for Purchasing Group |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |