EXTENDED PURCHASING
SUBSYSTEM
TABLE NAME |
TABLE CODE |
S/U ** |
|
AGENCY/ORGANIZATION
PURCHASE ORDER |
AOPI |
U |
|
BID
AWARD |
BIDA |
S/U |
|
BID
CREATION |
BIDC |
U |
|
BIDDERS |
BIDD |
U |
|
BID
MASTER HEADER |
BDMH |
U |
|
BID
MASTER LINE |
BDML |
U |
|
BID
MASTER REQUISITION |
BDMR |
S/U |
|
BID
MASTER REVISIONS |
BDRE |
U |
|
BID
OPEN/CLOSED UPDATE |
BOCU |
U |
|
BID
RESPONSE |
BIDR |
U |
|
BID
TEXT |
BDTX |
U |
|
BID
TRACKING HEADER |
BIDH |
U |
|
BID
TRACKING LINE |
BIDL |
U |
|
BID
VENDOR INQUIRY |
BDVI |
S/U |
|
BID
VENDOR SELECTION |
BIDV |
U |
|
BID
VENDOR SELECTION BY VENDOR NAME |
BDVN |
U |
|
BILLING
ADDRESS |
BILL |
U |
|
BUYERS
MASTER |
BUYT |
U |
|
CARRIER
MASTER |
CARR |
U |
|
COMMODITY |
COMT |
UU |
|
COMMODITY
BY COMMODITY CLASS SELECTION |
COMC |
U |
|
COMMODITY
BY DESCRIPTION SELECTION |
COMD |
U |
|
COMMODITY
CLASS BY DESCRIPTION |
CLDE |
U |
|
COMMODITY
CLASS MASTER |
COCL |
U |
|
COMMODITY
CROSS REFERENCE |
COMK |
S/U |
|
COMMODITY
INDEX |
COMM |
S |
|
COMMODITY
INQUIRY BY BID NUMBER |
CIBD |
S/U |
|
COMMODITY
INQUIRY BY PURCHASE ORDER |
CIPO |
U |
|
COMMODITY
INQUIRY BY REQUISITION |
CIRX |
S/U |
|
COMMODITY
SELECTION |
COMS |
U |
|
COMMODITY
SUB-CLASS BY COMMODITY CLASS |
CSCC |
U |
|
COMMODITY
SUB-CLASS BY DESCRIPTION CONDITION |
CSDE |
S/U |
|
CONDITION |
COND |
U |
|
DISCOUNT
TYPE |
DISC |
U |
|
DOCUMENTS
IN PROCESS |
DOCP |
S/U |
|
EXTENDED
PURCHASING SYSTEM CONTROL OPTIONS |
ESOP |
S/U |
|
NOTE
PAD |
NOTE |
U |
|
ON
DEMAND EPS PURCHASE ORDER PRINT |
ODPO |
U |
|
ON
DEMAND PURCHASE ORDER PRINT |
STPO |
U |
|
OPEN
BID VENDOR SELECTION |
BDVS |
U |
|
OPEN
PURCHASE ORDER ACCOUNTING LINE MOD |
MPPL |
U |
|
OPEN
PURCHASE ORDER ACCOUNTING LINE |
OPPL |
S/U |
|
OPEN
PURCHASE ORDER BY BLANKET NUMBER |
POBL |
U |
|
OPEN
PURCHASE ORDER BY BUYER |
POHB |
S |
|
OPEN
PURCHASE ORDER BY DELIVERY DATE |
PODD |
S |
|
OPEN
PURCHASE ORDER COMMODITY BY COMMODITY CODE |
POCC |
S |
|
OPEN
PURCHASE ORDER COMMODITY LINE MOD |
MPPC |
U |
|
OPEN
PURCHASE ORDER COMMODITY LINE |
OPPC |
S |
|
OPEN
PURCHASE ORDER COMMODITY LINE BY VENDOR AND COMMODITY CODE |
POC1 |
S |
|
OPEN
PURCHASE ORDER COMMODITY LINE BY COMMODITY CODE AND VENDOR CODE |
POC2 |
S |
|
OPEN
PURCHASE ORDER COMMODITY LINE RC SELECTION |
PORC |
S |
|
OPEN
PURCHASE ORDER COMMODITY LINE VI SELECTION |
POVI |
S |
|
OPEN
PURCHASE ORDER HEADER |
OPPH |
S |
|
OPEN
PURCHASE ORDER HEADER BY DOCUMENT |
OPPD |
S |
|
OPEN
PURCHASE ORDER HEADER MOD |
MPPH |
S/U |
|
OPEN
PURCHASE ORDER INQUIRY BY VENDOR |
OPIV |
S/U |
|
OPEN
PURCHASE ORDER PRINT |
PCHD |
S |
|
OPEN
RECEIVER HEADER |
ORCH |
S/U |
|
OPEN
RECEIVER LINE |
ORCL |
S/U |
|
OPEN
REQUISITION ACCOUNTING LINE |
ORQL |
S/U |
|
OPEN
REQUISITION COMMODITY LINE |
ORQC |
S/U |
|
OPEN
REQUISITION HEADER |
ORQH |
S/U |
|
OPEN
REQUISITION INQUIRY BY AGENCY |
ORIA |
U |
|
OPEN
VENDOR INVOICE LINE |
OVIL |
U |
|
PRICE
AGREEMENT BY COMMODITY |
PABC |
U |
|
PRICE
AGREEMENT SECURITY |
PASC |
U |
|
PRICE
AGREEMENT SUMMARY |
PASM |
U |
|
PRICE
AGREEMENT SUMMARY INQUIRY |
PASI |
U |
|
PRICE
AGREEMENT TEXT |
PATX |
U |
|
PRICE
AGREEMENT VENDOR/COMMODITY |
PAVC |
U |
|
PURCHASE
ORDER GENERATION |
PCG1 |
U |
|
PURCHASE
ORDER GENERATION - SCREEN 2 |
PCG2 |
U |
|
PURCHASE
ORDER INQUIRY BY VENDOR |
PIBV |
S |
|
PURCHASE
ORDER PREPARATION INQUIRY |
POPR |
U |
|
PURCHASING
TEXT |
PTEX |
U |
|
RECEIVER
GENERATION |
RCGN |
S |
|
RECEIVER
TEXT |
RCTX |
U |
|
REQUISITION
ACTIVE/INACTIVE |
RAIT |
U |
|
REQUISITION
FREEZE/UNFREEZE |
RFUF |
U |
|
REQUISITION
GENERATION |
RXGN |
U |
|
REQUISITION
STATUS |
RQST |
S/U |
|
REQUISITION
STATUS CODE |