| field name | data type | mnd. | description |
|---|
| PayConf_ID | integer | yes | Record ID |
| BankNumber_ID | integer | yes | Link to BankNumber |
| Company_ID | integer | yes | Link to Company |
| AROverPayGL_ID | integer | no | Link to GL - AR OverPay |
| ARShortPayGL_ID | integer | no | Link to GL - AR ShortPay |
| AROverPayDivision_ID | integer | no | Link to Division - AR OverPay |
| ARShortPayDivision_ID | integer | no | Link to Division - AR ShortPay |
| AROverPayCostCentre_ID | integer | no | Link to CostCentre - AR OverPay |
| ARShortPayCostCentre_ID | integer | no | Link to CostCentre - AR ShortPay |
| PayConfPIBFNoInvoiceAction | character(40) | yes | If no matching invoice found |
| value list: | | {&PAYCONFNOINVOICEACTS} |
| PayConfPIBFNoCustomerAction | character(40) | yes | If customer not found |
| value list: | | {&PAYCONFNOCUSTOMERACTS} |
| PayConfPIBFNoCustOrDDocAction | character(40) | yes | If customer or payment not found |
| value list: | | {&PAYCONFNOCUSTORDDOCACTS} |
| PayConfARTolerancePercent | decimal(4) | no | Tolerance Percent |
| tcBankNumber | character(40) | yes | |
| PayConfARToleranceAmountTC | decimal(4) | no | Tolerance Amount |
| PayConfARIsTolerancePercent | logical | yes | Tolerance Percent |
| PayConfARIsToleranceAmount | logical | yes | Tolerance Amount |
| PayConfPIBFIsCreateBE | logical | yes | Create Banking Entry |
| PayConfPIBFIsAllCompanyAlloc | logical | yes | All Entities Allocation |
| PayConfPIBFIsNewDDocAsPaid | logical | yes | New Payments As Paid |
| tcOverPayGLDescription | character(40) | no | |
| tcShortPayGLDescription | character(40) | no | |
| tcShortPayGLCode | character(20) | no | |
| tcOverPayGLCode | character(20) | no | |
| tcCurrencyCode | character(20) | no | |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| CustomShort10 | character(20) | no | Custom Short Field |
| CustomShort11 | character(20) | no | Custom Short Field |
| CustomShort12 | character(20) | no | Custom Short Field |
| CustomShort13 | character(20) | no | Custom Short Field |
| CustomShort14 | character(20) | no | Custom Short Field |
| CustomCombo10 | character(20) | no | Custom Combo Field |
| CustomCombo11 | character(20) | no | Custom Combo Field |
| CustomCombo12 | character(20) | no | Custom Combo Field |
| CustomCombo13 | character(20) | no | Custom Combo Field |
| CustomCombo14 | character(20) | no | Custom Combo Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |