Powered by InfoCaptor


Previous Page   Next Page

Credit Memos
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_CREDIT_MEMO_ARSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Credit Memos. GLOBAL_FLEX_ORIGINAL_TRANSAC_9GLOBAL_FLEX_ORIGINAL_TRANSAC_9266811
1 Credit Memos. 1GLOBAL_FLEX_ORIGINAL_TRANSA_10GLOBAL_FLEX_ORIGINAL_TRANSA_10266816
2 Credit Memos. 2GLOBAL_FLEX_ORIGINAL_TRANSA_11GLOBAL_FLEX_ORIGINAL_TRANSA_11266818
Agreement Number Credit Memos.Agreement NumberINVOICE_TRANS_AGREEMENT_NUMB_2INVOICE_TRANS_AGREEMENT_NUMB_2266775
BANK_ACCOUNT_NUMBER Credit Memos.BANK_ACCOUNT_NUMBERGLOBAL_FLEX_BANK_ACCOUNT_NUM_8GLOBAL_FLEX_BANK_ACCOUNT_NUM_8266809
Batch IdSurrogate key for the batch for which results are recorded.Credit Memos.Batch IdBATCH_IDBATCH_ID119374
Batch Name Credit Memos.Batch NameBATCH_NAMEBATCH_NAME119398
Bill To Contact IdUnique Identifier for Bill To ContactCredit Memos.Bill To Contact IdBILL_TO_CONTACT_IDBILL_TO_CONTACT_ID119891
Bill To Contact Name Credit Memos.Bill To Contact NameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119899
Bill To Customer Credit Memos.Bill To CustomerBILL_TO_CUSTOMERBILL_TO_CUSTOMER119911
Bill To Customer IdUnique Identifier for Bill To CustomerCredit Memos.Bill To Customer IdBILL_TO_CUSTOMER_IDBILL_TO_CUSTOMER_ID119918
Bill To Site Credit Memos.Bill To SiteBILL_TO_SITEBILL_TO_SITE119957
Bill To Site Use IdUnique Identifier for Bill To Site UseCredit Memos.Bill To Site Use IdBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119966
Bill-to Party ID Credit Memos.Bill-to Party IDINVOICE_TRANS_BILL_TO_PARTY__4INVOICE_TRANS_BILL_TO_PARTY__4266782
Billing Interface Request ID Credit Memos.Billing Interface Request IDINVOICE_TRANS_BILLING_INTERF_3INVOICE_TRANS_BILLING_INTERF_3266780
Billing Party ID Credit Memos.Billing Party IDINVOICE_TRANS_BILLING_PARTY__3INVOICE_TRANS_BILLING_PARTY__3266778
Billing Period Credit Memos.Billing PeriodINVOICE_TRANS_BILLING_PERIOD_3INVOICE_TRANS_BILLING_PERIOD_3266781
Billing Site Use ID Credit Memos.Billing Site Use IDINVOICE_TRANS_BILLING_SITE_U_3INVOICE_TRANS_BILLING_SITE_U_3266779
CAI_DUE_DATE Credit Memos.CAI_DUE_DATEGLOBAL_FLEX_CAI_DUE_DATE_9GLOBAL_FLEX_CAI_DUE_DATE_9266813
CAI_NUMBER Credit Memos.CAI_NUMBERGLOBAL_FLEX_CAI_NUMBER_9GLOBAL_FLEX_CAI_NUMBER_9266812
Claim Number Credit Memos.Claim NumberINVOICE_TRANS_CLAIM_NUMBER_6INVOICE_TRANS_CLAIM_NUMBER_6266784
Claim Reason Credit Memos.Claim ReasonINVOICE_TRANS_CLAIM_REASON_6INVOICE_TRANS_CLAIM_REASON_6266787
Complete Flag Credit Memos.Complete FlagCOMPLETE_FLAGCOMPLETE_FLAG266763
Context Value Credit Memos.Context ValueTRANS_INFO_CONTEXT_VALUETRANS_INFO_CONTEXT_VALUE266770
Context Value 1 Credit Memos.Context Value 1INVOICE_TRANS_CONTEXT_VALUEINVOICE_TRANS_CONTEXT_VALUE266772
Context Value 2 Credit Memos.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266788
Copy Status Credit Memos.Copy StatusGLOBAL_FLEX_COPY_STATUS_9GLOBAL_FLEX_COPY_STATUS_9266810
Copy Status 1 Credit Memos.Copy Status 1GLOBAL_FLEX_COPY_STATUS_10GLOBAL_FLEX_COPY_STATUS_10266815
Copy Status 2 Credit Memos.Copy Status 2GLOBAL_FLEX_COPY_STATUS_11GLOBAL_FLEX_COPY_STATUS_11266817
Correction Credit Memos.CorrectionGLOBAL_FLEX_CORRECTION_PERIO_3GLOBAL_FLEX_CORRECTION_PERIO_3266792
Correction Year Credit Memos.Correction YearGLOBAL_FLEX_CORRECTION_YEAR_3GLOBAL_FLEX_CORRECTION_YEAR_3266791
Created ByStandard WHO column.Credit Memos.Created ByCREATED_BYCREATED_BY124532
Creation DateStandard WHO column.Credit Memos.Creation DateCREATION_DATECREATION_DATE125964
Creation Date - Day Credit Memos.Creation Date CREATION_DATE_DAY172095
Creation Date - Month Credit Memos.Creation Date CREATION_DATE_MONTH172549
Creation Date - Quarter Credit Memos.Creation Date CREATION_DATE_QUARTER173003
Creation Date - Year Credit Memos.Creation Date CREATION_DATE_YEAR173457
Credited Transaction Number Credit Memos.Credited Transaction NumberCREDITED_TRANSACTION_NUMBERCREDITED_TRANSACTION_NUMBER126704
Currency Exchange RateExchange rate for foreign currency payments.Credit Memos.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127198
Currency Exchange Rate Date Credit Memos.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127209
Currency Exchange Rate Date - Day Credit Memos.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174198
Currency Exchange Rate Date - Month Credit Memos.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174214
Currency Exchange Rate Date - Quarter Credit Memos.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174230
Currency Exchange Rate Date - Year Credit Memos.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174246
Currency Exchange Rate TypeExchange rate type for foreign currency payments.Credit Memos.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127222
Cust Trx Type IdUnique Identifier for Customer Transaction TypeCredit Memos.Cust Trx Type IdCUST_TRX_TYPE_IDCUST_TRX_TYPE_ID127855
Customer Bank Account IDUnique Identifier for Customer Bank AccountCredit Memos.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127528
Customer Bank Account Name Credit Memos.Customer Bank Account NameCUSTOMER_BANK_ACCOUNT_NAMECUSTOMER_BANK_ACCOUNT_NAME127536
Customer Bank Account NumberCustomer Bank Account NumberCredit Memos.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127543
Customer Reason Credit Memos.Customer ReasonINVOICE_TRANS_CUSTOMER_REASO_6INVOICE_TRANS_CUSTOMER_REASO_6266786
Customer Reference Credit Memos.Customer ReferenceINVOICE_TRANS_CUSTOMER_REFER_6INVOICE_TRANS_CUSTOMER_REFER_6266785
Deductible Type Credit Memos.Deductible TypeGLOBAL_FLEX_DEDUCTIBLE_TYPE_5GLOBAL_FLEX_DEDUCTIBLE_TYPE_5266798
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.Credit Memos.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130359
Draft Invoice Number Credit Memos.Draft Invoice NumberINVOICE_TRANS_DRAFT_INVOICE__2INVOICE_TRANS_DRAFT_INVOICE__2266774
Due DateRequired batch completion date/time, notational.Credit Memos.Due DateDUE_DATEDUE_DATE130636
Due Date - Day Credit Memos.Due Date DUE_DATE_DAY176343
Due Date - Month Credit Memos.Due Date DUE_DATE_MONTH176359
Due Date - Quarter Credit Memos.Due Date DUE_DATE_QUARTER176375
Due Date - Year Credit Memos.Due Date DUE_DATE_YEAR176391
Edi Processed Flag Credit Memos.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG266768
Export Certificate Number Credit Memos.Export Certificate NumberGLOBAL_FLEX_EXPORT_CERTIFICA_5GLOBAL_FLEX_EXPORT_CERTIFICA_5266799
Export Date Credit Memos.Export DateGLOBAL_FLEX_EXPORT_DATE_5GLOBAL_FLEX_EXPORT_DATE_5266803
Export Method Credit Memos.Export MethodGLOBAL_FLEX_EXPORT_METHOD_5GLOBAL_FLEX_EXPORT_METHOD_5266801
Export Name Credit Memos.Export NameGLOBAL_FLEX_EXPORT_NAME_5GLOBAL_FLEX_EXPORT_NAME_5266800
Export Type Credit Memos.Export TypeGLOBAL_FLEX_EXPORT_TYPE_5GLOBAL_FLEX_EXPORT_TYPE_5266802
Finance Charges Flag Credit Memos.Finance Charges FlagFINANCE_CHARGES_FLAGFINANCE_CHARGES_FLAG266765
First Print Date Credit Memos.First Print DateFIRST_PRINT_DATEFIRST_PRINT_DATE134386
First Print Date - Day Credit Memos.First Print Date FIRST_PRINT_DATE_DAY179557
First Print Date - Month Credit Memos.First Print Date FIRST_PRINT_DATE_MONTH179569
First Print Date - Quarter Credit Memos.First Print Date FIRST_PRINT_DATE_QUARTER179581
First Print Date - Year Credit Memos.First Print Date FIRST_PRINT_DATE_YEAR179593
Fob Point Credit Memos.Fob PointFOB_POINTFOB_POINT266767
Freight Accessory Expense Credit Memos.Freight Accessory ExpenseGLOBAL_FLEX_FREIGHT_ACC_EXP_12GLOBAL_FLEX_FREIGHT_ACC_EXP_12266827
Freight CarrierName of shipping firm.Credit Memos.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134658
GUI Type Credit Memos.GUI TypeGLOBAL_FLEX_GUI_TYPE_5GLOBAL_FLEX_GUI_TYPE_5266796
Grace Days Credit Memos.Grace DaysGLOBAL_FLEX_GRACE_DAYS_12GLOBAL_FLEX_GRACE_DAYS_12266823
ISS_DATE Credit Memos.ISS_DATEGLOBAL_FLEX_ISS_DATE_12GLOBAL_FLEX_ISS_DATE_12266836
Insurance Accessory Expense Credit Memos.Insurance Accessory ExpenseGLOBAL_FLEX_INSURANCE_ACC_E_12GLOBAL_FLEX_INSURANCE_ACC_E_12266828
Interest Formula Credit Memos.Interest FormulaGLOBAL_FLEX_INTEREST_FORMUL_12GLOBAL_FLEX_INTEREST_FORMUL_12266822
Interest Period Credit Memos.Interest PeriodGLOBAL_FLEX_INTEREST_PERIOD_12GLOBAL_FLEX_INTEREST_PERIOD_12266821
Interest Rate/Amount Credit Memos.Interest Rate/AmountGLOBAL_FLEX_INTEREST_RATE_A_12GLOBAL_FLEX_INTEREST_RATE_A_12266820
Interest Type Credit Memos.Interest TypeGLOBAL_FLEX_INTEREST_TYPE_12GLOBAL_FLEX_INTEREST_TYPE_12266819
Invoice Type Credit Memos.Invoice TypeGLOBAL_FLEX_INVOICE_TYPE_2GLOBAL_FLEX_INVOICE_TYPE_2266789
Invoice Type 1 Credit Memos.Invoice Type 1GLOBAL_FLEX_INVOICE_TYPE_3GLOBAL_FLEX_INVOICE_TYPE_3266790
Invoice Type 2 Credit Memos.Invoice Type 2GLOBAL_FLEX_INVOICE_TYPE_4GLOBAL_FLEX_INVOICE_TYPE_4266794
Invoice Type 3 Credit Memos.Invoice Type 3GLOBAL_FLEX_INVOICE_TYPE_14GLOBAL_FLEX_INVOICE_TYPE_14266837
Invoice Type 4 Credit Memos.Invoice Type 4GLOBAL_FLEX_INVOICE_TYPE_17GLOBAL_FLEX_INVOICE_TYPE_17266839
Invoice Type 5 Credit Memos.Invoice Type 5GLOBAL_FLEX_INVOICE_TYPE_18GLOBAL_FLEX_INVOICE_TYPE_18266840
Issue Date Credit Memos.Issue DateGLOBAL_FLEX_ISSUE_DATE_12GLOBAL_FLEX_ISSUE_DATE_12266826
Last Print Date Credit Memos.Last Print DateLAST_PRINT_DATELAST_PRINT_DATE138598
Last Print Date - Day Credit Memos.Last Print Date LAST_PRINT_DATE_DAY182456
Last Print Date - Month Credit Memos.Last Print Date LAST_PRINT_DATE_MONTH182472
Last Print Date - Quarter Credit Memos.Last Print Date LAST_PRINT_DATE_QUARTER182488
Last Print Date - Year Credit Memos.Last Print Date LAST_PRINT_DATE_YEAR182504
Last Update DateStandard WHO column.Credit Memos.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140495
Last Update Date - Day Credit Memos.Last Update Date LAST_UPDATE_DATE_DAY183500
Last Update Date - Month Credit Memos.Last Update Date LAST_UPDATE_DATE_MONTH183928
Last Update Date - Quarter Credit Memos.Last Update Date LAST_UPDATE_DATE_QUARTER184356
Last Update Date - Year Credit Memos.Last Update Date LAST_UPDATE_DATE_YEAR184784
Last Updated ByStandard WHO column.Credit Memos.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139156
Legacy Uniform Invoice Credit Memos.Legacy Uniform InvoiceGLOBAL_FLEX_LEGACY_UNIFORM_I_5GLOBAL_FLEX_LEGACY_UNIFORM_I_5266805
License Plate Credit Memos.License PlateGLOBAL_FLEX_LICENSE_PLATE_12GLOBAL_FLEX_LICENSE_PLATE_12266830
NUMERIC_BAR_CODE Credit Memos.NUMERIC_BAR_CODEGLOBAL_FLEX_NUMERIC_BAR_CODE_9GLOBAL_FLEX_NUMERIC_BAR_CODE_9266814
Operating Unit Credit Memos.Operating UnitOPERATING_UNITOPERATING_UNIT149497
Organization IDOrganization identifier.Credit Memos.Organization IDORG_IDORG_ID150924
Original System Batch Name Credit Memos.Original System Batch NameORIGINAL_SYSTEM_BATCH_NAMEORIGINAL_SYSTEM_BATCH_NAME151227
Original Transaction Number Credit Memos.Original Transaction NumberGLOBAL_FLEX_ORIGINAL_TRANSAC_5GLOBAL_FLEX_ORIGINAL_TRANSAC_5266804
Other Accessory Expenses Credit Memos.Other Accessory ExpensesGLOBAL_FLEX_OTHER_ACC_EXP_12GLOBAL_FLEX_OTHER_ACC_EXP_12266829
Paying Customer Credit Memos.Paying CustomerPAYING_CUSTOMERPAYING_CUSTOMER152157
Paying Customer IdUnique Identifier for Paying CustomerCredit Memos.Paying Customer IdPAYING_CUSTOMER_IDPAYING_CUSTOMER_ID152163
Paying Site Credit Memos.Paying SitePAYING_SITEPAYING_SITE152170
Paying Site Use IdUnique Identifier for Paying Site UseCredit Memos.Paying Site Use IdPAYING_SITE_USE_IDPAYING_SITE_USE_ID152176
Payment MethodPayment Method selection criterion.Credit Memos.Payment MethodPAYMENT_METHODPAYMENT_METHOD152222
Payment Term Name Credit Memos.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152303
Penalty Rate/Amount Credit Memos.Penalty Rate/AmountGLOBAL_FLEX_PENALTY_RATE_AM_12GLOBAL_FLEX_PENALTY_RATE_AM_12266825
Penalty Type Credit Memos.Penalty TypeGLOBAL_FLEX_PENALTY_TYPE_12GLOBAL_FLEX_PENALTY_TYPE_12266824
Pending Print Flag Credit Memos.Pending Print FlagPENDING_PRINT_FLAGPENDING_PRINT_FLAG266769
Previous Customer Trx IdUnique Identifier for Previous Customer TransactionCredit Memos.Previous Customer Trx IdPREVIOUS_CUSTOMER_TRX_IDPREVIOUS_CUSTOMER_TRX_ID155229
Primary Salesrep IdUnique Identifier for Primary SalesrepCredit Memos.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155571
Printing Count Credit Memos.Printing CountPRINTING_COUNTPRINTING_COUNT155625
Project Manager Credit Memos.Project ManagerINVOICE_TRANS_PROJECT_MANAGE_2INVOICE_TRANS_PROJECT_MANAGE_2266777
Project Number Credit Memos.Project NumberINVOICE_TRANS_PROJECT_NUMBER_2INVOICE_TRANS_PROJECT_NUMBER_2266773
Project Organization Credit Memos.Project OrganizationINVOICE_TRANS_PROJECT_ORGANI_2INVOICE_TRANS_PROJECT_ORGANI_2266776
Property Location Credit Memos.Property LocationGLOBAL_FLEX_PROPERTY_LOCATIO_4GLOBAL_FLEX_PROPERTY_LOCATIO_4266795
Property Location 1 Credit Memos.Property Location 1GLOBAL_FLEX_PROPERTY_LOCATI_18GLOBAL_FLEX_PROPERTY_LOCATI_18266841
Purchase Order Date Credit Memos.Purchase Order DatePURCHASE_ORDER_DATEPURCHASE_ORDER_DATE157045
Purchase Order Date - Day Credit Memos.Purchase Order Date PURCHASE_ORDER_DATE_DAY189243
Purchase Order Date - Month Credit Memos.Purchase Order Date PURCHASE_ORDER_DATE_MONTH189255
Purchase Order Date - Quarter Credit Memos.Purchase Order Date PURCHASE_ORDER_DATE_QUARTER189267
Purchase Order Date - Year Credit Memos.Purchase Order Date PURCHASE_ORDER_DATE_YEAR189279
Purchase Order Number Credit Memos.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157063
Purchase Order Revision Credit Memos.Purchase Order RevisionPURCHASE_ORDER_REVISIONPURCHASE_ORDER_REVISION157074
Reason Code Credit Memos.Reason CodeREASON_CODEREASON_CODE157935
Receipt Method IdUnique Identifier for Receipt MethodCredit Memos.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID157999
Reference Number Credit Memos.Reference NumberREFERENCE_NUMBERREFERENCE_NUMBER158287
Remit To Address Credit Memos.Remit To AddressREMIT_TO_ADDRESSREMIT_TO_ADDRESS158544
Remit To Address IdUnique Identifier for Remit To AddressCredit Memos.Remit To Address IdREMIT_TO_ADDRESS_IDREMIT_TO_ADDRESS_ID158550
Sales Order Credit Memos.Sales OrderINVOICE_TRANS_SALES_ORDER_NU_5INVOICE_TRANS_SALES_ORDER_NU_5266783
Salesperson Name Credit Memos.Salesperson NameSALESPERSON_NAMESALESPERSON_NAME160579
Ship Date Credit Memos.Ship DateSHIP_DATESHIP_DATE161785
Ship Date - Day Credit Memos.Ship Date SHIP_DATE_DAY190456
Ship Date - Month Credit Memos.Ship Date SHIP_DATE_MONTH190472
Ship Date - Quarter Credit Memos.Ship Date SHIP_DATE_QUARTER190488
Ship Date - Year Credit Memos.Ship Date SHIP_DATE_YEAR190504
Ship To Contact IdUnique Identifier for Ship To ContactCredit Memos.Ship To Contact IdSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161862
Ship To Contact Name Credit Memos.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161873
Ship To Customer Credit Memos.Ship To CustomerSHIP_TO_CUSTOMERSHIP_TO_CUSTOMER161886
Ship To Customer IdUnique Identifier for Ship To CustomerCredit Memos.Ship To Customer IdSHIP_TO_CUSTOMER_IDSHIP_TO_CUSTOMER_ID161893
Ship To Site Credit Memos.Ship To SiteSHIP_TO_SITESHIP_TO_SITE161995
Ship To Site Use IdUnique Identifier for Ship To Site UseCredit Memos.Ship To Site Use IdSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162023
Shipping Reference Credit Memos.Shipping ReferenceSHIPPING_REFERENCESHIPPING_REFERENCE161769
Sold To Contact IdUnique Identifier for Sold To ContactCredit Memos.Sold To Contact IdSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162242
Sold To Contact Name Credit Memos.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162251
Sold To Customer Credit Memos.Sold To CustomerSOLD_TO_CUSTOMERSOLD_TO_CUSTOMER162259
Sold To Customer IdUnique Identifier for Sold To CustomerCredit Memos.Sold To Customer IdSOLD_TO_CUSTOMER_IDSOLD_TO_CUSTOMER_ID162265
Sold To Site Credit Memos.Sold To SiteSOLD_TO_SITESOLD_TO_SITE162278
Sold To Site Use IdUnique Identifier for Sold To Site UseCredit Memos.Sold To Site Use IdSOLD_TO_SITE_USE_IDSOLD_TO_SITE_USE_ID162284
TAX_DATE Credit Memos.TAX_DATEGLOBAL_FLEX_TAX_DATE_6GLOBAL_FLEX_TAX_DATE_6266806
TAX_DATE 1 Credit Memos.TAX_DATE 1GLOBAL_FLEX_TAX_DATE_7GLOBAL_FLEX_TAX_DATE_7266807
TAX_DATE 2 Credit Memos.TAX_DATE 2GLOBAL_FLEX_TAX_DATE_8GLOBAL_FLEX_TAX_DATE_8266808
TAX_DATE 3 Credit Memos.TAX_DATE 3GLOBAL_FLEX_TAX_DATE_19GLOBAL_FLEX_TAX_DATE_19266842
Tax Exempt Flag Credit Memos.Tax Exempt FlagTAX_EXEMPT_FLAGTAX_EXEMPT_FLAG266766
Term IdUnique identifier for this payment term.Credit Memos.Term IdTERM_IDTERM_ID164971
Total Gross Weight Credit Memos.Total Gross WeightGLOBAL_FLEX_TOTAL_GR_WEIGHT_12GLOBAL_FLEX_TOTAL_GR_WEIGHT_12266834
Total Net Weight Credit Memos.Total Net WeightGLOBAL_FLEX_TOTAL_NT_WEIGHT_12GLOBAL_FLEX_TOTAL_NT_WEIGHT_12266835
Transaction Date Credit Memos.Transaction DateTRANSACTION_DATETRANSACTION_DATE165632
Transaction Date - Day Credit Memos.Transaction Date TRANSACTION_DATE_DAY192313
Transaction Date - Month Credit Memos.Transaction Date TRANSACTION_DATE_MONTH192367
Transaction Date - Quarter Credit Memos.Transaction Date TRANSACTION_DATE_QUARTER192421
Transaction Date - Year Credit Memos.Transaction Date TRANSACTION_DATE_YEAR192475
Transaction IdExternal payment/receipt identifier.Credit Memos.Transaction IdTRANSACTION_IDTRANSACTION_ID165683
Transaction Number Credit Memos.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165737
Transaction Status Credit Memos.Transaction StatusTRANSACTION_STATUSTRANSACTION_STATUS266764
Transaction Type Name Credit Memos.Transaction Type NameTRANSACTION_TYPE_NAMETRANSACTION_TYPE_NAME165871
Triangulation Credit Memos.TriangulationGLOBAL_FLEX_TRIANGULATION_3GLOBAL_FLEX_TRIANGULATION_3266793
UPS Invoice Reference Credit Memos.UPS Invoice ReferenceTRANS_INFO_UPS_INVOICE_REFERENTRANS_INFO_UPS_INVOICE_REFEREN266771
Volume Number Credit Memos.Volume NumberGLOBAL_FLEX_VOLUME_NUMBER_12GLOBAL_FLEX_VOLUME_NUMBER_12266833
Volume Quantity Credit Memos.Volume QuantityGLOBAL_FLEX_VOLUME_QUANTITY_12GLOBAL_FLEX_VOLUME_QUANTITY_12266831
Volume Type Credit Memos.Volume TypeGLOBAL_FLEX_VOLUME_TYPE_12GLOBAL_FLEX_VOLUME_TYPE_12266832
Wine/Cigarette Credit Memos.Wine/CigaretteGLOBAL_FLEX_WINE/CIGARETTE_5GLOBAL_FLEX_WINECIGARETTE_5266797
invoice Type Credit Memos.invoice TypeGLOBAL_FLEX_INVOICE_TYPE_16GLOBAL_FLEX_INVOICE_TYPE_16266838
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Credit Memos -> Customer Transaction LinesCredit Memos.Transaction Id = Customer Transaction Lines.Customer Trx IdAlways exist in master folderOuter join on detail No
Credit Memos -> Freight ChargesCredit Memos.Transaction Id = Freight Charges.Customer Trx IdAlways exist in master folderOuter join on detail No
Credit Memos -> Freight DistributionsCredit Memos.Transaction Id = Freight Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credit Memos -> Invoice AdjustmentsCredit Memos.Transaction Id = Invoice Adjustments.Customer Trx IdMight not exist in master folderOuter join on detail No
Credit Memos -> Invoice Adjustments 1Credit Memos.Transaction Id = Invoice Adjustments.Customer Trx IdAlways exist in master folderNoneNo
Credit Memos -> Payment SchedulesCredit Memos.Transaction Id = Payment Schedules.Customer Trx IdMight not exist in master folderNoneNo
Credit Memos -> Revenue DistributionsCredit Memos.Transaction Id = Revenue Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credit Memos -> Tax DistributionsCredit Memos.Transaction Id = Tax Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credit Memos -> Transaction DistributionsCredit Memos.Transaction Id = Transaction Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credit Memos -> Transaction Revenue LinesCredit Memos.Transaction Id = Transaction Revenue Lines.Customer Trx IdAlways exist in master folderOuter join on detail No
Credit Memos -> Transaction Tax LinesCredit Memos.Transaction Id = Transaction Tax Lines.Customer Trx IdAlways exist in master folderOuter join on detail No