| 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 | IMPORT_STATUS | BRF: Import Status | char | 1 | 0 | CHAR | (N' ') | No | | BRF_IMPORT_STATUS | Allow NULL? |
| 3 | APPLCLASS | BRF: Application Class | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | BRF_APPLCLASS | Allow NULL? |
| 4 | ACTION | Name of Action | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | BRF_ACTION | Allow NULL? |
| 5 | VERSION | BRF: Version | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | BRF_VERSION | Allow NULL? |
| 6 | SEQUENCE | Sequence Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | BRF_SEQUENCE_NUMBER | Allow NULL? |
| 7 | BILL_AMOUNT | Expression for Billing Amount | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_BILL_AMOUNT_EXPRESSION_PS | Allow NULL? |
| 8 | GPART | BRF Expression: Business Partner for Credit Posting | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_GPART_EXPRESSION_PS | Allow NULL? |
| 9 | VKONT | BRF Expression: Contract Acct for Credit Posting | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_VKONT_EXPRESSION_PS | Allow NULL? |
| 10 | VTREF | BRF Expression: Contract Object for Credit Posting | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_VTREF_EXPRESSION_PS | Allow NULL? |
| 11 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKHVO | HVORG_KK | Allow NULL? |
| 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFKTVO | TVORG_KK | Allow NULL? |
| 13 | FAEDN | Expression for Due Date | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_DUE_DATE_EXPRESSION_PS | Allow NULL? |
| 14 | ADD_GROUP | Grouping of Additional Items | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ADD_GROUP_KK | Allow NULL? |
| 15 | POSTREL | Posting-Relevant Line Item | char | 1 | 0 | CHAR | (N' ') | Yes | | POSTREL_KK | Allow NULL? |
| 16 | PRINTREL | Line Item Is Relevant for Printing | char | 1 | 0 | CHAR | (N' ') | Yes | | PRINTREL_KK | Allow NULL? |
| 17 | RDIGRP | Grouping for Revenue Distribution | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | RDIGRP_PS | Allow NULL? |
| 18 | PYMET | Payment Method | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_PYMET_EXPRESSION_PS | Allow NULL? |
| 19 | EMBVT | Alternataive Bank Details ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_EMBVT_EXPRESSION_PS | Allow NULL? |
| 20 | DATE_FROM | BRF: Expression | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_EXPRESSION | Allow NULL? |
| 21 | DATE_TO | BRF: Expression | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_EXPRESSION | Allow NULL? |
| 22 | RDIKEY | BRF: Expression | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BRF_EXPRESSION | Allow NULL? |