Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

Conditions

ABASSIGN
ABTRANS
ACACCTCATActivity Account Categories
ACACCTCATXAccount Category Detail
ACACTGRPActivity Group
ACACTIVITYActivity
ACACTMXVALActivity List Attribute Values
ACADDASSGNActivity Address Assignment
ACADDLCNTR
ACADDRESSActivity Address
ACALLOCActivity Allocation
ACALLOCGPActivity Allocation Group
ACALLOCGPXActivity Allocation Grp Detail
ACALLOCXActivity Allocation Detail
ACAMCODEActivity Asset Code
ACASSIGNActivity Resource Assignment
ACAUDITActivity Audit
ACBILLActivity Billing
ACBILLXActivity Billing Detail
ACBLRATEActivity Billing Rates Header
ACBLRATEXActivity Billing Rates Detail
ACBRDNDTL
ACBRDNTYPE
ACBUDDTLActivity Budget
ACBUDDTLXActivity Budget Detail
ACBUDHDRActivity Budget Header
ACCALActivity Calendar
ACCATRANSAC Allocation Transaction
ACCHGORDERActivity Change Order
ACCHGORDXActivity Change Order Detail
ACCNTRACT
ACCNTRCMTX
ACCOLGRP
ACCOMMITActivity Commitments
ACCOMMITXActivity Commitments Detail
ACCONSOLActivity Consolidation
ACCONSOLXActivity Consolidation Detail
ACCRSCHEDActivity Accrual Schedule
ACCTLGRPHDActivity Control Group Header
ACCUAMTActivity Currency Amount
ACCUAMTXAC Currency Amount Detail
ACCUSTOMERActivity Customer
ACDEFREV
ACEMPEXPX
ACGLACCTActivity GL Accounts
ACGLCONSLAC GL Acct Unit Consolidation
ACGLCONSLXAC GL Acct Unit Consol Detail
ACGLMASTAC GL Acct Unit Master
ACGLMASTXAC GL Acct Unit Master Detail
ACHISTCNSL
ACHISTDTL
ACHISTHDR
ACIAAMTDIM
ACIACALDIM
ACIAMBR
ACIASCNMBR
ACIFACTV
ACIFRESCActivity Resource Interface
ACINVAUDIT
ACINVDTL
ACINVHDR
ACLEVELActivity Levels
ACMASTERActivity Master
ACMASTERXActivity Master Detail
ACMILESTNActivity Milestones
ACMILESTNXActivity Milestones Detail
ACMNTHDR
ACMNTSCHMaintenance Schedule
ACMNTSCHXMaintenance Schedule Detail
ACPERCCMPLActivity Percent Complete
ACPERCMPLXAC Percent Complete Detail
ACPMHSTCSL
ACPMHSTDTL
ACPMHSTHDR
ACPOOLHDRAllocation Pool Header
ACPRMSTN
ACPRMSTNX
ACPRODACCT
ACPRODDTL
ACPRODHDR
ACPRODLST
ACPRODLSTX
ACPRODUSERProduct List Price/Cost
ACPROFORMAProduct Proforma Invoice
ACRANGEDTL
ACRANGEHDR
ACRESCLASSActivity Resource Class
ACRESOURCEActivity Resource
ACRETAIN
ACRETAINX
ACRETNG
ACRJGRP
ACRJHDR
ACSPREADActivity Spread Codes
ACSRVCLOCActivity Service Location
ACTOTBAL
ACTOTBALX
ACTRANSActivity Transaction
ACUOMActivity Unit of Measure
ADCOMPANY
ADMASTER
AMACCOUNTAccount
AMACCTGRPAsset Account Group
AMASSETAsset
AMASSETADJAsset Adjustment
AMASSETCNVAsset Conversion
AMASSETDSPAsset Disposal
AMASSETGRP
AMASSETRIN
AMASSETTRFAsset Transfer
AMASTBKADJAsset Book Adjustment
AMASTBKCNVAsset Book Conversion
AMASTBKDSPAsset Book Disposal
AMASTBKRIN
AMASTBKTRFAsset Book Transfer
AMASTBOOKAsset Book
AMASTITCNVAsset Item Conversion
AMASTITEMAsset Item
AMASTMXCNVAsset Attribute Conversion
AMASTRECAPAsset Depreciation Recapture
AMASTRPAIRAsset Repair
AMASTTRCNV
AMASTTYPEAsset Type
AMAUGROUPAM Accounting Unit Group
AMBKHIST
AMBKHISTX
AMBOOKAsset Book Name
AMBOOKTYPE
AMCALENDARCalendar
AMCNVASSETAsset Conversion Number
AMCONTROLAsset Internal Control
AMDIVISIONDivision
AMIAASTDIM
AMIABKDIM
AMIACALDIM
AMIAMEADIM
AMIAOPDIM
AMINTERAsset Interface
AMLOCATIONLocation
AMMETHODMethod
AMRPRINTERAsset Repair Interface
AMSELDTLAsset Selection Detail
AMSELECTAsset Processing Selection
AMSYSOPTS
AMTABLEPCTPercent Table
AMTEMPLATEAsset Template
AMTRANSAsset Transaction
AMTYPALLOC
AMUOPPDSUnits of Production Periods
APAPDHIST
APAPIHIST
APAPPHIST
APAPPROVALInvoice Approval
APAUDITVendor-Invoice Audit
APBATCHBatch
APCINVOICEInvoice Interface
APCOMMENTSComments
APCOMPANYAccounts Payable Company
APDISCACCDiscount
APDISTCODEDistribution Code Detail
APDISTRIBInvoice Distribution Header
APDRAFTSAP Bill of Exchange
APDRFTDISTBill of Exchange Distribution
APHLDINVHold
APINVOICEAccounts Payable Invoice
APMONITORAccounts Payable Monitor
APPAYMENTInvoice Payment
APPJOBHISTApplicant Job History
APPLICANTApplicant
APPROCGRPProcess Group
APPROCLEVAccounts Payable Process Level
APVENADDRAP Vendor Address
APVENBALVendor Balance
APVENGROUPVendor Group
APVENLOCVendor Location
APVENMASTVendor
APVENPAY
ARADJUSTAR Application Adjustment
ARAPPLIEDAR Application
ARAPSELECT
ARCDSELECTAR Credit Selects
ARCOMMENTCustomer Comments
ARCUSTOMERAR Company Customer
ARCYCLEAR Statement Cycle Code
ARDFTSELAR Obligations Selected-BOEs
ARDISPUTEAR Disputed Transactions
ARDISTRIBAR Distributions
ARDRAFTSAR Bill of Exchange
ARICOMMENTComment Conversion/Interface
ARIDISTRIBDistribution Convert/Interface
ARILOCKBOXAR Lock Box Interface
ARIPMT
AROBLIGGRPAR Obligation Grouping
AROIHDRAR Transaction Header
AROITEMSAR Transaction
AROPIVOT
ARPAYMENTAR Payment
ARPREPAYAR Payment Prepay Information
ARPYMNTHDRAR Payment Batch
ARREASONAR Reason Codes
ARREMITAR Payment Remittance
ARRTMAR Return to Maker Payment
ARSADJUSTCash Application Adjust Select
ARUDISTRIB
ARXIND
ATCLASSAttendance Class
ATTENDCODEAttendance Code
ATTENDHISTEmployee Attendance History
AUMXVALUEAcct Unit Attribute Value
BANKACCTBank Account
BANKFILEBank Code
BENEFICRYBeneficiary
BENEFITEmployee Benefit
BILLOFLADBill of Lading
BILLTOBill To
BINSTORAGEBin Storage Code
BLINVHDRAR Transaction Batch
BLRICLINECust. Recurring Invc Item
BLRICUSTCustomer Recurring Invoice
BNACCOUNTSBenefit Accounts
BNBEN
BNBROKER
BNCARRIERInsurance Carrier
BNCHANGEBenefit Changes
BNCOMMENTSBenefit Comments
BNCOMPANYBenefit Company Parameters
BNCOVDFTBenefit Coverage Defaults
BNCOVERAGEBenefit Coverage
BNEMPEXER
BNEMPGRNT
BNGRPCHGBenefit Group Change
BNINVDETLBenefit Invoice Detail
BNINVESTInvestment Distribution
BNPAYDETLBenefit Payment Detail
BNPAYMENTBenefit Payment
BNPRMOPTBenefit Premium Options
BNSIMDTLBenefit Simulation Detail
BNSIMHDRBenefit Simulation
BNSTKGNT
BNSTKSPLT
BNWAITBenefit Waiting Period
BONDBENIFSavings Bond Beneficiary
BUYCLASSPO Buyer Purch Class Auth
BUYCMPLOC
BUYERPO Buyer Master
CAALLOCGRPAllocation Group
CADETAILAllocation Detail
CAHEADERAllocation Header
CBBANKINSTBank Transaction Code
CBCASHCODECash Code
CBCHECKAccounts Payable Cash Payment
CBDISTRIBTransaction Distribution
CBRECPTDTLCash Receipt Detail
CBRECPTHDRCash Receipt
CBSTATEMNTReconciliation Statement
CBTRANSBank Transaction
CBTRFDTLFund Transfer Detail
CBTRFHDRFund Transfer
CMPUTECompute Statements
COCOMPDemand Line Kit Components
CODACash/Deferred Account History
COLINECustomer Order Line
COLINEUOMOrder Line Pricing UOM's
COMISCCustomer Order Miscellaneous
COMPONENTComponents of a Kit
CONTRDETLContribution Schedule Detail
CUACCTCurrency Gain and Loss Account
CUAMOUNTCurrency Amount
CUAMOUNTXCurrency Amount-Daily
CURELATCurrency Relationships
CUSTDEFLTSAR Customer Defaults
CUSTDESCAR Group Customer
CUSTORDERCustomer Order File
CUTABLECurrency Table
CUTRANSLCurrency Translation
CXBURDENCase Cart Burden
CXCASEHEADCase Cart Header
CXCASEPREFCase Cart Preferences
CXPREFITEMPreference Items
CXPREFTEMPPreference Template
CXPTMPITEMTemplate Items
DEDCODEDeduction
DEPTCODEDepartment
DTCASHINGAR Bank Cashing Charges
DTCUSTBANKAR Customer Paying Bank
DTREMITAR Bill of Exchange Remittance
EEADVANCEEmployee Advance
EECATEGORYExpense-Advance Category Code
EEDISTRIBExpense Distribution
EEEXPENSEEmployee Expense
EEOUNITEEO Establishment
EMACHDEPSTEmployee ACH Account
EMDEDMASTREmployee Deduction
EMDEPENDEmployee Dependent
EMDISTMASTEmp Acct Distribution Override
EMPACHDISTEmployee ACH Distribution
EMPAUTOEmployee Automobiles
EMPCODESEmp/App Personnel Codes
EMPFLEXDOLEmployee Flex Dollars
EMPFLEXREMEmployee Flex Period Dollars
EMPLOYEEEmployee
EMPSUMMEmployee Year-To-Date Tip Pay
EMPVISAEmployee Travel and Visa
EMSTATUSEmployee/Applicant Status
EMTAMASTREmployee Time Accrual Master
EMTATRANSEmp Time Accrual Transactions
EMTATRNSUMEmp TA Transaction Summary
FBDETAILBudget Detail
FBFUNDHDR
FBHEADERBudget Header
FLEXDOLLARFlex Dollars
FLEXPLANFlex Plan
FRCHARGEFR Charges
FRCONTMASTFR Contract Master
FRSALESFR Sales Remittance
GLACCTVLDGL Account Validation
GLADDRESSGeneral Ledger Address
GLAMOUNTSGeneral Ledger Amounts
GLAUDITGeneral Ledger Audit
GLAUTMPCNV
GLAUTMPDTL
GLAUTMPHDR
GLAUTMPMST
GLCHARTGeneral Ledger Chart
GLCHARTDTLGeneral Ledger Chart Detail
GLCHARTSUMGeneral Ledger Chart Summary
GLCODESGeneral Ledger Codes
GLCOMMITX
GLCONSOLGeneral Ledger Consolidation
GLCONTROLGeneral Ledger Control
GLCPYGRPGeneral Ledger Company Group
GLIAMBRFinancial Analyzer Members
GLINTCOGeneral Ledger Intercompany
GLJELOGGL Journal Entry Log
GLMASTERGeneral Ledger Account Master
GLNAMESGeneral Ledger Names
GLRPTDEFGL Report Definition
GLRPTSELGL Report Selection
GLSCCATGL Source Code Category
GLSRCCODEGeneral Ledger Source Code
GLSUBACDTLGL Subaccount Detail
GLSUBACHDRGL Subaccount Header
GLSYSTEMGeneral Ledger Company
GLTRANSGeneral Ledger Transactions
GLTRANSRELGL Transaction Conversion
GLUNITSGeneral Ledger Units
HAZARDHazard Code
HCCHRGITEMCharge Item
HISTERR
HRCONTNBR
HRCORRESP
HRCTRYCODE
HREMPUSFEmployee/Applicant User Fields
HRHISTORYHR History
HRIADIM
HRIAMBR
HRPOSFLDSPosition User Fields
HRPOSUSDPosition User Field Type
HRSUPERSupervisors
HRUSERFLDSHR User Fields
IADRILL
IAFILEDEF
IASECURITY
ICACTIVITYPre-Released Document Header
ICAUDITItem/Item Location Audit
ICBINBin Numbers
ICBRDNTMPLBurden Template
ICCATEGORYGL Account Category
ICCOMPANYInventory Company Information
ICCPHYINV
ICCTRNHDR
ICDICTItem/Item Location Dictionary
ICFACILITY
ICFGBRDNFinished Goods Burden
ICGENERICGeneric Name
ICITEMCODE
ICLOCATIONCompany Location
ICMANFCODEManufacturer's Code
ICPLANORDInventory Planned Order File
ICRECEIPTSCosting Record
ICTRANSInventory Transaction
ICTRANSDTLInventory Transaction Detail
INCALENDARIntrastat Calendar
INTERVIEWApplicant Interview
ITEMLOCItem Location
ITEMMASTItem Master
ITEMNDCItem National Drug Code
ITEMSKUItem SKU
ITEMSRC
ITEMSUBItem Substitute
ITEMUPCItem Universal Product Code
ITEMUPN1Item UPN1
ITEMUPN2Item UPN2
ITSERIALSerial Numbers
JBOOKHDRJournal Book Header
JOBAUTHEmployee Job Authorization
JOBCODEJob Code Parameters
JOBRELATEJob Code Relationship
KITITEMKit Item
KTINSTRUCTKit Instructions
KWDDETAIL
KWDMASTER
KWDSETUP
LETTERCODEBenefit Letter Code
LETTERTEXTBenefit Letter Text
LMDISTRIB
LMINVOICE
LMLEASE
LMPAYDTL
MACINVOICEInvoice Conversion/Interface
MAINVDTLMatching Invoice Detail
MAINVHANDInvoice Handling Code
MAINVMSG
MAJORCLMajor Class
MAMADHIST
MAMATCHTBLMatch Table
MAMTCHELEMMatching Elements
MAPOINVMatching Purchase Order
MATCHCLASSMatch Class
MEMBEROutline Members
MILITARYMilitary Service History
MINORCLMinor Class
MLAMOUNTS
MLCALMAP
MLCONSOL
MLCUAMOUNT
MLTRANS
MLUNITS
MMDISTAccount Distributions
MSDSACKMaterial Sfty Data Sht Acknwld
MXCATDEFAttribute Definition
MXELEMENTAttribute Element
MXLISTHDRAttribute List Header
MXLISTMBRAttribute List
MXOBJCATAttribute Object
MXTMPLHDRAttribute Template Header
MXVIEWDTLAttribute View Detail
MXVIEWHDRAttribute View Header
NATACCTAR National Account
NAVIGATEBenefit Process Order
OBJIDObject ID
OCCURTYPECOBRA Occurrence Type
OEAUDITOrder Entry Audit
OEBASEBase Price
OECOMPANYOrder Entry Company
OEFRTCODEOrder Entry Freight Code
OEINVCCOMMInvoice Comments
OEINVCLINEInvoice Line
OEINVCTYPEInvoice Type
OEINVOICEInvoice
OEMISCCustomer Order Misc Charges
OEORDCMNTCustomer Order Comments
OEORDDISCOrder Discount
OEPLCLASSPrice List Sales Class
OEPLITEMPrice List Item
OEPRCLISTPrice List
OEPROCLEVOrder Entry Process Level
OEREASONCancellation Reason Code
OEROUTEOrder Entry Route
OESLSACCTSales Accounts
OLAPDBMData Mart Manager
OLAPDIMData Mart Dimensions
ONETMDEDPayroll One-time Deduction
OPERATOROperator
OSHAOSHA Incident History
PAASSIGNEDAssigned Resources
PAATTRIBCourse Attributes
PABUDGETBudget
PACANEEA
PACLASSPOSPosition Class/Position Number
PACOMMENTSPersonnel Comments
PACOMPPROF
PACOSTCourse Cost
PACOURSECourses
PADICTHR Systems Data Dictionary
PADICT2HR Systems Data Dict Detail
PAEMERGCNTEmployee Emergency Contact
PAEMPAPP
PAEMPAPTST
PAEMPCOSTSEmployee Costs
PAEMPLOYEEEmployee Personnel Information
PAEMPPOSEmployee Multiple Pos, Jobs
PAEMPTRACKRequired Training
PAFOLLOWUP
PAGRDI
PAGRDISTEP
PAINCICOST
PAINSCOURSCourse Instructors
PAINSTRUCTInstructor Information
PAINSTSESSession Instructors
PAJOBINTRS
PAJOBREQJob Requisition
PAMEDICALEmp Medical and Work Desc Code
PAMODOPTTraining Options
PAOFFLANG
PAPEPAUDITRetroactive Pos, Job Changes
PAPOSCHGPosition Changes
PAPOSERRPosition Errors
PAPOSITIONPositions
PAPOSRULEPosition Rules
PAPREREQCourse Prerequisites
PAPROFILE
PAPROMAP
PAREGISTERRegistration Information
PAREQAPPJob Requisition Application
PAREQCOSTJob Requisition Cost
PAREQLOGJob Requisition Log
PAREQOFFERJob Requisition Offer
PARTBENCOBRA Participant Benefit
PARTICIPNTCOBRA Participant
PASCOSTSession Costs
PASCRTYData Item Attribute Parameters
PASESSIONSessions
PATESTOVER
PATHFINDEmployee Report Writer Paths
PATRACKTracks
PATRACKDTLTrack Courses
PATRNHISTTraining History
PATSTRESLT
PATSTSETUP
PAYCLASSPay Class
PAYDEDUCTNEmployee Payment Deductions
PAYMASTREmployee Payment Master
PAYSUMGRPPay Summary Groups
PBACCTASGNAccount Assignment
PBBILL
PBBLDEDRT
PBBLJOBCD
PBBLJOBCDX
PBBNBILL
PBCLIENT
PBDCTGRPX
PBDISTRIB
PBFEE
PBHSTDTL
PBHSTHDR
PBONETMDED
PBTIME
PBTIMEREC
PBTRANS
PBWCRT
PCODESHuman Resource Code
PCODESDTL
PCODESTYPE
PERSACTHSTPersonnel Action History
PERSACTIONPersonnel Action
PERSACTYPEPersonnel Action Code
PERSGROUPEmployee Group Header
PGSELECTEmp Group Selection Criteria
PHARITEM
PLANBenefit Plan
PLANMASTERTime Accrual Plan
POAOCDTLAdd On Cost Detail
POAOCMASTAdd On Cost Master
POAOCSPRDAdd On Cost Spread
POAUDITAudit Records
POBIDBid
POBIDITEMBid Item
POCODEPurchase Order Codes
PODOCREFDocument Reference
POINTAOCInterface Add On Cost
POINTERFACInterface File
POITEMVENPO Vendor Item Information
POLINELine Items
POLINESRCPO Line Source
POMESSAGEBuyer Messages
POPSPHIST
PORECADJHDReceiving Adjustments Header
PORECADJLNReceiving Adjustments Line
PORECEIVEPO Receivers
PORECLINEPO Line Item Receivings
PORETURNHDPO Return Header
PORETURNLNPO Return Line
POTRANSDTLPO Transaction Detail
POVAGRMTHD
POVAGRMTLN
POVENDLOCVendor Location Master
POVENDORPO Vendor Master
PRBATCHPayroll Time Record Batch Head
PRCHECKEmployee Payment
PRDEDDTL
PRDISTRIBEmployee Payment Distribution
PREMDEDHSTEmployee Deduction History
PREMIUMBenefit Plan Premium
PREMPBANK
PREMPGARN
PRFUNDSRC
PRGARNHIST
PRGARNRULE
PRHOURS
PRMINWAGEMinimum Wage
PRMONITOR
PROCTEMP
PROCTEMPLN
PROCTMPPAR
PROGPAY
PROVERTIMEOvertime Pay Plan
PRPAYCODEPay Code
PRPENDTIME
PRPENFSRC
PRPROCGRPPayroll Process Group
PRQUALIFYRequired Code Select Criteria
PRRATEHISTEmployee Rate History
PRRATESAlternate Pay Rates
PRREGDICT
PRREGPARM
PRSAGDTLStep & Grade Schedule Detail
PRSAGHEADStep & Grade Schedule Header
PRSHIFTHDR
PRSHIFTTBL
PRSYSTEMHR Company and Process Levels
PRTAXAUTHTax Authority
PRTAXIDTax Identification Number
PRTAXLEVYPayroll Tax Levy
PRTAXLOC
PRTAXPRDS
PRTIMEEmployee Pay/Hours History
PRTIMEFORM
PSGTAXESPay Summary Group Taxes
PURCHORDERPurchase Order Master
PWCOMPUTEHR Writer Compute Statements
PWICUST
PWSELECTHR Writer Selection Criteria
PWTITLEHR Report Writer Title
PWTOPICHR Report Writer Topics
QUARTDEDQuarterly Deduction
QUARTWAGEQuarterly Wage
RATETBLDTLRate Table Detail
RATETBLHDRRate Table Header
RATOTALSRatio Totals
REASONReason Code
REFERENCApplicant Reference
REQHEADERRequisition Header
REQLINERequisition Line
REQUESTERRequester
RETURNHDRReturn Header
REVIEWEmployee Performance Review
RJCONTROLRecurring Journal Control
RJTRANSRecurring Journal Transactions
ROLAPDIM
ROLAPIDS
ROUTEHDRRoute Header
ROUTESTOPRoute Stop
RQAPPROVERequisition Approvals
RQLINEDTLRequisition Line Details
RQLOCRequesting Locations
RQTEMPRequisition Template Header
RQTRANSRequisition Transactions
RWDICTReport Writer Dictionary
RWFORMATReport Writer Format
RWGRPDETReport Writer Group Detail
RWHEADERReport Writer Header
RWREQUESTReport Writer Request
RWROWDETRW Row File Detail
SBBENSavings Bond Beneficiary
SCNSTRUCX
SHIPTOCustomer Ship To Address
SIOEBCIUPD
SLSEGMENTPL User Analysis
SLSEGRULEProfitability Ledger Class
SLTRANSPL Transaction
SLTRANSERRPL Transaction Error
SOHDETAIL
STANDTIMEPayroll Standard Time Record
STCOMMCODEPO Standard Comment Codes
TAFORMULATime Accrual Formula
TAXGROUPPayroll Tax Reporting Group
TAXIDEXMPPay/Deduction Exemption Code
TERMSPayment Terms
TIMERECORDEmployee Time Records
TIPPAYEmployee Tip Pay
TMEMPLEAVE
TMEMPLVDTL
TMLEAVE
TPPARAMTip Parameters
TREXCEPT
TXCODEMASTTax Code Master
TXCOMPANYTax Company
TXTAXCODETax Code
TXTAXRATETax Rate
TXTAXTABLETax Table
TXTAXTRANTax Transaction
UGCHKLST
UGSTATUpgrade Statistics
VESTHOURSEmployee Vesting Hours
WCCLASSWork Comp Class Detail
WCCLASSHDRWork Comp Class Header
WCCLASSOVR
WHDEMANDDemand
WHDEMNDHDRDemand Header
WHSHIPCOMPShipment Line Kit Component
WHSHIPLINEShipment Line
WHSHIPMENTShipment
WHSHLDTLShipment Line Detail
WOBRDNWork Order Burdens
WOBYPRODWork Order Byproducts
WODETAILWork Order Item Details
WODMNDFCSTWork Order Forecast Demand
WOITEMWork Order Items
WORDERWork Order Header
WOSCHEDDTLWork Order Schedule Detail
WOSCHEDULEWork Order Schedule