Powered by InfoCaptor


Previous Page   Next Page

Debits
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_DEBITSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Debits. GLOBAL_FLEX_ORIGINAL_TRANSAC_9GLOBAL_FLEX_ORIGINAL_TRANSAC_9267191
1 Debits. 1GLOBAL_FLEX_ORIGINAL_TRANSA_10GLOBAL_FLEX_ORIGINAL_TRANSA_10267196
2 Debits. 2GLOBAL_FLEX_ORIGINAL_TRANSA_11GLOBAL_FLEX_ORIGINAL_TRANSA_11267198
Agreement Number Debits.Agreement NumberINVOICE_TRANS_AGREEMENT_NUMB_2INVOICE_TRANS_AGREEMENT_NUMB_2267155
BANK_ACCOUNT_NUMBER Debits.BANK_ACCOUNT_NUMBERGLOBAL_FLEX_BANK_ACCOUNT_NUM_8GLOBAL_FLEX_BANK_ACCOUNT_NUM_8267189
Batch IdSurrogate key for the batch for which results are recorded.Debits.Batch IdBATCH_IDBATCH_ID119375
Batch Name Debits.Batch NameBATCH_NAMEBATCH_NAME119399
Bill To Contact IdUnique Identifier for Bill To ContactDebits.Bill To Contact IdBILL_TO_CONTACT_IDBILL_TO_CONTACT_ID119892
Bill To Contact Name Debits.Bill To Contact NameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119900
Bill To Customer Debits.Bill To CustomerBILL_TO_CUSTOMERBILL_TO_CUSTOMER119912
Bill To Customer IdUnique Identifier for Bill To CustomerDebits.Bill To Customer IdBILL_TO_CUSTOMER_IDBILL_TO_CUSTOMER_ID119919
Bill To Site Debits.Bill To SiteBILL_TO_SITEBILL_TO_SITE119958
Bill To Site Use IdUnique Identifier for Bill To Site UseDebits.Bill To Site Use IdBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119967
Bill-to Party ID Debits.Bill-to Party IDINVOICE_TRANS_BILL_TO_PARTY__4INVOICE_TRANS_BILL_TO_PARTY__4267162
Billing Interface Request ID Debits.Billing Interface Request IDINVOICE_TRANS_BILLING_INTERF_3INVOICE_TRANS_BILLING_INTERF_3267160
Billing Party ID Debits.Billing Party IDINVOICE_TRANS_BILLING_PARTY__3INVOICE_TRANS_BILLING_PARTY__3267158
Billing Period Debits.Billing PeriodINVOICE_TRANS_BILLING_PERIOD_3INVOICE_TRANS_BILLING_PERIOD_3267161
Billing Site Use ID Debits.Billing Site Use IDINVOICE_TRANS_BILLING_SITE_U_3INVOICE_TRANS_BILLING_SITE_U_3267159
CAI_DUE_DATE Debits.CAI_DUE_DATEGLOBAL_FLEX_CAI_DUE_DATE_9GLOBAL_FLEX_CAI_DUE_DATE_9267193
CAI_NUMBER Debits.CAI_NUMBERGLOBAL_FLEX_CAI_NUMBER_9GLOBAL_FLEX_CAI_NUMBER_9267192
Claim Number Debits.Claim NumberINVOICE_TRANS_CLAIM_NUMBER_6INVOICE_TRANS_CLAIM_NUMBER_6267164
Claim Reason Debits.Claim ReasonINVOICE_TRANS_CLAIM_REASON_6INVOICE_TRANS_CLAIM_REASON_6267167
CommentsComments not printed on an invoice.Debits.CommentsCOMMENTSCOMMENTS122505
Complete Flag Debits.Complete FlagCOMPLETE_FLAGCOMPLETE_FLAG267143
Context Value Debits.Context ValueTRANS_INFO_CONTEXT_VALUETRANS_INFO_CONTEXT_VALUE267150
Context Value 1 Debits.Context Value 1INVOICE_TRANS_CONTEXT_VALUEINVOICE_TRANS_CONTEXT_VALUE267152
Context Value 2 Debits.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE267168
Copy Status Debits.Copy StatusGLOBAL_FLEX_COPY_STATUS_9GLOBAL_FLEX_COPY_STATUS_9267190
Copy Status 1 Debits.Copy Status 1GLOBAL_FLEX_COPY_STATUS_10GLOBAL_FLEX_COPY_STATUS_10267195
Copy Status 2 Debits.Copy Status 2GLOBAL_FLEX_COPY_STATUS_11GLOBAL_FLEX_COPY_STATUS_11267197
Correction Debits.CorrectionGLOBAL_FLEX_CORRECTION_PERIO_3GLOBAL_FLEX_CORRECTION_PERIO_3267172
Correction Year Debits.Correction YearGLOBAL_FLEX_CORRECTION_YEAR_3GLOBAL_FLEX_CORRECTION_YEAR_3267171
Created ByStandard WHO column.Debits.Created ByCREATED_BYCREATED_BY124538
Creation DateStandard WHO column.Debits.Creation DateCREATION_DATECREATION_DATE125970
Creation Date - Day Debits.Creation Date CREATION_DATE_DAY172107
Creation Date - Month Debits.Creation Date CREATION_DATE_MONTH172561
Creation Date - Quarter Debits.Creation Date CREATION_DATE_QUARTER173015
Creation Date - Year Debits.Creation Date CREATION_DATE_YEAR173469
Currency Exchange RateExchange rate for foreign currency payments.Debits.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127199
Currency Exchange Rate Date Debits.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127210
Currency Exchange Rate Date - Day Debits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174200
Currency Exchange Rate Date - Month Debits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174216
Currency Exchange Rate Date - Quarter Debits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174232
Currency Exchange Rate Date - Year Debits.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174248
Currency Exchange Rate TypeExchange rate type for foreign currency payments.Debits.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127223
Cust Trx Type IdUnique Identifier for Customer Transaction TypeDebits.Cust Trx Type IdCUST_TRX_TYPE_IDCUST_TRX_TYPE_ID127856
Customer Bank Account IDUnique Identifier for Customer Bank AccountDebits.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127529
Customer Bank Account Name Debits.Customer Bank Account NameCUSTOMER_BANK_ACCOUNT_NAMECUSTOMER_BANK_ACCOUNT_NAME127537
Customer Bank Account NumberCustomer Bank Account NumberDebits.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127544
Customer Reason Debits.Customer ReasonINVOICE_TRANS_CUSTOMER_REASO_6INVOICE_TRANS_CUSTOMER_REASO_6267166
Customer Reference Debits.Customer ReferenceINVOICE_TRANS_CUSTOMER_REFER_6INVOICE_TRANS_CUSTOMER_REFER_6267165
Deductible Type Debits.Deductible TypeGLOBAL_FLEX_DEDUCTIBLE_TYPE_5GLOBAL_FLEX_DEDUCTIBLE_TYPE_5267178
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.Debits.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130360
Draft Invoice Number Debits.Draft Invoice NumberINVOICE_TRANS_DRAFT_INVOICE__2INVOICE_TRANS_DRAFT_INVOICE__2267154
Due DateRequired batch completion date/time, notational.Debits.Due DateDUE_DATEDUE_DATE130637
Due Date - Day Debits.Due Date DUE_DATE_DAY176345
Due Date - Month Debits.Due Date DUE_DATE_MONTH176361
Due Date - Quarter Debits.Due Date DUE_DATE_QUARTER176377
Due Date - Year Debits.Due Date DUE_DATE_YEAR176393
Edi Processed Flag Debits.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG267148
Export Certificate Number Debits.Export Certificate NumberGLOBAL_FLEX_EXPORT_CERTIFICA_5GLOBAL_FLEX_EXPORT_CERTIFICA_5267179
Export Date Debits.Export DateGLOBAL_FLEX_EXPORT_DATE_5GLOBAL_FLEX_EXPORT_DATE_5267183
Export Method Debits.Export MethodGLOBAL_FLEX_EXPORT_METHOD_5GLOBAL_FLEX_EXPORT_METHOD_5267181
Export Name Debits.Export NameGLOBAL_FLEX_EXPORT_NAME_5GLOBAL_FLEX_EXPORT_NAME_5267180
Export Type Debits.Export TypeGLOBAL_FLEX_EXPORT_TYPE_5GLOBAL_FLEX_EXPORT_TYPE_5267182
Finance Charges Flag Debits.Finance Charges FlagFINANCE_CHARGES_FLAGFINANCE_CHARGES_FLAG267145
First Print Date Debits.First Print DateFIRST_PRINT_DATEFIRST_PRINT_DATE134387
First Print Date - Day Debits.First Print Date FIRST_PRINT_DATE_DAY179559
First Print Date - Month Debits.First Print Date FIRST_PRINT_DATE_MONTH179571
First Print Date - Quarter Debits.First Print Date FIRST_PRINT_DATE_QUARTER179583
First Print Date - Year Debits.First Print Date FIRST_PRINT_DATE_YEAR179595
Fob Point Debits.Fob PointFOB_POINTFOB_POINT267147
Freight Accessory Expense Debits.Freight Accessory ExpenseGLOBAL_FLEX_FREIGHT_ACC_EXP_12GLOBAL_FLEX_FREIGHT_ACC_EXP_12267207
Freight CarrierName of shipping firm.Debits.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134661
GUI Type Debits.GUI TypeGLOBAL_FLEX_GUI_TYPE_5GLOBAL_FLEX_GUI_TYPE_5267176
Grace Days Debits.Grace DaysGLOBAL_FLEX_GRACE_DAYS_12GLOBAL_FLEX_GRACE_DAYS_12267203
ISS_DATE Debits.ISS_DATEGLOBAL_FLEX_ISS_DATE_12GLOBAL_FLEX_ISS_DATE_12267216
Insurance Accessory Expense Debits.Insurance Accessory ExpenseGLOBAL_FLEX_INSURANCE_ACC_E_12GLOBAL_FLEX_INSURANCE_ACC_E_12267208
Interest Formula Debits.Interest FormulaGLOBAL_FLEX_INTEREST_FORMUL_12GLOBAL_FLEX_INTEREST_FORMUL_12267202
Interest Period Debits.Interest PeriodGLOBAL_FLEX_INTEREST_PERIOD_12GLOBAL_FLEX_INTEREST_PERIOD_12267201
Interest Rate/Amount Debits.Interest Rate/AmountGLOBAL_FLEX_INTEREST_RATE_A_12GLOBAL_FLEX_INTEREST_RATE_A_12267200
Interest Type Debits.Interest TypeGLOBAL_FLEX_INTEREST_TYPE_12GLOBAL_FLEX_INTEREST_TYPE_12267199
Internal NotesNotes not printed on an invoice.Debits.Internal NotesINTERNAL_NOTESINTERNAL_NOTES137093
Invoice Type Debits.Invoice TypeGLOBAL_FLEX_INVOICE_TYPE_2GLOBAL_FLEX_INVOICE_TYPE_2267169
Invoice Type 1 Debits.Invoice Type 1GLOBAL_FLEX_INVOICE_TYPE_3GLOBAL_FLEX_INVOICE_TYPE_3267170
Invoice Type 2 Debits.Invoice Type 2GLOBAL_FLEX_INVOICE_TYPE_4GLOBAL_FLEX_INVOICE_TYPE_4267174
Invoice Type 3 Debits.Invoice Type 3GLOBAL_FLEX_INVOICE_TYPE_14GLOBAL_FLEX_INVOICE_TYPE_14267217
Invoice Type 4 Debits.Invoice Type 4GLOBAL_FLEX_INVOICE_TYPE_17GLOBAL_FLEX_INVOICE_TYPE_17267219
Invoice Type 5 Debits.Invoice Type 5GLOBAL_FLEX_INVOICE_TYPE_18GLOBAL_FLEX_INVOICE_TYPE_18267220
Issue Date Debits.Issue DateGLOBAL_FLEX_ISSUE_DATE_12GLOBAL_FLEX_ISSUE_DATE_12267206
Last Print Date Debits.Last Print DateLAST_PRINT_DATELAST_PRINT_DATE138599
Last Print Date - Day Debits.Last Print Date LAST_PRINT_DATE_DAY182458
Last Print Date - Month Debits.Last Print Date LAST_PRINT_DATE_MONTH182474
Last Print Date - Quarter Debits.Last Print Date LAST_PRINT_DATE_QUARTER182490
Last Print Date - Year Debits.Last Print Date LAST_PRINT_DATE_YEAR182506
Last Update DateStandard WHO column.Debits.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140501
Last Update Date - Day Debits.Last Update Date LAST_UPDATE_DATE_DAY183512
Last Update Date - Month Debits.Last Update Date LAST_UPDATE_DATE_MONTH183940
Last Update Date - Quarter Debits.Last Update Date LAST_UPDATE_DATE_QUARTER184368
Last Update Date - Year Debits.Last Update Date LAST_UPDATE_DATE_YEAR184796
Last Updated ByStandard WHO column.Debits.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139162
Legacy Uniform Invoice Debits.Legacy Uniform InvoiceGLOBAL_FLEX_LEGACY_UNIFORM_I_5GLOBAL_FLEX_LEGACY_UNIFORM_I_5267185
License Plate Debits.License PlateGLOBAL_FLEX_LICENSE_PLATE_12GLOBAL_FLEX_LICENSE_PLATE_12267210
NUMERIC_BAR_CODE Debits.NUMERIC_BAR_CODEGLOBAL_FLEX_NUMERIC_BAR_CODE_9GLOBAL_FLEX_NUMERIC_BAR_CODE_9267194
Operating Unit Debits.Operating UnitOPERATING_UNITOPERATING_UNIT149502
Organization IDOrganization identifier.Debits.Organization IDORG_IDORG_ID150929
Original System Batch Name Debits.Original System Batch NameORIGINAL_SYSTEM_BATCH_NAMEORIGINAL_SYSTEM_BATCH_NAME151228
Original Transaction Number Debits.Original Transaction NumberGLOBAL_FLEX_ORIGINAL_TRANSAC_5GLOBAL_FLEX_ORIGINAL_TRANSAC_5267184
Other Accessory Expenses Debits.Other Accessory ExpensesGLOBAL_FLEX_OTHER_ACC_EXP_12GLOBAL_FLEX_OTHER_ACC_EXP_12267209
Paying Customer Debits.Paying CustomerPAYING_CUSTOMERPAYING_CUSTOMER152158
Paying Customer IdUnique Identifier for Paying CustomerDebits.Paying Customer IdPAYING_CUSTOMER_IDPAYING_CUSTOMER_ID152164
Paying Site Debits.Paying SitePAYING_SITEPAYING_SITE152171
Paying Site Use IdUnique Identifier for Paying Site UseDebits.Paying Site Use IdPAYING_SITE_USE_IDPAYING_SITE_USE_ID152177
Payment MethodPayment Method selection criterion.Debits.Payment MethodPAYMENT_METHODPAYMENT_METHOD152223
Payment Term Name Debits.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152305
Penalty Rate/Amount Debits.Penalty Rate/AmountGLOBAL_FLEX_PENALTY_RATE_AM_12GLOBAL_FLEX_PENALTY_RATE_AM_12267205
Penalty Type Debits.Penalty TypeGLOBAL_FLEX_PENALTY_TYPE_12GLOBAL_FLEX_PENALTY_TYPE_12267204
Pending Print Flag Debits.Pending Print FlagPENDING_PRINT_FLAGPENDING_PRINT_FLAG267149
Primary Salesrep IdUnique Identifier for Primary SalesrepDebits.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155574
Printing Count Debits.Printing CountPRINTING_COUNTPRINTING_COUNT155626
Project Manager Debits.Project ManagerINVOICE_TRANS_PROJECT_MANAGE_2INVOICE_TRANS_PROJECT_MANAGE_2267157
Project Number Debits.Project NumberINVOICE_TRANS_PROJECT_NUMBER_2INVOICE_TRANS_PROJECT_NUMBER_2267153
Project Organization Debits.Project OrganizationINVOICE_TRANS_PROJECT_ORGANI_2INVOICE_TRANS_PROJECT_ORGANI_2267156
Property Location Debits.Property LocationGLOBAL_FLEX_PROPERTY_LOCATIO_4GLOBAL_FLEX_PROPERTY_LOCATIO_4267175
Property Location 1 Debits.Property Location 1GLOBAL_FLEX_PROPERTY_LOCATI_18GLOBAL_FLEX_PROPERTY_LOCATI_18267221
Purchase Order Date Debits.Purchase Order DatePURCHASE_ORDER_DATEPURCHASE_ORDER_DATE157046
Purchase Order Date - Day Debits.Purchase Order Date PURCHASE_ORDER_DATE_DAY189245
Purchase Order Date - Month Debits.Purchase Order Date PURCHASE_ORDER_DATE_MONTH189257
Purchase Order Date - Quarter Debits.Purchase Order Date PURCHASE_ORDER_DATE_QUARTER189269
Purchase Order Date - Year Debits.Purchase Order Date PURCHASE_ORDER_DATE_YEAR189281
Purchase Order Number Debits.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157064
Purchase Order Revision Debits.Purchase Order RevisionPURCHASE_ORDER_REVISIONPURCHASE_ORDER_REVISION157075
Reason Code Debits.Reason CodeREASON_CODEREASON_CODE157937
Receipt Method IdUnique Identifier for Receipt MethodDebits.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID158000
Reference Number Debits.Reference NumberREFERENCE_NUMBERREFERENCE_NUMBER158288
Remit To Address Debits.Remit To AddressREMIT_TO_ADDRESSREMIT_TO_ADDRESS158545
Remit To Address IdUnique Identifier for Remit To AddressDebits.Remit To Address IdREMIT_TO_ADDRESS_IDREMIT_TO_ADDRESS_ID158551
Sales Order Debits.Sales OrderINVOICE_TRANS_SALES_ORDER_NU_5INVOICE_TRANS_SALES_ORDER_NU_5267163
Salesperson Name Debits.Salesperson NameSALESPERSON_NAMESALESPERSON_NAME160580
Ship Date Debits.Ship DateSHIP_DATESHIP_DATE161786
Ship Date - Day Debits.Ship Date SHIP_DATE_DAY190458
Ship Date - Month Debits.Ship Date SHIP_DATE_MONTH190474
Ship Date - Quarter Debits.Ship Date SHIP_DATE_QUARTER190490
Ship Date - Year Debits.Ship Date SHIP_DATE_YEAR190506
Ship To Contact IdUnique Identifier for Ship To ContactDebits.Ship To Contact IdSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161863
Ship To Contact Name Debits.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161874
Ship To Customer Debits.Ship To CustomerSHIP_TO_CUSTOMERSHIP_TO_CUSTOMER161887
Ship To Customer IdUnique Identifier for Ship To CustomerDebits.Ship To Customer IdSHIP_TO_CUSTOMER_IDSHIP_TO_CUSTOMER_ID161894
Ship To Site Debits.Ship To SiteSHIP_TO_SITESHIP_TO_SITE161996
Ship To Site Use IdUnique Identifier for Ship To Site UseDebits.Ship To Site Use IdSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162024
Shipping Reference Debits.Shipping ReferenceSHIPPING_REFERENCESHIPPING_REFERENCE161770
Sold To Contact IdUnique Identifier for Sold To ContactDebits.Sold To Contact IdSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162243
Sold To Contact Name Debits.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162252
Sold To Customer Debits.Sold To CustomerSOLD_TO_CUSTOMERSOLD_TO_CUSTOMER162260
Sold To Customer IdUnique Identifier for Sold To CustomerDebits.Sold To Customer IdSOLD_TO_CUSTOMER_IDSOLD_TO_CUSTOMER_ID162266
Sold To Site Debits.Sold To SiteSOLD_TO_SITESOLD_TO_SITE162279
Sold To Site Use IdUnique Identifier for Sold To Site UseDebits.Sold To Site Use IdSOLD_TO_SITE_USE_IDSOLD_TO_SITE_USE_ID162285
TAX_DATE Debits.TAX_DATEGLOBAL_FLEX_TAX_DATE_6GLOBAL_FLEX_TAX_DATE_6267186
TAX_DATE 1 Debits.TAX_DATE 1GLOBAL_FLEX_TAX_DATE_7GLOBAL_FLEX_TAX_DATE_7267187
TAX_DATE 2 Debits.TAX_DATE 2GLOBAL_FLEX_TAX_DATE_8GLOBAL_FLEX_TAX_DATE_8267188
TAX_DATE 3 Debits.TAX_DATE 3GLOBAL_FLEX_TAX_DATE_19GLOBAL_FLEX_TAX_DATE_19267222
Tax Exempt Flag Debits.Tax Exempt FlagTAX_EXEMPT_FLAGTAX_EXEMPT_FLAG267146
Term IdUnique identifier for this payment term.Debits.Term IdTERM_IDTERM_ID164972
Total Gross Weight Debits.Total Gross WeightGLOBAL_FLEX_TOTAL_GR_WEIGHT_12GLOBAL_FLEX_TOTAL_GR_WEIGHT_12267214
Total Net Weight Debits.Total Net WeightGLOBAL_FLEX_TOTAL_NT_WEIGHT_12GLOBAL_FLEX_TOTAL_NT_WEIGHT_12267215
Transaction Date Debits.Transaction DateTRANSACTION_DATETRANSACTION_DATE165634
Transaction Date - Day Debits.Transaction Date TRANSACTION_DATE_DAY192315
Transaction Date - Month Debits.Transaction Date TRANSACTION_DATE_MONTH192369
Transaction Date - Quarter Debits.Transaction Date TRANSACTION_DATE_QUARTER192423
Transaction Date - Year Debits.Transaction Date TRANSACTION_DATE_YEAR192477
Transaction IdExternal payment/receipt identifier.Debits.Transaction IdTRANSACTION_IDTRANSACTION_ID165684
Transaction Number Debits.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165739
Transaction Status Debits.Transaction StatusTRANSACTION_STATUSTRANSACTION_STATUS267144
Transaction Type Name Debits.Transaction Type NameTRANSACTION_TYPE_NAMETRANSACTION_TYPE_NAME165872
Triangulation Debits.TriangulationGLOBAL_FLEX_TRIANGULATION_3GLOBAL_FLEX_TRIANGULATION_3267173
UPS Invoice Reference Debits.UPS Invoice ReferenceTRANS_INFO_UPS_INVOICE_REFERENTRANS_INFO_UPS_INVOICE_REFEREN267151
Volume Number Debits.Volume NumberGLOBAL_FLEX_VOLUME_NUMBER_12GLOBAL_FLEX_VOLUME_NUMBER_12267213
Volume Quantity Debits.Volume QuantityGLOBAL_FLEX_VOLUME_QUANTITY_12GLOBAL_FLEX_VOLUME_QUANTITY_12267211
Volume Type Debits.Volume TypeGLOBAL_FLEX_VOLUME_TYPE_12GLOBAL_FLEX_VOLUME_TYPE_12267212
Wine/Cigarette Debits.Wine/CigaretteGLOBAL_FLEX_WINE/CIGARETTE_5GLOBAL_FLEX_WINECIGARETTE_5267177
invoice Type Debits.invoice TypeGLOBAL_FLEX_INVOICE_TYPE_16GLOBAL_FLEX_INVOICE_TYPE_16267218
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Debits -> Credit MemosDebits.Transaction Id = Credit Memos.Previous Customer Trx IdAlways exist in master folderNoneNo
Debits -> Customer Transaction LinesDebits.Transaction Id = Customer Transaction Lines.Customer Trx IdAlways exist in master folderOuter join on detail No
Debits -> Freight ChargesDebits.Transaction Id = Freight Charges.Customer Trx IdAlways exist in master folderOuter join on detail No
Debits -> Freight DistributionsDebits.Transaction Id = Freight Distributions.Customer Trx IdAlways exist in master folderNoneNo
Debits -> Invoice AdjustmentsDebits.Transaction Id = Invoice Adjustments.Customer Trx IdMight not exist in master folderOuter join on detail No
Debits -> Payment SchedulesDebits.Transaction Id = Payment Schedules.Customer Trx IdMight not exist in master folderNoneNo
Debits -> Revenue DistributionsDebits.Transaction Id = Revenue Distributions.Customer Trx IdAlways exist in master folderNoneNo
Debits -> Tax DistributionsDebits.Transaction Id = Tax Distributions.Customer Trx IdAlways exist in master folderNoneNo
Debits -> Transaction DistributionsDebits.Transaction Id = Transaction Distributions.Customer Trx IdAlways exist in master folderNoneNo
Debits -> Transaction Revenue LinesDebits.Transaction Id = Transaction Revenue Lines.Customer Trx IdAlways exist in master folderOuter join on detail No
Debits -> Transaction Tax LinesDebits.Transaction Id = Transaction Tax Lines.Customer Trx IdAlways exist in master folderOuter join on detail No