| 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 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 3 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPW_KK | Allow NULL? |
| 4 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 5 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPZ_KK | Allow NULL? |
| 6 | PAYBL | Document no. of payment | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | PAYBL_KK | Allow NULL? |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 8 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | AUGRD_KK | Allow NULL? |
| 9 | THPST | Entry status | char | 1 | 0 | CHAR | (N' ') | Yes | | THPST_KK | Allow NULL? |
| 10 | THPDT | Planned date for transfer of payment to third party | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | THPDT_KK | Allow NULL? |
| 11 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 12 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 13 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 14 | THPRD | Actual Date for Transfer to Third Party | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | THPRD_KK | Allow NULL? |
| 15 | THBLN | Document number with which payment was paid over | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | THBLN_KK | Allow NULL? |
| 16 | THBLN_TYPE | Document Number Type | char | 1 | 0 | CHAR | (N' ') | Yes | | THBLN_TYPE_KK | Allow NULL? |
| 17 | BCBLN | Document Number of Posting to Service Provider Account | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | BCBLN_KK | Allow NULL? |
| 18 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 19 | BUKAG | Company Code of Aggregated Posting | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKAG_KK | Allow NULL? |
| 20 | SENID | Sender ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SENID_KK | Allow NULL? |
| 21 | RECID | Recipient | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | RECID_KK | Allow NULL? |
| 22 | SENRF | Reference number assigned by the sender | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SENRF_KK | Allow NULL? |
| 23 | RECRF | Reference number assigned by recipient | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | RECRF_KK | Allow NULL? |
| 24 | HERKF | Document Origin Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | HERKF_KK | Allow NULL? |
| 25 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | Yes | | APPLK_KK | Allow NULL? |
| 26 | HVORG | Main Transaction for Line Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | HVORG_KK | Allow NULL? |
| 27 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TVORG_KK | Allow NULL? |
| 28 | WAERS | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BLWAE_KK | Allow NULL? |
| 29 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRW_KK | |
| 30 | CRSRF | Reference Number Identical for Sender and Recipient | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | CRSRF_KK | Allow NULL? |
