| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | RETURNK | Return Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | OTRNSTYPE | Offsetting Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | RTRNSTYPE | Return Transaction Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | RXDOCUMENT | Indicator: Documented Return | char | 1 | 0 | | | | Allow NULL? |
| 7 | ZTRNSTYPE | Return Transaction Type (Interest Related) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | ZXDOCUMENT | Indicator: Documented Return | char | 1 | 0 | | | | Allow NULL? |
| 9 | ZDAYS | Interest Adjustment: Additional Days | decimal | 3 | 0 | | | | |
| 10 | GTRNSTYPE | Transaction Type for Guaranteed Amount / Returned Checks | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | USECPD | Indicator: Use for CpD (Suspense) Accounts Allowed | char | 1 | 0 | | | | Allow NULL? |
| 12 | USEPRT | Indicator: Return from Customer Account Allowed | char | 1 | 0 | | | | Allow NULL? |
| 13 | BNKLIAB | Indicator: Posting of Guaranteed Check Amount | char | 1 | 0 | | | | Allow NULL? |
| 14 | LIABBNKACC | Indicator: Guaranteed Check Amount - Liability of Bank | char | 1 | 0 | | | | Allow NULL? |
| 15 | PARTRETURN | Indicator: Partial Return Allowed | char | 1 | 0 | | | | Allow NULL? |
| 16 | RETURN_PERIOD | Return Reason: Period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | RETURN_UNIT | Period Unit for Return | char | 1 | 0 | | | | Allow NULL? |
| 18 | REF_DATE_TYP | Return Reason: Reference Date Type | char | 1 | 0 | | | | Allow NULL? |
| 19 | CAL_ID | Factory Calendar Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | CAL_CAT | Return Reason: Calendar Category | char | 1 | 0 | | | | Allow NULL? |