Order Management Comparison

Order Management Comparison

C_Campaign

Compiere 3.3 Compiere 3.8.9  
AD_CLIENT_ID   NOT NULL NUMBER(10) AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10) AD_ORG_ID   NOT NULL NUMBER(10)
C_CAMPAIGN_ID   NOT NULL NUMBER(10) C_CAMPAIGN_ID   NOT NULL NUMBER(10)
C_CHANNEL_ID   NUMBER(10) C_CHANNEL_ID NUMBER(10)
COSTS   NOT NULL NUMBER COSTS   NOT NULL NUMBER
CREATED   NOT NULL DATE CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10) CREATEDBY   NOT NULL NUMBER(10)
DESCRIPTION   NVARCHAR2(255) DESCRIPTION NVARCHAR2(382.5)
ENDDATE   DATE ENDDATE DATE
ISACTIVE   NOT NULL CHAR(1) ISACTIVE   NOT NULL CHAR(1)
ISSUMMARY   NOT NULL CHAR(1) ISSUMMARY   NOT NULL CHAR(1)
NAME   NOT NULL NVARCHAR2(60) NAME   NOT NULL NVARCHAR2(90)
STARTDATE   DATE STARTDATE DATE
UPDATED   NOT NULL DATE UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10) UPDATEDBY   NOT NULL NUMBER(10)
VALUE   NOT NULL NVARCHAR2(40) VALUE   NOT NULL NVARCHAR2(60)
ISNTA   CHAR(1)
M_PRICELIST_ID   NUMBER(10)
UM_MAPPINGTYPE   VARCHAR2(30)
UM_CAMPAIGNDISC   NUMBER
ISVERIFIED   CHAR(1)
UM_VALIDATESKU   CHAR(1)
ISREPOST   CHAR(1)
I_ISIMPORTED   CHAR(1)
ISSOLD   CHAR(1)
ISDIRECTCAMPAIGN   CHAR(1)
UM_VALIDATEBOM   CHAR(1)
M_LOCATOR_ID   NUMBER(10)
UM_SKUCONTRIBUTION   CHAR(1)
ISSKUALLOCATION    CHAR(1)
UM_SODOCTYPE_ID   NUMBER(10)
ISSKUALLOCATIONNTA   CHAR(1)
UM_ISGIFT   CHAR(1)

 

UM_CampaignMAPPING

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
C_CAMPAIGN_ID   NOT NULL NUMBER(10)
UM_MAPPINGTYPE   CHAR(1)
UM_CAMPAIGNMAPPING_ID   NOT NULL NUMBER(10)
UM_SUBCHANNEL_ID   NUMBER(10)
UM_CUSTOMERPROGRAM_ID   NUMBER(10)
C_BPARTNER_ID   NUMBER(10)
DESCRIPTION   NVARCHAR2(255)
C_REGION_ID   NUMBER(10)

 

UM_MAPPINGPROVINCE

Compiere 3.3 Compiere 3.8.9
C_REGION_ID   NUMBER(10)
UM_MAPPINGPROVINCE_ID   NOT NULL NUMBER(10)
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
UPDATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
UPDATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UM_CAMPAIGNMAPPING_ID   NUMBER(10)

 

UM_BOMPRODUCTALLOC

Compiere 3.3 Compiere 3.8.9
C_REGION_ID   NUMBER(10)
UM_MAPPINGPROVINCE_ID   NOT NULL NUMBER(10)
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
UPDATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
UPDATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UM_CAMPAIGNMAPPING_ID   NUMBER(10)

 

UM_CAMPSUBPROPOSAL

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
UM_CAMPSUBPROPOSAL_ID   NOT NULL NUMBER(10)
UM_SUBPROPOSAL_ID   NOT NULL NUMBER(10)
C_CAMPAIGN_ID   NOT NULL NUMBER(10)
UM_DISCOUNTTYPE   CHAR(2)
C_BP_GROUP_ID   NUMBER(10)
UM_CUSTOMERPROGRAM_ID   NUMBER(10)
C_YEAR_ID   NUMBER(10)

 

UM_CAMPAIGNSKUALLOC

Compiere 3.3 Compiere 3.8.9
UM_CAMPAIGNSKUALLOC_ID   NOT NULL NUMBER(10)
C_CAMPAIGN_ID   NUMBER(10)
M_PRODUCT_ID   NUMBER(10)
UM_ALLOCATIONPERC   NUMBER
ISACTIVE   CHAR(1)
CREATED   DATE
CREATEDBY   NUMBER(10)
UPDATED   DATE
UPDATEDBY   NUMBER(10)
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
LINE   NUMBER(10)
UM_BUDGETTYPE   NVARCHAR2(60)
UM_SUBPROPOSAL_ID   NUMBER(10)
C_PERIOD_ID   NUMBER(10)
C_YEAR_ID   NUMBER(10)
M_PRODUCT_CATEGORY_ID   NUMBER(10)
UM_P2PPRODUCTBRAND   NVARCHAR2(120)
INV_MNTH   NUMBER(10)
UM_LASTCONTRIPERC   NUMBER
UM_DONOTOVERWRITE   CHAR(1)
DESCRIPTION   NVARCHAR2(255)

 

UM_CAMPAIGNACTIVATIONLOG

Compiere 3.3 Compiere 3.8.9
UM_CAMPAIGNACTIVATIONLOG_ID   NOT NULL NUMBER(10)
C_CAMPAIGN_ID   NUMBER(10)
CAMPAIGNVALUE   NVARCHAR2(40)
STARTDATE   DATE
ENDDATE   DATE
UM_DEACTIVATEDDATE   DATE
DESCRIPTION   NVARCHAR2(255)
AD_CLIENT_ID   NUMBER(10)
AD_ORG_ID   NUMBER(10)
ISACTIVE   CHAR(1)
CREATED   NOT NULL DATE
UPDATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
UPDATEDBY   NOT NULL NUMBER(10)
UM_APPROVEDBYNAME   NVARCHAR2(160)

 

