Powered by InfoCaptor


Previous Page   Next Page

Customer Transaction Lines
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.ARFG_AR_CUSTOMER_TRANS_LINESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
AMOUNT Customer Transaction Lines.AMOUNTLINE_TRANS_AMOUNT_15LINE_TRANS_AMOUNT_15267052
Accounting Rule Customer Transaction Lines.Accounting RuleACCOUNTING_RULEACCOUNTING_RULE114097
Accounting Rule Duration Customer Transaction Lines.Accounting Rule DurationACCOUNTING_RULE_DURATIONACCOUNTING_RULE_DURATION114100
Accounting Rule Id Customer Transaction Lines.Accounting Rule IdACCOUNTING_RULE_IDACCOUNTING_RULE_ID114106
Activity Date Customer Transaction Lines.Activity DateLINE_TRANS_ACTIVITY_DATE_13LINE_TRANS_ACTIVITY_DATE_13267039
Activity ID Customer Transaction Lines.Activity IDLINE_TRANS_ACTIVITY_ID_13LINE_TRANS_ACTIVITY_ID_13267038
Agreement Number Customer Transaction Lines.Agreement NumberLINE_TRANS_AGREEMENT_NUMBER_5LINE_TRANS_AGREEMENT_NUMBER_5266992
Amortization Schedule ID Customer Transaction Lines.Amortization Schedule IDLINE_TRANS_PAYMENT_ORDER_21LINE_TRANS_PAYMENT_ORDER_21267087
AmountThe amount of revenue authorized for the agreement.Customer Transaction Lines.AmountAMOUNTAMOUNT115855
BILLED_FROM Customer Transaction Lines.BILLED_FROMLINE_TRANS_BILLED_FROM_15LINE_TRANS_BILLED_FROM_15267050
BILLED_FROM_DATE Customer Transaction Lines.BILLED_FROM_DATELINE_TRANS_BILLED_FROM_DATE_15LINE_TRANS_BILLED_FROM_DATE_15267053
BILLED_TO Customer Transaction Lines.BILLED_TOLINE_TRANS_BILLED_TO_15LINE_TRANS_BILLED_TO_15267051
Bill of Lading Customer Transaction Lines.Bill of LadingLINE_TRANS_BILL_OF_LADING_2LINE_TRANS_BILL_OF_LADING_2266968
Bill of Lading 1 Customer Transaction Lines.Bill of Lading 1LINE_TRANS_BILL_OF_LADING_16LINE_TRANS_BILL_OF_LADING_16267064
Bill-to Party ID Customer Transaction Lines.Bill-to Party IDLINE_TRANS_BILL_TO_PARTY_ID_13LINE_TRANS_BILL_TO_PARTY_ID_13267036
Bill_Installment_number Customer Transaction Lines.Bill_Installment_numberLINE_TRANS_BILL_INSTALLMENT_15LINE_TRANS_BILL_INSTALLMENT_15267056
Billing Activity Type ID Customer Transaction Lines.Billing Activity Type IDLINE_TRANS_BILLING_ACTIVITY_12LINE_TRANS_BILLING_ACTIVITY_12267035
Billing Activity Type ID 1 Customer Transaction Lines.Billing Activity Type ID 1LINE_TRANS_BILLING_ACTIVITY_13LINE_TRANS_BILLING_ACTIVITY_13267037
Billing Id Customer Transaction Lines.Billing IdLINE_TRANS_BILLING_ID_6LINE_TRANS_BILLING_ID_6267000
Billing Party ID Customer Transaction Lines.Billing Party IDLINE_TRANS_BILLING_PARTY_ID_12LINE_TRANS_BILLING_PARTY_ID_12267031
Billing Period Customer Transaction Lines.Billing PeriodLINE_TRANS_BILLING_INTERFAC_12LINE_TRANS_BILLING_INTERFAC_12267033
Billing Period 1 Customer Transaction Lines.Billing Period 1LINE_TRANS_BILLING_PERIOD_12LINE_TRANS_BILLING_PERIOD_12267034
Billing Site Use ID Customer Transaction Lines.Billing Site Use IDLINE_TRANS_BILLING_SITE_USE_12LINE_TRANS_BILLING_SITE_USE_12267032
Buyer Part Number Customer Transaction Lines.Buyer Part NumberINV_LINE_INFO_BUYER_PART_NUMBEINV_LINE_INFO_BUYER_PART_NUMBE266955
CONTRACT_MODIFIER Customer Transaction Lines.CONTRACT_MODIFIERLINE_TRANS_CONTRACT_MODIFIE_15LINE_TRANS_CONTRACT_MODIFIE_15267048
CONTRACT_NUMBER Customer Transaction Lines.CONTRACT_NUMBERLINE_TRANS_CONTRACT_NUMBER1_15LINE_TRANS_CONTRACT_NUMBER1_15267047
Calculated Tax Amount Customer Transaction Lines.Calculated Tax AmountGLOBAL_FLEX_CALCULATED_TAX_A_2GLOBAL_FLEX_CALCULATED_TAX_A_2267100
Calculated Tax Amount 1 Customer Transaction Lines.Calculated Tax Amount 1GLOBAL_FLEX_CALCULATED_TAX_A_3GLOBAL_FLEX_CALCULATED_TAX_A_3267111
Calculated Tax Amount 2 Customer Transaction Lines.Calculated Tax Amount 2GLOBAL_FLEX_CALCULATED_TAX_A_4GLOBAL_FLEX_CALCULATED_TAX_A_4267131
Charged Tax Amount Customer Transaction Lines.Charged Tax AmountGLOBAL_FLEX_CHARGED_TAX_AMOU_2GLOBAL_FLEX_CHARGED_TAX_AMOU_2267099
Charged Tax Amount 1 Customer Transaction Lines.Charged Tax Amount 1GLOBAL_FLEX_CHARGED_TAX_AMOU_3GLOBAL_FLEX_CHARGED_TAX_AMOU_3267110
Charged Tax Amount 2 Customer Transaction Lines.Charged Tax Amount 2GLOBAL_FLEX_CHARGED_TAX_AMOU_4GLOBAL_FLEX_CHARGED_TAX_AMOU_4267130
Claim Id Customer Transaction Lines.Claim IdLINE_TRANS_CLAIM_ID_14LINE_TRANS_CLAIM_ID_14267041
Claim Line Id Customer Transaction Lines.Claim Line IdLINE_TRANS_CLAIM_LINE_ID_14LINE_TRANS_CLAIM_LINE_ID_14267042
Claim Number Customer Transaction Lines.Claim NumberLINE_TRANS_CLAIM_NUMBER_14LINE_TRANS_CLAIM_NUMBER_14267040
Claim Reason Customer Transaction Lines.Claim ReasonLINE_TRANS_CLAIM_REASON_14LINE_TRANS_CLAIM_REASON_14267046
Commitment Line Number Customer Transaction Lines.Commitment Line NumberCOMMITMENT_LINE_NUMBERCOMMITMENT_LINE_NUMBER122648
Commitment Transaction Number Customer Transaction Lines.Commitment Transaction NumberCOMMITMENT_TRANSACTION_NUMBERCOMMITMENT_TRANSACTION_NUMBER122659
Context Value Customer Transaction Lines.Context ValueINV_LINE_INFO_CONTEXT_VALUEINV_LINE_INFO_CONTEXT_VALUE266954
Context Value 1 Customer Transaction Lines.Context Value 1LINE_TRANS_CONTEXT_VALUELINE_TRANS_CONTEXT_VALUE266960
Context Value 2 Customer Transaction Lines.Context Value 2GLOBAL_FLEX_CONTEXT_VALUEGLOBAL_FLEX_CONTEXT_VALUE267089
Contract Group Id Customer Transaction Lines.Contract Group IdLINE_TRANS_CONTRACT_GROUP_ID_6LINE_TRANS_CONTRACT_GROUP_ID_6267002
Contract Group Id 1 Customer Transaction Lines.Contract Group Id 1LINE_TRANS_TRANSACTION_START_6LINE_TRANS_TRANSACTION_START_6267003
Contract Group Id 2 Customer Transaction Lines.Contract Group Id 2LINE_TRANS_TRANSACTION_END_D_6LINE_TRANS_TRANSACTION_END_D_6267004
Contract Group Id 3 Customer Transaction Lines.Contract Group Id 3LINE_TRANS_TRANSACTION_AMOUN_6LINE_TRANS_TRANSACTION_AMOUN_6267005
Contract Group Id 4 Customer Transaction Lines.Contract Group Id 4LINE_TRANS_SERVICE_TRANSACTI_6LINE_TRANS_SERVICE_TRANSACTI_6267006
Contract Id Customer Transaction Lines.Contract IdLINE_TRANS_CONTRACT_ID_6LINE_TRANS_CONTRACT_ID_6266997
Contract Number Customer Transaction Lines.Contract NumberLINE_TRANS_CONTRACT_NUMBER_6LINE_TRANS_CONTRACT_NUMBER_6266999
Contract Type Id Customer Transaction Lines.Contract Type IdLINE_TRANS_CONTRACT_TYPE_ID_6LINE_TRANS_CONTRACT_TYPE_ID_6267001
Count Customer Transaction Lines.CountLINE_TRANS_COUNT_2LINE_TRANS_COUNT_2266965
Count 1 Customer Transaction Lines.Count 1LINE_TRANS_WAYBILL_16LINE_TRANS_WAYBILL_16267060
Count 2 Customer Transaction Lines.Count 2LINE_TRANS_COUNT_16LINE_TRANS_COUNT_16267061
Create AP Invoice Customer Transaction Lines.Create AP InvoiceLINE_TRANS_CREATE_AP_INVOICE_3LINE_TRANS_CREATE_AP_INVOICE_3266983
Create AP Invoice 1 Customer Transaction Lines.Create AP Invoice 1LINE_TRANS_CREATE_AP_INVOIC_20LINE_TRANS_CREATE_AP_INVOIC_20267081
Created ByStandard WHO column.Customer Transaction Lines.Created ByCREATED_BYCREATED_BY124537
Creation DateStandard WHO column.Customer Transaction Lines.Creation DateCREATION_DATECREATION_DATE125969
Creation Date - Day Customer Transaction Lines.Creation Date CREATION_DATE_DAY172105
Creation Date - Month Customer Transaction Lines.Creation Date CREATION_DATE_MONTH172559
Creation Date - Quarter Customer Transaction Lines.Creation Date CREATION_DATE_QUARTER173013
Creation Date - Year Customer Transaction Lines.Creation Date CREATION_DATE_YEAR173467
Credited Transaction Line NumberCredited Transaction Line NumCustomer Transaction Lines.Credited Transaction Line NumberCREDITED_TRANSACTION_LINE_NUMCREDITED_TRANSACTION_LINE_NUM126700
Credited Transaction Number Customer Transaction Lines.Credited Transaction NumberCREDITED_TRANSACTION_NUMBERCREDITED_TRANSACTION_NUMBER126705
Cross Charged Project Number Customer Transaction Lines.Cross Charged Project NumberLINE_TRANS_CROSS_CHARGED_PRO_7LINE_TRANS_CROSS_CHARGED_PRO_7267011
Customer Item Part Customer Transaction Lines.Customer Item PartLINE_TRANS_CUSTOMER_ITEM_PAR_2LINE_TRANS_CUSTOMER_ITEM_PAR_2266969
Customer Item Part 1 Customer Transaction Lines.Customer Item Part 1LINE_TRANS_CUSTOMER_ITEM_PA_16LINE_TRANS_CUSTOMER_ITEM_PA_16267065
Customer Reason Customer Transaction Lines.Customer ReasonLINE_TRANS_CUSTOMER_REASON_14LINE_TRANS_CUSTOMER_REASON_14267045
Customer Reference Customer Transaction Lines.Customer ReferenceLINE_TRANS_CUSTOMER_REFEREN_14LINE_TRANS_CUSTOMER_REFEREN_14267044
Customer Trx IdUnique Identifier for Customer TransactionCustomer Transaction Lines.Customer Trx IdCUSTOMER_TRX_IDCUSTOMER_TRX_ID127766
DM Quantity Customer Transaction Lines.DM QuantityINV_LINE_INFO_DM_QUANTITYINV_LINE_INFO_DM_QUANTITY266958
DM Unit Price Customer Transaction Lines.DM Unit PriceINV_LINE_INFO_DM_UNIT_PRICEINV_LINE_INFO_DM_UNIT_PRICE266959
Default Fiscal Class Code Customer Transaction Lines.Default Fiscal Class CodeGLOBAL_FLEX_DEF_FISCAL_CODE_2GLOBAL_FLEX_DEF_FISCAL_CODE_2267097
Default Fiscal Class Code 1 Customer Transaction Lines.Default Fiscal Class Code 1GLOBAL_FLEX_DEF_FISCAL_CODE_3GLOBAL_FLEX_DEF_FISCAL_CODE_3267108
Default Fiscal Class Code 2 Customer Transaction Lines.Default Fiscal Class Code 2GLOBAL_FLEX_DEF_FISCAL_CODE_4GLOBAL_FLEX_DEF_FISCAL_CODE_4267124
Default Transaction Condition Class Code Customer Transaction Lines.Default Transaction Condition Class CodeGLOBAL_FLEX_DEF_TRX_NATURE_C_2GLOBAL_FLEX_DEF_TRX_NATURE_C_2267098
Default Transaction Condition Class Code 1 Customer Transaction Lines.Default Transaction Condition Class Code 1GLOBAL_FLEX_DEF_TRX_NATURE_C_3GLOBAL_FLEX_DEF_TRX_NATURE_C_3267109
Default Transaction Condition Class Code 2 Customer Transaction Lines.Default Transaction Condition Class Code 2GLOBAL_FLEX_DEF_TRX_NATURE_C_4GLOBAL_FLEX_DEF_TRX_NATURE_C_4267125
Delivery Customer Transaction Lines.DeliveryLINE_TRANS_DELIVERY_16LINE_TRANS_DELIVERY_16267059
Draft Invoice Number Customer Transaction Lines.Draft Invoice NumberLINE_TRANS_DRAFT_INVOICE_NUM_5LINE_TRANS_DRAFT_INVOICE_NUM_5266991
Draft Invoice Number 1 Customer Transaction Lines.Draft Invoice Number 1LINE_TRANS_DRAFT_INVOICE_NUM_7LINE_TRANS_DRAFT_INVOICE_NUM_7267008
Earnings Attached Flag Customer Transaction Lines.Earnings Attached FlagLINE_TRANS_EARNINGS_ATTACHE_14LINE_TRANS_EARNINGS_ATTACHE_14267043
Expenditure Item Date Customer Transaction Lines.Expenditure Item DateLINE_TRANS_EXPENDITURE_ITEM_11LINE_TRANS_EXPENDITURE_ITEM_11267025
Expenditure Type Customer Transaction Lines.Expenditure TypeLINE_TRANS_EXPENDITURE_TYPE_11LINE_TRANS_EXPENDITURE_TYPE_11267027
FED_TRIB Customer Transaction Lines.FED_TRIBGLOBAL_FLEX_FED_TRIB_4GLOBAL_FLEX_FED_TRIB_4267128
FINAL_VAT_REQUEST_ID Customer Transaction Lines.FINAL_VAT_REQUEST_IDGLOBAL_FLEX_FINAL_VAT_REQUES_5GLOBAL_FLEX_FINAL_VAT_REQUES_5267132
FINAL_VAT_REQUEST_ID 1 Customer Transaction Lines.FINAL_VAT_REQUEST_ID 1GLOBAL_FLEX_FINAL_VAT_REQUES_6GLOBAL_FLEX_FINAL_VAT_REQUES_6267133
FINAL_VAT_REQUEST_ID 2 Customer Transaction Lines.FINAL_VAT_REQUEST_ID 2GLOBAL_FLEX_FINAL_VAT_REQUES_7GLOBAL_FLEX_FINAL_VAT_REQUES_7267134
FINAL_VAT_REQUEST_ID 3 Customer Transaction Lines.FINAL_VAT_REQUEST_ID 3GLOBAL_FLEX_FINAL_VAT_REQUES_8GLOBAL_FLEX_FINAL_VAT_REQUES_8267135
Federal Tributary Situation Customer Transaction Lines.Federal Tributary SituationGLOBAL_FLEX_FEDERAL_TRIB_SIT_4GLOBAL_FLEX_FEDERAL_TRIB_SIT_4267117
Fiscal Classification Code Customer Transaction Lines.Fiscal Classification CodeGLOBAL_FLEX_FISCAL_CLASS_COD_2GLOBAL_FLEX_FISCAL_CLASS_COD_2267090
Fiscal Classification Code 1 Customer Transaction Lines.Fiscal Classification Code 1GLOBAL_FLEX_FISCAL_CLASS_COD_3GLOBAL_FLEX_FISCAL_CLASS_COD_3267101
Fiscal Classification Code 2 Customer Transaction Lines.Fiscal Classification Code 2GLOBAL_FLEX_FISCAL_CLASS_COD_4GLOBAL_FLEX_FISCAL_CLASS_COD_4267113
INSTANCE_NO Customer Transaction Lines.INSTANCE_NOLINE_TRANS_INSTANCE_NO_15LINE_TRANS_INSTANCE_NO_15267049
ITEM_FISC Customer Transaction Lines.ITEM_FISCGLOBAL_FLEX_ITEM_FISC_4GLOBAL_FLEX_ITEM_FISC_4267127
ITEM_ORG Customer Transaction Lines.ITEM_ORGGLOBAL_FLEX_ITEM_ORG_4GLOBAL_FLEX_ITEM_ORG_4267126
Initial Customer Trx Line IdUnique Identifier for Initial Customer Transaction LineCustomer Transaction Lines.Initial Customer Trx Line IdINITIAL_CUSTOMER_TRX_LINE_IDINITIAL_CUSTOMER_TRX_LINE_ID136889
Inventory Item Id Customer Transaction Lines.Inventory Item IdINVENTORY_ITEM_IDINVENTORY_ITEM_ID137210
Invoice Number Customer Transaction Lines.Invoice NumberLINE_TRANS_INVOICE_NUMBER_17LINE_TRANS_INVOICE_NUMBER_17267068
Invoice Number 1 Customer Transaction Lines.Invoice Number 1LINE_TRANS_INVOICE_NUMBER_18LINE_TRANS_INVOICE_NUMBER_18267072
Item Description Customer Transaction Lines.Item DescriptionITEM_DESCRIPTIONITEM_DESCRIPTION137727
Item Fiscal Type Customer Transaction Lines.Item Fiscal TypeGLOBAL_FLEX_ITEM_FISCAL_TYPE_4GLOBAL_FLEX_ITEM_FISCAL_TYPE_4267116
Item Origin Customer Transaction Lines.Item OriginGLOBAL_FLEX_ITEM_ORIGIN_4GLOBAL_FLEX_ITEM_ORIGIN_4267115
Last Update DateStandard WHO column.Customer Transaction Lines.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140500
Last Update Date - Day Customer Transaction Lines.Last Update Date LAST_UPDATE_DATE_DAY183510
Last Update Date - Month Customer Transaction Lines.Last Update Date LAST_UPDATE_DATE_MONTH183938
Last Update Date - Quarter Customer Transaction Lines.Last Update Date LAST_UPDATE_DATE_QUARTER184366
Last Update Date - Year Customer Transaction Lines.Last Update Date LAST_UPDATE_DATE_YEAR184794
Last Updated ByStandard WHO column.Customer Transaction Lines.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139161
Lease Customer Transaction Lines.LeaseLINE_TRANS_LEASE_11LINE_TRANS_LEASE_11267021
Lease Number Customer Transaction Lines.Lease NumberLINE_TRANS_LEASE_NUMBER_11LINE_TRANS_LEASE_NUMBER_11267030
Legal Justification Message 1 Customer Transaction Lines.Legal Justification Message 1GLOBAL_FLEX_LEGAL_JUST_MES_2_1GLOBAL_FLEX_LEGAL_JUST_MES_2_1267093
Legal Justification Message 1 1 Customer Transaction Lines.Legal Justification Message 1 1GLOBAL_FLEX_LEGAL_JUST_MES_3_1GLOBAL_FLEX_LEGAL_JUST_MES_3_1267104
Legal Justification Message 1 2 Customer Transaction Lines.Legal Justification Message 1 2GLOBAL_FLEX_LEGAL_JUST_MES_4_1GLOBAL_FLEX_LEGAL_JUST_MES_4_1267120
Legal Justification Message 2 Customer Transaction Lines.Legal Justification Message 2GLOBAL_FLEX_LEGAL_JUST_MES_2_2GLOBAL_FLEX_LEGAL_JUST_MES_2_2267094
Legal Justification Message 2 1 Customer Transaction Lines.Legal Justification Message 2 1GLOBAL_FLEX_LEGAL_JUST_MES_3_2GLOBAL_FLEX_LEGAL_JUST_MES_3_2267105
Legal Justification Message 2 2 Customer Transaction Lines.Legal Justification Message 2 2GLOBAL_FLEX_LEGAL_JUST_MES_4_2GLOBAL_FLEX_LEGAL_JUST_MES_4_2267121
Legal Justification Message 3 Customer Transaction Lines.Legal Justification Message 3GLOBAL_FLEX_LEGAL_JUST_MESSA_2GLOBAL_FLEX_LEGAL_JUST_MESSA_2267092
Legal Justification Message 3 1 Customer Transaction Lines.Legal Justification Message 3 1GLOBAL_FLEX_LEGAL_JUST_MESSA_3GLOBAL_FLEX_LEGAL_JUST_MESSA_3267103
Legal Justification Message 3 2 Customer Transaction Lines.Legal Justification Message 3 2GLOBAL_FLEX_LEGAL_JUST_MESSA_4GLOBAL_FLEX_LEGAL_JUST_MESSA_4267119
Line ID Customer Transaction Lines.Line IDLINE_TRANS_LINE_ID_2LINE_TRANS_LINE_ID_2266966
Line ID 1 Customer Transaction Lines.Line ID 1LINE_TRANS_LINE_ID_16LINE_TRANS_LINE_ID_16267062
Line Number Customer Transaction Lines.Line NumberLINE_TRANS_LINE_NUMBER_5LINE_TRANS_LINE_NUMBER_5266995
Line Number 1 Customer Transaction Lines.Line Number 1LINE_TRANS_LINE_NUMBER_7LINE_TRANS_LINE_NUMBER_7267012
Line Number 2 Customer Transaction Lines.Line Number 2LINE_TRANS_LINE_NUMBER_18LINE_TRANS_LINE_NUMBER_18267073
Line Type Customer Transaction Lines.Line TypeLINE_TRANS_PAYMENT_NUMBER_21LINE_TRANS_PAYMENT_NUMBER_21267084
Line_TYPE Customer Transaction Lines.Line_TYPELINE_TRANS_LINE_TYPE_15LINE_TRANS_LINE_TYPE_15267055
Loan Id Customer Transaction Lines.Loan IdLINE_TRANS_LOAN_ID_21LINE_TRANS_LOAN_ID_21267082
Loan Number Customer Transaction Lines.Loan NumberLINE_TRANS_AMORTIZATION_SCH_21LINE_TRANS_AMORTIZATION_SCH_21267083
Location Customer Transaction Lines.LocationLINE_TRANS_LOCATION_11LINE_TRANS_LOCATION_11267022
Memo Line Id Customer Transaction Lines.Memo Line IdMEMO_LINE_IDMEMO_LINE_ID147026
N Customer Transaction Lines.NLINE_TRANS_CUSTOMER_REF_10LINE_TRANS_CUSTOMER_REF_10267014
N 1 Customer Transaction Lines.N 1LINE_TRANS_CUSTOMER_SITE_10LINE_TRANS_CUSTOMER_SITE_10267015
N 2 Customer Transaction Lines.N 2LINE_TRANS_BATCH_SOURCE_10LINE_TRANS_BATCH_SOURCE_10267016
N 3 Customer Transaction Lines.N 3LINE_TRANS_PACKAGE_ID_10LINE_TRANS_PACKAGE_ID_10267017
N 4 Customer Transaction Lines.N 4LINE_TRANS_TRX_NUMBER_10LINE_TRANS_TRX_NUMBER_10267018
N 5 Customer Transaction Lines.N 5LINE_TRANS_TRX_TYPE_10LINE_TRANS_TRX_TYPE_10267019
N 6 Customer Transaction Lines.N 6LINE_TRANS_ORIG_TRX_REF_10LINE_TRANS_ORIG_TRX_REF_10267020
Operating Unit Customer Transaction Lines.Operating UnitOPERATING_UNITOPERATING_UNIT149501
Operation Fiscal Code Customer Transaction Lines.Operation Fiscal CodeGLOBAL_FLEX_OPERATION_FISC_C_4GLOBAL_FLEX_OPERATION_FISC_C_4267112
Option Number Customer Transaction Lines.Option NumberLINE_TRANS_OPTION_NUMBER_2LINE_TRANS_OPTION_NUMBER_2266973
Order Line ID Customer Transaction Lines.Order Line IDLINE_TRANS_ORDER_LINE_ID_3LINE_TRANS_ORDER_LINE_ID_3266981
Order Line Number Customer Transaction Lines.Order Line NumberLINE_TRANS_ORDER_LINE_NUMBER_3LINE_TRANS_ORDER_LINE_NUMBER_3266976
Order Number Customer Transaction Lines.Order NumberLINE_TRANS_ORDER_NUMBER_2LINE_TRANS_ORDER_NUMBER_2266961
Order Number 1 Customer Transaction Lines.Order Number 1LINE_TRANS_ORDER_NUMBER_3LINE_TRANS_ORDER_NUMBER_3266975
Order Number 2 Customer Transaction Lines.Order Number 2LINE_TRANS_ORDER_NUMBER_16LINE_TRANS_ORDER_NUMBER_16267057
Order Org ID Customer Transaction Lines.Order Org IDLINE_TRANS_ORDER_ORG_ID_3LINE_TRANS_ORDER_ORG_ID_3266982
Order Type Customer Transaction Lines.Order TypeLINE_TRANS_ORDER_TYPE_2LINE_TRANS_ORDER_TYPE_2266962
Order Type 1 Customer Transaction Lines.Order Type 1LINE_TRANS_ORDER_TYPE_16LINE_TRANS_ORDER_TYPE_16267058
Organization Customer Transaction Lines.OrganizationLINE_TRANS_ORGANIZATION_11LINE_TRANS_ORGANIZATION_11267026
Organization IDOrganization identifier.Customer Transaction Lines.Organization IDORG_IDORG_ID150928
PO Line Location ID Customer Transaction Lines.PO Line Location IDLINE_TRANS_PO_LINE_LOCATION_20LINE_TRANS_PO_LINE_LOCATION_20267079
PO Line Number Customer Transaction Lines.PO Line NumberLINE_TRANS_PO_LINE_NUMBER_20LINE_TRANS_PO_LINE_NUMBER_20267075
PO Number Customer Transaction Lines.PO NumberINV_LINE_INFO_PO_NUMBERINV_LINE_INFO_PO_NUMBER266957
PO Number 1 Customer Transaction Lines.PO Number 1LINE_TRANS_PO_NUMBER_20LINE_TRANS_PO_NUMBER_20267074
POS Price Customer Transaction Lines.POS PriceINV_LINE_INFO_POS_PRICEINV_LINE_INFO_POS_PRICE266956
Parent Amortization ID Customer Transaction Lines.Parent Amortization IDLINE_TRANS_PARENT_AMORTIZAT_21LINE_TRANS_PARENT_AMORTIZAT_21267088
Payment Item Purpose Customer Transaction Lines.Payment Item PurposeLINE_TRANS_PAYMENT_ITEM_PUR_11LINE_TRANS_PAYMENT_ITEM_PUR_11267028
Payment Item Type Customer Transaction Lines.Payment Item TypeLINE_TRANS_PAYMENT_ITEM_TYP_11LINE_TRANS_PAYMENT_ITEM_TYP_11267029
Payment Number Customer Transaction Lines.Payment NumberLINE_TRANS_LINE_TYPE_21LINE_TRANS_LINE_TYPE_21267086
Payment Order Customer Transaction Lines.Payment OrderLINE_TRANS_LOAN_NUMBER_21LINE_TRANS_LOAN_NUMBER_21267085
Pick Slip Customer Transaction Lines.Pick SlipLINE_TRANS_DELIVERY_2LINE_TRANS_DELIVERY_2266963
Picking Line ID Customer Transaction Lines.Picking Line IDLINE_TRANS_PICKING_LINE_ID_2LINE_TRANS_PICKING_LINE_ID_2266967
Picking Line ID 1 Customer Transaction Lines.Picking Line ID 1LINE_TRANS_PICKING_LINE_ID_16LINE_TRANS_PICKING_LINE_ID_16267063
Previous Customer Trx IdUnique Identifier for Previous Customer TransactionCustomer Transaction Lines.Previous Customer Trx IdPREVIOUS_CUSTOMER_TRX_IDPREVIOUS_CUSTOMER_TRX_ID155230
Previous Customer Trx Line IdUnique Identifier for Previous Customer Transaction LineCustomer Transaction Lines.Previous Customer Trx Line IdPREVIOUS_CUSTOMER_TRX_LINE_IDPREVIOUS_CUSTOMER_TRX_LINE_ID155234
Price Adjustment ID Customer Transaction Lines.Price Adjustment IDLINE_TRANS_PRICE_ADJUSTMENT__2LINE_TRANS_PRICE_ADJUSTMENT__2266971
Price Adjustment ID 1 Customer Transaction Lines.Price Adjustment ID 1LINE_TRANS_PRICE_ADJUSTMENT_16LINE_TRANS_PRICE_ADJUSTMENT_16267067
Project Manager Customer Transaction Lines.Project ManagerLINE_TRANS_PROJECT_MANAGER_5LINE_TRANS_PROJECT_MANAGER_5266994
Project Manager 1 Customer Transaction Lines.Project Manager 1LINE_TRANS_PROJECT_MANAGER_7LINE_TRANS_PROJECT_MANAGER_7267010
Project Name Customer Transaction Lines.Project NameLINE_TRANS_PROJECT_NAME_11LINE_TRANS_PROJECT_NAME_11267023
Project Number Customer Transaction Lines.Project NumberLINE_TRANS_PROJECT_NUMBER_5LINE_TRANS_PROJECT_NUMBER_5266990
Project Organization Customer Transaction Lines.Project OrganizationLINE_TRANS_PROJECT_ORGANIZAT_5LINE_TRANS_PROJECT_ORGANIZAT_5266993
Provider Project Number Customer Transaction Lines.Provider Project NumberLINE_TRANS_PROVIDER_PROJECT__7LINE_TRANS_PROVIDER_PROJECT__7267007
Purchasing Operating Unit Customer Transaction Lines.Purchasing Operating UnitLINE_TRANS_PURCHASING_OPERA_20LINE_TRANS_PURCHASING_OPERA_20267077
Quantity Credited Customer Transaction Lines.Quantity CreditedQUANTITY_CREDITEDQUANTITY_CREDITED157286
Quantity Invoiced Customer Transaction Lines.Quantity InvoicedQUANTITY_INVOICEDQUANTITY_INVOICED157291
Quantity Ordered Customer Transaction Lines.Quantity OrderedQUANTITY_ORDEREDQUANTITY_ORDERED157302
Reason Customer Transaction Lines.ReasonREASONREASON266953
Receiving Inventory Org Customer Transaction Lines.Receiving Inventory OrgLINE_TRANS_RECEIVING_INVENT_20LINE_TRANS_RECEIVING_INVENT_20267076
Receiving Operating Unit Customer Transaction Lines.Receiving Operating UnitLINE_TRANS_RECEIVING_OPERATI_7LINE_TRANS_RECEIVING_OPERATI_7267009
Receiving Operating Unit 1 Customer Transaction Lines.Receiving Operating Unit 1LINE_TRANS_RECEIVING_OPERAT_20LINE_TRANS_RECEIVING_OPERAT_20267078
Reference Customer Transaction Lines.ReferenceLINE_TRANS_REFERENCE_3LINE_TRANS_REFERENCE_3266977
Reference 1 Customer Transaction Lines.Reference 1LINE_TRANS_REFERENCE_20LINE_TRANS_REFERENCE_20267080
Rule Start Date Customer Transaction Lines.Rule Start DateRULE_START_DATERULE_START_DATE160423
START_DATE Customer Transaction Lines.START_DATELINE_TRANS_START_DATE_15LINE_TRANS_START_DATE_15267054
STAT_TRIB Customer Transaction Lines.STAT_TRIBGLOBAL_FLEX_STAT_TRIB_4GLOBAL_FLEX_STAT_TRIB_4267129
Sales Order Date Customer Transaction Lines.Sales Order DateSALES_ORDER_DATESALES_ORDER_DATE160665
Sales Order Line Customer Transaction Lines.Sales Order LineSALES_ORDER_LINESALES_ORDER_LINE160671
Sales Order Number Customer Transaction Lines.Sales Order NumberSALES_ORDER_NUMBERSALES_ORDER_NUMBER160679
Sales Order Number 1 Customer Transaction Lines.Sales Order Number 1LINE_TRANS_SALES_ORDER_NUMB_17LINE_TRANS_SALES_ORDER_NUMB_17267069
Selling Operating Unit Customer Transaction Lines.Selling Operating UnitLINE_TRANS_SELLING_OPERATING_3LINE_TRANS_SELLING_OPERATING_3266979
Service Id Customer Transaction Lines.Service IdLINE_TRANS_SERVICE_ID_6LINE_TRANS_SERVICE_ID_6266998
Service Number Customer Transaction Lines.Service NumberLINE_TRANS_SERVICE_NUMBER_2LINE_TRANS_SERVICE_NUMBER_2266974
Service Order Line ID Customer Transaction Lines.Service Order Line IDLINE_TRANS_SERVICE_ORDER_LIN_4LINE_TRANS_SERVICE_ORDER_LIN_4266989
Service Order Number Customer Transaction Lines.Service Order NumberLINE_TRANS_SERVICE_ORDER_NUM_4LINE_TRANS_SERVICE_ORDER_NUM_4266984
Service Order Type Customer Transaction Lines.Service Order TypeLINE_TRANS_REFERENCE_NUMBER_4LINE_TRANS_REFERENCE_NUMBER_4266985
Service Transaction ID Customer Transaction Lines.Service Transaction IDLINE_TRANS_SERVICE_TRAN_ID_4LINE_TRANS_SERVICE_TRAN_ID_4266986
Shipment Number Customer Transaction Lines.Shipment NumberLINE_TRANS_SHIPMENT_NUMBER_2LINE_TRANS_SHIPMENT_NUMBER_2266972
Shipping Operating Unit Customer Transaction Lines.Shipping Operating UnitLINE_TRANS_SHIPPING_OPERATIN_3LINE_TRANS_SHIPPING_OPERATIN_3266980
Shipping Warehouse Customer Transaction Lines.Shipping WarehouseLINE_TRANS_SHIPPING_WAREHOUS_3LINE_TRANS_SHIPPING_WAREHOUS_3266978
State Tributary Situation Customer Transaction Lines.State Tributary SituationGLOBAL_FLEX_STATE_TRIB_SITUA_4GLOBAL_FLEX_STATE_TRIB_SITUA_4267118
Task Customer Transaction Lines.TaskLINE_TRANS_TASK_11LINE_TRANS_TASK_11267024
Tax Base Amount Customer Transaction Lines.Tax Base AmountGLOBAL_FLEX_TAX_BASE_AMOUNT_2GLOBAL_FLEX_TAX_BASE_AMOUNT_2267095
Tax Base Amount 1 Customer Transaction Lines.Tax Base Amount 1GLOBAL_FLEX_TAX_BASE_AMOUNT_3GLOBAL_FLEX_TAX_BASE_AMOUNT_3267106
Tax Base Amount 2 Customer Transaction Lines.Tax Base Amount 2GLOBAL_FLEX_TAX_BASE_AMOUNT_4GLOBAL_FLEX_TAX_BASE_AMOUNT_4267122
Tax Base Rate Customer Transaction Lines.Tax Base RateGLOBAL_FLEX_TAX_BASE_RATE_2GLOBAL_FLEX_TAX_BASE_RATE_2267096
Tax Base Rate 1 Customer Transaction Lines.Tax Base Rate 1GLOBAL_FLEX_TAX_BASE_RATE_3GLOBAL_FLEX_TAX_BASE_RATE_3267107
Tax Base Rate 2 Customer Transaction Lines.Tax Base Rate 2GLOBAL_FLEX_TAX_BASE_RATE_4GLOBAL_FLEX_TAX_BASE_RATE_4267123
Termination End Date Customer Transaction Lines.Termination End DateLINE_TRANS_TERMINATION_END_D_4LINE_TRANS_TERMINATION_END_D_4266988
Termination Start Date Customer Transaction Lines.Termination Start DateLINE_TRANS_TERMINATION_START_4LINE_TRANS_TERMINATION_START_4266987
Transaction Complete Customer Transaction Lines.Transaction CompleteTRANSACTION_COMPLETETRANSACTION_COMPLETE165617
Transaction Condition Class Customer Transaction Lines.Transaction Condition ClassGLOBAL_FLEX_TRANSACTION_COND_2GLOBAL_FLEX_TRANSACTION_COND_2267091
Transaction Condition Class 1 Customer Transaction Lines.Transaction Condition Class 1GLOBAL_FLEX_TRANSACTION_COND_3GLOBAL_FLEX_TRANSACTION_COND_3267102
Transaction Condition Class 2 Customer Transaction Lines.Transaction Condition Class 2GLOBAL_FLEX_TRANSACTION_COND_4GLOBAL_FLEX_TRANSACTION_COND_4267114
Transaction Date Customer Transaction Lines.Transaction DateTRANSACTION_DATETRANSACTION_DATE165633
Transaction Line IdUnique Identifier for Transaction LineCustomer Transaction Lines.Transaction Line IdTRANSACTION_LINE_IDTRANSACTION_LINE_ID165714
Transaction Line NumberThe user-defined sequence number for a GIS transaction line.Customer Transaction Lines.Transaction Line NumberTRANSACTION_LINE_NUMBERTRANSACTION_LINE_NUMBER165721
Transaction Number Customer Transaction Lines.Transaction NumberTRANSACTION_NUMBERTRANSACTION_NUMBER165738
Type Customer Transaction Lines.TypeLINE_TRANS_TYPE_5LINE_TRANS_TYPE_5266996
Type 1 Customer Transaction Lines.Type 1LINE_TRANS_TYPE_7LINE_TRANS_TYPE_7267013
Unit Of Measure Customer Transaction Lines.Unit Of MeasureUNIT_OF_MEASUREUNIT_OF_MEASURE166268
Unit Price Customer Transaction Lines.Unit PriceUNIT_PRICEUNIT_PRICE166303
Uom Code Customer Transaction Lines.Uom CodeUOM_CODEUOM_CODE166407
Warehouse Customer Transaction Lines.WarehouseLINE_TRANS_WAREHOUSE_2LINE_TRANS_WAREHOUSE_2266970
Warehouse 1 Customer Transaction Lines.Warehouse 1LINE_TRANS_WAREHOUSE_16LINE_TRANS_WAREHOUSE_16267066
Waybill Customer Transaction Lines.WaybillLINE_TRANS_WAYBILL_2LINE_TRANS_WAYBILL_2266964
Work Oder Customer Transaction Lines.Work OderLINE_TRANS_WORK_ORDER_18LINE_TRANS_WORK_ORDER_18267070
Work Order Id Customer Transaction Lines.Work Order IdLINE_TRANS_WORK_ORDER_ID_18LINE_TRANS_WORK_ORDER_ID_18267071
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Customer Transaction Lines -> Credit Memo ApplicationsCustomer Transaction Lines.Transaction Line Id = Credit Memo Applications.Transaction Line IdAlways exist in master folderNoneNo
Customer Transaction Lines -> Freight DistributionsCustomer Transaction Lines.Transaction Line Id = Freight Distributions.Customer Trx Line IdMight not exist in master folderOuter join on detail No
Customer Transaction Lines -> Invoice AdjustmentsCustomer Transaction Lines.Transaction Line Id = Invoice Adjustments.Customer Trx Line IdAlways exist in master folderNoneNo
Customer Transaction Lines -> Revenue DistributionsCustomer Transaction Lines.Transaction Line Id = Revenue Distributions.Customer Trx Line IdMight not exist in master folderOuter join on detail No
Customer Transaction Lines -> Tax DistributionsCustomer Transaction Lines.Transaction Line Id = Tax Distributions.Customer Trx Line IdMight not exist in master folderOuter join on detail No
Customer Transaction Lines -> Transaction DistributionsCustomer Transaction Lines.Transaction Line Id = Transaction Distributions.Customer Trx Line IdMight not exist in master folderOuter join on detail No
Customer Transaction Lines -> Unbilled Receivable DistributionsCustomer Transaction Lines.Transaction Line Id = Unbilled Receivable Distributions.Customer Trx Line IdMight not exist in master folderOuter join on detail No
Customer Transaction Lines -> Unearned Revenue DistributionsCustomer Transaction Lines.Transaction Line Id = Unearned Revenue Distributions.Customer Trx Line IdMight not exist in master folderOuter join on detail No