I have a new screen which utilizes a custom DAC class based on a table I imported in to the Acumatica database. When I manually add rows to the SQL table, the data is present in the new screen but the save functionality is not working. I don’t receive any errors but the data is not actually saved to the database for new or existing rows. The delete button does not work either.
Because I can view the data properly, but not save, I am lead to believe that this is an issue with some of the DAC attributes but I followed the documentation in the partner learning program (and I got the example to work) but now this project isn’t working.
Here is new custom DAC:
using System;
using PX.Data;
namespace MyCustomImport
{
[PXCacheName("myTable")]
public class myTable: IBqlTable
{
#region Ord_type
[PXDBString(1, IsKey = true, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXDefault]
[PXUIField(DisplayName = "Ord_type")]
public virtual string Ord_type { get; set; }
public abstract class ord_type : PX.Data.BQL.BqlString.Field<ord_type> { }
#endregion
#region Ord_no
[PXDBString(8, IsKey = true, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXDefault]
[PXUIField(DisplayName = "Ord_no")]
public virtual string Ord_no { get; set; }
public abstract class ord_no : PX.Data.BQL.BqlString.Field<ord_no> { }
#endregion
#region Entered_dt
[PXDBDate()]
[PXDefault]
[PXUIField(DisplayName = "Entered_dt")]
public virtual DateTime? Entered_dt { get; set; }
public abstract class entered_dt : PX.Data.BQL.BqlDateTime.Field<entered_dt> { }
#endregion
#region Ord_dt
[PXDBDate()]
[PXDefault]
[PXUIField(DisplayName = "Ord_dt")]
public virtual DateTime? Ord_dt { get; set; }
public abstract class ord_dt : PX.Data.BQL.BqlDateTime.Field<ord_dt> { }
#endregion
#region Apply_to_no
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Apply_to_no")]
public virtual string Apply_to_no { get; set; }
public abstract class apply_to_no : PX.Data.BQL.BqlString.Field<apply_to_no> { }
#endregion
#region Oe_po_no
[PXDBString(25, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Oe_po_no")]
public virtual string Oe_po_no { get; set; }
public abstract class oe_po_no : PX.Data.BQL.BqlString.Field<oe_po_no> { }
#endregion
#region Cus_no
[PXDBString(20, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cus_no")]
public virtual string Cus_no { get; set; }
public abstract class cus_no : PX.Data.BQL.BqlString.Field<cus_no> { }
#endregion
#region Bill_to_name
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_name")]
public virtual string Bill_to_name { get; set; }
public abstract class bill_to_name : PX.Data.BQL.BqlString.Field<bill_to_name> { }
#endregion
#region Bill_to_addr_1
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_1")]
public virtual string Bill_to_addr_1 { get; set; }
public abstract class bill_to_addr_1 : PX.Data.BQL.BqlString.Field<bill_to_addr_1> { }
#endregion
#region Bill_to_addr_2
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_2")]
public virtual string Bill_to_addr_2 { get; set; }
public abstract class bill_to_addr_2 : PX.Data.BQL.BqlString.Field<bill_to_addr_2> { }
#endregion
#region Bill_to_addr_3
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_3")]
public virtual string Bill_to_addr_3 { get; set; }
public abstract class bill_to_addr_3 : PX.Data.BQL.BqlString.Field<bill_to_addr_3> { }
#endregion
#region Bill_to_addr_4
[PXDBString(44, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_addr_4")]
public virtual string Bill_to_addr_4 { get; set; }
public abstract class bill_to_addr_4 : PX.Data.BQL.BqlString.Field<bill_to_addr_4> { }
#endregion
#region Bill_to_country
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Bill_to_country")]
public virtual string Bill_to_country { get; set; }
public abstract class bill_to_country : PX.Data.BQL.BqlString.Field<bill_to_country> { }
#endregion
#region Cus_alt_adr_cd
[PXDBString(15, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cus_alt_adr_cd")]
public virtual string Cus_alt_adr_cd { get; set; }
public abstract class cus_alt_adr_cd : PX.Data.BQL.BqlString.Field<cus_alt_adr_cd> { }
#endregion
#region Ship_to_name
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_name")]
public virtual string Ship_to_name { get; set; }
public abstract class ship_to_name : PX.Data.BQL.BqlString.Field<ship_to_name> { }
#endregion
#region Ship_to_addr_1
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_1")]
public virtual string Ship_to_addr_1 { get; set; }
public abstract class ship_to_addr_1 : PX.Data.BQL.BqlString.Field<ship_to_addr_1> { }
#endregion
#region Ship_to_addr_2
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_2")]
public virtual string Ship_to_addr_2 { get; set; }
public abstract class ship_to_addr_2 : PX.Data.BQL.BqlString.Field<ship_to_addr_2> { }
#endregion
#region Ship_to_addr_3
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_3")]
public virtual string Ship_to_addr_3 { get; set; }
public abstract class ship_to_addr_3 : PX.Data.BQL.BqlString.Field<ship_to_addr_3> { }
#endregion
#region Ship_to_addr_4
[PXDBString(44, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_addr_4")]
public virtual string Ship_to_addr_4 { get; set; }
public abstract class ship_to_addr_4 : PX.Data.BQL.BqlString.Field<ship_to_addr_4> { }
#endregion
#region Ship_to_country
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_to_country")]
public virtual string Ship_to_country { get; set; }
public abstract class ship_to_country : PX.Data.BQL.BqlString.Field<ship_to_country> { }
#endregion
#region Shipping_dt
[PXDBDate()]
[PXUIField(DisplayName = "Shipping_dt")]
public virtual DateTime? Shipping_dt { get; set; }
public abstract class shipping_dt : PX.Data.BQL.BqlDateTime.Field<shipping_dt> { }
#endregion
#region Ship_via_cd
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_via_cd")]
public virtual string Ship_via_cd { get; set; }
public abstract class ship_via_cd : PX.Data.BQL.BqlString.Field<ship_via_cd> { }
#endregion
#region Ar_terms_cd
[PXDBString(2, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ar_terms_cd")]
public virtual string Ar_terms_cd { get; set; }
public abstract class ar_terms_cd : PX.Data.BQL.BqlString.Field<ar_terms_cd> { }
#endregion
#region Ship_instruction_1
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_instruction_1")]
public virtual string Ship_instruction_1 { get; set; }
public abstract class ship_instruction_1 : PX.Data.BQL.BqlString.Field<ship_instruction_1> { }
#endregion
#region Ship_instruction_2
[PXDBString(40, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ship_instruction_2")]
public virtual string Ship_instruction_2 { get; set; }
public abstract class ship_instruction_2 : PX.Data.BQL.BqlString.Field<ship_instruction_2> { }
#endregion
#region Slspsn_no
[PXDBInt()]
[PXUIField(DisplayName = "Slspsn_no")]
public virtual int? Slspsn_no { get; set; }
public abstract class slspsn_no : PX.Data.BQL.BqlInt.Field<slspsn_no> { }
#endregion
#region Slspsn_pct_comm
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_pct_comm")]
public virtual Decimal? Slspsn_pct_comm { get; set; }
public abstract class slspsn_pct_comm : PX.Data.BQL.BqlDecimal.Field<slspsn_pct_comm> { }
#endregion
#region Slspsn_comm_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_comm_amt")]
public virtual Decimal? Slspsn_comm_amt { get; set; }
public abstract class slspsn_comm_amt : PX.Data.BQL.BqlDecimal.Field<slspsn_comm_amt> { }
#endregion
#region Slspsn_no_2
[PXDBInt()]
[PXUIField(DisplayName = "Slspsn_no_2")]
public virtual int? Slspsn_no_2 { get; set; }
public abstract class slspsn_no_2 : PX.Data.BQL.BqlInt.Field<slspsn_no_2> { }
#endregion
#region Slspsn_pct_comm_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_pct_comm_2")]
public virtual Decimal? Slspsn_pct_comm_2 { get; set; }
public abstract class slspsn_pct_comm_2 : PX.Data.BQL.BqlDecimal.Field<slspsn_pct_comm_2> { }
#endregion
#region Slspsn_comm_amt_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_comm_amt_2")]
public virtual Decimal? Slspsn_comm_amt_2 { get; set; }
public abstract class slspsn_comm_amt_2 : PX.Data.BQL.BqlDecimal.Field<slspsn_comm_amt_2> { }
#endregion
#region Slspsn_no_3
[PXDBInt()]
[PXUIField(DisplayName = "Slspsn_no_3")]
public virtual int? Slspsn_no_3 { get; set; }
public abstract class slspsn_no_3 : PX.Data.BQL.BqlInt.Field<slspsn_no_3> { }
#endregion
#region Slspsn_pct_comm_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_pct_comm_3")]
public virtual Decimal? Slspsn_pct_comm_3 { get; set; }
public abstract class slspsn_pct_comm_3 : PX.Data.BQL.BqlDecimal.Field<slspsn_pct_comm_3> { }
#endregion
#region Slspsn_comm_amt_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Slspsn_comm_amt_3")]
public virtual Decimal? Slspsn_comm_amt_3 { get; set; }
public abstract class slspsn_comm_amt_3 : PX.Data.BQL.BqlDecimal.Field<slspsn_comm_amt_3> { }
#endregion
#region Tax_cd
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Tax_cd")]
public virtual string Tax_cd { get; set; }
public abstract class tax_cd : PX.Data.BQL.BqlString.Field<tax_cd> { }
#endregion
#region Tax_pct
[PXDBDecimal()]
[PXUIField(DisplayName = "Tax_pct")]
public virtual Decimal? Tax_pct { get; set; }
public abstract class tax_pct : PX.Data.BQL.BqlDecimal.Field<tax_pct> { }
#endregion
#region Tax_cd_2
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Tax_cd_2")]
public virtual string Tax_cd_2 { get; set; }
public abstract class tax_cd_2 : PX.Data.BQL.BqlString.Field<tax_cd_2> { }
#endregion
#region Tax_pct_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Tax_pct_2")]
public virtual Decimal? Tax_pct_2 { get; set; }
public abstract class tax_pct_2 : PX.Data.BQL.BqlDecimal.Field<tax_pct_2> { }
#endregion
#region Tax_cd_3
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Tax_cd_3")]
public virtual string Tax_cd_3 { get; set; }
public abstract class tax_cd_3 : PX.Data.BQL.BqlString.Field<tax_cd_3> { }
#endregion
#region Tax_pct_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Tax_pct_3")]
public virtual Decimal? Tax_pct_3 { get; set; }
public abstract class tax_pct_3 : PX.Data.BQL.BqlDecimal.Field<tax_pct_3> { }
#endregion
#region Discount_pct
[PXDBDecimal()]
[PXUIField(DisplayName = "Discount_pct")]
public virtual Decimal? Discount_pct { get; set; }
public abstract class discount_pct : PX.Data.BQL.BqlDecimal.Field<discount_pct> { }
#endregion
#region Job_no
[PXDBString(20, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Job_no")]
public virtual string Job_no { get; set; }
public abstract class job_no : PX.Data.BQL.BqlString.Field<job_no> { }
#endregion
#region Mfg_loc
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Mfg_loc")]
public virtual string Mfg_loc { get; set; }
public abstract class mfg_loc : PX.Data.BQL.BqlString.Field<mfg_loc> { }
#endregion
#region Profit_center
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Profit_center")]
public virtual string Profit_center { get; set; }
public abstract class profit_center : PX.Data.BQL.BqlString.Field<profit_center> { }
#endregion
#region Dept
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Dept")]
public virtual string Dept { get; set; }
public abstract class dept : PX.Data.BQL.BqlString.Field<dept> { }
#endregion
#region Ar_reference
[PXDBString(45, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Ar_reference")]
public virtual string Ar_reference { get; set; }
public abstract class ar_reference : PX.Data.BQL.BqlString.Field<ar_reference> { }
#endregion
#region Tot_sls_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_sls_amt")]
public virtual Decimal? Tot_sls_amt { get; set; }
public abstract class tot_sls_amt : PX.Data.BQL.BqlDecimal.Field<tot_sls_amt> { }
#endregion
#region Tot_sls_disc
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_sls_disc")]
public virtual Decimal? Tot_sls_disc { get; set; }
public abstract class tot_sls_disc : PX.Data.BQL.BqlDecimal.Field<tot_sls_disc> { }
#endregion
#region Tot_tax_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_tax_amt")]
public virtual Decimal? Tot_tax_amt { get; set; }
public abstract class tot_tax_amt : PX.Data.BQL.BqlDecimal.Field<tot_tax_amt> { }
#endregion
#region Tot_cost
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_cost")]
public virtual Decimal? Tot_cost { get; set; }
public abstract class tot_cost : PX.Data.BQL.BqlDecimal.Field<tot_cost> { }
#endregion
#region Tot_weight
[PXDBDecimal()]
[PXUIField(DisplayName = "Tot_weight")]
public virtual Decimal? Tot_weight { get; set; }
public abstract class tot_weight : PX.Data.BQL.BqlDecimal.Field<tot_weight> { }
#endregion
#region Misc_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Misc_amt")]
public virtual Decimal? Misc_amt { get; set; }
public abstract class misc_amt : PX.Data.BQL.BqlDecimal.Field<misc_amt> { }
#endregion
#region Frt_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Frt_amt")]
public virtual Decimal? Frt_amt { get; set; }
public abstract class frt_amt : PX.Data.BQL.BqlDecimal.Field<frt_amt> { }
#endregion
#region Sls_tax_amt_1
[PXDBDecimal()]
[PXUIField(DisplayName = "Sls_tax_amt_1")]
public virtual Decimal? Sls_tax_amt_1 { get; set; }
public abstract class sls_tax_amt_1 : PX.Data.BQL.BqlDecimal.Field<sls_tax_amt_1> { }
#endregion
#region Sls_tax_amt_2
[PXDBDecimal()]
[PXUIField(DisplayName = "Sls_tax_amt_2")]
public virtual Decimal? Sls_tax_amt_2 { get; set; }
public abstract class sls_tax_amt_2 : PX.Data.BQL.BqlDecimal.Field<sls_tax_amt_2> { }
#endregion
#region Sls_tax_amt_3
[PXDBDecimal()]
[PXUIField(DisplayName = "Sls_tax_amt_3")]
public virtual Decimal? Sls_tax_amt_3 { get; set; }
public abstract class sls_tax_amt_3 : PX.Data.BQL.BqlDecimal.Field<sls_tax_amt_3> { }
#endregion
#region Comm_pct
[PXDBDecimal()]
[PXUIField(DisplayName = "Comm_pct")]
public virtual Decimal? Comm_pct { get; set; }
public abstract class comm_pct : PX.Data.BQL.BqlDecimal.Field<comm_pct> { }
#endregion
#region Comm_amt
[PXDBDecimal()]
[PXUIField(DisplayName = "Comm_amt")]
public virtual Decimal? Comm_amt { get; set; }
public abstract class comm_amt : PX.Data.BQL.BqlDecimal.Field<comm_amt> { }
#endregion
#region Cmt_1
[PXDBString(35, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cmt_1")]
public virtual string Cmt_1 { get; set; }
public abstract class cmt_1 : PX.Data.BQL.BqlString.Field<cmt_1> { }
#endregion
#region Cmt_2
[PXDBString(35, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cmt_2")]
public virtual string Cmt_2 { get; set; }
public abstract class cmt_2 : PX.Data.BQL.BqlString.Field<cmt_2> { }
#endregion
#region Cmt_3
[PXDBString(35, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Cmt_3")]
public virtual string Cmt_3 { get; set; }
public abstract class cmt_3 : PX.Data.BQL.BqlString.Field<cmt_3> { }
#endregion
#region Inv_no
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Inv_no")]
public virtual string Inv_no { get; set; }
public abstract class inv_no : PX.Data.BQL.BqlString.Field<inv_no> { }
#endregion
#region Inv_dt
[PXDBDate()]
[PXUIField(DisplayName = "Inv_dt")]
public virtual DateTime? Inv_dt { get; set; }
public abstract class inv_dt : PX.Data.BQL.BqlDateTime.Field<inv_dt> { }
#endregion
#region Lost_sale_cd
[PXDBString(3, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Lost_sale_cd")]
public virtual string Lost_sale_cd { get; set; }
public abstract class lost_sale_cd : PX.Data.BQL.BqlString.Field<lost_sale_cd> { }
#endregion
#region Orig_ord_type
[PXDBString(1, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Orig_ord_type")]
public virtual string Orig_ord_type { get; set; }
public abstract class orig_ord_type : PX.Data.BQL.BqlString.Field<orig_ord_type> { }
#endregion
#region Orig_ord_dt
[PXDBDate()]
[PXUIField(DisplayName = "Orig_ord_dt")]
public virtual DateTime? Orig_ord_dt { get; set; }
public abstract class orig_ord_dt : PX.Data.BQL.BqlDateTime.Field<orig_ord_dt> { }
#endregion
#region Orig_ord_no
[PXDBString(8, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Orig_ord_no")]
public virtual string Orig_ord_no { get; set; }
public abstract class orig_ord_no : PX.Data.BQL.BqlString.Field<orig_ord_no> { }
#endregion
#region User_def_fld_1
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_1")]
public virtual string User_def_fld_1 { get; set; }
public abstract class user_def_fld_1 : PX.Data.BQL.BqlString.Field<user_def_fld_1> { }
#endregion
#region User_def_fld_2
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_2")]
public virtual string User_def_fld_2 { get; set; }
public abstract class user_def_fld_2 : PX.Data.BQL.BqlString.Field<user_def_fld_2> { }
#endregion
#region User_def_fld_3
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_3")]
public virtual string User_def_fld_3 { get; set; }
public abstract class user_def_fld_3 : PX.Data.BQL.BqlString.Field<user_def_fld_3> { }
#endregion
#region User_def_fld_4
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_4")]
public virtual string User_def_fld_4 { get; set; }
public abstract class user_def_fld_4 : PX.Data.BQL.BqlString.Field<user_def_fld_4> { }
#endregion
#region User_def_fld_5
[PXDBString(30, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "User_def_fld_5")]
public virtual string User_def_fld_5 { get; set; }
public abstract class user_def_fld_5 : PX.Data.BQL.BqlString.Field<user_def_fld_5> { }
#endregion
#region Packing_no
[PXDBInt()]
[PXUIField(DisplayName = "Packing_no")]
public virtual int? Packing_no { get; set; }
public abstract class packing_no : PX.Data.BQL.BqlInt.Field<packing_no> { }
#endregion
#region CreatedDateTime
[PXDBCreatedDateTime()]
public virtual DateTime? CreatedDateTime { get; set; }
public abstract class createdDateTime : PX.Data.BQL.BqlDateTime.Field<createdDateTime> { }
#endregion
#region CreatedByID
[PXDBCreatedByID()]
public virtual Guid? CreatedByID { get; set; }
public abstract class createdByID : PX.Data.BQL.BqlGuid.Field<createdByID> { }
#endregion
#region CreatedByScreenID
[PXDBCreatedByScreenID()]
public virtual string CreatedByScreenID { get; set; }
public abstract class createdByScreenID : PX.Data.BQL.BqlString.Field<createdByScreenID> { }
#endregion
#region LastModifiedDateTime
[PXDBLastModifiedDateTime()]
public virtual DateTime? LastModifiedDateTime { get; set; }
public abstract class lastModifiedDateTime : PX.Data.BQL.BqlDateTime.Field<lastModifiedDateTime> { }
#endregion
#region LastModifiedByID
[PXDBLastModifiedByID()]
public virtual Guid? LastModifiedByID { get; set; }
public abstract class lastModifiedByID : PX.Data.BQL.BqlGuid.Field<lastModifiedByID> { }
#endregion
#region LastModifiedByScreenID
[PXDBLastModifiedByScreenID()]
public virtual string LastModifiedByScreenID { get; set; }
public abstract class lastModifiedByScreenID : PX.Data.BQL.BqlString.Field<lastModifiedByScreenID> { }
#endregion
#region Tstamp
[PXDBTimestamp()]
[PXUIField(DisplayName = "Tstamp")]
public virtual byte[] Tstamp { get; set; }
public abstract class tstamp : PX.Data.BQL.BqlByteArray.Field<tstamp> { }
#endregion
#region Noteid
[PXNote()]
public virtual Guid? Noteid { get; set; }
public abstract class noteid : PX.Data.BQL.BqlGuid.Field<noteid> { }
#endregion
}
}And the main graph tied to the screen:
using System;
using PX.Data;
using PX.Data.BQL.Fluent;
namespace MyCustomImport
{
public class OEHeaderMaint : PXGraph<OEHeaderMaint>
{
public PXSave<myTable> Save;
public PXCancel<myTable> Cancel;
public SelectFrom<myTable>.View OEHeaderView;
public PXFilter<myTable> MasterView;
public PXFilter<DetailsTable> DetailsView;
[Serializable]
public class MasterTable : IBqlTable
{
}
[Serializable]
public class DetailsTable : IBqlTable
{
}
}
}
The primary key of the SQL table is CompanyID (int), ord_type (nchar(1)), and ord_no (nchar(8)) and none of the other fields are required except for the system fields (created, last modified, tstamp, noteid, etc.)
Thanks in advance for any help!
