| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | PRIOP | Price options for gain calculation | char | 1 | 0 | | | | Allow NULL? |
| 4 | CKFNL | Check of tolerance on final transfer (ind.) | char | 1 | 0 | | | | Allow NULL? |
| 5 | CKITM | Check tolerance on each goods receipt | char | 1 | 0 | | | | Allow NULL? |
| 6 | CKEXT | Check of external number for transfer (indicator) | char | 1 | 0 | | | | Allow NULL? |
| 7 | GHNDL | Gain handling | char | 1 | 0 | | | | Allow NULL? |
| 8 | PROWL | Warning loss percentage tolerance limit | decimal | 5 | 2 | | | | |
| 9 | PROEL | Error loss percentage tolerance limit | decimal | 5 | 2 | | | | |
| 10 | PROWG | Warning gain percentage tolerance limit | decimal | 5 | 2 | | | | |
| 11 | PROEG | Error gain percentage tolerance limit | decimal | 5 | 2 | | | | |
| 12 | HANTYPG | Handling type for transfer gain | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | HANTYPL | Handling type for transfer loss | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | NEW_FC | field obsolete in ERP 2005 /only new Two-Step Transfer logic | char | 1 | 0 | | | | Allow NULL? |
| 16 | KONTO | Account number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 17 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |