POP_REQUISITION_TYPES

Purchasing Requisitions

tableFINPOP

POP_REQUISITION_TYPES — Purchasing Requisitions. FIN table in the standard Ross ERP 8.0 schema: 6 columns, used by 16 programs. Columns, data types, keys, foreign keys and relationships.

Open POP_REQUISITION_TYPES in the interactive Data Dictionary →

Part of POP tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2COMPANY_CODEvarchar(10)PKCompany Code
3REQUISITION_TYPEvarchar(2)PKPurchase Requisition Type
4CODE_DESCRIPTIONvarchar(30)Code Description
5STORES_REQvarchar(1)Stores Requisition Flag
6EMERGENCYvarchar(1)Emergency Flag

Referenced by · 3 foreign keys

INV_TRANSACTIONSINV_TRANSACTIONSPOP_REQUISITION_HEADERS