Class PM_TransactionDetail_bus

Properties

LOCAL cMainTable$="PM_TransactionDetail"  

[string] Table name being maintained by this business object.

LOCAL cIsSysDB=isFALSE  

[boolean] Flag to indicate whether table is located in the MAS_SYSTEM directory.

LOCAL cDistDstIOList$=CPL("IOLIST coHeader, TransactionNo$, LineKey$, WorkTicketKey$, ItemCode$, WarehouseCode$, Valuation$, "+"UnitOfMeasure$, UnitOfMeasureConvFactor, Quantity, TransactionType$, cLotSerRefDate$, cLotSerTransType")  

[string] IOList to receive field values passed into tier distribution object.

LOCAL cMatlSrcIOList$=CPL("IOLIST coHeader, TransactionNo$, LineKey$, WorkTicketKey$, MaterialsItemCode$, MaterialsWarehouseCode$, "+"Valuation$, UnitOfMeasure$, UnitOfMeasureConvFactor, QuantityIssued, TransType$, TransDate$, cLotSerTransType")  

[string] IOList of materials transaction fields used in tier distribution object.

LOCAL cCmplSrcIOList$=CPL("IOLIST coHeader, TransactionNo$, LineKey$, WorkTicketKey$, SubstituteItemCode$, SubstituteWarehouseCode$, "+"Valuation$, UnitOfMeasure$, UnitOfMeasureConvFactor, Quantity, TransType$, TransDate$, cLotSerTransType")  

[string] IOList of close/completion transaction fields used in tier distribution object.

LOCAL cDistObject$="PM_TransactionTierDistribution_bus"  

[string] Name of tier distribution class.

LOCAL cDistItemCode$="TBL(TransType$=trnMATERIALS$, SubstituteItemCode$, MaterialsItemCode$)"  

[string] Name of item code field used in tier distribution.

LOCAL cDistWarehouseCode$="TBL(TransType$=trnMATERIALS$, SubstituteWarehouseCode$, MaterialsWarehouseCode$)"  

[string] Name of warehouse code field used in tier distribution.

LOCAL cDistQtyVar$="TBL(TransType$=trnMATERIALS$, Quantity, QuantityIssued)"  

[string] Name of quantity field used in tier distribution.

LOCAL cItemTypes$  
LOCAL cItemValResetIOL$  
PROPERTY AllowUnbalancedLines  

[boolean] Flag to indicate whether incomplete tier distribution is allowed.

PROPERTY ExtensionQtyCol$   * Read Only *

[string] Quantity field to reset when an alternate item number is selected, used in CI_ItemCideUI_Val.

PROPERTY HdrBatchNo$  

[string] Header record batch number.

PROPERTY ML_FromStepNo$  

[string] Default Scrap From Step Number, used in UI class.

PROPERTY ML_ToStepNo$  

[string] Default Scrap To Step Number, used in UI class.

PROPERTY SkipBackFlush  

[boolean] If true, do not create backflush labor and materials transactions.

PROPERTY TransDate$  

[string] Transaction date from transaction header.

PROPERTY TransType$  

[string] Transaction type from transaction header.

PROPERTY UnitOfMeasures$   * Read Only *

[string] List of units of measure set up for an item. Used by CI_ItemCodeUI_val to display in ML_Status$.

PROPERTY WarehouseDefault$  

[string] Transaction header work ticket's materials warehouse code.

PROPERTY WorkTicketDefault$  

[string] Transaction header work ticket key.

PROPERTY TrackCompletedQty$  

[string] Work ticket class option 'Track Completed Quantity'. Set by header business class.

PROPERTY PieceRate  

[boolean] Flag to indicate whether activity code is set up for piece rate labor cost.

Methods

FUNCTION CopyFromWorkTicketMaterials(workTicket$)  
FUNCTION CopyFromWorkTicketMaterials(workTicket$, selFH)  
FUNCTION CopyFromWorkTicketMaterials(workTicket$, selFH, rnos$)  

Function will copy work ticket material lines into material transactions lines for a given work ticket. This will create a row for every work ticket material line that has a quantity remaining to issue. If given a selection file, will use the records within the table to create the material issue lines.

ParameterDescription
workticket$ [input, string] Work Ticket Key value for the work ticket that will be used to create material issue lines.
selFH [input, fileHandle] {optional} Filehandle to a subset of material lines from the given work ticket. This is a memory table and is populated in the selection dialog used in the UI.
rnos$ [input, string] {optional} SEP separated list of first and last record number added
Returns [boolean] Always returns True(1)
FUNCTION DeleteLine(delKey$)  

Deletes detail line

ParameterDescription
delKey$ [input, string] Key of detail line to delete
Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION DistributionRequired()  
FUNCTION DistributionRequired(valuation$)  

Checks if tier distribution is required

ParameterDescription
valuation$ [input, string] {optional} "5" = Lot, "6" = Serial
Returns [boolean] (1) distribution is required or (0) distribution is not required
FUNCTION DoesWorkTicketHaveUnIssuedLines(workTicket$)  

Function checks to see if work ticket detail has any unissued lines. This function used in the UI to determine whether to prompt to pull from work ticket.

ParameterDescription
workTicket$ [input, string] WorkTicketKey value of the work ticket to scan the material lines for valid lines.
Returns [boolean]
ValueDescription
True - if work ticket has at least one material line that has an unissued quantity.
False - If transaction type is not a material issue or the work ticket given has no lines that have an unissued qty.
FUNCTION GetContext$(destTable$)  

Function returns the available contexts for a given file maintained by this class. This is used for mapping UDF's

ParameterDescription
destTable$ [input, string] File name used to retrieve mapping contexts identifiers for the given table name.
Returns [string] SEP (0x8a) separated list of mapping conexts.
FUNCTION GetContextSourceTables$(context$)  

Function returns the file names for a given mapping context.

ParameterDescription
context$ [input, string] Mapping context identifier used to retrieve filenames for that context.
Returns [string] SEP (0x8a) separated list of file names.
FUNCTION GetStepLineKey$(workTicket$, step$)  

Function returns the step line key for the given work ticket and step number

ParameterDescription
workTicket$ [input, string] work ticket number that the step belongs to
step$ [input, string] step number on the work ticket.
Returns [string] returns the StepLineKey$ for the given work ticket and step number.
FUNCTION GetWorkTicketLineKeys(wtLineKeys$)  

Function will read through the current memory table and return a list of work ticket line keys that are already in data entry. This function will only return this for Material transactions.

ParameterDescription
[output, string] SEP (0x8a) separated list of WorkTicketLineKey values found in the Transaction Detail lines.
Returns [boolean]
ValueDescription
True(1) - if there are any rows with work ticket line keys
False(0) - if no rows contain work ticket line keys.
FUNCTION ImportPhantomBill(billNo$, revNo$, toStepNo$, qtyIssue)  

Imports phantom bill.

ParameterDescription
billNo$ [input, string] Bill number
revNo$ [input, string] Revision number
toStepNo$ [input, string] Step number
qtyIssue [input, numeric] Quantity issued
Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION SetDistributionIOList()  

Sets distribution source iolist based on transaction type.

Returns [boolean] retSUCCESS (1)
FUNCTION SetUnitOfMeasures()  

Concatenates all units of measure set up for the current materials item in cUnitOfMeasures$.

Returns [boolean] retSUCCESS (1)
FUNCTION ValidateGroupActivityCodeRequired()  

Verifies that activity code is not null in labor transaction.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupCloseComplete()  

Verifies that transaction type is Close or Complete.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupLabor()  

Verifies that transaction type is Labor.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupLaborMaterials()  

Verifies that transaction type is Labor or Materials.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupMaterials()  

Verifies that transaction type is Materials.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupMatItemRequired()  

Verifies that materials item code is not null in materials transaction.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupNotLabor()  

Verifies that transaction type is not Labor.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupSO()  

Verifies that sales order module is set up.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupStepRequired()  

Verifies that step number and step line key are not null in labor/materials transaction.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupSubItemRequired()  

Verifies that substitute item code is not null in close/completion transaction.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateGroupWorkTicketRequired()  

Verifies that work ticket key is not null in close/completion transaction.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)
FUNCTION ValidateLines()  

Verifies that at least one line exists and accumulates batch totals.

Returns [boolean] retSUCCESS (1) or retFAILURE (0)

Properties inherited from: CI_Constant

itmREGULAR$, itmSPECIAL$, itmCHARGE$, itmCOMMENT$, itmMISC$, valSTANDARD$, valAVERAGE$, valFIFO$, valLIFO$, valLOT$, valSERIAL$, typFINISHEDGOODS$, typRAWMATERIALS$, typDISCONTINUED$, typKIT$, proMAKE$, proBUY$, proSUBCONTRACT$, proMAKETOORDER$, proBUYTOORDER$, tierFIFO$, tierLIFO$, tierLOT$, tierSERIAL$, upceanTYPENONE$, upceanTYPEOTHER$

Properties inherited from: CI_ItemCode_Val

cItemTypes$, cAllowAliasItems, cAliasItemTypes$, cItemCodeDescCol$, cItemTypeCol$, cExtDescKeyCol$, ItemTypes$, AllowAliasItems, AliasItemTypes$, ExtendedDescriptionBusiness, ItemCodeDescCol$, AllowPhantom, AllowEngineering, AllowInactive, InvalidPurchase, IMIntegrated

Properties inherited from: PM_Constant

