Uploaded by User36366

ERD

advertisement
ad_orginfo
ad_org_id
NUMERIC(10,0)
ad_client_id
NUMERIC(10,0)
isactive
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
NUMERIC(10,0)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
c_location_id
CHARACTER(11)
CHARACTER VARYING(20)
pa_goal_id
ad_org_id
isactive
created
createdby
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
name
NUMERIC(10,0)
CHARACTER VARYING(1023)
CHARACTER VARYING(60)
description
CHARACTER VARYING(255)
uuid
CHARACTER VARYING(36)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
phone
c_calendar_id NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
transferbank_id
transfercashbook_id
receiptfootermsg
dropship_warehouse_id
c_calendar_id
logo_id
phone2
ad_client_id
NUMERIC(10,0)
supervisor_id
parent_org_id
ad_orgtype_id
m_warehouse_id
fax
c_calendar
NUMERIC(10,0)
duns
taxid
c_interorg_acct
CHARACTER VARYING(40)
c_acctschema_id
CHARACTER VARYING(40)
NUMERIC(10,0)
ad_org_id
CHARACTER VARYING(40)
NUMERIC(10,0)
ad_orgto_id
NUMERIC(10,0)
email
CHARACTER VARYING(60)
ad_client_id
NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
isactive
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
NUMERIC(10,0)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
intercompanydueto_acct
NUMERIC(10,0)
intercompanyduefrom_acct NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
c_acctschema
c_acctschema_id
NUMERIC(10,0)
ad_client_id
NUMERIC(10,0)
ad_org_id
NUMERIC(10,0)
isactive
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
NUMERIC(10,0)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
name
CHARACTER VARYING(60)
description
CHARACTER VARYING(255)
gaap
CHARACTER(2)
isaccrual
CHARACTER(1)
costingmethod
CHARACTER(1)
c_currency_id
NUMERIC(10,0)
autoperiodcontrol
CHARACTER(1)
c_period_id
NUMERIC(10,0)
period_openhistory
NUMERIC(10,0)
period_openfuture
NUMERIC(10,0)
separator
CHARACTER(1)
hasalias
CHARACTER(1)
hascombination
CHARACTER(1)
istradediscountposted
CHARACTER(1)
isdiscountcorrectstax
CHARACTER(1)
m_costtype_id
NUMERIC(10,0)
costinglevel
CHARACTER(1)
isadjustcogs
CHARACTER(1)
ad_orgonly_id
NUMERIC(10,0)
ispostservices
CHARACTER(1)
isexplicitcostadjustment
CHARACTER(1)
commitmenttype
CHARACTER(1)
processing
CHARACTER(1)
taxcorrectiontype
CHARACTER(1)
isallownegativeposting
CHARACTER(1)
ispostifclearingequal
CHARACTER(1)
uuid
CHARACTER VARYING(36)
c_orgassignment
c_orgassignment_id NUMERIC(10,0)
ad_client_id
NUMERIC(10,0)
ad_org_id
NUMERIC(10,0)
isactive
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
NUMERIC(10,0)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
ad_user_id
NUMERIC(10,0)
validfrom
NUMERIC(10,0)
NUMERIC(10,0)
ad_org_id
isactive
created
NUMERIC(10,0)
CHARACTER VARYING(40)
CHARACTER(1)
NUMERIC(10,0)
isapproved
docstatus
NUMERIC(10,0)
NUMERIC(10,0)
processedon
user3_id
updatedby
issotrx
createdby
updated
updatedby
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
documentno
CHARACTER VARYING(30)
NUMERIC(10,0)
confirmtype
isapproved
description
processing
CHARACTER(2)
CHARACTER(1)
CHARACTER VARYING(255)
CHARACTER(1)
processed
CHARACTER(1)
createpackage
CHARACTER(1)
iscancelled
docstatus
docaction
CHARACTER(1)
CHARACTER(2)
CHARACTER(2)
isindispute
CHARACTER(1)
m_inventory_id
NUMERIC(10,0)
c_invoice_id
approvalamt
NUMERIC(10,0)
NUMERIC
confirmationno
CHARACTER VARYING(20)
uuid
CHARACTER VARYING(36)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
c_project_acct
ad_client_id
ad_org_id
isactive
CHARACTER(1)
CHARACTER(1)
freightamt
deliveryviarule
m_shipper_id
c_charge_id
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
pj_asset_acct
NUMERIC(10,0)
CHARACTER VARYING(36)
created
createdby
CHARACTER(1)
updatedby
NUMERIC(10,0)
CHARACTER(1)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
ad_user_id
salesrep_id
nopackages
documentno
NUMERIC(10,0)
description
NUMERIC(10,0)
movementdate
NUMERIC(10,0)
posted
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER VARYING(30)
CHARACTER VARYING(255)
TIMESTAMP(6) WITHOUT TIME ZONE
TIMESTAMP(6) WITHOUT TIME ZONE
processed
CHARACTER(1)
CHARACTER VARYING(60)
processing
CHARACTER(1)
ad_orgtrx_id
c_project_id
ad_orgtrx_id
NUMERIC(10,0)
c_project_id
NUMERIC(10,0)
c_campaign_id
NUMERIC(10,0)
c_activity_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
c_activity_id
NUMERIC(10,0)
user1_id
NUMERIC(10,0)
user1_id
NUMERIC(10,0)
NUMERIC(10,0)
user2_id
NUMERIC(10,0)
user2_id
datereceived
isintransit
ref_inout_id
datereceived
TIMESTAMP(6) WITHOUT TIME ZONE
docaction
CHARACTER(1)
docstatus
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(2)
CHARACTER(2)
createconfirm
CHARACTER(1)
isintransit
CHARACTER(1)
createpackage
CHARACTER(1)
c_doctype_id
NUMERIC(10,0)
isapproved
isindispute
volume
weight
isapproved
CHARACTER(1)
approvalamt
CHARACTER(1)
freightcostrule
NUMERIC
m_shipper_id
NUMERIC
CHARACTER(1)
NUMERIC
CHARACTER(1)
NUMERIC(10,0)
m_rma_id
NUMERIC(10,0)
priorityrule
CHARACTER(1)
reversal_id
NUMERIC(10,0)
salesrep_id
NUMERIC(10,0)
isdropship
dropship_bpartner_id
dropship_location_id
ad_user_id
CHARACTER(1)
c_bpartner_id
NUMERIC(10,0)
c_bpartner_location_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
dropship_user_id
NUMERIC(10,0)
c_charge_id
NUMERIC(10,0)
processedon
NUMERIC
chargeamt
NUMERIC
c_pos_id
user3_id
user4_id
barcodescanner
createfrom
NUMERIC(10,0)
dd_order_id
NUMERIC(10,0)
deliveryrule
NUMERIC(10,0)
deliveryviarule
CHARACTER(1)
ad_user
CHARACTER(1)
NUMERIC(10,0)
ad_user_id
CHARACTER(1)
NUMERIC(10,0)
ad_client_id
CHARACTER(1)
NUMERIC(10,0)
ad_org_id
NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
freightamt
NUMERIC
isactive
CHARACTER(1)
m_freightcategory_id
NUMERIC(10,0)
reversal_id
NUMERIC(10,0)
created
TIMESTAMP(6) WITHOUT TIME ZONE
poreference
processedon
user3_id
CHARACTER VARYING(20)
createdby
NUMERIC
NUMERIC(10,0)
updated
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
user4_id
NUMERIC(10,0)
name
CHARACTER VARYING(60)
m_productionbatch_id
NUMERIC(10,0)
description
CHARACTER VARYING(255)
barcodescanner
CHARACTER(1)
uuid
CHARACTER VARYING(36)
password
CHARACTER VARYING(1024)
email
CHARACTER VARYING(60)
supervisor_id
NUMERIC(10,0)
c_bpartner_id
NUMERIC(10,0)
processing
CHARACTER(1)
emailuser
CHARACTER VARYING(60)
emailuserpw
CHARACTER VARYING(255)
c_bpartner_location_id
NUMERIC(10,0)
c_greeting_id
NUMERIC(10,0)
title
CHARACTER VARYING(40)
comments
CHARACTER VARYING(2000)
phone
CHARACTER VARYING(40)
phone2
CHARACTER VARYING(40)
fax
CHARACTER VARYING(40)
lastcontact
TIMESTAMP(6) WITHOUT TIME ZONE
lastresult
CHARACTER VARYING(255)
birthday
TIMESTAMP(6) WITHOUT TIME ZONE
ad_orgtrx_id
CHARACTER(1)
NUMERIC(10,0)
ldapuser
CHARACTER VARYING(60)
connectionprofile
CHARACTER(1)
CHARACTER VARYING(40)
userpin
CHARACTER VARYING(20)
isinpayroll
CHARACTER(1)
salt
CHARACTER VARYING(16)
issaleslead
CHARACTER(1)
c_location_id
NUMERIC(10,0)
leadsource
CHARACTER VARYING(10)
leadstatus
CHARACTER VARYING(10)
leadsourcedescription
CHARACTER VARYING(255)
leadstatusdescription
CHARACTER VARYING(255)
c_campaign_id
NUMERIC(10,0)
salesrep_id
NUMERIC(10,0)
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC
NUMERIC
TIMESTAMP(6) WITHOUT TIME ZONE
m_movementconfirm
c_projecttype_id
m_movementconfirm_id NUMERIC(10,0)
ad_client_id
invoicedqty
NUMERIC
projectbalanceamt
NUMERIC
TIMESTAMP(6) WITHOUT TIME ZONE
c_phase_id
NUMERIC(10,0)
projinvoicerule
CHARACTER(1)
projectlinelevel
CHARACTER(1)
uuid
CHARACTER VARYING(36)
c_projectgroup_id
NUMERIC(10,0)
c_projectclass_id
NUMERIC(10,0)
c_projectcategory_id
NUMERIC(10,0)
NUMERIC(10,0)
c_projectstatus_id
CHARACTER VARYING(30)
NUMERIC(10,0)
datestart
NUMERIC(10,0)
description
TIMESTAMP(6) WITHOUT TIME ZONE
datefinishschedule
TIMESTAMP(6) WITHOUT TIME ZONE
isreversal
CHARACTER(1)
datestartschedule
TIMESTAMP(6) WITHOUT TIME ZONE
uuid
CHARACTER VARYING(36)
datedeadline
TIMESTAMP(6) WITHOUT TIME ZONE
isindefinite
CHARACTER(1)
c_activity_id
NUMERIC(10,0)
ad_orgtrx_id
NUMERIC(10,0)
c_salesregion_id
NUMERIC(10,0)
user1_id
NUMERIC(10,0)
user2_id
NUMERIC(10,0)
user3_id
NUMERIC(10,0)
user4_id
NUMERIC(10,0)
projectmanager_id
NUMERIC(10,0)
durationunit
CHARACTER(1)
priorityrule
CHARACTER(1)
ad_color_id
NUMERIC(10,0)
createfrom
CHARACTER(1)
datelastaction
TIMESTAMP(6) WITHOUT TIME ZONE
datelastalert
TIMESTAMP(6) WITHOUT TIME ZONE
duetype
CHARACTER(1)
alertmessage
CHARACTER VARYING(2000)
bomdrop
CHARACTER(1)
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER VARYING(40)
CHARACTER VARYING(60)
CHARACTER VARYING(60)
description
CHARACTER VARYING(255)
issummary
CHARACTER(1)
c_bp_group_id
NUMERIC(10,0)
isonetime
CHARACTER(1)
isprospect
CHARACTER(1)
isvendor
CHARACTER(1)
iscustomer
CHARACTER(1)
isemployee
CHARACTER(1)
issalesrep
CHARACTER(1)
referenceno
CHARACTER VARYING(40)
duns
CHARACTER(11)
url
CHARACTER VARYING(120)
ad_language
CHARACTER VARYING(20)
CHARACTER(1)
NUMERIC(10,0)
rating
CHARACTER(1)
salesvolume
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(6)
firstsale
TIMESTAMP(6) WITHOUT TIME ZONE
acqusitioncost
NUMERIC
potentiallifetimevalue
actuallifetimevalue
ad_client_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
NUMERIC(10,0)
updated
updatedby
name
routingno
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER VARYING(60)
CHARACTER VARYING(20)
c_location_id
NUMERIC(10,0)
swiftcode
CHARACTER VARYING(20)
isownbank
description
uuid
CHARACTER(1)
CHARACTER VARYING(255)
CHARACTER VARYING(36)
banktype
CHARACTER(1)
c_bpartner_id
NUMERIC(10,0)
CHARACTER(1)
NUMERIC
NUMERIC
c_paymentterm_id
NUMERIC(10,0)
m_pricelist_id
NUMERIC(10,0)
m_discountschema_id
NUMERIC(10,0)
CHARACTER(1)
so_description
documentcopies
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC
name
CHARACTER VARYING(60)
description
CHARACTER VARYING(255)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
uuid
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
updatedby
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
name
CHARACTER VARYING(60)
updated
updatedby
issotrx
printname
NUMERIC(10,0)
description
CHARACTER(1)
docbasetype
CHARACTER VARYING(30)
CHARACTER VARYING(60)
CHARACTER VARYING(255)
CHARACTER(3)
docstatus
CHARACTER(2)
issotrx
CHARACTER(1)
docaction
CHARACTER(2)
docsubtypeso
CHARACTER(2)
processing
processed
c_doctype_id
c_doctypetarget_id
hasproforma
CHARACTER(1)
c_doctypeproforma_id
CHARACTER(1)
c_doctypeshipment_id
NUMERIC(10,0)
c_doctypeinvoice_id
NUMERIC(10,0)
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
description
CHARACTER VARYING(255)
isdocnocontrolled
CHARACTER(1)
isapproved
CHARACTER(1)
docnosequence_id
NUMERIC(10,0)
iscreditapproved
isdelivered
isinvoiced
gl_category_id
CHARACTER(1)
hascharges
CHARACTER(1)
documentnote
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
CHARACTER VARYING(2000)
isprinted
CHARACTER(1)
isdefault
CHARACTER(1)
istransferred
CHARACTER(1)
documentcopies
NUMERIC(10,0)
isselected
salesrep_id
dateordered
datepromised
ad_printformat_id
CHARACTER(1)
isdefaultcounterdoc
NUMERIC(10,0)
isshipconfirm
TIMESTAMP(6) WITHOUT TIME ZONE
ispickqaconfirm
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
c_doctypedifference_id
iscreatecounter
isindexed
CHARACTER(1)
isoverwriteseqoncomplete
CHARACTER(1)
NUMERIC(10,0)
definitesequence_id
NUMERIC(10,0)
paymentrule
c_paymentterm_id
invoicerule
isoverwritedateoncomplete
CHARACTER(1)
ispreparesplitdocument
NUMERIC(10,0)
printdocument
CHARACTER(1)
iscopydocnoonreversal
CHARACTER(1)
uuid
CHARACTER VARYING(36)
isreversedwithoriginalacct
CHARACTER(1)
deliveryviarule
m_shipper_id
c_charge_id
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
c_project_id
c_activity_id
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
c_payment_id
NUMERIC(10,0)
c_cashline_id
NUMERIC(10,0)
sendemail
ad_user_id
copyfrom
isselfservice
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
ad_orgtrx_id
NUMERIC(10,0)
user1_id
NUMERIC(10,0)
user2_id
c_conversiontype_id
bill_bpartner_id
bill_location_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
bill_user_id
NUMERIC(10,0)
pay_bpartner_id
NUMERIC(10,0)
pay_location_id
ref_order_id
isdropship
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
volume
NUMERIC
weight
NUMERIC
ordertype
c_pos_id
amounttendered
amountrefunded
CHARACTER VARYING(510)
NUMERIC(10,0)
NUMERIC
NUMERIC
link_order_id
NUMERIC(10,0)
m_freightcategory_id
NUMERIC(10,0)
dropship_bpartner_id
dropship_location_id
dropship_user_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
promotioncode
CHARACTER VARYING(30)
c_ordersource_id
NUMERIC(10,0)
processedon
c_opportunity_id
user3_id
user4_id
CHARACTER(1)
c_doctypepayment_id
isbanktransfer
NUMERIC
NUMERIC
NUMERIC(10,0)
NUMERIC(10,0)
istaxincluded
c_campaign_id
posted
isallocateimmediate
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC
CHARACTER(1)
totallines
grandtotal
m_warehouse_id
m_pricelist_id
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
NUMERIC(10,0)
CHARACTER VARYING(36)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
NUMERIC
chargeamt
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER VARYING(60)
CHARACTER VARYING(255)
NUMERIC(10,0)
m_discountschema_id
validfrom
proccreate
m_pricelist_version_base_id
uuid
createfrom
CHARACTER(1)
freightcostrule
freightamt
priorityrule
updated
updatedby
name
description
m_pricelist_id
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
isdiscountprinted
c_currency_id
deliveryrule
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER(1)
isintransit
issplitwhendifference
NUMERIC(10,0)
CHARACTER VARYING(20)
m_pricelist_version_id
ad_client_id
ad_org_id
isactive
created
createdby
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
TIMESTAMP(6) WITHOUT TIME ZONE
c_bpartner_id
c_bpartner_location_id NUMERIC(10,0)
CHARACTER VARYING(36)
m_pricelist_version
CHARACTER(1)
dateprinted
dateacct
poreference
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(36)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
created
createdby
documentno
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
isactive
priceprecision
ismandatory
ispresentforproduct CHARACTER(1)
isnetprice
uuid
CHARACTER VARYING(3)
CHARACTER VARYING(60)
CHARACTER VARYING(60)
CHARACTER(1)
placeofbirth_id
maritalstatus
created
CHARACTER(1)
c_currency_id
enforcepricelimit
CHARACTER(40)
CHARACTER(40)
CHARACTER(40)
CHARACTER(40)
TIMESTAMP(6) WITHOUT TIME ZONE
bloodgroup
fathersname
placeofbirth
gender
NUMERIC(10,0)
NUMERIC(10,0)
createdby
basepricelist_id
istaxincluded
issopricelist
isdefault
CHARACTER(40)
CHARACTER(40)
unappliedpayments
customeropeninvoices
vendoropeninvoices
birthday
ad_client_id
ad_org_id
updated
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC
TIMESTAMP(6) WITHOUT TIME ZONE
arenquiry
apenquiry
notposted
NUMERIC(10,0)
createdby
updated
updatedby
totalopenbalance
dunninggrace
c_taxgroup_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
isactive
created
logo_id
CHARACTER(1)
m_pricelist_id
ad_client_id
ad_org_id
NUMERIC(10,0)
CHARACTER(1)
ispotaxexempt
ad_client_id
m_pricelist
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
NUMERIC(10,0)
invoice_printformat_id
socreditstatus
ismanufacturer
ad_org_id
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(36)
NUMERIC(10,0)
c_greeting_id
invoicerule
deliveryrule
freightcostrule
shelflifeminpct
isactive
CHARACTER VARYING(255)
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
CHARACTER VARYING(2000)
NUMERIC
CHARACTER(1)
cumulativelevel
processing
isbpartnerflatdiscount
uuid
CHARACTER VARYING(20)
ad_orgbp_id
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER VARYING(60)
description
validfrom
discounttype
script
flatdiscount
isquantitybased
CHARACTER(1)
flatdiscount
c_doctype
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
created
createdby
updated
updatedby
name
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
deliveryviarule
c_doctype_id
m_discountschema_id NUMERIC(10,0)
ad_client_id
ad_org_id
isactive
CHARACTER VARYING(255)
poreference
paymentrulepo
po_pricelist_id
po_discountschema_id
po_paymentterm_id
salesrep_id
c_order
NUMERIC(10,0)
c_dunning_id
isdiscountprinted
sendemail
NUMERIC(10,0)
NUMERIC
NUMERIC
NUMERIC(10,0)
paymentrule
so_creditlimit
so_creditused
bpartner_parent_id
c_order_id
m_discountschema
CHARACTER VARYING(6)
taxid
istaxexempt
c_invoiceschedule_id
shareofcustomer
ad_org_id
CHARACTER VARYING(36)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
updated
updatedby
value
name
name2
numberemployees
isactive
NUMERIC
CHARACTER(1)
uuid
c_bpartner
c_bpartner_id
ad_client_id
ad_org_id
isactive
created
naics
c_bank
c_bank_id
CHARACTER VARYING(255)
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
TIMESTAMP(6) WITHOUT TIME ZONE
costs
issummary
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
NUMERIC
CHARACTER(2)
CHARACTER(2)
CHARACTER(1)
CHARACTER(1)
m_inventory_id
documentno
reversal_id
c_channel_id
CHARACTER(1)
m_warehouse_id
projectcategory
processing
c_bpartnersr_id
docstatus
CHARACTER VARYING(40)
CHARACTER VARYING(60)
enddate
NUMERIC(10,0)
iscommitceiling
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(255)
isapproved
approvalamt
docaction
processing
processed
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
value
name
startdate
NUMERIC
NUMERIC(10,0)
CHARACTER(1)
created
createdby
updated
updatedby
m_movement_id
description
NUMERIC
NUMERIC
NUMERIC(10,0)
updated
NUMERIC
invoicedamt
ad_org_id
isactive
NUMERIC(10,0)
NUMERIC(10,0)
differenceqty
scrappedqty
CHARACTER VARYING(36)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
NUMERIC(10,0)
committedqty
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
isactive
created
createdby
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
updatedby
NUMERIC(10,0)
c_campaign_id NUMERIC(10,0)
ad_client_id
ad_org_id
CHARACTER(1)
salesrep_id
copyfrom
m_movementconfirm_id
CHARACTER VARYING(255)
c_campaign
CHARACTER(1)
NUMERIC
NUMERIC
plannedmarginamt
committedamt
ad_client_id
NUMERIC
NUMERIC
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
bomdrop
CHARACTER(1)
ad_role
c_payment
c_payment_id
ad_client_id
NUMERIC(10,0)
CHARACTER(1)
created
createdby
updated
NUMERIC(10,0)
CHARACTER VARYING(30)
datetrx
isreceipt
c_doctype_id
NUMERIC(10,0)
NUMERIC(10,0)
c_invoice_id
c_bp_bankaccount_id
c_paymentbatch_id
NUMERIC(10,0)
roundofffactor
NUMERIC
uuid
CHARACTER VARYING(36)
CHARACTER(1)
allow_info_resource
CHARACTER(1)
docstatus
processed
posted
CHARACTER VARYING(40)
NUMERIC(10,0)
isselfservice
chargeamt
c_charge_id
CHARACTER VARYING(20)
CHARACTER(1)
r_pnref_dc
swipe
NUMERIC(10,0)
NUMERIC(10,0)
user1_id
user2_id
c_conversiontype_id
c_payment_id
c_invoice_id
amount
discountamt
invoiceamt
c_projectline_id
ad_client_id
ad_org_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
isactive
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
updated
updatedby
c_project_id
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC(10,0)
line
NUMERIC(10,0)
description
CHARACTER VARYING(255)
plannedqty
plannedprice
plannedamt
NUMERIC
NUMERIC
NUMERIC
plannedmarginamt
NUMERIC
committedamt
NUMERIC
m_product_id
m_product_category_id
invoicedamt
invoicedqty
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC
NUMERIC
committedqty
NUMERIC
c_projectissue_id
NUMERIC(10,0)
c_order_id
c_orderpo_id
isprinted
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
processed
CHARACTER(1)
dopricing
CHARACTER(1)
c_projectphase_id
c_projecttask_id
s_resourceassignment_id
uuid
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(36)
vendor_id
NUMERIC(10,0)
pp_product_bom_id
NUMERIC(10,0)
ad_workflow_id
NUMERIC(10,0)
pp_order_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC
NUMERIC
NUMERIC
NUMERIC
NUMERIC
c_allocationline_id
NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(255)
dateacct
TIMESTAMP(6) WITHOUT TIME ZONE
c_order_id
NUMERIC(10,0)
isprepayment
writeoffamt
CHARACTER VARYING(20)
CHARACTER VARYING(80)
NUMERIC(10,0)
c_campaign_id
c_activity_id
description
ref_payment_id
reversal_id
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
c_cashbook_id
NUMERIC(10,0)
processedon
NUMERIC
c_pos_id
user3_id
user4_id
c_invoice
CHARACTER(1)
NUMERIC
NUMERIC(10,0)
CHARACTER(1)
r_authcode_dc
r_cvv2match
ad_orgtrx_id
overunderamt
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
NUMERIC
a_country
c_project_id
isdelayedcapture
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(36)
CHARACTER(2)
CHARACTER(2)
CHARACTER(1)
CHARACTER(1)
isoverunderpayment
isdiscountallowedontotal CHARACTER(1)
allow_html_view
allow_xls_view
iscanload
uuid
CHARACTER(1)
isallocated
isonline
overunderamt
c_projectline
CHARACTER(1)
NUMERIC(22,0)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
docaction
CHARACTER(1)
allow_info_schedule
userdiscount
allow_info_mrp
allow_info_crp
isdiscountuptolimitprice
CHARACTER VARYING(36)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER VARYING(20)
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(2000)
processing
oprocessing
isreconciled
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
allow_info_product
NUMERIC
CHARACTER(1)
CHARACTER VARYING(40)
CHARACTER VARYING(255)
CHARACTER VARYING(40)
CHARACTER VARYING(60)
uuid
issotrx
c_bpartner_id
CHARACTER VARYING(20)
CHARACTER VARYING(60)
r_authcode
r_avsaddr
r_avszip
NUMERIC(10,0)
allow_info_inout
allow_info_invoice
allow_info_order
allow_info_payment
CHARACTER VARYING(20)
NUMERIC
creditlimit
isdefault
iban
description
bban
paymentexportclass
NUMERIC
CHARACTER(1)
CHARACTER VARYING(20)
r_result
r_respmsg
r_info
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
accountno
currentbalance
CHARACTER VARYING(20)
CHARACTER VARYING(60)
NUMERIC(10,0)
NUMERIC
NUMERIC
NUMERIC
taxamt
isapproved
NUMERIC(10,0)
c_bank_id
c_currency_id
bankaccounttype
CHARACTER VARYING(60)
CHARACTER VARYING(20)
discountamt
writeoffamt
r_pnref
isactive
CHARACTER VARYING(20)
CHARACTER VARYING(20)
CHARACTER VARYING(20)
a_email
voiceauthcode
orig_trxid
created
CHARACTER(1)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC
CHARACTER(1)
CHARACTER(1)
ponum
createdby
iseuro
isemumember
emuentrydate
emurate
allow_info_bpartner
allow_info_cashjournal
c_currency_id
updated
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
payamt
updatedby
CHARACTER(3)
CHARACTER VARYING(10)
CHARACTER VARYING(255)
stdprecision
costingprecision NUMERIC(10,0)
maxqueryrecords
connectionprofile
allow_info_account
allow_info_asset
updated
updatedby
a_zip
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
iso_code
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER(1)
cursymbol
description
ad_tree_org_id
confirmqueryrecords
ad_org_id
isactive
created
createdby
CHARACTER VARYING(60)
CHARACTER VARYING(40)
a_ident_dl
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
updated
updatedby
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(20)
CHARACTER VARYING(20)
CHARACTER VARYING(60)
CHARACTER VARYING(60)
isuseuserorgaccess
CHARACTER(1)
c_bankaccount_id
ad_client_id
NUMERIC(10,0)
a_city
a_state
a_ident_ssn
c_paymentallocate
ad_org_id
isactive
created
createdby
CHARACTER(1)
CHARACTER(1)
preferencetype
overwritepricelimit
CHARACTER VARYING(20)
CHARACTER VARYING(20)
accountno
checkno
a_name
c_paymentallocate_id NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
isaccessallorgs
ischangelog
micr
a_street
ad_client_id
c_currency_id
ad_client_id
iscanexport
iscanreport
supervisor_id
c_bankaccount
c_currency
CHARACTER(1)
CHARACTER(1)
iscanapproveowndoc
CHARACTER VARYING(20)
CHARACTER VARYING(4)
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
ispersonallock
ispersonalaccess
routingno
creditcardexpyy
ad_org_id
NUMERIC(10,0)
NUMERIC
ad_tree_menu_id
ismanual
NUMERIC(10,0)
CHARACTER VARYING(60)
NUMERIC(10,0)
CHARACTER VARYING(255)
CHARACTER(3)
c_currency_id
amtapproval
isshowacct
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
name
updatedby
description
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
creditcardnumber
creditcardvv
creditcardexpmm
NUMERIC(10,0)
NUMERIC(10,0)
createdby
updated
userlevel
NUMERIC(10,0)
tendertype
creditcardtype
ad_role_id
ad_org_id
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
c_bankaccount_id
c_bpartner_id
ad_client_id
created
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
documentno
trxtype
isactive
NUMERIC(10,0)
NUMERIC(10,0)
ad_org_id
isactive
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
relatedpayment_id
NUMERIC(10,0)
c_invoice_id
ad_client_id
ad_org_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
isactive
CHARACTER(1)
created
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
updated
updatedby
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
issotrx
CHARACTER(1)
documentno
CHARACTER VARYING(30)
docstatus
docaction
processing
processed
CHARACTER(2)
CHARACTER(2)
CHARACTER(1)
CHARACTER(1)
posted
CHARACTER(1)
c_doctype_id
NUMERIC(10,0)
c_doctypetarget_id
c_order_id
description
isapproved
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(255)
CHARACTER(1)
istransferred
CHARACTER(1)
isprinted
CHARACTER(1)
salesrep_id
dateinvoiced
dateprinted
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
TIMESTAMP(6) WITHOUT TIME ZONE
dateacct
TIMESTAMP(6) WITHOUT TIME ZONE
c_bpartner_id
NUMERIC(10,0)
c_bpartner_location_id NUMERIC(10,0)
poreference
isdiscountprinted
dateordered
CHARACTER VARYING(20)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
c_currency_id
NUMERIC(10,0)
paymentrule
CHARACTER(1)
c_paymentterm_id
c_charge_id
chargeamt
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC
totallines
NUMERIC
grandtotal
NUMERIC
m_pricelist_id
istaxincluded
c_campaign_id
c_project_id
NUMERIC(10,0)
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
m_product
m_product_id
ad_client_id
ad_org_id
isactive
created
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
c_activity_id
NUMERIC(10,0)
createdby
NUMERIC(10,0)
ispaid
CHARACTER(1)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
c_payment_id
c_cashline_id
createfrom
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
updatedby
value
name
NUMERIC(10,0)
CHARACTER VARYING(510)
CHARACTER VARYING(255)
generateto
CHARACTER(1)
description
CHARACTER VARYING(255)
sendemail
CHARACTER(1)
documentnote
CHARACTER VARYING(2000)
ad_user_id
copyfrom
isselfservice
ad_orgtrx_id
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
help
upc
sku
c_uom_id
CHARACTER VARYING(2000)
CHARACTER VARYING(30)
CHARACTER VARYING(30)
NUMERIC(10,0)
user1_id
NUMERIC(10,0)
salesrep_id
NUMERIC(10,0)
user2_id
NUMERIC(10,0)
issummary
CHARACTER(1)
c_conversiontype_id
ispayschedulevalid
ref_invoice_id
NUMERIC(10,0)
CHARACTER(1)
NUMERIC(10,0)
isstocked
ispurchased
issold
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
isindispute
CHARACTER(1)
isbom
CHARACTER(1)
invoicecollectiontype
CHARACTER(1)
isinvoiceprintdetails
CHARACTER(1)
m_rma_id
dunninggrace
c_dunninglevel_id
reversal_id
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC(10,0)
ispicklistprintdetails
isverified
c_revenuerecognition_id
m_product_category_id
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
processedon
NUMERIC
classification
CHARACTER VARYING(12)
isfixedassetinvoice
CHARACTER(1)
volume
NUMERIC
c_pos_id
user3_id
user4_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(255)
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(36)
NUMERIC(10,0)
NUMERIC(10,0)
ad_org_id
NUMERIC
CHARACTER VARYING(255)
CHARACTER VARYING(255)
CHARACTER(1)
CHARACTER VARYING(255)
NUMERIC(10,0)
CHARACTER VARYING(20)
NUMERIC(10,0)
NUMERIC(10,0)
m_pricelist_version_id
c_campaign_id
datecontract
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(60)
CHARACTER(1)
CHARACTER(1)
isuseasp
ad_replicationstrategy_id
ad_emailconfig_id
uuid
datefinish
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(255)
CHARACTER VARYING(255)
CHARACTER(1)
unixarchivepath
CHARACTER VARYING(255)
CHARACTER VARYING(2000)
CHARACTER(1)
generateto
NUMERIC(10,0)
CHARACTER VARYING(60)
CHARACTER VARYING(60)
CHARACTER VARYING(20)
CHARACTER VARYING(20)
CHARACTER VARYING(6)
CHARACTER(1)
storeattachmentsonfilesystem CHARACTER(1)
windowsattachmentpath
unixattachmentpath
NUMERIC(10,0)
processed
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER VARYING(20)
CHARACTER VARYING(60)
CHARACTER VARYING(36)
NUMERIC(10,0)
iscommitment
NUMERIC(10,0)
mobilephone
email
uuid
NUMERIC(10,0)
CHARACTER VARYING(40)
CHARACTER VARYING(60)
CHARACTER VARYING(255)
CHARACTER VARYING(60)
mmpolicy
emailtest
isserveremail
documentdir
ispostimmediate
iscostimmediate
ad_user_id
plannedamt
processed
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER VARYING(40)
CHARACTER VARYING(40)
NUMERIC(10,0)
issmtpauthorization
isusebetafunctions
ldapquery
modelvalidationclasses
autoarchive
c_bpartner_id
plannedqty
m_inventoryline_id
c_bpartner_id
c_location_id
contacttype
contactperson
hr_relationship_id
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
requestemail
requestuser
requestuserpw
requestfolder
ad_language
ismultilingualdocument
storearchiveonfilesystem
c_bpartner_location_id
reversalline_id
CHARACTER(1)
CHARACTER VARYING(40)
CHARACTER VARYING(40)
CHARACTER VARYING(40)
CHARACTER VARYING(40)
NUMERIC(10,0)
updatedby
value
name
description
smtphost
windowsarchivepath
poreference
uuid
isremitto
phone
phone2
fax
isdn
c_salesregion_id
created
createdby
updated
NUMERIC(10,0)
c_paymentterm_id
m_movementlineconfirm
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER VARYING(60)
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
CHARACTER VARYING(40)
c_currency_id
m_movementline_id
CHARACTER VARYING(36)
isprojectmember
isprojectmanager
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
name
isbillto
isshipto
ispayfrom
CHARACTER VARYING(60)
description
description
uuid
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
ad_client_id
ad_org_id
isactive
created
createdby
updated
value
note
targetqty
isactive
c_bpartner_location
c_bpartner_location_id NUMERIC(10,0)
name
issummary
confirmedqty
CHARACTER(1)
CHARACTER(1)
recentitemsmaxsaved
recentitemsmaxshown
created
isactive
CHARACTER(1)
isinternaluser
iswebstoreuser
NUMERIC(10,0)
CHARACTER(1)
createdby
created
NUMERIC(10,0)
isloginuser
NUMERIC(10,0)
NUMERIC(10,0)
ad_org_id
updated
createdby
CHARACTER VARYING(60)
NUMERIC(10,0)
isactive
updatedby
updated
NUMERIC(10,0)
bpname
bp_location_id
ad_emailconfig_id
c_project
c_project_id
ad_org_id
CHARACTER VARYING(40)
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
isfullbpaccess
c_job_id
value
ad_client_id
ad_client
ad_client_id
NUMERIC(10,0)
emailverify
emailverifydate
notificationtype
m_movementlineconfirm_id
CHARACTER(1)
NUMERIC(10,0)
CHARACTER VARYING(36)
CHARACTER(1)
shipdate
trackingno
c_campaign_id
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER VARYING(40)
CHARACTER VARYING(60)
CHARACTER VARYING(255)
ad_replicationstrategy_id
uuid
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
generateto
sendemail
pickdate
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
updated
updatedby
value
name
description
issummary
NUMERIC(10,0)
NUMERIC(10,0)
isactive
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
CHARACTER(1)
NUMERIC(10,0)
isactive
created
NUMERIC(10,0)
ad_client_id
ad_org_id
dateprinted
ad_org_id
m_movement
m_movement_id
NUMERIC
CHARACTER(1)
c_invoice_id
ad_client_id
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
NUMERIC(10,0)
pj_wip_acct
uuid
NUMERIC
CHARACTER(1)
NUMERIC(10,0)
NUMERIC(10,0)
chargeamt
priorityrule
createfrom
ad_org
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
created
updatedby
NUMERIC(10,0)
CHARACTER VARYING(20)
deliveryrule
freightcostrule
createdby
updated
c_bpartner_location_id NUMERIC(10,0)
m_warehouse_id
NUMERIC(10,0)
c_acctschema_id
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
CHARACTER(2)
TIMESTAMP(6) WITHOUT TIME ZONE
dateacct
c_bpartner_id
poreference
c_project_id
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
CHARACTER VARYING(255)
NUMERIC(10,0)
dateordered
isprinted
movementtype
m_inout_id
NUMERIC(10,0)
CHARACTER(1)
description
c_order_id
movementdate
CHARACTER(1)
CHARACTER VARYING(36)
CHARACTER VARYING(30)
CHARACTER(2)
CHARACTER(1)
processing
processed
barcodescanner
uuid
CHARACTER(2)
docstatus
posted
c_doctype_id
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
documentno
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC
NUMERIC(10,0)
NUMERIC(10,0)
isstocktake
updateqtycount
TIMESTAMP(6) WITHOUT TIME ZONE
createdby
updated
docaction
m_inoutconfirm
m_inoutconfirm_id NUMERIC(10,0)
ad_client_id
ad_org_id
isactive
created
CHARACTER VARYING(60)
CHARACTER(1)
CHARACTER VARYING(36)
CHARACTER(1)
CHARACTER(2)
CHARACTER(2)
NUMERIC
c_doctype_id
reversal_id
user4_id
replenishmentclass
isintransit
uuid
NUMERIC(10,0)
NUMERIC(10,0)
docaction
NUMERIC(10,0)
CHARACTER VARYING(60)
CHARACTER VARYING(255)
NUMERIC(10,0)
separator
m_warehousesource_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
user1_id
user2_id
approvalamt
NUMERIC(10,0)
name
description
c_location_id
CHARACTER(1)
NUMERIC(10,0)
ad_orgtrx_id
c_project_id
c_campaign_id
ad_client_id
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
value
CHARACTER(1)
CHARACTER(1)
CHARACTER(1)
generatelist
m_perpetualinv_id
c_activity_id
ad_org_id
NUMERIC(10,0)
NUMERIC(10,0)
NUMERIC(10,0)
isactive
created
createdby
updated
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
processed
processing
isactive
m_warehouse
m_warehouse_id
ad_client_id
ad_org_id
NUMERIC(10,0)
CHARACTER VARYING(30)
CHARACTER VARYING(255)
NUMERIC(10,0)
movementdate
posted
updateqty
created
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
updatedby
documentno
m_inout
CHARACTER VARYING(255)
CHARACTER VARYING(36)
createdby
description
NUMERIC(10,0)
TIMESTAMP(6) WITHOUT TIME ZONE
description
uuid
updated
m_warehouse_id
m_inout_id
TIMESTAMP(6) WITHOUT TIME ZONE
validto
m_inventory
m_inventory_id
ad_client_id
weight
shelfwidth
shelfheight
NUMERIC
NUMERIC(10,0)
NUMERIC
c_uom
uuid
CHARACTER VARYING(36)
shelfdepth
NUMERIC(10,0)
bomdrop
CHARACTER(1)
unitsperpallet
NUMERIC
c_uom_id
NUMERIC(10,0)
NUMERIC(10,0)
ad_client_id
NUMERIC(10,0)
c_taxcategory_id
s_resource_id
discontinued
discontinuedby
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
ad_org_id
isactive
created
NUMERIC(10,0)
CHARACTER(1)
TIMESTAMP(6) WITHOUT TIME ZONE
processing
CHARACTER(1)
updated
TIMESTAMP(6) WITHOUT TIME ZONE
s_expensetype_id
NUMERIC(10,0)
createdby
NUMERIC(10,0)
producttype
imageurl
descriptionurl
guaranteedays
CHARACTER(1)
CHARACTER VARYING(120)
CHARACTER VARYING(120)
NUMERIC(10,0)
updatedby
x12de355
uomsymbol
name
NUMERIC(10,0)
CHARACTER VARYING(4)
CHARACTER VARYING(10)
CHARACTER VARYING(60)
r_mailtext_id
NUMERIC(10,0)
description
CHARACTER VARYING(255)
versionno
CHARACTER VARYING(20)
stdprecision
NUMERIC(10,0)
m_attributeset_id
m_attributesetinstance_id
NUMERIC(10,0)
NUMERIC(10,0)
costingprecision NUMERIC(10,0)
isdefault
CHARACTER(1)
CHARACTER VARYING(120)
uomtype
CHARACTER VARYING(2)
m_freightcategory_id
NUMERIC(10,0)
uuid
CHARACTER VARYING(36)
m_locator_id
NUMERIC(10,0)
downloadurl
guaranteedaysmin
iswebstorefeatured
isselfservice
c_subscriptiontype_id
NUMERIC(10,0)
CHARACTER(1)
CHARACTER(1)
NUMERIC(10,0)
isdropship
CHARACTER(1)
isexcludeautodelivery
CHARACTER(1)
group1
group2
istoformule
CHARACTER VARYING(255)
CHARACTER VARYING(255)
CHARACTER(1)
lowlevel
NUMERIC(10,0)
unitsperpack
NUMERIC(10,0)
discontinuedat
copyfrom
m_parttype_id
iskanban
TIMESTAMP(6) WITHOUT TIME ZONE
CHARACTER(1)
NUMERIC(10,0)
CHARACTER(1)
ismanufactured
CHARACTER(1)
m_product_class_id
NUMERIC(10,0)
m_product_group_id
m_product_classification_id
isphantom
NUMERIC(10,0)
NUMERIC(10,0)
CHARACTER(1)
uuid
CHARACTER VARYING(36)
c_taxtype_id
NUMERIC(10,0)
Download