| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDefense Forces and Public Security |
1 | /ISDFPS/ZEBAN | Copy of EBAN | 9 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
TOPExternal Services |
2 | ESVC | Vendor confirmation for service lines | 9 | ESTKZ | Creation Indicator: Vendor Confirmation | nvarchar | 1 | 0 | | |
TOPMaterials Management |
3 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 14 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
TOPPurchasing |
4 | EBAN | Purchase Requisition | 9 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
5 | EKEH | Scheduling Agreement Release Documentation | 13 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
6 | EKEHH | Removed Scheduling Agreement Release Documentation | 13 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
7 | EKES | Vendor Confirmations | 13 | ESTKZ | Creation Indicator: Vendor Confirmation | nvarchar | 1 | 0 | | |
8 | EKET | Scheduling Agreement Schedule Lines | 15 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
9 | EKETH | Scheduling Agreement Schedules: History Tables | 15 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |
10 | MEREQX | Purchase Requisition Change Parameter | 9 | ESTKZ | Updated information in related user data field | nvarchar | 1 | 0 | | |
11 | PEKES | Variant Vendor Confirmations | 13 | ESTKZ | Creation Indicator: Vendor Confirmation | nvarchar | 1 | 0 | | |
TOPSimulation |
12 | VSEBAN_CN | Version: Purchase requisition | 10 | ESTKZ | Creation Indicator (Purchase Requisition/Schedule Lines) | nvarchar | 1 | 0 | | |