View idempiere11.adempiere.c_order_linetax_v
Order Print View

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ad_language varchar 6  √  null Language for this entity
c_order_id numeric 10  √  null Order
c_orderline_id numeric 0  √  null Sales Order Line
c_tax_id numeric 0  √  null Tax identifier
taxindicator varchar 2147483647  √  null Short form for Tax to be printed on documents
c_bpartner_id numeric 0  √  null Identifies a Business Partner
c_bpartner_location_id numeric 0  √  null Identifies the (ship to) address for this Business Partner
bpname varchar 2147483647  √  null BP Name
c_location_id numeric 0  √  null Location or Address
line numeric 0  √  null Unique line for this document
m_product_id numeric 0  √  null Product, Service, Item
vendorproductno varchar 2147483647  √  null Product Key of the Business Partner
qtyordered numeric 0  √  null Ordered Quantity
qtyentered numeric 0  √  null The Quantity Entered is based on the selected UoM
uomsymbol varchar 2147483647  √  null Symbol for a Unit of Measure
name varchar 2147483647  √  null Alphanumeric identifier of the entity
description varchar 2147483647  √  null Optional short description of the record
documentnote varchar 2147483647  √  null Additional information for a Document
upc varchar 2147483647  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 2147483647  √  null Stock Keeping Unit
productvalue varchar 2147483647  √  null Key of the Product
resourcedescription varchar 2147483647  √  null Resource Allocation Description
pricelist numeric 0  √  null List Price
priceenteredlist numeric 0  √  null Entered List Price
discount numeric 0  √  null Discount in percent
priceactual numeric 0  √  null Actual Price
priceentered numeric 0  √  null Price Entered - the price based on the selected/base UoM
linenetamt numeric 0  √  null Line Extended Amount (Quantity * Actual Price) without Freight and Charges
productdescription varchar 2147483647  √  null Product Description
imageurl varchar 2147483647  √  null URL of image
c_campaign_id numeric 0  √  null Marketing Campaign
c_project_id numeric 0  √  null Financial Project
c_activity_id numeric 0  √  null Business Activity
c_projectphase_id numeric 0  √  null Phase of a Project
c_projecttask_id numeric 0  √  null Actual Project Task in a Phase
c_orderline_ad_orgtrx_id numeric 0  √  null c_orderline_ad_orgtrx_id
c_orderline_c_charge_id numeric 0  √  null c_orderline_c_charge_id
c_orderline_c_currency_id numeric 0  √  null c_orderline_c_currency_id
c_uom_id numeric 0  √  null Unit of Measure
datedelivered timestamp 29,6  √  null Date when the product was delivered
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
dateordered timestamp 29,6  √  null Date of Order
c_orderline_datepromised timestamp 29,6  √  null c_orderline_datepromised
c_orderline_freightamt numeric 0  √  null c_orderline_freightamt
isdescription bpchar 2147483647  √  null if true, the line is just description and no transaction
link_orderline_id numeric 0  √  null This field links a sales order line to the purchase order line that is generated from it.
m_promotion_id numeric 0  √  null Promotion
c_orderline_m_shipper_id numeric 0  √  null c_orderline_m_shipper_id
c_orderline_m_warehouse_id numeric 0  √  null c_orderline_m_warehouse_id
pricecost numeric 0  √  null Price per Unit of Measure including all indirect costs (Freight, etc.)
pricelimit numeric 0  √  null Lowest price for a product
c_orderline_processed bpchar 2147483647  √  null c_orderline_processed
qtydelivered numeric 0  √  null Delivered Quantity
qtyinvoiced numeric 0  √  null Invoiced Quantity
qtylostsales numeric 0  √  null Quantity of potential sales
qtyreserved numeric 0  √  null Reserved Quantity
ref_orderline_id numeric 0  √  null Reference to corresponding Sales/Purchase Order
rramt numeric 0  √  null Revenue Recognition Amount
rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
s_resourceassignment_id numeric 0  √  null Resource Assignment
c_orderline_user1_id numeric 0  √  null c_orderline_user1_id
c_orderline_user2_id numeric 0  √  null c_orderline_user2_id
c_uom_ad_org_id numeric 0  √  null c_uom_ad_org_id
costingprecision numeric 0  √  null Rounding used costing calculations
c_uom_description varchar 2147483647  √  null c_uom_description
c_uom_isactive bpchar 2147483647  √  null c_uom_isactive
isdefault bpchar 2147483647  √  null Default value
c_uom_name varchar 2147483647  √  null c_uom_name
stdprecision numeric 0  √  null Rule for rounding calculated amounts
uomtype varchar 2147483647  √  null UOM Type
x12de355 varchar 2147483647  √  null UOM EDI X12 Code
c_order_ad_org_id numeric 0  √  null c_order_ad_org_id
c_order_ad_orgtrx_id numeric 0  √  null c_order_ad_orgtrx_id
ad_user_id numeric 0  √  null User within the system - Internal or Business Partner Contact
amountrefunded numeric 0  √  null Amount Refunded
amounttendered numeric 0  √  null Amount Tendered
bill_bpartner_id numeric 0  √  null Business Partner to be invoiced
bill_location_id numeric 0  √  null Business Partner Location for invoicing
bill_user_id numeric 0  √  null Business Partner Contact for invoicing
c_order_c_activity_id numeric 0  √  null c_order_c_activity_id
c_order_c_bpartner_id numeric 0  √  null c_order_c_bpartner_id
c_order_c_campaign_id numeric 0  √  null c_order_c_campaign_id
c_cashline_id numeric 0  √  null Cash Journal Line
c_cashplanline_id numeric 0  √  null Cash Plan Line
c_order_c_charge_id numeric 0  √  null c_order_c_charge_id
c_conversiontype_id numeric 0  √  null Currency Conversion Rate Type
c_order_c_currency_id numeric 0  √  null c_order_c_currency_id
c_doctype_id numeric 0  √  null Document type or rules
c_doctypetarget_id numeric 0  √  null Target document type for conversing documents
chargeamt numeric 0  √  null Charge Amount
copyfrom bpchar 2147483647  √  null Copy From Record
c_payment_id numeric 0  √  null Payment identifier
c_paymentterm_id numeric 0  √  null The terms of Payment (timing, discount)
c_pos_id numeric 0  √  null Point of Sales Terminal
c_order_c_project_id numeric 0  √  null c_order_c_project_id
c_order_created timestamp 29,6  √  null c_order_created
c_order_createdby numeric 0  √  null c_order_createdby
dateacct timestamp 29,6  √  null Accounting Date
dateprinted timestamp 29,6  √  null Date the document was printed.
c_order_datepromised timestamp 29,6  √  null c_order_datepromised
deliveryrule bpchar 2147483647  √  null Defines the timing of Delivery
deliveryviarule bpchar 2147483647  √  null How the order will be delivered
c_order_description varchar 2147483647  √  null c_order_description
docaction bpchar 2147483647  √  null The targeted status of the document
docstatus bpchar 2147483647  √  null The current status of the document
documentno varchar 2147483647  √  null Document sequence number of the document
dropship_bpartner_id numeric 0  √  null Business Partner to ship to
dropship_location_id numeric 0  √  null Business Partner Location for shipping to
dropship_user_id numeric 0  √  null Business Partner Contact for drop shipment
c_order_freightamt numeric 0  √  null c_order_freightamt
freightcostrule bpchar 2147483647  √  null Method for charging Freight
grandtotal numeric 0  √  null Total amount of document
invoicerule bpchar 2147483647  √  null Frequency and method of invoicing
c_order_isactive bpchar 2147483647  √  null c_order_isactive
isapproved bpchar 2147483647  √  null Indicates if this document requires approval
iscreditapproved bpchar 2147483647  √  null Credit has been approved
isdelivered bpchar 2147483647  √  null Delivered
c_order_isdiscountprinted bpchar 2147483647  √  null c_order_isdiscountprinted
c_order_isdropship bpchar 2147483647  √  null c_order_isdropship
isinvoiced bpchar 2147483647  √  null Is this invoiced?
ispayschedulevalid bpchar 2147483647  √  null Is the Payment Schedule is valid
isprinted bpchar 2147483647  √  null Indicates if this document / line is printed
isselected bpchar 2147483647  √  null Selected
c_order_isselfservice bpchar 2147483647  √  null c_order_isselfservice
issotrx bpchar 2147483647  √  null This is a Sales Transaction
istaxincluded bpchar 2147483647  √  null Tax is included in the price
istransferred bpchar 2147483647  √  null Transferred to General Ledger (i.e. accounted)
link_order_id numeric 0  √  null This field links a sales order to the purchase order that is generated from it.
c_order_m_freightcategory_id numeric 0  √  null c_order_m_freightcategory_id
c_order_m_pricelist_id numeric 0  √  null c_order_m_pricelist_id
c_order_m_shipper_id numeric 0  √  null c_order_m_shipper_id
c_order_m_warehouse_id numeric 0  √  null c_order_m_warehouse_id
ordertype varchar 2147483647  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
pay_bpartner_id numeric 0  √  null Business Partner responsible for the payment
pay_location_id numeric 0  √  null Location of the Business Partner responsible for the payment
c_order_paymentrule bpchar 2147483647  √  null c_order_paymentrule
poreference varchar 2147483647  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
posted bpchar 2147483647  √  null Posting status
priorityrule bpchar 2147483647  √  null Priority of a document
c_order_processed bpchar 2147483647  √  null c_order_processed
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
promotioncode varchar 2147483647  √  null User entered promotion code at sales time
ref_order_id numeric 0  √  null Reference to corresponding Sales/Purchase Order
salesrep_id numeric 0  √  null Sales Representative or Company Agent
c_order_sendemail bpchar 2147483647  √  null c_order_sendemail
totallines numeric 0  √  null Total of all document lines
c_order_updated timestamp 29,6  √  null c_order_updated
c_order_updatedby numeric 0  √  null c_order_updatedby
c_order_user1_id numeric 0  √  null c_order_user1_id
c_order_user2_id numeric 0  √  null c_order_user2_id
c_order_volume numeric 0  √  null c_order_volume
c_order_weight numeric 0  √  null c_order_weight
m_product_ad_org_id numeric 0  √  null m_product_ad_org_id
classification varchar 2147483647  √  null Classification for grouping
m_product_copyfrom bpchar 2147483647  √  null m_product_copyfrom
m_product_created timestamp 29,6  √  null m_product_created
m_product_createdby numeric 0  √  null m_product_createdby
c_revenuerecognition_id numeric 0  √  null Method for recording revenue
c_subscriptiontype_id numeric 0  √  null Type of subscription
c_taxcategory_id numeric 0  √  null Tax Category
m_product_c_uom_id numeric 0  √  null m_product_c_uom_id
descriptionurl varchar 2147483647  √  null URL for the description
m_product_discontinued bpchar 2147483647  √  null m_product_discontinued
m_product_discontinuedat timestamp 29,6  √  null m_product_discontinuedat
group1 varchar 2147483647  √  null Group1
group2 varchar 2147483647  √  null Group2
guaranteedays numeric 0  √  null Number of days the product is guaranteed or available
guaranteedaysmin numeric 0  √  null Minimum number of guarantee days
help varchar 2147483647  √  null Comment or Hint
m_product_isactive bpchar 2147483647  √  null m_product_isactive
isbom bpchar 2147483647  √  null Bill of Materials
m_product_isdropship bpchar 2147483647  √  null m_product_isdropship
isexcludeautodelivery bpchar 2147483647  √  null Exclude from automatic Delivery
isinvoiceprintdetails bpchar 2147483647  √  null Print detail BOM elements on the invoice
ispicklistprintdetails bpchar 2147483647  √  null Print detail BOM elements on the pick list
ispurchased bpchar 2147483647  √  null Organization purchases this product
m_product_isselfservice bpchar 2147483647  √  null m_product_isselfservice
issold bpchar 2147483647  √  null Organization sells this product
isstocked bpchar 2147483647  √  null Organization stocks this product
m_product_issummary bpchar 2147483647  √  null m_product_issummary
isverified bpchar 2147483647  √  null The BOM configuration has been verified
iswebstorefeatured bpchar 2147483647  √  null If selected, the product is displayed in the initial or any empty search
lowlevel numeric 0  √  null The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_attributeset_id numeric 0  √  null Product Attribute Set
m_attributesetinstance_id numeric 0  √  null Product Attribute Set Instance
m_product_m_freightcategory_id numeric 0  √  null m_product_m_freightcategory_id
m_locator_id numeric 0  √  null Warehouse Locator
m_product_product_category_id numeric 0  √  null M_Product_Product_Category_ID
m_product_processing bpchar 2147483647  √  null m_product_processing
producttype bpchar 2147483647  √  null Type of product
r_mailtext_id numeric 0  √  null Text templates for mailings
m_product_salesrep_id numeric 0  √  null m_product_salesrep_id
s_expensetype_id numeric 0  √  null Expense report type
shelfdepth numeric 0  √  null Shelf depth required
shelfheight numeric 0  √  null Shelf height required
shelfwidth numeric 0  √  null Shelf width required
s_resource_id numeric 0  √  null Resource
unitsperpack numeric 0  √  null The Units Per Pack indicates the no of units of a product packed together.
unitsperpallet numeric 0  √  null Units Per Pallet
m_product_updated timestamp 29,6  √  null m_product_updated
m_product_updatedby numeric 0  √  null m_product_updatedby
versionno varchar 2147483647  √  null Version Number
m_product_volume numeric 0  √  null m_product_volume
m_product_weight numeric 0  √  null m_product_weight
m_product_po_ad_org_id numeric 0  √  null m_product_po_ad_org_id
m_product_po_c_bpartner_id numeric 0  √  null m_product_po_c_bpartner_id
m_product_po_c_currency_id numeric 0  √  null m_product_po_c_currency_id
costperorder numeric 0  √  null Fixed Cost Per Order
m_product_po_created timestamp 29,6  √  null m_product_po_created
m_product_po_createdby numeric 0  √  null m_product_po_createdby
m_product_po_c_uom_id numeric 0  √  null m_product_po_c_uom_id
deliverytime_actual numeric 0  √  null Actual days between order and delivery
deliverytime_promised numeric 0  √  null Promised days between order and delivery
m_product_po_discontinued bpchar 2147483647  √  null m_product_po_discontinued
m_product_po_discontinuedat timestamp 29,6  √  null m_product_po_discontinuedat
m_product_po_isactive bpchar 2147483647  √  null m_product_po_isactive
iscurrentvendor bpchar 2147483647  √  null Use this Vendor for pricing and stock replenishment
m_product_po_manufacturer varchar 2147483647  √  null m_product_po_manufacturer
m_product_po_m_product_id numeric 0  √  null m_product_po_m_product_id
order_min numeric 0  √  null Minimum order quantity in UOM
order_pack numeric 0  √  null Package order size in UOM (e.g. order set of 5 units)
priceeffective timestamp 29,6  √  null Effective Date of Price
pricelastinv numeric 0  √  null Price of the last invoice for the product
pricelastpo numeric 0  √  null Price of the last purchase order for the product
m_product_po_pricelist numeric 0  √  null m_product_po_pricelist
pricepo numeric 0  √  null Price based on a purchase order
m_product_po_qualityrating numeric 0  √  null m_product_po_qualityrating
royaltyamt numeric 0  √  null (Included) Amount for copyright, etc.
m_product_po_upc varchar 2147483647  √  null m_product_po_upc
m_product_po_updated timestamp 29,6  √  null m_product_po_updated
m_product_po_updatedby numeric 0  √  null m_product_po_updatedby
m_product_po_vendorcategory varchar 2147483647  √  null m_product_po_vendorcategory
s_resourceassignment_ad_org_id numeric 0  √  null s_resourceassignment_ad_org_id
assigndatefrom timestamp 29,6  √  null Assign resource from
assigndateto timestamp 29,6  √  null Assign resource until
s_resourceassignment_created timestamp 29,6  √  null s_resourceassignment_created
s_resourceassignment_createby numeric 0  √  null s_resourceassignment_createby
s_resourceassignment_isactive bpchar 2147483647  √  null s_resourceassignment_isactive
isconfirmed bpchar 2147483647  √  null Assignment is confirmed
s_resourceassignment_name varchar 2147483647  √  null s_resourceassignment_name
s_resourceassignment_qty numeric 0  √  null s_resourceassignment_qty
s_resourceassignment_s_resour numeric 0  √  null s_resourceassignment_s_resour
s_resourceassignment_updated timestamp 29,6  √  null s_resourceassignment_updated
s_resourceassignment_updatedby numeric 0  √  null s_resourceassignment_updatedby
c_charge_c_org_id numeric 0  √  null
c_charge_c_bpartner_id numeric 0  √  null c_charge_c_bpartner_id
c_chargetype_id numeric 0  √  null Charge Type
c_charge_chargeamt numeric 0  √  null c_charge_chargeamt
c_charge_c_taxcategory_id numeric 0  √  null c_charge_c_taxcategory_id
c_charge_description varchar 2147483647  √  null c_charge_description
c_charge_isactive bpchar 2147483647  √  null c_charge_isactive
issamecurrency bpchar 2147483647  √  null Same Currency
issametax bpchar 2147483647  √  null Use the same tax as the main transaction
c_charge_istaxincluded bpchar 2147483647  √  null c_charge_istaxincluded
c_bpartner_product_ad_org_id numeric 0  √  null c_bpartner_product_ad_org_id
c_bp_product_c_bpartner_id numeric 0  √  null C_BP_Product_C_BPartner_ID
c_bpartner_product_created timestamp 29,6  √  null c_bpartner_product_created
c_bpartner_product_createdby numeric 0  √  null c_bpartner_product_createdby
c_bpartner_product_description varchar 2147483647  √  null c_bpartner_product_description
c_bpartner_product_isactive bpchar 2147483647  √  null c_bpartner_product_isactive
ismanufacturer bpchar 2147483647  √  null Indicate role of this Business partner as Manufacturer
c_bpartner_product_manufactur varchar 2147483647  √  null c_bpartner_product_manufactur
c_bpartner_product_qualityrat numeric 0  √  null c_bpartner_product_qualityrating
shelflifemindays numeric 0  √  null Minimum Shelf Life in days based on Product Instance Guarantee Date
c_bpartner_product_shelflifem numeric 0  √  null c_bpartner_product_shelflifem
c_bpartner_product_updated timestamp 29,6  √  null c_bpartner_product_updated
c_bpartner_product_updatedby numeric 0  √  null c_bpartner_product_updatedby
c_bpartner_product_vendorcate varchar 2147483647  √  null c_bpartner_product_vendorcategory
acqusitioncost numeric 0  √  null The cost of gaining the prospect as a customer
actuallifetimevalue numeric 0  √  null Actual Life Time Revenue
c_bpartner_ad_language varchar 2147483647  √  null c_bpartner_ad_language
ad_orgbp_id numeric 0  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner_ad_org_id numeric 0  √  null C_BPartner_AD_Org_ID
bpartner_parent_id numeric 0  √  null Business Partner Parent
c_bp_group_id numeric 0  √  null Business Partner Group
c_dunning_id numeric 0  √  null Dunning Rules for overdue invoices
c_greeting_id numeric 0  √  null Greeting to print on correspondence
c_invoiceschedule_id numeric 0  √  null Schedule for generating Invoices
c_bpartner_c_paymentterm_id numeric 0  √  null C_BPartner_C_PaymentTerm_ID
c_bpartner_created timestamp 29,6  √  null c_bpartner_created
c_bpartner_createdby numeric 0  √  null c_bpartner_createdby
c_bpartner_c_taxgroup_id numeric 0  √  null C_BPartner_C_TaxGroup_ID
c_bpartner_deliveryrule bpchar 2147483647  √  null c_bpartner_deliveryrule
c_bpartner_deliveryviarule bpchar 2147483647  √  null c_bpartner_deliveryviarule
c_bpartner_description varchar 2147483647  √  null c_bpartner_description
c_bpartner_dunninggrace timestamp 29,6  √  null c_bpartner_dunninggrace
duns varchar 2147483647  √  null Dun & Bradstreet Number
c_bpartner_firstsale timestamp 29,6  √  null c_bpartner_firstsale
c_bpartner_flatdiscount numeric 0  √  null c_bpartner_flatdiscount
c_bpartner_freightcostrule bpchar 2147483647  √  null c_bpartner_freightcostrule
c_bpartner_invoicerule bpchar 2147483647  √  null c_bpartner_invoicerule
c_bpartner_isactive bpchar 2147483647  √  null c_bpartner_isactive
iscustomer bpchar 2147483647  √  null Indicates if this Business Partner is a Customer
c_bpartner_isdiscountprinted bpchar 2147483647  √  null c_bpartner_isdiscountprinted
c_bpartner_isemployee bpchar 2147483647  √  null c_bpartner_isemployee
c_bpartner_ismanufacturer bpchar 2147483647  √  null c_bpartner_ismanufacturer
isonetime bpchar 2147483647  √  null One time transaction
ispotaxexempt bpchar 2147483647  √  null Business partner is exempt from tax on purchases
isprospect bpchar 2147483647  √  null Indicates this is a Prospect
issalesrep bpchar 2147483647  √  null Indicates if the business partner is a sales representative or company agent
c_bpartner_issummary bpchar 2147483647  √  null c_bpartner_issummary
c_bpartner_istaxexempt bpchar 2147483647  √  null c_bpartner_istaxexempt
isvendor bpchar 2147483647  √  null Indicates if this Business Partner is a Vendor
logo_id numeric 0  √  null Logo
m_discountschema_id numeric 0  √  null Schema to calculate the trade discount percentage
c_bpartner_m_pricelist_id numeric 0  √  null C_BPartner_M_PriceList_ID
naics varchar 2147483647  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner_name varchar 2147483647  √  null c_bpartner_name
c_bpartner_name2 varchar 2147483647  √  null c_bpartner_name2
numberemployees numeric 0  √  null Number of employees
c_bpartner_paymentrule bpchar 2147483647  √  null c_bpartner_paymentrule
paymentrulepo bpchar 2147483647  √  null Purchase payment option
po_discountschema_id numeric 0  √  null Schema to calculate the purchase trade discount percentage
po_paymentterm_id numeric 0  √  null Payment rules for a purchase order
po_pricelist_id numeric 0  √  null Price List used by this Business Partner
c_bpartner_poreference varchar 2147483647  √  null c_bpartner_poreference
potentiallifetimevalue numeric 0  √  null Total Revenue expected
c_bpartner_rating bpchar 2147483647  √  null c_bpartner_rating
c_bpartner_referenceno varchar 2147483647  √  null c_bpartner_referenceno
c_bpartner_salesrep_id numeric 0  √  null C_BPartner_SalesRep_ID
salesvolume numeric 0  √  null Total Volume of Sales in Thousands of Currency
c_bpartner_sendemail bpchar 2147483647  √  null c_bpartner_sendemail
shareofcustomer numeric 0  √  null Share of Customer's business as a percentage
c_bpartner_shelflifeminpct numeric 0  √  null c_bpartner_shelflifeminpct
so_creditlimit numeric 0  √  null Total outstanding invoice amounts allowed
socreditstatus bpchar 2147483647  √  null Business Partner Credit Status
so_creditused numeric 0  √  null Current open balance
so_description varchar 2147483647  √  null Description to be used on orders
c_bpartner_taxid varchar 2147483647  √  null c_bpartner_taxid
totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bpartner_updated timestamp 29,6  √  null c_bpartner_updated
c_bpartner_updatedby numeric 0  √  null c_bpartner_updatedby
c_bpartner_url varchar 2147483647  √  null c_bpartner_url
c_bpartner_value varchar 2147483647  √  null c_bpartner_value
c_bpartner_location_ad_org_id numeric 0  √  null C_BPartner_Location_AD_Org_ID
c_bpartner_location_c_bpartne numeric 0  √  null c_bpartner_location_c_bpartne
c_bpartner_location_created timestamp 29,6  √  null c_bpartner_location_created
c_bpartner_location_createdby numeric 0  √  null c_bpartner_location_createdby
c_salesregion_id numeric 0  √  null Sales coverage region
c_bpartner_location_fax varchar 2147483647  √  null c_bpartner_location_fax
c_bpartner_location_isactive bpchar 2147483647  √  null c_bpartner_location_isactive
isbillto bpchar 2147483647  √  null Business Partner Invoice/Bill Address
isdn varchar 2147483647  √  null ISDN or modem line
ispayfrom bpchar 2147483647  √  null Business Partner pays from that address and we'll send dunning letters there
isremitto bpchar 2147483647  √  null Business Partner payment address
isshipto bpchar 2147483647  √  null Business Partner Shipment Address
c_bpartner_location_name varchar 2147483647  √  null c_bpartner_location_name
c_bpartner_location_phone varchar 2147483647  √  null c_bpartner_location_phone
c_bpartner_location_phone2 varchar 2147483647  √  null c_bpartner_location_phone2
c_bpartner_location_updated timestamp 29,6  √  null c_bpartner_location_updated
c_bpartner_location_updatedby numeric 0  √  null c_bpartner_location_updatedby
c_tax_ad_org_id numeric 0  √  null c_tax_ad_org_id
ad_rule_id numeric 0  √  null Rule
c_country_id numeric 0  √  null Country
c_region_id numeric 0  √  null Identifies a geographical Region
c_tax_c_taxcategory_id numeric 0  √  null c_tax_c_taxcategory_id
c_tax_description varchar 2147483647  √  null c_tax_description
c_tax_isactive bpchar 2147483647  √  null c_tax_isactive
c_tax_isdefault bpchar 2147483647  √  null c_tax_isdefault
isdocumentlevel bpchar 2147483647  √  null Tax is calculated on document level (rather than line by line)
issalestax bpchar 2147483647  √  null This is a sales tax (i.e. not a value added tax)
c_tax_issummary bpchar 2147483647  √  null c_tax_issummary
c_tax_istaxexempt bpchar 2147483647  √  null c_tax_istaxexempt
c_tax_name varchar 2147483647  √  null c_tax_name
parent_tax_id numeric 0  √  null Parent Tax indicates a tax that is made up of multiple taxes
rate numeric 0  √  null Rate or Tax or Exchange
requirestaxcertificate bpchar 2147483647  √  null This tax rate requires the Business Partner to be tax exempt
sopotype bpchar 2147483647  √  null Sales Tax applies to sales situations, Purchase Tax to purchase situations
to_country_id numeric 0  √  null Receiving Country
c_tax_to_region_id numeric 0  √  null c_tax_to_region_id
validfrom timestamp 29,6  √  null Valid from including this date (first day)

Analyzed at 2024-01-03 13:53 +0100