R_Request

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10) AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10) AD_ORG_ID   NOT NULL NUMBER(10)
AD_ROLE_ID   NUMBER(10) AD_ROLE_ID NUMBER(10)
AD_TABLE_ID   NUMBER(10) AD_TABLE_ID NUMBER(10)
AD_USER_ID   NUMBER(10) AD_USER_ID NUMBER(10)
A_ASSET_ID   NUMBER(10) A_ASSET_ID NUMBER(10)
C_ACTIVITY_ID   NUMBER(10) C_ACTIVITY_ID NUMBER(10)
C_BPARTNERSR_ID   NUMBER(10) C_BPARTNERSR_ID NUMBER(10)
C_BPARTNER_ID   NUMBER(10) C_BPARTNER_ID NUMBER(10)
C_CAMPAIGN_ID   NUMBER(10) C_CAMPAIGN_ID NUMBER(10)
C_INVOICEREQUEST_ID   NUMBER(10) C_INVOICEREQUEST_ID NUMBER(10)
C_INVOICE_ID   NUMBER(10) C_INVOICE_ID NUMBER(10)
C_LEAD_ID   NUMBER(10) C_LEAD_ID NUMBER(10)
C_ORDER_ID   NUMBER(10) C_ORDER_ID NUMBER(10)
C_PAYMENT_ID   NUMBER(10) C_PAYMENT_ID NUMBER(10)
C_PROJECT_ID   NUMBER(10) C_PROJECT_ID NUMBER(10)
C_SALESREGION_ID   NUMBER(10) C_SALESREGION_ID NUMBER(10)
CLOSEDATE   DATE CLOSEDATE DATE
CONFIDENTIALTYPE   NOT NULL CHAR(1) CONFIDENTIALTYPE   NOT NULL CHAR(1)
CONFIDENTIALTYPEENTRY   NOT NULL CHAR(1) CONFIDENTIALTYPEENTRY   NOT NULL CHAR(1)
CREATED   NOT NULL DATE CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10) CREATEDBY   NOT NULL NUMBER(10)
DATECOMPLETEPLAN   DATE DATECOMPLETEPLAN DATE
DATELASTACTION   DATE DATELASTACTION DATE
DATELASTALERT   DATE DATELASTALERT DATE
DATENEXTACTION   DATE DATENEXTACTION DATE
DATESTARTPLAN   DATE DATESTARTPLAN DATE
DOCUMENTNO   NOT NULL NVARCHAR2(30) DOCUMENTNO   NOT NULL NVARCHAR2(45)
DUETYPE   NOT NULL CHAR(1) DUETYPE   NOT NULL CHAR(1)
ENDTIME   DATE ENDTIME DATE
ISACTIVE   NOT NULL CHAR(1) ISACTIVE   NOT NULL CHAR(1)
ISESCALATED   NOT NULL CHAR(1) ISESCALATED   NOT NULL CHAR(1)
ISINVOICED   NOT NULL CHAR(1) ISINVOICED   NOT NULL CHAR(1)
ISSELFSERVICE   NOT NULL CHAR(1) ISSELFSERVICE   NOT NULL CHAR(1)
LASTRESULT   NVARCHAR2(2000) LASTRESULT NVARCHAR2(2000)
M_CHANGEREQUEST_ID   NUMBER(10) M_CHANGEREQUEST_ID NUMBER(10)
M_FIXCHANGENOTICE_ID   NUMBER(10) M_FIXCHANGENOTICE_ID NUMBER(10)
M_INOUT_ID   NUMBER(10) M_INOUT_ID NUMBER(10)
M_PRODUCTSPENT_ID   NUMBER(10) M_PRODUCTSPENT_ID NUMBER(10)
M_PRODUCT_ID   NUMBER(10) M_PRODUCT_ID NUMBER(10)
NEXTACTION   CHAR(1) NEXTACTION CHAR(1)
PRIORITY   NOT NULL CHAR(1) PRIORITY   NOT NULL CHAR(1)
PRIORITYUSER   CHAR(1) PRIORITYUSER CHAR(1)
PROCESSED   NOT NULL CHAR(1) PROCESSED   NOT NULL CHAR(1)
QTYINVOICED   NUMBER QTYINVOICED NUMBER
QTYPLAN   NUMBER QTYPLAN NUMBER
QTYSPENT   NUMBER QTYSPENT NUMBER
R_CATEGORY_ID   NUMBER(10) R_CATEGORY_ID NUMBER(10)
R_GROUP_ID   NUMBER(10) R_GROUP_ID NUMBER(10)
R_MAILTEXT_ID   NUMBER(10) R_MAILTEXT_ID NUMBER(10)
R_REQUESTRELATED_ID   NUMBER(10) R_REQUESTRELATED_ID NUMBER(10)
R_REQUESTTYPE_ID   NOT NULL NUMBER(10) R_REQUESTTYPE_ID   NOT NULL NUMBER(10)
R_REQUEST_ID   NOT NULL NUMBER(10) R_REQUEST_ID   NOT NULL NUMBER(10)
R_RESOLUTION_ID   NUMBER(10) R_RESOLUTION_ID NUMBER(10)
R_SOURCE_ID   NUMBER(10) R_SOURCE_ID NUMBER(10)
R_STANDARDRESPONSE_ID   NUMBER(10) R_STANDARDRESPONSE_ID NUMBER(10)
R_STATUS_ID   NUMBER(10) R_STATUS_ID NUMBER(10)
RECORD_ID   NUMBER(10) RECORD_ID NUMBER(10)
REQUESTAMT   NOT NULL NUMBER REQUESTAMT   NOT NULL NUMBER
RESULT   NVARCHAR2(2000) RESULT NVARCHAR2(2000)
SALESREP_ID   NUMBER(10) SALESREP_ID NUMBER(10)
STARTDATE   DATE STARTDATE DATE
STARTTIME   DATE STARTTIME DATE
SUMMARY   NVARCHAR2(2000) SUMMARY   NOT NULL NVARCHAR2(2000)
TASKSTATUS   CHAR(1) TASKSTATUS CHAR(1)
UPDATED   NOT NULL DATE UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10) UPDATEDBY   NOT NULL NUMBER(10)
UM_APPROVEDBY   VARCHAR2(10)
UM_APPROVEDDATE   DATE
UM_ISREADONLY   CHAR(1)
UM_NODE   NVARCHAR2(60)
UM_REQUESTPRINTNO   NVARCHAR2(60)
UM_APPROVEDBYNAME   NVARCHAR2(60)
UM_REJECTEDBY   NVARCHAR2(60)
UM_REJECTEDDATE   DATE
UM_REQUESTEDBYNAME   NVARCHAR2(60)
UM_REQUESTEDDATE   DATE

 

