| field name | data type | db field | description |
|---|
| tiBill_ID | integer | Bill.Bill_ID | Record ID |
| tdBillClosingBalanceTC | decimal | Bill.BillClosingBalanceTC | TC Closing Balance |
| ttBillConfirmDate | date | Bill.BillConfirmDate | Bill Confirm Date |
| ttBillDate | date | Bill.BillDate | Bill Date |
| ttBillDueDate | date | Bill.BillDueDate | Bill Due Date |
| tiBillNumber | integer | Bill.BillNumber | Bill Number |
| tcBillStatus | character | Bill.BillStatus | Status |
| tiBillYear | integer | Bill.BillYear | Bill Year |
| tiCompany_ID | integer | Bill.Company_ID | Link to Company |
| tiCurrency_ID | integer | Bill.Currency_ID | Link to Currency |
| tcCustomCombo0 | character | Bill.CustomCombo0 | Custom Combo Field |
| tcCustomCombo1 | character | Bill.CustomCombo1 | Custom Combo Field |
| tcCustomCombo2 | character | Bill.CustomCombo2 | Custom Combo Field |
| tcCustomCombo3 | character | Bill.CustomCombo3 | Custom Combo Field |
| tcCustomCombo4 | character | Bill.CustomCombo4 | Custom Combo Field |
| tcCustomCombo5 | character | Bill.CustomCombo5 | Custom Combo Field |
| tcCustomCombo6 | character | Bill.CustomCombo6 | Custom Combo Field |
| tcCustomCombo7 | character | Bill.CustomCombo7 | Custom Combo Field |
| tcCustomCombo8 | character | Bill.CustomCombo8 | Custom Combo Field |
| tcCustomCombo9 | character | Bill.CustomCombo9 | Custom Combo Field |
| ttCustomDate0 | date | Bill.CustomDate0 | Custom Date Field |
| ttCustomDate1 | date | Bill.CustomDate1 | Custom Date Field |
| ttCustomDate2 | date | Bill.CustomDate2 | Custom Date Field |
| ttCustomDate3 | date | Bill.CustomDate3 | Custom Date Field |
| ttCustomDate4 | date | Bill.CustomDate4 | Custom Date Field |
| tdCustomDecimal0 | decimal | Bill.CustomDecimal0 | Custom Decimal Field |
| tdCustomDecimal1 | decimal | Bill.CustomDecimal1 | Custom Decimal Field |
| tdCustomDecimal2 | decimal | Bill.CustomDecimal2 | Custom Decimal Field |
| tdCustomDecimal3 | decimal | Bill.CustomDecimal3 | Custom Decimal Field |
| tdCustomDecimal4 | decimal | Bill.CustomDecimal4 | Custom Decimal Field |
| tiCustomInteger0 | integer | Bill.CustomInteger0 | Custom Integer Field |
| tiCustomInteger1 | integer | Bill.CustomInteger1 | Custom Integer Field |
| tiCustomInteger2 | integer | Bill.CustomInteger2 | Custom Integer Field |
| tiCustomInteger3 | integer | Bill.CustomInteger3 | Custom Integer Field |
| tiCustomInteger4 | integer | Bill.CustomInteger4 | Custom Integer Field |
| tcCustomLong0 | character | Bill.CustomLong0 | Custom Long Field |
| tcCustomLong1 | character | Bill.CustomLong1 | Custom Long Field |
| tcCustomNote | character | Bill.CustomNote | Custom Note Field |
| tcCustomShort0 | character | Bill.CustomShort0 | Custom Short Field |
| tcCustomShort1 | character | Bill.CustomShort1 | Custom Short Field |
| tcCustomShort2 | character | Bill.CustomShort2 | Custom Short Field |
| tcCustomShort3 | character | Bill.CustomShort3 | Custom Short Field |
| tcCustomShort4 | character | Bill.CustomShort4 | Custom Short Field |
| tcCustomShort5 | character | Bill.CustomShort5 | Custom Short Field |
| tcCustomShort6 | character | Bill.CustomShort6 | Custom Short Field |
| tcCustomShort7 | character | Bill.CustomShort7 | Custom Short Field |
| tcCustomShort8 | character | Bill.CustomShort8 | Custom Short Field |
| tcCustomShort9 | character | Bill.CustomShort9 | Custom Short Field |
| tiDebtor_ID | integer | Bill.Debtor_ID | Link to Debtor |
| tiDInvoiceMovement_ID | integer | Bill.DInvoiceMovement_ID | Link to highest DInvoiceMovement |
| tiEmployee_ID | integer | Bill.Employee_ID | Link to Employee |
| ttLastModifiedDate | date | Bill.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | Bill.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | Bill.LastModifiedUser | Last Modified User |
| tcQADC01 | character | Bill.QADC01 | unused QAD reserved field |
| tcQADC02 | character | Bill.QADC02 | unused QAD reserved field |
| tdQADD01 | decimal | Bill.QADD01 | unused QAD reserved field |
| ttQADT01 | date | Bill.QADT01 | unused QAD reserved field |
each Bill where