How is PJC Cost Distribution Accounting Date Derived?
Summary:
How is PJC Cost Distribution Accounting Date Derived?
Content (required):
If I upload Project Costs to the interface using "Load Interface File for Import", data is loaded into the PJC_TXN_XFACE_STAGE_ALL table.
Sample data here:
TXN_INTERFACE_ID (100000468013855) DOCUMENT_NAME (XXCUST_LABOUR_COSTS) DOC_ENTRY_NAME (XXCUST_LABOUR_COSTS) BATCH_NAME (XX_2023_07_27_DEV5_00003) EXPENDITURE_ITEM_DATE (2023-01-12T00:00:00.000+00:00) QUANTITY (2) TRANSACTION_STATUS_CODE (P) ORIG_TRANSACTION_REFERENCE (ref_20230727_00003) USER_TRANSACTION_SOURCE (XXCUST_LABOUR_COSTS) CREATED_BY (USERA) CREATION_DATE (2023-07-27T13:03:20.318+00:00) LAST_UPDATED_BY (USERA) LAST_UPDATE_DATE (2023-07-27T13:03:20.318+00:00) PERSON_ID (100000009893577) OBJECT_VERSION_NUMBER (1) LAST_UPDATE_LOGIN (017820F43224CE2BE0631C60D90A5523) BUSINESS_UNIT (XXCUST BU) PROJECT_NUMBER (1629) TASK_NAME (Approved) EXPENDITURE_TYPE (Staff Time - P) UNIT_OF_MEASURE_NAME (Hours) LOAD_REQUEST_ID (4942817) TRANSACTION_TYPE (LABOR)
Tagged:
0