project QadFinancials > class BMFGLegalDocument > dataset BMFGLegalDocument

class dataset

object identification

primary key
lgd_domain
lgd_nbr
lgd_shipper_id
alternate key
oid_lgd_mstr

table tlgd_mstr


field namedata typemnd.description
lgd_domaincharacter(8)noDomain
lgd_nbrcharacter(12)noLegal Doc Nbr
lgd_doc_typecharacter(2)noDoc Type
lgd_addrcharacter(80)noLegal Doc Address
lgd_custcharacter(80)noCustomer
lgd_shipcharacter(80)noShip-To
lgd_billcharacter(80)noBill-To
lgd_printlogicalnoPrinted
lgd_postedlogicalnoPosted
lgd_fobcharacter(30)noFOB Point
lgd_shipviacharacter(30)noShip Via
lgd_bolcharacter(30)noBOL
lgd_inv_nbrcharacter(80)noInvoice Number
lgd_inv_datedatenoInvoice Date
lgd_gwtdecimal(10)noGross Weight
lgd_nwtdecimal(10)noNet Weight
lgd_weight_umcharacter(30)noWeight UM
lgd_voldecimal(10)noVolume
lgd_vol_umcharacter(30)noVolume UM
lgd_ship_datedatenoShip Date
lgd_cmtindxintegernoComment Index
lgd_amtdecimal(10)noLegal Doc Amount
lgd_goods_amtdecimal(10)noGoods Amount
lgd_dsc_amtdecimal(10)noDiscount Amount
lgd_ar_amtdecimal(10)noAR Amount
lgd_trl1_amtdecimal(10)noTrailer Amt 1
lgd_trl2_amtdecimal(10)noTrailer Amt 2
lgd_trl3_amtdecimal(10)noTrailer Amt 3
lgd_useridcharacter(80)noUser ID
lgd_prim_addrcharacter(80)noOrig Addr
lgd_prim_nbrcharacter(12)noOrig Doc
lgd_prim_doc_typcharacter(4)noOrig Doc Type
lgd_taxablelogicalnoTaxable
lgd_taxccharacter(30)noTax Class
lgd_tax_usagecharacter(30)noTax Usage
lgd_tax_datedatenoTax Date
lgd_tax_envcharacter(30)noTax Environment
lgd_pst_idcharacter(30)noPST ID
lgd_gst_idcharacter(30)noFed Tax ID
lgd_carriercharacter(80)noCarrier
lgd_veh_refcharacter(20)noVehicle Reference
lgd_print_datedatenoPrint Date
lgd_print_timecharacter(8)noPrint Time
lgd_print_usercharacter(8)noPrinted By
lgd_cancel_datedatenoVoid Date
lgd_cancel_timecharacter(8)noVoid Time
lgd_cancel_rsncharacter(8)noVoid Reason
lgd_cancel_usercharacter(8)noVoided By
lgd_cancel_invcharacter(80)noVoid Invoice Number
lgd_reprint_datedatenoReprint Date
lgd_reprint_timecharacter(8)noReprint Time
lgd_reprint_rsncharacter(8)noReprint Reason
lgd_reprint_usercharacter(8)noReprinted By
lgd_pst_id_replacecharacter(30)noPST ID (Subst)
lgd_trib_replacelogicalnoTributary Subst
lgd_especiecharacter(20)noShip Pack Desc
lgd_sh_cmtindxintegernoComment Index Shipper
lgd_ret_nbrcharacter(20)noReturn Nbr
lgd_simullogicalnoSimulation
lgd_prt_cmtlogicalnoPrint Comments
lgd_shipper_idcharacter(80)noShipper ID
lgd_prt_with_shplogicalnoPrint LD With Shipper
lgd_org_doc_nbrcharacter(20)noOriginal Legal Document Number
lgd_crdt_notescharacter(20)noCredit Notes
lgd_seq_idcharacter(30)noSequence ID
lgd_effdatedatenoEffective Date
lgd_ordercharacter(80)noOrder Number
lgd_rmkscharacter(40)noRemarks
lgd_shipfromcharacter(80)noShip From
lgd_loccharacter(80)noLocation
lgd_so_jobcharacter(80)noSales/Job
lgd_nbr_cpyintegernoNumber of Copies
lgd_drvcharacter(24)noDriver Name
lgd_liccharacter(24)noLicense
lgd_statuscharacter(8)noStatus
lgd_typelogicalnoLegal Document Type
lgd_mod_datedatenoModified Date
lgd_mod_useridcharacter(80)noUser ID
lgd_user1character(80)noUser Field Character 1
lgd_user2character(80)noUser Field Character 2
lgd__qadc01character(80)noQAD Character Field 1
lgd__qadc02character(80)noQAD Character Field 2
lgd__qadd01decimal(10)noQAD Decimal Field 1
lgd__qadt01datenoQAD Date Field 1
oid_lgd_mstrdecimal(10)no
lgd_shipto_sitecharacter(8)noShip-to Site
lgd_shipto_loccharacter(8)noShip-to Location
lgd_inv_movcharacter(8)noInventory Movement Code
lgd_trans_currcharacter(3)noTransaction Currency
lgd_ex_ratedecimal(10)noExch Rate
lgd_ex_rate2decimal(10)noExch Rate 2
lgd_fix_ratelogicalnoFixed Rate
lgd_trl_amtdecimal(10)noTrailer Total Amount
lgd_cr_termscharacter(80)noCredit Terms
lgd_receive_datedatenoReceiving Date
lgd_due_datedatenoDue Date
lgd_tax_inlogicalnoTax In
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tlgdd_det


