| 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 | CASE_GUID | FSCM-DM: GUID (Internal Key of Dispute Case) | nvarchar | 32 | 0 | CHAR | (N' ') | No | | BDM_CASE_GUID | Allow NULL? |
| 3 | FIN_COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BDM_COMP_CODE | Allow NULL? |
| 4 | FIN_CUSTOMER | Key of Customer in Accounts Receivable Accounting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | UDM_KUNNR | Allow NULL? |
| 5 | FIN_INVOICE_TYPE | Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SWO_OBJTYP | Allow NULL? |
| 6 | FIN_INVOICE_KEY | Object key | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | SWO_TYPEID | Allow NULL? |
| 7 | FIN_PROMISED_AMT | Amount Promised for Payment | decimal | 15 | 2 | CURR | ((0)) | Yes | | BDM_PROMISED_AMOUNT | |
| 8 | FIN_PAID_AMOUNT | Amount Paid | decimal | 15 | 2 | CURR | ((0)) | Yes | | BDM_PAID_AMOUNT | |
| 9 | FIN_P2P_CURR | Currency of Promise to Pay | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BDM_PROMISE_CURR | Allow NULL? |
| 10 | FIN_P2P_DUE_DATE | Date for Which Payment Is Promised | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDM_PROMISE_DUE_DATE | Allow NULL? |
| 11 | FIN_P2P_DATE | Date on Which Promise to Pay Was Given | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDM_PROMISE_DATE | Allow NULL? |
| 12 | FIN_LAST_PAYMENT | Date of Last Payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDM_LAST_PAYMENT_DATE | Allow NULL? |
| 13 | FIN_P2P_STATE | State of Promise to Pay | char | 1 | 0 | CHAR | (N' ') | Yes | | BDM_PROMISE_STATE | Allow NULL? |
| 14 | FIN_P2P_LEVEL | Level of Promise to Pay | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | BDM_PROMISE_LEVEL | |
| 15 | FIN_PROMISED_BY | Clerk That Gave the Promise to Pay | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BDM_PROMISED_BY | Allow NULL? |
| 16 | FIN_CONTACT_MAIL | e-mail Address of Contact Person at Business Partner | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | UDM_CONTACT_EMAIL | Allow NULL? |
| 17 | FIN_CONTACT_TEL | Telephone Number of Contact Person at Business Partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | UDM_CONTACT_PHONE | Allow NULL? |
| 18 | FIN_CONTACT_FAX | Fax Number of Contact Person at Business Partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | UDM_CONTACT_FAX | Allow NULL? |
| 19 | FIN_CONTACT_FAXC | Country of Fax Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | UDM_CONTACT_FAXC | Allow NULL? |
| 20 | FIN_CONTACT_KEY | Contact Person Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | UDM_CONTACT_KEY | Allow NULL? |
| 21 | FIN_PROC_SEQNR | Sequential Number of Process | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | UDM_PROC_SEQNR | Allow NULL? |
| 22 | FIN_LOG_SYSTEM | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 23 | FIN_RFC_CREATOR | User That Created the Dispute Case via RFC | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | UDM_RFC_CREATOR | Allow NULL? |
| 24 | FIN_NO_OF_INST | Number of Installments in the Promise to Pay in Installments | int | 10 | 0 | INT4 | ((0)) | Yes | | BDM_NO_OF_INSTMNTS | Allow NULL? |
| 25 | FIN_PAID_OS | Installment Amounts Paid on Schedule | decimal | 15 | 2 | CURR | ((0)) | Yes | | BDM_PAID_ON_SCHEDULE | |
| 26 | FIN_PAID_NOT_OS | Installment Amounts Not Paid on Schedule | decimal | 15 | 2 | CURR | ((0)) | Yes | | BDM_PAID_NOT_ON_SCHEDULE | |
| 27 | FIN_NXT_INST_DUE | Due Date of Next Open Installment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | UDM_NEXT_INST_DUE_DATE | Allow NULL? |
| 28 | FIN_NXT_INST_AMT | Open Amount of Next Installment | decimal | 15 | 2 | CURR | ((0)) | Yes | | UDM_NEXT_INST_OPEN_AMT | |
| 29 | FIN_MULT_INV_CTX | UUID in character form | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SYSUUID_C | Allow NULL? |
