| 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 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | EKKO | EBELN | Allow NULL? |
| 3 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | EKPO | EBELP | Allow NULL? |
| 4 | SUBITM | Sub-item number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIA_SUBITM | Allow NULL? |
| 5 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 6 | CIND | Contract / call-off indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | OIA_CIND | Allow NULL? |
| 7 | LVORM | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LVORM | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 9 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 10 | EXGTYP | Exchange type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TOIA2 | OIA_EXGTYP | Allow NULL? |
| 11 | EXGPTR | Exchange partner (vendor number) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | OIA_EXGPTR | Allow NULL? |
| 12 | CNTTYP | Order Type (Purchasing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BSART | Allow NULL? |
| 13 | SMENGE_POS | Called-off/delivered/goods receipt quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIA_SMENGE | |
| 14 | SMENGE | Called-off/delivered/goods receipt quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIA_SMENGE | |
| 15 | INTQTY | Quantity scheduled to be exchanged | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIA_INTQTY | |
| 16 | RECQTY | Quantity intended against an exchange | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIA_RECQTY | |
| 17 | MEINS | Quantity schedule-related UoM | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIA_MEINS | Allow NULL? |
| 18 | ENTLU | Breakdown ind. for scheduling on contract/call-off level | char | 1 | 0 | CHAR | (N' ') | Yes | TOIA3 | OIA_ENTLU | Allow NULL? |
| 19 | SPLIT | How to split quantity in quantity schedule | char | 1 | 0 | CHAR | (N' ') | Yes | | OIA_SPLIT | Allow NULL? |
| 20 | MOD | Mode of transport | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIA_MOD | Allow NULL? |
| 21 | VONDAT | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VONDAT | Allow NULL? |
| 22 | BISDAT | Valid-to date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BISDAT | Allow NULL? |
| 23 | OIPRIOR | Priority of an exchange agreement for load balancing | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIA_PRIOR | Allow NULL? |
| 24 | KALID | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | WFCID | Allow NULL? |
| 25 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 26 | ERTIM | Time of creation | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_ERTIM | Allow NULL? |
| 27 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 28 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 29 | AETIM | Time of day the record was changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | OI0_AETIM | Allow NULL? |
| 30 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
