field name | data type | description |
tcCompanyCode | character | |
tiCompanyId | integer | Internal ID of the active company. |
tcDaybookCode | character | |
tiInvoiceYear | integer | |
tiInvoiceVoucher | integer | |
tcAllInvoice | character | |
tcExpenseEntity | character | |
ttPostingDate | date | |
tdDInvoiceAmtCC | decimal | |
tdDInvoiceAmountTC | decimal | Used in ApiLoadDeductionDetail method. |
tdDInvoiceAmountLC | decimal | |
tcDeductionCatCodeType | character | |
tcDeductionCatCodeDesc | character | |
DInvoiceDeduction_ID | integer | |
DInvoice_ID | integer | |
DeductionCatLine_ID | integer | |
ApprovePosting_ID | integer | |
RejectPosting_ID | integer | |
PaidDInvoice_ID | integer | |
DInvoiceDeductionTC | decimal(4) | |
DInvoiceDeductionLC | decimal(4) | |
DInvoiceDeductionCC | decimal(4) | |
DInvoiceDeductionStatus | character | |
DInvoiceDeductionComment | character | |
DInvoiceDeductionApRejCom | character | |
DInvoiceDeductionApRejDate | date | |
DInvoiceDeductionCreateDate | date | |
DInvoiceDeductionSequence | integer | |
DInvoiceDeductionCustRef | character | |
DInvoiceDeductionPromotionCode | character | |
tcDeductionCatCode | character | |
LastModifiedDate | date | |
LastModifiedTime | integer | |
LastModifiedUser | character | |
CustomShort0 | character | |
CustomShort1 | character | |
CustomShort2 | character | |
CustomShort3 | character | |
CustomShort4 | character | |
CustomShort5 | character | |
CustomShort6 | character | |
CustomShort7 | character | |
CustomShort8 | character | |
CustomShort9 | character | |
CustomCombo0 | character | |
CustomCombo1 | character | |
CustomCombo2 | character | |
CustomCombo3 | character | |
CustomCombo4 | character | |
CustomCombo5 | character | |
CustomCombo6 | character | |
CustomCombo7 | character | |
CustomCombo8 | character | |
CustomCombo9 | character | |
CustomLong0 | character | |
CustomLong1 | character | |
CustomNote | character | |
CustomDate0 | date | |
CustomDate1 | date | |
CustomDate2 | date | |
CustomDate3 | date | |
CustomDate4 | date | |
CustomInteger0 | integer | |
CustomInteger1 | integer | |
CustomInteger2 | integer | |
CustomInteger3 | integer | |
CustomInteger4 | integer | |
CustomDecimal0 | decimal(4) | |
CustomDecimal1 | decimal(4) | |
CustomDecimal2 | decimal(4) | |
CustomDecimal3 | decimal(4) | |
CustomDecimal4 | decimal(4) | |
QADC01 | character | unused QAD reserved field |
QADC02 | character | unused QAD reserved field |
QADT01 | date | unused QAD reserved field |
QADD01 | decimal(10) | unused QAD reserved field |
tc_Rowid | character | |
tc_ParentRowid | character | |
tc_Status | character | |