project QadFinancials > class BMfgPLInvoice > dataset BMfgPLInvoice

class dataset

object identification

primary key
pli_domain
pli_keyid
alternate key
oid_pli_mstr

table tpli_mstr

Description

Purchase Ledger Invoice Master

field namedata typemnd.description
pli_keyidintegeryesKey ID
pli__qadc03character(80)no
pli__qadc04character(80)no
pli_suppliercharacter(80)noSupplier
pli_invoicecharacter(30)noInvoice Number
pli_invoice_amtdecimal(10)noInvoice Amount
pli_currcharacter(30)noCurrency
pli_invoice_datedatenoInvoice Date
pli_vo_refcharacter(80)noVoucher
pli_ex_ratedecimal(10)noExch Rate
pli_ex_rate2decimal(10)noExch Rate 2
pli_ex_ratetypecharacter(80)noRate Type
pli_exru_seqintegernoSequence
pli_taxablelogicalnoTaxable
pli_taxccharacter(30)noTax Class
pli_tax_envcharacter(30)noTax Environment
pli_tax_inlogicalnoTax In
pli_tax_usagecharacter(80)noTax Usage
pli_tax_datedatenoTax Date
pli_mod_datedatenoModified Date
pli_mod_useridcharacter(80)noUser ID
pli_user1character(80)noUser Field Character 1
pli_user2character(80)noUser Field Character 2
pli__qadc01character(80)no
pli__qadc02character(80)no
pli_domaincharacter(8)yesDomain
oid_pli_mstrdecimal(10)no
pli_fix_ratelogicalnoFixed Rate
pli_cinvoice_idintegernoInvoice ID
pli_volumedecimal(10)noVolume
pli_vol_umcharacter(4)noVolume UM
pli_docmodelcharacter(3)noDocument Model
pli_goodsamtdecimal(10)noGoods Amount
pli_traileramtdecimal(10)noTrailer Amount
pli_discamtdecimal(10)noDiscount Amount
pli_ldamtdecimal(10)noLegal Doc Amount
pli_totwgtdecimal(10)noTotal Weight
pli_wt_umcharacter(30)noWeight UM
pli_cr_termscharacter(8)noCredit Terms
pli_shipperidcharacter(80)noShipper ID
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tplid_det

Description

Purchase Ledger Invoice Detail

field namedata typemnd.description
plid_pli_keyidintegeryesInvoice Key ID
plid_lineintegeryesLine
plid_order_typecharacter(30)noOrder Type
plid_ordercharacter(80)noOrder
plid_order_lineintegernoOrder Line
plid_inv_qtydecimal(10)noInvoice Quantity
plid_inv_costdecimal(10)noInvoice Cost
plid_pvo_idintegernoPending Voucher ID
plid_taxablelogicalnoTaxable
plid_taxccharacter(30)noTax Class
plid_tax_envcharacter(30)noTax Environment
plid_tax_inlogicalnoTax In
plid_tax_usagecharacter(80)noTax Usage
plid_mod_datedatenoModified Date
plid_mod_useridcharacter(80)noUser ID
plid_user1character(80)noUser Field Character 1
plid_user2character(80)noUser Field Character 2
plid__qadc01character(80)no
plid__qadc02character(80)no
plid_domaincharacter(8)yesDomain
oid_plid_detdecimal(10)no
plid_abs_idcharacter(80)noShipper ID
plid_netwgtdecimal(10)noNet Weight
plid_grosswgtdecimal(10)noGross Weight
plid_cmtindxintegernoComment Index
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tpli_mstr.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter