It's rather long so I attached it here.
On Thursday, September 13, 2012 12:07:05 PM UTC+2, Lukas Eder wrote:
>
> That is a different problem
> Does your generated LaborTicket class specify an identity column? Can
> you paste the generated Table class, please?
>
> 2012/9/13 Rick van Biljouw <[email protected] <javascript:>>:
> > Hi,
> >
> > I've updated all the JooQ libraries to version 2.5.0 and it's now
> impossible
> > for me to actually do anything with the POJO created.
> > Following exception is thrown when trying to store the created object:
> >>>
> >>> Caused by: org.jooq.exception.DataAccessException: SQL [insert into
> >>> [LABOR_TICKET] ([ROWID], [TRANSACTION_ID], [WORKORDER_TYPE],
> >>> [WORKORDER_BASE_ID], [WORKORDER_LOT_ID], [WORKORDER_SPLIT_ID],
> >>> [WORKORDER_SUB_ID], [OPERATION_SEQ_NO], [TYPE], [SETUP_COMPLETED],
> >>> [EMPLOYEE_ID], [DEPARTMENT_ID], [RESOURCE_ID], [HOURLY_COST],
> [CLOCK_IN],
> >>> [CLOCK_OUT], [HOURS_WORKED], [HOURS_BREAK], [MULTIPLIER_1],
> [MULTIPLIER_2],
> >>> [GOOD_QTY], [BAD_QTY], [TRANSACTION_DATE], [DESCRIPTION], [USER_ID],
> >>> [BURDEN_PER_HR], [BURDEN_PERCENT], [BUR_PER_OPERATION],
> [POSTING_CANDIDATE],
> >>> [HOURS_OVERALL], [HOURS_PREVIOUS], [INDIRECT_CODE], [INDIRECT_ID],
> >>> [SHIFT_DATE], [BREAK_CLOCKIN], [HOURS_BREAK_IND], [ACT_LABOR_COST],
> >>> [ACT_BURDEN_COST], [CREATE_DATE], [ACT_CLOCK_IN], [ACT_CLOCK_OUT],
> >>> [STARTING_TRANS], [BURDEN_PER_UNIT], [UNIT_COST], [GL_ACCT_ID],
> >>> [EARNING_CODE_ID], [BUDGET_ACCT_YEAR], [BUDGET_ACCT_PERIOD],
> >>> [MILESTONE_TXN_ID], [MILESTONE_UPDATED], [COST_CATEGORY_ID],
> >>> [AUTOGEN_TXN_ID], [UNADJ_CLOCK_IN], [UNADJ_CLOCK_OUT], [DEVIATION_ID],
> >>> [DATA_COLL_COMP], [PRD_INSP_PLAN_ID], [ACT_RATE_ID], [ACT_PERIOD_ID],
> >>> [RETRO_RATE_ID], [RETRO_PERIOD_ID], [RETRO_RATE_CODE]) values (?, ?,
> ?, ?,
> >>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?,
> >>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?,
> >>> ?, ?, ?, ?, ?, ?, ?, ?)]; Cannot insert explicit value for identity
> column
> >>> in table 'LABOR_TICKET' when IDENTITY_INSERT is set to OFF.
> >>>
> >>> at org.jooq.impl.Util.translate(Util.java:562) ~[jooq-2.5.0.jar:na]
> >>>
> >>> at
> >>>
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:360)
>
>
> >>> ~[jooq-2.5.0.jar:na]
> >>>
> >>> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:176)
> >>> ~[jooq-2.5.0.jar:na]
> >>>
> >>> at org.jooq.impl.TableRecordImpl.storeInsert(TableRecordImpl.java:184)
> >>> ~[jooq-2.5.0.jar:na]
> >>>
> >>> at org.jooq.impl.TableRecordImpl.storeUsing(TableRecordImpl.java:145)
> >>> ~[jooq-2.5.0.jar:na]
> >>>
> >>> at
> org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:76)
> >>> ~[jooq-2.5.0.jar:na]
> >>>
> >>> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot
> insert
> >>> explicit value for identity column in table 'LABOR_TICKET' when
> >>> IDENTITY_INSERT is set to OFF.
> >>>
> >>> at
> >>>
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
>
>
> >>> ~[sqljdbc.jar:na]
> >>>
> >>> at
> >>>
> com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
>
>
> >>> ~[sqljdbc.jar:na]
> >>>
> >>> at
> >>>
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
>
>
> >>> ~[sqljdbc.jar:na]
> >>>
> >>> at
> >>>
> com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
>
>
> >>> ~[sqljdbc.jar:na]
> >>>
> >>> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
> >>> ~[sqljdbc.jar:na]
> >>>
> >>> at
> >>>
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
>
>
> >>> ~[sqljdbc.jar:na]
> >>
> >>
> > Now I'm really lost..
> >
> > On Wednesday, September 12, 2012 6:13:04 PM UTC+2, Rick van Biljouw
> wrote:
> >>
> >> It would seem that the exception occurs because LaborTicketRecord
> defines
> >> a relation with EmployeeRecord on that particular employeeId, since its
> a
> >> foreign key. That doesn't explain why the type is wrongly converted
> though
> >> as it would seem to me that it should actually fetch the relationships
> from
> >> the database if that is what it does. Perhaps 2.5.0 deals with Records
> just
> >> a little differently and it only appears with this specific use-case?
> I'll
> >> give it a try using just 2.5.0 this evening.
>
/**
* This class is generated by jOOQ
*/
package com.abbaba.tables.records;
/**
* This class is generated by jOOQ.
*/
@javax.annotation.Generated(value = {"http://www.jooq.org";, "2.5.0"},
comments = "This class is generated by jOOQ")
public class LaborTicketRecord extends org.jooq.impl.UpdatableRecordImpl<com.abbaba.tables.records.LaborTicketRecord> {
private static final long serialVersionUID = -1198459545;
/**
* The table column <code>dbo.LABOR_TICKET.ROWID</code>
*/
public void setRowid(java.lang.Integer value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ROWID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ROWID</code>
*/
public java.lang.Integer getRowid() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ROWID);
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_ID</code>
* <p>
* This column is part of the table's PRIMARY KEY
*/
public void setTransactionId(java.lang.Integer value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_ID</code>
* <p>
* This column is part of the table's PRIMARY KEY
*/
public java.lang.Integer getTransactionId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_ID</code>
* <p>
* This column is part of the table's PRIMARY KEY
*/
public java.util.List<com.abbaba.tables.records.IndirectDetailRecord> fetchIndirectDetailList() {
return create()
.selectFrom(com.abbaba.tables.IndirectDetail.INDIRECT_DETAIL)
.where(com.abbaba.tables.IndirectDetail.INDIRECT_DETAIL.TRANSACTION_ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_ID)))
.fetch();
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_ID</code>
* <p>
* This column is part of the table's PRIMARY KEY
*/
public java.util.List<com.abbaba.tables.records.LaborTicketCurrRecord> fetchLaborTicketCurrList() {
return create()
.selectFrom(com.abbaba.tables.LaborTicketCurr.LABOR_TICKET_CURR)
.where(com.abbaba.tables.LaborTicketCurr.LABOR_TICKET_CURR.TRANSACTION_ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_ID)))
.fetch();
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_ID</code>
* <p>
* This column is part of the table's PRIMARY KEY
*/
public java.util.List<com.abbaba.tables.records.TraceLaborTransRecord> fetchTraceLaborTransList() {
return create()
.selectFrom(com.abbaba.tables.TraceLaborTrans.TRACE_LABOR_TRANS)
.where(com.abbaba.tables.TraceLaborTrans.TRACE_LABOR_TRANS.TRANSACTION_ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_ID)))
.fetch();
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_TYPE</code>
*/
public void setWorkorderType(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_TYPE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_TYPE</code>
*/
public java.lang.String getWorkorderType() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_TYPE);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_BASE_ID</code>
*/
public void setWorkorderBaseId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_BASE_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_BASE_ID</code>
*/
public java.lang.String getWorkorderBaseId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_BASE_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_LOT_ID</code>
*/
public void setWorkorderLotId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_LOT_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_LOT_ID</code>
*/
public java.lang.String getWorkorderLotId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_LOT_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_SPLIT_ID</code>
*/
public void setWorkorderSplitId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_SPLIT_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_SPLIT_ID</code>
*/
public java.lang.String getWorkorderSplitId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_SPLIT_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_SUB_ID</code>
*/
public void setWorkorderSubId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_SUB_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_SUB_ID</code>
*/
public java.lang.String getWorkorderSubId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.WORKORDER_SUB_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.OPERATION_SEQ_NO</code>
*/
public void setOperationSeqNo(java.lang.Short value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.OPERATION_SEQ_NO, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.OPERATION_SEQ_NO</code>
*/
public java.lang.Short getOperationSeqNo() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.OPERATION_SEQ_NO);
}
/**
* The table column <code>dbo.LABOR_TICKET.TYPE</code>
*/
public void setType(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TYPE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.TYPE</code>
*/
public java.lang.String getType() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TYPE);
}
/**
* The table column <code>dbo.LABOR_TICKET.SETUP_COMPLETED</code>
*/
public void setSetupCompleted(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.SETUP_COMPLETED, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.SETUP_COMPLETED</code>
*/
public java.lang.String getSetupCompleted() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.SETUP_COMPLETED);
}
/**
* The table column <code>dbo.LABOR_TICKET.EMPLOYEE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0086
* FOREIGN KEY (EMPLOYEE_ID)
* REFERENCES dbo.EMPLOYEE (ID)
* </pre></code>
*/
public void setEmployeeId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EMPLOYEE_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.EMPLOYEE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0086
* FOREIGN KEY (EMPLOYEE_ID)
* REFERENCES dbo.EMPLOYEE (ID)
* </pre></code>
*/
public java.lang.String getEmployeeId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EMPLOYEE_ID);
}
/**
* Link this record to a given {@link com.abbaba.tables.records.EmployeeRecord
* EmployeeRecord}
*/
public void setEmployeeId(com.abbaba.tables.records.EmployeeRecord value) {
if (value == null) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EMPLOYEE_ID, null);
}
else {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EMPLOYEE_ID, value.getValue(com.abbaba.tables.Employee.EMPLOYEE.ID));
}
}
/**
* The table column <code>dbo.LABOR_TICKET.EMPLOYEE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0086
* FOREIGN KEY (EMPLOYEE_ID)
* REFERENCES dbo.EMPLOYEE (ID)
* </pre></code>
*/
public com.abbaba.tables.records.EmployeeRecord fetchEmployee() {
return create()
.selectFrom(com.abbaba.tables.Employee.EMPLOYEE)
.where(com.abbaba.tables.Employee.EMPLOYEE.ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EMPLOYEE_ID)))
.fetchOne();
}
/**
* The table column <code>dbo.LABOR_TICKET.DEPARTMENT_ID</code>
*/
public void setDepartmentId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DEPARTMENT_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.DEPARTMENT_ID</code>
*/
public java.lang.String getDepartmentId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DEPARTMENT_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.RESOURCE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0129
* FOREIGN KEY (RESOURCE_ID)
* REFERENCES dbo.SHOP_RESOURCE (ID)
* </pre></code>
*/
public void setResourceId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RESOURCE_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.RESOURCE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0129
* FOREIGN KEY (RESOURCE_ID)
* REFERENCES dbo.SHOP_RESOURCE (ID)
* </pre></code>
*/
public java.lang.String getResourceId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RESOURCE_ID);
}
/**
* Link this record to a given {@link com.abbaba.tables.records.ShopResourceRecord
* ShopResourceRecord}
*/
public void setResourceId(com.abbaba.tables.records.ShopResourceRecord value) {
if (value == null) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RESOURCE_ID, null);
}
else {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RESOURCE_ID, value.getValue(com.abbaba.tables.ShopResource.SHOP_RESOURCE.ID));
}
}
/**
* The table column <code>dbo.LABOR_TICKET.RESOURCE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0129
* FOREIGN KEY (RESOURCE_ID)
* REFERENCES dbo.SHOP_RESOURCE (ID)
* </pre></code>
*/
public com.abbaba.tables.records.ShopResourceRecord fetchShopResource() {
return create()
.selectFrom(com.abbaba.tables.ShopResource.SHOP_RESOURCE)
.where(com.abbaba.tables.ShopResource.SHOP_RESOURCE.ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RESOURCE_ID)))
.fetchOne();
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURLY_COST</code>
*/
public void setHourlyCost(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURLY_COST, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURLY_COST</code>
*/
public java.math.BigDecimal getHourlyCost() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURLY_COST);
}
/**
* The table column <code>dbo.LABOR_TICKET.CLOCK_IN</code>
*/
public void setClockIn(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.CLOCK_IN, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.CLOCK_IN</code>
*/
public java.sql.Timestamp getClockIn() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.CLOCK_IN);
}
/**
* The table column <code>dbo.LABOR_TICKET.CLOCK_OUT</code>
*/
public void setClockOut(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.CLOCK_OUT, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.CLOCK_OUT</code>
*/
public java.sql.Timestamp getClockOut() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.CLOCK_OUT);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_WORKED</code>
*/
public void setHoursWorked(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_WORKED, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_WORKED</code>
*/
public java.math.BigDecimal getHoursWorked() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_WORKED);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_BREAK</code>
*/
public void setHoursBreak(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_BREAK, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_BREAK</code>
*/
public java.math.BigDecimal getHoursBreak() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_BREAK);
}
/**
* The table column <code>dbo.LABOR_TICKET.MULTIPLIER_1</code>
*/
public void setMultiplier_1(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MULTIPLIER_1, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.MULTIPLIER_1</code>
*/
public java.math.BigDecimal getMultiplier_1() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MULTIPLIER_1);
}
/**
* The table column <code>dbo.LABOR_TICKET.MULTIPLIER_2</code>
*/
public void setMultiplier_2(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MULTIPLIER_2, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.MULTIPLIER_2</code>
*/
public java.math.BigDecimal getMultiplier_2() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MULTIPLIER_2);
}
/**
* The table column <code>dbo.LABOR_TICKET.GOOD_QTY</code>
*/
public void setGoodQty(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.GOOD_QTY, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.GOOD_QTY</code>
*/
public java.math.BigDecimal getGoodQty() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.GOOD_QTY);
}
/**
* The table column <code>dbo.LABOR_TICKET.BAD_QTY</code>
*/
public void setBadQty(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BAD_QTY, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BAD_QTY</code>
*/
public java.math.BigDecimal getBadQty() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BAD_QTY);
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_DATE</code>
*/
public void setTransactionDate(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_DATE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_DATE</code>
*/
public java.sql.Timestamp getTransactionDate() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.TRANSACTION_DATE);
}
/**
* The table column <code>dbo.LABOR_TICKET.DESCRIPTION</code>
*/
public void setDescription(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DESCRIPTION, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.DESCRIPTION</code>
*/
public java.lang.String getDescription() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DESCRIPTION);
}
/**
* The table column <code>dbo.LABOR_TICKET.USER_ID</code>
*/
public void setUserId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.USER_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.USER_ID</code>
*/
public java.lang.String getUserId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.USER_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PER_HR</code>
*/
public void setBurdenPerHr(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BURDEN_PER_HR, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PER_HR</code>
*/
public java.math.BigDecimal getBurdenPerHr() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BURDEN_PER_HR);
}
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PERCENT</code>
*/
public void setBurdenPercent(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BURDEN_PERCENT, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PERCENT</code>
*/
public java.math.BigDecimal getBurdenPercent() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BURDEN_PERCENT);
}
/**
* The table column <code>dbo.LABOR_TICKET.BUR_PER_OPERATION</code>
*/
public void setBurPerOperation(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BUR_PER_OPERATION, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BUR_PER_OPERATION</code>
*/
public java.math.BigDecimal getBurPerOperation() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BUR_PER_OPERATION);
}
/**
* The table column <code>dbo.LABOR_TICKET.POSTING_CANDIDATE</code>
*/
public void setPostingCandidate(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.POSTING_CANDIDATE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.POSTING_CANDIDATE</code>
*/
public java.lang.String getPostingCandidate() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.POSTING_CANDIDATE);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_OVERALL</code>
*/
public void setHoursOverall(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_OVERALL, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_OVERALL</code>
*/
public java.math.BigDecimal getHoursOverall() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_OVERALL);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_PREVIOUS</code>
*/
public void setHoursPrevious(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_PREVIOUS, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_PREVIOUS</code>
*/
public java.math.BigDecimal getHoursPrevious() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_PREVIOUS);
}
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_CODE</code>
*/
public void setIndirectCode(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_CODE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_CODE</code>
*/
public java.lang.String getIndirectCode() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_CODE);
}
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0048
* FOREIGN KEY (INDIRECT_ID)
* REFERENCES dbo.INDIRECT (ID)
* </pre></code>
*/
public void setIndirectId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0048
* FOREIGN KEY (INDIRECT_ID)
* REFERENCES dbo.INDIRECT (ID)
* </pre></code>
*/
public java.lang.String getIndirectId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_ID);
}
/**
* Link this record to a given {@link com.abbaba.tables.records.IndirectRecord
* IndirectRecord}
*/
public void setIndirectId(com.abbaba.tables.records.IndirectRecord value) {
if (value == null) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_ID, null);
}
else {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_ID, value.getValue(com.abbaba.tables.Indirect.INDIRECT.ID));
}
}
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0048
* FOREIGN KEY (INDIRECT_ID)
* REFERENCES dbo.INDIRECT (ID)
* </pre></code>
*/
public com.abbaba.tables.records.IndirectRecord fetchIndirect() {
return create()
.selectFrom(com.abbaba.tables.Indirect.INDIRECT)
.where(com.abbaba.tables.Indirect.INDIRECT.ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.INDIRECT_ID)))
.fetchOne();
}
/**
* The table column <code>dbo.LABOR_TICKET.SHIFT_DATE</code>
*/
public void setShiftDate(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.SHIFT_DATE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.SHIFT_DATE</code>
*/
public java.sql.Timestamp getShiftDate() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.SHIFT_DATE);
}
/**
* The table column <code>dbo.LABOR_TICKET.BREAK_CLOCKIN</code>
*/
public void setBreakClockin(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BREAK_CLOCKIN, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BREAK_CLOCKIN</code>
*/
public java.sql.Timestamp getBreakClockin() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BREAK_CLOCKIN);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_BREAK_IND</code>
*/
public void setHoursBreakInd(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_BREAK_IND, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_BREAK_IND</code>
*/
public java.math.BigDecimal getHoursBreakInd() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.HOURS_BREAK_IND);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_LABOR_COST</code>
*/
public void setActLaborCost(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_LABOR_COST, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_LABOR_COST</code>
*/
public java.math.BigDecimal getActLaborCost() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_LABOR_COST);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_BURDEN_COST</code>
*/
public void setActBurdenCost(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_BURDEN_COST, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_BURDEN_COST</code>
*/
public java.math.BigDecimal getActBurdenCost() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_BURDEN_COST);
}
/**
* The table column <code>dbo.LABOR_TICKET.CREATE_DATE</code>
*/
public void setCreateDate(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.CREATE_DATE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.CREATE_DATE</code>
*/
public java.sql.Timestamp getCreateDate() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.CREATE_DATE);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_CLOCK_IN</code>
*/
public void setActClockIn(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_CLOCK_IN, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_CLOCK_IN</code>
*/
public java.sql.Timestamp getActClockIn() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_CLOCK_IN);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_CLOCK_OUT</code>
*/
public void setActClockOut(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_CLOCK_OUT, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_CLOCK_OUT</code>
*/
public java.sql.Timestamp getActClockOut() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_CLOCK_OUT);
}
/**
* The table column <code>dbo.LABOR_TICKET.STARTING_TRANS</code>
*/
public void setStartingTrans(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.STARTING_TRANS, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.STARTING_TRANS</code>
*/
public java.lang.String getStartingTrans() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.STARTING_TRANS);
}
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PER_UNIT</code>
*/
public void setBurdenPerUnit(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BURDEN_PER_UNIT, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PER_UNIT</code>
*/
public java.math.BigDecimal getBurdenPerUnit() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BURDEN_PER_UNIT);
}
/**
* The table column <code>dbo.LABOR_TICKET.UNIT_COST</code>
*/
public void setUnitCost(java.math.BigDecimal value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.UNIT_COST, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.UNIT_COST</code>
*/
public java.math.BigDecimal getUnitCost() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.UNIT_COST);
}
/**
* The table column <code>dbo.LABOR_TICKET.GL_ACCT_ID</code>
*/
public void setGlAcctId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.GL_ACCT_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.GL_ACCT_ID</code>
*/
public java.lang.String getGlAcctId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.GL_ACCT_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.EARNING_CODE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0051
* FOREIGN KEY (EARNING_CODE_ID)
* REFERENCES dbo.EARNING_CODE (ID)
* </pre></code>
*/
public void setEarningCodeId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EARNING_CODE_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.EARNING_CODE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0051
* FOREIGN KEY (EARNING_CODE_ID)
* REFERENCES dbo.EARNING_CODE (ID)
* </pre></code>
*/
public java.lang.String getEarningCodeId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EARNING_CODE_ID);
}
/**
* Link this record to a given {@link com.abbaba.tables.records.EarningCodeRecord
* EarningCodeRecord}
*/
public void setEarningCodeId(com.abbaba.tables.records.EarningCodeRecord value) {
if (value == null) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EARNING_CODE_ID, null);
}
else {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EARNING_CODE_ID, value.getValue(com.abbaba.tables.EarningCode.EARNING_CODE.ID));
}
}
/**
* The table column <code>dbo.LABOR_TICKET.EARNING_CODE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0051
* FOREIGN KEY (EARNING_CODE_ID)
* REFERENCES dbo.EARNING_CODE (ID)
* </pre></code>
*/
public com.abbaba.tables.records.EarningCodeRecord fetchEarningCode() {
return create()
.selectFrom(com.abbaba.tables.EarningCode.EARNING_CODE)
.where(com.abbaba.tables.EarningCode.EARNING_CODE.ID.equal(getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.EARNING_CODE_ID)))
.fetchOne();
}
/**
* The table column <code>dbo.LABOR_TICKET.BUDGET_ACCT_YEAR</code>
*/
public void setBudgetAcctYear(java.lang.Short value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BUDGET_ACCT_YEAR, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BUDGET_ACCT_YEAR</code>
*/
public java.lang.Short getBudgetAcctYear() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BUDGET_ACCT_YEAR);
}
/**
* The table column <code>dbo.LABOR_TICKET.BUDGET_ACCT_PERIOD</code>
*/
public void setBudgetAcctPeriod(java.lang.Byte value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BUDGET_ACCT_PERIOD, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.BUDGET_ACCT_PERIOD</code>
*/
public java.lang.Byte getBudgetAcctPeriod() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.BUDGET_ACCT_PERIOD);
}
/**
* The table column <code>dbo.LABOR_TICKET.MILESTONE_TXN_ID</code>
*/
public void setMilestoneTxnId(java.lang.Integer value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MILESTONE_TXN_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.MILESTONE_TXN_ID</code>
*/
public java.lang.Integer getMilestoneTxnId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MILESTONE_TXN_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.MILESTONE_UPDATED</code>
*/
public void setMilestoneUpdated(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MILESTONE_UPDATED, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.MILESTONE_UPDATED</code>
*/
public java.lang.String getMilestoneUpdated() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.MILESTONE_UPDATED);
}
/**
* The table column <code>dbo.LABOR_TICKET.COST_CATEGORY_ID</code>
*/
public void setCostCategoryId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.COST_CATEGORY_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.COST_CATEGORY_ID</code>
*/
public java.lang.String getCostCategoryId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.COST_CATEGORY_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.AUTOGEN_TXN_ID</code>
*/
public void setAutogenTxnId(java.lang.Integer value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.AUTOGEN_TXN_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.AUTOGEN_TXN_ID</code>
*/
public java.lang.Integer getAutogenTxnId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.AUTOGEN_TXN_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.UNADJ_CLOCK_IN</code>
*/
public void setUnadjClockIn(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.UNADJ_CLOCK_IN, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.UNADJ_CLOCK_IN</code>
*/
public java.sql.Timestamp getUnadjClockIn() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.UNADJ_CLOCK_IN);
}
/**
* The table column <code>dbo.LABOR_TICKET.UNADJ_CLOCK_OUT</code>
*/
public void setUnadjClockOut(java.sql.Timestamp value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.UNADJ_CLOCK_OUT, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.UNADJ_CLOCK_OUT</code>
*/
public java.sql.Timestamp getUnadjClockOut() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.UNADJ_CLOCK_OUT);
}
/**
* The table column <code>dbo.LABOR_TICKET.DEVIATION_ID</code>
*/
public void setDeviationId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DEVIATION_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.DEVIATION_ID</code>
*/
public java.lang.String getDeviationId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DEVIATION_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.DATA_COLL_COMP</code>
*/
public void setDataCollComp(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DATA_COLL_COMP, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.DATA_COLL_COMP</code>
*/
public java.lang.String getDataCollComp() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.DATA_COLL_COMP);
}
/**
* The table column <code>dbo.LABOR_TICKET.PRD_INSP_PLAN_ID</code>
*/
public void setPrdInspPlanId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.PRD_INSP_PLAN_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.PRD_INSP_PLAN_ID</code>
*/
public java.lang.String getPrdInspPlanId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.PRD_INSP_PLAN_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_RATE_ID</code>
*/
public void setActRateId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_RATE_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_RATE_ID</code>
*/
public java.lang.String getActRateId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_RATE_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_PERIOD_ID</code>
*/
public void setActPeriodId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_PERIOD_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.ACT_PERIOD_ID</code>
*/
public java.lang.String getActPeriodId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.ACT_PERIOD_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_RATE_ID</code>
*/
public void setRetroRateId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RETRO_RATE_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_RATE_ID</code>
*/
public java.lang.String getRetroRateId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RETRO_RATE_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_PERIOD_ID</code>
*/
public void setRetroPeriodId(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RETRO_PERIOD_ID, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_PERIOD_ID</code>
*/
public java.lang.String getRetroPeriodId() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RETRO_PERIOD_ID);
}
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_RATE_CODE</code>
*/
public void setRetroRateCode(java.lang.String value) {
setValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RETRO_RATE_CODE, value);
}
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_RATE_CODE</code>
*/
public java.lang.String getRetroRateCode() {
return getValue(com.abbaba.tables.LaborTicket.LABOR_TICKET.RETRO_RATE_CODE);
}
/**
* Create a detached LaborTicketRecord
*/
public LaborTicketRecord() {
super(com.abbaba.tables.LaborTicket.LABOR_TICKET);
}
}
