Powered by InfoCaptor


Previous Page   Next Page

AR Transactions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_AR_TRANSACTIONSUnknown
NoneNone.ARFG_AR_TRANSACTIONSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AR Transactions. GLOBAL_FLEX_ORIGINAL_TRANSAC_9GLOBAL_FLEX_ORIGINAL_TRANSAC_9266593
1 AR Transactions. 1GLOBAL_FLEX_ORIGINAL_TRANSA_10GLOBAL_FLEX_ORIGINAL_TRANSA_10266598
2 AR Transactions. 2GLOBAL_FLEX_ORIGINAL_TRANSA_11GLOBAL_FLEX_ORIGINAL_TRANSA_11266600
Agreement Number AR Transactions.Agreement NumberINVOICE_TRANS_AGREEMENT_NUMB_2INVOICE_TRANS_AGREEMENT_NUMB_2266557
BANK_ACCOUNT_NUMBER AR Transactions.BANK_ACCOUNT_NUMBERGLOBAL_FLEX_BANK_ACCOUNT_NUM_8GLOBAL_FLEX_BANK_ACCOUNT_NUM_8266591
Batch IdSurrogate key for the batch for which results are recorded.AR Transactions.Batch IdBATCH_IDBATCH_ID119371
Batch Name AR Transactions.Batch NameBATCH_NAMEBATCH_NAME119396
Batch Source Id AR Transactions.Batch Source IdBATCH_SOURCE_IDBATCH_SOURCE_ID119420
Batch Source Name AR Transactions.Batch Source NameBATCH_SOURCE_NAMEBATCH_SOURCE_NAME119421
Bill To Contact IdUnique Identifier for Bill To ContactAR Transactions.Bill To Contact IdBILL_TO_CONTACT_IDBILL_TO_CONTACT_ID119889
Bill To Contact Name AR Transactions.Bill To Contact NameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119897
Bill To Customer AR Transactions.Bill To CustomerBILL_TO_CUSTOMERBILL_TO_CUSTOMER119909
Bill To Customer IdUnique Identifier for Bill To CustomerAR Transactions.Bill To Customer IdBILL_TO_CUSTOMER_IDBILL_TO_CUSTOMER_ID119916
Bill To Site AR Transactions.Bill To SiteBILL_TO_SITEBILL_TO_SITE119955
Bill To Site Use IdUnique Identifier for Bill To Site UseAR Transactions.Bill To Site Use IdBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119964
Bill-to Party ID AR Transactions.Bill-to Party IDINVOICE_TRANS_BILL_TO_PARTY__4INVOICE_TRANS_BILL_TO_PARTY__4266564
Billing Interface Request ID AR Transactions.Billing Interface Request IDINVOICE_TRANS_BILLING_INTERF_3INVOICE_TRANS_BILLING_INTERF_3266562
Billing Party ID AR Transactions.Billing Party IDINVOICE_TRANS_BILLING_PARTY__3INVOICE_TRANS_BILLING_PARTY__3266560
Billing Period AR Transactions.Billing PeriodINVOICE_TRANS_BILLING_PERIOD_3INVOICE_TRANS_BILLING_PERIOD_3266563
Billing Site Use ID AR Transactions.Billing Site Use IDINVOICE_TRANS_BILLING_SITE_U_3INVOICE_TRANS_BILLING_SITE_U_3266561
CAI_DUE_DATE AR Transactions.CAI_DUE_DATEGLOBAL_FLEX_CAI_DUE_DATE_9GLOBAL_FLEX_CAI_DUE_DATE_9266595
CAI_NUMBER AR Transactions.CAI_NUMBERGLOBAL_FLEX_CAI_NUMBER_9GLOBAL_FLEX_CAI_NUMBER_9266594
Claim Number AR Transactions.Claim NumberINVOICE_TRANS_CLAIM_NUMBER_6INVOICE_TRANS_CLAIM_NUMBER_6266566
Claim Reason AR Transactions.Claim ReasonINVOICE_TRANS_CLAIM_REASON_6INVOICE_TRANS_CLAIM_REASON_6266569
CommentsComments not printed on an invoice.AR Transactions.CommentsCOMMENTSCOMMENTS122500
Complete Flag AR Transactions.Complete FlagCOMPLETE_FLAGCOMPLETE_FLAG266545
Context Value AR Transactions.Context ValueTRANS_INFO_CONTEXT_VALUETRANS_INFO_CONTEXT_VALUE266552
Context Value 1 AR Transactions.Context Value 1INVOICE_TRANS_CONTEXT_VALUEINVOICE_TRANS_CONTEXT_VALUE266554
Context Value 2 AR Transactions.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266570
Copy Status AR Transactions.Copy StatusGLOBAL_FLEX_COPY_STATUS_9GLOBAL_FLEX_COPY_STATUS_9266592
Copy Status 1 AR Transactions.Copy Status 1GLOBAL_FLEX_COPY_STATUS_10GLOBAL_FLEX_COPY_STATUS_10266597
Copy Status 2 AR Transactions.Copy Status 2GLOBAL_FLEX_COPY_STATUS_11GLOBAL_FLEX_COPY_STATUS_11266599
Correction AR Transactions.CorrectionGLOBAL_FLEX_CORRECTION_PERIO_3GLOBAL_FLEX_CORRECTION_PERIO_3266574
Correction Year AR Transactions.Correction YearGLOBAL_FLEX_CORRECTION_YEAR_3GLOBAL_FLEX_CORRECTION_YEAR_3266573
Created ByStandard WHO column.AR Transactions.Created ByCREATED_BYCREATED_BY124525
Creation DateStandard WHO column.AR Transactions.Creation DateCREATION_DATECREATION_DATE125957
Creation Date - Day AR Transactions.Creation Date CREATION_DATE_DAY172081
Creation Date - Month AR Transactions.Creation Date CREATION_DATE_MONTH172535
Creation Date - Quarter AR Transactions.Creation Date CREATION_DATE_QUARTER172989
Creation Date - Year AR Transactions.Creation Date CREATION_DATE_YEAR173443
Currency Exchange RateExchange rate for foreign currency payments.AR Transactions.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127194
Currency Exchange Rate Date AR Transactions.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127206
Currency Exchange Rate Date - Day AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174192
Currency Exchange Rate Date - Month AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174208
Currency Exchange Rate Date - Quarter AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174224
Currency Exchange Rate Date - Year AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174240
Currency Exchange Rate TypeExchange rate type for foreign currency payments.AR Transactions.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127218
Cust Trx Type IdUnique Identifier for Customer Transaction TypeAR Transactions.Cust Trx Type IdCUST_TRX_TYPE_IDCUST_TRX_TYPE_ID127853
Customer Bank Account IDUnique Identifier for Customer Bank AccountAR Transactions.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127525
Customer Bank Account Name AR Transactions.Customer Bank Account NameCUSTOMER_BANK_ACCOUNT_NAMECUSTOMER_BANK_ACCOUNT_NAME127534
Customer Bank Account NumberCustomer Bank Account NumberAR Transactions.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127540
Customer Reason AR Transactions.Customer ReasonINVOICE_TRANS_CUSTOMER_REASO_6INVOICE_TRANS_CUSTOMER_REASO_6266568
Customer Reference AR Transactions.Customer ReferenceINVOICE_TRANS_CUSTOMER_REFER_6INVOICE_TRANS_CUSTOMER_REFER_6266567
Deductible Type AR Transactions.Deductible TypeGLOBAL_FLEX_DEDUCTIBLE_TYPE_5GLOBAL_FLEX_DEDUCTIBLE_TYPE_5266580
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.AR Transactions.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130356
Draft Invoice Number AR Transactions.Draft Invoice NumberINVOICE_TRANS_DRAFT_INVOICE__2INVOICE_TRANS_DRAFT_INVOICE__2266556
Due DateRequired batch completion date/time, notational.AR Transactions.Due DateDUE_DATEDUE_DATE130634
Due Date - Day AR Transactions.Due Date DUE_DATE_DAY176339
Due Date - Month AR Transactions.Due Date DUE_DATE_MONTH176355
Due Date - Quarter AR Transactions.Due Date DUE_DATE_QUARTER176371
Due Date - Year AR Transactions.Due Date DUE_DATE_YEAR176387
Edi Processed Flag AR Transactions.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG266550
Export Certificate Number AR Transactions.Export Certificate NumberGLOBAL_FLEX_EXPORT_CERTIFICA_5GLOBAL_FLEX_EXPORT_CERTIFICA_5266581
Export Date AR Transactions.Export DateGLOBAL_FLEX_EXPORT_DATE_5GLOBAL_FLEX_EXPORT_DATE_5266585
Export Method AR Transactions.Export MethodGLOBAL_FLEX_EXPORT_METHOD_5GLOBAL_FLEX_EXPORT_METHOD_5266583
Export Name AR Transactions.Export NameGLOBAL_FLEX_EXPORT_NAME_5GLOBAL_FLEX_EXPORT_NAME_5266582
Export Type AR Transactions.Export TypeGLOBAL_FLEX_EXPORT_TYPE_5GLOBAL_FLEX_EXPORT_TYPE_5266584
Finance Charges Flag AR Transactions.Finance Charges FlagFINANCE_CHARGES_FLAGFINANCE_CHARGES_FLAG266547
First Print Date AR Transactions.First Print DateFIRST_PRINT_DATEFIRST_PRINT_DATE134384
First Print Date - Day AR Transactions.First Print Date FIRST_PRINT_DATE_DAY179553
First Print Date - Month AR Transactions.First Print Date FIRST_PRINT_DATE_MONTH179565
First Print Date - Quarter AR Transactions.First Print Date FIRST_PRINT_DATE_QUARTER179577
First Print Date - Year AR Transactions.First Print Date FIRST_PRINT_DATE_YEAR179589
Fob Point AR Transactions.Fob PointFOB_POINTFOB_POINT266549
Freight Accessory Expense AR Transactions.Freight Accessory ExpenseGLOBAL_FLEX_FREIGHT_ACC_EXP_12GLOBAL_FLEX_FREIGHT_ACC_EXP_12266609
Freight CarrierName of shipping firm.AR Transactions.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134656
GUI Type AR Transactions.GUI TypeGLOBAL_FLEX_GUI_TYPE_5GLOBAL_FLEX_GUI_TYPE_5266578
Grace Days AR Transactions.Grace DaysGLOBAL_FLEX_GRACE_DAYS_12GLOBAL_FLEX_GRACE_DAYS_12266605
ISS_DATE AR Transactions.ISS_DATEGLOBAL_FLEX_ISS_DATE_12GLOBAL_FLEX_ISS_DATE_12266618
Insurance Accessory Expense AR Transactions.Insurance Accessory ExpenseGLOBAL_FLEX_INSURANCE_ACC_E_12GLOBAL_FLEX_INSURANCE_ACC_E_12266610
Interest Formula AR Transactions.Interest FormulaGLOBAL_FLEX_INTEREST_FORMUL_12GLOBAL_FLEX_INTEREST_FORMUL_12266604
Interest Period AR Transactions.Interest PeriodGLOBAL_FLEX_INTEREST_PERIOD_12GLOBAL_FLEX_INTEREST_PERIOD_12266603
Interest Rate/Amount AR Transactions.Interest Rate/AmountGLOBAL_FLEX_INTEREST_RATE_A_12GLOBAL_FLEX_INTEREST_RATE_A_12266602
Interest Type AR Transactions.Interest TypeGLOBAL_FLEX_INTEREST_TYPE_12GLOBAL_FLEX_INTEREST_TYPE_12266601
Internal NotesNotes not printed on an invoice.AR Transactions.Internal NotesINTERNAL_NOTESINTERNAL_NOTES137091
Invoice Currency Code AR Transactions.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137405
Invoice Type AR Transactions.Invoice TypeGLOBAL_FLEX_INVOICE_TYPE_2GLOBAL_FLEX_INVOICE_TYPE_2266571
Invoice Type 1 AR Transactions.Invoice Type 1GLOBAL_FLEX_INVOICE_TYPE_3GLOBAL_FLEX_INVOICE_TYPE_3266572
Invoice Type 2 AR Transactions.Invoice Type 2GLOBAL_FLEX_INVOICE_TYPE_4GLOBAL_FLEX_INVOICE_TYPE_4266576
Invoice Type 3 AR Transactions.Invoice Type 3GLOBAL_FLEX_INVOICE_TYPE_14GLOBAL_FLEX_INVOICE_TYPE_14266619
Invoice Type 4 AR Transactions.Invoice Type 4GLOBAL_FLEX_INVOICE_TYPE_17GLOBAL_FLEX_INVOICE_TYPE_17266621
Invoice Type 5 AR Transactions.Invoice Type 5GLOBAL_FLEX_INVOICE_TYPE_18GLOBAL_FLEX_INVOICE_TYPE_18266622
Issue Date AR Transactions.Issue DateGLOBAL_FLEX_ISSUE_DATE_12GLOBAL_FLEX_ISSUE_DATE_12266608
Last Print Date AR Transactions.Last Print DateLAST_PRINT_DATELAST_PRINT_DATE138596
Last Print Date - Day AR Transactions.Last Print Date LAST_PRINT_DATE_DAY182452
Last Print Date - Month AR Transactions.Last Print Date LAST_PRINT_DATE_MONTH182468
Last Print Date - Quarter AR Transactions.Last Print Date LAST_PRINT_DATE_QUARTER182484
Last Print Date - Year AR Transactions.Last Print Date LAST_PRINT_DATE_YEAR182500
Last Update DateStandard WHO column.AR Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140488
Last Update Date - Day AR Transactions.Last Update Date LAST_UPDATE_DATE_DAY183486
Last Update Date - Month AR Transactions.Last Update Date LAST_UPDATE_DATE_MONTH183914
Last Update Date - Quarter AR Transactions.Last Update Date LAST_UPDATE_DATE_QUARTER184342
Last Update Date - Year AR Transactions.Last Update Date LAST_UPDATE_DATE_YEAR184770
Last Updated ByStandard WHO column.AR Transactions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139149
Legacy Uniform Invoice AR Transactions.Legacy Uniform InvoiceGLOBAL_FLEX_LEGACY_UNIFORM_I_5GLOBAL_FLEX_LEGACY_UNIFORM_I_5266587
License Plate AR Transactions.License PlateGLOBAL_FLEX_LICENSE_PLATE_12GLOBAL_FLEX_LICENSE_PLATE_12266612
NUMERIC_BAR_CODE AR Transactions.NUMERIC_BAR_CODEGLOBAL_FLEX_NUMERIC_BAR_CODE_9GLOBAL_FLEX_NUMERIC_BAR_CODE_9266596
Operating Unit AR Transactions.Operating UnitOPERATING_UNITOPERATING_UNIT149490
Organization IDOrganization identifier.AR Transactions.Organization IDORG_IDORG_ID150917
Original System Batch Name AR Transactions.Original System Batch NameORIGINAL_SYSTEM_BATCH_NAMEORIGINAL_SYSTEM_BATCH_NAME151225
Original Transaction Number AR Transactions.Original Transaction NumberGLOBAL_FLEX_ORIGINAL_TRANSAC_5GLOBAL_FLEX_ORIGINAL_TRANSAC_5266586
Other Accessory Expenses AR Transactions.Other Accessory ExpensesGLOBAL_FLEX_OTHER_ACC_EXP_12GLOBAL_FLEX_OTHER_ACC_EXP_12266611
Paying Customer AR Transactions.Paying CustomerPAYING_CUSTOMERPAYING_CUSTOMER152155
Paying Customer IdUnique Identifier for Paying CustomerAR Transactions.Paying Customer IdPAYING_CUSTOMER_IDPAYING_CUSTOMER_ID152161
Paying Site AR Transactions.Paying SitePAYING_SITEPAYING_SITE152168
Paying Site Use IdUnique Identifier for Paying Site UseAR Transactions.Paying Site Use IdPAYING_SITE_USE_IDPAYING_SITE_USE_ID152174
Payment MethodPayment Method selection criterion.AR Transactions.Payment MethodPAYMENT_METHODPAYMENT_METHOD152220
Penalty Rate/Amount AR Transactions.Penalty Rate/AmountGLOBAL_FLEX_PENALTY_RATE_AM_12GLOBAL_FLEX_PENALTY_RATE_AM_12266607
Penalty Type AR Transactions.Penalty TypeGLOBAL_FLEX_PENALTY_TYPE_12GLOBAL_FLEX_PENALTY_TYPE_12266606
Pending Print Flag AR Transactions.Pending Print FlagPENDING_PRINT_FLAGPENDING_PRINT_FLAG266551
Primary Salesrep IdUnique Identifier for Primary SalesrepAR Transactions.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155569
Printing Count AR Transactions.Printing CountPRINTING_COUNTPRINTING_COUNT155623
Project Manager AR Transactions.Project ManagerINVOICE_TRANS_PROJECT_MANAGE_2INVOICE_TRANS_PROJECT_MANAGE_2266559
Project Number AR Transactions.Project NumberINVOICE_TRANS_PROJECT_NUMBER_2INVOICE_TRANS_PROJECT_NUMBER_2266555
Project Organization AR Transactions.Project OrganizationINVOICE_TRANS_PROJECT_ORGANI_2INVOICE_TRANS_PROJECT_ORGANI_2266558
Property Location AR Transactions.Property LocationGLOBAL_FLEX_PROPERTY_LOCATIO_4GLOBAL_FLEX_PROPERTY_LOCATIO_4266577
Property Location 1 AR Transactions.Property Location 1GLOBAL_FLEX_PROPERTY_LOCATI_18GLOBAL_FLEX_PROPERTY_LOCATI_18266623
Purchase Order Date AR Transactions.Purchase Order DatePURCHASE_ORDER_DATEPURCHASE_ORDER_DATE157043
Purchase Order Date - Day AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_DAY189239
Purchase Order Date - Month AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_MONTH189251
Purchase Order Date - Quarter AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_QUARTER189263
Purchase Order Date - Year AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_YEAR189275
Purchase Order Number AR Transactions.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157061
Purchase Order Revision AR Transactions.Purchase Order RevisionPURCHASE_ORDER_REVISIONPURCHASE_ORDER_REVISION157072
Reason Code AR Transactions.Reason CodeREASON_CODEREASON_CODE157933
Receipt Method IdUnique Identifier for Receipt MethodAR Transactions.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID157996
Reference Number AR Transactions.Reference NumberREFERENCE_NUMBERREFERENCE_NUMBER158285
Remit To Address AR Transactions.Remit To AddressREMIT_TO_ADDRESSREMIT_TO_ADDRESS158542
Remit To Address IdUnique Identifier for Remit To AddressAR Transactions.Remit To Address IdREMIT_TO_ADDRESS_IDREMIT_TO_ADDRESS_ID158548
Sales Order AR Transactions.Sales OrderINVOICE_TRANS_SALES_ORDER_NU_5INVOICE_TRANS_SALES_ORDER_NU_5266565
Salesperson Name AR Transactions.Salesperson NameSALESPERSON_NAMESALESPERSON_NAME160577
Ship Date AR Transactions.Ship DateSHIP_DATESHIP_DATE161783
Ship Date - Day AR Transactions.Ship Date SHIP_DATE_DAY190452
Ship Date - Month AR Transactions.Ship Date SHIP_DATE_MONTH190468
Ship Date - Quarter AR Transactions.Ship Date SHIP_DATE_QUARTER190484
Ship Date - Year AR Transactions.Ship Date SHIP_DATE_YEAR190500
Ship To Contact IdUnique Identifier for Ship To ContactAR Transactions.Ship To Contact IdSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161860
Ship To Contact Name AR Transactions.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161871
Ship To Customer AR Transactions.Ship To CustomerSHIP_TO_CUSTOMERSHIP_TO_CUSTOMER161884
Ship To Customer IdUnique Identifier for Ship To CustomerAR Transactions.Ship To Customer IdSHIP_TO_CUSTOMER_IDSHIP_TO_CUSTOMER_ID161891
Ship To Site AR Transactions.Ship To SiteSHIP_TO_SITESHIP_TO_SITE161993
Ship To Site Use IdUnique Identifier for Ship To Site UseAR Transactions.Ship To Site Use IdSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162021
Shipping Reference AR Transactions.Shipping ReferenceSHIPPING_REFERENCESHIPPING_REFERENCE161767
Sold To Contact IdUnique Identifier for Sold To ContactAR Transactions.Sold To Contact IdSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162240
Sold To Contact Name AR Transactions.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162249
Sold To Customer AR Transactions.Sold To CustomerSOLD_TO_CUSTOMERSOLD_TO_CUSTOMER162257
Sold To Customer IdUnique Identifier for Sold To CustomerAR Transactions.Sold To Customer IdSOLD_TO_CUSTOMER_IDSOLD_TO_CUSTOMER_ID162263
Sold To Site AR Transactions.Sold To SiteSOLD_TO_SITESOLD_TO_SITE162276
Sold To Site Use IdUnique Identifier for Sold To Site UseAR Transactions.Sold To Site Use IdSOLD_TO_SITE_USE_IDSOLD_TO_SITE_USE_ID162282
TAX_DATE AR Transactions.TAX_DATEGLOBAL_FLEX_TAX_DATE_6GLOBAL_FLEX_TAX_DATE_6266588
TAX_DATE 1 AR Transactions.TAX_DATE 1GLOBAL_FLEX_TAX_DATE_7GLOBAL_FLEX_TAX_DATE_7266589
TAX_DATE 2 AR Transactions.TAX_DATE 2GLOBAL_FLEX_TAX_DATE_8GLOBAL_FLEX_TAX_DATE_8266590
TAX_DATE 3 AR Transactions.TAX_DATE 3GLOBAL_FLEX_TAX_DATE_19GLOBAL_FLEX_TAX_DATE_19266624
Tax Exempt Flag AR Transactions.Tax Exempt FlagTAX_EXEMPT_FLAGTAX_EXEMPT_FLAG266548
Total Gross Weight AR Transactions.Total Gross WeightGLOBAL_FLEX_TOTAL_GR_WEIGHT_12GLOBAL_FLEX_TOTAL_GR_WEIGHT_12266616
Total Net Weight AR Transactions.Total Net WeightGLOBAL_FLEX_TOTAL_NT_WEIGHT_12GLOBAL_FLEX_TOTAL_NT_WEIGHT_12266617
Transaction Date AR Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165630
Transaction Date - Day AR Transactions.Transaction Date TRANSACTION_DATE_DAY192309
Transaction Date - Month AR Transactions.Transaction Date TRANSACTION_DATE_MONTH192363
Transaction Date - Quarter AR Transactions.Transaction Date TRANSACTION_DATE_QUARTER192417
Transaction Date - Year AR Transactions.Transaction Date TRANSACTION_DATE_YEAR192471
Transaction IdExternal payment/receipt identifier.AR Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165681
Transaction Number AR Transactions.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165735
Transaction Status AR Transactions.Transaction StatusTRANSACTION_STATUSTRANSACTION_STATUS266546
Transaction Type Name AR Transactions.Transaction Type NameTRANSACTION_TYPE_NAMETRANSACTION_TYPE_NAME165869
Triangulation AR Transactions.TriangulationGLOBAL_FLEX_TRIANGULATION_3GLOBAL_FLEX_TRIANGULATION_3266575
UPS Invoice Reference AR Transactions.UPS Invoice ReferenceTRANS_INFO_UPS_INVOICE_REFERENTRANS_INFO_UPS_INVOICE_REFEREN266553
Volume Number AR Transactions.Volume NumberGLOBAL_FLEX_VOLUME_NUMBER_12GLOBAL_FLEX_VOLUME_NUMBER_12266615
Volume Quantity AR Transactions.Volume QuantityGLOBAL_FLEX_VOLUME_QUANTITY_12GLOBAL_FLEX_VOLUME_QUANTITY_12266613
Volume Type AR Transactions.Volume TypeGLOBAL_FLEX_VOLUME_TYPE_12GLOBAL_FLEX_VOLUME_TYPE_12266614
Wine/Cigarette AR Transactions.Wine/CigaretteGLOBAL_FLEX_WINE/CIGARETTE_5GLOBAL_FLEX_WINECIGARETTE_5266579
invoice Type AR Transactions.invoice TypeGLOBAL_FLEX_INVOICE_TYPE_16GLOBAL_FLEX_INVOICE_TYPE_16266620
AR Transactions. GLOBAL_FLEX_ORIGINAL_TRANSAC_9GLOBAL_FLEX_ORIGINAL_TRANSAC_9266593
1 AR Transactions. 1GLOBAL_FLEX_ORIGINAL_TRANSA_10GLOBAL_FLEX_ORIGINAL_TRANSA_10266598
2 AR Transactions. 2GLOBAL_FLEX_ORIGINAL_TRANSA_11GLOBAL_FLEX_ORIGINAL_TRANSA_11266600
Agreement Number AR Transactions.Agreement NumberINVOICE_TRANS_AGREEMENT_NUMB_2INVOICE_TRANS_AGREEMENT_NUMB_2266557
BANK_ACCOUNT_NUMBER AR Transactions.BANK_ACCOUNT_NUMBERGLOBAL_FLEX_BANK_ACCOUNT_NUM_8GLOBAL_FLEX_BANK_ACCOUNT_NUM_8266591
Batch IdSurrogate key for the batch for which results are recorded.AR Transactions.Batch IdBATCH_IDBATCH_ID119371
Batch Name AR Transactions.Batch NameBATCH_NAMEBATCH_NAME119396
Batch Source Id AR Transactions.Batch Source IdBATCH_SOURCE_IDBATCH_SOURCE_ID119420
Batch Source Name AR Transactions.Batch Source NameBATCH_SOURCE_NAMEBATCH_SOURCE_NAME119421
Bill To Contact IdUnique Identifier for Bill To ContactAR Transactions.Bill To Contact IdBILL_TO_CONTACT_IDBILL_TO_CONTACT_ID119889
Bill To Contact Name AR Transactions.Bill To Contact NameBILL_TO_CONTACT_NAMEBILL_TO_CONTACT_NAME119897
Bill To Customer AR Transactions.Bill To CustomerBILL_TO_CUSTOMERBILL_TO_CUSTOMER119909
Bill To Customer IdUnique Identifier for Bill To CustomerAR Transactions.Bill To Customer IdBILL_TO_CUSTOMER_IDBILL_TO_CUSTOMER_ID119916
Bill To Site AR Transactions.Bill To SiteBILL_TO_SITEBILL_TO_SITE119955
Bill To Site Use IdUnique Identifier for Bill To Site UseAR Transactions.Bill To Site Use IdBILL_TO_SITE_USE_IDBILL_TO_SITE_USE_ID119964
Bill-to Party ID AR Transactions.Bill-to Party IDINVOICE_TRANS_BILL_TO_PARTY__4INVOICE_TRANS_BILL_TO_PARTY__4266564
Billing Interface Request ID AR Transactions.Billing Interface Request IDINVOICE_TRANS_BILLING_INTERF_3INVOICE_TRANS_BILLING_INTERF_3266562
Billing Party ID AR Transactions.Billing Party IDINVOICE_TRANS_BILLING_PARTY__3INVOICE_TRANS_BILLING_PARTY__3266560
Billing Period AR Transactions.Billing PeriodINVOICE_TRANS_BILLING_PERIOD_3INVOICE_TRANS_BILLING_PERIOD_3266563
Billing Site Use ID AR Transactions.Billing Site Use IDINVOICE_TRANS_BILLING_SITE_U_3INVOICE_TRANS_BILLING_SITE_U_3266561
CAI_DUE_DATE AR Transactions.CAI_DUE_DATEGLOBAL_FLEX_CAI_DUE_DATE_9GLOBAL_FLEX_CAI_DUE_DATE_9266595
CAI_NUMBER AR Transactions.CAI_NUMBERGLOBAL_FLEX_CAI_NUMBER_9GLOBAL_FLEX_CAI_NUMBER_9266594
Claim Number AR Transactions.Claim NumberINVOICE_TRANS_CLAIM_NUMBER_6INVOICE_TRANS_CLAIM_NUMBER_6266566
Claim Reason AR Transactions.Claim ReasonINVOICE_TRANS_CLAIM_REASON_6INVOICE_TRANS_CLAIM_REASON_6266569
CommentsComments not printed on an invoice.AR Transactions.CommentsCOMMENTSCOMMENTS122500
Complete Flag AR Transactions.Complete FlagCOMPLETE_FLAGCOMPLETE_FLAG266545
Context Value AR Transactions.Context ValueTRANS_INFO_CONTEXT_VALUETRANS_INFO_CONTEXT_VALUE266552
Context Value 1 AR Transactions.Context Value 1INVOICE_TRANS_CONTEXT_VALUEINVOICE_TRANS_CONTEXT_VALUE266554
Context Value 2 AR Transactions.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE266570
Copy Status AR Transactions.Copy StatusGLOBAL_FLEX_COPY_STATUS_9GLOBAL_FLEX_COPY_STATUS_9266592
Copy Status 1 AR Transactions.Copy Status 1GLOBAL_FLEX_COPY_STATUS_10GLOBAL_FLEX_COPY_STATUS_10266597
Copy Status 2 AR Transactions.Copy Status 2GLOBAL_FLEX_COPY_STATUS_11GLOBAL_FLEX_COPY_STATUS_11266599
Correction AR Transactions.CorrectionGLOBAL_FLEX_CORRECTION_PERIO_3GLOBAL_FLEX_CORRECTION_PERIO_3266574
Correction Year AR Transactions.Correction YearGLOBAL_FLEX_CORRECTION_YEAR_3GLOBAL_FLEX_CORRECTION_YEAR_3266573
Created ByStandard WHO column.AR Transactions.Created ByCREATED_BYCREATED_BY124525
Creation DateStandard WHO column.AR Transactions.Creation DateCREATION_DATECREATION_DATE125957
Creation Date - Day AR Transactions.Creation Date CREATION_DATE_DAY172081
Creation Date - Month AR Transactions.Creation Date CREATION_DATE_MONTH172535
Creation Date - Quarter AR Transactions.Creation Date CREATION_DATE_QUARTER172989
Creation Date - Year AR Transactions.Creation Date CREATION_DATE_YEAR173443
Currency Exchange RateExchange rate for foreign currency payments.AR Transactions.Currency Exchange RateCURRENCY_EXCHANGE_RATECURRENCY_EXCHANGE_RATE127194
Currency Exchange Rate Date AR Transactions.Currency Exchange Rate DateCURRENCY_EXCHANGE_RATE_DATECURRENCY_EXCHANGE_RATE_DATE127206
Currency Exchange Rate Date - Day AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_DAY174192
Currency Exchange Rate Date - Month AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_MONTH174208
Currency Exchange Rate Date - Quarter AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_QUARTER174224
Currency Exchange Rate Date - Year AR Transactions.Currency Exchange Rate Date CURRENCY_EXCHANGE_RATE_DATE_YEAR174240
Currency Exchange Rate TypeExchange rate type for foreign currency payments.AR Transactions.Currency Exchange Rate TypeCURRENCY_EXCHANGE_RATE_TYPECURRENCY_EXCHANGE_RATE_TYPE127218
Cust Trx Type IdUnique Identifier for Customer Transaction TypeAR Transactions.Cust Trx Type IdCUST_TRX_TYPE_IDCUST_TRX_TYPE_ID127853
Customer Bank Account IDUnique Identifier for Customer Bank AccountAR Transactions.Customer Bank Account IDCUSTOMER_BANK_ACCOUNT_IDCUSTOMER_BANK_ACCOUNT_ID127525
Customer Bank Account Name AR Transactions.Customer Bank Account NameCUSTOMER_BANK_ACCOUNT_NAMECUSTOMER_BANK_ACCOUNT_NAME127534
Customer Bank Account NumberCustomer Bank Account NumberAR Transactions.Customer Bank Account NumberCUSTOMER_BANK_ACCOUNT_NUMBERCUSTOMER_BANK_ACCOUNT_NUMBER127540
Customer Reason AR Transactions.Customer ReasonINVOICE_TRANS_CUSTOMER_REASO_6INVOICE_TRANS_CUSTOMER_REASO_6266568
Customer Reference AR Transactions.Customer ReferenceINVOICE_TRANS_CUSTOMER_REFER_6INVOICE_TRANS_CUSTOMER_REFER_6266567
Deductible Type AR Transactions.Deductible TypeGLOBAL_FLEX_DEDUCTIBLE_TYPE_5GLOBAL_FLEX_DEDUCTIBLE_TYPE_5266580
Document Sequence NumberA sequence number assigned by the system or by you. This number maybe used to uniquely identify your bank statements.AR Transactions.Document Sequence NumberDOCUMENT_SEQUENCE_NUMBERDOCUMENT_SEQUENCE_NUMBER130356
Draft Invoice Number AR Transactions.Draft Invoice NumberINVOICE_TRANS_DRAFT_INVOICE__2INVOICE_TRANS_DRAFT_INVOICE__2266556
Due DateRequired batch completion date/time, notational.AR Transactions.Due DateDUE_DATEDUE_DATE130634
Due Date - Day AR Transactions.Due Date DUE_DATE_DAY176339
Due Date - Month AR Transactions.Due Date DUE_DATE_MONTH176355
Due Date - Quarter AR Transactions.Due Date DUE_DATE_QUARTER176371
Due Date - Year AR Transactions.Due Date DUE_DATE_YEAR176387
Edi Processed Flag AR Transactions.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG266550
Export Certificate Number AR Transactions.Export Certificate NumberGLOBAL_FLEX_EXPORT_CERTIFICA_5GLOBAL_FLEX_EXPORT_CERTIFICA_5266581
Export Date AR Transactions.Export DateGLOBAL_FLEX_EXPORT_DATE_5GLOBAL_FLEX_EXPORT_DATE_5266585
Export Method AR Transactions.Export MethodGLOBAL_FLEX_EXPORT_METHOD_5GLOBAL_FLEX_EXPORT_METHOD_5266583
Export Name AR Transactions.Export NameGLOBAL_FLEX_EXPORT_NAME_5GLOBAL_FLEX_EXPORT_NAME_5266582
Export Type AR Transactions.Export TypeGLOBAL_FLEX_EXPORT_TYPE_5GLOBAL_FLEX_EXPORT_TYPE_5266584
Finance Charges Flag AR Transactions.Finance Charges FlagFINANCE_CHARGES_FLAGFINANCE_CHARGES_FLAG266547
First Print Date AR Transactions.First Print DateFIRST_PRINT_DATEFIRST_PRINT_DATE134384
First Print Date - Day AR Transactions.First Print Date FIRST_PRINT_DATE_DAY179553
First Print Date - Month AR Transactions.First Print Date FIRST_PRINT_DATE_MONTH179565
First Print Date - Quarter AR Transactions.First Print Date FIRST_PRINT_DATE_QUARTER179577
First Print Date - Year AR Transactions.First Print Date FIRST_PRINT_DATE_YEAR179589
Fob Point AR Transactions.Fob PointFOB_POINTFOB_POINT266549
Freight Accessory Expense AR Transactions.Freight Accessory ExpenseGLOBAL_FLEX_FREIGHT_ACC_EXP_12GLOBAL_FLEX_FREIGHT_ACC_EXP_12266609
Freight CarrierName of shipping firm.AR Transactions.Freight CarrierFREIGHT_CARRIERFREIGHT_CARRIER134656
GUI Type AR Transactions.GUI TypeGLOBAL_FLEX_GUI_TYPE_5GLOBAL_FLEX_GUI_TYPE_5266578
Grace Days AR Transactions.Grace DaysGLOBAL_FLEX_GRACE_DAYS_12GLOBAL_FLEX_GRACE_DAYS_12266605
ISS_DATE AR Transactions.ISS_DATEGLOBAL_FLEX_ISS_DATE_12GLOBAL_FLEX_ISS_DATE_12266618
Insurance Accessory Expense AR Transactions.Insurance Accessory ExpenseGLOBAL_FLEX_INSURANCE_ACC_E_12GLOBAL_FLEX_INSURANCE_ACC_E_12266610
Interest Formula AR Transactions.Interest FormulaGLOBAL_FLEX_INTEREST_FORMUL_12GLOBAL_FLEX_INTEREST_FORMUL_12266604
Interest Period AR Transactions.Interest PeriodGLOBAL_FLEX_INTEREST_PERIOD_12GLOBAL_FLEX_INTEREST_PERIOD_12266603
Interest Rate/Amount AR Transactions.Interest Rate/AmountGLOBAL_FLEX_INTEREST_RATE_A_12GLOBAL_FLEX_INTEREST_RATE_A_12266602
Interest Type AR Transactions.Interest TypeGLOBAL_FLEX_INTEREST_TYPE_12GLOBAL_FLEX_INTEREST_TYPE_12266601
Internal NotesNotes not printed on an invoice.AR Transactions.Internal NotesINTERNAL_NOTESINTERNAL_NOTES137091
Invoice Currency Code AR Transactions.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137405
Invoice Type AR Transactions.Invoice TypeGLOBAL_FLEX_INVOICE_TYPE_2GLOBAL_FLEX_INVOICE_TYPE_2266571
Invoice Type 1 AR Transactions.Invoice Type 1GLOBAL_FLEX_INVOICE_TYPE_3GLOBAL_FLEX_INVOICE_TYPE_3266572
Invoice Type 2 AR Transactions.Invoice Type 2GLOBAL_FLEX_INVOICE_TYPE_4GLOBAL_FLEX_INVOICE_TYPE_4266576
Invoice Type 3 AR Transactions.Invoice Type 3GLOBAL_FLEX_INVOICE_TYPE_14GLOBAL_FLEX_INVOICE_TYPE_14266619
Invoice Type 4 AR Transactions.Invoice Type 4GLOBAL_FLEX_INVOICE_TYPE_17GLOBAL_FLEX_INVOICE_TYPE_17266621
Invoice Type 5 AR Transactions.Invoice Type 5GLOBAL_FLEX_INVOICE_TYPE_18GLOBAL_FLEX_INVOICE_TYPE_18266622
Issue Date AR Transactions.Issue DateGLOBAL_FLEX_ISSUE_DATE_12GLOBAL_FLEX_ISSUE_DATE_12266608
Last Print Date AR Transactions.Last Print DateLAST_PRINT_DATELAST_PRINT_DATE138596
Last Print Date - Day AR Transactions.Last Print Date LAST_PRINT_DATE_DAY182452
Last Print Date - Month AR Transactions.Last Print Date LAST_PRINT_DATE_MONTH182468
Last Print Date - Quarter AR Transactions.Last Print Date LAST_PRINT_DATE_QUARTER182484
Last Print Date - Year AR Transactions.Last Print Date LAST_PRINT_DATE_YEAR182500
Last Update DateStandard WHO column.AR Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140488
Last Update Date - Day AR Transactions.Last Update Date LAST_UPDATE_DATE_DAY183486
Last Update Date - Month AR Transactions.Last Update Date LAST_UPDATE_DATE_MONTH183914
Last Update Date - Quarter AR Transactions.Last Update Date LAST_UPDATE_DATE_QUARTER184342
Last Update Date - Year AR Transactions.Last Update Date LAST_UPDATE_DATE_YEAR184770
Last Updated ByStandard WHO column.AR Transactions.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139149
Legacy Uniform Invoice AR Transactions.Legacy Uniform InvoiceGLOBAL_FLEX_LEGACY_UNIFORM_I_5GLOBAL_FLEX_LEGACY_UNIFORM_I_5266587
License Plate AR Transactions.License PlateGLOBAL_FLEX_LICENSE_PLATE_12GLOBAL_FLEX_LICENSE_PLATE_12266612
NUMERIC_BAR_CODE AR Transactions.NUMERIC_BAR_CODEGLOBAL_FLEX_NUMERIC_BAR_CODE_9GLOBAL_FLEX_NUMERIC_BAR_CODE_9266596
Operating Unit AR Transactions.Operating UnitOPERATING_UNITOPERATING_UNIT149490
Organization IDOrganization identifier.AR Transactions.Organization IDORG_IDORG_ID150917
Original System Batch Name AR Transactions.Original System Batch NameORIGINAL_SYSTEM_BATCH_NAMEORIGINAL_SYSTEM_BATCH_NAME151225
Original Transaction Number AR Transactions.Original Transaction NumberGLOBAL_FLEX_ORIGINAL_TRANSAC_5GLOBAL_FLEX_ORIGINAL_TRANSAC_5266586
Other Accessory Expenses AR Transactions.Other Accessory ExpensesGLOBAL_FLEX_OTHER_ACC_EXP_12GLOBAL_FLEX_OTHER_ACC_EXP_12266611
Paying Customer AR Transactions.Paying CustomerPAYING_CUSTOMERPAYING_CUSTOMER152155
Paying Customer IdUnique Identifier for Paying CustomerAR Transactions.Paying Customer IdPAYING_CUSTOMER_IDPAYING_CUSTOMER_ID152161
Paying Site AR Transactions.Paying SitePAYING_SITEPAYING_SITE152168
Paying Site Use IdUnique Identifier for Paying Site UseAR Transactions.Paying Site Use IdPAYING_SITE_USE_IDPAYING_SITE_USE_ID152174
Payment MethodPayment Method selection criterion.AR Transactions.Payment MethodPAYMENT_METHODPAYMENT_METHOD152220
Penalty Rate/Amount AR Transactions.Penalty Rate/AmountGLOBAL_FLEX_PENALTY_RATE_AM_12GLOBAL_FLEX_PENALTY_RATE_AM_12266607
Penalty Type AR Transactions.Penalty TypeGLOBAL_FLEX_PENALTY_TYPE_12GLOBAL_FLEX_PENALTY_TYPE_12266606
Pending Print Flag AR Transactions.Pending Print FlagPENDING_PRINT_FLAGPENDING_PRINT_FLAG266551
Primary Salesrep IdUnique Identifier for Primary SalesrepAR Transactions.Primary Salesrep IdPRIMARY_SALESREP_IDPRIMARY_SALESREP_ID155569
Printing Count AR Transactions.Printing CountPRINTING_COUNTPRINTING_COUNT155623
Project Manager AR Transactions.Project ManagerINVOICE_TRANS_PROJECT_MANAGE_2INVOICE_TRANS_PROJECT_MANAGE_2266559
Project Number AR Transactions.Project NumberINVOICE_TRANS_PROJECT_NUMBER_2INVOICE_TRANS_PROJECT_NUMBER_2266555
Project Organization AR Transactions.Project OrganizationINVOICE_TRANS_PROJECT_ORGANI_2INVOICE_TRANS_PROJECT_ORGANI_2266558
Property Location AR Transactions.Property LocationGLOBAL_FLEX_PROPERTY_LOCATIO_4GLOBAL_FLEX_PROPERTY_LOCATIO_4266577
Property Location 1 AR Transactions.Property Location 1GLOBAL_FLEX_PROPERTY_LOCATI_18GLOBAL_FLEX_PROPERTY_LOCATI_18266623
Purchase Order Date AR Transactions.Purchase Order DatePURCHASE_ORDER_DATEPURCHASE_ORDER_DATE157043
Purchase Order Date - Day AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_DAY189239
Purchase Order Date - Month AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_MONTH189251
Purchase Order Date - Quarter AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_QUARTER189263
Purchase Order Date - Year AR Transactions.Purchase Order Date PURCHASE_ORDER_DATE_YEAR189275
Purchase Order Number AR Transactions.Purchase Order NumberPURCHASE_ORDER_NUMBERPURCHASE_ORDER_NUMBER157061
Purchase Order Revision AR Transactions.Purchase Order RevisionPURCHASE_ORDER_REVISIONPURCHASE_ORDER_REVISION157072
Reason Code AR Transactions.Reason CodeREASON_CODEREASON_CODE157933
Receipt Method IdUnique Identifier for Receipt MethodAR Transactions.Receipt Method IdRECEIPT_METHOD_IDRECEIPT_METHOD_ID157996
Reference Number AR Transactions.Reference NumberREFERENCE_NUMBERREFERENCE_NUMBER158285
Remit To Address AR Transactions.Remit To AddressREMIT_TO_ADDRESSREMIT_TO_ADDRESS158542
Remit To Address IdUnique Identifier for Remit To AddressAR Transactions.Remit To Address IdREMIT_TO_ADDRESS_IDREMIT_TO_ADDRESS_ID158548
Sales Order AR Transactions.Sales OrderINVOICE_TRANS_SALES_ORDER_NU_5INVOICE_TRANS_SALES_ORDER_NU_5266565
Salesperson Name AR Transactions.Salesperson NameSALESPERSON_NAMESALESPERSON_NAME160577
Ship Date AR Transactions.Ship DateSHIP_DATESHIP_DATE161783
Ship Date - Day AR Transactions.Ship Date SHIP_DATE_DAY190452
Ship Date - Month AR Transactions.Ship Date SHIP_DATE_MONTH190468
Ship Date - Quarter AR Transactions.Ship Date SHIP_DATE_QUARTER190484
Ship Date - Year AR Transactions.Ship Date SHIP_DATE_YEAR190500
Ship To Contact IdUnique Identifier for Ship To ContactAR Transactions.Ship To Contact IdSHIP_TO_CONTACT_IDSHIP_TO_CONTACT_ID161860
Ship To Contact Name AR Transactions.Ship To Contact NameSHIP_TO_CONTACT_NAMESHIP_TO_CONTACT_NAME161871
Ship To Customer AR Transactions.Ship To CustomerSHIP_TO_CUSTOMERSHIP_TO_CUSTOMER161884
Ship To Customer IdUnique Identifier for Ship To CustomerAR Transactions.Ship To Customer IdSHIP_TO_CUSTOMER_IDSHIP_TO_CUSTOMER_ID161891
Ship To Site AR Transactions.Ship To SiteSHIP_TO_SITESHIP_TO_SITE161993
Ship To Site Use IdUnique Identifier for Ship To Site UseAR Transactions.Ship To Site Use IdSHIP_TO_SITE_USE_IDSHIP_TO_SITE_USE_ID162021
Shipping Reference AR Transactions.Shipping ReferenceSHIPPING_REFERENCESHIPPING_REFERENCE161767
Sold To Contact IdUnique Identifier for Sold To ContactAR Transactions.Sold To Contact IdSOLD_TO_CONTACT_IDSOLD_TO_CONTACT_ID162240
Sold To Contact Name AR Transactions.Sold To Contact NameSOLD_TO_CONTACT_NAMESOLD_TO_CONTACT_NAME162249
Sold To Customer AR Transactions.Sold To CustomerSOLD_TO_CUSTOMERSOLD_TO_CUSTOMER162257
Sold To Customer IdUnique Identifier for Sold To CustomerAR Transactions.Sold To Customer IdSOLD_TO_CUSTOMER_IDSOLD_TO_CUSTOMER_ID162263
Sold To Site AR Transactions.Sold To SiteSOLD_TO_SITESOLD_TO_SITE162276
Sold To Site Use IdUnique Identifier for Sold To Site UseAR Transactions.Sold To Site Use IdSOLD_TO_SITE_USE_IDSOLD_TO_SITE_USE_ID162282
TAX_DATE AR Transactions.TAX_DATEGLOBAL_FLEX_TAX_DATE_6GLOBAL_FLEX_TAX_DATE_6266588
TAX_DATE 1 AR Transactions.TAX_DATE 1GLOBAL_FLEX_TAX_DATE_7GLOBAL_FLEX_TAX_DATE_7266589
TAX_DATE 2 AR Transactions.TAX_DATE 2GLOBAL_FLEX_TAX_DATE_8GLOBAL_FLEX_TAX_DATE_8266590
TAX_DATE 3 AR Transactions.TAX_DATE 3GLOBAL_FLEX_TAX_DATE_19GLOBAL_FLEX_TAX_DATE_19266624
Tax Exempt Flag AR Transactions.Tax Exempt FlagTAX_EXEMPT_FLAGTAX_EXEMPT_FLAG266548
Total Gross Weight AR Transactions.Total Gross WeightGLOBAL_FLEX_TOTAL_GR_WEIGHT_12GLOBAL_FLEX_TOTAL_GR_WEIGHT_12266616
Total Net Weight AR Transactions.Total Net WeightGLOBAL_FLEX_TOTAL_NT_WEIGHT_12GLOBAL_FLEX_TOTAL_NT_WEIGHT_12266617
Transaction Date AR Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165630
Transaction Date - Day AR Transactions.Transaction Date TRANSACTION_DATE_DAY192309
Transaction Date - Month AR Transactions.Transaction Date TRANSACTION_DATE_MONTH192363
Transaction Date - Quarter AR Transactions.Transaction Date TRANSACTION_DATE_QUARTER192417
Transaction Date - Year AR Transactions.Transaction Date TRANSACTION_DATE_YEAR192471
Transaction IdExternal payment/receipt identifier.AR Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165681
Transaction Number AR Transactions.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165735
Transaction Status AR Transactions.Transaction StatusTRANSACTION_STATUSTRANSACTION_STATUS266546
Transaction Type Name AR Transactions.Transaction Type NameTRANSACTION_TYPE_NAMETRANSACTION_TYPE_NAME165869
Triangulation AR Transactions.TriangulationGLOBAL_FLEX_TRIANGULATION_3GLOBAL_FLEX_TRIANGULATION_3266575
UPS Invoice Reference AR Transactions.UPS Invoice ReferenceTRANS_INFO_UPS_INVOICE_REFERENTRANS_INFO_UPS_INVOICE_REFEREN266553
Volume Number AR Transactions.Volume NumberGLOBAL_FLEX_VOLUME_NUMBER_12GLOBAL_FLEX_VOLUME_NUMBER_12266615
Volume Quantity AR Transactions.Volume QuantityGLOBAL_FLEX_VOLUME_QUANTITY_12GLOBAL_FLEX_VOLUME_QUANTITY_12266613
Volume Type AR Transactions.Volume TypeGLOBAL_FLEX_VOLUME_TYPE_12GLOBAL_FLEX_VOLUME_TYPE_12266614
Wine/Cigarette AR Transactions.Wine/CigaretteGLOBAL_FLEX_WINE/CIGARETTE_5GLOBAL_FLEX_WINECIGARETTE_5266579
invoice Type AR Transactions.invoice TypeGLOBAL_FLEX_INVOICE_TYPE_16GLOBAL_FLEX_INVOICE_TYPE_16266620
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
AR Transactions -> Customer Transaction LinesAR Transactions.Transaction Id = Customer Transaction Lines.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Freight ChargesAR Transactions.Transaction Id = Freight Charges.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Freight DistributionsAR Transactions.Transaction Id = Freight Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Invoice AdjustmentsAR Transactions.Transaction Id = Invoice Adjustments.Customer Trx IdMight not exist in master folderOuter join on detail No
AR Transactions -> Invoice Adjustments 1AR Transactions.Transaction Id = Invoice Adjustments.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Non Revenue CreditsAR Transactions.Transaction Id = Non Revenue Credits.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Non Revenue Credits 1AR Transactions.Transaction Id = Non Revenue Credits.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> PA Customer InvoicesAR Transactions.Transaction Id = PA Customer Invoices.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> PA Customer Invoices 1AR Transactions.Transaction Id = PA Customer Invoices.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> PA Customer Invoices 2AR Transactions.Transaction Id = PA Customer Invoices.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Payment SchedulesAR Transactions.Transaction Id = Payment Schedules.Customer Trx IdMight not exist in master folderNoneNo
AR Transactions -> Revenue CreditsAR Transactions.Transaction Id = Revenue Credits.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Revenue Credits 1AR Transactions.Transaction Id = Revenue Credits.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Revenue DistributionsAR Transactions.Transaction Id = Revenue Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Sales CreditsAR Transactions.Transaction Id = Sales Credits.Customer Trx IdAlways exist in master folderOuter join on detail No
AR Transactions -> Sales Credits 1AR Transactions.Transaction Id = Sales Credits.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Tax DistributionsAR Transactions.Transaction Id = Tax Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Transaction DistributionsAR Transactions.Transaction Id = Transaction Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Transaction Revenue LinesAR Transactions.Transaction Id = Transaction Revenue Lines.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Transaction Tax LinesAR Transactions.Transaction Id = Transaction Tax Lines.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Unbilled Receivable DistributionsAR Transactions.Transaction Id = Unbilled Receivable Distributions.Customer Trx IdAlways exist in master folderNoneNo
AR Transactions -> Unearned Revenue DistributionsAR Transactions.Transaction Id = Unearned Revenue Distributions.Customer Trx IdAlways exist in master folderNoneNo