MFG_GPO(SQL Table) |
Index Back |
|---|---|
GPO Manufacturer |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | MFG_ID |
Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MFG_SETID_VW |
| 3 | GPO_ID |
Character(18) | VARCHAR2(18) NOT NULL |
GPO ID
Prompt Table: GPO_TBL |
| 4 | GPO_CNTRCT_NBR |
Character(25) | VARCHAR2(25) NOT NULL | GPO Contract Number |
| 5 | CNTRCT_BEGIN_DT | Date(10) | DATE NOT NULL | Contract Begin Date |
| 6 | CNTRCT_EXPIRE_DT | Date(10) | DATE NOT NULL | Expire Date |
| 7 | BUY_FROM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Buy from this Manufacturer
Y/N Table Edit Default Value: N |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_SET_VW |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 10 | COMMIT_CNTRCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Committed Contract
Y/N Table Edit Default Value: N |
| 11 | COMMIT_LEVEL_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Commitment Percent |
| 12 | COMMIT_LEVEL_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Commit Level Amount |
| 13 | PRICE_EXPRTN_DT | Date(10) | DATE | Price Expiration Date |
| 14 | MAX_PRC_INC_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Maximum % Increase |
| 15 | INCREASE_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Increase Type
CPI=% of CPI MPI=% of MPI PCT=Straight % |
| 16 | CNTRCT_TIER_DESIG | Character(5) | VARCHAR2(5) NOT NULL | Contract Tier Level |
| 17 | CNTRCT_TIER_REQ | Character(254) | VARCHAR2(254) NOT NULL | Tier Requirements |
| 18 | REBATE_FREQ | Character(4) | VARCHAR2(4) NOT NULL |
Rebate Frequency
ANUL=Annual QUAR=Quarterly SANL=Sem Annual |