| 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 | T000 | MANDT | Allow NULL? |
| 2 | RBL_GUID | GUID for Table CMS_RBL | varbinary | 16 | 0 | RAW | | No | | CMS_DTE_RBL_GUID | |
| 3 | CREDITSYSTEM | Credit System | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TCMS_RBL_CRDSYS | CMS_DTE_RBL_CRDSYS | Allow NULL? |
| 4 | RBL_ID | Receivable ID | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_RBL_ID | Allow NULL? |
| 5 | PAR_GUID | Receivable Parent Guid | varbinary | 16 | 0 | RAW | | Yes | | CMS_DTE_RBL_PAR_GUID | |
| 6 | POSITIONID | Receivable Position ID | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CMS_DTE_POSID | Allow NULL? |
| 7 | PRD_CLASS | Product Class | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TCMS_PRD | CMS_DTE_PRD_CLASS | Allow NULL? |
| 8 | PRODUCT | Product of Receivable | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | TCMS_RBL_PROD | CMS_DTE_RBL_PROD | Allow NULL? |
| 9 | RBL_ORG_UNIT | Organization Unit for a Receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCMS_RBL_ORG | CMS_DTE_RBL_ORG_UNIT | Allow NULL? |
| 10 | IND_CREDIT | Indicator to specify if Receivable is Credit/Debit to Bank | char | 1 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_IND_CREDIT | Allow NULL? |
| 11 | OTHERBANK | Indicates that the Receivable belongs to an External Bank | char | 1 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_RBL_OTHERBANK | Allow NULL? |
| 12 | DESCR | Description of Receivable | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_RBL_DESCRIPTION | Allow NULL? |
| 13 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_ADMINORG | Allow NULL? |
| 14 | STATUS | Status of Receivable | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_RBL_STATUS | Allow NULL? |
| 15 | REF_CRDSYS | Reference to Credit System | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TCMS_RBL_CRDSYS | CMS_DTE_RBL_REFCRDSYS | Allow NULL? |
| 16 | REF_ID | Receivable Id | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_RBL_REFID | Allow NULL? |
| 17 | VALID_FROM | Date from which the Risk stands Valid | nvarchar | 15 | 0 | NUMC | (N'000000000000000') | Yes | | CMS_DTE_RBL_VALID_FROM | Allow NULL? |
| 18 | VALID_TO | Date until which the Risk stands Valid | nvarchar | 15 | 0 | NUMC | (N'000000000000000') | Yes | | CMS_DTE_RBL_VALID_TO | Allow NULL? |
| 19 | FIXED_FROM | Start Date of Fixed Period of Receivable Conditions | nvarchar | 15 | 0 | NUMC | (N'000000000000000') | Yes | | CMS_DTE_RBL_FIXED_FROM | Allow NULL? |
| 20 | FIXED_TO | End Date of Fixed Period of Receivable Conditions | nvarchar | 15 | 0 | NUMC | (N'000000000000000') | Yes | | CMS_DTE_RBL_FIXED_TO | Allow NULL? |
| 21 | CONT_AMOUNT | Amount of Receivable Contract | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_CONTAMT | |
| 22 | CONT_CURRENCY | Receivable Contract Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CONTCURR | Allow NULL? |
| 23 | AMT_MAXRISK | Maximum Risk | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_MAXRISK | |
| 24 | AMT_CURRRISK | Current Risk | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_CURRRISK | |
| 25 | CURR_RISK | Currency for Receivable Risk Amounts | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_RISKCURR | Allow NULL? |
| 26 | AMT_OBLIG | Disbursement Obligation | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_OBLIG | |
| 27 | CURR_OBLIG | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 28 | AMT_UTIL | Utilization Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_UTIL | |
| 29 | CURR_UTIL | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 30 | AMT_DRAWDOWN | Drawdown of Receivable | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_DRAWDOWN | |
| 31 | CURR_DRAWDOWN | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 32 | AMT_INTEREST | Outstanding Interest Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_INTEREST | |
| 33 | CURR_INTEREST | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 34 | AMT_FEES | Fees Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_FEES | |
| 35 | CURR_FEES | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 36 | AMT_1 | Receivable Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_AMT | |
| 37 | CURR_1 | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 38 | AMT_2 | Receivable Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_AMT | |
| 39 | CURR_2 | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 40 | AMT_3 | Receivable Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_AMT | |
| 41 | CURR_3 | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 42 | AMT_4 | Receivable Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_AMT | |
| 43 | CURR_4 | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 44 | AMT_DEBT_ARR | Debt in arrears | decimal | 17 | 2 | CURR | ((0)) | Yes | | CMS_DTE_RBL_DEBT_ARREARS | |
| 45 | CURR_DEBT_ARR | Currency of Receivable Capitals | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CMS_DTE_RBL_CAPCURR | Allow NULL? |
| 46 | ORG_UNIT1 | Organizational Unit 1: Receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_RBL_ORG_UNIT1 | Allow NULL? |
| 47 | ORG_UNIT2 | Organizational Unit 2: Receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_RBL_ORG_UNIT2 | Allow NULL? |
| 48 | ORG_UNIT3 | Organizational Unit 3: Receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_RBL_ORG_UNIT3 | Allow NULL? |
| 49 | ORG_UNIT4 | Organizational Unit 4: Receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_RBL_ORG_UNIT4 | Allow NULL? |
| 50 | ORG_UNIT5 | Organizational Unit 5: Receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CMS_DTE_RBL_ORG_UNIT5 | Allow NULL? |
| 51 | CREATED_BY | Login ID of the User who created the Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_USER | Allow NULL? |
| 52 | CREATED_AT | Creation Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | CMS_DTE_CREATED_AT | |
| 53 | CHANGED_BY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_LAST_CHNG_USER | Allow NULL? |
| 54 | CHANGED_AT | Change Timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | CMS_DTE_CHANGED_AT | |
| 55 | SOURCEOFENTRY | Source of Entry | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CMS_DTE_SOURCE_OF_ENTRY | Allow NULL? |
