| 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 | GEN_CONTRACT | Generating Contract | nvarchar | 10 | 0 | CHAR | (N' ') | No | EVER | EGEN_CONTRACT | Allow NULL? |
| 3 | ALLOC_DATE | Allocation date for billing | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | E_ZUORDDATABR | Allow NULL? |
| 4 | RUSE_BEGDATE | Date from which time slice is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ABZEITSCH | Allow NULL? |
| 5 | TOU_CODE | Global TOU code | nvarchar | 5 | 0 | CHAR | (N' ') | No | EGLOBAL_TOU_BR | ETOU_CODE | Allow NULL? |
| 6 | TRANS_NUM | Brazil: Transaction Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ETRANS_NUM | Allow NULL? |
| 7 | ACT_TYPE | Brazil: Activity Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | EACT_TYPE | Allow NULL? |
| 8 | RUSE_ENDDATE | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BISZEITSCH | Allow NULL? |
| 9 | QUANT | Brazil: Energy Credits Quantity | decimal | 31 | 14 | DEC | ((0)) | Yes | | EQUANT | |
| 10 | UNIT | Unit of measurement for billing | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | E_MASSBILL | Allow NULL? |
| 11 | PRICE_AMNT | Price amount | decimal | 17 | 8 | DEC | ((0)) | Yes | | PRSBTR | |
| 12 | CURRENCY | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TWAERS | Allow NULL? |
| 13 | BILL_DOC | Number of a billing document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | E_BELNR | Allow NULL? |
| 14 | REV_TR_NUM | Brazil: Reversal Transaction Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | EREV_TR_NUM | Allow NULL? |
| 15 | CONTRACT_REF | Brazil: Contract Reference | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ECONTRACT_REF | Allow NULL? |
| 16 | CREATEDBY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 17 | CREATEDDATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 18 | CREATEDTIME | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 19 | REMARKS | ISU Brazil: Remarks | nvarchar | 160 | 0 | CHAR | (N' ') | Yes | | EREMARKS | Allow NULL? |