| 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 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | No | HRITABNR | HRTABNR | Allow NULL? |
| 3 | TABSEQNR | Sequence Number in Table Part of Table Infotype | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | HRTABSEQNR | Allow NULL? |
| 4 | PAID_INBRIN | Paid at BRIN Number for an Incoming Proof of Payment | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_INBRIN | Allow NULL? |
| 5 | BRIN_SEQ | BRIN Sequence Number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PIQ_NL_BRINSEQ | Allow NULL? |
| 6 | INITAMT | Initial Amount | decimal | 10 | 2 | CURR | ((0)) | Yes | | PIQ_NL_INIAMOUNT | |
| 7 | VALUTA_INIT | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 8 | INSTAMT | Incoming Proof of Payment Legal Tuition Fee | decimal | 10 | 2 | CURR | ((0)) | Yes | | PIQ_NL_LEGALTUTFEE | |
| 9 | VALUTA_INST | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 10 | PRF_INSTATUS | Incoming Proof of Payment Status | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_PINSTATUS | Allow NULL? |
| 11 | RECEIV_BY | Received By (User Name) | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_RECIEVBY | Allow NULL? |
| 12 | RECEIPT_DATE | Receipt Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_RECEIPTDATE | Allow NULL? |
| 13 | INCANCEL_BY | Incoming Proof of Payment Cancelled By (User Name) | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_INCANCELLEDBY | Allow NULL? |
| 14 | INCANCEL_ON | Incoming Proof of Payment Cancellation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_INCANCELLEDDATE | Allow NULL? |
| 15 | TOTAL_AMT | Amount | decimal | 10 | 2 | CURR | ((0)) | Yes | | PIQ_NL_AMOUNT | |
| 16 | VALUTA_TOT | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 17 | INST_BRIN | Institute BRIN Number | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_BRIN | Allow NULL? |
| 18 | PRF_OUTSTATUS | Outgoing Proof of Payment Status | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_POUTSTATUS | Allow NULL? |
| 19 | REG_BY | Registered By (User Name) | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_REGISTBY | Allow NULL? |
| 20 | REG_DATE | Registered Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_REGISTDATE | Allow NULL? |
| 21 | OUTCANCEL_BY | Outgoing Proof of Payment Cancelled By (User Name) | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | PIQ_NL_OUTCANCELLEDBY | Allow NULL? |
| 22 | OUTCANCEL_ON | Outgoing Proof of Payment Cancellation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PIQ_NL_OUTCANCELLEDDATE | Allow NULL? |
| 23 | LEGAL_TUTFEE | Outgoing Proof of Payment Legal Tuition Fee | decimal | 10 | 2 | CURR | ((0)) | Yes | | PIQ_NL_OUTLEGALTUTFEE | |
| 24 | VALUTA_LEGLFEE | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 25 | INST_TUTFEE | Institute Tuition Fee | decimal | 10 | 2 | CURR | ((0)) | Yes | | PIQ_NL_INSTTUTFEE | |
| 26 | VALUTA_INSTFEE | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
