Database Definitions Change Summary
About This Guide
Introduction
How This Book Is Organized
Symbols and Conventions
AAA_F_20141204
abscc_det
absc_det
absd_det
absi_mstr
absl_det
abspli_ref
absp_det
absr_det
abssc_det
abssi_det
abss_det
absw_det
absx_det
abs_mstr
AcctIF
AcctIFFilter
acdf_mstr
acld_det
acm_mstr
actf_mstr
act_mstr
ac_mstr
adc_ctrl
Address
AddressType
adx_det
ad_mstr
Agent
AIMW
ald_det
AlgoAssD
AlgoAssM
AlgoM
AlgoTypeM
Allocation
AllocationBatch
AllocationBatchLine
AllocationLayer
AllocationPosting
AllocationProportional
alm_mstr
AltCOAGroup
AltCOAStruct
AltCOAStructDet
AltTaskM
AltUMD
AltUMM
al_mstr
anl_det
ans_det
anx_det
an_mstr
apc_ctrl
APMatching
APmatchingLn
APMatchingLnRevTax
APMatchingLnTax
APMatchingLnWHT
apmr_mstr
apm_ctrl
ApproveStatusTrans
arc_ctrl
arfld_det
atcatx_ref
atcat_mstr
atdcd_det
atdc_mstr
atdext_det
atg_mstr
atp_det
attrdh_hist
attrd_det
attrlot_mstr
attrpfd_det
attrpf_mstr
attrp_det
attrsl_det
attrsp_det
attrs_det
attrvh_hist
attrv_det
attr_mstr
att_mstr
aud_det
AutoNumber
avatax_ctrl
BankAccFormat
BankAccFormatSect
BankBranch
BankCharge
BankChargeRate
BankFileFormat
BankFileFormatTransType
BankImp
BankImpLine
BankImpLineLog
BankImpLinePrc
BankNumber
BankNumberPayCode
BankPayFormat
BankState
BankStateAlloc
BankStateAllocColl
BankStateImport
BankStateLine
BankStateStageAlloc
BatchPickC
BatchPickD
BatchPickM
bbl_mstr
bcd_det
bc_mstr
bdld_det
bdl_mstr
bdp_det
bic_ctrl
Bill
BillSchedule
BLWIGroup
bom_mstr
bopd_det
bop_mstr
Box1099
Box1099PurchaseTypeLink
btb_det
btrd_det
btr_mstr
Budget
BudgetCompany
BudgetFDS
BudgetGroup
BudgetLink
BudgetLinkAcc
BudgetLinkAccDet
BudgetLinkActual
BudgetLinkCommit
BudgetPeriod
BudgetReport
BudgetReportDetail
BudgetVersion
BudgetVersionFig
BudgetVersionGLFig
BudgetWBS
BudgetWBSBusComponent
BudgetWBSRoster
BulkPickC
BulkPickD
BulkPickDH
BulkPickM
BusArea
BusAreaComponent
BusinessRelation
BusRelationSafDefault
cac_ctrl
cah_hist
cald_det
CalendarD
CalendarM
calh_det
calm_mstr
cals_det
cal_det
caq_mstr
CashGroup
CashReport
CashReportGL
CashReportGLLine
cas_mstr
categ_mstr
ca_mstr
CBalance
ccb_mstr
ccc_ctrl
ccd_mstr
cclscd_det
cclsc_mstr
ccls_mstr
ccl_ctrl
CCollection
cctr_hist
cct_mstr
cc_mstr
cdf_mstr
CDocInvoiceXrefStage
CDocument
CDocumentInvoiceXref
CDocumentPostingLine
CDocumentStatus
cd_det
ChargesD
chg_mstr
CHist
chm_mstr
cild_det
cil_mstr
CInvoice
CInvoiceBank
CInvoiceBankPayCode
CInvoiceMovement
CInvoicePO
CInvoicePosting
CInvoiceStage
CInvoiceVat
CInvoiceWHT
clc_ctrl
ClientCache
clsf_mstr
CMask
CMaskJournal
CMaskJrnlGroup
cmc_ctrl
cmd_det
cmf_mstr
cmh_hist
cmt_det
cm_mstr
cncix_mstr
cncs_mstr
cncud_det
cncu_mstr
cnc_ctrl
cnsix_mstr
cnss_mstr
cnsud_det
cnsu_mstr
cns_ctrl
CnvXref
COACrossRef
COACrossRefDet
COAMaskCC
COAMaskCCDiv
COAMaskCCGL
COAMaskDiv
COAMaskDivGL
COAMaskProj
COAMaskProjCC
COAMaskProjDiv
COAMaskProjGL
code_mstr
comd_det
Company
CompanyProperty
CompanySharedSet
com_mstr
ConCheck
ConCheckLine
ConCheckLineDet
Consolid
ConsolidCycle
ConsolidCycleCompany
ConsolidCycleSaf
ConsolidDump
ConsolidLayer
ConsolidPeriodXref
ConsolidPostingXref
Contact
cont_mstr
CorporateGroup
CostCentre
CostCentreSafDefault
cost_cal
Country
CountryVatFormat
County
co_ctrl
CPay
cpcd_det
cpc_mstr
cph_hist
cp_mstr
crc_ctrl
crd_det
Creditor
CreditorSafDefault
CreditorType
CreditorVat
cref_mstr
csa_mstr
cscp_det
csc_mstr
csd_det
csid_det
csil_mstr
csim_mstr
csld_det
cslm_mstr
cssi_det
css_mstr
cst_mstr
cs_mstr
ctd_det
ctg_mstr
ctry_mstr
ct_mstr
Currency
CustInventM
CustPartM
cu_mstr
CyGroup
CyGroupCompany
DBalance
DCollection
DCollectionExport
dc_mstr
DDocInvoiceXrefStage
DDocument
DDocumentInvoiceXref
DDocumentPayCode
DDocumentPostingLine
DDocumentStatus
Debtor
DebtorCreditRating
DebtorEndUser
DebtorSafDefault
DebtorShipTo
DebtorType
decl_mstr
DeductionCat
DeductionCatLine
DeductionCatLineSaf
ded_det
deed_det
dee_mstr
defc_det
defd_det
deff_det
defl_det
defr_det
defs_det
DeliveryCond
delt_mstr
dep_mstr
deu_det
de_mstr
df_mstr
DHist
DInvoice
DInvoiceBank
DInvoiceBankPayCode
DInvoiceDeduction
DInvoiceMovement
DInvoiceOpInfo
DInvoicePosting
DInvoiceShipper
DInvoiceStage
DInvoiceVat
Division
dmw_wkfl
DomainProperty
Domains
DomainSharedSet
dom_mstr
dosr_det
DPay
DPaySel
DPaySelLine
DPaySelLineStg
DPaySelPayCode
DPaySelPayRef
dpt_mstr
drp_ctrl
dsd_det
dsr_mstr
dss_mstr
ds_det
dvfv_det
dvf_det
dvlbx_ref
dvshx_ref
dv_mstr
dybs_mstr
dyd_mstr
dy_mstr
ea_mstr
eca_mstr
ecd1_det
ecd2_det
ecd3_det
ecd4_det
ecd5_det
ecd9_det
ecd_det
ecl_list
ecm_mstr
ect_mstr
ecx_ref
edlg_hist
ega_mstr
egc_ctrl
egd_det
egs_det
egt_mstr
egw_wkfl
Employee
emp_mstr
emsg_mstr
em_mstr
EngineC
EngineH
EngineW
eng_mstr
en_mstr
ERAssD
ERD
ERM
ERS
ERSLine
ers_mstr
esapfc_det
esapfil_det
esapfs_det
esapf_det
esapmp_ref
esaps_det
esap_mstr
escat_mstr
escd_det
escf_ref
escx_det
esc_ctrl
esfil_mstr
esgc_ref
esh_mstr
esig_mstr
esrec_det
ess_mstr
eswpfc_det
eswpfil_det
eswpfs_det
eswpf_det
eswpmp_ref
eswps_det
eswp_mstr
es_mstr
et_ctrl
euc_ctrl
eud_det
eus_mstr
eu_mstr
EventDaemon
ExchangeRate
ExchangeRateType
ExpenseCode
ExpenseGLMatrix
ExpNoteCInvoice
ExpNoteLineSaf
exr_rate
faadj_mstr
FAAssetBookDeprec
FAAssetGLSaf
FAAssetSaf
FAAssetTypeFABook
faba_det
fabchd_det
fabch_mstr
fabdy_det
fabd_det
fabk_mstr
fab_det
FACapitalAssetBook
facd_det
facld_det
facls_mstr
facl_cal
fact_ctrl
fac_ctrl
FADepreciationDetSaf
FADepreciationPosting
fadf_mstr
FADisposalDetSaf
fad_det
faloc_mstr
fal_mstr
famtd_det
famtrd_det
famtr_mstr
famt_mstr
FARevalDetSaf
FARevalPosting
fas_ctrl
fauop_det
FavBusComponent
fa_mstr
fcc_mstr
fcDraftInstanceData
fcd_mstr
fcg_mstr
fcIdmObject
fcInstance
fcl_mstr
fcs_sum
fct_mstr
fc_det
ff_mstr
fh_mstr
fis_mstr
fkt_mstr
flcrh_hist
flcr_mstr
fldattr_mstr
fldf_mstr
flff_mstr
flh_mstr
flpw_mstr
flp_plan
flscd_det
flsc_mstr
flsd_det
fnd_det
fnh_hist
fn_mstr
fp1_plan
fp2_plan
fp3_plan
fpc_mstr
fpd_cost
fpst_mstr
frcd_det
frd_det
frm_mstr
FRWAnCode
FRWAnCodeElem
FRWAnCodeElemDet
FRWBuildLog
FRWChart
FRWCol
FRWColDet
FRWColDetComp
FRWCompany
FRWCrossRef
FRWCube
FRWCubeCy
FRWCubeDim
FRWCubeGLPd
FRWCubeHistLink
FRWCubeLayer
FRWCubeMeas
FRWCubePeriod
FRWRepMstr
FRWRepMstrRole
FRWShSetComb
FRWTreeNode
FRWTreeView
FRWUsrDefault
frzd_det
fr_mstr
fsc_mstr
fsd_det
fsh_mstr
fslp_pln
fsp1_pln
fsp2_pln
fsp3_pln
fspd_det
fsu_mstr
ftch_hist
ft_mstr
fwk_mstr
genfldd_det
giap_mstr
gimd_mstr
gip_det
gisi_mstr
GL
GLCalendar
glccp_det
glcd_det
GLConsolidCy
glcor_ctrl
glc_cal
GLMirror
GLOpenItem
GLOpenItemMovement
GLReportLink
GLSafDefault
GLSystemType
gltsaf_det
gltw_wkfl
GLType
glt_det
gl_ctrl
grac_det
grad_det
gral_det
gras_det
gra_mstr
grbg_det
grcd_det
grc_mstr
grdf_mtx
grhd_det
grib_det
gric_det
grid_det
grig_mtx
grit_wkf
gri_mstr
GrossIncAcc
grqd_det
grrd_det
grr_mstr
grtx_det
grv_det
grx1_wkfl
grx2_wkfl
grx3_wkfl
grx_mstr
gr_ctrl
gtidh_hist
gtih_hist
gtnbr_det
gt_ctrl
hd_mstr
hlp_mstr
HoldM
Holiday
iach_hist
iac_ctrl
iad_mstr
iaod_det
iao_mstr
iasd_det
iatd_det
iat_mstr
ibh_hist
ib_det
icc_ctrl
idhlc_hist
idhr_hist
idh_hist
iec_ctrl
ied_det
ieh_hist
iepl_ctrl
ie_mstr
ihcc_hist
ihr_hist
ih_hist
ild_det
im_mstr
Industry
ind_det
insd_det
InspC
InspH
InspInvD
InstallNetImport
ins_mstr
InterWLGM
InventHM
InventM
in_mstr
ipd_det
iph_hist
ip_mstr
IRAssD
IRD
IRGroupM
IRM
iro_det
isb_mstr
isd_det
iss_mstr
isvc_mstr
is_mstr
itmh_hist
itm_det
itsd_det
its_mstr
ivs_ctrl
Journal
JournalGroup
JournalType
kbc_ctrl
kbdt_mstr
kbmd_mstr
kbpp_mstr
kbtrd_det
kbtrr_det
kbtr_hist
kenb_det
kia_mstr
knbadc_hist
knbcd_det
knbdd_mstr
knbd_det
knbfd_det
knbism_det
knbi_mstr
knble_det
knbl_det
knbrs_mstr
knbsm_mstr
knbs_det
knb_mstr
knpd_det
knp_mstr
kstc_det
LabourC
lacd_det
lacod_det
lac_ctrl
lad_det
LaneAssD
LaneAssM
LaneGroupD
LaneGroupM
LaneM
Layer
lblc_ctrl
lcpr_mstr
lc_mstr
ld_det
lgdc_ctrl
lgddl_det
lgdd_det
lgdfcb_det
lgdfcd_det
lgdfc_mstr
lgdnr_det
lgdtx_det
lgd_mstr
lmh_hist
lm_mstr
lna_det
lnd_det
lnf_det
Lng
lngd_det
lng_mstr
ln_mstr
LoadD
LoadM
LoadMasterM
LoadSAddrD
LoadSetupM
LoadSItemD
LocalExitC
locc_det
LocDefD
LocDefM
locd_det
LocForD
LocM
locpd_det
LocUMM
LocW
loc_mstr
lotw_wkfl
lot_mstr
ls_mstr
ltrenvd_det
ltrenv_mstr
ltrznd_det
ltrzn_mstr
maxt_det
max_mstr
ma_mstr
MessageD
MessageM
mfc_ctrl
mfrel_mstr
mfscl_mstr
mfsc_ctrl
mfsd_det
mfslsd_det
mfssld_det
mfsu_mstr
MirroringGL
MirroringJournal
mnd_det
mnp_det
mnt_det
mpd_det
mph_hist
mps_mstr
mp_mstr
mrpc_ctrl
mrpp_det
mrp_det
MsgBrokerSetting
msg_mstr
mu_mstr
nfdft_det
nfd_det
nfecs_det
nfelg_hist
nfews_mstr
nf_mstr
Nomenclature
nrh_hist
nr_mstr
nsoc_ctrl
oa_det
ObjectStatus
ocm_mstr
OIAdjust
OIAdjustLn
opc_ctrl
opgl_det
opm_mstr
ops_ctrl
op_hist
OrdAllocD
OrdAllocH
OrderD
OrderM
OrderSelD
OrderSelM
pac_mstr
pald_det
pal_mstr
PartSLGM
PartWhseM
PayConf
PayFormatCode
PayFormatGroup
PayFormatType
PaymentCondition
PaymentConditionStaged
PaymentGroup
PaySel
PaySelHistory
PaySelLine
PaySelLineStage
PaySelPayCode
PaySelPrepay
pcc_ctrl
pcd_det
pckc_mstr
pcld_det
pcl_mstr
pcsc_ctrl
pctrop_det
pct_mstr
pc_mstr
Period
PeriodMark
pfc_det
pfd_det
pgc_ctrl
pgh_hist
pgm_det
pic_ctrl
pid_det
pigc_det
pigp_det
pig_mstr
pih_hist
pi_mstr
pjc_ctrl
pjd_det
pjsh_hist
pjsx_det
pjs_mstr
pjt_mstr
pj_mstr
pk_det
pld_det
pliabs_ref
plid_det
pli_mstr
plsd_det
plt_det
pl_mstr
poad_det
poa_mstr
poc_ctrl
pod_det
Posting
PostingHist
PostingLine
PostingSaf
PostingSafCombined
PostingSafHist
PostingTemplate
PostingVat
PostingVatDelay
PostingWHT
pould_det
poul_mstr
po_mstr
pp_plan
pq_mstr
prd_det
PrefixC
prh_hist
prj_mstr
profd_det
Profile
ProfileLink
ProfileType
prof_mstr
Project
ProjectGroup
ProjectSafDefault
ProjectStatus
prsd_det
prs_mstr
pr_mstr
pshc_ctrl
ps_mstr
ptat_ctrl
pta_det
ptc_det
pth_hist
pti_det
ptls_det
ptpac_det
ptp_det
ptqa_det
ptre_det
ptr_det
pts_det
ptt_det
ptv_det
pt_mstr
PurchaseCode
PurchaseGLMatrix
PurchaseType
pvod_det
pvo_mstr
qaddb_ctrl
qaddb_ver
QADFinReserved
qad_wkfl
qcc_ctrl
qcd_det
qcs_mstr
qc_mstr
QFRWCube
QFRWCubeSaf
QFRWCubeSkip
qlcoac_ctrl
qlcoad_det
qlcoa_mstr
qlc_ctrl
qlpfdv_det
qltd_det
qltr_det
qlts_det
qltx_ref
qlt_mstr
qlwr_route
ql_mstr
qob_det
qoc_ctrl
qodr_det
qod_det
qor_mstr
qo_mstr
QPostingSaf
qps_det
qro_det
qr_test
qtbl_ext
QueryCache
rbc_ctrl
rbi_det
rbm_mstr
rcc_mstr
rcf_ctrl
rcsd_det
rcsx_ref
rcs_mstr
rdf_mstr
Reason
ReceiptD
RecEntry
RecEntryLine
reg_mstr
RelStatM
ReplenC
RepListD
RepListM
RepLocM
ReportPeriod
RepSLGM
req_det
Resources
Reval
RevalDet
RevalGL
RevalGLSafCombined
RevalHeader
RevalRate
RGD
RGM
rhd_hist
rma_mstr
rmc_ctrl
rmd_det
rndc_mstr
rnd_mstr
Role
RoleResource
RoundingMethod
ro_det
rpc_ctrl
rps_mstr
rqa_mstr
rqcd_det
rqc_mstr
rqda_det
rqd_det
rqf_ctrl
rqh_hist
rqj_mstr
rql_mstr
rqm_det
rqm_mstr
rqpo_ref
rqr_mstr
rq_mstr
rsc_ctrl
rsd_det
rsn_ref
rstd_det
rst_mstr
rsud_det
rsu_mstr
rs_mstr
RunD
sab_det
sac_ctrl
sadh_hist
sad_det
Saf
SafConcept
SafStructure
SafStructureLine
SafStructureLink
sah_hist
SalesCode
SalesGLMatrix
salh_hist
sal_mstr
sap_det
sar_mstr
sa_mstr
sbc_mstr
sbd_det
sbic_ctl
sbid_det
sbi_mstr
sb_mstr
sca_mstr
scc_mstr
schd_det
sch_mstr
scs_ctrl
sct_det
scx_ref
sc_mstr
sdtd_det
sdt_mstr
sd_mstr
seoc_ctrl
seq_mstr
serc_ctrl
serd_det
serh_hist
ser_mstr
sfb_det
sfh_hist
sgad_det
sgcd_det
sgid_det
sg_mstr
SharedSet
SharedSetMergeLog
SharedSetProp
SharedSetType
shcd_det
shc_ctrl
shd_det
shft_det
ShipViaM
shm_mstr
shop_cal
ShortcutAct
shpc_ctrl
shpd_hist
shphr_det
shphvd_det
shphvpv_det
shphv_det
shph_hist
shpordh_hist
shpschh_hist
shpserh_hist
shpsobh_hist
shp_hist
shtr_det
shv_mstr
sigd_det
sim_det
six_ref
si_mstr
SLGListD
SLGListM
SLGM
SLGUMD
slrd_det
slr_mstr
sm_mstr
sob_det
socc_mstr
soc_ctrl
SODAudit
SODCategory
sodctg_mstr
SODException
SODExceptionLn
SODExclusion
sodlc_det
SODLog
sodm_det
sodped_det
sodpe_mstr
sodrc_det
sodr_det
SODViolation1
SODViolation1R
SODViolation2
SODViolation2R
sodv_hist
sod_det
sop_det
sor_mstr
sosrd_det
sosr_mstr
so_mstr
spc_ctrl
spd_det
sph_hist
spt_det
sp_mstr
srand_det
sran_mstr
src_ctrl
srg_mstr
sroc_ctrl
sro_mstr
srr_mstr
sr_wkfl
ssd_det
ssm_mstr
State
Statistic
sttqd_det
sttq_mstr
stx_mstr
sufd_det
suf_mstr
svc_ctrl
sv_mstr
swc_det
SysProperty
Syst
SystemC
sytf_mstr
tag_mstr
TaskAssD
TaskAssM
TaskD
TaskM
TaxReg
TaxRegCompany
TaxRegJournal
tblcd_det
tblc_mstr
tbl_mstr
TemplateD
TemplateM
te_mstr
tm_mstr
totd_det
tot_mstr
TrackingD
TranD
TranH
TransactionType
TransportMeans
TranTypeM
TranW
trcs_det
trgl_det
trld_det
trl_mstr
trq_mstr
tr_hist
tx2d_det
tx2_mstr
txbd_det
txcl_mstr
txc_ctrl
txed_det
txenv_mstr
txe_mstr
txhd_det
txty_mstr
txud_det
txu_mstr
txz_mstr
typ_mstr
tzod_det
tzo_mstr
UDCConfig
udd_det
ufd_det
UMGroupD
UMGroupM
umsg_det
um_mstr
upd_det
urd_det
url_mstr
ursc_det
ur_mstr
UserD
UserGroupD
UserGroupM
UserM
UserSysM
UserWLGM
usg_det
uslh_hist
uspw_hist
Usr
UsrCompany
usrc_ctrl
UsrDomain
usrgd_det
usrgm_det
usrg_mstr
usrl_det
UsrProperty
UsrRole
UsrRoleCompany
UsrRoleDomain
UsrRoleScope
usrw_wkfl
usr_mstr
Vat
VatBox
VatExport
VatGroup
VatGroupBoxLink
VatNumber
VatPercent
VatPercentLine
VatPeriod
VatRule
vdf_mstr
vd_mstr
vecd_det
vec_mstr
vee_mstr
vef_ctrl
VendPartM
vepd_det
vep_mstr
VerbH
verd_det
VerifyStatusTrans
ver_mstr
vesd_det
ves_mstr
vew_mstr
vex_mstr
vph_hist
vpo_det
vp_mstr
vw_mstr
WaveC
WaveD
WaveLoadD
WaveM
WaveMasterM
WaveTranspC
wcr_route
wc_mstr
whl_mstr
WhseC
WhseListD
WhseListM
WhseM
WhseTferOrdD
WhseTferOrdM
WhseTrTypeM
WHT
WHTCertFormat
wlbd_det
wlbm_mstr
wlc_ctrl
wld_det
WLGM
wlrd_det
wlrm_mstr
wlt_mstr
wl_mstr
woc_ctrl
wod_det
wopd_det
wopm_det
wopr_det
WorkClass
WorkLoadD
WorkLoadM
wo_mstr
wr_route
wtx_mstr
YearClosing
Database Definitions Change Summary
YearClosing