| 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 | * | MANDT | Allow NULL? |
| 2 | DOC_NO | Document Number for Material Debit/Credit | nvarchar | 15 | 0 | NUMC | (N'000000000000000') | No | | UAINV_DEBCRE_DOC_NO | Allow NULL? |
| 3 | DOC_ITEM_NO | Document Item for Material Debit/Credit | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | UAINV_DEBCRE_DOC_ITEM_NO | Allow NULL? |
| 4 | FIN_POSTDAT | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | FIN_POSTDAT | Allow NULL? |
| 5 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | FIN_CURRTYPE | Allow NULL? |
| 6 | FINB_SND_ID | Sender Identification | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | FINB_SND_ID | Allow NULL? |
| 7 | FINB_SNDKEY | Document Key of the Sending System | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | FINB_SNDKEY | Allow NULL? |
| 8 | FIN_PRICELABEL | Price Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | FIN_PRICELABEL | Allow NULL? |
| 9 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | RAW | | Yes | | FOBJ_OBJECT_ID | |
| 10 | FIN_QTYVAL | Valuation Quantity | decimal | 23 | 3 | QUAN | ((0)) | Yes | | FIN_QTYVAL | |
| 11 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FIN_UOMVAL | Allow NULL? |
| 12 | FIN_AMOUNT | Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMOUNT | |
| 13 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRENCY | Allow NULL? |
| 14 | CURRENCY_RATE | Alternative Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | UAINV_CURRENCY_RATE | |
| 15 | UAINV_PR_O | Price Before Revaluation | decimal | 23 | 2 | CURR | ((0)) | Yes | | UAINV_PR_O | |
| 16 | UAINV_PR_FIX_O | Fixed Component of Price Before Inventory Price Change | decimal | 23 | 2 | CURR | ((0)) | Yes | | UAINV_PR_FIX_O | |
| 17 | UAINV_PR_BASE_O | Base Quantity for Price Before Revaluation | decimal | 23 | 3 | QUAN | ((0)) | Yes | | UAINV_PR_BASE_O | |
| 18 | UAINV_PR_N | Price After Revaluation | decimal | 23 | 2 | CURR | ((0)) | Yes | | UAINV_PR_N | |
| 19 | UAINV_PR_FIX_N | Fixed Component of Price After Inventory Revaluation | decimal | 23 | 2 | CURR | ((0)) | Yes | | UAINV_PR_FIX_N | |
| 20 | UAINV_PR_BASE_N | Base Quantity for Price After Revaluation | decimal | 23 | 3 | QUAN | ((0)) | Yes | | UAINV_PR_BASE_N | |
| 21 | UAINV_VALUE_O | Inventory Value Before Revaluation | decimal | 23 | 2 | CURR | ((0)) | Yes | | UAINV_VALUE_O | |
| 22 | UAINV_VALUE_N | Inventory Value After Revaluation | decimal | 23 | 2 | CURR | ((0)) | Yes | | UAINV_VALUE_N | |
| 23 | UAINV_QUANTITY | Inventory Quantity for Revaluation | decimal | 23 | 3 | QUAN | ((0)) | Yes | | UAINV_QUANTITY | |
| 24 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FOBJ_TYPE_NAME | Allow NULL? |
