Powered by InfoCaptor


Previous Page   Next Page

Credits
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_CREDITSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Credits. GLOBAL_FLEX_ORIGINAL_TRANSAC_9GLOBAL_FLEX_ORIGINAL_TRANSAC_9266727
1 Credits. 1GLOBAL_FLEX_ORIGINAL_TRANSA_10GLOBAL_FLEX_ORIGINAL_TRANSA_10266732
2 Credits. 2GLOBAL_FLEX_ORIGINAL_TRANSA_11GLOBAL_FLEX_ORIGINAL_TRANSA_11266734
Agreement Number Credits.Agreement NumberINVOICE_TRANS_AGREEMENT_NUMB_2INVOICE_TRANS_AGREEMENT_NUMB_2266691
BANK_ACCOUNT_NUMBER Credits.BANK_ACCOUNT_NUMBERGLOBAL_FLEX_BANK_ACCOUNT_NUM_8GLOBAL_FLEX_BANK_ACCOUNT_NUM_8266725
Batch IdSurrogate key for the batch for which results are recorded.Credits.Batch IdBATCH_IDBATCH_ID119373
Batch Name Credits.Batch NameBATCH_NAMEBATCH_NAME119397
Bill To Contact IdUnique Identifier for Bill To ContactCredits.Bill To Contact IdBILL_TO_CONTACT_IDBILL_TO_CONTACT_ID119890
Bill To Contact Name Credits.Bill To Contact NameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119898
Bill To Customer Credits.Bill To CustomerBILL_TO_CUSTOMERBILL_TO_CUSTOMER119910
Bill To Customer IdUnique Identifier for Bill To CustomerCredits.Bill To Customer IdBILL_TO_CUSTOMER_IDBILL_TO_CUSTOMER_ID119917
Bill To Site Credits.Bill To SiteBILL_TO_SITEBILL_TO_SITE119956
Bill To Site Use IdUnique Identifier for Bill To Site UseCredits.Bill To Site Use IdBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119965
Bill-to Party ID Credits.Bill-to Party IDINVOICE_TRANS_BILL_TO_PARTY__4INVOICE_TRANS_BILL_TO_PARTY__4266698
Billing Interface Request ID Credits.Billing Interface Request IDINVOICE_TRANS_BILLING_INTERF_3INVOICE_TRANS_BILLING_INTERF_3266696
Billing Party ID Credits.Billing Party IDINVOICE_TRANS_BILLING_PARTY__3INVOICE_TRANS_BILLING_PARTY__3266694
Billing Period Credits.Billing PeriodINVOICE_TRANS_BILLING_PERIOD_3INVOICE_TRANS_BILLING_PERIOD_3266697
Billing Site Use ID Credits.Billing Site Use IDINVOICE_TRANS_BILLING_SITE_U_3INVOICE_TRANS_BILLING_SITE_U_3266695
CAI_DUE_DATE Credits.CAI_DUE_DATEGLOBAL_FLEX_CAI_DUE_DATE_9GLOBAL_FLEX_CAI_DUE_DATE_9266729
CAI_NUMBER Credits.CAI_NUMBERGLOBAL_FLEX_CAI_NUMBER_9GLOBAL_FLEX_CAI_NUMBER_9266728
Claim Number Credits.Claim NumberINVOICE_TRANS_CLAIM_NUMBER_6INVOICE_TRANS_CLAIM_NUMBER_6266700
Claim Reason Credits.Claim ReasonINVOICE_TRANS_CLAIM_REASON_6INVOICE_TRANS_CLAIM_REASON_6266703
CommentsComments not printed on an invoice.Credits.CommentsCOMMENTSCOMMENTS122503
Complete Flag Credits.Complete FlagCOMPLETE_FLAGCOMPLETE_FLAG266679
Context Value Credits.Context ValueTRANS_INFO_CONTEXT_VALUETRANS_INFO_CONTEXT_VALUE266686
Context Value 1 Credits.Context Value 1INVOICE_TRANS_CONTEXT_VALUEINVOICE_TRANS_CONTEXT_VALUE266688
Context Value 2 Credits.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266704
Copy Status Credits.Copy StatusGLOBAL_FLEX_COPY_STATUS_9GLOBAL_FLEX_COPY_STATUS_9266726
Copy Status 1 Credits.Copy Status 1GLOBAL_FLEX_COPY_STATUS_10GLOBAL_FLEX_COPY_STATUS_10266731
Copy Status 2 Credits.Copy Status 2GLOBAL_FLEX_COPY_STATUS_11GLOBAL_FLEX_COPY_STATUS_11266733
Correction Credits.CorrectionGLOBAL_FLEX_CORRECTION_PERIO_3GLOBAL_FLEX_CORRECTION_PERIO_3266708
Correction Year Credits.Correction YearGLOBAL_FLEX_CORRECTION_YEAR_3GLOBAL_FLEX_CORRECTION_YEAR_3266707
Created ByStandard WHO column.Credits.Created ByCREATED_BYCREATED_BY124531
Creation DateStandard WHO column.Credits.Creation DateCREATION_DATECREATION_DATE125963
Creation Date - Day Credits.Creation Date CREATION_DATE_DAY172093
Creation Date - Month Credits.Creation Date CREATION_DATE_MONTH172547
Creation Date - Quarter Credits.Creation Date CREATION_DATE_QUARTER173001
Creation Date - Year Credits.Creation Date CREATION_DATE_YEAR173455
Currency Exchange RateExchange rate for foreign currency payments.Credits.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127197
Currency Exchange Rate Date Credits.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127208
Currency Exchange Rate Date - Day Credits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174196
Currency Exchange Rate Date - Month Credits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174212
Currency Exchange Rate Date - Quarter Credits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174228
Currency Exchange Rate Date - Year Credits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174244
Currency Exchange Rate TypeExchange rate type for foreign currency payments.Credits.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127221
Cust Trx Type IdUnique Identifier for Customer Transaction TypeCredits.Cust Trx Type IdCUST_TRX_TYPE_IDCUST_TRX_TYPE_ID127854
Customer Bank Account IDUnique Identifier for Customer Bank AccountCredits.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127527
Customer Bank Account Name Credits.Customer Bank Account NameCUSTOMER_BANK_ACCOUNT_NAMECUSTOMER_BANK_ACCOUNT_NAME127535
Customer Bank Account NumberCustomer Bank Account NumberCredits.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127542
Customer Reason Credits.Customer ReasonINVOICE_TRANS_CUSTOMER_REASO_6INVOICE_TRANS_CUSTOMER_REASO_6266702
Customer Reference Credits.Customer ReferenceINVOICE_TRANS_CUSTOMER_REFER_6INVOICE_TRANS_CUSTOMER_REFER_6266701
Deductible Type Credits.Deductible TypeGLOBAL_FLEX_DEDUCTIBLE_TYPE_5GLOBAL_FLEX_DEDUCTIBLE_TYPE_5266714
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.Credits.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130358
Draft Invoice Number Credits.Draft Invoice NumberINVOICE_TRANS_DRAFT_INVOICE__2INVOICE_TRANS_DRAFT_INVOICE__2266690
Due DateRequired batch completion date/time, notational.Credits.Due DateDUE_DATEDUE_DATE130635
Due Date - Day Credits.Due Date DUE_DATE_DAY176341
Due Date - Month Credits.Due Date DUE_DATE_MONTH176357
Due Date - Quarter Credits.Due Date DUE_DATE_QUARTER176373
Due Date - Year Credits.Due Date DUE_DATE_YEAR176389
Edi Processed Flag Credits.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG266684
Export Certificate Number Credits.Export Certificate NumberGLOBAL_FLEX_EXPORT_CERTIFICA_5GLOBAL_FLEX_EXPORT_CERTIFICA_5266715
Export Date Credits.Export DateGLOBAL_FLEX_EXPORT_DATE_5GLOBAL_FLEX_EXPORT_DATE_5266719
Export Method Credits.Export MethodGLOBAL_FLEX_EXPORT_METHOD_5GLOBAL_FLEX_EXPORT_METHOD_5266717
Export Name Credits.Export NameGLOBAL_FLEX_EXPORT_NAME_5GLOBAL_FLEX_EXPORT_NAME_5266716
Export Type Credits.Export TypeGLOBAL_FLEX_EXPORT_TYPE_5GLOBAL_FLEX_EXPORT_TYPE_5266718
Finance Charges Flag Credits.Finance Charges FlagFINANCE_CHARGES_FLAGFINANCE_CHARGES_FLAG266681
First Print Date Credits.First Print DateFIRST_PRINT_DATEFIRST_PRINT_DATE134385
First Print Date - Day Credits.First Print Date FIRST_PRINT_DATE_DAY179555
First Print Date - Month Credits.First Print Date FIRST_PRINT_DATE_MONTH179567
First Print Date - Quarter Credits.First Print Date FIRST_PRINT_DATE_QUARTER179579
First Print Date - Year Credits.First Print Date FIRST_PRINT_DATE_YEAR179591
Fob Point Credits.Fob PointFOB_POINTFOB_POINT266683
Freight Accessory Expense Credits.Freight Accessory ExpenseGLOBAL_FLEX_FREIGHT_ACC_EXP_12GLOBAL_FLEX_FREIGHT_ACC_EXP_12266743
Freight CarrierName of shipping firm.Credits.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134657
GUI Type Credits.GUI TypeGLOBAL_FLEX_GUI_TYPE_5GLOBAL_FLEX_GUI_TYPE_5266712
Grace Days Credits.Grace DaysGLOBAL_FLEX_GRACE_DAYS_12GLOBAL_FLEX_GRACE_DAYS_12266739
ISS_DATE Credits.ISS_DATEGLOBAL_FLEX_ISS_DATE_12GLOBAL_FLEX_ISS_DATE_12266752
Insurance Accessory Expense Credits.Insurance Accessory ExpenseGLOBAL_FLEX_INSURANCE_ACC_E_12GLOBAL_FLEX_INSURANCE_ACC_E_12266744
Interest Formula Credits.Interest FormulaGLOBAL_FLEX_INTEREST_FORMUL_12GLOBAL_FLEX_INTEREST_FORMUL_12266738
Interest Period Credits.Interest PeriodGLOBAL_FLEX_INTEREST_PERIOD_12GLOBAL_FLEX_INTEREST_PERIOD_12266737
Interest Rate/Amount Credits.Interest Rate/AmountGLOBAL_FLEX_INTEREST_RATE_A_12GLOBAL_FLEX_INTEREST_RATE_A_12266736
Interest Type Credits.Interest TypeGLOBAL_FLEX_INTEREST_TYPE_12GLOBAL_FLEX_INTEREST_TYPE_12266735
Internal NotesNotes not printed on an invoice.Credits.Internal NotesINTERNAL_NOTESINTERNAL_NOTES137092
Invoice Type Credits.Invoice TypeGLOBAL_FLEX_INVOICE_TYPE_2GLOBAL_FLEX_INVOICE_TYPE_2266705
Invoice Type 1 Credits.Invoice Type 1GLOBAL_FLEX_INVOICE_TYPE_3GLOBAL_FLEX_INVOICE_TYPE_3266706
Invoice Type 2 Credits.Invoice Type 2GLOBAL_FLEX_INVOICE_TYPE_4GLOBAL_FLEX_INVOICE_TYPE_4266710
Invoice Type 3 Credits.Invoice Type 3GLOBAL_FLEX_INVOICE_TYPE_14GLOBAL_FLEX_INVOICE_TYPE_14266753
Invoice Type 4 Credits.Invoice Type 4GLOBAL_FLEX_INVOICE_TYPE_17GLOBAL_FLEX_INVOICE_TYPE_17266755
Invoice Type 5 Credits.Invoice Type 5GLOBAL_FLEX_INVOICE_TYPE_18GLOBAL_FLEX_INVOICE_TYPE_18266756
Issue Date Credits.Issue DateGLOBAL_FLEX_ISSUE_DATE_12GLOBAL_FLEX_ISSUE_DATE_12266742
Last Print Date Credits.Last Print DateLAST_PRINT_DATELAST_PRINT_DATE138597
Last Print Date - Day Credits.Last Print Date LAST_PRINT_DATE_DAY182454
Last Print Date - Month Credits.Last Print Date LAST_PRINT_DATE_MONTH182470
Last Print Date - Quarter Credits.Last Print Date LAST_PRINT_DATE_QUARTER182486
Last Print Date - Year Credits.Last Print Date LAST_PRINT_DATE_YEAR182502
Last Update DateStandard WHO column.Credits.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140494
Last Update Date - Day Credits.Last Update Date LAST_UPDATE_DATE_DAY183498
Last Update Date - Month Credits.Last Update Date LAST_UPDATE_DATE_MONTH183926
Last Update Date - Quarter Credits.Last Update Date LAST_UPDATE_DATE_QUARTER184354
Last Update Date - Year Credits.Last Update Date LAST_UPDATE_DATE_YEAR184782
Last Updated ByStandard WHO column.Credits.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139155
Legacy Uniform Invoice Credits.Legacy Uniform InvoiceGLOBAL_FLEX_LEGACY_UNIFORM_I_5GLOBAL_FLEX_LEGACY_UNIFORM_I_5266721
License Plate Credits.License PlateGLOBAL_FLEX_LICENSE_PLATE_12GLOBAL_FLEX_LICENSE_PLATE_12266746
NUMERIC_BAR_CODE Credits.NUMERIC_BAR_CODEGLOBAL_FLEX_NUMERIC_BAR_CODE_9GLOBAL_FLEX_NUMERIC_BAR_CODE_9266730
Operating Unit Credits.Operating UnitOPERATING_UNITOPERATING_UNIT149496
Organization IDOrganization identifier.Credits.Organization IDORG_IDORG_ID150923
Original System Batch Name Credits.Original System Batch NameORIGINAL_SYSTEM_BATCH_NAMEORIGINAL_SYSTEM_BATCH_NAME151226
Original Transaction Number Credits.Original Transaction NumberGLOBAL_FLEX_ORIGINAL_TRANSAC_5GLOBAL_FLEX_ORIGINAL_TRANSAC_5266720
Other Accessory Expenses Credits.Other Accessory ExpensesGLOBAL_FLEX_OTHER_ACC_EXP_12GLOBAL_FLEX_OTHER_ACC_EXP_12266745
Paying Customer Credits.Paying CustomerPAYING_CUSTOMERPAYING_CUSTOMER152156
Paying Customer IdUnique Identifier for Paying CustomerCredits.Paying Customer IdPAYING_CUSTOMER_IDPAYING_CUSTOMER_ID152162
Paying Site Credits.Paying SitePAYING_SITEPAYING_SITE152169
Paying Site Use IdUnique Identifier for Paying Site UseCredits.Paying Site Use IdPAYING_SITE_USE_IDPAYING_SITE_USE_ID152175
Payment MethodPayment Method selection criterion.Credits.Payment MethodPAYMENT_METHODPAYMENT_METHOD152221
Payment Term Name Credits.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152302
Penalty Rate/Amount Credits.Penalty Rate/AmountGLOBAL_FLEX_PENALTY_RATE_AM_12GLOBAL_FLEX_PENALTY_RATE_AM_12266741
Penalty Type Credits.Penalty TypeGLOBAL_FLEX_PENALTY_TYPE_12GLOBAL_FLEX_PENALTY_TYPE_12266740
Pending Print Flag Credits.Pending Print FlagPENDING_PRINT_FLAGPENDING_PRINT_FLAG266685
Primary Salesrep IdUnique Identifier for Primary SalesrepCredits.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155570
Printing Count Credits.Printing CountPRINTING_COUNTPRINTING_COUNT155624
Project Manager Credits.Project ManagerINVOICE_TRANS_PROJECT_MANAGE_2INVOICE_TRANS_PROJECT_MANAGE_2266693
Project Number Credits.Project NumberINVOICE_TRANS_PROJECT_NUMBER_2INVOICE_TRANS_PROJECT_NUMBER_2266689
Project Organization Credits.Project OrganizationINVOICE_TRANS_PROJECT_ORGANI_2INVOICE_TRANS_PROJECT_ORGANI_2266692
Property Location Credits.Property LocationGLOBAL_FLEX_PROPERTY_LOCATIO_4GLOBAL_FLEX_PROPERTY_LOCATIO_4266711
Property Location 1 Credits.Property Location 1GLOBAL_FLEX_PROPERTY_LOCATI_18GLOBAL_FLEX_PROPERTY_LOCATI_18266757
Purchase Order Date Credits.Purchase Order DatePURCHASE_ORDER_DATEPURCHASE_ORDER_DATE157044
Purchase Order Date - Day Credits.Purchase Order Date PURCHASE_ORDER_DATE_DAY189241
Purchase Order Date - Month Credits.Purchase Order Date PURCHASE_ORDER_DATE_MONTH189253
Purchase Order Date - Quarter Credits.Purchase Order Date PURCHASE_ORDER_DATE_QUARTER189265
Purchase Order Date - Year Credits.Purchase Order Date PURCHASE_ORDER_DATE_YEAR189277
Purchase Order Number Credits.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157062
Purchase Order Revision Credits.Purchase Order RevisionPURCHASE_ORDER_REVISIONPURCHASE_ORDER_REVISION157073
Reason Code Credits.Reason CodeREASON_CODEREASON_CODE157934
Receipt Method IdUnique Identifier for Receipt MethodCredits.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID157998
Reference Number Credits.Reference NumberREFERENCE_NUMBERREFERENCE_NUMBER158286
Remit To Address Credits.Remit To AddressREMIT_TO_ADDRESSREMIT_TO_ADDRESS158543
Remit To Address IdUnique Identifier for Remit To AddressCredits.Remit To Address IdREMIT_TO_ADDRESS_IDREMIT_TO_ADDRESS_ID158549
Sales Order Credits.Sales OrderINVOICE_TRANS_SALES_ORDER_NU_5INVOICE_TRANS_SALES_ORDER_NU_5266699
Salesperson Name Credits.Salesperson NameSALESPERSON_NAMESALESPERSON_NAME160578
Ship Date Credits.Ship DateSHIP_DATESHIP_DATE161784
Ship Date - Day Credits.Ship Date SHIP_DATE_DAY190454
Ship Date - Month Credits.Ship Date SHIP_DATE_MONTH190470
Ship Date - Quarter Credits.Ship Date SHIP_DATE_QUARTER190486
Ship Date - Year Credits.Ship Date SHIP_DATE_YEAR190502
Ship To Contact IdUnique Identifier for Ship To ContactCredits.Ship To Contact IdSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161861
Ship To Contact Name Credits.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161872
Ship To Customer Credits.Ship To CustomerSHIP_TO_CUSTOMERSHIP_TO_CUSTOMER161885
Ship To Customer IdUnique Identifier for Ship To CustomerCredits.Ship To Customer IdSHIP_TO_CUSTOMER_IDSHIP_TO_CUSTOMER_ID161892
Ship To Site Credits.Ship To SiteSHIP_TO_SITESHIP_TO_SITE161994
Ship To Site Use IdUnique Identifier for Ship To Site UseCredits.Ship To Site Use IdSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162022
Shipping Reference Credits.Shipping ReferenceSHIPPING_REFERENCESHIPPING_REFERENCE161768
Sold To Contact IdUnique Identifier for Sold To ContactCredits.Sold To Contact IdSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162241
Sold To Contact Name Credits.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162250
Sold To Customer Credits.Sold To CustomerSOLD_TO_CUSTOMERSOLD_TO_CUSTOMER162258
Sold To Customer IdUnique Identifier for Sold To CustomerCredits.Sold To Customer IdSOLD_TO_CUSTOMER_IDSOLD_TO_CUSTOMER_ID162264
Sold To Site Credits.Sold To SiteSOLD_TO_SITESOLD_TO_SITE162277
Sold To Site Use IdUnique Identifier for Sold To Site UseCredits.Sold To Site Use IdSOLD_TO_SITE_USE_IDSOLD_TO_SITE_USE_ID162283
TAX_DATE Credits.TAX_DATEGLOBAL_FLEX_TAX_DATE_6GLOBAL_FLEX_TAX_DATE_6266722
TAX_DATE 1 Credits.TAX_DATE 1GLOBAL_FLEX_TAX_DATE_7GLOBAL_FLEX_TAX_DATE_7266723
TAX_DATE 2 Credits.TAX_DATE 2GLOBAL_FLEX_TAX_DATE_8GLOBAL_FLEX_TAX_DATE_8266724
TAX_DATE 3 Credits.TAX_DATE 3GLOBAL_FLEX_TAX_DATE_19GLOBAL_FLEX_TAX_DATE_19266758
Tax Exempt Flag Credits.Tax Exempt FlagTAX_EXEMPT_FLAGTAX_EXEMPT_FLAG266682
Term IdUnique identifier for this payment term.Credits.Term IdTERM_IDTERM_ID164970
Total Gross Weight Credits.Total Gross WeightGLOBAL_FLEX_TOTAL_GR_WEIGHT_12GLOBAL_FLEX_TOTAL_GR_WEIGHT_12266750
Total Net Weight Credits.Total Net WeightGLOBAL_FLEX_TOTAL_NT_WEIGHT_12GLOBAL_FLEX_TOTAL_NT_WEIGHT_12266751
Transaction Date Credits.Transaction DateTRANSACTION_DATETRANSACTION_DATE165631
Transaction Date - Day Credits.Transaction Date TRANSACTION_DATE_DAY192311
Transaction Date - Month Credits.Transaction Date TRANSACTION_DATE_MONTH192365
Transaction Date - Quarter Credits.Transaction Date TRANSACTION_DATE_QUARTER192419
Transaction Date - Year Credits.Transaction Date TRANSACTION_DATE_YEAR192473
Transaction IdExternal payment/receipt identifier.Credits.Transaction IdTRANSACTION_IDTRANSACTION_ID165682
Transaction Number Credits.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165736
Transaction Status Credits.Transaction StatusTRANSACTION_STATUSTRANSACTION_STATUS266680
Transaction Type Name Credits.Transaction Type NameTRANSACTION_TYPE_NAMETRANSACTION_TYPE_NAME165870
Triangulation Credits.TriangulationGLOBAL_FLEX_TRIANGULATION_3GLOBAL_FLEX_TRIANGULATION_3266709
UPS Invoice Reference Credits.UPS Invoice ReferenceTRANS_INFO_UPS_INVOICE_REFERENTRANS_INFO_UPS_INVOICE_REFEREN266687
Volume Number Credits.Volume NumberGLOBAL_FLEX_VOLUME_NUMBER_12GLOBAL_FLEX_VOLUME_NUMBER_12266749
Volume Quantity Credits.Volume QuantityGLOBAL_FLEX_VOLUME_QUANTITY_12GLOBAL_FLEX_VOLUME_QUANTITY_12266747
Volume Type Credits.Volume TypeGLOBAL_FLEX_VOLUME_TYPE_12GLOBAL_FLEX_VOLUME_TYPE_12266748
Wine/Cigarette Credits.Wine/CigaretteGLOBAL_FLEX_WINE/CIGARETTE_5GLOBAL_FLEX_WINECIGARETTE_5266713
invoice Type Credits.invoice TypeGLOBAL_FLEX_INVOICE_TYPE_16GLOBAL_FLEX_INVOICE_TYPE_16266754
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Credits -> Customer Transaction LinesCredits.Transaction Id = Customer Transaction Lines.Customer Trx IdAlways exist in master folderOuter join on detail No
Credits -> Freight ChargesCredits.Transaction Id = Freight Charges.Customer Trx IdAlways exist in master folderOuter join on detail No
Credits -> Freight Charges 1Credits.Transaction Id = Freight Charges.Customer Trx IdAlways exist in master folderNoneNo
Credits -> Freight DistributionsCredits.Transaction Id = Freight Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credits -> Invoice AdjustmentsCredits.Transaction Id = Invoice Adjustments.Customer Trx IdMight not exist in master folderOuter join on detail No
Credits -> Invoice Adjustments 1Credits.Transaction Id = Invoice Adjustments.Customer Trx IdAlways exist in master folderNoneNo
Credits -> Payment SchedulesCredits.Transaction Id = Payment Schedules.Customer Trx IdMight not exist in master folderNoneNo
Credits -> Revenue DistributionsCredits.Transaction Id = Revenue Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credits -> Tax DistributionsCredits.Transaction Id = Tax Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credits -> Transaction DistributionsCredits.Transaction Id = Transaction Distributions.Customer Trx IdAlways exist in master folderNoneNo
Credits -> Transaction Revenue LinesCredits.Transaction Id = Transaction Revenue Lines.Customer Trx IdAlways exist in master folderOuter join on detail No
Credits -> Transaction Tax LinesCredits.Transaction Id = Transaction Tax Lines.Customer Trx IdAlways exist in master folderOuter join on detail No