| field name | data type | mnd. | description |
|---|---|---|---|
| APMatching_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| CInvoice_ID | integer | yes | Voucher |
| Reason_ID | integer | yes | Invoice Status Code |
| Period_ID | integer | yes | GL Period |
| Currency_ID | integer | yes | Currency Code |
| Journal_ID | integer | no | Daybook |
| Posting_ID | integer | no | Voucher |
| CirecPostingLine_ID | integer | no | Link to PostingLine |
| APMatchingTotalAmountTC | decimal(4) | yes | TC to Allocate |
| APMatchingTotalAmountLC | decimal(4) | no | BC to Allocate |
| APMatchingARRecTaxTC | decimal(4) | no | Recoverable Receipt Tax |
| APMatchingARNRecTaxTC | decimal(4) | no | Non-recoverable Receipt Tax |
| APMatchingAIRecTaxTC | decimal(4) | no | Recoverable Invoice Tax |
| APMatchingAINRecTaxTC | decimal(4) | no | Non-recoverable Invoice Tax |
| APMatchingCInvoiceDiscPct | decimal(2) | no | Discount Percentage |
| APMatchingStatus | character(20) | yes | Status |
| value list: | {&APMATCHINGSTATUSES} | ||
| APMatchingDate | date | yes | Date |
| APMatchingTaxEnv | character(16) | no | Tax Environment |
| tcReasonCode | character(20) | yes | Invoice Status Code |
| tiPeriodYear | integer | yes | Year/Pd |
| tiPeriodPeriod | integer | yes | GL Period |
| tiPostingVoucher | integer | no | Voucher |
| tcCurrencyCode | character(3) | yes | Currency Code |
| tcJournalCode | character(8) | no | Daybook |
| tiCInvoicePostingYear | integer | yes | Year |
| tiCInvoiceVoucher | integer | yes | Voucher |
| tcCInvoiceJournalCode | character(8) | yes | Daybook Code |
| tcCreditorCode | character(8) | yes | Supplier Code |
| tiBusinessRelationID | integer | yes | |
| tcBusinessRelationCode | character(20) | no | Business Relation |
| tdCInvoiceExchangeRate | decimal(10) | yes | Rate between TC and LC at the moment of the invoice (type: accounting) |
| tdCInvoiceRateScale | decimal(10) | yes | Scale between TC and LC at the moment of the invoice (type: accounting) |
| tdCInvoiceCCRate | decimal(10) | yes | Rate between TC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| tdCInvoiceCCScale | decimal(10) | yes | Scale between TC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| tdCInvoiceLCCCRate | decimal(10) | no | Rate between LC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| tdCInvoiceLCCCScale | decimal(10) | no | Scale between LC and SC at the moment of the invoice (type: Statutory - optional: accounting) |
| ttCInvoiceDate | date | yes | Invoice Date |
| ttCInvoicePostingDate | date | yes | Posting-date of the invoice |
| tcCInvoiceReference | character(22) | yes | Reference |
| tcCInvoiceType | character(20) | yes | Invoice Type |
| value list: | {&INVOICETYPES} | ||
| ttCInvoiceTaxPointDate | date | yes | Tax Point Date |
| tcCInvoicePaymentConditionCode | character(8) | no | Credit Terms Code |
| tlCInvoiceIsInitialStatus | logical | yes | Initial Status |
| tiCInvoiceRegistrationNr | integer | yes | Registration Number |
| tcCreditorAddrTaxIDFederal | character(18) | no | Federal Tax |
| tcCreditorAddrTaxIDState | character(18) | no | State Tax |
| tcCreditorAddrTaxIDMisc1 | character(18) | no | Miscellaneous Tax 1 |
| tcCreditorAddrTaxIDMisc2 | character(18) | no | Miscellaneous Tax 2 |
| tcCreditorAddrTaxIDMisc3 | character(18) | no | Miscellaneous Tax 3 |
| tlCreditorAddrIsTaxInCity | logical | no | Tax in City |
| tlCreditorAddrIsEUCountry | logical | no | EU Member |
| tcCreditorAddrCountryCode | character(3) | no | Country Code |
| tcShipToAddrTaxIDFederal | character(18) | no | Federal Tax |
| tcShipToAddrTaxIDState | character(18) | no | State Tax |
| tcShipToAddrTaxIDMisc1 | character(18) | no | Miscellaneous Tax 1 |
| tcShipToAddrTaxIDMisc2 | character(18) | no | Miscellaneous Tax 2 |
| tcShipToAddrTaxIDMisc3 | character(18) | no | Miscellaneous Tax 3 |
| tiShipToAddrTaxDeclaration | integer | no | Tax Declaration |
| tlShipToAddrIsTaxInCity | logical | no | Tax in City |
| tlShipToAddrIsEUCountry | logical | no | EU Member |
| tcShipToAddrCountryCode | character(3) | no | Country Code |
| tcBusinessRelationICCode | character(20) | no | |
| tlIsUpdateCInvoiceAutomatically | logical | no | This flag indicates, whether supplier invoice (total amount and taxes) should be updated automatically during save of receiver matching or not. |
| tlJournalAccessAllowed | logical | no | Used to determine whether a user has access to modify an ap matching |
| tiNormalPaymentCondition_ID | integer | yes | |
| tiShipToAddress_ID | integer | yes | |
| tiCreditorAddr_ID | integer | 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 |
| 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 |
|---|---|---|---|
| APMatchingLn_ID | integer | yes | Record ID |
| APMatching_ID | integer | yes | Link to APMatching |
| PvoPostingLine_ID | integer | no | Link to PostingLine |
| VarRatePostingLine_ID | integer | no | Link to PostingLine |
| VarUsagePostingLine_ID | integer | no | Link to PostingLine |
| VarExchRatePostingLine_ID | integer | no | Exch Rate Posting Line |
| VarExchRatCCPostingLine_ID | integer | no | SC Exch Rate Posting Line |
| NewExpensePostingLine_ID | integer | no | Link to PostingLine |
| RevExpensePostingLine_ID | integer | no | Link To PostingLine |
| GL_ID | integer | no | Account |
| Division_ID | integer | no | Sub-Account |
| CostCentre_ID | integer | no | Cost Center |
| Project_ID | integer | no | Project Code |
| PvoDomain | character(8) | yes | Domain |
| PvoID | integer | yes | Pinv ID |
| PvodLineID | integer | yes | Pinv Line ID |
| APMatchingLnPvodIsLgCharge | logical | yes | Log Charge |
| APMatchingLnPvodLgCharge | character(20) | no | Logistic Charge |
| APMatchingLnPvodItemType | character(20) | yes | Possible values: Normal, Memo or Sub-contract |
| value list: | {&APMATCHINGLNPVODITEMTYPES} | ||
| APMatchingLnPvodCostMtdGL | character(20) | yes | GL Cost Method |
| value list: | {&COSTMETHODS} | ||
| APMatchingLnPvodCostMtdCur | character(20) | yes | Current Cost Method |
| value list: | {&COSTMETHODS} | ||
| APMatchingLnPvodExchRate | decimal(10) | no | Exchange Rate |
| APMatchingLnPvodExchRate2 | decimal(10) | no | Exchange Rate 2 |
| APMatchingLnPvodCCRate | decimal(10) | no | Rate between LC and SC at the moment of the receipt (type: Statutory - optional: accounting) |
| APMatchingLnPvodCCScale | decimal(10) | no | Scale between LC and SC at the moment of the receipt (type: Statutory - optional: accounting) |
| APMatchingLnPvodReceiptQty | decimal(10) | no | Receipt Quantity |
| APMatchingLnPvodUnitPrice | decimal(10) | no | Unit Price |
| APMatchingLnPvodIsTaxIncl | logical | yes | Tax Included |
| APMatchingLnPvodUnitPrNT | decimal(10) | no | Unit Price (excl Tax) |
| APMatchingLnPvodAccruedTC | decimal(4) | no | TC Accrued Amount |
| APMatchingLnPvodInvoicedTC | decimal(4) | no | TC Invoiced Amount |
| APMatchingLnPvodOpenQty | decimal(10) | no | Open Quantity |
| APMatchingLnPvodOpenAmtTC | decimal(4) | no | TC Open Amt |
| APMatchingLnPvodGLCode | character(20) | no | Account (Pinv) |
| APMatchingLnPvodDivCode | character(20) | no | Sub-Account (Pinv) |
| APMatchingLnPvodCCCode | character(20) | no | Cost Center (Pinv) |
| APMatchingLnPvodPrjCode | character(20) | no | Project (Pinv) |
| APMatchingLnPvodCurrency | character(20) | no | Currency |
| APMatchingLnPvodIntRef | character(50) | no | Internal Ref |
| APMatchingLnPvodExtRef | character(50) | no | External Ref |
| APMatchingLnPvodPackingQty | decimal(10) | no | Packing Slip Qty |
| APMatchingLnPvodSupplItem | character(30) | no | Supplier Item |
| APMatchingLnPvodItem | character(20) | no | Item |
| APMatchingLnPvodItemDescr1 | character(24) | no | Item Description |
| APMatchingLnPvodItemDescr2 | character(24) | no | Item Description (2) |
| APMatchingLnPvodUoM | character(20) | no | GL Unit of Measure |
| APMatchingLnPvodUoMConv | decimal(10) | no | Conversion factor between base UoM and PO UoM |
| APMatchingLnPvodSupplier | character(8) | no | Supplier |
| APMatchingLnPvodOrderType | character(20) | no | Order Type |
| value list: | {&APMATCHINGLNPVODORDERTYPES} | ||
| APMatchingLnPvodOrder | character(20) | no | Order |
| APMatchingLnPvodOrderLnNbr | integer | no | Order Line Nbr |
| APMatchingLnPvodTransDate | date | no | Transaction Date |
| APMatchingLnPvodSite | character(20) | no | APMatchingLnPvodSite |
| APMatchingLnPvodCompID | integer | yes | APMatchingLnPvodCompID |
| APMatchingLnPvodCompCode | character(20) | no | APMatchingLnPvodCompCode |
| APMatchingLnPvodConvFactor | decimal(8) | yes | APMatchingLnPvodConvFactor; The unit of measure conversion factor for a PO receipt. |
| APMatchingLnPvodPayCond | character(8) | no | Credit Terms |
| APMatchingLnPvodPLiKeyId | integer | no | PLI Key |
| APMatchingLnPvodPLidLine | integer | no | PLI Line |
| APMatchingLnPvodIsTaxable | logical | yes | Taxable (pvo) |
| APMatchingLnPvodTaxEnv | character(16) | no | Tax Env (pvo) |
| APMatchingLnPvodTaxClass | character(3) | no | Tax Class (pvo) |
| APMatchingLnPvodTaxUsage | character(8) | no | Tax Usage (pvo) |
| APMatchingLnIsPvodFinished | logical | yes | Finished |
| APMatchingLnPvodOpAllocCode | character(8) | no | Op Alloc Code (Pinv) |
| APMatchingLnMatchQty | decimal(10) | no | Matched Quantity |
| APMatchingLnPvodFromTaxZone | character(16) | no | From Tax Zone (pvo) |
| APMatchingLnMatchUnitPrice | decimal(10) | no | Matched Unit Price |
| APMatchingLnPvodToTaxZone | character(16) | no | To Tax Zone (pvo) |
| APMatchingLnMatchIsTaxIncl | logical | yes | Tax Included |
| APMatchingLnMatchUnitPrNT | decimal(10) | no | Matched Unit Price (excl Tax) |
| APMatchingLnMatchAmtTxInTC | decimal(4) | no | TC Matched Amount (incl Tax) |
| APMatchingLnMatchAmtTC | decimal(4) | no | TC Matched Amount |
| APMatchingLnMatchAmtLC | decimal(4) | no | BC Matched Amount |
| APMatchingLnMatchAmtCC | decimal(4) | no | SC Matched Amount |
| APMatchingLnReceiptAmtTC | decimal(4) | no | TC Receipt Amt |
| APMatchingLnReceiptAmtLC | decimal(4) | no | BC Receipt Amt |
| APMatchingLnReceiptAmtCC | decimal(4) | no | SC Receipt Amount |
| APMatchingLnVarRateTC | decimal(4) | no | TC Rate Variance |
| APMatchingLnVarRateLC | decimal(4) | no | BC Rate Variance |
| APMatchingLnVarRateCC | decimal(4) | no | SC Rate Variance |
| APMatchingLnVarUsageTC | decimal(4) | no | TC Usage Variance |
| APMatchingLnVarUsageLC | decimal(4) | no | BC Usage Variance |
| APMatchingLnVarUsageCC | decimal(4) | no | SC Usage Variance |
| APMatchingLnVarExchRateLC | decimal(4) | no | BC Exch Rate Variance |
| APMatchingLnVarExchRateCC | decimal(4) | no | SC Exch Rate Variance |
| APMatchingLnIsVarGLPosting | logical | yes | Yes: Use G/L Var account No: Use WIP account |
| APMatchingLnIsTaxable | logical | yes | Taxable |
| APMatchingLnTaxEnv | character(16) | no | Tax Env |
| APMatchingLnTaxClass | character(3) | no | Tax Class |
| APMatchingLnTaxUsage | character(8) | no | Tax Usage |
| APMatchingLnOpAllocCode | character(8) | no | Op Alloc Code |
| tcGLCode | character(8) | no | Account |
| tcDivisionCode | character(8) | no | Sub-Account |
| tcCostCentreCode | character(4) | no | Cost Center |
| tcProjectCode | character(8) | no | Project Code |
| tdAPMatchingLnPendingMatchAmtTC | decimal(4) | no | Pending Matched Amt TC of this Pending Voucher Detail on other initial Matchings |
| tdAPMatchingLnPendingMatchQty | decimal(10) | no | Pending Matched Qty of this Pending Voucher Details on other initial Matchings |
| tlIsSelected | logical | no | Selected |
| tlIsNeededToRecallGTM | logical | no | Need To Call GTM |
| tdAPMatchingLnARRecTaxTC | decimal(4) | no | APMatchingLnARRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMatchignLnTax records. This field gets filled in a submethod of ValidateComponent. |
| tdAPMatchingLnARNRecTaxTC | decimal(4) | no | APMatchingLnARNRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMathcignLnTax records. This field gets filled in a submethod of ValidateComponent. |
| tdAPMatchingLnAIRecTaxTC | decimal(4) | no | APMatchingLnAIRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMathcignLnTax records. This field gets filled in a submethod of ValidateComponent. |
| tdAPMatchingLnAINRecTaxTC | decimal(4) | no | APMatchingLnAINRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMathcignLnTax records. This field gets filled in a submethod of ValidateComponent. |
| tdAPMatchingLnOrigARRetainTaxTC | decimal(4) | no | APMatchingLnOrigARRetainTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the TaxTC fields on the tax-details of the pvo that have the Retained on. This field is not based upon the data in tAPMatchingLnTax but based upon the taxes of the pending-voucher. This field gets filled in a submethod of ValidateComponent. |
| tdAPMatchingLnOrigARRecTaxTC | decimal(4) | no | APMatchingLnOrigARRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the Recoverable TaxTC fields on the tax-details of the pvo that are marked as AccrueAtReceipt. This field is not based upon the data in tAPMatchingLnTax but based upon the taxes of the pending-voucher. This field gets filled in a submethod of ValidateComponent. |
| tdAPMatchingLnOrigARNRecTaxTC | decimal(4) | no | APMatchingLnOrigARNRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the non-rRecoverable TaxTC fields on the tax-details of the pvo that are marked as AccrueAtReceipt. This field is not based upon the data in tAPMatchingLnTax but based upon the taxes of the pending-voucher. This field gets filled in a submethod of ValidateComponent. |
| tcAPMatchingLnCostAdjGLCode | character(20) | no | For BL purposes only. This field contains GL account used for posting of cost adjustment amount. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnCostAdjDivCode | character(20) | no | For BL purposes only. This field contains Division used for posting of cost adjustment amount. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnCostAdjCCCode | character(20) | no | For BL purposes only. This field contains Cost Centre used for posting of cost adjustment amount. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnDiscrpGLCode | character(20) | no | This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnDiscrpDivCode | character(20) | no | For BL purposes only. This field contains Division used for posting of discrepancy amount. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnDiscrpCCCode | character(20) | no | For BL purposes only. This field contains Cost Centre for posting of discrepancy amount. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnRateVarGLCode | character | no | APMatchingLnRateVarGLCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnRateVarDivCode | character | no | APMatchingLnRateVarDivCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnRateVarCCCode | character | no | APMatchingLnRateVarCCCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnPVVGLCode | character | no | APMatchingLnPVVGLCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnPVVDivCode | character | no | APMatchingLnPVVDivCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnPVVCCCode | character | no | APMatchingLnPVVCCCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tlLogChargeHeaderIsFinished | logical | no | Field used to hold the IsFinished-property that was stated on the logistic-charge pop-up form |
| tlLogChargeHeaderIsSelected | logical | no | Field used to hold the IsSelected-property that was stated on the logistic-charge pop-up form |
| tdLogChargeHeaderMatchedAmountTC | decimal(4) | no | Field used to hold the MatchedAmount-property that was stated on the logistic-charge pop-up form |
| 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 |
| ttAPMatchingLnPvodEffDate | date | no | Pending voucher effective date |
| tcAPMatchingLnUsageVarGLCode | character | no | APMatchingLnUsageVarGLCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnUsageVarDivCode | character | no | APMatchingLnUsageVarDivCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tcAPMatchingLnUsageVarCCCode | character | no | APMatchingLnUsageVarCCCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tAPMatching.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| APMatchingLnRevTax_ID | integer | yes | Record ID |
| APMatching_ID | integer | no | Link to APMatching |
| APMatchingLn_ID | integer | yes | Link to APMatchingLn |
| PostingLine_ID | integer | yes | Link to PostingLine |
| 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 | = tAPMatchingLn.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| APMatchingLnTax_ID | integer | yes | Record ID |
| APMatchingLn_ID | integer | yes | Link to APMatchingLn |
| APMatching_ID | integer | no | Link to APMatching |
| Vat_ID | integer | no | Tax Code |
| APRatePostingLine_ID | integer | no | Link to PostingLine |
| PPVPostingLine_ID | integer | no | Link to PostingLine |
| NormalTaxPostingLine_ID | integer | no | Link to PostingLine |
| AbsRetTaxPostingLine_ID | integer | no | Link to PostingLine |
| NormalTaxGL_ID | integer | no | Normal Tax Account |
| NormalTaxDivision_ID | integer | no | Normal Tax Sub-Account |
| AbsRetTaxGL_ID | integer | no | Retained Tax Account |
| AbsRetTaxDivision_ID | integer | no | Retained Tax Sub-Account |
| SuspDelTaxGL_ID | integer | no | Delayed Tax Account |
| SuspDelTaxDivision_ID | integer | no | Delayed Tax Sub-Account |
| APMatchingLnTaxTaxType | character(16) | yes | Tax Type |
| APMatchingLnTaxTaxTrType | character(2) | yes | Transaction Type |
| value list: | {&VATTAXTRANSACTIONTYPES} | ||
| APMatchingLnTaxBaseTC | decimal(4) | no | TC Tax Base |
| APMatchingLnTaxBaseLC | decimal(4) | no | LC Tax Base |
| APMatchingLnTaxTaxTC | decimal(4) | no | TC Tax |
| APMatchingLnTaxTaxLC | decimal(4) | no | LC Tax |
| APMatchingLnTaxIsAccrRcp | logical | yes | Accrue at Receipt or Usage |
| APMatchingLnTaxIsDiscAtInv | logical | yes | Discount Tax at Invoice |
| APMatchingLnTaxIsAbsRet | logical | yes | Absorbed or Retained Tax |
| APMatchingLnTaxIsUpdAllow | logical | yes | Update Tax Allowed |
| APMatchingLnTaxIsRevCharge | logical | yes | Reverse Charge |
| APMatchingLnTaxIsSuspDel | logical | yes | Delayed Tax |
| APMatchingLnTaxIsTIAllowed | logical | yes | Allow Tax Included |
| APMatchingLnTaxIsTaxIncl | logical | yes | Tax Incl |
| APMatchingLnTaxTaxPct | decimal(2) | no | Tax Percentage |
| APMatchingLnTaxRecovTaxPct | decimal(2) | no | Recoverable Tax Percentage |
| APMatchingLnTaxARRecTaxTC | decimal(4) | no | TC Recov Tax Accrued at Receipt |
| APMatchingLnTaxARNRecTaxTC | decimal(4) | no | TC Non Recov Tax Accrued at Receipt |
| APMatchingLnTaxAIRecTaxTC | decimal(4) | no | TC Recoverable Tax Accrued at Invoice |
| APMatchingLnTaxAINRecTaxTC | decimal(4) | no | TC Non Recov Tax Accrued at Invoice |
| tcVatCode | character(20) | no | Tax Code |
| tcDomainCode | character(8) | no | Domain |
| tcVatInOut | character(20) | no | Tax In/Out |
| tcNormalTaxGLCode | character(8) | no | Normal Tax Account |
| tcNormalTaxDivisionCode | character(8) | no | Normal Tax Sub-Account |
| tcAbsRetTaxGLCode | character(8) | no | Retained Tax Account |
| tcAbsRetTaxDivisionCode | character(8) | no | Retained Tax Sub-Account |
| tcSuspDelTaxGLCode | character(8) | no | Delayed Tax Account |
| tcSuspDelTaxDivisionCode | character(8) | no | Delayed Tax Sub-Account |
| 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 | = tAPMatchingLn.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| APMatchingLnWHT_ID | integer | yes | Record ID |
| APMatchingLn_ID | integer | yes | Link to APMatchingLn |
| APMatching_ID | integer | no | Link to APMatching |
| APMatchingLnTax_ID | integer | no | Link To APMatchingLnTax |
| Vat_ID | integer | no | Link to Vat |
| GL_ID | integer | no | Link To GL |
| Division_ID | integer | no | Link To Division |
| APMatchingLnWHTFeeDebTC | decimal(4) | no | TC Fee (DR) |
| APMatchingLnWHTFeeCredTC | decimal(4) | no | TC Fee (CR) |
| APMatchingLnWHTExpDebTC | decimal(4) | no | TC Expense (DR) |
| APMatchingLnWHTExpCredTC | decimal(4) | no | TC Expense (CR) |
| APMatchingLnWHTTxFeeDebTC | decimal(4) | no | TC Taxable Fee (DR) |
| APMatchingLnWHTTxFeeCredTC | decimal(4) | no | TC Taxable Fee (CR) |
| APMatchingLnWHTTxFeeDebLC | decimal(4) | no | BC Taxable Fee (DR) |
| APMatchingLnWHTTxFeeCredLC | decimal(4) | no | BC Taxable Fee (CR) |
| APMatchingLnWHTAmtDebTC | decimal(4) | no | TC WHT Amt (DR) |
| APMatchingLnWHTAmtCredTC | decimal(4) | no | TC WHT Amt (CR) |
| APMatchingLnWHTAmtDebLC | decimal(4) | no | BC WHT Amt (DR) |
| APMatchingLnWHTAmtCredLC | decimal(4) | no | BC WHT Amt (CR) |
| APMatchingLnWHTTaxPct | decimal(2) | no | Tax Percentage |
| APMatchingLnWHTRecovTaxPct | decimal(2) | no | Recoverable Tax Percentage |
| APMatchingLnWHTTaxType | character(20) | no | Tax Type |
| APMatchingLnWHTTaxTrType | character(2) | no | Transaction Type |
| APMatchingLnWHTIsUpdAllow | logical | yes | Update Tax Allowed |
| APMatchingLnWHTBaseTaxPct | decimal(2) | no | Tax Base Percentage |
| tcVatCode | character(20) | no | |
| tcDomainCode | character(8) | no | |
| tcVatInOut | character(20) | no | |
| tcGLCode | character(8) | no | |
| tcDivisionCode | character(8) | no | |
| tcVatDescription | character(40) | 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 |
| 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 | = tAPMatchingLn.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcGLCode | character | |
| tcDivisionCode | character | |
| tcCostCentreCode | character | |
| tcProjectCode | character | |
| tcSafStructureCode | character | |
| tcCurrencyCode | character | |
| tcLineText | character | |
| tdDebitTC | decimal | |
| tdDebitLC | decimal | |
| tdDebitCC | decimal | |
| tdCreditTC | decimal | |
| tdCreditLC | decimal | |
| tdCreditCC | decimal | |
| tcExchangeRateType | character | |
| tdExchangeRate | decimal | |
| tdExchangeRateScale | decimal | |
| tdPostingLineCCRate | decimal | |
| tdPostingLineCCScale | decimal | |
| ttExchangeRateDate | date | |
| tc_Status | character | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tcAllocationType | character | |
| tcAllocationKey | character | |
| ttTaxPointDate | date | |
| tcPostingVatInOut | character | |
| tcPostingVatCode | character | |
| tcPostingVatDomain | character | |
| tcTransactionType | character | |
| tcTaxTransactionType | character | |
| tdBaseDebitTC | decimal | |
| tdBaseCreditTC | decimal | |
| tdBaseDebitLC | decimal | |
| tdBaseCreditLC | decimal | |
| tdBaseDebitCC | decimal | |
| tdBaseCreditCC | decimal | |
| tdVatDebitTC | decimal | |
| tdVatCreditTC | decimal | |
| tdVatDebitLC | decimal | |
| tdVatCreditLC | decimal | |
| tdVatDebitCC | decimal | |
| tdVatCreditCC | decimal | |
| tlNormalTaxIsAlreadyAbsRet | logical | |
| tcAbsRetTaxGLCode | character | |
| tcAbsRetTaxDivisionCode | character | |
| tcFromTaxZone | character | |
| tcToTaxZone | character | |
| tcTaxEnvironment | character | |
| tlIsTaxable | logical | |
| tcTaxClass | character | |
| tcTaxUsage | character | |
| tcTaxType | character | |
| tlTaxIsReverseChargeDomestic | logical | |
| tiTaxAddressID | integer | |
| tcTaxIDFeder | character | |
| tcTaxIDState | character | |
| tcTaxIDMisc1 | character | |
| tcTaxIDMisc2 | character | |
| tcTaxIDMisc3 | character | |
| tiOwnAddressID | integer | |
| tcOwnTaxIDFeder | character | |
| tcOwnTaxIDState | character | |
| tcOwnTaxIDMisc1 | character | |
| tcOwnTaxIDMisc2 | character | |
| tcOwnTaxIDMisc3 | character | |
| tiOwnTaxIDDeclarat | integer | |
| tlIsSuspDel | logical | |
| tlCalledFromMoveSuspDelTax | logical |
| field name | data type | description |
|---|---|---|
| tcSafCode | character | |
| tcSafConcept | character | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |