Powered by InfoCaptor


Previous Page   Next Page

Claims
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.OZF_CLAIMS_VUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Account name Claims.Account nameACCOUNT_NAMEACCOUNT_NAME114224
Account number Claims.Account numberACCOUNT_NUMBERACCOUNT_NUMBER114246
Acctd amount Claims.Acctd amountACCTD_AMOUNTACCTD_AMOUNT114377
Acctd amount adjusted Claims.Acctd amount adjustedACCTD_AMOUNT_ADJUSTEDACCTD_AMOUNT_ADJUSTED114380
Acctd amount remaining Claims.Acctd amount remainingACCTD_AMOUNT_REMAININGACCTD_AMOUNT_REMAINING114381
Acctd amount settled Claims.Acctd amount settledACCTD_AMOUNT_SETTLEDACCTD_AMOUNT_SETTLED114383
Acctd tax amount Claims.Acctd tax amountACCTD_TAX_AMOUNTACCTD_TAX_AMOUNT114392
Amount Claims.AmountAMOUNTAMOUNT115878
Amount adjusted Claims.Amount adjustedAMOUNT_ADJUSTEDAMOUNT_ADJUSTED115884
Amount applied Claims.Amount appliedAMOUNT_APPLIEDAMOUNT_APPLIED115888
Amount remaining Claims.Amount remainingAMOUNT_REMAININGAMOUNT_REMAINING115908
Amount settled Claims.Amount settledAMOUNT_SETTLEDAMOUNT_SETTLED115910
Applied receipt id Claims.Applied receipt idAPPLIED_RECEIPT_IDAPPLIED_RECEIPT_ID116261
Applied receipt number Claims.Applied receipt numberAPPLIED_RECEIPT_NUMBERAPPLIED_RECEIPT_NUMBER116262
Attribute category Claims.Attribute categoryATTRIBUTE_CATEGORYATTRIBUTE_CATEGORY118542
Attribute1 Claims.Attribute1ATTRIBUTE1ATTRIBUTE1117062
Attribute10 Claims.Attribute10ATTRIBUTE10ATTRIBUTE10117139
Attribute11 Claims.Attribute11ATTRIBUTE11ATTRIBUTE11117219
Attribute12 Claims.Attribute12ATTRIBUTE12ATTRIBUTE12117296
Attribute13 Claims.Attribute13ATTRIBUTE13ATTRIBUTE13117373
Attribute14 Claims.Attribute14ATTRIBUTE14ATTRIBUTE14117450
Attribute15 Claims.Attribute15ATTRIBUTE15ATTRIBUTE15117527
Attribute2 Claims.Attribute2ATTRIBUTE2ATTRIBUTE2117669
Attribute3 Claims.Attribute3ATTRIBUTE3ATTRIBUTE3117794
Attribute4 Claims.Attribute4ATTRIBUTE4ATTRIBUTE4117902
Attribute5 Claims.Attribute5ATTRIBUTE5ATTRIBUTE5118010
Attribute6 Claims.Attribute6ATTRIBUTE6ATTRIBUTE6118117
Attribute7 Claims.Attribute7ATTRIBUTE7ATTRIBUTE7118224
Attribute8 Claims.Attribute8ATTRIBUTE8ATTRIBUTE8118331
Attribute9 Claims.Attribute9ATTRIBUTE9ATTRIBUTE9118438
Batch id Claims.Batch idBATCH_IDBATCH_ID119378
Batch type Claims.Batch typeBATCH_TYPEBATCH_TYPE119428
Broker id Claims.Broker idBROKER_IDBROKER_ID120278
Claim class Claims.Claim classCLAIM_CLASSCLAIM_CLASS122091
Claim class meaning Claims.Claim class meaningCLAIM_CLASS_MEANINGCLAIM_CLASS_MEANING122092
Claim date Claims.Claim dateCLAIM_DATECLAIM_DATE122095
Claim id Claims.Claim idCLAIM_IDCLAIM_ID122096
Claim number Claims.Claim numberCLAIM_NUMBERCLAIM_NUMBER122099
Claim type id Claims.Claim type idCLAIM_TYPE_IDCLAIM_TYPE_ID122100
Claim type name Claims.Claim type nameCLAIM_TYPE_NAMECLAIM_TYPE_NAME122101
Comments Claims.CommentsCOMMENTSCOMMENTS122538
Contact id Claims.Contact idCONTACT_IDCONTACT_ID123204
Created By Claims.Created ByCREATED_BYCREATED_BY273921
Created from Claims.Created fromCREATED_FROMCREATED_FROM125438
Creation Date Claims.Creation DateCREATION_DATECREATION_DATE273920
Currency code Claims.Currency codeCURRENCY_CODECURRENCY_CODE127034
Cust account id Claims.Cust account idCUST_ACCOUNT_IDCUST_ACCOUNT_ID127828
Cust billto acct site id Claims.Cust billto acct site idCUST_BILLTO_ACCT_SITE_IDCUST_BILLTO_ACCT_SITE_ID127830
Cust shipto acct site id Claims.Cust shipto acct site idCUST_SHIPTO_ACCT_SITE_IDCUST_SHIPTO_ACCT_SITE_ID127844
Custom setup id Claims.Custom setup idCUSTOM_SETUP_IDCUSTOM_SETUP_ID127824
Customer reason Claims.Customer reasonCUSTOMER_REASONCUSTOMER_REASON127746
Customer ref date Claims.Customer ref dateCUSTOMER_REF_DATECUSTOMER_REF_DATE127749
Customer ref normalized Claims.Customer ref normalizedCUSTOMER_REF_NORMALIZEDCUSTOMER_REF_NORMALIZED127750
Customer ref number Claims.Customer ref numberCUSTOMER_REF_NUMBERCUSTOMER_REF_NUMBER127751
Deduction attribute category Claims.Deduction attribute categoryDEDUCTION_ATTRIBUTE_CATEGORYDEDUCTION_ATTRIBUTE_CATEGORY128768
Deduction attribute1 Claims.Deduction attribute1DEDUCTION_ATTRIBUTE1DEDUCTION_ATTRIBUTE1128753
Deduction attribute10 Claims.Deduction attribute10DEDUCTION_ATTRIBUTE10DEDUCTION_ATTRIBUTE10128754
Deduction attribute11 Claims.Deduction attribute11DEDUCTION_ATTRIBUTE11DEDUCTION_ATTRIBUTE11128755
Deduction attribute12 Claims.Deduction attribute12DEDUCTION_ATTRIBUTE12DEDUCTION_ATTRIBUTE12128756
Deduction attribute13 Claims.Deduction attribute13DEDUCTION_ATTRIBUTE13DEDUCTION_ATTRIBUTE13128757
Deduction attribute14 Claims.Deduction attribute14DEDUCTION_ATTRIBUTE14DEDUCTION_ATTRIBUTE14128758
Deduction attribute15 Claims.Deduction attribute15DEDUCTION_ATTRIBUTE15DEDUCTION_ATTRIBUTE15128759
Deduction attribute2 Claims.Deduction attribute2DEDUCTION_ATTRIBUTE2DEDUCTION_ATTRIBUTE2128760
Deduction attribute3 Claims.Deduction attribute3DEDUCTION_ATTRIBUTE3DEDUCTION_ATTRIBUTE3128761
Deduction attribute4 Claims.Deduction attribute4DEDUCTION_ATTRIBUTE4DEDUCTION_ATTRIBUTE4128762
Deduction attribute5 Claims.Deduction attribute5DEDUCTION_ATTRIBUTE5DEDUCTION_ATTRIBUTE5128763
Deduction attribute6 Claims.Deduction attribute6DEDUCTION_ATTRIBUTE6DEDUCTION_ATTRIBUTE6128764
Deduction attribute7 Claims.Deduction attribute7DEDUCTION_ATTRIBUTE7DEDUCTION_ATTRIBUTE7128765
Deduction attribute8 Claims.Deduction attribute8DEDUCTION_ATTRIBUTE8DEDUCTION_ATTRIBUTE8128766
Deduction attribute9 Claims.Deduction attribute9DEDUCTION_ATTRIBUTE9DEDUCTION_ATTRIBUTE9128767
Due date Claims.Due dateDUE_DATEDUE_DATE130642
Duplicate claim id Claims.Duplicate claim idDUPLICATE_CLAIM_IDDUPLICATE_CLAIM_ID130656
Exchange rate Claims.Exchange rateEXCHANGE_RATEEXCHANGE_RATE133789
Exchange rate date Claims.Exchange rate dateEXCHANGE_RATE_DATEEXCHANGE_RATE_DATE133795
Exchange rate type Claims.Exchange rate typeEXCHANGE_RATE_TYPEEXCHANGE_RATE_TYPE133805
Group claim id Claims.Group claim idGROUP_CLAIM_IDGROUP_CLAIM_ID135512
History event Claims.History eventHISTORY_EVENTHISTORY_EVENT135821
History event date Claims.History event dateHISTORY_EVENT_DATEHISTORY_EVENT_DATE135822
History event description Claims.History event descriptionHISTORY_EVENT_DESCRIPTIONHISTORY_EVENT_DESCRIPTION135823
Last Update Date Claims.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE273918
Last Update Login Claims.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN273922
Last Updated By Claims.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY273919
Object Version Number Claims.Object Version NumberOBJECT_VERSION_NUMBEROBJECT_VERSION_NUMBER273917
Order type id Claims.Order type idORDER_TYPE_IDORDER_TYPE_ID149918
Org id Claims.Org idORG_IDORG_ID150982
Original claim date Claims.Original claim dateORIGINAL_CLAIM_DATEORIGINAL_CLAIM_DATE151186
Owner id Claims.Owner idOWNER_IDOWNER_ID151755
Program Application Id Claims.Program Application IdPROGRAM_APPLICATION_IDPROGRAM_APPLICATION_ID273924
Program Id Claims.Program IdPROGRAM_IDPROGRAM_ID273926
Program Update Date Claims.Program Update DatePROGRAM_UPDATE_DATEPROGRAM_UPDATE_DATE273925
Reason code id Claims.Reason code idREASON_CODE_IDREASON_CODE_ID157946
Receipt id Claims.Receipt idRECEIPT_IDRECEIPT_ID157987
Receipt number Claims.Receipt numberRECEIPT_NUMBERRECEIPT_NUMBER158018
Request Id Claims.Request IdREQUEST_IDREQUEST_ID273923
Root claim id Claims.Root claim idROOT_CLAIM_IDROOT_CLAIM_ID159777
Sales rep id Claims.Sales rep idSALES_REP_IDSALES_REP_ID160691
Set of books id Claims.Set of books idSET_OF_BOOKS_IDSET_OF_BOOKS_ID161520
Ship to cust account id Claims.Ship to cust account idSHIP_TO_CUST_ACCOUNT_IDSHIP_TO_CUST_ACCOUNT_ID161899
Source object class Claims.Source object classSOURCE_OBJECT_CLASSSOURCE_OBJECT_CLASS162455
Source object id Claims.Source object idSOURCE_OBJECT_IDSOURCE_OBJECT_ID162457
Source object number Claims.Source object numberSOURCE_OBJECT_NUMBERSOURCE_OBJECT_NUMBER162460
Source object type id Claims.Source object type idSOURCE_OBJECT_TYPE_IDSOURCE_OBJECT_TYPE_ID162461
Split date Claims.Split dateSPLIT_DATESPLIT_DATE162697
Split from claim id Claims.Split from claim idSPLIT_FROM_CLAIM_IDSPLIT_FROM_CLAIM_ID162701
Status code Claims.Status codeSTATUS_CODESTATUS_CODE163547
Task template group id Claims.Task template group idTASK_TEMPLATE_GROUP_IDTASK_TEMPLATE_GROUP_ID164683
Tax amount Claims.Tax amountTAX_AMOUNTTAX_AMOUNT164696
Under write off threshold Claims.Under write off thresholdUNDER_WRITE_OFF_THRESHOLDUNDER_WRITE_OFF_THRESHOLD166216
User status id Claims.User status idUSER_STATUS_IDUSER_STATUS_ID166960
User status name Claims.User status nameUSER_STATUS_NAMEUSER_STATUS_NAME166963
Wo rec trx id Claims.Wo rec trx idWO_REC_TRX_IDWO_REC_TRX_ID168047
Write off flag Claims.Write off flagWRITE_OFF_FLAGWRITE_OFF_FLAG168054
Write off threshold amount Claims.Write off threshold amountWRITE_OFF_THRESHOLD_AMOUNTWRITE_OFF_THRESHOLD_AMOUNT168055
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto