| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | TYPE_FROM | Document Category | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WLF_SHADOW_DOC_TYPE | Allow NULL? |
| 3 | DOCUMENT_FROM | Document Number | nvarchar | 32 | 0 | CHAR | (N' ') | No | | WLF_GENERIC_DOC_NUM | Allow NULL? |
| 4 | ITEM_FROM | item number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | WLF_GENERIC_ITEM_NUM | Allow NULL? |
| 5 | SIDE_FROM | Side of the Document with an Assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WLF_PR_SIDE_FROM | Allow NULL? |
| 6 | SUB_ITEM_FROM | Subitem Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | WLF_GENERIC_SUB_ITEM_NUM | Allow NULL? |
| 7 | TKONN | Trading Contract: Trading Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | TKONN | Allow NULL? |
| 8 | TPOSN | Trading Contract: Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | TPOSN | Allow NULL? |
| 9 | SIDE_TO | Side of the document which is assigned to | nvarchar | 2 | 0 | CHAR | (N' ') | No | | WLF_PR_SIDE_TO | Allow NULL? |
| 10 | TPOSN_COM | Commodity Subitem Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | WLF_TPOSN_COM | Allow NULL? |
| 11 | ASSGD_QUAN | Assigned Quantity | varbinary | 16 | 0 | | | Yes | | WLF_ASSGD_QUANTITY_IND | |
| 12 | ASSGD_QUAN_ORIG | Original Assigned Quantity | varbinary | 16 | 0 | | | Yes | | WLF_ASSGD_QUANTITY_ORIG | |
| 13 | ASSGD_UOM | UoM of the Assigned Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | WLF_ASSGD_UOM | Allow NULL? |
| 14 | A_GUID | GUID of an assignment | varbinary | 16 | 0 | RAW | | Yes | | WLF_ASSGMT_GUID | |
| 15 | PRED_A_GUID | GUID of a preceding assignment | varbinary | 16 | 0 | RAW | | Yes | | WLF_PRED_ASSGMT_GUID | |
| 16 | PRED_QUAN | Quantity Transferred from a Preceding Assignment | varbinary | 16 | 0 | | | Yes | | WLF_PRED_ASSGD_QUANTITY | |
| 17 | FROZEN | Assignment is frozen | char | 1 | 0 | CHAR | (N' ') | Yes | | WLF_ASSGMT_FROZEN | Allow NULL? |
| 18 | CR_NAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 19 | CR_DATE | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 20 | CR_TIME | Time, at Which Record Was Added | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZEIT | Allow NULL? |
| 21 | CH_NAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 22 | CH_DATE | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 23 | CH_TIME | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZEIT | Allow NULL? |
| 24 | CANCEL_FLAG | Cancel | char | 1 | 0 | CHAR | (N' ') | Yes | | WLF_CANCEL | Allow NULL? |
| 25 | PLACE_HOLDER | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
