| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory Management |
1 | RESB | Reservation/dependent requirements | 184 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
TOPMaster Data |
2 | MDTB | MRP Table | 59 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
TOPMaterials Management |
3 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 139 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
4 | /ISDFPS/PURG | Requirement Urgencies (Obsolete --> New Table: PURG) | 2 | PRIO_URG | Requirement Urgency (Obsolete) | nvarchar | 2 | 0 | | |
5 | /ISDFPS/PURGPM | Assgmt of PM Priors to Reqmt Urgencies (Obs.--> New: PURGPM) | 4 | PRIO_URG | Requirement Urgency (Obsolete) | nvarchar | 2 | 0 | | |
6 | /ISDFPS/PURGSD | Assgmt Bet. Reqmt and Deliv. Priors (Obs. --> New: PURGSD) | 3 | PRIO_URG | Requirement Urgency (Obsolete) | nvarchar | 2 | 0 | | |
7 | /ISDFPS/PURGT | Reqmt Urgencies - Text Tables (Obs. --> New Tab.: PURGTX_T) | 3 | PRIO_URG | Requirement Urgency (Obsolete) | nvarchar | 2 | 0 | | |
8 | PACT | Activation of Requirement Prioritization | 4 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
9 | PURG | Requirement Urgencies | 2 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
10 | PURGPM | Assignment of Maintenance Priorities to Requirem. Urgencies | 4 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
11 | PURGSD | Relationships Between Requirement and Delivery Priorities | 3 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
12 | PURGTX_T | Requirement Urgencies - Text Tables | 3 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
13 | NMATO | IS-H: Material requisition by nurse station | 39 | PRIO_URG | IS-H-MM: Requirement Urgency | nvarchar | 2 | 0 | | |
14 | NMATP | IS-H: Material planned for case | 41 | PRIO_URG | IS-H-MM: Requirement Urgency | nvarchar | 2 | 0 | | |
TOPPurchasing |
15 | EBAN | Purchase Requisition | 131 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
16 | EKPO | Purchasing Document Item | 211 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |
17 | MEREQX | Purchase Requisition Change Parameter | 131 | PRIO_URG | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPSimulation |
18 | VSRESB_CN | Version: Reservation/Dependent requirements | 191 | PRIO_URG | Requirement Urgency | nvarchar | 2 | 0 | | |