| field name | data type | mnd. | description |
|---|
| PaymentCondition_ID | integer | yes | Record ID |
| PaymentConditionPaymentTyp | character(20) | yes | Payment Type |
| value list: | | {&PAYMENTCONDITIONPAYMENTTYPES} |
| PaymentConditionPercentage | decimal(3) | yes | Discount Percentage |
| PaymentConditionPeriodType | character(20) | yes | Period Type |
| value list: | | {&PAYMENTCONDITIONPERIODTYPES} |
| PaymentConditionDescript | character(40) | yes | Description |
| PaymentConditionCode | character(8) | yes | Credit Terms Code |
| PaymentConditionIsActive | logical | yes | Active |
| PaymentConditionDaysMonths | integer | no | No of Periods |
| PaymentConditionSupplDays | integer | no | Supplementary Days |
| PaymentConditionGraceDay | integer | no | Grace Days |
| PaymentConditionLateInt | decimal(2) | no | Daily Overdue Int Percentage |
| PaymentConditionDueDays | integer | no | Min Due Days |
| PaymentConditionBaseDate | date | no | Base Date |
| PaymentConditionBaseDays | integer | no | Base Days |
| PaymentConditionTermsInt | decimal(2) | no | Terms Interest Percentage |
| PaymentConditionPdDiscType | character(20) | no | Period Type |
| value list: | | {&PAYMENTCONDITIONPERIODTYPES} |
| PaymentConditionDayMthDisc | integer | no | No of Periods |
| PaymentConditionSupDayDisc | integer | no | Supplementary Days |
| tlPaymentConditionIsAlreadyUsed | logical | no | Used |
| 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 |
| 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 |
| field name | data type | mnd. | description |
|---|
| PaymentConditionStaged_ID | integer | yes | Record ID |
| PaymentCondition_ID | integer | yes | Credit Terms Code |
| StagedPaymentCondition_ID | integer | yes | Credit Terms |
| PaymentConditionStagedPerc | decimal(10) | yes | Percentage |
| tcStagedPaymentConditionCode | character(8) | yes | Credit Terms Code |
| tcStagedPaymentConditionDescript | character(40) | yes | Description |
| tcPaymentConditionCode | character(8) | yes | Credit Terms Code |
| 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 | yes | = tPaymentCondition.tc_Rowid |
| tc_Status | character | no | update status |