|
|
SAP Business One SDK 10.0 - Database Tables Reference |
SAP Sustainability Footprint Management Transactional Data for Replication
Table Name: BEM2
Table Description: SAP Sustainability Footprint Management Transactional Data for Replication
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RowNumber | Row Number of the PFMCOP Doc. Type | Int | 11 | - | Â | Â | Â |
| BEMDocType | PFMCOP Doc. Type Code | Int | 11 | - | Â | Â | Â |
| BEMDocName | PFMCOP Doc. Type Name | nVarChar | 60 | - | Â | Â | Â |
| ScopeKey | Footprint Inventory Scope Identifier in PFMCOP | nVarChar | 36 | - | Â | Â | Â |
| RepId | Replication Identifier | nVarChar | 36 | - | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| EndDate | End Date | Date | 8 | - | Â | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| B1ObjCode | B1 Object Code | nVarChar | 20 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 60 | - | Â | Â | Â |
| WhseCode | Warehouse Code | nVarChar | 60 | - | Â | Â | Â |
| UomCode | Unit of Measure Code | nVarChar | 3 | - | Â | Â | Â |
| InQty | In Quantity | Num | 19.6 | - | Â | Â | Â |
| OutQty | Out Quantity | Num | 19.6 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| VendorCode | Vendor Code | nVarChar | 60 | - | Â | Â | Â |
| WOREntry | Production Order Internal Key | nVarChar | 60 | - | Â | Â | Â |
| RoleCode | Material Role Code | nVarChar | 2 | - | MP | MP | Main Product |
| Â | Â | Â | Â | Â | Â | BP | By-Product |
| RscCode | Resource Code | nVarChar | 60 | - | Â | Â | Â |
| RscQty | Resource Quantity | Num | 19.6 | - | Â | Â | Â |
| RscUomCode | Resource Quantity UoM Code | nVarChar | 3 | - | Â | Â | Â |
| Project | Project | nVarChar | 60 | - | Â | Â | Â |
| ToWhseCode | To Warehouse Code | nVarChar | 60 | - | Â | Â | Â |
| CostCenter | Cost Center | nVarChar | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | RowNumber |
| Â | Â | BEMDocType |
| Â | Â | RepId |
| REP_ID | No | RepId |