Powered by InfoCaptor


Previous Page   Next Page

Supplier Sites
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_SUPPLIER_SITESUnknown
NoneNone.POFG_SUPPLIER_SITESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Address Line 1First line of supplier addressSupplier Sites.Address Line 1ADDRESS_LINE_1ADDRESS_LINE_1115101
Address Line 2Second line of supplier addressSupplier Sites.Address Line 2ADDRESS_LINE_2ADDRESS_LINE_2115111
Address Line 3Third line of supplier addressSupplier Sites.Address Line 3ADDRESS_LINE_3ADDRESS_LINE_3115120
Address Line 4Fourth line of supplier addressSupplier Sites.Address Line 4ADDRESS_LINE_4ADDRESS_LINE_4115122
Allow Tax Calc Override Supplier Sites.Allow Tax Calc OverrideALLOW_TAX_CALC_OVERRIDEALLOW_TAX_CALC_OVERRIDE276647
Allow Withholding Flag Supplier Sites.Allow Withholding FlagALLOW_WITHHOLDING_FLAGALLOW_WITHHOLDING_FLAG276666
Alternate Address Supplier Sites.Alternate AddressALTERNATE_ADDRESSALTERNATE_ADDRESS115755
Alternate Pay Site Supplier Sites.Alternate Pay SiteALTERNATE_PAY_SITEALTERNATE_PAY_SITE115783
Alternate Pay Site IDUnique identifier for Alternate Pay SiteSupplier Sites.Alternate Pay Site IDALTERNATE_PAY_SITE_IDALTERNATE_PAY_SITE_ID115784
Alternate Supplier Site Name Supplier Sites.Alternate Supplier Site NameALTERNATE_SUPPLIER_SITE_NAMEALTERNATE_SUPPLIER_SITE_NAME115801
Always Take Discount Supplier Sites.Always Take DiscountALWAYS_TAKE_DISCOUNTALWAYS_TAKE_DISCOUNT276658
Amounts Include Tax Flag Supplier Sites.Amounts Include Tax FlagAMOUNTS_INCLUDE_TAX_FLAGAMOUNTS_INCLUDE_TAX_FLAG276649
Area Code Supplier Sites.Area CodeAREA_CODEAREA_CODE116403
Attention Ar Flag Supplier Sites.Attention Ar FlagATTENTION_AR_FLAGATTENTION_AR_FLAG276661
Bank Branch Type Supplier Sites.Bank Branch TypeBANK_BRANCH_TYPEBANK_BRANCH_TYPE276669
Bill To Location Supplier Sites.Bill To LocationBILL_TO_LOCATIONBILL_TO_LOCATION119939
Bill To Location IDUnique identifier for the bill-to locationSupplier Sites.Bill To Location IDBILL_TO_LOCATION_IDBILL_TO_LOCATION_ID119947
Carrier Supplier Sites.CarrierCARRIERCARRIER121575
Carrier Description Supplier Sites.Carrier DescriptionCARRIER_DESCRIPTIONCARRIER_DESCRIPTION121588
Carrier Organization Code Supplier Sites.Carrier Organization CodeCARRIER_ORGANIZATION_CODECARRIER_ORGANIZATION_CODE121613
Carrier Organization IDUnique identifier for Carrier OrganizationSupplier Sites.Carrier Organization IDCARRIER_ORGANIZATION_IDCARRIER_ORGANIZATION_ID121623
City Supplier Sites.CityCITYCITY122059
Country Supplier Sites.CountryCOUNTRYCOUNTRY123843
Country Of Origin Code Supplier Sites.Country Of Origin CodeCOUNTRY_OF_ORIGIN_CODECOUNTRY_OF_ORIGIN_CODE276679
County Supplier Sites.CountyCOUNTYCOUNTY123895
Create Debit Memo Flag Supplier Sites.Create Debit Memo FlagCREATE_DEBIT_MEMO_FLAGCREATE_DEBIT_MEMO_FLAG276672
Created By Supplier Sites.Created ByCREATED_BYCREATED_BY125258
Created Date Supplier Sites.Created DateCREATED_DATECREATED_DATE125433
Created Date - Day Supplier Sites.Created Date CREATED_DATE_DAY171289
Created Date - Month Supplier Sites.Created Date CREATED_DATE_MONTH171443
Created Date - Quarter Supplier Sites.Created Date CREATED_DATE_QUARTER171597
Created Date - Year Supplier Sites.Created Date CREATED_DATE_YEAR171751
Electronic Data Interchange ID NumberElectronic Data Interchange trading partner number for the Bank Branch.Supplier Sites.Electronic Data Interchange ID NumberEDI_ID_NUMBEREDI_ID_NUMBER130713
Electronic Data Interchange Payment FormatType of information being transmitted with the funds if using an EDI_PAYMENT_METHOD of ACH. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.Supplier Sites.Electronic Data Interchange Payment FormatEDI_PAYMENT_FORMATEDI_PAYMENT_FORMAT130717
Electronic Data Interchange Payment MethodIndicates how payment is to be made through Electronic Data Interchange (EDI). Valid methods are ACH and BOP.Supplier Sites.Electronic Data Interchange Payment MethodEDI_PAYMENT_METHODEDI_PAYMENT_METHOD130719
Electronic Data Interchange Remittance InstructionWho will send the remittance advice. Valid values are banks or payables systems.Supplier Sites.Electronic Data Interchange Remittance InstructionEDI_REMITTANCE_INSTRUCTIONEDI_REMITTANCE_INSTRUCTION130733
Electronic Data Interchange Remittance MethodHow the remittance advice will be sent to the supplierSupplier Sites.Electronic Data Interchange Remittance MethodEDI_REMITTANCE_METHODEDI_REMITTANCE_METHOD130735
Electronic Data Interchange Transaction HanldingANSI standard code for the Electronic Data Interchange (EDI) transaction typeSupplier Sites.Electronic Data Interchange Transaction HanldingEDI_TRANSACTION_HANLDINGEDI_TRANSACTION_HANLDING130737
Email Address Supplier Sites.Email AddressEMAIL_ADDRESSEMAIL_ADDRESS276675
Excl Freight From Disc Supplier Sites.Excl Freight From DiscEXCL_FREIGHT_FROM_DISCEXCL_FREIGHT_FROM_DISC276659
Fax Area CodeCustomer site facsimile area codeSupplier Sites.Fax Area CodeFAX_AREA_CODEFAX_AREA_CODE134253
Fax NumberCustomer site facsimile numberSupplier Sites.Fax NumberFAX_NUMBERFAX_NUMBER134255
Free On Board Point Supplier Sites.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276663
Freight Terms Supplier Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS276662
Future Dated Payment Ccid Supplier Sites.Future Dated Payment CcidFUTURE_DATED_PAYMENT_CCIDFUTURE_DATED_PAYMENT_CCID276671
Hold All Payments Supplier Sites.Hold All PaymentsHOLD_ALL_PAYMENTSHOLD_ALL_PAYMENTS276651
Hold Future Payments Supplier Sites.Hold Future PaymentsHOLD_FUTURE_PAYMENTSHOLD_FUTURE_PAYMENTS276652
Hold ReasonReason for hold being placed on invoice.Supplier Sites.Hold ReasonHOLD_REASONHOLD_REASON135854
Hold Unmatched Invoices Supplier Sites.Hold Unmatched InvoicesHOLD_UNMATCHED_INVOICESHOLD_UNMATCHED_INVOICES276653
Inactive DateDate on which bank account becomes inactive.Supplier Sites.Inactive DateINACTIVE_DATEINACTIVE_DATE136208
Inactive Date - Day Supplier Sites.Inactive Date INACTIVE_DATE_DAY181197
Inactive Date - Month Supplier Sites.Inactive Date INACTIVE_DATE_MONTH181267
Inactive Date - Quarter Supplier Sites.Inactive Date INACTIVE_DATE_QUARTER181337
Inactive Date - Year Supplier Sites.Inactive Date INACTIVE_DATE_YEAR181407
Invoice Amount LimitMaximum amount per invoiceSupplier Sites.Invoice Amount LimitINVOICE_AMOUNT_LIMITINVOICE_AMOUNT_LIMIT137377
Invoice Currency Supplier Sites.Invoice CurrencyINVOICE_CURRENCYINVOICE_CURRENCY137403
Invoice Currency Code Supplier Sites.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137410
Invoice Summary Level Supplier Sites.Invoice Summary LevelINVOICE_SUMMARY_LEVELINVOICE_SUMMARY_LEVEL276665
Invoice Tax Name Supplier Sites.Invoice Tax NameINVOICE_TAX_NAMEINVOICE_TAX_NAME137486
LanguageLanguage Id. For MLS(Multi-Lingual support).Supplier Sites.LanguageLANGUAGELANGUAGE138454
Last Updated By Supplier Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139838
Last Updated Date Supplier Sites.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE140012
Last Updated Date - Day Supplier Sites.Last Updated Date LAST_UPDATED_DATE_DAY182972
Last Updated Date - Month Supplier Sites.Last Updated Date LAST_UPDATED_DATE_MONTH183134
Last Updated Date - Quarter Supplier Sites.Last Updated Date LAST_UPDATED_DATE_QUARTER183296
Last Updated Date - Year Supplier Sites.Last Updated Date LAST_UPDATED_DATE_YEAR183458
Liability Account IDUnique identifier for Liability AccountSupplier Sites.Liability Account IDLIABILITY_ACCOUNT_IDLIABILITY_ACCOUNT_ID144531
Liabty Account Num Supplier Sites.Liabty Account NumLIABTY_ACCOUNT_NUMLIABTY_ACCOUNT_NUM276667
Match Option Supplier Sites.Match OptionMATCH_OPTIONMATCH_OPTION276670
Offset Tax Flag Supplier Sites.Offset Tax FlagOFFSET_TAX_FLAGOFFSET_TAX_FLAG276673
Offset Tax Name Supplier Sites.Offset Tax NameOFFSET_TAX_NAMEOFFSET_TAX_NAME149341
Operating Unit IDUnique identifier for Operating UnitSupplier Sites.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149568
Operating Unit Name Supplier Sites.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149616
Pay Alone Flag Supplier Sites.Pay Alone FlagPAY_ALONE_FLAGPAY_ALONE_FLAG276660
Pay Date Basis Supplier Sites.Pay Date BasisPAY_DATE_BASISPAY_DATE_BASIS276656
Pay Group Supplier Sites.Pay GroupPAY_GROUPPAY_GROUP276654
Pay On Supplier Sites.Pay OnPAY_ONPAY_ON276664
Pay Site Flag Supplier Sites.Pay Site FlagPAY_SITE_FLAGPAY_SITE_FLAG276643
Payment Currency Supplier Sites.Payment CurrencyPAYMENT_CURRENCYPAYMENT_CURRENCY152193
Payment Currency Code Supplier Sites.Payment Currency CodePAYMENT_CURRENCY_CODEPAYMENT_CURRENCY_CODE152196
Payment Method Supplier Sites.Payment MethodPAYMENT_METHODPAYMENT_METHOD276657
Payment PriorityIndicates the lowest payment priority the forecast amount representsfor AP invoice or Purchase order source type.Supplier Sites.Payment PriorityPAYMENT_PRIORITYPAYMENT_PRIORITY152245
Payment Terms IDUnique identifier for Payment TermsSupplier Sites.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152276
Payment Terms Name Supplier Sites.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152292
Pcard Site Flag Supplier Sites.Pcard Site FlagPCARD_SITE_FLAGPCARD_SITE_FLAG276678
Phone Number Supplier Sites.Phone NumberPHONE_NUMBERPHONE_NUMBER154033
Postal Code Supplier Sites.Postal CodePOSTAL_CODEPOSTAL_CODE154948
Prepay Account Num Supplier Sites.Prepay Account NumPREPAY_ACCOUNT_NUMPREPAY_ACCOUNT_NUM276668
Prepayment Account IDUnique identifier for Prepayment AccountSupplier Sites.Prepayment Account IDPREPAYMENT_ACCOUNT_IDPREPAYMENT_ACCOUNT_ID155223
Primary Pay Site Flag Supplier Sites.Primary Pay Site FlagPRIMARY_PAY_SITE_FLAGPRIMARY_PAY_SITE_FLAG276677
Province Supplier Sites.ProvincePROVINCEPROVINCE156816
Purchasing Site Flag Supplier Sites.Purchasing Site FlagPURCHASING_SITE_FLAGPURCHASING_SITE_FLAG276644
Remittance Email Supplier Sites.Remittance EmailREMITTANCE_EMAILREMITTANCE_EMAIL276676
Rfq Only Site Flag Supplier Sites.Rfq Only Site FlagRFQ_ONLY_SITE_FLAGRFQ_ONLY_SITE_FLAG276645
Ship To Location Supplier Sites.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161930
Ship To Location IDUnique identifier for the default ship-to-locationSupplier Sites.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161957
State Supplier Sites.StateSTATESTATE163375
Supplier IDUnique identifier for SupplierSupplier Sites.Supplier IDSUPPLIER_IDSUPPLIER_ID164223
Supplier Name Supplier Sites.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164267
Supplier Notif Method Supplier Sites.Supplier Notif MethodSUPPLIER_NOTIF_METHODSUPPLIER_NOTIF_METHOD276674
Supplier Site IDUnique identifier for the supplier siteSupplier Sites.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164338
Supplier Site Name Supplier Sites.Supplier Site NameSUPPLIER_SITE_NAMESUPPLIER_SITE_NAME164340
Tax Calculation Level Supplier Sites.Tax Calculation LevelTAX_CALCULATION_LEVELTAX_CALCULATION_LEVEL276646
Tax Reporting Site Flag Supplier Sites.Tax Reporting Site FlagTAX_REPORTING_SITE_FLAGTAX_REPORTING_SITE_FLAG276650
Tax Rounding Rule Supplier Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE276648
Telex NumberCustomer site telexSupplier Sites.Telex NumberTELEX_NUMBERTELEX_NUMBER164927
Terms Date Basis Supplier Sites.Terms Date BasisTERMS_DATE_BASISTERMS_DATE_BASIS276655
Value Added Tax Registration NumberValue Added Tax (VAT) registration numberSupplier Sites.Value Added Tax Registration NumberVAT_REGISTRATION_NUMBERVAT_REGISTRATION_NUMBER167397
Address Line 1First line of supplier addressSupplier Sites.Address Line 1ADDRESS_LINE_1ADDRESS_LINE_1115101
Address Line 2Second line of supplier addressSupplier Sites.Address Line 2ADDRESS_LINE_2ADDRESS_LINE_2115111
Address Line 3Third line of supplier addressSupplier Sites.Address Line 3ADDRESS_LINE_3ADDRESS_LINE_3115120
Address Line 4Fourth line of supplier addressSupplier Sites.Address Line 4ADDRESS_LINE_4ADDRESS_LINE_4115122
Allow Tax Calc Override Supplier Sites.Allow Tax Calc OverrideALLOW_TAX_CALC_OVERRIDEALLOW_TAX_CALC_OVERRIDE276647
Allow Withholding Flag Supplier Sites.Allow Withholding FlagALLOW_WITHHOLDING_FLAGALLOW_WITHHOLDING_FLAG276666
Alternate Address Supplier Sites.Alternate AddressALTERNATE_ADDRESSALTERNATE_ADDRESS115755
Alternate Pay Site Supplier Sites.Alternate Pay SiteALTERNATE_PAY_SITEALTERNATE_PAY_SITE115783
Alternate Pay Site IDUnique identifier for Alternate Pay SiteSupplier Sites.Alternate Pay Site IDALTERNATE_PAY_SITE_IDALTERNATE_PAY_SITE_ID115784
Alternate Supplier Site Name Supplier Sites.Alternate Supplier Site NameALTERNATE_SUPPLIER_SITE_NAMEALTERNATE_SUPPLIER_SITE_NAME115801
Always Take Discount Supplier Sites.Always Take DiscountALWAYS_TAKE_DISCOUNTALWAYS_TAKE_DISCOUNT276658
Amounts Include Tax Flag Supplier Sites.Amounts Include Tax FlagAMOUNTS_INCLUDE_TAX_FLAGAMOUNTS_INCLUDE_TAX_FLAG276649
Area Code Supplier Sites.Area CodeAREA_CODEAREA_CODE116403
Attention Ar Flag Supplier Sites.Attention Ar FlagATTENTION_AR_FLAGATTENTION_AR_FLAG276661
Bank Branch Type Supplier Sites.Bank Branch TypeBANK_BRANCH_TYPEBANK_BRANCH_TYPE276669
Bill To Location Supplier Sites.Bill To LocationBILL_TO_LOCATIONBILL_TO_LOCATION119939
Bill To Location IDUnique identifier for the bill-to locationSupplier Sites.Bill To Location IDBILL_TO_LOCATION_IDBILL_TO_LOCATION_ID119947
Carrier Supplier Sites.CarrierCARRIERCARRIER121575
Carrier Description Supplier Sites.Carrier DescriptionCARRIER_DESCRIPTIONCARRIER_DESCRIPTION121588
Carrier Organization Code Supplier Sites.Carrier Organization CodeCARRIER_ORGANIZATION_CODECARRIER_ORGANIZATION_CODE121613
Carrier Organization IDUnique identifier for Carrier OrganizationSupplier Sites.Carrier Organization IDCARRIER_ORGANIZATION_IDCARRIER_ORGANIZATION_ID121623
City Supplier Sites.CityCITYCITY122059
Country Supplier Sites.CountryCOUNTRYCOUNTRY123843
Country Of Origin Code Supplier Sites.Country Of Origin CodeCOUNTRY_OF_ORIGIN_CODECOUNTRY_OF_ORIGIN_CODE276679
County Supplier Sites.CountyCOUNTYCOUNTY123895
Create Debit Memo Flag Supplier Sites.Create Debit Memo FlagCREATE_DEBIT_MEMO_FLAGCREATE_DEBIT_MEMO_FLAG276672
Created By Supplier Sites.Created ByCREATED_BYCREATED_BY125258
Created Date Supplier Sites.Created DateCREATED_DATECREATED_DATE125433
Created Date - Day Supplier Sites.Created Date CREATED_DATE_DAY171289
Created Date - Month Supplier Sites.Created Date CREATED_DATE_MONTH171443
Created Date - Quarter Supplier Sites.Created Date CREATED_DATE_QUARTER171597
Created Date - Year Supplier Sites.Created Date CREATED_DATE_YEAR171751
Electronic Data Interchange ID NumberElectronic Data Interchange trading partner number for the Bank Branch.Supplier Sites.Electronic Data Interchange ID NumberEDI_ID_NUMBEREDI_ID_NUMBER130713
Electronic Data Interchange Payment FormatType of information being transmitted with the funds if using an EDI_PAYMENT_METHOD of ACH. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.Supplier Sites.Electronic Data Interchange Payment FormatEDI_PAYMENT_FORMATEDI_PAYMENT_FORMAT130717
Electronic Data Interchange Payment MethodIndicates how payment is to be made through Electronic Data Interchange (EDI). Valid methods are ACH and BOP.Supplier Sites.Electronic Data Interchange Payment MethodEDI_PAYMENT_METHODEDI_PAYMENT_METHOD130719
Electronic Data Interchange Remittance InstructionWho will send the remittance advice. Valid values are banks or payables systems.Supplier Sites.Electronic Data Interchange Remittance InstructionEDI_REMITTANCE_INSTRUCTIONEDI_REMITTANCE_INSTRUCTION130733
Electronic Data Interchange Remittance MethodHow the remittance advice will be sent to the supplierSupplier Sites.Electronic Data Interchange Remittance MethodEDI_REMITTANCE_METHODEDI_REMITTANCE_METHOD130735
Electronic Data Interchange Transaction HanldingANSI standard code for the Electronic Data Interchange (EDI) transaction typeSupplier Sites.Electronic Data Interchange Transaction HanldingEDI_TRANSACTION_HANLDINGEDI_TRANSACTION_HANLDING130737
Email Address Supplier Sites.Email AddressEMAIL_ADDRESSEMAIL_ADDRESS276675
Excl Freight From Disc Supplier Sites.Excl Freight From DiscEXCL_FREIGHT_FROM_DISCEXCL_FREIGHT_FROM_DISC276659
Fax Area CodeCustomer site facsimile area codeSupplier Sites.Fax Area CodeFAX_AREA_CODEFAX_AREA_CODE134253
Fax NumberCustomer site facsimile numberSupplier Sites.Fax NumberFAX_NUMBERFAX_NUMBER134255
Free On Board Point Supplier Sites.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276663
Freight Terms Supplier Sites.Freight TermsFREIGHT_TERMSFREIGHT_TERMS276662
Future Dated Payment Ccid Supplier Sites.Future Dated Payment CcidFUTURE_DATED_PAYMENT_CCIDFUTURE_DATED_PAYMENT_CCID276671
Hold All Payments Supplier Sites.Hold All PaymentsHOLD_ALL_PAYMENTSHOLD_ALL_PAYMENTS276651
Hold Future Payments Supplier Sites.Hold Future PaymentsHOLD_FUTURE_PAYMENTSHOLD_FUTURE_PAYMENTS276652
Hold ReasonReason for hold being placed on invoice.Supplier Sites.Hold ReasonHOLD_REASONHOLD_REASON135854
Hold Unmatched Invoices Supplier Sites.Hold Unmatched InvoicesHOLD_UNMATCHED_INVOICESHOLD_UNMATCHED_INVOICES276653
Inactive DateDate on which bank account becomes inactive.Supplier Sites.Inactive DateINACTIVE_DATEINACTIVE_DATE136208
Inactive Date - Day Supplier Sites.Inactive Date INACTIVE_DATE_DAY181197
Inactive Date - Month Supplier Sites.Inactive Date INACTIVE_DATE_MONTH181267
Inactive Date - Quarter Supplier Sites.Inactive Date INACTIVE_DATE_QUARTER181337
Inactive Date - Year Supplier Sites.Inactive Date INACTIVE_DATE_YEAR181407
Invoice Amount LimitMaximum amount per invoiceSupplier Sites.Invoice Amount LimitINVOICE_AMOUNT_LIMITINVOICE_AMOUNT_LIMIT137377
Invoice Currency Supplier Sites.Invoice CurrencyINVOICE_CURRENCYINVOICE_CURRENCY137403
Invoice Currency Code Supplier Sites.Invoice Currency CodeINVOICE_CURRENCY_CODEINVOICE_CURRENCY_CODE137410
Invoice Summary Level Supplier Sites.Invoice Summary LevelINVOICE_SUMMARY_LEVELINVOICE_SUMMARY_LEVEL276665
Invoice Tax Name Supplier Sites.Invoice Tax NameINVOICE_TAX_NAMEINVOICE_TAX_NAME137486
LanguageLanguage Id. For MLS(Multi-Lingual support).Supplier Sites.LanguageLANGUAGELANGUAGE138454
Last Updated By Supplier Sites.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139838
Last Updated Date Supplier Sites.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE140012
Last Updated Date - Day Supplier Sites.Last Updated Date LAST_UPDATED_DATE_DAY182972
Last Updated Date - Month Supplier Sites.Last Updated Date LAST_UPDATED_DATE_MONTH183134
Last Updated Date - Quarter Supplier Sites.Last Updated Date LAST_UPDATED_DATE_QUARTER183296
Last Updated Date - Year Supplier Sites.Last Updated Date LAST_UPDATED_DATE_YEAR183458
Liability Account IDUnique identifier for Liability AccountSupplier Sites.Liability Account IDLIABILITY_ACCOUNT_IDLIABILITY_ACCOUNT_ID144531
Liabty Account Num Supplier Sites.Liabty Account NumLIABTY_ACCOUNT_NUMLIABTY_ACCOUNT_NUM276667
Match Option Supplier Sites.Match OptionMATCH_OPTIONMATCH_OPTION276670
Offset Tax Flag Supplier Sites.Offset Tax FlagOFFSET_TAX_FLAGOFFSET_TAX_FLAG276673
Offset Tax Name Supplier Sites.Offset Tax NameOFFSET_TAX_NAMEOFFSET_TAX_NAME149341
Operating Unit IDUnique identifier for Operating UnitSupplier Sites.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149568
Operating Unit Name Supplier Sites.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149616
Pay Alone Flag Supplier Sites.Pay Alone FlagPAY_ALONE_FLAGPAY_ALONE_FLAG276660
Pay Date Basis Supplier Sites.Pay Date BasisPAY_DATE_BASISPAY_DATE_BASIS276656
Pay Group Supplier Sites.Pay GroupPAY_GROUPPAY_GROUP276654
Pay On Supplier Sites.Pay OnPAY_ONPAY_ON276664
Pay Site Flag Supplier Sites.Pay Site FlagPAY_SITE_FLAGPAY_SITE_FLAG276643
Payment Currency Supplier Sites.Payment CurrencyPAYMENT_CURRENCYPAYMENT_CURRENCY152193
Payment Currency Code Supplier Sites.Payment Currency CodePAYMENT_CURRENCY_CODEPAYMENT_CURRENCY_CODE152196
Payment Method Supplier Sites.Payment MethodPAYMENT_METHODPAYMENT_METHOD276657
Payment PriorityIndicates the lowest payment priority the forecast amount representsfor AP invoice or Purchase order source type.Supplier Sites.Payment PriorityPAYMENT_PRIORITYPAYMENT_PRIORITY152245
Payment Terms IDUnique identifier for Payment TermsSupplier Sites.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152276
Payment Terms Name Supplier Sites.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152292
Pcard Site Flag Supplier Sites.Pcard Site FlagPCARD_SITE_FLAGPCARD_SITE_FLAG276678
Phone Number Supplier Sites.Phone NumberPHONE_NUMBERPHONE_NUMBER154033
Postal Code Supplier Sites.Postal CodePOSTAL_CODEPOSTAL_CODE154948
Prepay Account Num Supplier Sites.Prepay Account NumPREPAY_ACCOUNT_NUMPREPAY_ACCOUNT_NUM276668
Prepayment Account IDUnique identifier for Prepayment AccountSupplier Sites.Prepayment Account IDPREPAYMENT_ACCOUNT_IDPREPAYMENT_ACCOUNT_ID155223
Primary Pay Site Flag Supplier Sites.Primary Pay Site FlagPRIMARY_PAY_SITE_FLAGPRIMARY_PAY_SITE_FLAG276677
Province Supplier Sites.ProvincePROVINCEPROVINCE156816
Purchasing Site Flag Supplier Sites.Purchasing Site FlagPURCHASING_SITE_FLAGPURCHASING_SITE_FLAG276644
Remittance Email Supplier Sites.Remittance EmailREMITTANCE_EMAILREMITTANCE_EMAIL276676
Rfq Only Site Flag Supplier Sites.Rfq Only Site FlagRFQ_ONLY_SITE_FLAGRFQ_ONLY_SITE_FLAG276645
Ship To Location Supplier Sites.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161930
Ship To Location IDUnique identifier for the default ship-to-locationSupplier Sites.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161957
State Supplier Sites.StateSTATESTATE163375
Supplier IDUnique identifier for SupplierSupplier Sites.Supplier IDSUPPLIER_IDSUPPLIER_ID164223
Supplier Name Supplier Sites.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164267
Supplier Notif Method Supplier Sites.Supplier Notif MethodSUPPLIER_NOTIF_METHODSUPPLIER_NOTIF_METHOD276674
Supplier Site IDUnique identifier for the supplier siteSupplier Sites.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164338
Supplier Site Name Supplier Sites.Supplier Site NameSUPPLIER_SITE_NAMESUPPLIER_SITE_NAME164340
Tax Calculation Level Supplier Sites.Tax Calculation LevelTAX_CALCULATION_LEVELTAX_CALCULATION_LEVEL276646
Tax Reporting Site Flag Supplier Sites.Tax Reporting Site FlagTAX_REPORTING_SITE_FLAGTAX_REPORTING_SITE_FLAG276650
Tax Rounding Rule Supplier Sites.Tax Rounding RuleTAX_ROUNDING_RULETAX_ROUNDING_RULE276648
Telex NumberCustomer site telexSupplier Sites.Telex NumberTELEX_NUMBERTELEX_NUMBER164927
Terms Date Basis Supplier Sites.Terms Date BasisTERMS_DATE_BASISTERMS_DATE_BASIS276655
Value Added Tax Registration NumberValue Added Tax (VAT) registration numberSupplier Sites.Value Added Tax Registration NumberVAT_REGISTRATION_NUMBERVAT_REGISTRATION_NUMBER167397
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Supplier Sites -> AP Payment SchedulesSupplier Sites.Supplier Site ID = AP Payment Schedules.Vendor Site IDAlways exist in master folderNoneNo
Supplier Sites -> InvoicesSupplier Sites.Supplier Site ID = Invoices.Vendor Site IdAlways exist in master folderNoneNo
Supplier Sites -> PaymentsSupplier Sites.Supplier Site ID = Payments.Vendor Site IdAlways exist in master folderNoneNo