| 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 | BILLDOCNO | Grantor Billing Doc Number | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | GTRFIBILL_H | GTR_FI_BILLDOC_NO | Allow NULL? |
| 3 | BILLDOCITEM | Sequential Number of Document Item | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | GTR_FI_BILLDOC_ITEM | Allow NULL? |
| 4 | BILLDOCITEM_GUID | Grantor Billing Doc Item Guid (for reference Items) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GTR_FI_BILLDOC_ITEM_GUID | Allow NULL? |
| 5 | REFDOC_I_ID | Item Number of Reference Item in CRM (Agreement, Claim) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | GTR_FI_REF_DOC_I_ID | Allow NULL? |
| 6 | REFDOC_I_GUID | GUID of the reference item in CRM (Agreement, Claim) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GTR_FI_REF_DOC_I_GUID | Allow NULL? |
| 7 | REFDOC_I_OBJTP | Object Type of the reference item in CRM (Agreement, Claim) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GTR_FI_REF_DOC_I_OBJTP | Allow NULL? |
| 8 | BILL_AMOUNT | Amount in Grantor Billing Document Item | decimal | 13 | 2 | CURR | ((0)) | Yes | | GTR_FI_BILL_AMOUNT | |
| 9 | BILL_CURR | Currency of Grantor Billing Document | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | GTR_FI_BILL_CURR | Allow NULL? |
| 10 | FLG_REVERS_ITEM | Reversal Item Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | GTR_FI_BILLDOC_REV | Allow NULL? |
| 11 | DATE_FROM | Start of Period of Grantor Bill. Doc. Line Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GTR_FI_DATE_FROM | Allow NULL? |
| 12 | DATE_TO | End of Period of Grantor Bill. Doc. Line Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GTR_FI_DATE_TO | Allow NULL? |
| 13 | DUE_DATE | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GTR_FI_DUE_DATE | Allow NULL? |
| 14 | PAYMENT_TYPE | Payment Type for Grantor | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GTRT_CRM_GRM_PAYMENT_TYPE | Allow NULL? |
| 15 | EXPENSE_TYPE | Expense Type for Grantor | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | GTRT_CRM_GRM_EXPENSE_CAT | Allow NULL? |
| 16 | BRI_GUID | UUID in character form | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SYSUUID_C | Allow NULL? |
| 17 | REL_ITEM_GUID | GUID of the reference item in CRM (Agreement, Claim) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GTR_FI_REF_DOC_I_GUID | Allow NULL? |
| 18 | REL_ITEM_ID | Item Number of Reference Item in CRM (Agreement, Claim) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | GTR_FI_REF_DOC_I_ID | Allow NULL? |
| 19 | BILLDOC_I_REF | Grantor Billing Doc Item Guid (for reference Items) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | GTR_FI_BILLDOC_ITEM_GUID | Allow NULL? |
