CHNG_MAP_TMPLT(SQL Table) |
Index Back |
---|---|
Change Order Mapping Template |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CHNG_MAP_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Template ID |
2 | CHNG_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Change Source
BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |