copy of query resultset tqGetPreConfirmedBill
table tBillReportPayment
| field name | data type | description |
|---|
| tiBillReport_ID | integer | |
| tcPaymentType | character | |
| tdPaymentAmt | decimal | |
| ttPostingDate | date | |
| ttPaymentDate | date | |
| tcBillCurrency | character | |
| tiDDocument_ID | integer | |
| tcDDocumentReference | character | |
| tcPaymentTarget | character | |
| tcPaymentInstrument | character | |
| tcGLTransaction | character | |
| tcPostingTxt | character | |
| tiPosting_ID | integer | |
| tcPaySelCode | character | |
| tcPayFormatTypeCode | character | |
| tiBill_ID | integer | |
| tdBillClosingBalanceTC | decimal(4) | |
| ttBillConfirmDate | date | |
| ttBillDate | date | |
| tiBillNumber | integer | |
| tcBillStatus | character | |
| tiBillYear | integer | |
| tiCompany_ID | integer | |
| tiDInvoiceMovement_ID | integer | |
Internal usage
unused