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 |