Powered by InfoCaptor


Previous Page   Next Page

AP Invoice Payments
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.APFG_AP_INVOICE_PAYMENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Accounting Date AP Invoice Payments.Accounting DateACCOUNTING_DATEACCOUNTING_DATE114085
Accounting Date Day AP Invoice Payments.Accounting Date ACCOUNTING_DATE_DAY168321
Accounting Date Month AP Invoice Payments.Accounting Date ACCOUNTING_DATE_MONTH168333
Accounting Date Quarter AP Invoice Payments.Accounting Date ACCOUNTING_DATE_QUARTER168345
Accounting Date Year AP Invoice Payments.Accounting Date ACCOUNTING_DATE_YEAR168357
Accrual Posted Flag AP Invoice Payments.Accrual Posted FlagACCRUAL_POSTED_FLAGACCRUAL_POSTED_FLAG114343
Accts Pay Code Combination Id AP Invoice Payments.Accts Pay Code Combination IdACCTS_PAY_CODE_COMBINATION_IDACCTS_PAY_CODE_COMBINATION_ID114400
Amount AP Invoice Payments.AmountAMOUNTAMOUNT115852
Amount Paid AP Invoice Payments.Amount PaidAMOUNT_PAIDAMOUNT_PAID115906
Aps External Bank Account Id AP Invoice Payments.Aps External Bank Account IdAPS_EXTERNAL_BANK_ACCOUNT_IDAPS_EXTERNAL_BANK_ACCOUNT_ID116386
Asset Code Combination Id AP Invoice Payments.Asset Code Combination IdASSET_CODE_COMBINATION_IDASSET_CODE_COMBINATION_ID116564
Assets Addition Flag AP Invoice Payments.Assets Addition FlagASSETS_ADDITION_FLAGASSETS_ADDITION_FLAG116550
Bank Account Name AP Invoice Payments.Bank Account NameBANK_ACCOUNT_NAMEBANK_ACCOUNT_NAME119023
Bank Account Number AP Invoice Payments.Bank Account NumberBANK_ACCOUNT_NUMBERBANK_ACCOUNT_NUMBER119040
Bank Account Type AP Invoice Payments.Bank Account TypeBANK_ACCOUNT_TYPEBANK_ACCOUNT_TYPE119045
Bank Number AP Invoice Payments.Bank NumberBANK_NUMBERBANK_NUMBER119093
Cash Posted Flag AP Invoice Payments.Cash Posted FlagCASH_POSTED_FLAGCASH_POSTED_FLAG121643
Check Amount AP Invoice Payments.Check AmountCHECK_AMOUNTCHECK_AMOUNT121957
Check Currency Code AP Invoice Payments.Check Currency CodeCHECK_CURRENCY_CODECHECK_CURRENCY_CODE121958
Check Date AP Invoice Payments.Check DateCHECK_DATECHECK_DATE121959
Check Date Day AP Invoice Payments.Check Date CHECK_DATE_DAY170469
Check Date Month AP Invoice Payments.Check Date CHECK_DATE_MONTH170471
Check Date Quarter AP Invoice Payments.Check Date CHECK_DATE_QUARTER170473
Check Date Year AP Invoice Payments.Check Date CHECK_DATE_YEAR170475
Check Id AP Invoice Payments.Check IdCHECK_IDCHECK_ID121961
Check Number AP Invoice Payments.Check NumberCHECK_NUMBERCHECK_NUMBER121965
Check Status AP Invoice Payments.Check StatusCHECK_STATUSCHECK_STATUS266406
Check Type AP Invoice Payments.Check TypeCHECK_TYPECHECK_TYPE266405
Created By AP Invoice Payments.Created ByCREATED_BYCREATED_BY124517
Creation Date AP Invoice Payments.Creation DateCREATION_DATECREATION_DATE125949
Description AP Invoice Payments.DescriptionDESCRIPTIONDESCRIPTION129519
Discount Lost AP Invoice Payments.Discount LostDISCOUNT_LOSTDISCOUNT_LOST130158
Discount Taken AP Invoice Payments.Discount TakenDISCOUNT_TAKENDISCOUNT_TAKEN130172
Exchange Date AP Invoice Payments.Exchange DateEXCHANGE_DATEEXCHANGE_DATE133777
Exchange Date Day AP Invoice Payments.Exchange Date EXCHANGE_DATE_DAY179137
Exchange Date Month AP Invoice Payments.Exchange Date EXCHANGE_DATE_MONTH179141
Exchange Date Quarter AP Invoice Payments.Exchange Date EXCHANGE_DATE_QUARTER179145
Exchange Date Year AP Invoice Payments.Exchange Date EXCHANGE_DATE_YEAR179149
Exchange Rate AP Invoice Payments.Exchange RateEXCHANGE_RATEEXCHANGE_RATE133785
Exchange Rate Type AP Invoice Payments.Exchange Rate TypeEXCHANGE_RATE_TYPEEXCHANGE_RATE_TYPE133801
External Bank Account Id AP Invoice Payments.External Bank Account IdEXTERNAL_BANK_ACCOUNT_IDEXTERNAL_BANK_ACCOUNT_ID134146
Gain Code Combination Id AP Invoice Payments.Gain Code Combination IdGAIN_CODE_COMBINATION_IDGAIN_CODE_COMBINATION_ID134989
Invoice Amount AP Invoice Payments.Invoice AmountINVOICE_AMOUNTINVOICE_AMOUNT137369
Invoice Base Amount AP Invoice Payments.Invoice Base AmountINVOICE_BASE_AMOUNTINVOICE_BASE_AMOUNT137379
Invoice Date AP Invoice Payments.Invoice DateINVOICE_DATEINVOICE_DATE137416
Invoice Date Day AP Invoice Payments.Invoice Date INVOICE_DATE_DAY181640
Invoice Date Month AP Invoice Payments.Invoice Date INVOICE_DATE_MONTH181650
Invoice Date Quarter AP Invoice Payments.Invoice Date INVOICE_DATE_QUARTER181660
Invoice Date Year AP Invoice Payments.Invoice Date INVOICE_DATE_YEAR181678
Invoice Id AP Invoice Payments.Invoice IdINVOICE_IDINVOICE_ID137438
Invoice Number AP Invoice Payments.Invoice NumberINVOICE_NUMBERINVOICE_NUMBER137461
Invoice Payment Id AP Invoice Payments.Invoice Payment IdINVOICE_PAYMENT_IDINVOICE_PAYMENT_ID137475
Invoice Payment Type AP Invoice Payments.Invoice Payment TypeINVOICE_PAYMENT_TYPEINVOICE_PAYMENT_TYPE137476
Last Update Date AP Invoice Payments.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140480
Last Update Login AP Invoice Payments.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141442
Last Updated By AP Invoice Payments.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139141
Loss Code Combination Id AP Invoice Payments.Loss Code Combination IdLOSS_CODE_COMBINATION_IDLOSS_CODE_COMBINATION_ID145818
Payment Base Amount AP Invoice Payments.Payment Base AmountPAYMENT_BASE_AMOUNTPAYMENT_BASE_AMOUNT152191
Payment Number AP Invoice Payments.Payment NumberPAYMENT_NUMBERPAYMENT_NUMBER152237
Payment Type AP Invoice Payments.Payment TypePAYMENT_TYPEPAYMENT_TYPE266404
Period Name AP Invoice Payments.Period NamePERIOD_NAMEPERIOD_NAME153089
Posted Flag AP Invoice Payments.Posted FlagPOSTED_FLAGPOSTED_FLAG154950
Set Of Books Id AP Invoice Payments.Set Of Books IdSET_OF_BOOKS_IDSET_OF_BOOKS_ID161470
Set Of Books Name AP Invoice Payments.Set Of Books NameSET_OF_BOOKS_NAMESET_OF_BOOKS_NAME161544
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
AP Invoice Payments -> PaymentsAP Invoice Payments.Check Id = Payments.Check IdAlways exist in master folderOuter join on detail No