Powered by InfoCaptor


Previous Page   Next Page

Suppliers
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_SUPPLIERSUnknown
NoneNone.POFG_SUPPLIERSUnknown
NoneNone.POFG_SUPPLIERSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Allow Interest Invoices Suppliers.Allow Interest InvoicesALLOW_INTEREST_INVOICESALLOW_INTEREST_INVOICES276614
Allow Substitute Receipt Suppliers.Allow Substitute ReceiptALLOW_SUBSTITUTE_RECEIPTALLOW_SUBSTITUTE_RECEIPT276621
Allow Tax Calc Override Suppliers.Allow Tax Calc OverrideALLOW_TAX_CALC_OVERRIDEALLOW_TAX_CALC_OVERRIDE276599
Allow Unordered Receipt Suppliers.Allow Unordered ReceiptALLOW_UNORDERED_RECEIPTALLOW_UNORDERED_RECEIPT276622
Allow Withholding Flag Suppliers.Allow Withholding FlagALLOW_WITHHOLDING_FLAGALLOW_WITHHOLDING_FLAG276624
Alternate Supplier Name Suppliers.Alternate Supplier NameALTERNATE_SUPPLIER_NAMEALTERNATE_SUPPLIER_NAME115800
Always Take Discount Suppliers.Always Take DiscountALWAYS_TAKE_DISCOUNTALWAYS_TAKE_DISCOUNT276612
Amount Includes Tax Flag Suppliers.Amount Includes Tax FlagAMOUNT_INCLUDES_TAX_FLAGAMOUNT_INCLUDES_TAX_FLAG276601
Bank Branch Type Suppliers.Bank Branch TypeBANK_BRANCH_TYPEBANK_BRANCH_TYPE276627
Bank Charge Bearer Suppliers.Bank Charge BearerBANK_CHARGE_BEARERBANK_CHARGE_BEARER276626
Create Debit Memo Flag Suppliers.Create Debit Memo FlagCREATE_DEBIT_MEMO_FLAGCREATE_DEBIT_MEMO_FLAG276630
Created By Suppliers.Created ByCREATED_BYCREATED_BY125256
Created Date Suppliers.Created DateCREATED_DATECREATED_DATE125431
Created Date - Day Suppliers.Created Date CREATED_DATE_DAY171285
Created Date - Month Suppliers.Created Date CREATED_DATE_MONTH171439
Created Date - Quarter Suppliers.Created Date CREATED_DATE_QUARTER171593
Created Date - Year Suppliers.Created Date CREATED_DATE_YEAR171747
Customer NumberCustomer number with the supplierSuppliers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127729
Early Receipt Allowed DaysMaximum acceptable number of days items can be received earlySuppliers.Early Receipt Allowed DaysEARLY_RECEIPT_ALLOWED_DAYSEARLY_RECEIPT_ALLOWED_DAYS130693
Electronic Data Interchange Payment FormatType of information being transmitted with the funds if using an Electronic Data Interchange Payment Method o. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.Suppliers.Electronic Data Interchange Payment FormatEDI_PAYMENT_FORMATEDI_PAYMENT_FORMAT130716
Electronic Data Interchange Payment MethodIndicates how payment is to be made through Electronic Data Interchange (EDI). Valid methods are ACH, BOP, CWT, FEW, FWT, and SWT.Suppliers.Electronic Data Interchange Payment MethodEDI_PAYMENT_METHODEDI_PAYMENT_METHOD130718
Electronic Data Interchange Remittance InstructionWho will send the remittance advice. Valid values are banks or payables systems.Suppliers.Electronic Data Interchange Remittance InstructionEDI_REMITTANCE_INSTRUCTIONEDI_REMITTANCE_INSTRUCTION130732
Electronic Data Interchange Remittance MethodHow the remittance advice will be sent to the supplierSuppliers.Electronic Data Interchange Remittance MethodEDI_REMITTANCE_METHODEDI_REMITTANCE_METHOD130734
Electronic Data Interchange Transaction HandlingDefines whether the supplier is an Electronic Data Interchange (EDI) partnerSuppliers.Electronic Data Interchange Transaction HandlingEDI_TRANSACTION_HANDLINGEDI_TRANSACTION_HANDLING130736
End Active DateActive end dateSuppliers.End Active DateEND_ACTIVE_DATEEND_ACTIVE_DATE132716
End Active Date - Day Suppliers.End Active Date END_ACTIVE_DATE_DAY178251
End Active Date - Month Suppliers.End Active Date END_ACTIVE_DATE_MONTH178253
End Active Date - Quarter Suppliers.End Active Date END_ACTIVE_DATE_QUARTER178255
End Active Date - Year Suppliers.End Active Date END_ACTIVE_DATE_YEAR178257
Enforce Ship To Location Suppliers.Enforce Ship To LocationENFORCE_SHIP_TO_LOCATIONENFORCE_SHIP_TO_LOCATION276618
Excl Freight From Disc Suppliers.Excl Freight From DiscEXCL_FREIGHT_FROM_DISCEXCL_FREIGHT_FROM_DISC276613
Federal Reportable Flag Suppliers.Federal Reportable FlagFEDERAL_REPORTABLE_FLAGFEDERAL_REPORTABLE_FLAG276602
Free On Board Point Suppliers.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276617
Freight Terms Suppliers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS276616
Future Dated Payment Ccid Suppliers.Future Dated Payment CcidFUTURE_DATED_PAYMENT_CCIDFUTURE_DATED_PAYMENT_CCID276629
Hold All Payments Suppliers.Hold All PaymentsHOLD_ALL_PAYMENTSHOLD_ALL_PAYMENTS276605
Hold By Suppliers.Hold ByHOLD_BYHOLD_BY135834
Hold By Employee Name Suppliers.Hold By Employee NameHOLD_BY_EMPLOYEE_NAMEHOLD_BY_EMPLOYEE_NAME135835
Hold By Employee Number Suppliers.Hold By Employee NumberHOLD_BY_EMPLOYEE_NUMBERHOLD_BY_EMPLOYEE_NUMBER135836
Hold Future Payments Suppliers.Hold Future PaymentsHOLD_FUTURE_PAYMENTSHOLD_FUTURE_PAYMENTS276606
Hold ReasonReason for hold being placed on invoice.Suppliers.Hold ReasonHOLD_REASONHOLD_REASON135853
Hold Unmatched Invoices Suppliers.Hold Unmatched InvoicesHOLD_UNMATCHED_INVOICESHOLD_UNMATCHED_INVOICES276607
Invoice Amount LimitMaximum amount per invoiceSuppliers.Invoice Amount LimitINVOICE_AMOUNT_LIMITINVOICE_AMOUNT_LIMIT137376
Invoice Currency Code Suppliers.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137409
Invoice Currency Name Suppliers.Invoice Currency NameINVOICE_CURRENCY_NAMEINVOICE_CURRENCY_NAME137411
Invoice Matching Suppliers.Invoice MatchingINVOICE_MATCHINGINVOICE_MATCHING276619
Last Updated By Suppliers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139836
Last Updated Date Suppliers.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE140010
Last Updated Date - Day Suppliers.Last Updated Date LAST_UPDATED_DATE_DAY182968
Last Updated Date - Month Suppliers.Last Updated Date LAST_UPDATED_DATE_MONTH183130
Last Updated Date - Quarter Suppliers.Last Updated Date LAST_UPDATED_DATE_QUARTER183292
Last Updated Date - Year Suppliers.Last Updated Date LAST_UPDATED_DATE_YEAR183454
Late Receipt Allowed DaysMaximum acceptable number of days items can be received lateSuppliers.Late Receipt Allowed DaysLATE_RECEIPT_ALLOWED_DAYSLATE_RECEIPT_ALLOWED_DAYS141704
Match Option Suppliers.Match OptionMATCH_OPTIONMATCH_OPTION276628
Minority Group Suppliers.Minority GroupMINORITY_GROUPMINORITY_GROUP276595
Name Control Suppliers.Name ControlNAME_CONTROLNAME_CONTROL147787
Offset Tax Flag Suppliers.Offset Tax FlagOFFSET_TAX_FLAGOFFSET_TAX_FLAG276631
One Time Flag Suppliers.One Time FlagONE_TIME_FLAGONE_TIME_FLAG276594
Organization Type Suppliers.Organization TypeORGANIZATION_TYPEORGANIZATION_TYPE276604
Parent Supplier IDUnique identifier for Parent SupplierSuppliers.Parent Supplier IDPARENT_SUPPLIER_IDPARENT_SUPPLIER_ID151928
Parent Supplier Name Suppliers.Parent Supplier NamePARENT_SUPPLIER_NAMEPARENT_SUPPLIER_NAME151929
Pay Alone Flag Suppliers.Pay Alone FlagPAY_ALONE_FLAGPAY_ALONE_FLAG276615
Pay Date Basis Suppliers.Pay Date BasisPAY_DATE_BASISPAY_DATE_BASIS276610
Pay Group Suppliers.Pay GroupPAY_GROUPPAY_GROUP276608
Payment Currency Code Suppliers.Payment Currency CodePAYMENT_CURRENCY_CODEPAYMENT_CURRENCY_CODE152195
Payment Currency Name Suppliers.Payment Currency NamePAYMENT_CURRENCY_NAMEPAYMENT_CURRENCY_NAME152198
Payment Method Suppliers.Payment MethodPAYMENT_METHODPAYMENT_METHOD276611
Payment PriorityIndicates the lowest payment priority the forecast amount representsfor AP invoice or Purchase order source type.Suppliers.Payment PriorityPAYMENT_PRIORITYPAYMENT_PRIORITY152244
Payment Terms IDUnique identifier for Payment TermsSuppliers.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152275
Payment Terms Name Suppliers.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152291
Purchasing Hold DateDate the supplier was placed on purchasing holdSuppliers.Purchasing Hold DatePURCHASING_HOLD_DATEPURCHASING_HOLD_DATE157087
Purchasing Hold Date - Day Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_DAY189285
Purchasing Hold Date - Month Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_MONTH189287
Purchasing Hold Date - Quarter Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_QUARTER189289
Purchasing Hold Date - Year Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_YEAR189291
Purchasing Hold ReasonReason for placing the supplier on purchasing holdSuppliers.Purchasing Hold ReasonPURCHASING_HOLD_REASONPURCHASING_HOLD_REASON157088
Qty Received Exception Suppliers.Qty Received ExceptionQTY_RECEIVED_EXCEPTIONQTY_RECEIVED_EXCEPTION276620
Qty Received ToleranceQuantity received tolerance percentageSuppliers.Qty Received ToleranceQTY_RECEIVED_TOLERANCEQTY_RECEIVED_TOLERANCE157183
Receipt Days Exception Suppliers.Receipt Days ExceptionRECEIPT_DAYS_EXCEPTIONRECEIPT_DAYS_EXCEPTION276623
Receiving Routing IDUnique identifier for Receiving RoutingSuppliers.Receiving Routing IDRECEIVING_ROUTING_IDRECEIVING_ROUTING_ID158086
Receiving Routing Name Suppliers.Receiving Routing NameRECEIVING_ROUTING_NAMERECEIVING_ROUTING_NAME158095
Small Business Flag Suppliers.Small Business FlagSMALL_BUSINESS_FLAGSMALL_BUSINESS_FLAG276596
Standard Industry ClassStandard industry classification numberSuppliers.Standard Industry ClassSTANDARD_INDUSTRY_CLASSSTANDARD_INDUSTRY_CLASS162828
Start Active DateActive start dateSuppliers.Start Active DateSTART_ACTIVE_DATESTART_ACTIVE_DATE162879
Start Active Date - Day Suppliers.Start Active Date START_ACTIVE_DATE_DAY190747
Start Active Date - Month Suppliers.Start Active Date START_ACTIVE_DATE_MONTH190749
Start Active Date - Quarter Suppliers.Start Active Date START_ACTIVE_DATE_QUARTER190751
Start Active Date - Year Suppliers.Start Active Date START_ACTIVE_DATE_YEAR190753
State Reportable Flag Suppliers.State Reportable FlagSTATE_REPORTABLE_FLAGSTATE_REPORTABLE_FLAG276603
Supplier Employee IDUnique identifier for Supplier EmployeeSuppliers.Supplier Employee IDSUPPLIER_EMPLOYEE_IDSUPPLIER_EMPLOYEE_ID164195
Supplier Employee Name Suppliers.Supplier Employee NameSUPPLIER_EMPLOYEE_NAMESUPPLIER_EMPLOYEE_NAME164196
Supplier Employee Number Suppliers.Supplier Employee NumberSUPPLIER_EMPLOYEE_NUMBERSUPPLIER_EMPLOYEE_NUMBER164197
Supplier IDUnique identifier for the supplierSuppliers.Supplier IDSUPPLIER_IDSUPPLIER_ID164222
Supplier Name Suppliers.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164266
Supplier Number Suppliers.Supplier NumberSUPPLIER_NUMBERSUPPLIER_NUMBER164283
Supplier Type Suppliers.Supplier TypeSUPPLIER_TYPESUPPLIER_TYPE276593
Tax Calculation Level Suppliers.Tax Calculation LevelTAX_CALCULATION_LEVELTAX_CALCULATION_LEVEL276598
Tax Identification NumberTax identification number for 1099Suppliers.Tax Identification NumberTAX_IDENTIFICATION_NUMBERTAX_IDENTIFICATION_NUMBER164770
Tax Reporting Method Suppliers.Tax Reporting MethodTAX_REPORTING_METHODTAX_REPORTING_METHOD164804
Tax Rounding Rule Suppliers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE276600
Tax Verification Date Suppliers.Tax Verification DateTAX_VERIFICATION_DATETAX_VERIFICATION_DATE164852
Tax Verification Date - Day Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_DAY191900
Tax Verification Date - Month Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_MONTH191902
Tax Verification Date - Quarter Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_QUARTER191904
Tax Verification Date - Year Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_YEAR191906
Terms Date Basis Suppliers.Terms Date BasisTERMS_DATE_BASISTERMS_DATE_BASIS276609
Type Of 1099 Suppliers.Type Of 1099TYPE_OF_1099TYPE_OF_1099166173
Validation Number Suppliers.Validation NumberVALIDATION_NUMBERVALIDATION_NUMBER167164
Value Added Tax Registration NumberValue Added Tax (VAT) registration numberSuppliers.Value Added Tax Registration NumberVAT_REGISTRATION_NUMBERVAT_REGISTRATION_NUMBER167396
Withholding Start Date Suppliers.Withholding Start DateWITHHOLDING_START_DATEWITHHOLDING_START_DATE167899
Withholding Start Date - Day Suppliers.Withholding Start Date WITHHOLDING_START_DATE_DAY195182
Withholding Start Date - Month Suppliers.Withholding Start Date WITHHOLDING_START_DATE_MONTH195184
Withholding Start Date - Quarter Suppliers.Withholding Start Date WITHHOLDING_START_DATE_QUARTER195186
Withholding Start Date - Year Suppliers.Withholding Start Date WITHHOLDING_START_DATE_YEAR195188
Withholding Status Type Suppliers.Withholding Status TypeWITHHOLDING_STATUS_TYPEWITHHOLDING_STATUS_TYPE276625
Women Owned Flag Suppliers.Women Owned FlagWOMEN_OWNED_FLAGWOMEN_OWNED_FLAG276597
Allow Interest Invoices Suppliers.Allow Interest InvoicesALLOW_INTEREST_INVOICESALLOW_INTEREST_INVOICES276614
Allow Substitute Receipt Suppliers.Allow Substitute ReceiptALLOW_SUBSTITUTE_RECEIPTALLOW_SUBSTITUTE_RECEIPT276621
Allow Tax Calc Override Suppliers.Allow Tax Calc OverrideALLOW_TAX_CALC_OVERRIDEALLOW_TAX_CALC_OVERRIDE276599
Allow Unordered Receipt Suppliers.Allow Unordered ReceiptALLOW_UNORDERED_RECEIPTALLOW_UNORDERED_RECEIPT276622
Allow Withholding Flag Suppliers.Allow Withholding FlagALLOW_WITHHOLDING_FLAGALLOW_WITHHOLDING_FLAG276624
Alternate Supplier Name Suppliers.Alternate Supplier NameALTERNATE_SUPPLIER_NAMEALTERNATE_SUPPLIER_NAME115800
Always Take Discount Suppliers.Always Take DiscountALWAYS_TAKE_DISCOUNTALWAYS_TAKE_DISCOUNT276612
Amount Includes Tax Flag Suppliers.Amount Includes Tax FlagAMOUNT_INCLUDES_TAX_FLAGAMOUNT_INCLUDES_TAX_FLAG276601
Bank Branch Type Suppliers.Bank Branch TypeBANK_BRANCH_TYPEBANK_BRANCH_TYPE276627
Bank Charge Bearer Suppliers.Bank Charge BearerBANK_CHARGE_BEARERBANK_CHARGE_BEARER276626
Create Debit Memo Flag Suppliers.Create Debit Memo FlagCREATE_DEBIT_MEMO_FLAGCREATE_DEBIT_MEMO_FLAG276630
Created By Suppliers.Created ByCREATED_BYCREATED_BY125256
Created Date Suppliers.Created DateCREATED_DATECREATED_DATE125431
Created Date - Day Suppliers.Created Date CREATED_DATE_DAY171285
Created Date - Month Suppliers.Created Date CREATED_DATE_MONTH171439
Created Date - Quarter Suppliers.Created Date CREATED_DATE_QUARTER171593
Created Date - Year Suppliers.Created Date CREATED_DATE_YEAR171747
Customer NumberCustomer number with the supplierSuppliers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127729
Early Receipt Allowed DaysMaximum acceptable number of days items can be received earlySuppliers.Early Receipt Allowed DaysEARLY_RECEIPT_ALLOWED_DAYSEARLY_RECEIPT_ALLOWED_DAYS130693
Electronic Data Interchange Payment FormatType of information being transmitted with the funds if using an Electronic Data Interchange Payment Method o. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.Suppliers.Electronic Data Interchange Payment FormatEDI_PAYMENT_FORMATEDI_PAYMENT_FORMAT130716
Electronic Data Interchange Payment MethodIndicates how payment is to be made through Electronic Data Interchange (EDI). Valid methods are ACH, BOP, CWT, FEW, FWT, and SWT.Suppliers.Electronic Data Interchange Payment MethodEDI_PAYMENT_METHODEDI_PAYMENT_METHOD130718
Electronic Data Interchange Remittance InstructionWho will send the remittance advice. Valid values are banks or payables systems.Suppliers.Electronic Data Interchange Remittance InstructionEDI_REMITTANCE_INSTRUCTIONEDI_REMITTANCE_INSTRUCTION130732
Electronic Data Interchange Remittance MethodHow the remittance advice will be sent to the supplierSuppliers.Electronic Data Interchange Remittance MethodEDI_REMITTANCE_METHODEDI_REMITTANCE_METHOD130734
Electronic Data Interchange Transaction HandlingDefines whether the supplier is an Electronic Data Interchange (EDI) partnerSuppliers.Electronic Data Interchange Transaction HandlingEDI_TRANSACTION_HANDLINGEDI_TRANSACTION_HANDLING130736
End Active DateActive end dateSuppliers.End Active DateEND_ACTIVE_DATEEND_ACTIVE_DATE132716
End Active Date - Day Suppliers.End Active Date END_ACTIVE_DATE_DAY178251
End Active Date - Month Suppliers.End Active Date END_ACTIVE_DATE_MONTH178253
End Active Date - Quarter Suppliers.End Active Date END_ACTIVE_DATE_QUARTER178255
End Active Date - Year Suppliers.End Active Date END_ACTIVE_DATE_YEAR178257
Enforce Ship To Location Suppliers.Enforce Ship To LocationENFORCE_SHIP_TO_LOCATIONENFORCE_SHIP_TO_LOCATION276618
Excl Freight From Disc Suppliers.Excl Freight From DiscEXCL_FREIGHT_FROM_DISCEXCL_FREIGHT_FROM_DISC276613
Federal Reportable Flag Suppliers.Federal Reportable FlagFEDERAL_REPORTABLE_FLAGFEDERAL_REPORTABLE_FLAG276602
Free On Board Point Suppliers.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276617
Freight Terms Suppliers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS276616
Future Dated Payment Ccid Suppliers.Future Dated Payment CcidFUTURE_DATED_PAYMENT_CCIDFUTURE_DATED_PAYMENT_CCID276629
Hold All Payments Suppliers.Hold All PaymentsHOLD_ALL_PAYMENTSHOLD_ALL_PAYMENTS276605
Hold By Suppliers.Hold ByHOLD_BYHOLD_BY135834
Hold By Employee Name Suppliers.Hold By Employee NameHOLD_BY_EMPLOYEE_NAMEHOLD_BY_EMPLOYEE_NAME135835
Hold By Employee Number Suppliers.Hold By Employee NumberHOLD_BY_EMPLOYEE_NUMBERHOLD_BY_EMPLOYEE_NUMBER135836
Hold Future Payments Suppliers.Hold Future PaymentsHOLD_FUTURE_PAYMENTSHOLD_FUTURE_PAYMENTS276606
Hold ReasonReason for hold being placed on invoice.Suppliers.Hold ReasonHOLD_REASONHOLD_REASON135853
Hold Unmatched Invoices Suppliers.Hold Unmatched InvoicesHOLD_UNMATCHED_INVOICESHOLD_UNMATCHED_INVOICES276607
Invoice Amount LimitMaximum amount per invoiceSuppliers.Invoice Amount LimitINVOICE_AMOUNT_LIMITINVOICE_AMOUNT_LIMIT137376
Invoice Currency Code Suppliers.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137409
Invoice Currency Name Suppliers.Invoice Currency NameINVOICE_CURRENCY_NAMEINVOICE_CURRENCY_NAME137411
Invoice Matching Suppliers.Invoice MatchingINVOICE_MATCHINGINVOICE_MATCHING276619
Last Updated By Suppliers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139836
Last Updated Date Suppliers.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE140010
Last Updated Date - Day Suppliers.Last Updated Date LAST_UPDATED_DATE_DAY182968
Last Updated Date - Month Suppliers.Last Updated Date LAST_UPDATED_DATE_MONTH183130
Last Updated Date - Quarter Suppliers.Last Updated Date LAST_UPDATED_DATE_QUARTER183292
Last Updated Date - Year Suppliers.Last Updated Date LAST_UPDATED_DATE_YEAR183454
Late Receipt Allowed DaysMaximum acceptable number of days items can be received lateSuppliers.Late Receipt Allowed DaysLATE_RECEIPT_ALLOWED_DAYSLATE_RECEIPT_ALLOWED_DAYS141704
Match Option Suppliers.Match OptionMATCH_OPTIONMATCH_OPTION276628
Minority Group Suppliers.Minority GroupMINORITY_GROUPMINORITY_GROUP276595
Name Control Suppliers.Name ControlNAME_CONTROLNAME_CONTROL147787
Offset Tax Flag Suppliers.Offset Tax FlagOFFSET_TAX_FLAGOFFSET_TAX_FLAG276631
One Time Flag Suppliers.One Time FlagONE_TIME_FLAGONE_TIME_FLAG276594
Organization Type Suppliers.Organization TypeORGANIZATION_TYPEORGANIZATION_TYPE276604
Parent Supplier IDUnique identifier for Parent SupplierSuppliers.Parent Supplier IDPARENT_SUPPLIER_IDPARENT_SUPPLIER_ID151928
Parent Supplier Name Suppliers.Parent Supplier NamePARENT_SUPPLIER_NAMEPARENT_SUPPLIER_NAME151929
Pay Alone Flag Suppliers.Pay Alone FlagPAY_ALONE_FLAGPAY_ALONE_FLAG276615
Pay Date Basis Suppliers.Pay Date BasisPAY_DATE_BASISPAY_DATE_BASIS276610
Pay Group Suppliers.Pay GroupPAY_GROUPPAY_GROUP276608
Payment Currency Code Suppliers.Payment Currency CodePAYMENT_CURRENCY_CODEPAYMENT_CURRENCY_CODE152195
Payment Currency Name Suppliers.Payment Currency NamePAYMENT_CURRENCY_NAMEPAYMENT_CURRENCY_NAME152198
Payment Method Suppliers.Payment MethodPAYMENT_METHODPAYMENT_METHOD276611
Payment PriorityIndicates the lowest payment priority the forecast amount representsfor AP invoice or Purchase order source type.Suppliers.Payment PriorityPAYMENT_PRIORITYPAYMENT_PRIORITY152244
Payment Terms IDUnique identifier for Payment TermsSuppliers.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152275
Payment Terms Name Suppliers.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152291
Purchasing Hold DateDate the supplier was placed on purchasing holdSuppliers.Purchasing Hold DatePURCHASING_HOLD_DATEPURCHASING_HOLD_DATE157087
Purchasing Hold Date - Day Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_DAY189285
Purchasing Hold Date - Month Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_MONTH189287
Purchasing Hold Date - Quarter Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_QUARTER189289
Purchasing Hold Date - Year Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_YEAR189291
Purchasing Hold ReasonReason for placing the supplier on purchasing holdSuppliers.Purchasing Hold ReasonPURCHASING_HOLD_REASONPURCHASING_HOLD_REASON157088
Qty Received Exception Suppliers.Qty Received ExceptionQTY_RECEIVED_EXCEPTIONQTY_RECEIVED_EXCEPTION276620
Qty Received ToleranceQuantity received tolerance percentageSuppliers.Qty Received ToleranceQTY_RECEIVED_TOLERANCEQTY_RECEIVED_TOLERANCE157183
Receipt Days Exception Suppliers.Receipt Days ExceptionRECEIPT_DAYS_EXCEPTIONRECEIPT_DAYS_EXCEPTION276623
Receiving Routing IDUnique identifier for Receiving RoutingSuppliers.Receiving Routing IDRECEIVING_ROUTING_IDRECEIVING_ROUTING_ID158086
Receiving Routing Name Suppliers.Receiving Routing NameRECEIVING_ROUTING_NAMERECEIVING_ROUTING_NAME158095
Small Business Flag Suppliers.Small Business FlagSMALL_BUSINESS_FLAGSMALL_BUSINESS_FLAG276596
Standard Industry ClassStandard industry classification numberSuppliers.Standard Industry ClassSTANDARD_INDUSTRY_CLASSSTANDARD_INDUSTRY_CLASS162828
Start Active DateActive start dateSuppliers.Start Active DateSTART_ACTIVE_DATESTART_ACTIVE_DATE162879
Start Active Date - Day Suppliers.Start Active Date START_ACTIVE_DATE_DAY190747
Start Active Date - Month Suppliers.Start Active Date START_ACTIVE_DATE_MONTH190749
Start Active Date - Quarter Suppliers.Start Active Date START_ACTIVE_DATE_QUARTER190751
Start Active Date - Year Suppliers.Start Active Date START_ACTIVE_DATE_YEAR190753
State Reportable Flag Suppliers.State Reportable FlagSTATE_REPORTABLE_FLAGSTATE_REPORTABLE_FLAG276603
Supplier Employee IDUnique identifier for Supplier EmployeeSuppliers.Supplier Employee IDSUPPLIER_EMPLOYEE_IDSUPPLIER_EMPLOYEE_ID164195
Supplier Employee Name Suppliers.Supplier Employee NameSUPPLIER_EMPLOYEE_NAMESUPPLIER_EMPLOYEE_NAME164196
Supplier Employee Number Suppliers.Supplier Employee NumberSUPPLIER_EMPLOYEE_NUMBERSUPPLIER_EMPLOYEE_NUMBER164197
Supplier IDUnique identifier for the supplierSuppliers.Supplier IDSUPPLIER_IDSUPPLIER_ID164222
Supplier Name Suppliers.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164266
Supplier Number Suppliers.Supplier NumberSUPPLIER_NUMBERSUPPLIER_NUMBER164283
Supplier Type Suppliers.Supplier TypeSUPPLIER_TYPESUPPLIER_TYPE276593
Tax Calculation Level Suppliers.Tax Calculation LevelTAX_CALCULATION_LEVELTAX_CALCULATION_LEVEL276598
Tax Identification NumberTax identification number for 1099Suppliers.Tax Identification NumberTAX_IDENTIFICATION_NUMBERTAX_IDENTIFICATION_NUMBER164770
Tax Reporting Method Suppliers.Tax Reporting MethodTAX_REPORTING_METHODTAX_REPORTING_METHOD164804
Tax Rounding Rule Suppliers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE276600
Tax Verification Date Suppliers.Tax Verification DateTAX_VERIFICATION_DATETAX_VERIFICATION_DATE164852
Tax Verification Date - Day Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_DAY191900
Tax Verification Date - Month Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_MONTH191902
Tax Verification Date - Quarter Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_QUARTER191904
Tax Verification Date - Year Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_YEAR191906
Terms Date Basis Suppliers.Terms Date BasisTERMS_DATE_BASISTERMS_DATE_BASIS276609
Type Of 1099 Suppliers.Type Of 1099TYPE_OF_1099TYPE_OF_1099166173
Validation Number Suppliers.Validation NumberVALIDATION_NUMBERVALIDATION_NUMBER167164
Value Added Tax Registration NumberValue Added Tax (VAT) registration numberSuppliers.Value Added Tax Registration NumberVAT_REGISTRATION_NUMBERVAT_REGISTRATION_NUMBER167396
Withholding Start Date Suppliers.Withholding Start DateWITHHOLDING_START_DATEWITHHOLDING_START_DATE167899
Withholding Start Date - Day Suppliers.Withholding Start Date WITHHOLDING_START_DATE_DAY195182
Withholding Start Date - Month Suppliers.Withholding Start Date WITHHOLDING_START_DATE_MONTH195184
Withholding Start Date - Quarter Suppliers.Withholding Start Date WITHHOLDING_START_DATE_QUARTER195186
Withholding Start Date - Year Suppliers.Withholding Start Date WITHHOLDING_START_DATE_YEAR195188
Withholding Status Type Suppliers.Withholding Status TypeWITHHOLDING_STATUS_TYPEWITHHOLDING_STATUS_TYPE276625
Women Owned Flag Suppliers.Women Owned FlagWOMEN_OWNED_FLAGWOMEN_OWNED_FLAG276597
Allow Interest Invoices Suppliers.Allow Interest InvoicesALLOW_INTEREST_INVOICESALLOW_INTEREST_INVOICES276614
Allow Substitute Receipt Suppliers.Allow Substitute ReceiptALLOW_SUBSTITUTE_RECEIPTALLOW_SUBSTITUTE_RECEIPT276621
Allow Tax Calc Override Suppliers.Allow Tax Calc OverrideALLOW_TAX_CALC_OVERRIDEALLOW_TAX_CALC_OVERRIDE276599
Allow Unordered Receipt Suppliers.Allow Unordered ReceiptALLOW_UNORDERED_RECEIPTALLOW_UNORDERED_RECEIPT276622
Allow Withholding Flag Suppliers.Allow Withholding FlagALLOW_WITHHOLDING_FLAGALLOW_WITHHOLDING_FLAG276624
Alternate Supplier Name Suppliers.Alternate Supplier NameALTERNATE_SUPPLIER_NAMEALTERNATE_SUPPLIER_NAME115800
Always Take Discount Suppliers.Always Take DiscountALWAYS_TAKE_DISCOUNTALWAYS_TAKE_DISCOUNT276612
Amount Includes Tax Flag Suppliers.Amount Includes Tax FlagAMOUNT_INCLUDES_TAX_FLAGAMOUNT_INCLUDES_TAX_FLAG276601
Bank Branch Type Suppliers.Bank Branch TypeBANK_BRANCH_TYPEBANK_BRANCH_TYPE276627
Bank Charge Bearer Suppliers.Bank Charge BearerBANK_CHARGE_BEARERBANK_CHARGE_BEARER276626
Create Debit Memo Flag Suppliers.Create Debit Memo FlagCREATE_DEBIT_MEMO_FLAGCREATE_DEBIT_MEMO_FLAG276630
Created By Suppliers.Created ByCREATED_BYCREATED_BY125256
Created Date Suppliers.Created DateCREATED_DATECREATED_DATE125431
Created Date - Day Suppliers.Created Date CREATED_DATE_DAY171285
Created Date - Month Suppliers.Created Date CREATED_DATE_MONTH171439
Created Date - Quarter Suppliers.Created Date CREATED_DATE_QUARTER171593
Created Date - Year Suppliers.Created Date CREATED_DATE_YEAR171747
Customer NumberCustomer number with the supplierSuppliers.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127729
Early Receipt Allowed DaysMaximum acceptable number of days items can be received earlySuppliers.Early Receipt Allowed DaysEARLY_RECEIPT_ALLOWED_DAYSEARLY_RECEIPT_ALLOWED_DAYS130693
Electronic Data Interchange Payment FormatType of information being transmitted with the funds if using an Electronic Data Interchange Payment Method o. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.Suppliers.Electronic Data Interchange Payment FormatEDI_PAYMENT_FORMATEDI_PAYMENT_FORMAT130716
Electronic Data Interchange Payment MethodIndicates how payment is to be made through Electronic Data Interchange (EDI). Valid methods are ACH, BOP, CWT, FEW, FWT, and SWT.Suppliers.Electronic Data Interchange Payment MethodEDI_PAYMENT_METHODEDI_PAYMENT_METHOD130718
Electronic Data Interchange Remittance InstructionWho will send the remittance advice. Valid values are banks or payables systems.Suppliers.Electronic Data Interchange Remittance InstructionEDI_REMITTANCE_INSTRUCTIONEDI_REMITTANCE_INSTRUCTION130732
Electronic Data Interchange Remittance MethodHow the remittance advice will be sent to the supplierSuppliers.Electronic Data Interchange Remittance MethodEDI_REMITTANCE_METHODEDI_REMITTANCE_METHOD130734
Electronic Data Interchange Transaction HandlingDefines whether the supplier is an Electronic Data Interchange (EDI) partnerSuppliers.Electronic Data Interchange Transaction HandlingEDI_TRANSACTION_HANDLINGEDI_TRANSACTION_HANDLING130736
End Active DateActive end dateSuppliers.End Active DateEND_ACTIVE_DATEEND_ACTIVE_DATE132716
End Active Date - Day Suppliers.End Active Date END_ACTIVE_DATE_DAY178251
End Active Date - Month Suppliers.End Active Date END_ACTIVE_DATE_MONTH178253
End Active Date - Quarter Suppliers.End Active Date END_ACTIVE_DATE_QUARTER178255
End Active Date - Year Suppliers.End Active Date END_ACTIVE_DATE_YEAR178257
Enforce Ship To Location Suppliers.Enforce Ship To LocationENFORCE_SHIP_TO_LOCATIONENFORCE_SHIP_TO_LOCATION276618
Excl Freight From Disc Suppliers.Excl Freight From DiscEXCL_FREIGHT_FROM_DISCEXCL_FREIGHT_FROM_DISC276613
Federal Reportable Flag Suppliers.Federal Reportable FlagFEDERAL_REPORTABLE_FLAGFEDERAL_REPORTABLE_FLAG276602
Free On Board Point Suppliers.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276617
Freight Terms Suppliers.Freight TermsFREIGHT_TERMSFREIGHT_TERMS276616
Future Dated Payment Ccid Suppliers.Future Dated Payment CcidFUTURE_DATED_PAYMENT_CCIDFUTURE_DATED_PAYMENT_CCID276629
Hold All Payments Suppliers.Hold All PaymentsHOLD_ALL_PAYMENTSHOLD_ALL_PAYMENTS276605
Hold By Suppliers.Hold ByHOLD_BYHOLD_BY135834
Hold By Employee Name Suppliers.Hold By Employee NameHOLD_BY_EMPLOYEE_NAMEHOLD_BY_EMPLOYEE_NAME135835
Hold By Employee Number Suppliers.Hold By Employee NumberHOLD_BY_EMPLOYEE_NUMBERHOLD_BY_EMPLOYEE_NUMBER135836
Hold Future Payments Suppliers.Hold Future PaymentsHOLD_FUTURE_PAYMENTSHOLD_FUTURE_PAYMENTS276606
Hold ReasonReason for hold being placed on invoice.Suppliers.Hold ReasonHOLD_REASONHOLD_REASON135853
Hold Unmatched Invoices Suppliers.Hold Unmatched InvoicesHOLD_UNMATCHED_INVOICESHOLD_UNMATCHED_INVOICES276607
Invoice Amount LimitMaximum amount per invoiceSuppliers.Invoice Amount LimitINVOICE_AMOUNT_LIMITINVOICE_AMOUNT_LIMIT137376
Invoice Currency Code Suppliers.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137409
Invoice Currency Name Suppliers.Invoice Currency NameINVOICE_CURRENCY_NAMEINVOICE_CURRENCY_NAME137411
Invoice Matching Suppliers.Invoice MatchingINVOICE_MATCHINGINVOICE_MATCHING276619
Last Updated By Suppliers.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139836
Last Updated Date Suppliers.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE140010
Last Updated Date - Day Suppliers.Last Updated Date LAST_UPDATED_DATE_DAY182968
Last Updated Date - Month Suppliers.Last Updated Date LAST_UPDATED_DATE_MONTH183130
Last Updated Date - Quarter Suppliers.Last Updated Date LAST_UPDATED_DATE_QUARTER183292
Last Updated Date - Year Suppliers.Last Updated Date LAST_UPDATED_DATE_YEAR183454
Late Receipt Allowed DaysMaximum acceptable number of days items can be received lateSuppliers.Late Receipt Allowed DaysLATE_RECEIPT_ALLOWED_DAYSLATE_RECEIPT_ALLOWED_DAYS141704
Match Option Suppliers.Match OptionMATCH_OPTIONMATCH_OPTION276628
Minority Group Suppliers.Minority GroupMINORITY_GROUPMINORITY_GROUP276595
Name Control Suppliers.Name ControlNAME_CONTROLNAME_CONTROL147787
Offset Tax Flag Suppliers.Offset Tax FlagOFFSET_TAX_FLAGOFFSET_TAX_FLAG276631
One Time Flag Suppliers.One Time FlagONE_TIME_FLAGONE_TIME_FLAG276594
Organization Type Suppliers.Organization TypeORGANIZATION_TYPEORGANIZATION_TYPE276604
Parent Supplier IDUnique identifier for Parent SupplierSuppliers.Parent Supplier IDPARENT_SUPPLIER_IDPARENT_SUPPLIER_ID151928
Parent Supplier Name Suppliers.Parent Supplier NamePARENT_SUPPLIER_NAMEPARENT_SUPPLIER_NAME151929
Pay Alone Flag Suppliers.Pay Alone FlagPAY_ALONE_FLAGPAY_ALONE_FLAG276615
Pay Date Basis Suppliers.Pay Date BasisPAY_DATE_BASISPAY_DATE_BASIS276610
Pay Group Suppliers.Pay GroupPAY_GROUPPAY_GROUP276608
Payment Currency Code Suppliers.Payment Currency CodePAYMENT_CURRENCY_CODEPAYMENT_CURRENCY_CODE152195
Payment Currency Name Suppliers.Payment Currency NamePAYMENT_CURRENCY_NAMEPAYMENT_CURRENCY_NAME152198
Payment Method Suppliers.Payment MethodPAYMENT_METHODPAYMENT_METHOD276611
Payment PriorityIndicates the lowest payment priority the forecast amount representsfor AP invoice or Purchase order source type.Suppliers.Payment PriorityPAYMENT_PRIORITYPAYMENT_PRIORITY152244
Payment Terms IDUnique identifier for Payment TermsSuppliers.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152275
Payment Terms Name Suppliers.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152291
Purchasing Hold DateDate the supplier was placed on purchasing holdSuppliers.Purchasing Hold DatePURCHASING_HOLD_DATEPURCHASING_HOLD_DATE157087
Purchasing Hold Date - Day Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_DAY189285
Purchasing Hold Date - Month Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_MONTH189287
Purchasing Hold Date - Quarter Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_QUARTER189289
Purchasing Hold Date - Year Suppliers.Purchasing Hold Date PURCHASING_HOLD_DATE_YEAR189291
Purchasing Hold ReasonReason for placing the supplier on purchasing holdSuppliers.Purchasing Hold ReasonPURCHASING_HOLD_REASONPURCHASING_HOLD_REASON157088
Qty Received Exception Suppliers.Qty Received ExceptionQTY_RECEIVED_EXCEPTIONQTY_RECEIVED_EXCEPTION276620
Qty Received ToleranceQuantity received tolerance percentageSuppliers.Qty Received ToleranceQTY_RECEIVED_TOLERANCEQTY_RECEIVED_TOLERANCE157183
Receipt Days Exception Suppliers.Receipt Days ExceptionRECEIPT_DAYS_EXCEPTIONRECEIPT_DAYS_EXCEPTION276623
Receiving Routing IDUnique identifier for Receiving RoutingSuppliers.Receiving Routing IDRECEIVING_ROUTING_IDRECEIVING_ROUTING_ID158086
Receiving Routing Name Suppliers.Receiving Routing NameRECEIVING_ROUTING_NAMERECEIVING_ROUTING_NAME158095
Small Business Flag Suppliers.Small Business FlagSMALL_BUSINESS_FLAGSMALL_BUSINESS_FLAG276596
Standard Industry ClassStandard industry classification numberSuppliers.Standard Industry ClassSTANDARD_INDUSTRY_CLASSSTANDARD_INDUSTRY_CLASS162828
Start Active DateActive start dateSuppliers.Start Active DateSTART_ACTIVE_DATESTART_ACTIVE_DATE162879
Start Active Date - Day Suppliers.Start Active Date START_ACTIVE_DATE_DAY190747
Start Active Date - Month Suppliers.Start Active Date START_ACTIVE_DATE_MONTH190749
Start Active Date - Quarter Suppliers.Start Active Date START_ACTIVE_DATE_QUARTER190751
Start Active Date - Year Suppliers.Start Active Date START_ACTIVE_DATE_YEAR190753
State Reportable Flag Suppliers.State Reportable FlagSTATE_REPORTABLE_FLAGSTATE_REPORTABLE_FLAG276603
Supplier Employee IDUnique identifier for Supplier EmployeeSuppliers.Supplier Employee IDSUPPLIER_EMPLOYEE_IDSUPPLIER_EMPLOYEE_ID164195
Supplier Employee Name Suppliers.Supplier Employee NameSUPPLIER_EMPLOYEE_NAMESUPPLIER_EMPLOYEE_NAME164196
Supplier Employee Number Suppliers.Supplier Employee NumberSUPPLIER_EMPLOYEE_NUMBERSUPPLIER_EMPLOYEE_NUMBER164197
Supplier IDUnique identifier for the supplierSuppliers.Supplier IDSUPPLIER_IDSUPPLIER_ID164222
Supplier Name Suppliers.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164266
Supplier Number Suppliers.Supplier NumberSUPPLIER_NUMBERSUPPLIER_NUMBER164283
Supplier Type Suppliers.Supplier TypeSUPPLIER_TYPESUPPLIER_TYPE276593
Tax Calculation Level Suppliers.Tax Calculation LevelTAX_CALCULATION_LEVELTAX_CALCULATION_LEVEL276598
Tax Identification NumberTax identification number for 1099Suppliers.Tax Identification NumberTAX_IDENTIFICATION_NUMBERTAX_IDENTIFICATION_NUMBER164770
Tax Reporting Method Suppliers.Tax Reporting MethodTAX_REPORTING_METHODTAX_REPORTING_METHOD164804
Tax Rounding Rule Suppliers.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE276600
Tax Verification Date Suppliers.Tax Verification DateTAX_VERIFICATION_DATETAX_VERIFICATION_DATE164852
Tax Verification Date - Day Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_DAY191900
Tax Verification Date - Month Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_MONTH191902
Tax Verification Date - Quarter Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_QUARTER191904
Tax Verification Date - Year Suppliers.Tax Verification Date TAX_VERIFICATION_DATE_YEAR191906
Terms Date Basis Suppliers.Terms Date BasisTERMS_DATE_BASISTERMS_DATE_BASIS276609
Type Of 1099 Suppliers.Type Of 1099TYPE_OF_1099TYPE_OF_1099166173
Validation Number Suppliers.Validation NumberVALIDATION_NUMBERVALIDATION_NUMBER167164
Value Added Tax Registration NumberValue Added Tax (VAT) registration numberSuppliers.Value Added Tax Registration NumberVAT_REGISTRATION_NUMBERVAT_REGISTRATION_NUMBER167396
Withholding Start Date Suppliers.Withholding Start DateWITHHOLDING_START_DATEWITHHOLDING_START_DATE167899
Withholding Start Date - Day Suppliers.Withholding Start Date WITHHOLDING_START_DATE_DAY195182
Withholding Start Date - Month Suppliers.Withholding Start Date WITHHOLDING_START_DATE_MONTH195184
Withholding Start Date - Quarter Suppliers.Withholding Start Date WITHHOLDING_START_DATE_QUARTER195186
Withholding Start Date - Year Suppliers.Withholding Start Date WITHHOLDING_START_DATE_YEAR195188
Withholding Status Type Suppliers.Withholding Status TypeWITHHOLDING_STATUS_TYPEWITHHOLDING_STATUS_TYPE276625
Women Owned Flag Suppliers.Women Owned FlagWOMEN_OWNED_FLAGWOMEN_OWNED_FLAG276597
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Suppliers -> Approved Supplier ListsSuppliers.Supplier ID = Approved Supplier Lists.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Blanket Purcahse Order ReleasesSuppliers.Supplier ID = Blanket Purcahse Order Releases.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Blanket Purchase OrdersSuppliers.Supplier ID = Blanket Purchase Orders.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Inbound Shipment LinesSuppliers.Supplier ID = Inbound Shipment Lines.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> InvoicesSuppliers.Supplier ID = Invoices.Vendor IdAlways exist in master folderNoneNo
Suppliers -> PaymentsSuppliers.Supplier ID = Payments.Vendor IdAlways exist in master folderNoneNo
Suppliers -> Planned Purchase Order ReleasesSuppliers.Supplier ID = Planned Purchase Order Releases.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Planned Purchase OrdersSuppliers.Supplier ID = Planned Purchase Orders.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Purchase ContractsSuppliers.Supplier ID = Purchase Contracts.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Purchase OrdersSuppliers.Supplier ID = Purchase Orders.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> QuotationsSuppliers.Supplier ID = Quotations.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Receiving TransactionsSuppliers.Supplier ID = Receiving Transactions.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Request For QuotationSuppliers.Supplier ID = Request For Quotation.Supplier IDMight not exist in master folderOuter join on master No
Suppliers -> Request For Quotation Supplier List EntriesSuppliers.Supplier ID = Request For Quotation Supplier List Entries.Supplier IdAlways exist in master folderNoneNo
Suppliers -> Request For Quotation SuppliersSuppliers.Supplier ID = Request For Quotation Suppliers.Supplier IDAlways exist in master folderNoneNo
Suppliers -> Standard Purchase OrdersSuppliers.Supplier ID = Standard Purchase Orders.Supplier IDMight not exist in master folderOuter join on master No
Folder Filters
Used In ConditionItemBa NameBase ObjectFilter NameFilter TypeFolder Name
Hierarchies
Hierarchy NameCreated ByHierarchy LevelHierarchy Details
Bank Accounts: Inactive DateSystem1Bank Accounts: Inactive Date - Year
Bank Accounts: Inactive DateSystem2 ^------Bank Accounts: Inactive Date - Quarter
Bank Accounts: Inactive DateSystem3 ^------Bank Accounts: Inactive Date - Month
Bank Accounts: Inactive DateSystem4 ^------Bank Accounts: Inactive Date - Day
Bank Accounts: Inactive DateSystem5 ^------Bank Accounts: Inactive Date
Bank Branches: End Effective DateSystem1Bank Branches: End Effective Date - Year
Bank Branches: End Effective DateSystem2 ^------Bank Branches: End Effective Date - Quarter
Bank Branches: End Effective DateSystem3 ^------Bank Branches: End Effective Date - Month
Bank Branches: End Effective DateSystem4 ^------Bank Branches: End Effective Date - Day
Bank Branches: End Effective DateSystem5 ^------Bank Branches: End Effective Date
Bank Branches: Start Effective DateSystem1Bank Branches: Start Effective Date - Year
Bank Branches: Start Effective DateSystem2 ^------Bank Branches: Start Effective Date - Quarter
Bank Branches: Start Effective DateSystem3 ^------Bank Branches: Start Effective Date - Month
Bank Branches: Start Effective DateSystem4 ^------Bank Branches: Start Effective Date - Day
Bank Branches: Start Effective DateSystem5 ^------Bank Branches: Start Effective Date
Expense Reports: Exchange Date1System1Exchange Date Year
Expense Reports: Exchange Date1System2 ^------Exchange Date Quarter
Expense Reports: Exchange Date1System3 ^------Exchange Date Month
Expense Reports: Exchange Date1System4 ^------Exchange Date Day
Expense Reports: Exchange Date1System5 ^------Exchange Date
Expense Reports: Report Week End DateSystem1Report Week End Date Year
Expense Reports: Report Week End DateSystem2 ^------Report Week End Date Quarter
Expense Reports: Report Week End DateSystem3 ^------Report Week End Date Month
Expense Reports: Report Week End DateSystem4 ^------Report Week End Date Day
Expense Reports: Report Week End DateSystem5 ^------Report Week End Date
GL Accounts: End Effective DateSystem1GL Accounts: End Effective Date
GL Accounts: Start Effective DateSystem1GL Accounts: Start Effective Date
Holds: Hold DateSystem1Holds: Hold Date - Year
Holds: Hold DateSystem2 ^------Holds: Hold Date - Quarter
Holds: Hold DateSystem3 ^------Holds: Hold Date - Month
Holds: Hold DateSystem4 ^------Holds: Hold Date - Day
Holds: Hold DateSystem5 ^------Holds: Hold Date
Invoice Distributions: Accounting DateSystem1Invoice Distributions: Accounting Date - Year
Invoice Distributions: Accounting DateSystem2 ^------Invoice Distributions: Accounting Date - Quarter
Invoice Distributions: Accounting DateSystem3 ^------Invoice Distributions: Accounting Date - Month
Invoice Distributions: Accounting DateSystem4 ^------Invoice Distributions: Accounting Date - Day
Invoice Distributions: Accounting DateSystem5 ^------Invoice Distributions: Accounting Date
Invoice Payments: Accounting DateSystem1Accounting Date Year
Invoice Payments: Accounting DateSystem2 ^------Accounting Date Quarter
Invoice Payments: Accounting DateSystem3 ^------Accounting Date Month
Invoice Payments: Accounting DateSystem4 ^------Accounting Date Day
Invoice Payments: Accounting DateSystem5 ^------Accounting Date
Invoice Payments: Check DateSystem1Check Date Year
Invoice Payments: Check DateSystem2 ^------Check Date Quarter
Invoice Payments: Check DateSystem3 ^------Check Date Month
Invoice Payments: Check DateSystem4 ^------Check Date Day
Invoice Payments: Check DateSystem5 ^------Check Date
Invoice Payments: Exchange DateSystem1Exchange Date Year
Invoice Payments: Exchange DateSystem2 ^------Exchange Date Quarter
Invoice Payments: Exchange DateSystem3 ^------Exchange Date Month
Invoice Payments: Exchange DateSystem4 ^------Exchange Date Day
Invoice Payments: Exchange DateSystem5 ^------Exchange Date
Invoice Payments: Invoice DateSystem1Invoice Date Year
Invoice Payments: Invoice DateSystem2 ^------Invoice Date Quarter
Invoice Payments: Invoice DateSystem3 ^------Invoice Date Month
Invoice Payments: Invoice DateSystem4 ^------Invoice Date Day
Invoice Payments: Invoice DateSystem5 ^------Invoice Date
Invoices: Invoice Canceled DateSystem1Invoice Canceled Date Year
Invoices: Invoice Canceled DateSystem2 ^------Invoice Canceled Date Quarter
Invoices: Invoice Canceled DateSystem3 ^------Invoice Canceled Date Month
Invoices: Invoice Canceled DateSystem4 ^------Invoice Canceled Date Day
Invoices: Invoice Canceled DateSystem5 ^------Invoice Canceled Date
Invoices: Invoice DateSystem1Invoice Date Year
Invoices: Invoice DateSystem2 ^------Invoice Date Quarter
Invoices: Invoice DateSystem3 ^------Invoice Date Month
Invoices: Invoice DateSystem4 ^------Invoice Date Day
Invoices: Invoice DateSystem5 ^------Invoice Date
Invoices: Invoice Received DateSystem1Invoice Received Date Year
Invoices: Invoice Received DateSystem2 ^------Invoice Received Date Quarter
Invoices: Invoice Received DateSystem3 ^------Invoice Received Date Month
Invoices: Invoice Received DateSystem4 ^------Invoice Received Date Day
Invoices: Invoice Received DateSystem5 ^------Invoice Received Date
Invoices: Invoice To Payment Rate DateSystem1Inv To Pmt Rate Date Year
Invoices: Invoice To Payment Rate DateSystem2 ^------Inv To Pmt Rate Date Quarter
Invoices: Invoice To Payment Rate DateSystem3 ^------Inv To Pmt Rate Date Month
Invoices: Invoice To Payment Rate DateSystem4 ^------Inv To Pmt Rate Date Day
Invoices: Invoice To Payment Rate DateSystem5 ^------Inv To Pmt Rate Date
Payment Schedules: Discount DateSystem1Discount Date Year
Payment Schedules: Discount DateSystem2 ^------Discount Date Quarter
Payment Schedules: Discount DateSystem3 ^------Discount Date Month
Payment Schedules: Discount DateSystem4 ^------Discount Date Day
Payment Schedules: Discount DateSystem5 ^------Discount Date
Payment Schedules: Due Date1System1Due Date Year
Payment Schedules: Due Date1System2 ^------Due Date Quarter
Payment Schedules: Due Date1System3 ^------Due Date Month
Payment Schedules: Due Date1System4 ^------Due Date Day
Payment Schedules: Due Date1System5 ^------Due Date
Payment Schedules: Future Pay Due DateSystem1Future Pay Due Date Year
Payment Schedules: Future Pay Due DateSystem2 ^------Future Pay Due Date Quarter
Payment Schedules: Future Pay Due DateSystem3 ^------Future Pay Due Date Month
Payment Schedules: Future Pay Due DateSystem4 ^------Future Pay Due Date Day
Payment Schedules: Future Pay Due DateSystem5 ^------Future Pay Due Date
Payment Schedules: Invoice DateSystem1Invoice Date Year
Payment Schedules: Invoice DateSystem2 ^------Invoice Date Quarter
Payment Schedules: Invoice DateSystem3 ^------Invoice Date Month
Payment Schedules: Invoice DateSystem4 ^------Invoice Date Day
Payment Schedules: Invoice DateSystem5 ^------Invoice Date
Payment Schedules: Second Discount DateSystem1Second Discount Date Year
Payment Schedules: Second Discount DateSystem2 ^------Second Discount Date Quarter
Payment Schedules: Second Discount DateSystem3 ^------Second Discount Date Month
Payment Schedules: Second Discount DateSystem4 ^------Second Discount Date Day
Payment Schedules: Second Discount DateSystem5 ^------Second Discount Date
Payment Schedules: Third Discount DateSystem1Third Discount Date Year
Payment Schedules: Third Discount DateSystem2 ^------Third Discount Date Quarter
Payment Schedules: Third Discount DateSystem3 ^------Third Discount Date Month
Payment Schedules: Third Discount DateSystem4 ^------Third Discount Date Day
Payment Schedules: Third Discount DateSystem5 ^------Third Discount Date
Payment Terms: End Effective DateSystem1End Effective Date Year
Payment Terms: End Effective DateSystem2 ^------End Effective Date Quarter
Payment Terms: End Effective DateSystem3 ^------End Effective Date Month
Payment Terms: End Effective DateSystem4 ^------End Effective Date Day
Payment Terms: End Effective DateSystem5 ^------End Effective Date
Payment Terms: Payment Terms DateSystem1Payment Terms Date Year
Payment Terms: Payment Terms DateSystem2 ^------Payment Terms Date Quarter
Payment Terms: Payment Terms DateSystem3 ^------Payment Terms Date Month
Payment Terms: Payment Terms DateSystem4 ^------Payment Terms Date Day
Payment Terms: Payment Terms DateSystem5 ^------Payment Terms Date
Payment Terms: Start Effective DateSystem1Start Effective Date Year
Payment Terms: Start Effective DateSystem2 ^------Start Effective Date Quarter
Payment Terms: Start Effective DateSystem3 ^------Start Effective Date Month
Payment Terms: Start Effective DateSystem4 ^------Start Effective Date Day
Payment Terms: Start Effective DateSystem5 ^------Start Effective Date
Payments: Cleared Currency Exch DateSystem1Payments: Cleared Currency Exchange Date - Year
Payments: Cleared Currency Exch DateSystem2 ^------Payments: Cleared Currency Exchange Date - Quarter
Payments: Cleared Currency Exch DateSystem3 ^------Payments: Cleared Currency Exchange Date - Month
Payments: Cleared Currency Exch DateSystem4 ^------Payments: Cleared Currency Exchange Date - Day
Payments: Cleared Currency Exch DateSystem5 ^------Payments: Cleared Currency Exchange Date
Payments: Cleared DateSystem1Payments: Cleared Date - Year
Payments: Cleared DateSystem2 ^------Payments: Cleared Date - Quarter
Payments: Cleared DateSystem3 ^------Payments: Cleared Date - Month
Payments: Cleared DateSystem4 ^------Payments: Cleared Date - Day
Payments: Cleared DateSystem5 ^------Payments: Cleared Date
Payments: Currency Exchange DateSystem1Payments: Currency Exchange Date - Year
Payments: Currency Exchange DateSystem2 ^------Payments: Currency Exchange Date - Quarter
Payments: Currency Exchange DateSystem3 ^------Payments: Currency Exchange Date - Month
Payments: Currency Exchange DateSystem4 ^------Payments: Currency Exchange Date - Day
Payments: Currency Exchange DateSystem5 ^------Payments: Currency Exchange Date
Payments: Future Pay Due DateSystem1Payments: Future Pay Due Date - Year
Payments: Future Pay Due DateSystem2 ^------Payments: Future Pay Due Date - Quarter
Payments: Future Pay Due DateSystem3 ^------Payments: Future Pay Due Date - Month
Payments: Future Pay Due DateSystem4 ^------Payments: Future Pay Due Date - Day
Payments: Future Pay Due DateSystem5 ^------Payments: Future Pay Due Date
Payments: Payment Document DateSystem1Payments: Payment Document Date - Year
Payments: Payment Document DateSystem2 ^------Payments: Payment Document Date - Quarter
Payments: Payment Document DateSystem3 ^------Payments: Payment Document Date - Month
Payments: Payment Document DateSystem4 ^------Payments: Payment Document Date - Day
Payments: Payment Document DateSystem5 ^------Payments: Payment Document Date
Payments: Void DateSystem1Payments: Void Date - Year
Payments: Void DateSystem2 ^------Payments: Void Date - Quarter
Payments: Void DateSystem3 ^------Payments: Void Date - Month
Payments: Void DateSystem4 ^------Payments: Void Date - Day
Payments: Void DateSystem5 ^------Payments: Void Date
Supplier Sites: Created DateSystem1Supplier Sites: Created Date - Year
Supplier Sites: Created DateSystem2 ^------Supplier Sites: Created Date - Quarter
Supplier Sites: Created DateSystem3 ^------Supplier Sites: Created Date - Month
Supplier Sites: Created DateSystem4 ^------Supplier Sites: Created Date - Day
Supplier Sites: Created DateSystem5 ^------Supplier Sites: Created Date
Supplier Sites: Inactive DateSystem1Supplier Sites: Inactive Date - Year
Supplier Sites: Inactive DateSystem2 ^------Supplier Sites: Inactive Date - Quarter
Supplier Sites: Inactive DateSystem3 ^------Supplier Sites: Inactive Date - Month
Supplier Sites: Inactive DateSystem4 ^------Supplier Sites: Inactive Date - Day
Supplier Sites: Inactive DateSystem5 ^------Supplier Sites: Inactive Date
Supplier Sites: Last Updated DateSystem1Supplier Sites: Last Updated Date - Year
Supplier Sites: Last Updated DateSystem2 ^------Supplier Sites: Last Updated Date - Quarter
Supplier Sites: Last Updated DateSystem3 ^------Supplier Sites: Last Updated Date - Month
Supplier Sites: Last Updated DateSystem4 ^------Supplier Sites: Last Updated Date - Day
Supplier Sites: Last Updated DateSystem5 ^------Supplier Sites: Last Updated Date
Suppliers: Created DateSystem1Suppliers: Created Date - Year
Suppliers: Created DateSystem2 ^------Suppliers: Created Date - Quarter
Suppliers: Created DateSystem3 ^------Suppliers: Created Date - Month
Suppliers: Created DateSystem4 ^------Suppliers: Created Date - Day
Suppliers: Created DateSystem5 ^------Suppliers: Created Date
Suppliers: End Active DateSystem1Suppliers: End Active Date - Year
Suppliers: End Active DateSystem2 ^------Suppliers: End Active Date - Quarter
Suppliers: End Active DateSystem3 ^------Suppliers: End Active Date - Month
Suppliers: End Active DateSystem4 ^------Suppliers: End Active Date - Day
Suppliers: End Active DateSystem5 ^------Suppliers: End Active Date
Suppliers: Last Updated DateSystem1Suppliers: Last Updated Date - Year
Suppliers: Last Updated DateSystem2 ^------Suppliers: Last Updated Date - Quarter
Suppliers: Last Updated DateSystem3 ^------Suppliers: Last Updated Date - Month
Suppliers: Last Updated DateSystem4 ^------Suppliers: Last Updated Date - Day
Suppliers: Last Updated DateSystem5 ^------Suppliers: Last Updated Date
Suppliers: Purchasing Hold DateSystem1Suppliers: Purchasing Hold Date - Year
Suppliers: Purchasing Hold DateSystem2 ^------Suppliers: Purchasing Hold Date - Quarter
Suppliers: Purchasing Hold DateSystem3 ^------Suppliers: Purchasing Hold Date - Month
Suppliers: Purchasing Hold DateSystem4 ^------Suppliers: Purchasing Hold Date - Day
Suppliers: Purchasing Hold DateSystem5 ^------Suppliers: Purchasing Hold Date
Suppliers: Start Active DateSystem1Suppliers: Start Active Date - Year
Suppliers: Start Active DateSystem2 ^------Suppliers: Start Active Date - Quarter
Suppliers: Start Active DateSystem3 ^------Suppliers: Start Active Date - Month
Suppliers: Start Active DateSystem4 ^------Suppliers: Start Active Date - Day
Suppliers: Start Active DateSystem5 ^------Suppliers: Start Active Date
Suppliers: Tax Verification DateSystem1Suppliers: Tax Verification Date - Year
Suppliers: Tax Verification DateSystem2 ^------Suppliers: Tax Verification Date - Quarter
Suppliers: Tax Verification DateSystem3 ^------Suppliers: Tax Verification Date - Month
Suppliers: Tax Verification DateSystem4 ^------Suppliers: Tax Verification Date - Day
Suppliers: Tax Verification DateSystem5 ^------Suppliers: Tax Verification Date
Suppliers: Withholding Start DateSystem1Suppliers: Withholding Start Date - Year
Suppliers: Withholding Start DateSystem2 ^------Suppliers: Withholding Start Date - Quarter
Suppliers: Withholding Start DateSystem3 ^------Suppliers: Withholding Start Date - Month
Suppliers: Withholding Start DateSystem4 ^------Suppliers: Withholding Start Date - Day
Suppliers: Withholding Start DateSystem5 ^------Suppliers: Withholding Start Date
Item Classes
Item Class NamePrimary FolderUsed ByAlternate Sort
Bank Accounts: Account Holder NameBank Accounts . Account Holder NameBank Accounts . Account Holder Name.
Bank Accounts: Alternate Account Holder NameBank Accounts . Alternate Account Holder NameBank Accounts . Alternate Account Holder Name.
Bank Accounts: Bank Account NameBank Accounts . Bank Account NameBank Accounts . Bank Account Name.
Bank Accounts: Bank Account NumberBank Accounts . Bank Account NumberBank Accounts . Bank Account Number.
Bank Accounts: Bank Account TypeBank Accounts . Bank Account TypeBank Accounts . Bank Account Type.
Bank Accounts: Contact Area CodeBank Accounts . Contact Area CodeBank Accounts . Contact Area Code.
Bank Accounts: Contact First NameBank Accounts . Contact First NameBank Accounts . Contact First Name.
Bank Accounts: Contact Last NameBank Accounts . Contact Last NameBank Accounts . Contact Last Name.
Bank Accounts: Contact Middle NameBank Accounts . Contact Middle NameBank Accounts . Contact Middle Name.
Bank Accounts: Contact PhoneBank Accounts . Contact PhoneBank Accounts . Contact Phone.
Bank Accounts: Contact PrefixBank Accounts . Contact PrefixBank Accounts . Contact Prefix.
Bank Accounts: Contact TitleBank Accounts . Contact TitleBank Accounts . Contact Title.
Bank Accounts: Created ByBank Accounts . Created ByBank Accounts . Created By.
Bank Accounts: Currency CodeBank Accounts . Currency CodeBank Accounts . Currency Code.
Bank Accounts: DescriptionBank Accounts . DescriptionBank Accounts . Description.
Bank Accounts: Electronic Funds Transfer User NumberBank Accounts . Electronic Funds Transfer User NumberBank Accounts . Electronic Funds Transfer User Number.
Bank Accounts: Multicurrency Allowed FlagBank Accounts . Multicurrency Allowed FlagBank Accounts . Multicurrency Allowed Flag.
Bank Accounts: Pooled Account FlagBank Accounts . Pooled Account FlagBank Accounts . Pooled Account Flag.
Bank Accounts: Zero Payments Allowed FlagBank Accounts . Zero Payments Allowed FlagBank Accounts . Zero Payments Allowed Flag.
Bank Branches: Address Line 1Bank Branches . Address Line 1Bank Branches . Address Line 1.
Bank Branches: Address Line 2Bank Branches . Address Line 2Bank Branches . Address Line 2.
Bank Branches: Address Line 3Bank Branches . Address Line 3Bank Branches . Address Line 3.
Bank Branches: Address Line 4Bank Branches . Address Line 4Bank Branches . Address Line 4.
Bank Branches: Area CodeBank Branches . Area CodeBank Branches . Area Code.
Bank Branches: Bank Branch NameBank Branches . Bank Branch NameBank Branches . Bank Branch Name.
Bank Branches: Bank Branch NumberBank Branches . Bank Branch NumberBank Branches . Bank Branch Number.
Bank Branches: Bank Branch TypeBank Branches . Bank Branch TypeBank Branches . Bank Branch Type.
Bank Branches: Bank NameBank Branches . Bank NameBank Branches . Bank Name.
Bank Branches: Bank NumberBank Branches . Bank NumberBank Branches . Bank Number.
Bank Branches: CityBank Branches . CityBank Branches . City.
Bank Branches: Contact First NameBank Branches . Contact First NameBank Branches . Contact First Name.
Bank Branches: Contact Last NameBank Branches . Contact Last NameBank Branches . Contact Last Name.
Bank Branches: Contact Middle NameBank Branches . Contact Middle NameBank Branches . Contact Middle Name.
Bank Branches: Contact PrefixBank Branches . Contact PrefixBank Branches . Contact Prefix.
Bank Branches: Contact TitleBank Branches . Contact TitleBank Branches . Contact Title.
Bank Branches: CountryBank Branches . CountryBank Branches . Country.
Bank Branches: CountyBank Branches . CountyBank Branches . County.
Bank Branches: DescriptionBank Branches . DescriptionBank Branches . Description.
Bank Branches: Electronic Data Interchange ID NumberBank Branches . Electronic Data Interchange ID NumberBank Branches . Electronic Data Interchange ID Number.
Bank Branches: Electronic Funds Transfer Swift codeBank Branches . Electronic Funds Transfer Swift codeBank Branches . Electronic Funds Transfer Swift code.
Bank Branches: Electronic Funds Transfer User NumberBank Branches . Electronic Funds Transfer User NumberBank Branches . Electronic Funds Transfer User Number.
Bank Branches: Institution TypeBank Branches . Institution TypeBank Branches . Institution Type.
Bank Branches: PhoneBank Branches . PhoneBank Branches . Phone.
Bank Branches: StateBank Branches . StateBank Branches . State.
Bank Branches: Zip CodeBank Branches . Zip CodeBank Branches . Zip Code.
Charts Of Accounts: Chart Of Accounts NameCharts Of Accounts . Chart Of Accounts NameGL Accounts . Chart Of Accounts Name.
Charts Of Accounts: Chart Of Accounts NameCharts Of Accounts . Chart Of Accounts NameGL Accounts and Descriptions . Chart Of Accounts Name.
Holds: Hold CodeHolds . Hold CodeHolds . Hold Code.
Holds: Hold ReasonHolds . Hold ReasonHolds . Hold Reason.
Holds: Hold Release ReasonHolds . Hold Release ReasonHolds . Hold Release Reason.
Invoice Distributions: Amount Includes Tax FlagInvoice Distributions . Amount Includes Tax FlagInvoice Distributions . Amount Includes Tax Flag.
Invoice Distributions: Asset Related FlagInvoice Distributions . Asset