| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TSYST | Transport system | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIJTS | OIJ_TSYST | Allow NULL? |
| 3 | LOCID | Location ID | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIJLOC | OIJ_LOCID | Allow NULL? |
| 4 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | MATNR | Allow NULL? |
| 5 | DATUM | Stock Projection item date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | OIJ_RDDAT | Allow NULL? |
| 6 | PLANN | OIL-TSW: Planned inventory | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_PLANN | |
| 7 | BASE | OIL-TSW: Base inventory | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_BASE | |
| 8 | RPROD | Production quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_RPROD | |
| 9 | RMRP | Proposed Quantity for Bulk Receipts | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_RMRP | |
| 10 | RWHIF | OIL-TSW: "What if" quantity for bulk receipts | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_RWHIF | |
| 11 | RDOC | OIL-TSW: Document quantity for bulk receipts | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_RDOC | |
| 12 | RSCHED | OIL-TSW: Scheduled quantity for bulk receipts | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_RSCHED | |
| 13 | RACT | OIL-TSW: Actual quantity for bulk receipts | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_RACT | |
| 14 | IMRP | OIL-TSW: Proposed quantity for bulk issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IMRP | |
| 15 | IWHIF | OIL-TSW: What-if quantity for bulk issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IWHIF | |
| 16 | IDOC | OIL-TSW: Document quantity for bulk issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IDOC | |
| 17 | ISCHED | OIL-TSW: Scheduled quantity for bulk issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_ISCHED | |
| 18 | IACT | OIL-TSW: Actual quantity for bulk issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IACT | |
| 19 | IFCAST | OIL-TSW: Forecast for rack issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IFCAST | |
| 20 | ICORR | OIL-TSW: Corrected forecast of rack issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_ICORR | |
| 21 | IRACT | OIL-TSW: Actuals for rack issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IRACT | |
| 22 | WORKLIST | Worklist entry indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_WORKLT | Allow NULL? |
| 23 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 24 | ERZEIT | Time of creation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_ERTIM | Allow NULL? |
| 25 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 26 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 27 | AEZEIT | Time of day the record was changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_AETIM | Allow NULL? |
| 28 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 29 | BLOIND | Blocking indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_BLOIND | Allow NULL? |
| 30 | DELIND | Deletion indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIJ_DELIND | Allow NULL? |
| 31 | PHY_INV | OIL-TSW: Phy inventory at loc.(from external source) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_PHY_INV | |
| 32 | MIFCAST | OIL-TSW: Manual forecast for rack issues | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_MIFCAST | |
| 33 | RVP | RVP value | decimal | 4 | 1 | DEC | ((0)) | Yes | | OIJ_RVP | |
| 34 | UNCOMM | Uncommitted inventory | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_UNCOMM | |
| 35 | APODP | APO Demand planning Bulk forecast | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_APODP | |
| 36 | IPROD | Inverse production | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIJ_IPROD | |