UM_RequestLine

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
UM_REQUESTLINE_ID   NOT NULL NUMBER(10)
C_BPARTNER_ID   NUMBER(10)
R_REQUEST_ID   NOT NULL NUMBER(10)
R_STATUS_ID   NUMBER(10)
DESCRIPTION   NVARCHAR2(1000)
UM_AVERAGESELLOUTAMT   NUMBER
UM_CURRENTLIMITAMT   NUMBER
UM_CURRENTAGINGAMT   NUMBER
UM_ISREJECTED   NOT NULL CHAR(1)
ISACTIVE   NOT NULL CHAR(1)
UM_CUSTOMERNAME   NVARCHAR2(60)
UM_PROPOSEDLIMITAMT   NUMBER
PROCESSED   NOT NULL CHAR(1)
UM_NODE   NVARCHAR2(60)
LINE   NUMBER(10)
UM_REJECTEDBY   NVARCHAR2(60)
UM_REJECTEDDATE   DATE

 

Commercial Discount

UM_CommDiscount

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
UM_COMMDISCOUNT_ID   NOT NULL NUMBER(10)
DATAENTRYDATE   DATE
C_CAMPAIGN_ID   NUMBER(10)
UM_PHYDOCUMENTNO   NVARCHAR2(30)
DOCUMENTNO   NVARCHAR2(20)
PROCESSED   NOT NULL CHAR(1)
UM_COMMDISCSTATUS   CHAR(1)
UM_APPROVEDBY   VARCHAR2(10)
UM_APPROVEDDATE   DATE
DESCRIPTION   NVARCHAR2(255)
UM_ISREADONLY   CHAR(1)

 

UM_COMMDISCLINE

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
UM_COMMDISCLINE_ID   NOT NULL NUMBER(10)
C_BP_GROUP_ID   NUMBER(10)
UM_CUSTOMERPROGRAM_ID   NUMBER(10)
C_BPARTNER_ID   NUMBER(10)
UM_PITAMT   NUMBER
UM_AMTAFTERPIT   NUMBER
UM_AMTBEFOREPIT   NUMBER
UM_AMTBEFOREVAT   NUMBER
UM_COMMDISCOUNT_ID   NOT NULL NUMBER(10)
DESCRIPTION   NVARCHAR2(255)
TAXID   NVARCHAR2(20)
C_INVOICE_ID   NUMBER(10)
ISALLOCATED   CHAR(1)
UM_COMMDISCSTATUS   CHAR(1)
UM_REJECTEDDATE   DATE
PROCESSED   NOT NULL CHAR(1)
UM_REJECTBY   VARCHAR2(10)
UM_PRINTNO   NVARCHAR2(255)
C_CAMPAIGN_ID   NUMBER(10)
UM_ISREADONLY   CHAR(1)
ISCANCELLED   CHAR(1)

 

EPDiscount

UM_EPDiscount

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UM_EPDISCOUNT_ID   NOT NULL NUMBER(10)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
DISCOUNT   NOT NULL NUMBER
NAME   NVARCHAR2(60)
STARTFROM   DATE
ENDTO   DATE

 

Customer Support Days

UM_CusSupportDays

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1)
UM_CUSSUPPORTDAYS_ID   NOT NULL NUMBER(10)
UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10)
DISCOUNTDAYS   NOT NULL NUMBER
STARTFROM   DATE
ENDTO   DATE
C_BPARTNER_ID   NUMBER(10)

 

Manage Invoice

