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