Powered by InfoCaptor


Previous Page   Next Page

Purchase Contracts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_PURCHASE_CONTRACTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acceptance Due DateDate by which the supplier should accept the documentPurchase Contracts.Acceptance Due DateACCEPTANCE_DUE_DATEACCEPTANCE_DUE_DATE114036
Acceptance Due Date - Day Purchase Contracts.Acceptance Due Date ACCEPTANCE_DUE_DATE_DAY168255
Acceptance Due Date - Month Purchase Contracts.Acceptance Due Date ACCEPTANCE_DUE_DATE_MONTH168269
Acceptance Due Date - Quarter Purchase Contracts.Acceptance Due Date ACCEPTANCE_DUE_DATE_QUARTER168283
Acceptance Due Date - Year Purchase Contracts.Acceptance Due Date ACCEPTANCE_DUE_DATE_YEAR168297
Acceptance Required Flag Purchase Contracts.Acceptance Required FlagACCEPTANCE_REQUIRED_FLAGACCEPTANCE_REQUIRED_FLAG276079
Acknowledgement Date Purchase Contracts.Acknowledgement DateACKNOWLEDGEMENT_DATEACKNOWLEDGEMENT_DATE276084
Acknowledgement Type Purchase Contracts.Acknowledgement TypeACKNOWLEDGEMENT_TYPEACKNOWLEDGEMENT_TYPE276083
Amount Limit Purchase Contracts.Amount LimitAMOUNT_LIMITAMOUNT_LIMIT115904
Approval Date Purchase Contracts.Approval DateAPPROVAL_DATEAPPROVAL_DATE116328
Approval Date - Day Purchase Contracts.Approval Date APPROVAL_DATE_DAY169043
Approval Date - Month Purchase Contracts.Approval Date APPROVAL_DATE_MONTH169077
Approval Date - Quarter Purchase Contracts.Approval Date APPROVAL_DATE_QUARTER169111
Approval Date - Year Purchase Contracts.Approval Date APPROVAL_DATE_YEAR169145
Authorization Status Purchase Contracts.Authorization StatusAUTHORIZATION_STATUSAUTHORIZATION_STATUS276071
BOL Purchase Contracts.BOLBOLBOL276082
Bill To Location Purchase Contracts.Bill To LocationBILL_TO_LOCATIONBILL_TO_LOCATION119934
Bill To Location IDUnique identifier for Bill To LocationPurchase Contracts.Bill To Location IDBILL_TO_LOCATION_IDBILL_TO_LOCATION_ID119942
Buyer Employee Number Purchase Contracts.Buyer Employee NumberBUYER_EMPLOYEE_NUMBERBUYER_EMPLOYEE_NUMBER121231
Buyer IDUnique identifier for BuyerPurchase Contracts.Buyer IDBUYER_IDBUYER_ID121244
Buyer Name Purchase Contracts.Buyer NameBUYER_NAMEBUYER_NAME121256
Cancel Flag Purchase Contracts.Cancel FlagCANCEL_FLAGCANCEL_FLAG276072
Carrier Purchase Contracts.CarrierCARRIERCARRIER121568
Carrier Description Purchase Contracts.Carrier DescriptionCARRIER_DESCRIPTIONCARRIER_DESCRIPTION121581
Carrier Organization Code Purchase Contracts.Carrier Organization CodeCARRIER_ORGANIZATION_CODECARRIER_ORGANIZATION_CODE121606
Carrier Organization IDUnique identifier for Carrier OrganizationPurchase Contracts.Carrier Organization IDCARRIER_ORGANIZATION_IDCARRIER_ORGANIZATION_ID121616
Closed Date Purchase Contracts.Closed DateCLOSED_DATECLOSED_DATE122184
Closed Date - Day Purchase Contracts.Closed Date CLOSED_DATE_DAY170531
Closed Date - Month Purchase Contracts.Closed Date CLOSED_DATE_MONTH170569
Closed Date - Quarter Purchase Contracts.Closed Date CLOSED_DATE_QUARTER170607
Closed Date - Year Purchase Contracts.Closed Date CLOSED_DATE_YEAR170647
Closure Status Purchase Contracts.Closure StatusCLOSURE_STATUSCLOSURE_STATUS276073
Confirming Order Flag Purchase Contracts.Confirming Order FlagCONFIRMING_ORDER_FLAGCONFIRMING_ORDER_FLAG276080
Conterms Articles Upd Date Purchase Contracts.Conterms Articles Upd DateCONTERMS_ARTICLES_UPD_DATECONTERMS_ARTICLES_UPD_DATE276089
Conterms Deliv Upd Date Purchase Contracts.Conterms Deliv Upd DateCONTERMS_DELIV_UPD_DATECONTERMS_DELIV_UPD_DATE276090
Conterms Exist Flag Purchase Contracts.Conterms Exist FlagCONTERMS_EXIST_FLAGCONTERMS_EXIST_FLAG276088
Context Purchase Contracts.ContextCONTEXTCONTEXT276081
Created By Purchase Contracts.Created ByCREATED_BYCREATED_BY125230
Created Date Purchase Contracts.Created DateCREATED_DATECREATED_DATE125405
Created Date - Day Purchase Contracts.Created Date CREATED_DATE_DAY171233
Created Date - Month Purchase Contracts.Created Date CREATED_DATE_MONTH171387
Created Date - Quarter Purchase Contracts.Created Date CREATED_DATE_QUARTER171541
Created Date - Year Purchase Contracts.Created Date CREATED_DATE_YEAR171695
CurrencyThe currency for an account balance.Purchase Contracts.CurrencyCURRENCYCURRENCY126952
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Purchase Contracts.Currency CodeCURRENCY_CODECURRENCY_CODE127053
Currency Conversion RateThe currency exchange rate.Purchase Contracts.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127123
Currency Conversion Rate DateDate upon which to obtain the currency conversion ratePurchase Contracts.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127144
Currency Conversion Rate Date - Day Purchase Contracts.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174030
Currency Conversion Rate Date - Month Purchase Contracts.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174070
Currency Conversion Rate Date - Quarter Purchase Contracts.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174110
Currency Conversion Rate Date - Year Purchase Contracts.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174150
Currency Conversion Rate Type Purchase Contracts.Currency Conversion Rate TypeCURRENCY_CONVERSION_RATE_TYPECURRENCY_CONVERSION_RATE_TYPE127161
DescriptionThe accounting period description.Purchase Contracts.DescriptionDESCRIPTIONDESCRIPTION129827
Document Creation Method Purchase Contracts.Document Creation MethodDOCUMENT_CREATION_METHODDOCUMENT_CREATION_METHOD276091
Document NumberThe journal entry document number.Purchase Contracts.Document NumberDOCUMENT_NUMBERDOCUMENT_NUMBER130347
EDI Type Purchase Contracts.EDI TypeEDI_TYPEEDI_TYPE276086
Edi Processed FlagElectronic Data Interchange (EDI) Processed flagPurchase Contracts.Edi Processed FlagEDI_PROCESSED_FLAGEDI_PROCESSED_FLAG130724
Edi Processed StatusElectronic Data Interchange (EDI) Processed StatusPurchase Contracts.Edi Processed StatusEDI_PROCESSED_STATUSEDI_PROCESSED_STATUS130729
End Effective DateThe date after which an account becomes inactive.Purchase Contracts.End Effective DateEND_EFFECTIVE_DATEEND_EFFECTIVE_DATE133126
End Effective Date - Day Purchase Contracts.End Effective Date END_EFFECTIVE_DATE_DAY178631
End Effective Date - Month Purchase Contracts.End Effective Date END_EFFECTIVE_DATE_MONTH178727
End Effective Date - Quarter Purchase Contracts.End Effective Date END_EFFECTIVE_DATE_QUARTER178823
End Effective Date - Year Purchase Contracts.End Effective Date END_EFFECTIVE_DATE_YEAR178919
Error Message Purchase Contracts.Error MessageERROR_MESSAGEERROR_MESSAGE276085
Firm Status Purchase Contracts.Firm StatusFIRM_STATUSFIRM_STATUS276074
Free On Board Point Purchase Contracts.Free On Board PointFREE_ON_BOARD_POINTFREE_ON_BOARD_POINT276078
Freight Term Purchase Contracts.Freight TermFREIGHT_TERMFREIGHT_TERM276077
Frozen Flag Purchase Contracts.Frozen FlagFROZEN_FLAGFROZEN_FLAG276075
Hold Flag Purchase Contracts.Hold FlagHOLD_FLAGHOLD_FLAG276076
Last Printed Date Purchase Contracts.Last Printed DateLAST_PRINTED_DATELAST_PRINTED_DATE138589
Last Printed Date - Day Purchase Contracts.Last Printed Date LAST_PRINTED_DATE_DAY182378
Last Printed Date - Month Purchase Contracts.Last Printed Date LAST_PRINTED_DATE_MONTH182398
Last Printed Date - Quarter Purchase Contracts.Last Printed Date LAST_PRINTED_DATE_QUARTER182418
Last Printed Date - Year Purchase Contracts.Last Printed Date LAST_PRINTED_DATE_YEAR182438
Last Updated By Purchase Contracts.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139810
Last Updated Date Purchase Contracts.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139984
Last Updated Date - Day Purchase Contracts.Last Updated Date LAST_UPDATED_DATE_DAY182916
Last Updated Date - Month Purchase Contracts.Last Updated Date LAST_UPDATED_DATE_MONTH183078
Last Updated Date - Quarter Purchase Contracts.Last Updated Date LAST_UPDATED_DATE_QUARTER183240
Last Updated Date - Year Purchase Contracts.Last Updated Date LAST_UPDATED_DATE_YEAR183402
Modus Order Number Purchase Contracts.Modus Order NumberMODUS_ORDER_NUMBERMODUS_ORDER_NUMBER276087
Operating Unit IDUnique identifier for Operating UnitPurchase Contracts.Operating Unit IDOPERATING_UNIT_IDOPERATING_UNIT_ID149546
Operating Unit Name Purchase Contracts.Operating Unit NameOPERATING_UNIT_NAMEOPERATING_UNIT_NAME149594
Payment Terms IDUnique identifier for Payment TermsPurchase Contracts.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152266
Payment Terms Name Purchase Contracts.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152282
Print CountNumber of times batch ticket was printed.Purchase Contracts.Print CountPRINT_COUNTPRINT_COUNT155640
Purchase Contract IDUnique identifier for Purchase ContractPurchase Contracts.Purchase Contract IDPURCHASE_CONTRACT_IDPURCHASE_CONTRACT_ID157039
Rate Type Description Purchase Contracts.Rate Type DescriptionRATE_TYPE_DESCRIPTIONRATE_TYPE_DESCRIPTION157646
Rate Type Name Purchase Contracts.Rate Type NameRATE_TYPE_NAMERATE_TYPE_NAME157661
Receiver NoteNote to receiverPurchase Contracts.Receiver NoteRECEIVER_NOTERECEIVER_NOTE158059
Revised Date Purchase Contracts.Revised DateREVISED_DATEREVISED_DATE159500
Revision NumberDocument revision numberPurchase Contracts.Revision NumberREVISION_NUMBERREVISION_NUMBER159536
Ship To Location Purchase Contracts.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161923
Ship To Location IDUnique identifier for Ship To LocationPurchase Contracts.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161950
Start Effective DateThe date on which an account becomes active.Purchase Contracts.Start Effective DateSTART_EFFECTIVE_DATESTART_EFFECTIVE_DATE163284
Start Effective Date - Day Purchase Contracts.Start Effective Date START_EFFECTIVE_DATE_DAY191157
Start Effective Date - Month Purchase Contracts.Start Effective Date START_EFFECTIVE_DATE_MONTH191243
Start Effective Date - Quarter Purchase Contracts.Start Effective Date START_EFFECTIVE_DATE_QUARTER191329
Start Effective Date - Year Purchase Contracts.Start Effective Date START_EFFECTIVE_DATE_YEAR191415
Supplier Contact IDUnique identifier for Supplier ContactPurchase Contracts.Supplier Contact IDSUPPLIER_CONTACT_IDSUPPLIER_CONTACT_ID164178
Supplier Contact Name Purchase Contracts.Supplier Contact NameSUPPLIER_CONTACT_NAMESUPPLIER_CONTACT_NAME164188
Supplier IDUnique identifier for SupplierPurchase Contracts.Supplier IDSUPPLIER_IDSUPPLIER_ID164214
Supplier Name Purchase Contracts.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164258
Supplier NoteNote to supplierPurchase Contracts.Supplier NoteSUPPLIER_NOTESUPPLIER_NOTE164274
Supplier Site Purchase Contracts.Supplier SiteSUPPLIER_SITESUPPLIER_SITE164305
Supplier Site IDUnique identifier for Supplier SitePurchase Contracts.Supplier Site IDSUPPLIER_SITE_IDSUPPLIER_SITE_ID164329
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Purchase Contracts.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167063
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Purchase Contracts -> Standard Purchase Order LinesPurchase Contracts.Document Number = Standard Purchase Order Lines.Contract Number Purchase Contracts.Operating Unit ID = Standard Purchase Order Lines.Operating Unit IDMight not exist in master folderOuter join on master No