C_Invoice

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10) AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORGTRX_ID   NUMBER(10) AD_ORGTRX_ID NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10) AD_ORG_ID   NOT NULL NUMBER(10)
AD_USER_ID   NUMBER(10) AD_USER_ID NUMBER(10)
C_ACTIVITY_ID   NUMBER(10) C_ACTIVITY_ID NUMBER(10)
C_BP_BANKACCOUNT_ID   NUMBER(10) C_BP_BANKACCOUNT_ID NUMBER(10)
C_BPARTNERSR_ID   NUMBER(10) C_BPARTNERSR_ID NUMBER(10)
C_BPARTNERSHIPTO_LOCATION_ID NUMBER(10)
C_BPARTNER_ID   NOT NULL NUMBER(10) C_BPARTNER_ID   NOT NULL NUMBER(10)
C_BPARTNER_LOCATION_ID   NOT NULL NUMBER(10) C_BPARTNER_LOCATION_ID   NOT NULL NUMBER(10)
C_BLANKETORDER_ID NUMBER(10)
C_CAMPAIGN_ID   NUMBER(10) C_CAMPAIGN_ID NUMBER(10)
C_CASHBOOK_ID NUMBER(10)
C_CASHLINE_ID   NUMBER(10) C_CASHLINE_ID NUMBER(10)
C_CHARGE_ID   NUMBER(10) C_CHARGE_ID NUMBER(10)
C_CONVERSIONTYPE_ID   NUMBER(10) C_CONVERSIONTYPE_ID NUMBER(10)
C_CURRENCY_ID   NOT NULL NUMBER(10) C_CURRENCY_ID   NOT NULL NUMBER(10)
C_DOCTYPETARGET_ID   NOT NULL NUMBER(10) C_DOCTYPETARGET_ID   NOT NULL NUMBER(10)
C_DOCTYPE_ID   NOT NULL NUMBER(10) C_DOCTYPE_ID   NOT NULL NUMBER(10)
C_INVOICE_ID   NOT NULL NUMBER(10) C_INVOICE_ID   NOT NULL NUMBER(10)
C_ORDER_ID   NUMBER(10) C_ORDER_ID NUMBER(10)
C_PAYMENTTERM_ID   NOT NULL NUMBER(10) C_PAYMENTTERM_ID   NOT NULL NUMBER(10)
C_PAYMENT_ID   NUMBER(10) C_PAYMENT_ID NUMBER(10)
C_PROJECT_ID   NUMBER(10) C_PROJECT_ID NUMBER(10)
CHARGEAMT   NUMBER CHARGEAMT NUMBER
COPYFROM   CHAR(1) COPYFROM CHAR(1)
CREATEFROM   CHAR(1) CREATEFROM CHAR(1)
CREATED   NOT NULL DATE CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10) CREATEDBY   NOT NULL NUMBER(10)
DATEACCT   NOT NULL DATE DATEACCT   NOT NULL DATE
DATEINVOICED   NOT NULL DATE DATEINVOICED   NOT NULL DATE
DATEORDERED   DATE DATEORDERED DATE
DATEPRINTED   DATE DATEPRINTED DATE
DESCRIPTION   NVARCHAR2(255) DESCRIPTION NVARCHAR2(382.5)
DOCACTION   NOT NULL CHAR(2) DOCACTION   NOT NULL CHAR(2)
DOCSTATUS   NOT NULL CHAR(2) DOCSTATUS   NOT NULL CHAR(2)
DOCUMENTNO   NOT NULL NVARCHAR2(30) DOCUMENTNO   NOT NULL NVARCHAR2(45)
GENERATETO   CHAR(1) GENERATETO CHAR(1)
GRANDTOTAL   NOT NULL NUMBER GRANDTOTAL   NOT NULL NUMBER
INVOICECOLLECTIONTYPE   CHAR(1) INVOICECOLLECTIONTYPE CHAR(1)
ISACTIVE   NOT NULL CHAR(1) ISACTIVE   NOT NULL CHAR(1)
ISAPPROVED   NOT NULL CHAR(1) ISAPPROVED   NOT NULL CHAR(1)
ISDISCOUNTPRINTED   NOT NULL CHAR(1) ISDISCOUNTPRINTED   NOT NULL CHAR(1)
ISINDISPUTE   NOT NULL CHAR(1) ISINDISPUTE   NOT NULL CHAR(1)
ISMATCHEXCEPTIONACCEPTED CHAR(1)
ISPOMATCHED CHAR(1)
ISPAID   NOT NULL CHAR(1) ISPAID   NOT NULL CHAR(1)
ISPAYSCHEDULEVALID   NOT NULL CHAR(1) ISPAYSCHEDULEVALID   NOT NULL CHAR(1)
ISPRINTED   NOT NULL CHAR(1) ISPRINTED   NOT NULL CHAR(1)
ISRECEIPTMATCHED CHAR(1)
ISRETURNTRX   NOT NULL CHAR(1) ISRETURNTRX   NOT NULL CHAR(1)
ISSOTRX   NOT NULL CHAR(1) ISSOTRX   NOT NULL CHAR(1)
ISSELFSERVICE   NOT NULL CHAR(1) ISSELFSERVICE   NOT NULL CHAR(1)
ISTAXINCLUDED   NOT NULL CHAR(1) ISTAXINCLUDED   NOT NULL CHAR(1)
ISTRANSFERRED   NOT NULL CHAR(1) ISTRANSFERRED   NOT NULL CHAR(1)
M_CONSIGNEDTRANSFER_ID NUMBER(10)
M_PRICELIST_ID   NOT NULL NUMBER(10) M_PRICELIST_ID   NOT NULL NUMBER(10)
M_SHIPPER_ID NUMBER(10)
MATCHINVOICEPROCESS CHAR(1)
MATCHREQUIREMENTI   CHAR(1) MATCHREQUIREMENTI CHAR(1)
POREFERENCE   NVARCHAR2(20) POREFERENCE NVARCHAR2(45)
PAYMENTRULE   NOT NULL CHAR(1) PAYMENTRULE   NOT NULL CHAR(1)
POSTED   NOT NULL CHAR(1) POSTED   NOT NULL CHAR(1)
PROCESSED   NOT NULL CHAR(1) PROCESSED   NOT NULL CHAR(1)
PROCESSING   CHAR(1) PROCESSING CHAR(1)
REF_INVOICE_ID   NUMBER(10) REF_INVOICE_ID NUMBER(10)
SALESREP_ID   NUMBER(10) SALESREP_ID NUMBER(10)
SENDEMAIL   NOT NULL CHAR(1) SENDEMAIL   NOT NULL CHAR(1)
TOTALLINES   NOT NULL NUMBER TOTALLINES   NOT NULL NUMBER
UPDATED   NOT NULL DATE UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10) UPDATEDBY   NOT NULL NUMBER(10)
USER1_ID   NUMBER(10) USER1_ID NUMBER(10)
USER2_ID   NUMBER(10) USER2_ID NUMBER(10)
UM_NUMBERTOWORDS   NVARCHAR2(2000)
UM_PRINTNO   NVARCHAR2(255)
UM_ISPRINTED   CHAR(1)
UM_ISCONFIRMED   CHAR(1)
UM_ORIGINVOICENO   NVARCHAR2(255)
UM_3ACONTRACTNO   NVARCHAR2(40)
UM_BOLDATE   DATE
UM_BOLREFNO   NVARCHAR2(40)
UM_CONTAINERNO   NVARCHAR2(14)
UM_CREATEPOLINES   CHAR(1)
UM_ETADATE   DATE
UM_PAYMENTMODE   CHAR(2)
UM_SHIPMENTNO   NVARCHAR2(30)
CURRENCYRATE   NUMBER
UM_ISWRITEOFF   CHAR(1)
UM_ISADJUSTMENT   CHAR(1)
UM_FXINVOICE_ID   NUMBER(10)
UM_M_INOUT_ID   NUMBER(10)
UM_CREATERETURNLINES   CHAR(1)
I_ISIMPORTED   CHAR(1)
UM_INVOICETYPE   CHAR(2)
UM_PREFIXINVNO   NVARCHAR2(20)
UM_PHYSICALINVNO   NVARCHAR2(20)
UM_VATINVOICE   CHAR(2)
UM_ATTRIBUTES_ID   NUMBER(10)
UM_NTACONTRACTNO   NVARCHAR2(22)
UM_PRREFNO   NVARCHAR2(22)
UM_BILLREFNO   NVARCHAR2(22)
ISNTA   CHAR(1)
UM_REJECTIONCODE_ID   NUMBER(10)
TAXID   NVARCHAR2(20)
DUEDATE   DATE
DATETRX   DATE
NAME2   NVARCHAR2(120)
UM_PREFIXSOINVNO   NVARCHAR2(6)
UM_WAREHOUSE   NVARCHAR2(5)
BANKNAME   NVARCHAR2(100)
UM_INVOICEADDRESS   NVARCHAR2(500)
UM_ISBACKDATEDINVOICE   CHAR(1)
UM_ISWITHPO   CHAR(1)
UM_EBE_BP_NAME   NVARCHAR2(60)
UM_EBE_TAXID   NVARCHAR2(60)
ISEMPLOYEE   CHAR(1)
UM_CUSTOMERPROGRAM   NVARCHAR2(60)
UM_SUBCHANNEL   NVARCHAR2(22)
UM_SERIAL_INVOICE_NO   NVARCHAR2(11)
UM_CIT   CHAR(2)
UM_ISBILLCUTOFFINV   CHAR(1)
UM_REVERSEDDATE   DATE
UM_PAYMENTMETHOD   CHAR(1)
UM_ISSFA   CHAR(1)
UM_NTA_PAYMENT_ID   NUMBER(10)
UM_ISGIT   CHAR(1)
UM_ISDMS   CHAR(1)
ISEXPORTED   CHAR(1)

 

