Powered by InfoCaptor


Previous Page   Next Page

Period Close Variance Transactions
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WIPFG_PERIOD_CLOSE_VAR_TXNSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acct Period IdAccounting period identifierPeriod Close Variance Transactions.Acct Period IdACCT_PERIOD_IDACCT_PERIOD_ID114431
Created ByStandard Who column.Period Close Variance Transactions.Created ByCREATED_BYCREATED_BY124826
Creation Date Period Close Variance Transactions.Creation DateCREATION_DATECREATION_DATE126258
Last Update Date Period Close Variance Transactions.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140779
LineLine namePeriod Close Variance Transactions.LineLINELINE144577
Line IdThe number of the Line ID that is associated to the enrollment through OM or OTA.Period Close Variance Transactions.Line IdLINE_IDLINE_ID144653
Mfg Order IdWIP job or repetitive assembly identifierPeriod Close Variance Transactions.Mfg Order IdMFG_ORDER_IDMFG_ORDER_ID147067
Mfg Order NameWIP job or repetitive assembly name or flow schedule reference codePeriod Close Variance Transactions.Mfg Order NameMFG_ORDER_NAMEMFG_ORDER_NAME147078
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Period Close Variance Transactions.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150170
Organization Id Period Close Variance Transactions.Organization IdORGANIZATION_IDORGANIZATION_ID150437
Organization Name Period Close Variance Transactions.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150734
Period NameThe name of an accounting period.Period Close Variance Transactions.Period NamePERIOD_NAMEPERIOD_NAME153135
ReasonReason namePeriod Close Variance Transactions.ReasonREASONREASON157900
Reason IdReason identifierPeriod Close Variance Transactions.Reason IdREASON_IDREASON_ID157956
SourceCode of the source system that generated the transaction record (null if created by Oracle Work in Process)Period Close Variance Transactions.SourceSOURCESOURCE162318
Source Line IdIdentifier used by the source system that generated the transaction record (null if created by Oracle Work in Process)Period Close Variance Transactions.Source Line IdSOURCE_LINE_IDSOURCE_LINE_ID162445
Transaction Date Period Close Variance Transactions.Transaction DateTRANSACTION_DATETRANSACTION_DATE165655
Transaction Date - Day Period Close Variance Transactions.Transaction Date TRANSACTION_DATE_DAY192349
Transaction Date - Month Period Close Variance Transactions.Transaction Date TRANSACTION_DATE_MONTH192403
Transaction Date - Quarter Period Close Variance Transactions.Transaction Date TRANSACTION_DATE_QUARTER192457
Transaction Date - Year Period Close Variance Transactions.Transaction Date TRANSACTION_DATE_YEAR192511
Transaction IdExternal payment/receipt identifier.Period Close Variance Transactions.Transaction IdTRANSACTION_IDTRANSACTION_ID165704
Transaction ReferenceTransaction reference descriptive textPeriod Close Variance Transactions.Transaction ReferenceTRANSACTION_REFERENCETRANSACTION_REFERENCE165809
Transaction TypeType of the external cash transaction, either payment or receipt.Period Close Variance Transactions.Transaction TypeTRANSACTION_TYPETRANSACTION_TYPE165848
Updated By Period Close Variance Transactions.Updated ByUPDATED_BYUPDATED_BY166525
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto