| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory Management |
1 | RESB | Reservation/dependent requirements | 185 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
TOPMaster Data |
2 | MDTB | MRP Table | 60 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
TOPMaterials Management |
3 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 140 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
4 | /ISDFPS/PREQ | Requirement Priorities (Obsolete --> New Table: PREQ) | 2 | PRIO_REQ | Requirement Priority (Obsolete) | nvarchar | 3 | 0 | | |
5 | /ISDFPS/PREQT | Reqmt Priorities - Txt Table (Obs. --> new Table: PREQTX_T) | 3 | PRIO_REQ | Requirement Priority (Obsolete) | nvarchar | 3 | 0 | | |
6 | /ISDFPS/PREQT_N | Requirement Priorities - Text Table | 3 | PRIO_REQ | Requirement Priority (Obsolete) | nvarchar | 3 | 0 | | |
7 | /ISDFPS/PREQ_N | Requirement Priorities | 2 | PRIO_REQ | Requirement Priority (Obsolete) | nvarchar | 3 | 0 | | |
8 | /ISDFPS/PRPLCNTL | Subsequent Processing for Prioritized Materials Planning | 2 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
9 | /ISDFPS/PURGSD | Assgmt Bet. Reqmt and Deliv. Priors (Obs. --> New: PURGSD) | 2 | PRIO_REQ | Requirement Priority (Obsolete) | nvarchar | 3 | 0 | | |
10 | PACT | Activation of Requirement Prioritization | 3 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
11 | PREQ | Requirement Priorities | 2 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
12 | PREQTX_T | Requirement Priorities - Text Table | 3 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
13 | PURGSD | Relationships Between Requirement and Delivery Priorities | 2 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
TOPPatient Accounting |
14 | NMATO | IS-H: Material requisition by nurse station | 40 | PRIO_REQ | IS-H-MM: Requirement Priority | nvarchar | 3 | 0 | | |
15 | NMATP | IS-H: Material planned for case | 42 | PRIO_REQ | IS-H-MM: Requirement Priority | nvarchar | 3 | 0 | | |
TOPPurchasing |
16 | EBAN | Purchase Requisition | 132 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
17 | EKPO | Purchasing Document Item | 212 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |
18 | MEREQX | Purchase Requisition Change Parameter | 132 | PRIO_REQ | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPSimulation |
19 | VSRESB_CN | Version: Reservation/Dependent requirements | 192 | PRIO_REQ | Requirement Priority | nvarchar | 3 | 0 | | |