C_InvoiceLine

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10) AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORGTRX_ID   NUMBER(10) AD_ORGTRX_ID NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10) AD_ORG_ID   NOT NULL NUMBER(10)
A_ASSET_ID   NUMBER(10) A_ASSET_ID NUMBER(10)
C_ACTIVITY_ID   NUMBER(10) C_ACTIVITY_ID NUMBER(10)
C_CAMPAIGN_ID   NUMBER(10) C_CAMPAIGN_ID NUMBER(10)
C_CHARGE_ID   NUMBER(10) C_CHARGE_ID NUMBER(10)
C_INVOICELINE_ID   NOT NULL NUMBER(10) C_INVOICELINE_ID   NOT NULL NUMBER(10)
C_INVOICE_ID   NOT NULL NUMBER(10) C_INVOICE_ID   NOT NULL NUMBER(10)
C_ORDERLINE_ID   NUMBER(10) C_ORDERLINE_ID NUMBER(10)
C_PROJECTPHASE_ID   NUMBER(10) C_PROJECTPHASE_ID NUMBER(10)
C_PROJECTTASK_ID   NUMBER(10) C_PROJECTTASK_ID NUMBER(10)
C_PROJECT_ID   NUMBER(10) C_PROJECT_ID NUMBER(10)
C_TAX_ID   NUMBER(10) C_TAX_ID NUMBER(10)
C_UOM_ID   NUMBER(10) C_UOM_ID NUMBER(10)
CREATED   NOT NULL DATE CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10) CREATEDBY   NOT NULL NUMBER(10)
DESCRIPTION   NVARCHAR2(255) DESCRIPTION NVARCHAR2(382.5)
ISACTIVE   NOT NULL CHAR(1) ISACTIVE   NOT NULL CHAR(1)
ISASSETADDITION   CHAR(1) ISASSETADDITION CHAR(1)
ISDESCRIPTION   NOT NULL CHAR(1) ISDESCRIPTION   NOT NULL CHAR(1)
ISDROPSHIP   NOT NULL CHAR(1)
ISMATCHEXCEPTIONACCEPTED CHAR(1)
ISNOPOMATCH CHAR(1)
ISPOMATCHED CHAR(1)
ISPRINTED   NOT NULL CHAR(1) ISPRINTED   NOT NULL CHAR(1)
ISRECEIPTMATCHED CHAR(1)
LINE   NOT NULL NUMBER(10) LINE   NOT NULL NUMBER(10)
LINEDOCSTATUS   CHAR(2) LINEDOCSTATUS CHAR(2)
LINENETAMT   NOT NULL NUMBER LINENETAMT   NOT NULL NUMBER
LINETOTALAMT   NUMBER LINETOTALAMT NUMBER
M_ATTRIBUTESETINSTANCE_ID   NUMBER(10) M_ATTRIBUTESETINSTANCE_ID NUMBER(10)
M_CONSIGNEDTRANSFERLINE_ID NUMBER(10)
M_INOUTLINE_ID   NUMBER(10) M_INOUTLINE_ID NUMBER(10)
M_PRODUCT_ID   NUMBER(10) M_PRODUCT_ID NUMBER(10)
PRICEACTUAL   NOT NULL NUMBER PRICEACTUAL   NOT NULL NUMBER
PRICEENTERED   NOT NULL NUMBER PRICEENTERED   NOT NULL NUMBER
PRICELIMIT   NOT NULL NUMBER PRICELIMIT   NOT NULL NUMBER
PRICELIST   NOT NULL NUMBER PRICELIST   NOT NULL NUMBER
PROCESSED   NOT NULL CHAR(1) PROCESSED   NOT NULL CHAR(1)
QTYENTERED   NOT NULL NUMBER QTYENTERED   NOT NULL NUMBER
QTYINVOICED   NOT NULL NUMBER QTYINVOICED   NOT NULL NUMBER
RRAMT   NUMBER RRAMT NUMBER
RRSTARTDATE   DATE RRSTARTDATE DATE
REF_INVOICELINE_ID   NUMBER(10) REF_INVOICELINE_ID NUMBER(10)
S_RESOURCEASSIGNMENT_ID   NUMBER(10) S_RESOURCEASSIGNMENT_ID NUMBER(10)
TAXAMT   NUMBER TAXAMT NUMBER
UPDATED   NOT NULL DATE UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10) UPDATEDBY   NOT NULL NUMBER(10)
USER1_ID   NUMBER(10) USER1_ID NUMBER(10)
USER2_ID   NUMBER(10) USER2_ID NUMBER(10)
UM_QTYINCARTON   NUMBER
UM_QTYINTIN   NUMBER
UM_ISVOLUMEDISCOUNT   CHAR(1)
UM_ISOTHERDISCOUNT   CHAR(1)
UM_3ACONTRACTNO   NVARCHAR2(30)
UM_CONTAINERNO   NVARCHAR2(40)
UM_ORDERLINE_ID   NUMBER(10)
UM_SHIPMENTNO   NVARCHAR2(40)
UM_CONTRACTNO_ID   NUMBER(10)
POREFERENCE   NVARCHAR2(20)
UM_CIFAMT   NUMBER
AMTSOURCE   NUMBER
UM_SOURCECURRENCY_ID   NUMBER(10)
UM_COMMDISCLINE_ID   NUMBER(10)
UM_CIT   CHAR(2)
UM_EXPIRYDATE   DATE
UM_SUBACTIVITY_ID   NUMBER(10)
UM_ERNUMBER   NVARCHAR2(60)
UM_EMPLOYEE_ID   NUMBER(10)
ISBOM   CHAR(1)
UM_DISCOUNTAMT   NUMBER
UM_ISCOMMDISCAPPLIED   CHAR(1)
UM_ISFREEITEM   CHAR(1)
UM_BASEPRICE   NUMBER
UM_CHANNELPRICE   NUMBER
UM_FREEITEMLINE_ID   NUMBER(10)
UM_ISGIFT   CHAR(1)
M_PRICELIST_ID   NUMBER(10)
UM_ISPRICEDISC   NOT NULL CHAR(1)
UM_PROMOSKUINOUTLINES   NVARCHAR2(255)
UM_PROMOSKUINVLINES   NVARCHAR2(255)

 

C_InvoiceTax

Compiere 3.3 Compiere 3.8.9
AD_CLIENT_ID   NOT NULL NUMBER(10) AD_CLIENT_ID   NOT NULL NUMBER(10)
AD_ORG_ID   NOT NULL NUMBER(10) AD_ORG_ID   NOT NULL NUMBER(10)
C_INVOICE_ID   NOT NULL NUMBER(10) C_INVOICE_ID   NOT NULL NUMBER(10)
C_TAX_ID   NOT NULL NUMBER(10) C_TAX_ID   NOT NULL NUMBER(10)
CREATED   NOT NULL DATE CREATED   NOT NULL DATE
CREATEDBY   NOT NULL NUMBER(10) CREATEDBY   NOT NULL NUMBER(10)
ISACTIVE   NOT NULL CHAR(1) ISACTIVE   NOT NULL CHAR(1)
ISTAXINCLUDED   NOT NULL CHAR(1) ISTAXINCLUDED   NOT NULL CHAR(1)
PROCESSED   NOT NULL CHAR(1) PROCESSED   NOT NULL CHAR(1)
TAXAMT   NOT NULL NUMBER TAXAMT   NOT NULL NUMBER
TAXBASEAMT   NOT NULL NUMBER TAXBASEAMT   NOT NULL NUMBER
UPDATED   NOT NULL DATE UPDATED   NOT NULL DATE
UPDATEDBY   NOT NULL NUMBER(10) UPDATEDBY   NOT NULL NUMBER(10)