class routing_line(Base):
""" """
__tablename__ = 'RT010130'
__table_args__ = (ForeignKeyConstraint(
['ROUTINGNAME_I', 'ITEMNMBR'],
['RT010001.ROUTINGNAME_I', 'RT010001.ITEMNMBR']), {})
name = Column('ROUTINGNAME_I', StripString(31), primary_key=True)
item = Column('ITEMNMBR', StripString(31), primary_key=True)
routeseq = Column('RTSEQNUM_I', StripString(11), primary_key=True)
routedesc = Column('RTSEQDES_I', StripString(101), nullable=False)
wcid = Column('WCID_I', StripString(11), nullable=False)
noteidx = Column('NOTEINDX',
Numeric(19, 5),
nullable=False,
default=get_next_note_index)
def __init__(self, name, item, routeseq, routedesc, wcid, **kwargs):
self.name = name
self.item = item
self.routeseq = routeseq
self.routedesc = routedesc
self.wcid = wcid
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_Order_Activity(Base):
""" Manufacture Order Activity """
__tablename__ = 'MOP10213'
mo = Column('MANUFACTUREORDER_I',
StripString(31),
ForeignKey('WO010032.MANUFACTUREORDER_I'),
primary_key=True)
linenum = Column('LNSEQNBR', Numeric(19, 5), primary_key=True, default=1)
status = Column('MANUFACTUREORDERST_I', Integer, nullable=False, default=1)
activity = Column('MO_ACTIVITY_REASON_I',
Integer,
nullable=False,
default=47)
changeddate = Column('CHANGEDATE_I',
DateTime,
nullable=False,
default=gp_cur_date)
changedtime = Column('TIME_I',
DateTime,
nullable=False,
default=gp_cur_time)
uid = Column('USERID', StripString(15), nullable=False, default='sa')
picknum = Column('PICKNUMBER', StripString(17), nullable=False, default='')
doctype = Column('DOCTYPE', Integer, nullable=False, default=0)
def __init__(self, mo, **kwargs):
self.mo = mo
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_Lot_MSTR(Base):
""" Item Lot Number Master """
__tablename__ = 'IV00300'
item = Column('ITEMNMBR', StripString(31), ForeignKey('IV00101'), primary_key=True)
location = Column('LOCNCODE', StripString(11), primary_key=True)
received = Column('DATERECD', DateTime, primary_key=True, default=gp_cur_date)
dateseq = Column('DTSEQNUM', Integer, primary_key=True, autoincrement=False)
qtytype = Column('QTYTYPE', Integer, primary_key=True, autoincrement=False, default=1)
lot = Column('LOTNUMBR', StripString(21), nullable=False)
cost = Column('UNITCOST', Numeric(19,5), nullable=False)
qtyreceived = Column('QTYRECVD', Numeric(19,5), nullable=False)
qtyallocated = Column('ATYALLOC', Numeric(19,5), nullable=False, default=0)
qtysold = Column('QTYSOLD', Numeric(19,5), nullable=False, default=0)
def __init__(self, item, location, dateseq, lot, cost, qtyreceived, **kwargs):
self.item = item
self.location = location
self.dateseq = dateseq
self.lot = lot
self.cost = cost
self.qtyreceived = qtyreceived
for k, v in kwargs.items():
setattr(self, k, v)
pass
def _available(self):
return self.qtyreceived - (self.qtyallocated >= 0 and self.qtyallocated or 0) - self.qtysold
available = property(_available)
class IV_TRX_HIST_LINE_DTL(Base):
""" Inventory Transaction Detail History """
__tablename__ = 'IV30301'
doctype = Column('DOCTYPE', Integer, primary_key=True, autoincrement=False)
docnum = Column('DOCNUMBR', StripString(21), primary_key=True)
seq = Column('LNSEQNBR', Numeric(19,5), primary_key=True)
detailseq = Column('DTLSEQNM', Integer, primary_key=True, autoincrement=False)
qtytype = Column('QTYTYPE', Integer, nullable=False, default=1)
rctnum = Column('RCPTNMBR', StripString(21), nullable=False)
qty = Column('RCPTQTY', Numeric(19,5), nullable=False)
extcost = Column('RCPTEXCT', Numeric(19,5), nullable=False)
def __init__(self, doctype, docnum, seq, detailseq, rctnum, qty, extcost, **kwargs):
self.doctype = doctype
self.docnum = docnum
self.seq = seq
self.detailseq = detailseq
self.rctnum = rctnum
self.qty = qty
self.extcost = extcost
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_TRX_HIST_Batch(Base):
""" Inventory Transaction Batch History """
__tablename__ = 'IV30100'
trxsrc = Column('TRXSORCE', StripString(13), primary_key=True)
batchsrc = Column('BCHSOURC', StripString(15), nullable=False)
batch = Column('BACHNUMB', StripString(15), nullable=False)
batch_comment = Column('BCHCOMNT', StripString(61), nullable=False, default='')
batch_freq = Column('BACHFREQ', Integer, nullable=False, default=1)
posteddate = Column('POSTEDDT', DateTime, nullable=False)
hist_removed = Column('HISTRMVD', Integer, nullable=False)
batch_total = Column('BCHTOTAL', Numeric(19,5), nullable=False)
control_total = Column('CNTRLTOT', Numeric(19,5), nullable=False)
control_trx_count = Column('CNTRLTRX', Integer, nullable=False)
numtrans = Column('NUMOFTRX', Integer, nullable=False)
def __init__(self, trxsrc, batchsrc, batch, posteddate, hist_removed, batch_total, control_total, control_trx_count, numtrans, **kwargs):
self.trxsrc = trxsrc
self.batchsrc = batchsrc
self.batch = batch
self.posteddate = posteddate
self.hist_removed = hist_removed
self.batch_total = batch_total
self.control_total = control_total
self.control_trx_count = control_trx_count
self.numtrans = numtrans
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_PickDoc_MSTR(Base):
""" """
__tablename__ = 'MOP1200'
picknum = Column('PICKNUMBER', StripString(17), primary_key=True)
trxtype = Column('TRX_TYPE', Integer, nullable=False, default=1)
uid = Column('USERID', StripString(15), nullable=False, default='sa')
changedate = Column('CHANGEDATE_I',
DateTime,
nullable=False,
default=gp_cur_time)
docdate = Column('DOCDATE', DateTime, nullable=False, default=gp_cur_time)
posteddate = Column('POSTEDDT',
DateTime,
nullable=False,
default=gp_cur_date)
posted = Column('POSTED', Boolean, nullable=False, default=False)
def __init__(self, picknum, **kwargs):
self.picknum = picknum
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_Picklist_Site_QTYS(Base):
""" """
__tablename__ = 'MOP1400'
__table_args__ = (ForeignKeyConstraint(
['MANUFACTUREORDER_I', 'PICKLISTSEQ', 'LOCNCODE'],
['PK010033.MANUFACTUREORDER_I', 'PK010033.SEQ_I', 'PK010033.LOCNCODE'
]), {})
mo = Column('MANUFACTUREORDER_I', StripString(31), primary_key=True)
seq = Column('PICKLISTSEQ', Integer, primary_key=True, autoincrement=False)
location = Column('LOCNCODE', StripString(11), primary_key=True)
item = Column('ITEMNMBR', StripString(31), nullable=False)
qtyissued = Column('QTY_ISSUED_I',
Numeric(19, 5),
nullable=False,
default=0)
qtyallocated = Column('ATYALLOC',
Numeric(19, 5),
nullable=False,
default=0)
numscrapped = Column('NUMBERSCRAPPED_I',
Numeric(19, 5),
nullable=False,
default=0.0)
issuependingqty = Column('PENDING_ISSUE_QTY_I',
Numeric(19, 5),
nullable=False,
default=0.0)
revissuependingqty = Column('PENDING_REV_ISS_QTY_I',
Numeric(19, 5),
nullable=False,
default=0.0)
scrappendingqty = Column('PENDING_SCRAP_QTY_I',
Numeric(19, 5),
nullable=False,
default=0.0)
revscrappendingqty = Column('PENDING_REV_SCRAP_QTY_I',
Numeric(19, 5),
nullable=False,
default=0.0)
def __init__(self, mo, seq, location, item, **kwargs):
self.mo = mo
self.seq = seq
self.location = location
self.item = item
for k, v in kwargs.items():
setattr(self, k, v)
pass
class PM_Vendor_MSTR(Base):
""" PM Vendor Master File """
__tablename__ = 'PM00200'
vendid = Column('VENDORID', StripString(15), primary_key=True)
shipmethod = Column('SHIPMTHD', StripString(15), nullable=False)
def __init__(self, vendid, shipmethod, **kwargs):
self.vendid = vendid
self.shipmethod = shipmethod
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_Routing_Line(Base):
""" """
__tablename__ = 'WR010130'
mo = Column('MANUFACTUREORDER_I',
StripString(31),
ForeignKey('WO010032.MANUFACTUREORDER_I'),
primary_key=True)
routeseq = Column('RTSEQNUM_I', StripString(11), primary_key=True)
seqtype = Column('RTSEQTYPE_I', Integer, nullable=False, default=1)
startdate = Column('SCHEDULESTARTDATE_I',
DateTime,
nullable=False,
default=gp_cur_date)
finishdate = Column('SCHEDULEFINISHDATE_I',
DateTime,
nullable=False,
default=gp_cur_date)
wc = Column('WCID_I', StripString(11), nullable=False)
desc = Column('RTSEQDES_I', StripString(11), nullable=False)
uid = Column('USERID', StripString(15), nullable=False, default='sa')
createddate = Column('CREATDDT',
DateTime,
nullable=False,
default=gp_cur_date)
createdtime = Column('CREATETIME_I',
DateTime,
nullable=False,
default=gp_cur_time)
mostartqty = Column('WIPOPPERMOSTARTQTY',
Integer,
nullable=False,
default=1)
noteidx = Column('NOTEINDX',
Numeric(19, 5),
nullable=False,
default=get_next_note_index)
def __init__(self, mo, routeseq, wc, **kwargs):
self.mo = mo
self.routeseq = routeseq
self.wc = wc
self.desc = self.wc
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_Order_MSTR(Base):
""" Manufacture Order Master """
__tablename__ = 'WO010032'
mo = Column('MANUFACTUREORDER_I', StripString(31), primary_key=True)
desc = Column('DSCRIPTN', StripString(31), nullable=False, default='')
status = Column('MANUFACTUREORDERST_I', Integer, nullable=False, default=1)
fgitem = Column('ITEMNMBR', StripString(31), nullable=False, default='')
routing = Column('ROUTINGNAME_I',
StripString(31),
nullable=False,
default='')
endqty = Column('ENDQTY_I', Numeric(19, 5), nullable=False, default=1)
startqty = Column('STARTQTY_I', Numeric(19, 5), nullable=False, default=1)
startdate = Column('STRTDATE',
DateTime,
nullable=False,
default=gp_cur_date)
starttime = Column('STARTTIME_I',
DateTime,
nullable=False,
default=gp_cur_time)
enddate = Column('ENDDATE', DateTime, nullable=False, default=gp_cur_time)
fromsite = Column('DRAWFROMSITE_I',
StripString(11),
nullable=False,
default='PCSF')
uid = Column('USERID', StripString(15), nullable=False, default='sa')
schedmethod = Column('SCHEDULEMETHOD_I',
Integer,
nullable=False,
default=1)
schedpref = Column('SCHEDULINGPREFEREN_I',
StripString(21),
nullable=False,
default='DEFAULT')
tosite = Column('POSTTOSITE_I',
StripString(11),
nullable=False,
default='PCSF')
priority = Column('MANUFACTUREORDPRI_I',
Integer,
nullable=False,
default=2)
outsourced = Column('OUTSOURCED_I', Integer, nullable=False, default=1)
bomcat = Column('BOMCAT_I', Integer, nullable=False, default=1)
noteidx = Column('NOTEINDX',
Numeric(19, 5),
nullable=False,
default=get_next_note_index)
def __init__(self, mo, **kwargs):
self.mo = mo
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_Location_SETP(Base):
""" Site Setup """
__tablename__ = 'IV40700'
location = Column('LOCNCODE', StripString(11), primary_key=True)
desc = Column('LOCNDSCR', StripString(31), nullable=False)
noteidx = Column('NOTEINDX', Numeric(19,5), nullable=False, default=get_next_note_index)
def __init__(self, location, desc, **kwargs):
self.location = location
self.desc = desc
for k, v in kwargs.items():
setattr(self, k, v)
pass
class POP_ReceiptHist(Base):
""" Purchasing Receipt History """
__tablename__ = 'POP30300'
rctnum = Column('POPRCTNM', StripString(17), primary_key=True)
receiptdate = Column('receiptdate', DateTime, nullable=False)
batchnum = Column('BACHNUMB', StripString(15), nullable=False)
vendid = Column('VENDORID', StripString(15), nullable=False)
vendname = Column('VENDNAME', StripString(65), nullable=False)
venddocnum = Column('VNDDOCNM', StripString(21), nullable=False)
created = Column('CREATDDT', DateTime, nullable=False, default=gp_cur_date)
modified = Column('MODIFDT', DateTime, nullable=False, default=gp_cur_date)
currency = Column('CURNCYID',
StripString(15),
nullable=False,
default=get_currency)
shipmethod = Column('SHIPMTHD', StripString(15), nullable=False)
def __init__(self, rctnum, receiptdate, batchnum, vendid, vendname,
venddocnum, **kwargs):
self.rctnum = rctnum
self.receiptdate = receiptdate
self.batchnum = batchnum
self.vendid = vendid
self.vendname = vendname
self.venddocnum = venddocnum
self.shipmethod = get_vendor_ship_method(self.vendid)
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_UofM_SETP_HDR(Base):
""" Inventory U of M Schedule Setup """
__tablename__ = 'IV40201'
schedule = Column('UOMSCHDL', StripString(11), primary_key=True)
desc = Column('UMSCHDSC', StripString(31), nullable=False)
noteidx = Column('NOTEINDX', Numeric(19,5), nullable=False, default=get_next_note_index)
uom = Column('BASEUOFM', StripString(9), nullable=False)
dec_places_qtys = Column('UMDPQTYS', Integer, nullable=False, default=1)
def __init__(self, schedule, desc, uom, **kwargs):
self.schedule = schedule
self.desc = desc
self.uom = uom
for k, v in kwargs.items():
setattr(self, k, v)
pass
class WC_HDR(Base):
""" Work Center Header File """
__tablename__ = 'WC010931'
wc = Column('WCID_I',
StripString(11),
ForeignKey('WC010015.WCID_I'),
primary_key=True)
desc = Column('WCDESC_I', StripString(31), nullable=False)
outsourced = Column('OUTSOURCED_I', Integer, nullable=False, default=1)
def __init__(self, wc, **kwargs):
self.wc = wc
self.desc = wc
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_Item_MSTR_QTYS(Base):
""" Item Quantity Master """
__tablename__ = 'IV00102'
item = Column('ITEMNMBR', StripString(31), ForeignKey('IV00101'), primary_key=True)
location = Column('LOCNCODE', StripString(11), primary_key=True)
recordtype = Column('RCRDTYPE', Integer, primary_key=True, autoincrement=False, default=2)
bin = Column('BINNMBR', StripString(21), nullable=False, default='')
qtyonhand = Column('QTYONHND', Numeric(19,5), nullable=False, default=0)
qtyallocated = Column('ATYALLOC', Numeric(19,5), nullable=False, default=0)
qtysold = Column('QTYSOLD', Numeric(19,5), nullable=False, default=0)
landed_cost_id = Column('Landed_Cost_Group_ID', StripString(15), nullable=False, default='')
orderpolicy = Column('ORDERPOLICY', Integer, nullable=False, default=1)
numdays = Column('NMBROFDYS', Integer, nullable=False, default=1)
ordermultiple = Column('ORDERMULTIPLE', Numeric(19,5), nullable=False, default=1.0)
replenishmethod = Column('REPLENISHMENTMETHOD', Integer, nullable=False, default=3)
includeplanning = Column('INCLDDINPLNNNG', Integer, nullable=False, default=1)
forcast_consumption_period = Column('FRCSTCNSMPTNPRD', Integer, nullable=False, default=3)
replenishlevel = Column('ReplenishmentLevel', Integer, nullable=False, default=1)
ordermethod = Column('POPOrderMethod', Integer, nullable=False, default=1)
vendorselection = Column('POPVendorSelection', Integer, nullable=False, default=1)
pricingselection = Column('POPPricingSelection', Integer, nullable=False, default=1)
includeallocations = Column('IncludeAllocations', Integer, nullable=False, default=1)
includebackorders = Column('IncludeBackorders', Integer, nullable=False, default=1)
includerequisitions = Column('IncludeRequisitions', Integer, nullable=False, default=1)
pick_ticket_option = Column('PICKTICKETITEMOPT', Integer, nullable=False, default=3)
mrpmovein = Column('INCLDMRPMOVEIN', Integer, nullable=False, default=1)
mrpmoveout = Column('INCLDMRPMOVEOUT', Integer, nullable=False, default=1)
mrpcancel = Column('INCLDMRPCANCEL', Integer, nullable=False, default=1)
def __init__(self, item, location, **kwargs):
self.item = item
self.location = location
for k, v in kwargs.items():
setattr(self, k, v)
pass
def _available(self):
return self.qtyonhand - (self.qtyallocated >= 0 and self.qtyallocated or 0) - self.qtysold
available = property(_available)
class IV_Lot_Attribute(Base):
""" Item Lot Attribute Master """
__tablename__ = 'IV00301'
item = Column('ITEMNMBR', StripString(31), primary_key=True)
lot = Column('LOTNUMBR', StripString(21), primary_key=True)
attr1 = Column('LOTATRB1', StripString(11), nullable=False, default='')
attr2 = Column('LOTATRB2', StripString(11), nullable=False, default='')
attr3 = Column('LOTATRB3', StripString(11), nullable=False, default='')
attr4 = Column('LOTATRB4', DateTime, nullable=False, default=gp_epoch_start)
attr5 = Column('LOTATRB5', DateTime, nullable=False, default=gp_epoch_start)
def __init__(self, item, lot, **kwargs):
self.item = item
self.lot = lot
for k, v in kwargs.items():
setattr(self, k, v)
pass
class routing_mstr(Base):
""" """
__tablename__ = 'RT010001'
item = Column('ITEMNMBR', StripString(31), primary_key=True)
name = Column('ROUTINGNAME_I', StripString(31), primary_key=True)
routeprimary = Column('RTPRIMARY_I', Integer, nullable=False, default=1)
routestatus = Column('RTSTATUSDDL_I', Integer, nullable=False, default=4)
noteidx = Column('NOTeINDX',
Numeric(19, 5),
nullable=False,
default=get_next_note_index)
def __init__(self, item, name, **kwargs):
self.item = item
self.name = name
for k, v in kwargs.items():
setattr(self, k, v)
pass
class SOP_LINE_WORK(Base):
""" Sales Transaction Amounts Work """
__tablename__ = 'SOP10200'
soptype = Column('SOPTYPE', Integer, primary_key=True, default=1)
sopnum = Column('SOPNUMBE', StripString(21), primary_key=True)
lineitemseq = Column('LNITMSEQ', Integer, primary_key=True, default=Ordinal(0))
componentseq = Column('CMPNTSEQ', Integer, primary_key=True, default=0)
item = Column('ITEMNMBR', StripString(31), ForeignKey('IV00101.ITEMNMBR'), nullable=False)
location = Column('LOCNCODE', StripString(11), nullable=False, default='PCSF')
qty = Column('QUANTITY', Numeric(19,5), nullable=False, default=0)
qtyallocated = Column('ATYALLOC', Numeric(19,5), nullable=False, default=0)
def __init__(self, sopnum, item, **kwargs):
self.sopnum = sopnum
self.item = item
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MC_SETP(Base):
""" Multicurrency Setup """
__tablename__ = 'MC40000'
currency = Column('FUNLCURR', StripString(15), primary_key=True)
def __init__(self, currency, **kwargs):
self.currency = currency
for k, v in kwargs.items():
setattr(self, k, v)
pass
class BOM_Revision(Base):
""" """
__tablename__ = 'BM010415'
item = Column('ITEMNMBR', StripString(31), primary_key=True)
cat = Column('BOMCAT_I',
Integer,
primary_key=True,
autoincrement=False,
default=1)
name = Column('BOMNAME_I', StripString(15), primary_key=True, default='')
revlevel = Column('REVISIONLEVEL_I',
StripString(51),
nullable=False,
default='1')
backflush = Column('BACKFLUSHITEM_I', Integer, nullable=False, default=0)
type = Column('BOMTYPE_I', Integer, nullable=False, default=1)
phantominventory = Column('Net_Phanton_Inventory',
Integer,
nullable=False,
default=0)
changed = Column('CHANGEDATE_I', DateTime, nullable=False)
changedby = Column('CHANGEBY_I',
StripString(15),
nullable=False,
default='sa')
noteidx = Column('MFGNOTEINDEX3_I',
Numeric(19, 5),
nullable=False,
default=Decimal(0))
def __init__(self, item, changed, **kwargs):
self.item = item
self.changed = changed
for k, v in kwargs.items():
setattr(self, k, v)
pass
class SOP_Serial_Lot_WORK_HIST(Base):
""" Sales Serial/Lot Work and History """
__tablename__ = 'SOP10201'
__table_args__ = (ForeignKeyConstraint(['SOPTYPE',
'SOPNUMBE',
'LNITMSEQ',
'CMPNTSEQ',
'ITEMNMBR'],
['SOP10200.SOPTYPE',
'SOP10200.SOPNUMBE',
'SOP10200.LNITMSEQ',
'SOP10200.CMPNTSEQ',
'SOP10200.ITEMNMBR']), {})
soptype = Column('SOPTYPE', Integer, primary_key=True, default=1)
sopnum = Column('SOPNUMBE', StripString(21), primary_key=True)
lineitemseq = Column('LNITMSEQ', Integer, primary_key=True, default=Ordinal(0))
componentseq = Column('CMPNTSEQ', Integer, primary_key=True, default=0)
qtytype = Column('QTYTYPE', Integer, primary_key=True, default=1)
lotseq = Column('SLTSQNUM', Integer, primary_key=True, default=Ordinal(0))
received = Column('DATERECD', DateTime, primary_key=True, default=gp_cur_date)
dateseq = Column('DTSEQNUM', Integer, primary_key=True, autoincrement=False, default=Decimal(1))
lot = Column('SERLTNUM', StripString(21), nullable=False)
qty = Column('SERLTQTY', Numeric(19,5), nullable=False, default=0)
item = Column('ITEMNMBR', StripString(31), ForeignKey('IV00101.ITEMNMBR'), nullable=False)
posted = Column('POSTED', Integer, nullable=False, default=0)
def __init__(self, sopnum, item, lot, **kwargs):
self.sopnum = sopnum
self.item = item
self.lot = lot
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_TRX_HIST_HDR(Base):
""" Inventory Transaction History """
__tablename__ = 'IV30200'
__table_args__ = (ForeignKeyConstraint(['IVDOCTYP',
'DOCNUMBR',
'SRCRFRNCNMBR',],
['WO010302.IVDOCTYP',
'WO010302.IVDOCNBR',
'WO010302.MANUFACTUREORDER_I']), {})
trxsrc = Column('TRXSORCE', StripString(13), primary_key=True)
doctype = Column('IVDOCTYP', Integer, primary_key=True, autoincrement=False, default=1)
docnum = Column('DOCNUMBR', StripString(21), primary_key=True)
docdate = Column('DOCDATE', DateTime, nullable=False)
batchsrc = Column('BCHSOURC', StripString(15), nullable=False)
batchnum = Column('BACHNUMB', StripString(15), nullable=False)
noteidx = Column('NOTEINDX', Numeric(19,5), nullable=False, default=get_next_note_index)
gl_post_date = Column('GLPOSTDT', DateTime, nullable=False)
source_ref = Column('SRCRFRNCNMBR', StripString(31), nullable=False)
source_indicator = Column('SOURCEINDICATOR', Integer, nullable=False)
def __init__(self, trxsrc, docnum, docdate, batchsrc, batchnum, gl_post_date, source_ref, source_indicator, **kwargs):
self.trxsrc = trxsrc
self.docnum = docnum
self.docdate = docdate
self.batchsrc = batchsrc
self.batchnum = batchnum
self.gl_post_date = gl_post_date
self.source_ref = source_ref
self.source_indicator = source_indicator
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_Picklist_Seq_MSTR(Base):
""" Picklist Sequence Master """
__tablename__ = 'PK01200'
mo = Column('MANUFACTUREORDER_I',
StripString(31),
ForeignKey('WO010032.MANUFACTUREORDER_I'),
primary_key=True)
pciklistseq = Column('PICKLISTSEQ', Integer, nullable=False, default=1)
def __init__(self, mo, **kwargs):
self.mo = mo
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_Item_ENG(Base):
""" Item Engineering File """
__tablename__ = 'IVR10015'
item = Column('ITEMNMBT', StripString(32), primary_key=True)
status = Column('ITEMSTATUS_I', Integer, nullable=False, default=1)
makebuycode = Column('MAKEBUYCODE_I', Integer, nullable=False, default=1)
effective_date = Column('EFFECTIVEDATE_I', DateTime, nullable=False)
def __init__(self, item, **kwargs):
self.item = item
self.effective_date = datetime.now().date()
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_PickDoc_Line(Base):
""" """
__tablename__ = 'MOP1210'
picknum = Column('PICKNUMBER', StripString(17), primary_key=True)
linenum = Column('PICKDOCLINENUM',
Integer,
primary_key=True,
autoincrement=False)
mo = Column('MANUFACTUREORDER_I', StripString(31), nullable=False)
posnum = Column('POSITION_NUMBER', Integer, nullable=False)
item = Column('ITEMNMBR', StripString(31), nullable=False)
picklistseq = Column('PICKLISTSEQ', Integer, nullable=False)
pickqty = Column('TRXQTY', Numeric(19, 5), nullable=False)
uom = Column('UOFM', StripString(9), nullable=False)
tosite = Column('TO_SITE_I', StripString(11), nullable=False)
location = Column('FROM_SITE_I',
StripString(11),
nullable=False,
default='PCSF')
uomqty = Column('QTYBSUOM', Numeric(19, 5), nullable=False, default=1)
item_tracking = Column('ITMTRKOP', Integer, nullable=False, default=3)
qtyallocated = Column('ATYALLOC', Numeric(19, 5), nullable=False)
qtyselected = Column('QTYSLCTD', Numeric(19, 5), nullable=False)
qtyissued = Column('QTY_ISSUED_I', Numeric(19, 5), nullable=False)
mrpamt = Column('MRPAMOUNT_I', Numeric(19, 5), nullable=False)
reqdate = Column('REQDATE', DateTime, nullable=False, default=gp_cur_date)
pickdate = Column('DATEPICKED',
DateTime,
nullable=False,
default=gp_cur_date)
trxtype = Column('TRX_TYPE', Integer, nullable=False, default=1)
def __init__(self, picknum, linenum, mo, posnum, item, picklistseq,
pickqty, uom, tosite, qtyallocated, **kwargs):
self.picknum = picknum
self.linenum = linenum
self.mo = mo
self.posnum = posnum
self.item = item
self.picklistseq = picklistseq
self.pickqty = pickqty
self.uom = uom
self.tosite = tosite
self.qtyallocated = qtyallocated
self.qtyselected = self.qtyallocated
self.qtyissued = self.qtyallocated
self.mrpamt = self.qtyallocated
for k, v in kwargs.items():
setattr(self, k, v)
pass
class WC_MSTR(Base):
""" Work Center Master File """
__tablename__ = 'WC010015'
wc = Column('WCID_I', StripString(11), primary_key=True)
effective_date = Column('EFFECTIVEDATE_I',
DateTime,
primary_key=True,
default=gp_cur_date)
noteidx = Column('NOTEINDX',
Numeric(19, 5),
nullable=False,
default=get_next_note_index)
def __init__(self, wc, **kwargs):
self.wc = wc
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_TRX_HIST_Serial_Lot(Base):
""" Item Serial and Lot Number History """
__tablename__ = 'IV30400'
__table_args__ = (ForeignKeyConstraint(['TRXSORCE',
'IVDOCTYP',
'DOCNUMBR',
'LNSEQNBR',],
['IV30300.TRXSORCE',
'IV30300.DOCTYPE',
'IV30300.DOCNUMBR',
'IV30300.LNSEQNBR']), {})
trxsrc = Column('TRXSORCE', StripString(13), primary_key=True)
doctype = Column('IVDOCTYP', Integer, primary_key=True, autoincrement=False, default=1)
docnum = Column('DOCNUMBR', StripString(21), primary_key=True)
seq = Column('LNSEQNBR', Numeric(19,5), primary_key=True)
lotseq = Column('SLTSQNUM', Integer, primary_key=True, autoincrement=False)
lot = Column('SERLTNUM', StripString(21), nullable=False)
qty = Column('SERLTQTY', Numeric(19,5), nullable=False)
from_bin = Column('FROMBIN', StripString(15), nullable=False)
to_bin = Column('TOBIN', StripString(15), nullable=False)
item = Column('ITEMNMBR', StripString(31), nullable=False)
mfgdate = Column('MFGDATE', DateTime, nullable=False)
expiration = Column('EXPNDATE', DateTime, nullable=False)
def __init__(self, trxsrc, docnum, seq, lotseq, lot, qty, from_bin, to_bin, item, mfgdate, expiration, **kwargs):
self.trxsrc = trxsrc
self.docnum = docnum
self.seq = seq
self.lotseq = lotseq
self.lot = lot
self.qty = qty
self.from_bin = from_bin
self.to_bin = to_bin
self.item = item
self.mfgdate = mfgdate
self.expiration = expiration
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_Item_MSTR(Base):
""" Item Master """
__tablename__ = 'IV00101'
item = Column('ITEMNMBR', StripString(31), primary_key=True)
itemdesc = Column('ITEMDESC', StripString(101), nullable=False)
shortname = Column('ITMSHNAM', StripString(15), nullable=False)
itemtype = Column('ITEMTYPE', Integer, nullable=False, default=1)
stdcost = Column('STNDCOST', Numeric(19,5), nullable=False)
curcost = Column('CURRCOST', Numeric(19,5), nullable=False)
dec_places_qtys = Column('DECPLQTY', Integer, nullable=False, default=1)
dec_places_curr = Column('DECPLCUR', Integer, nullable=False, default=3)
itemtracking = Column('ITMTRKOP', Integer, nullable=False, default=3)
itemclass = Column('ITMCLSCD', StripString(11), nullable=False, default='MAIN')
uofmschedule = Column('UOMSCHDL', StripString(11), nullable=False, default='EACH')
alternate1 = Column('ALTITEM1', StripString(31), nullable=False, default='')
alternate2 = Column('ALTITEM2', StripString(31), nullable=False, default='')
usercategory1 = Column('USCATVLS_1', StripString(11), nullable=False, default='')
usercategory2 = Column('USCATVLS_2', StripString(11), nullable=False, default='')
usercategory3 = Column('USCATVLS_3', StripString(11), nullable=False, default='')
usercategory4 = Column('USCATVLS_4', StripString(11), nullable=False, default='')
usercategory5 = Column('USCATVLS_5', StripString(11), nullable=False, default='')
usercategory6 = Column('USCATVLS_6', StripString(11), nullable=False, default='')
location = Column('LOCNCODE', StripString(11), nullable=False)
invactindx = Column('IVIVINDX', Integer, nullable=False, default=147)
def __init__(self, item, itemdesc, shortname, stdcost, location, **kwargs):
self.item = item
self.itemdesc = itemdesc
self.shortname = shortname
self.stdcost = stdcost
self.curcost = self.stdcost
self.location = location
for k, v in kwargs.items():
setattr(self, k, v)
pass
class IV_TRX_HIST_LINE(Base):
""" Inventory Transaction Amounts History """
__tablename__ = 'IV30300'
__table_args__ = (ForeignKeyConstraint(['TRXSORCE',
'DOCTYPE',
'DOCNUMBR'],
['IV30200.TRXSORCE',
'IV30200.IVDOCTYP',
'IV30200.DOCNUMBR']),
ForeignKeyConstraint(['DOCNUMBR',
'DOCTYPE',
'LNSEQNBR',
'ITEMNMBR'],
['WO010302.IVDOCNBR',
'WO010302.IVDOCTYP',
'WO010302.LNSEQNBR',
'WO010302.ITEMNMBR']), {})
trxsrc = Column('TRXSORCE', StripString(13), nullable=False)
doctype = Column('DOCTYPE', Integer, primary_key=True, autoincrement=False)
docnum = Column('DOCNUMBR', StripString(21), primary_key=True)
seq = Column('LNSEQNBR', Numeric(19,5), primary_key=True)
docdate = Column('DOCDATE', DateTime, nullable=False)
hist_module = Column('HSTMODUL', StripString(3), nullable=False)
customer = Column('CUSTNMBR', StripString(15), nullable=False)
item = Column('ITEMNMBR', StripString(31), nullable=False)
uom = Column('UOFM', StripString(19), nullable=False)
trxqty = Column('TRXQTY', Numeric(19,5), nullable=False)
unitcost = Column('UNITCOST', Numeric(19,5), nullable=False)
extcost = Column('EXTDCOST', Numeric(19,5), nullable=False)
trxlocation = Column('TRXLOCTN', StripString(11), nullable=False)
trx_to_location = Column('TRNSTLOC', StripString(11), nullable=False)
trx_from_qty_type = Column('TRFQTYTY', Integer, nullable=False, default=1)
trx_to_qty_type = Column('TRTQTYTY', Integer, nullable=False, default=3)
invidx = Column('IVIVINDX', Integer, nullable=False)
invoffset = Column('IVIVOFIX', Integer, nullable=False)
dec_places_curr = Column('DECPLCUR', Integer, nullable=False, default=3)
dec_places_qtys = Column('DECPLQTY', Integer, nullable=False, default=1)
qtybsuom = Column('QTYBSUOM', Numeric(19,5), nullable=False)
def __init__(self, trxsrc, doctype, docnum, seq, docdate, hist_module, customer, item, uom, trxqty, unitcost, extcost, trxlocation, trx_to_location, invidx, invoffset, qtybsuom, **kwargs):
self.trxsrc = trxsrc
self.doctype = doctype
self.docnum = docnum
self.seq = seq
self.docdate = docdate
self.hist_module = hist_module
self.customer = customer
self.item = item
self.uom = uom
self.trxqty = trxqty
self.unitcost = unitcost
self.extcost = extcost
self.trxlocation = trxlocation
self.trx_to_location = trx_to_location
self.invidx = invidx
self.invoffset = invoffset
self.qtybsuom = qtybsuom
for k, v in kwargs.items():
setattr(self, k, v)
pass
class MOP_Item_MSTR(Base):
""" Picklist File """
__tablename__ = 'PK010033'
mo = Column('MANUFACTUREORDER_I',
StripString(31),
ForeignKey('WO010032.MANUFACTUREORDER_I'),
primary_key=True)
seq = Column('SEQ_I', Integer, primary_key=True, autoincrement=False)
fgitem = Column('PPN_I', StripString(31), primary_key=True, default='')
item = Column('ITEMNMBR',
StripString(31),
ForeignKey('IV00101.ITEMNMBR'),
primary_key=True)
status = Column('MANUFACTUREORDERST_I', Integer, nullable=False, default=1)
posnum = Column('POSITION_NUMBER', Integer, nullable=False, default=0)
routing = Column('ROUTINGNAME_I', StripString(31), nullable=False)
mrpamt = Column('MRPAMOUNT_I', Numeric(19, 5), nullable=False)
reqqty = Column('SUGGESTEDQTY_I', Numeric(19, 5), nullable=False)
qtyissued = Column('QTY_ISSUED_I',
Numeric(19, 5),
nullable=False,
default=Decimal(0))
qtyallocated = Column('ATYALLOC',
Numeric(19, 5),
nullable=False,
default=Decimal(0))
wc = Column('WCID_I', StripString(11), nullable=False)
routeseq = Column('RTSEQNUM_I', StripString(11), nullable=False)
location = Column('LOCNCODE',
StripString(11),
nullable=False,
default='PCSF')
changedate = Column('CHANGEDATE_I',
DateTime,
nullable=False,
default=gp_cur_date)
uid = Column('USERID', StripString(15), nullable=False, default='sa')
qtyallowed = Column('QTY_ALLOWED_I', Numeric(19, 5), nullable=False)
reqdate = Column('REQDATE', DateTime, nullable=False, default=gp_cur_date)
uom = Column('UOFM', StripString(9), nullable=False, default='Each')
qtybsuom = Column('QTYBSUOM', Numeric(19, 5), nullable=False, default=1)
bomseq = Column('BOMSEQ_I', Integer, nullable=False)
bomcat = Column('BOMCAT_I', Integer, nullable=False, default=1)
posnum2 = Column('POSITION_NUMBER2', Integer, nullable=False)
isallocated = Column('ALLOCATED_I', Integer, nullable=False, default=0)
allocateuid = Column('ALLOCATEUID_I',
StripString(15),
nullable=False,
default='sa')
allocatedate = Column('ALLOCATEDATEI',
DateTime,
nullable=False,
default=gp_cur_date)
allocatetime = Column('ALLOCATETIMEI',
DateTime,
nullable=False,
default=gp_cur_time)
def __init__(self, mo, seq, item, routing, reqqty, wc, routeseq, **kwargs):
self.mo = mo
self.seq = seq
self.item = item
self.routing = routing
self.mrpamt = self.reqqty
self.reqqty = reqqty
self.wc = wc
self.routeseq = routeseq
self.qtyallowed = self.reqqty
self.bomseq = self.seq
self.posnum2 = self.seq
for k, v in kwargs.items():
setattr(self, k, v)
pass