field namedata typemnd.description
lgdd_domaincharacter(8)noDomain
lgdd_nbrcharacter(12)noLegal Doc Nbr
lgdd_lineintegernoLine
lgdd_partcharacter(30)noItem Number
lgdd_desccharacter(48)noDescription
lgdd_typecharacter(1)noShip Type
lgdd_pricedecimal(10)noPrice
lgdd_taxablelogicalnoTaxable
lgdd_umcharacter(30)noUM
lgdd_cmtindxintegernoComment Index
lgdd_taxccharacter(30)noTax Class
lgdd_service_codecharacter(8)noService Code
lgdd_nfc_stlogicalnoStatus
lgdd_qty_itemdecimal(10)noItem Quantity
lgdd_tax_inlogicalnoTax In
lgdd_tax_usagecharacter(30)noTax Usage
lgdd_tax_envcharacter(30)noTax Environment
lgdd_gwtdecimal(10)noGross Weight
lgdd_nwtdecimal(10)noNet Weight
lgdd_legal_classcharacter(18)noLegal Classification
lgdd_cfop_codecharacter(20)noCFOP
lgdd_trib_sitcharacter(3)noTax SIT Code
lgdd_pm_codecharacter(30)noPur/Mfg
lgdd_shipfromcharacter(80)noShip From
lgdd_shipper_idcharacter(80)noShipper ID
lgdd_ordercharacter(30)noOrder
lgdd_order_lineintegernoLine
lgdd_sh_cmtindxintegernoShipper Comment Index
lgdd_addrcharacter(80)noLegal Doc Addr
lgdd_ret_nbrcharacter(20)noRet Nbr
lgdd_doc_typecharacter(2)noDoc Type
lgdd_ext_pricedecimal(10)noExt Price
lgdd_prim_addrcharacter(30)noOrig Addr
lgdd_prim_doc_typecharacter(2)noOrig Doc Type
lgdd_prim_nbrcharacter(12)noOrig Doc
lgdd_lotsercharacter(50)noLot/Serial
lgdd_refcharacter(8)noRef
lgdd_alt_umcharacter(30)noAlternate UM
lgdd_um_convdecimal(10)noUM Conversion
lgdd_item_numcharacter(30)noItem Number
lgdd_wt_umcharacter(30)noWeight UM
lgdd_expiredatenoExpire Date
lgdd_loccharacter(80)noLocation
lgdd_mod_datedatenoModified Date
lgdd_mod_useridcharacter(80)noUser ID
lgdd_user1character(80)noUser Field Character 1
lgdd_user2character(80)noUser Field Character 2
lgdd__qadc01character(80)noQAD Character Field 1
lgdd__qadc02character(80)noQAD Character Field 2
lgdd__qadd01decimal(10)noQAD Decimal Field 1
lgdd__qadt01datenoQAD Date Field 1
oid_lgdd_detdecimal(10)no
oid_lgd_mstrdecimal(10)no
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tlgd_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