Powered by InfoCaptor


Previous Page   Next Page

AR Invoices
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_INVOICE_ARSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AR Invoices. GLOBAL_FLEX_ORIGINAL_TRANSAC_9GLOBAL_FLEX_ORIGINAL_TRANSAC_9266506
1 AR Invoices. 1GLOBAL_FLEX_ORIGINAL_TRANSA_10GLOBAL_FLEX_ORIGINAL_TRANSA_10266511
2 AR Invoices. 2GLOBAL_FLEX_ORIGINAL_TRANSA_11GLOBAL_FLEX_ORIGINAL_TRANSA_11266513
Agreement Number AR Invoices.Agreement NumberINVOICE_TRANS_AGREEMENT_NUMB_2INVOICE_TRANS_AGREEMENT_NUMB_2266470
BANK_ACCOUNT_NUMBER AR Invoices.BANK_ACCOUNT_NUMBERGLOBAL_FLEX_BANK_ACCOUNT_NUM_8GLOBAL_FLEX_BANK_ACCOUNT_NUM_8266504
Batch IdSurrogate key for the batch for which results are recorded.AR Invoices.Batch IdBATCH_IDBATCH_ID119370
Batch Name AR Invoices.Batch NameBATCH_NAMEBATCH_NAME119395
Bill To Contact IdUnique Identifier for Bill To ContactAR Invoices.Bill To Contact IdBILL_TO_CONTACT_IDBILL_TO_CONTACT_ID119888
Bill To Contact Name AR Invoices.Bill To Contact NameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119896
Bill To Customer AR Invoices.Bill To CustomerBILL_TO_CUSTOMERBILL_TO_CUSTOMER119908
Bill To Customer IdUnique Identifier for Bill To CustomerAR Invoices.Bill To Customer IdBILL_TO_CUSTOMER_IDBILL_TO_CUSTOMER_ID119915
Bill To Site AR Invoices.Bill To SiteBILL_TO_SITEBILL_TO_SITE119954
Bill To Site Use IdUnique Identifier for Bill To Site UseAR Invoices.Bill To Site Use IdBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119963
Bill-to Party ID AR Invoices.Bill-to Party IDINVOICE_TRANS_BILL_TO_PARTY__4INVOICE_TRANS_BILL_TO_PARTY__4266477
Billing Interface Request ID AR Invoices.Billing Interface Request IDINVOICE_TRANS_BILLING_INTERF_3INVOICE_TRANS_BILLING_INTERF_3266475
Billing Party ID AR Invoices.Billing Party IDINVOICE_TRANS_BILLING_PARTY__3INVOICE_TRANS_BILLING_PARTY__3266473
Billing Period AR Invoices.Billing PeriodINVOICE_TRANS_BILLING_PERIOD_3INVOICE_TRANS_BILLING_PERIOD_3266476
Billing Site Use ID AR Invoices.Billing Site Use IDINVOICE_TRANS_BILLING_SITE_U_3INVOICE_TRANS_BILLING_SITE_U_3266474
CAI_DUE_DATE AR Invoices.CAI_DUE_DATEGLOBAL_FLEX_CAI_DUE_DATE_9GLOBAL_FLEX_CAI_DUE_DATE_9266508
CAI_NUMBER AR Invoices.CAI_NUMBERGLOBAL_FLEX_CAI_NUMBER_9GLOBAL_FLEX_CAI_NUMBER_9266507
Claim Number AR Invoices.Claim NumberINVOICE_TRANS_CLAIM_NUMBER_6INVOICE_TRANS_CLAIM_NUMBER_6266479
Claim Reason AR Invoices.Claim ReasonINVOICE_TRANS_CLAIM_REASON_6INVOICE_TRANS_CLAIM_REASON_6266482
CommentsComments not printed on an invoice.AR Invoices.CommentsCOMMENTSCOMMENTS122499
Commitment Transaction Number AR Invoices.Commitment Transaction NumberCOMMITMENT_TRANSACTION_NUMBERCOMMITMENT_TRANSACTION_NUMBER122658
Complete Flag AR Invoices.Complete FlagCOMPLETE_FLAGCOMPLETE_FLAG266458
Context Value AR Invoices.Context ValueTRANS_INFO_CONTEXT_VALUETRANS_INFO_CONTEXT_VALUE266465
Context Value 1 AR Invoices.Context Value 1INVOICE_TRANS_CONTEXT_VALUEINVOICE_TRANS_CONTEXT_VALUE266467
Context Value 2 AR Invoices.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266483
Copy Status AR Invoices.Copy StatusGLOBAL_FLEX_COPY_STATUS_9GLOBAL_FLEX_COPY_STATUS_9266505
Copy Status 1 AR Invoices.Copy Status 1GLOBAL_FLEX_COPY_STATUS_10GLOBAL_FLEX_COPY_STATUS_10266510
Copy Status 2 AR Invoices.Copy Status 2GLOBAL_FLEX_COPY_STATUS_11GLOBAL_FLEX_COPY_STATUS_11266512
Correction AR Invoices.CorrectionGLOBAL_FLEX_CORRECTION_PERIO_3GLOBAL_FLEX_CORRECTION_PERIO_3266487
Correction Year AR Invoices.Correction YearGLOBAL_FLEX_CORRECTION_YEAR_3GLOBAL_FLEX_CORRECTION_YEAR_3266486
Created ByStandard WHO column.AR Invoices.Created ByCREATED_BYCREATED_BY124523
Creation DateStandard WHO column.AR Invoices.Creation DateCREATION_DATECREATION_DATE125955
Creation Date - Day AR Invoices.Creation Date CREATION_DATE_DAY172079
Creation Date - Month AR Invoices.Creation Date CREATION_DATE_MONTH172533
Creation Date - Quarter AR Invoices.Creation Date CREATION_DATE_QUARTER172987
Creation Date - Year AR Invoices.Creation Date CREATION_DATE_YEAR173441
Currency Exchange RateExchange rate for foreign currency payments.AR Invoices.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127193
Currency Exchange Rate Date AR Invoices.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127205
Currency Exchange Rate Date - Day AR Invoices.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174190
Currency Exchange Rate Date - Month AR Invoices.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174206
Currency Exchange Rate Date - Quarter AR Invoices.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174222
Currency Exchange Rate Date - Year AR Invoices.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174238
Currency Exchange Rate TypeExchange rate type for foreign currency payments.AR Invoices.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127217
Cust Trx Type IdUnique Identifier for Customer Transaction TypeAR Invoices.Cust Trx Type IdCUST_TRX_TYPE_IDCUST_TRX_TYPE_ID127852
Customer Bank Account IDUnique Identifier for Customer Bank AccountAR Invoices.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127524
Customer Bank Account Name AR Invoices.Customer Bank Account NameCUSTOMER_BANK_ACCOUNT_NAMECUSTOMER_BANK_ACCOUNT_NAME127533
Customer Bank Account NumberCustomer Bank Account NumberAR Invoices.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127539
Customer Reason AR Invoices.Customer ReasonINVOICE_TRANS_CUSTOMER_REASO_6INVOICE_TRANS_CUSTOMER_REASO_6266481
Customer Reference AR Invoices.Customer ReferenceINVOICE_TRANS_CUSTOMER_REFER_6INVOICE_TRANS_CUSTOMER_REFER_6266480
Deductible Type AR Invoices.Deductible TypeGLOBAL_FLEX_DEDUCTIBLE_TYPE_5GLOBAL_FLEX_DEDUCTIBLE_TYPE_5266493
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.AR Invoices.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130355
Draft Invoice Number AR Invoices.Draft Invoice NumberINVOICE_TRANS_DRAFT_INVOICE__2INVOICE_TRANS_DRAFT_INVOICE__2266469
Due DateRequired batch completion date/time, notational.AR Invoices.Due DateDUE_DATEDUE_DATE130633
Due Date - Day AR Invoices.Due Date DUE_DATE_DAY176337
Due Date - Month AR Invoices.Due Date DUE_DATE_MONTH176353
Due Date - Quarter AR Invoices.Due Date DUE_DATE_QUARTER176369
Due Date - Year AR Invoices.Due Date DUE_DATE_YEAR176385
Edi Processed Flag AR Invoices.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG266463
Export Certificate Number AR Invoices.Export Certificate NumberGLOBAL_FLEX_EXPORT_CERTIFICA_5GLOBAL_FLEX_EXPORT_CERTIFICA_5266494
Export Date AR Invoices.Export DateGLOBAL_FLEX_EXPORT_DATE_5GLOBAL_FLEX_EXPORT_DATE_5266498
Export Method AR Invoices.Export MethodGLOBAL_FLEX_EXPORT_METHOD_5GLOBAL_FLEX_EXPORT_METHOD_5266496
Export Name AR Invoices.Export NameGLOBAL_FLEX_EXPORT_NAME_5GLOBAL_FLEX_EXPORT_NAME_5266495
Export Type AR Invoices.Export TypeGLOBAL_FLEX_EXPORT_TYPE_5GLOBAL_FLEX_EXPORT_TYPE_5266497
Finance Charges Flag AR Invoices.Finance Charges FlagFINANCE_CHARGES_FLAGFINANCE_CHARGES_FLAG266460
First Print Date AR Invoices.First Print DateFIRST_PRINT_DATEFIRST_PRINT_DATE134383
First Print Date - Day AR Invoices.First Print Date FIRST_PRINT_DATE_DAY179551
First Print Date - Month AR Invoices.First Print Date FIRST_PRINT_DATE_MONTH179563
First Print Date - Quarter AR Invoices.First Print Date FIRST_PRINT_DATE_QUARTER179575
First Print Date - Year AR Invoices.First Print Date FIRST_PRINT_DATE_YEAR179587
Fob Point AR Invoices.Fob PointFOB_POINTFOB_POINT266462
Freight Accessory Expense AR Invoices.Freight Accessory ExpenseGLOBAL_FLEX_FREIGHT_ACC_EXP_12GLOBAL_FLEX_FREIGHT_ACC_EXP_12266522
Freight CarrierName of shipping firm.AR Invoices.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134655
GUI Type AR Invoices.GUI TypeGLOBAL_FLEX_GUI_TYPE_5GLOBAL_FLEX_GUI_TYPE_5266491
Grace Days AR Invoices.Grace DaysGLOBAL_FLEX_GRACE_DAYS_12GLOBAL_FLEX_GRACE_DAYS_12266518
ISS_DATE AR Invoices.ISS_DATEGLOBAL_FLEX_ISS_DATE_12GLOBAL_FLEX_ISS_DATE_12266531
Initial Customer Trx IdUnique Identifier for Initial Customer TransactionAR Invoices.Initial Customer Trx IdINITIAL_CUSTOMER_TRX_IDINITIAL_CUSTOMER_TRX_ID136888
Insurance Accessory Expense AR Invoices.Insurance Accessory ExpenseGLOBAL_FLEX_INSURANCE_ACC_E_12GLOBAL_FLEX_INSURANCE_ACC_E_12266523
Interest Formula AR Invoices.Interest FormulaGLOBAL_FLEX_INTEREST_FORMUL_12GLOBAL_FLEX_INTEREST_FORMUL_12266517
Interest Period AR Invoices.Interest PeriodGLOBAL_FLEX_INTEREST_PERIOD_12GLOBAL_FLEX_INTEREST_PERIOD_12266516
Interest Rate/Amount AR Invoices.Interest Rate/AmountGLOBAL_FLEX_INTEREST_RATE_A_12GLOBAL_FLEX_INTEREST_RATE_A_12266515
Interest Type AR Invoices.Interest TypeGLOBAL_FLEX_INTEREST_TYPE_12GLOBAL_FLEX_INTEREST_TYPE_12266514
Internal NotesNotes not printed on an invoice.AR Invoices.Internal NotesINTERNAL_NOTESINTERNAL_NOTES137090
Invoice Type AR Invoices.Invoice TypeGLOBAL_FLEX_INVOICE_TYPE_2GLOBAL_FLEX_INVOICE_TYPE_2266484
Invoice Type 1 AR Invoices.Invoice Type 1GLOBAL_FLEX_INVOICE_TYPE_3GLOBAL_FLEX_INVOICE_TYPE_3266485
Invoice Type 2 AR Invoices.Invoice Type 2GLOBAL_FLEX_INVOICE_TYPE_4GLOBAL_FLEX_INVOICE_TYPE_4266489
Invoice Type 3 AR Invoices.Invoice Type 3GLOBAL_FLEX_INVOICE_TYPE_14GLOBAL_FLEX_INVOICE_TYPE_14266532
Invoice Type 4 AR Invoices.Invoice Type 4GLOBAL_FLEX_INVOICE_TYPE_17GLOBAL_FLEX_INVOICE_TYPE_17266534
Invoice Type 5 AR Invoices.Invoice Type 5GLOBAL_FLEX_INVOICE_TYPE_18GLOBAL_FLEX_INVOICE_TYPE_18266535
Invoicing Rule AR Invoices.Invoicing RuleINVOICING_RULEINVOICING_RULE137524
Invoicing Rule IdUnique Identifier for Invoicing RuleAR Invoices.Invoicing Rule IdINVOICING_RULE_IDINVOICING_RULE_ID137529
Issue Date AR Invoices.Issue DateGLOBAL_FLEX_ISSUE_DATE_12GLOBAL_FLEX_ISSUE_DATE_12266521
Last Print Date AR Invoices.Last Print DateLAST_PRINT_DATELAST_PRINT_DATE138595
Last Print Date - Day AR Invoices.Last Print Date LAST_PRINT_DATE_DAY182450
Last Print Date - Month AR Invoices.Last Print Date LAST_PRINT_DATE_MONTH182466
Last Print Date - Quarter AR Invoices.Last Print Date LAST_PRINT_DATE_QUARTER182482
Last Print Date - Year AR Invoices.Last Print Date LAST_PRINT_DATE_YEAR182498
Last Update DateStandard WHO column.AR Invoices.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140486
Last Update Date - Day AR Invoices.Last Update Date LAST_UPDATE_DATE_DAY183484
Last Update Date - Month AR Invoices.Last Update Date LAST_UPDATE_DATE_MONTH183912
Last Update Date - Quarter AR Invoices.Last Update Date LAST_UPDATE_DATE_QUARTER184340
Last Update Date - Year AR Invoices.Last Update Date LAST_UPDATE_DATE_YEAR184768
Last Updated ByStandard WHO column.AR Invoices.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139147
Legacy Uniform Invoice AR Invoices.Legacy Uniform InvoiceGLOBAL_FLEX_LEGACY_UNIFORM_I_5GLOBAL_FLEX_LEGACY_UNIFORM_I_5266500
License Plate AR Invoices.License PlateGLOBAL_FLEX_LICENSE_PLATE_12GLOBAL_FLEX_LICENSE_PLATE_12266525
NUMERIC_BAR_CODE AR Invoices.NUMERIC_BAR_CODEGLOBAL_FLEX_NUMERIC_BAR_CODE_9GLOBAL_FLEX_NUMERIC_BAR_CODE_9266509
Operating Unit AR Invoices.Operating UnitOPERATING_UNITOPERATING_UNIT149489
Organization IDOrganization identifier.AR Invoices.Organization IDORG_IDORG_ID150916
Original System Batch Name AR Invoices.Original System Batch NameORIGINAL_SYSTEM_BATCH_NAMEORIGINAL_SYSTEM_BATCH_NAME151224
Original Transaction Number AR Invoices.Original Transaction NumberGLOBAL_FLEX_ORIGINAL_TRANSAC_5GLOBAL_FLEX_ORIGINAL_TRANSAC_5266499
Other Accessory Expenses AR Invoices.Other Accessory ExpensesGLOBAL_FLEX_OTHER_ACC_EXP_12GLOBAL_FLEX_OTHER_ACC_EXP_12266524
Paying Customer AR Invoices.Paying CustomerPAYING_CUSTOMERPAYING_CUSTOMER152154
Paying Customer IdUnique Identifier for Paying CustomerAR Invoices.Paying Customer IdPAYING_CUSTOMER_IDPAYING_CUSTOMER_ID152160
Paying Site AR Invoices.Paying SitePAYING_SITEPAYING_SITE152167
Paying Site Use IdUnique Identifier for Paying Site UseAR Invoices.Paying Site Use IdPAYING_SITE_USE_IDPAYING_SITE_USE_ID152173
Payment MethodPayment Method selection criterion.AR Invoices.Payment MethodPAYMENT_METHODPAYMENT_METHOD152219
Payment Term Name AR Invoices.Payment Term NamePAYMENT_TERM_NAMEPAYMENT_TERM_NAME152300
Penalty Rate/Amount AR Invoices.Penalty Rate/AmountGLOBAL_FLEX_PENALTY_RATE_AM_12GLOBAL_FLEX_PENALTY_RATE_AM_12266520
Penalty Type AR Invoices.Penalty TypeGLOBAL_FLEX_PENALTY_TYPE_12GLOBAL_FLEX_PENALTY_TYPE_12266519
Pending Print Flag AR Invoices.Pending Print FlagPENDING_PRINT_FLAGPENDING_PRINT_FLAG266464
Primary Salesrep IdUnique Identifier for Primary SalesrepAR Invoices.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155568
Printing Count AR Invoices.Printing CountPRINTING_COUNTPRINTING_COUNT155622
Project Manager AR Invoices.Project ManagerINVOICE_TRANS_PROJECT_MANAGE_2INVOICE_TRANS_PROJECT_MANAGE_2266472
Project Number AR Invoices.Project NumberINVOICE_TRANS_PROJECT_NUMBER_2INVOICE_TRANS_PROJECT_NUMBER_2266468
Project Organization AR Invoices.Project OrganizationINVOICE_TRANS_PROJECT_ORGANI_2INVOICE_TRANS_PROJECT_ORGANI_2266471
Property Location AR Invoices.Property LocationGLOBAL_FLEX_PROPERTY_LOCATIO_4GLOBAL_FLEX_PROPERTY_LOCATIO_4266490
Property Location 1 AR Invoices.Property Location 1GLOBAL_FLEX_PROPERTY_LOCATI_18GLOBAL_FLEX_PROPERTY_LOCATI_18266536
Purchase Order Date AR Invoices.Purchase Order DatePURCHASE_ORDER_DATEPURCHASE_ORDER_DATE157042
Purchase Order Date - Day AR Invoices.Purchase Order Date PURCHASE_ORDER_DATE_DAY189237
Purchase Order Date - Month AR Invoices.Purchase Order Date PURCHASE_ORDER_DATE_MONTH189249
Purchase Order Date - Quarter AR Invoices.Purchase Order Date PURCHASE_ORDER_DATE_QUARTER189261
Purchase Order Date - Year AR Invoices.Purchase Order Date PURCHASE_ORDER_DATE_YEAR189273
Purchase Order Number AR Invoices.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157060
Purchase Order Revision AR Invoices.Purchase Order RevisionPURCHASE_ORDER_REVISIONPURCHASE_ORDER_REVISION157071
Reason Code AR Invoices.Reason CodeREASON_CODEREASON_CODE157932
Receipt Method IdUnique Identifier for Receipt MethodAR Invoices.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID157995
Reference Number AR Invoices.Reference NumberREFERENCE_NUMBERREFERENCE_NUMBER158284
Remit To Address AR Invoices.Remit To AddressREMIT_TO_ADDRESSREMIT_TO_ADDRESS158541
Remit To Address IdUnique Identifier for Remit To AddressAR Invoices.Remit To Address IdREMIT_TO_ADDRESS_IDREMIT_TO_ADDRESS_ID158547
Sales Order AR Invoices.Sales OrderINVOICE_TRANS_SALES_ORDER_NU_5INVOICE_TRANS_SALES_ORDER_NU_5266478
Salesperson Name AR Invoices.Salesperson NameSALESPERSON_NAMESALESPERSON_NAME160576
Ship Date AR Invoices.Ship DateSHIP_DATESHIP_DATE161782
Ship Date - Day AR Invoices.Ship Date SHIP_DATE_DAY190450
Ship Date - Month AR Invoices.Ship Date SHIP_DATE_MONTH190466
Ship Date - Quarter AR Invoices.Ship Date SHIP_DATE_QUARTER190482
Ship Date - Year AR Invoices.Ship Date SHIP_DATE_YEAR190498
Ship To Contact IdUnique Identifier for Ship To ContactAR Invoices.Ship To Contact IdSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161859
Ship To Contact Name AR Invoices.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161870
Ship To Customer AR Invoices.Ship To CustomerSHIP_TO_CUSTOMERSHIP_TO_CUSTOMER161883
Ship To Customer IdUnique Identifier for Ship To CustomerAR Invoices.Ship To Customer IdSHIP_TO_CUSTOMER_IDSHIP_TO_CUSTOMER_ID161890
Ship To Site AR Invoices.Ship To SiteSHIP_TO_SITESHIP_TO_SITE161992
Ship To Site Use IdUnique Identifier for Ship To Site UseAR Invoices.Ship To Site Use IdSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162020
Shipping Reference AR Invoices.Shipping ReferenceSHIPPING_REFERENCESHIPPING_REFERENCE161766
Sold To Contact IdUnique Identifier for Sold To ContactAR Invoices.Sold To Contact IdSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162239
Sold To Contact Name AR Invoices.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162248
Sold To Customer AR Invoices.Sold To CustomerSOLD_TO_CUSTOMERSOLD_TO_CUSTOMER162256
Sold To Customer IdUnique Identifier for Sold To CustomerAR Invoices.Sold To Customer IdSOLD_TO_CUSTOMER_IDSOLD_TO_CUSTOMER_ID162262
Sold To Site AR Invoices.Sold To SiteSOLD_TO_SITESOLD_TO_SITE162275
Sold To Site Use IdUnique Identifier for Sold To Site UseAR Invoices.Sold To Site Use IdSOLD_TO_SITE_USE_IDSOLD_TO_SITE_USE_ID162281
TAX_DATE AR Invoices.TAX_DATEGLOBAL_FLEX_TAX_DATE_6GLOBAL_FLEX_TAX_DATE_6266501
TAX_DATE 1 AR Invoices.TAX_DATE 1GLOBAL_FLEX_TAX_DATE_7GLOBAL_FLEX_TAX_DATE_7266502
TAX_DATE 2 AR Invoices.TAX_DATE 2GLOBAL_FLEX_TAX_DATE_8GLOBAL_FLEX_TAX_DATE_8266503
TAX_DATE 3 AR Invoices.TAX_DATE 3GLOBAL_FLEX_TAX_DATE_19GLOBAL_FLEX_TAX_DATE_19266537
Tax Exempt Flag AR Invoices.Tax Exempt FlagTAX_EXEMPT_FLAGTAX_EXEMPT_FLAG266461
Term IdUnique identifier for this payment term.AR Invoices.Term IdTERM_IDTERM_ID164968
Total Gross Weight AR Invoices.Total Gross WeightGLOBAL_FLEX_TOTAL_GR_WEIGHT_12GLOBAL_FLEX_TOTAL_GR_WEIGHT_12266529
Total Net Weight AR Invoices.Total Net WeightGLOBAL_FLEX_TOTAL_NT_WEIGHT_12GLOBAL_FLEX_TOTAL_NT_WEIGHT_12266530
Transaction Date AR Invoices.Transaction DateTRANSACTION_DATETRANSACTION_DATE165629
Transaction Date - Day AR Invoices.Transaction Date TRANSACTION_DATE_DAY192307
Transaction Date - Month AR Invoices.Transaction Date TRANSACTION_DATE_MONTH192361
Transaction Date - Quarter AR Invoices.Transaction Date TRANSACTION_DATE_QUARTER192415
Transaction Date - Year AR Invoices.Transaction Date TRANSACTION_DATE_YEAR192469
Transaction IdExternal payment/receipt identifier.AR Invoices.Transaction IdTRANSACTION_IDTRANSACTION_ID165680
Transaction Number AR Invoices.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165734
Transaction Status AR Invoices.Transaction StatusTRANSACTION_STATUSTRANSACTION_STATUS266459
Transaction Type Name AR Invoices.Transaction Type NameTRANSACTION_TYPE_NAMETRANSACTION_TYPE_NAME165868
Triangulation AR Invoices.TriangulationGLOBAL_FLEX_TRIANGULATION_3GLOBAL_FLEX_TRIANGULATION_3266488
UPS Invoice Reference AR Invoices.UPS Invoice ReferenceTRANS_INFO_UPS_INVOICE_REFERENTRANS_INFO_UPS_INVOICE_REFEREN266466
Volume Number AR Invoices.Volume NumberGLOBAL_FLEX_VOLUME_NUMBER_12GLOBAL_FLEX_VOLUME_NUMBER_12266528
Volume Quantity AR Invoices.Volume QuantityGLOBAL_FLEX_VOLUME_QUANTITY_12GLOBAL_FLEX_VOLUME_QUANTITY_12266526
Volume Type AR Invoices.Volume TypeGLOBAL_FLEX_VOLUME_TYPE_12GLOBAL_FLEX_VOLUME_TYPE_12266527
Wine/Cigarette AR Invoices.Wine/CigaretteGLOBAL_FLEX_WINE/CIGARETTE_5GLOBAL_FLEX_WINECIGARETTE_5266492
invoice Type AR Invoices.invoice TypeGLOBAL_FLEX_INVOICE_TYPE_16GLOBAL_FLEX_INVOICE_TYPE_16266533
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
AR Invoices -> Customer Transaction LinesAR Invoices.Transaction Id = Customer Transaction Lines.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Freight ChargesAR Invoices.Transaction Id = Freight Charges.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Freight DistributionsAR Invoices.Transaction Id = Freight Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Invoice AdjustmentsAR Invoices.Transaction Id = Invoice Adjustments.Customer Trx IdMight not exist in master folderOuter join on detail No
AR Invoices -> Invoice Adjustments 1AR Invoices.Transaction Id = Invoice Adjustments.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Payment SchedulesAR Invoices.Transaction Id = Payment Schedules.Customer Trx IdMight not exist in master folderNoneNo
AR Invoices -> Revenue DistributionsAR Invoices.Transaction Id = Revenue Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Tax DistributionsAR Invoices.Transaction Id = Tax Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Transaction DistributionsAR Invoices.Transaction Id = Transaction Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Transaction Revenue LinesAR Invoices.Transaction Id = Transaction Revenue Lines.Customer Trx IdAlways exist in master folderNoneNo
AR Invoices -> Transaction Tax LinesAR Invoices.Transaction Id = Transaction Tax Lines.Customer Trx IdAlways exist in master folderNoneNo