actClassEMPLOYEE$, actClassGENERAL$, actClassMACHINE$, actClassOUTSIDESVC$, capTimeNO$, capTimeNOEDIT$, capTimeYES$, earnTypeALLOCTIPS$, earnTypeEXCLUDETIPCALC$, earnTypeEXEMPTTIPS$, earnTypeFRINGE$, earnTypeMISC$, earnTypeOVERTIME$, earnTypeREGULAR$, earnTypeTAXABLETIPS$, earnTypeTIMEOFF1$, earnTypeTIMEOFF2$, earnTypeTIMEOFF3$, cAllEarningsTypes$, earnMethodADDAMOUNT$, earnMethodFIXED$, earnMethodSTANDARD$, cAllEarnMethods$, lttLABOR$, lttCREW$, lttMISC$, lttINOUT$, lttCOST$, dpcSTANDARD$, dpcAVERAGE$, dpcLAST$, overheadTypeAMOUNT$, overheadTypePERCENT$, prtPickNONE$, prtPickBYWHSE$, prtPickBYTICK$, tcmCodeACTUAL$, tcmCodeBUDGET$, tcmCodeSTANDARD$, tcmCodeLOWER$, tcmDescACTUAL$, tcmDescBUDGET$, tcmDescSTANDARD$, tcmDescLOWER$, trnLABOR$, trnMATERIALS$, trnCLOSE$, trnCOMPLETION$, trcSTATUS$, trcLABOR$, trcINVENTORY$, trcDIRECTCHARGE$, trcINVOICE$, trcCLOSE$, trcSCRAP$, udiSTRING$, udiNUMBER$, udiYESNO$, udiCODE$, udiDATE$, mftCodeSALESORDER$, mftCodeSALESORDERLINE$, mftCodeWORKTICKET$, mftCodeINVENTORY$, mftDescSALESORDER$, mftDescSALESORDERLINE$, mftDescWORKTICKET$, mftDescINVENTORY$, wtsOPEN$, wtsQUOTE$, wtsRELEASED$, wtsCLOSED$, wtsDELETED$, lbrIssMethodAUTOISSUE$, lbrIssMethodBACKFLUSH$, lbrIssMethodMANUAL$, matIssMethodAUTOISSUE$, matIssMethodBACKFLUSH$, matIssMethodMANUAL$, prtWORKTICKET$, prtOPERATIONTICKET$, prtCOMPLETEMISSINGCOST$, prtCOMPLETEVARFROMSTD$, prtCLOSEMISSINGCOST$, prtCLOSEVARFROMSTD$, prtCLOSECOSTLEDGER$, prtPICKSHEET$, drtBACKOUT$, drtADDIN$, drsNEW$, drsUPDATED$, drsCOMPLETED$, schFIXED$, schACTSPERHOUR$, schHOURSPERACT$, scaleNOSCALING$, scalePRODUCTIONRUN$, scalePARENTSPERTEMPLATE$, scaleTEMPLATESPERPARENT$, stepZERO$, dfltClosureWorkCenter$

Properties inherited from: SY_Customization

cDummyIol$

Properties inherited from: SY_LineEntryTierDetail

cDistItemCode$, cDistWarehouseCode$, Distribution, DistributionBalanced, DistributionIOL$, DistributionMessage, ResettingAllLines

Methods inherited from: CI_ActivityCode_Val

ClassValidateActivityCode()

Methods inherited from: CI_Constant

GetCalendarEndingDate(), GetDefaultExtendedDescriptionKey$(), UPCEANCheckDigit(), UPCEANFetch(), UPCEANUpdate()

Methods inherited from: CI_ItemCode_Val

Write(), PERFORM CheckForAlias(), PERFORM CheckUseIn(), CheckValidBill(), ClassOverrideDescription(), ClassOverrideItemCode(), ClassValidateDescription(), ClassValidateItemCode(), ItemTypeSetDefaults(), PERFORM ItemTypeSetDefaults(), UpdateGridExtendedDescKey(), ValidateGroupNotCurrentItemType()

Methods inherited from: CI_UnitOfMeasure_Val

ClassValidateUnitOfMeasure()

Methods inherited from: CI_Warehouse_Val

SetAllowInactiveRestrictedWhse(), ClassValidateWarehouse(), GetClassName$()

Methods inherited from: CI_WorkCenter_Val

ClassValidateWorkCenter()

Methods inherited from: CI_WorkTicket_Val

ClassValidateWorkTicket()

Methods inherited from: PM_Constant

BuildAlternateIOL$(), BuildMemoryFile(), ConvertCalendarToJulian(), ConvertJulianToCalendar$(), FormatTime$(), HHMMToMinutes(), HHMMToNum(), LoadCustomLabelConstants(), NumToHHMM$(), TimeToHHMM()

Methods inherited from: SY_Customization

GetCustomizations(), PostTableRead(), PreNextRecord(), PreTableWrite()

Methods inherited from: SY_LineEntryTierDetail

AddLine(), ClearLine(), ClearSetFiles(), CommitRow(), DeleteLine(), DistributionMissingInfo(), DistributionRequired(), RemoveTiersExpDate(), ResetLine(), SetHeader(), ValidateLines(), WRITE(), ClearLastLine(), DeleteTierLines(), GetMemoryEditKey$(), PostDeleteRec(), PostWriteRec(), ResetRow(), SetCurrentKey(), ValidateAccumulateLines()