dts
Tables (74)
All Building (unifier_uxcwab)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Field
All Room (unifier_uxcwa)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Actual Start (actual_start_only) — DATE
- Actual Start (uuu_P6ActualStart) — DATE
- Planned Finish (planned_finish_only) — DATE
- - (WBS_dashbar) — VARCHAR2(3)
- Planned Start (Planned_Start) — DATE
- Actual Finish (actual_finish_only) — DATE
- Lv.3 Code / Name (Lv_3_Code_Name) — VARCHAR2(750)
- 중간자 (d_separate_element) — VARCHAR2(3)
- Lv.1 Code (Lv_1_Phase) — VARCHAR2(96)
- 업체명 (Subcontractor_dpk) — NUMBER(10)
- Planned Finish (uuu_P6PlannedFinish) — DATE
- Lv.3 Name (Lv_3_Name) — VARCHAR2(360)
- Lv.1 Code / Name (Lv_1_Code_Name) — VARCHAR2(750)
- 업체명 (d_subcontractor_bpk) — NUMBER(10)
- Actual Finish (uuu_P6ActualFinish) — DATE
- Creation Date (uuu_creation_date) — DATE
- CWA Code (d_cwa_code) — VARCHAR2(360)
- Lv.1 Name (Lv_1_Name) — VARCHAR2(360)
- Field
Budget Change Orders (unifier_uxbco)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- hidden (xid) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- P6 Planned Cost (ugenP6PlannedCostCA) — FLOAT(50)
- P6 Planned Start (ugenP6PlannedStartDOP) — DATE
- P6 Activity (ugenActivityDPK) — NUMBER(10)
- Contract/PO (refid) — NUMBER(10)
- Transaction Currency (currencyid) — NUMBER(10)
- P6 Planned Finish (ugenP6PlannedFinishDOP) — DATE
Budget Change Orders Line Item (unifier_uxbco_lineitem)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (xid) — NUMBER(10)
- YTB Amount (ytb) — FLOAT(50)
- AFC Amount (afc) — FLOAT(50)
- hidden (bItemID) — NUMBER(10)
- hidden (budgetID) — NUMBER(10)
- hidden (sovitemid) — NUMBER(10)
- hidden (docid) — NUMBER(10)
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Item Quantity (uuu_quantity) — FLOAT(50)
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- BCO Record # (ubiBCORecordNoRND) — VARCHAR2(60)
- P6 Planned Cost (ugenP6PlannedCostCA) — FLOAT(50)
- Line Item Validation Value (ugenLineItemValidation) — NUMBER(10)
- Item Unit Cost (uuu_unit_price) — FLOAT(50)
- Not Costed Quantity (uuu_not_costed_qty) — FLOAT(50)
- Cost Line Item Type (uuu_cost_li_type) — NUMBER(10)
- Costed Quantity (uuu_costed_qty) — FLOAT(50)
- PC Record # (upcRecordNoRND) — VARCHAR2(60)
- P6 Planned Start (ugenP6PlannedStartDOP) — DATE
- P6 Activity (ugenActivityDPK) — NUMBER(10)
- Spend Category (uestSpendTypePD) — VARCHAR2(384)
- Not Costed Amount (uuu_not_costed_amt) — FLOAT(50)
- Approved BC Record # (ugenAppBCRecRND) — VARCHAR2(60)
- Costed Amount (uuu_costed_amt) — FLOAT(50)
- P6 Planned Finish (ugenP6PlannedFinishDOP) — DATE
- Reference (uuu_sovlinum) — NUMBER(10)
Daily Equipment Input (unifier_uxgen14)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Equipment Code (EquipmentCodeBPK) — NUMBER(10)
- 업체명 (d_subcontractor_bpk) — NUMBER(10)
- Creation Date (uuu_creation_date) — DATE
- 공종 (d_subcon_discipline_spd) — VARCHAR2(384)
- 계약번호 (d_subcontract_number) — VARCHAR2(150)
- 중장비 코드 (equipment_code) — VARCHAR2(12)
- 금일 투입장비 (d_today_etotal) — FLOAT(50)
- 보고일자 (d_reporting_date) — DATE
- DISCIPLINE (dash_DISCIPLINE) — VARCHAR2(750)
- 업체명 (d_company_name) — VARCHAR2(150)
- 중장비 코드명 (equipment_code_name) — VARCHAR2(180)
- INOUTDATE (dash_INOUTDATE) — DATE
- VENDORNAME (dash_VENDORNAME) — VARCHAR2(750)
- 하도공사명 (d_subcontract_name) — VARCHAR2(750)
- ACCESS COUNT (AccessCountDA) — FLOAT(50)
Design Reviews (unifier_udr)
- hidden (Key) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Phone (ugenPhoneTXT16) — VARCHAR2(48)
- Description (description) — VARCHAR2(750)
- P6 Activity (ugenActivityDPK) — NUMBER(10)
- City (ugenCityTXT50) — VARCHAR2(150)
- Publish Path (uuu_dm_publish_path) — VARCHAR2(4000)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- P6 Planned Finish (ugenP6PlannedFinishDOP) — DATE
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
- Fax (ugenFaxTXT16) — VARCHAR2(48)
- Creation Date (uuu_creation_date) — DATE
- Delivered Via (usubDeliveredViaPD) — VARCHAR2(384)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Summary (udrSummaryMLTB4000) — VARCHAR2(4000)
- P6 Planned Start (ugenP6PlannedStartDOP) — DATE
- Contract Reference (ugenContractRefBP) — NUMBER(10)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Reference ID (ugenReferenceIDTB120) — VARCHAR2(150)
- State/Province (ugenStatePD) — VARCHAR2(384)
Invoices-General Spends-FM (unifier_uigsf)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60) — Foreign key → Invoices-General Spends-FM Line Item.id — NOT NULL
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- Fax (uveFaxTB16) — VARCHAR2(48)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- PO Amendments (upoPoAmendmentNQB) — FLOAT(50)
- Primary Contact (uvePrimaryContactTB64) — VARCHAR2(192)
- PO Number (upoPONumberTXT16) — VARCHAR2(48)
- Invoice Date (upaInvoiceDateDOP) — Date Only Picker
- Purchase Order (uinvPurchaseOrderCA) — FLOAT(50)
- Description (upoContractDescMLT4000) — VARCHAR2(4000)
- City (ugenCityTXT50) — VARCHAR2(150)
- Contract/PO (refid) — NUMBER(10)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Email (uveEmailTB120) — VARCHAR2(360)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
- Purchase Order (upoPurchaseOrdersNQB) — FLOAT(50)
- Priority (ugenPriorityPD) — VARCHAR2(384)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- PO Amount (uInvPOAmointCA) — FLOAT(50)
- Phone (uvePhoneTB64) — VARCHAR2(192)
- Check Processed Date (upaCheckProcDateDOP) — DATE
- Pending Invoice (uinvPendingInvoiceNQB) — FLOAT(50)
- Vendor Name (uveVendorNameTB50) — VARCHAR2(150)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Estimated Deficiency Amount (ufcaTotlAmtCA) — FLOAT(50)
- Check No (upaCheckNoTB50) — VARCHAR2(150)
- Total Costs (ucwoTotalCostCA) — FLOAT(50)
- Approved Invoice (uinvApprovedSpendsNQB) — FLOAT(50)
- Effective Date (uuu_effective_date) — DATE
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- Check Date (upaCheckDateDOP) — DATE
- Vendor ID (uveVendorIDTB16) — VARCHAR2(48)
- State/Province (ugenStatePD) — VARCHAR2(384)
Invoices-General Spends-FM Line Item (unifier_uigsf_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (sovitemid) — NUMBER(10)
- hidden (cm_cost_lineitem_id) — NUMBER(10)
- Item Quantity (uuu_quantity) — FLOAT(50)
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- Spend Category (uestSpendTypePD) — VARCHAR2(384)
- Effective Date (uuu_effective_date) — DATE
- Item Unit Cost (uuu_unit_price) — FLOAT(50)
Invoices-Generic-FM (unifier_uing)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- Fax (uveFaxTB16) — VARCHAR2(48)
- Ref. Work Order No. (uinvRelatedWoBP) — NUMBER(10)
- Primary Contact (uvePrimaryContactTB64) — VARCHAR2(192)
- Invoice Date (upaInvoiceDateDOP) — DATE
- Vendor (ugenVendorBP) — NUMBER(10)
- City (ugenCityTXT50) — VARCHAR2(150)
- Publish Path (uuu_dm_publish_path) — VARCHAR2(4000)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Email (uveEmailTB120) — VARCHAR2(360)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
- Priority (ugenPriorityPD) — VARCHAR2(384)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Phone (uvePhoneTB64) — VARCHAR2(192)
- Check Processed Date (upaCheckProcDateDOP) — DATE
- Vendor Name (uveVendorNameTB50) — VARCHAR2(150)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Check No (upaCheckNoTB50) — VARCHAR2(150)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- Check Date (upaCheckDateDOP) — DATE
- Vendor ID (uveVendorIDTB16) — VARCHAR2(48)
- State/Province (ugenStatePD) — VARCHAR2(384)
Invoices-Generic-FM Line Item (unifier_uing_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (sovitemid) — NUMBER(10)
- hidden (cm_cost_lineitem_id) — NUMBER(10)
- Account Name (uuu_cm0_name) — VARCHAR2(750)
- Item Quantity (uuu_quantity) — FLOAT(50)
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- Effective Date (uuu_effective_date) — DATE
- Item Unit Cost (uuu_unit_price) — FLOAT(50)
Journal Entries (unifier_uje)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- hidden (xid) — NUMBER(10)
- Retainage Adjustments (ujeRetainageAdjPD) — VARCHAR2(30)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Retainage (ujeRetainageCA) — FLOAT(50)
- Amount (ugenAmountCA) — FLOAT(50)
- PO Number (ujePoNumberPK) — NUMBER(10)
- Description (description) — VARCHAR2(750)
- Contract Reference (ugenContractRefBP) — NUMBER(10)
- Publish Path (uuu_dm_publish_path) — VARCHAR2(4000)
- Transaction Currency (currencyid) — NUMBER(10)
Journal Entries Line Item (unifier_uje_lineitem)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (xid) — NUMBER(10)
- YTB Amount (ytb) — FLOAT(50)
- AFC Amount (afc) — FLOAT(50)
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — Short Description Text
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Cost Code (bItemID) — NUMBER(10)
- hidden (budgetID) — NUMBER(10)
- hidden (sovitemid) — NUMBER(10)
Lease Actions (unifier_ulskdact)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Due Date (ulseLeaseDueDateDOP) — DATE
- Lease Action Progress (ulseActionProgress) — VARCHAR2(384)
- Ref. Primary Lease (ulseLeaseBP) — NUMBER(10)
- Required Action (ulseReqActionTB500) — VARCHAR2(1500)
- Tenant (ulseTenantPK) — NUMBER(10)
- Key Date Type (ulsKeyDateType) — VARCHAR2(384)
- Key Date Item (ulaKeyDateItemLIPK) — NUMBER(10)
- Date Completed (ulaCompletedDOP) — DATE
- Completion Action Details (ulsComActionDetailsTXT2000) — VARCHAR2(4000)
- Lease Record (ugenLeaseBP) — NUMBER(10)
- Lease Title (ulseNameTB250) — VARCHAR2(750)
Lease Amendment Requests (unifier_urelease)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- (uuu_prev_pmtsch_dt) — DATE
- Amendment No. (ulseCurAmendNoDA) — FLOAT(50)
- Description (ugenDescriptionMTL4000) — VARCHAR2(4000)
- Lease Incentives (SL_Lease_Incentives) — FLOAT(50)
- Terminated Status (uLseTerminateRSP) — VARCHAR2(384)
- Incremental borrowing rate to apply (%) (KEY_CL_BorrowingRate) — FLOAT(50)
- Is term greater that 75% of economic life (y/n) (KEY_CL_Economic_Life) — NUMBER(10)
- Tenant Improvements (SL_Tenant_Improvements) — FLOAT(50)
- Refund Date (Lease_Deposit_Refund_Date) — DATE
- Blank - used to wipe out restated values (urfiBlankMTB4000) — VARCHAR2(4000)
- Annual Rent (ulseCurrentRentAnnCA) — FLOAT(50)
- Deposit Paid (Lease_Deposit_Amount_Paid) — FLOAT(50)
- Lease Execution Date (ulseExecutionDOP) — DATE
- Lease Record No. (uls_recordno) — VARCHAR2(60)
- Lease Title (ulseNameTB250) — VARCHAR2(750)
- Does lease provide a bargain purchase option (y/n) (KEY_CL_Bargain_Purchase) — NUMBER(10)
- Deposit Refunded (Lease_Deposit_Amount_Refund) — FLOAT(50)
- Monthly Rent (ulseCurrentRentMonCA) — FLOAT(50)
- Site Code (uSiteID) — VARCHAR2(384)
- Landlord Phone (ulseLLPhoneTXT16) — VARCHAR2(48)
- Lease Expiration Date (uuu_lse_termination_date) — DATE
- Memo (SL_Memo) — VARCHAR2(4000)
- Lease Record (ulseLeaseCreateBC) — NUMBER(10)
- Amended Lease (ulseLeasePK) — NUMBER(10)
- Leased Space (uemLeaseSpaceDPK) — NUMBER(10)
- Unit of Measure (utransPropUOM) — VARCHAR2(384)
- Leased Area Size (uls_Leased_Area_Size) — FLOAT(50)
- Contingent Monthly Rent ( Assumption) (SL_Contingent_rent) — FLOAT(50)
- Capital Lease (KEY_CL_Capital_Lease) — FLOAT(50)
- Additional Contact Information (lse_tenant_other_info) — VARCHAR2(4000)
- Region Name (uRegionName) — VARCHAR2(384)
- Primary Lease No. (uls_prim_recordno) — VARCHAR2(60)
- Sub-Lease Option? (Lease_Sub_Lease_Option) — NUMBER(10)
- Additional Contact Information (lse_landlord_other_info) — VARCHAR2(4000)
- Last Amendment No. (ulseLastAmendNoDA) — FLOAT(50)
- Tenant (ulseTenantPK) — NUMBER(10)
- Bargain Purchase Option (SL_Bargain_Purchase) — FLOAT(50)
- Fair Market Value of property (KEY_CL_FairMarket) — FLOAT(50)
- Lease Amendment Prefix (Lease_amendment_prefix) — VARCHAR2(150)
- Site Name (uSiteName) — VARCHAR2(384)
- LandLord (ulsLandLordDPK) — NUMBER(10)
- Number of Extension Options (ulseExtOptionCount) — NUMBER(10)
- First Payment Due Date (uuu_lse_first_pay_due_date) — DATE
- Region Code (uRegionID) — VARCHAR2(384)
- … +18
Lease Invoices (unifier_uli)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- Phone (ugenPhoneTXT16) — VARCHAR2(48)
- Amendment No. (ulseCurAmendNoDA) — FLOAT(50)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Primary Lease No. (uls_prim_recordno) — VARCHAR2(60)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Tenant Name (lse_Tenant_Name) — VARCHAR2(360)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- City (ugenCityTXT50) — VARCHAR2(150)
- Payment Type (uuu_lse_pay_type) — VARCHAR2(300)
- State/Province (ugenStatePD) — VARCHAR2(384)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Lease Record (ugenLeaseBP) — NUMBER(10)
- Lease Title (ulseNameTB250) — VARCHAR2(750)
Lease Invoices Line Item (unifier_uli_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (sovitemid) — NUMBER(10)
- hidden (cm_cost_lineitem_id) — NUMBER(10)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- Effective Date (uuu_effective_date) — DATE
- Total Payment Amount (uuu_lse_pay_amount) — FLOAT(50)
- Payment Due Date (uuu_lse_pay_due_date) — DATE
- Payment Type (uuu_lse_pay_type) — VARCHAR2(300)
- Payment Late if received after (uuu_lse_pay_latest_due_date) — DATE
- Allocation Amount (uuu_allocation_amount) — FLOAT(50)
Lease Payments (unifier_ulp)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- Phone (ugenPhoneTXT16) — VARCHAR2(48)
- Building Code (uBuildingNumber) — VARCHAR2(384)
- Amendment No. (ulseCurAmendNoDA) — FLOAT(50)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Region Name (uRegionName) — VARCHAR2(384)
- Primary Lease No. (uls_prim_recordno) — VARCHAR2(60)
- Landlord Name (lse_Landlord_Name) — VARCHAR2(360)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Site Code (uSiteID) — VARCHAR2(384)
- Building Name (uBuildingName) — VARCHAR2(384)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- City (ugenCityTXT50) — VARCHAR2(150)
- Payment Type (uuu_lse_pay_type) — VARCHAR2(300)
- Site Name (uSiteName) — VARCHAR2(384)
- State/Province (ugenStatePD) — VARCHAR2(384)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Lease Record (ugenLeaseBP) — NUMBER(10)
- Lease Title (ulseNameTB250) — VARCHAR2(750)
- Region Code (uRegionID) — VARCHAR2(384)
Lease Payments Line Item (unifier_ulp_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (sovitemid) — NUMBER(10)
- hidden (cm_cost_lineitem_id) — NUMBER(10)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- Effective Date (uuu_effective_date) — DATE
- Total Payment Amount (uuu_lse_pay_amount) — FLOAT(50)
- Payment Due Date (uuu_lse_pay_due_date) — DATE
- Payment Type (uuu_lse_pay_type) — VARCHAR2(300)
- Payment Late if received after (uuu_lse_pay_latest_due_date) — DATE
- Allocation Amount (uuu_allocation_amount) — FLOAT(50)
Master Service Agreements (unifier_umsa)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Fax (uveFaxTB16) — VARCHAR2(48)
- Description (ugenDescriptionMTL4000) — VARCHAR2(4000)
- Phone (uvePhoneTB64) — VARCHAR2(192)
- Primary Contact (uvePrimaryContactTB64) — VARCHAR2(192)
- Agreement Type (umsaAgreementTypePD) — VARCHAR2(384)
- Vendor (ugenVendorBP) — NUMBER(10)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Vendor Name (uveVendorNameTB50) — VARCHAR2(150)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- City (ugenCityTXT50) — VARCHAR2(150)
- Service Agreement Number (umsaServAgreeNoRND) — VARCHAR2(48)
- Vendor ID (uveVendorIDTB16) — VARCHAR2(48)
- State/Province (ugenStatePD) — VARCHAR2(384)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Email (uveEmailTB120) — VARCHAR2(360)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
Master Service Agreements Line Item (unifier_umsa_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (sovitemid) — NUMBER(10)
- hidden (cm_cost_lineitem_id) — NUMBER(10)
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- Spend Category (uestSpendTypePD) — VARCHAR2(384)
- Effective Date (uuu_effective_date) — DATE
Material Requests for CWO (unifier_umr1)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Material Costs (ucwoTotalMaterialCostCA) — FLOAT(50)
- Ref. CWO Record (uCWOBP) — NUMBER(10)
- Building (ubldBuildingPK) — NUMBER(10)
Material Requests for CWO Line Item (unifier_umr1_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Item Quantity (uuu_quantity) — FLOAT(50)
- Material Costs (ucwoTotalMaterialCostCA) — FLOAT(50)
- Average Unit Price (ujpAvUnitPricCA) — FLOAT(50)
- Requested Qty (upwoRequestedQuantity) — FLOAT(50)
- Material SKU Master # (umatSKUMasterNuber2RN) — VARCHAR2(60)
- Quantity — FLOAT(50)
- Ref. CWO Record (uCWOBP) — NUMBER(10)
- CWO Line Item (uCWOLIBP) — NUMBER(10)
- Material SKU Master # (umatSKUMasterNuberRN) — VARCHAR2(60)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Requested Material (umativDP) — NUMBER(10)
- Inventory Quantity (uipQtyHandDA) — FLOAT(50)
- Material Name (uuu_cm5_name) — VARCHAR2(750)
- Material from Inventory (uuu_cm5_picker) — NUMBER(10)
- Issued Qty (upwoIssuedQuantity) — FLOAT(50)
- Id from cm_cost_li table for Material Inventory Manager (cm5) (uuu_cm5_li_id) — NUMBER(10)
Material Requests for PWO (unifier_umrpwo)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Material Costs (ucwoTotalMaterialCostCA) — FLOAT(50)
- Ref. PWO Record (uPWOBP) — NUMBER(10)
- Building (ubldBuildingPK) — NUMBER(10)
Material Requests for PWO Line Item (unifier_umrpwo_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Item Quantity (uuu_quantity) — FLOAT(50)
- Material Costs (ucwoTotalMaterialCostCA) — FLOAT(50)
- Average Unit Price (ujpAvUnitPricCA) — FLOAT(50)
- PWO Line Item Picker (upwoPrevMainLineLP) — NUMBER(10)
- Requested Qty (upwoRequestedQuantity) — FLOAT(50)
- Material SKU Master # (umatSKUMasterNuber2RN) — VARCHAR2(60)
- Quantity — FLOAT(50)
- Material SKU Master # (umatSKUMasterNuberRN) — VARCHAR2(60)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Requested Material (umativDP) — NUMBER(10)
- Inventory Quantity (uipQtyHandDA) — FLOAT(50)
- Material Name (uuu_cm5_name) — VARCHAR2(750)
- Material from Inventory (uuu_cm5_picker) — NUMBER(10)
- Issued Qty (upwoIssuedQuantity) — FLOAT(50)
- Id from cm_cost_li table for Material Inventory Manager (cm5) (uuu_cm5_li_id) — NUMBER(10)
Material SKUs Master (unifier_uskum)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Image (upmEqpImg01) — NUMBER(10)
- Material SKU Name (umatSKUMasterNameTB250) — VARCHAR2(750)
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- Creation Date (uuu_creation_date) — DATE
- Material Sub Category (umatSubTypePD) — VARCHAR2(384)
- Material Description (umatSKUMtrDesc) — VARCHAR2(1500)
- Manufacturer (upmManufacturerTXT120) — VARCHAR2(360)
- Material SKU Master # (umatSKUMasterNuberRN) — VARCHAR2(60)
- Material Category (umatCategoryPD) — VARCHAR2(384)
Material SKUs Master Line Item (unifier_uskum_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Fax (uveFaxTB16) — VARCHAR2(48)
- Phone (uvePhoneTB64) — VARCHAR2(192)
- Primary Contact (uvePrimaryContactTB64) — VARCHAR2(192)
- Additional Information (uirAddInfoMTL4000) — VARCHAR2(4000)
- Vendor (ugenVendorBP) — NUMBER(10)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Vendor Name (uveVendorNameTB50) — VARCHAR2(150)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- City (ugenCityTXT50) — VARCHAR2(150)
- Vendor ID (uveVendorIDTB16) — VARCHAR2(48)
- State/Province (ugenStatePD) — VARCHAR2(384)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Email (uveEmailTB120) — VARCHAR2(360)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
Materials Received (unifier_umatr)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Title (uuu_title) — VARCHAR2(750)
- Receiving Type (umatRecTypePD) — VARCHAR2(384)
- PO Number (upoPONumberTXT16) — VARCHAR2(48)
- Ref. PO (uponumber) — NUMBER(10)
- Comments and Other Details (usrDisCommentsTB2000) — VARCHAR2(4000)
Materials Received Line Item (unifier_umatr_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Material SKU Name (umatSKUMasterNameTB250) — VARCHAR2(750)
- Unit Cost (UnitCost) — FLOAT(50)
- Ordered Quantity (umatOrderedQuantity) — FLOAT(50)
- Received Quantity (umatRecQtyDA) — FLOAT(50)
- Material from Inventory (uuu_cm5_picker) — NUMBER(10)
- Receiving Type (umatRecTypePD) — VARCHAR2(384)
- Item Unit Cost (uuu_unit_price) — FLOAT(50)
- Quantity — FLOAT(50)
- Material Cost (uMatCost) — FLOAT(50)
- Material Ordered (umatReceivedItemPkr) — NUMBER(10)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Id from cm_cost_li table for Material Inventory Manager (cm5) (uuu_cm5_li_id) — NUMBER(10)
Meeting Minutes (unifier_umm)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Meeting Location Name (ugenMeetLctnNameTXT120) — VARCHAR2(360)
- Meeting Coordinator (ugenMeetMinsUPK) — NUMBER(10)
- Zip (uuu_proj_zip) — VARCHAR2(192)
- Sort Order Incrementor (ugenSortOrdrIncDA) — FLOAT(50)
- Publish Path (uuu_dm_publish_path) — VARCHAR2(4000)
- Due Date Duration (ugenDueDateDurationIA) — NUMBER(10)
- Address (ugenAddTXT250) — VARCHAR2(750)
- Subject (ugenSbjctSSDT32) — VARCHAR2(96)
- Creation Date (uuu_creation_date) — DATE
- # in Attendance (ugenAtdncDA) — FLOAT(50)
- # of Business Items (ugenBsnsItmsDA) — FLOAT(50)
- Purpose (ummPurposeMLT4000) — VARCHAR2(4000)
- Meeting Date and Start Time (ugenMeetDateStrtTimeDP) — DATE
- # of Invited Attendees (ugenIntdAtndDA) — FLOAT(50)
- Action Item Approver (ugenActnItemAppvDP) — NUMBER(10)
- Meeting Type (ugenMeetTypeMMPD) — VARCHAR2(384)
- State/Province (uState1PD) — VARCHAR2(384)
- City (uCityTXT250) — VARCHAR2(150)
- Action Item Approver Email (ugenActnItmAppvMailSMN) — VARCHAR2(192)
Meeting Minutes Line Item (unifier_umm_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Work Phone (uuu_user_workphone) — VARCHAR2(192)
- Name (uuu_user_name) — VARCHAR2(192)
- E-Mail (uuu_user_email) — VARCHAR2(192)
- Description (ugenDescSDT2000) — VARCHAR2(4000)
- Include in next meeting(1=yes; 0=No) (ugenNxtMeetDA) — FLOAT(50)
- In Attendance? (ugenInAttdMAPD) — NUMBER(10)
- Action Item Status (ugenActionItemBC) — NUMBER(10)
- Job Title (uuu_user_title) — VARCHAR2(192)
- Key Decision? (ummKeyDcsnYNPD) — VARCHAR2(384)
- Further Action Required? (ummFurtActnReqYNIPD) — NUMBER(10)
- Name / Title (ugenNameSSDT120) — VARCHAR2(360)
- # of Business Items (ugenBsnsItmsDA) — FLOAT(50)
- Notes/Resolution (uaiResNotesMLT4000) — VARCHAR2(4000)
- Include in next meeting? (ugenNxtMeetPDI) — NUMBER(10)
- Company (uuu_user_company) — VARCHAR2(192)
- First Name (uuu_user_firstname) — VARCHAR2(192)
- Ext. Company name (ugenExtCmpnyNameSSDT120) — VARCHAR2(360)
- Action Item Approver (ugenActnItemAppvDP) — NUMBER(10)
- Start Date (ugenStrtdateDOP) — DATE
- Invited Attendee Count Value (ugenAttndCntValuDA) — FLOAT(50)
- Selected Issue # (upoSelectIssueBP) — NUMBER(10)
- Invited Attendee (selector) (ugenInvtAttnADP) — NUMBER(10)
- Assigned To (ugenAsgnToADP) — NUMBER(10)
- Title (title) — VARCHAR2(150)
- In Attendance Value (ugenAttndValuDA) — FLOAT(50)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Sort Order Incrementor (ugenSortOrdrIncDA) — FLOAT(50)
- Action Item Type (ugenActnItemTypeSSDT32) — VARCHAR2(96)
- Create new issue? (uriCreateNewIssueSYN) — VARCHAR2(30)
- Last Name (uuu_user_lastname) — VARCHAR2(192)
- External Assignee Name (ummExtAssineeNameTXT120) — VARCHAR2(360)
- Details (ugenDetailMTL4000) — VARCHAR2(4000)
- Business Item Type (ugenNsnsItmTypMMBPD) — NUMBER(10)
- External Assignee? (ummExtAssigneeYN) — VARCHAR2(30)
- Attendee (ugenAttndUP) — NUMBER(10)
- Mobile Phone (uuu_user_mobilephone) — VARCHAR2(192)
- Item # (ugenItemDA) — FLOAT(50)
- New Issue Record # (uriNewIssueRecordBP) — NUMBER(10)
- Today (ugenTodayDateDOP) — DATE
- Action Item Complete Date (ugenActnItmCmpltDateDP) — DATE
- Brief Summary of Actions Taken (ugenSumActionMLT2000) — VARCHAR2(4000)
- Attendee Name (ummAttndMN) — VARCHAR2(192)
- Due Date (ugenDueDateDO) — DATE
- Login User Name (uuu_user_loginname) — VARCHAR2(192)
- Risk Category (uriRiskCategoryPD) — VARCHAR2(384)
- Owner (ugenOwnerUP) — NUMBER(10)
- Action Item Approver Email (ugenActnItmAppvMailSMN) — VARCHAR2(192)
Meters (unifier_umt)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Gauge / Meter Type (uuu_rec_meter_type) — NUMBER(10)
- Creation Date (uuu_creation_date) — DATE
- Gauge / Meter UOM (ufmMeterUOMPD) — VARCHAR2(384)
- Asset Record (uuu_rec_asset_bp) — NUMBER(10)
- Rollover Point (uuu_meter_rollover_pt) — FLOAT(50)
- Average units per day (uuu_meter_avg_units) — FLOAT(50)
- Model (upmModelTXT120) — VARCHAR2(360)
- Asset Type (upmEqpTypePD) — VARCHAR2(384)
- Latest Reading (uuu_meter_latest_rdng) — FLOAT(50)
- Manufacturer (upmManufacturerTXT120) — VARCHAR2(360)
- Asset ID (ufmEQIDTXT16) — VARCHAR2(48)
- Gauge / Meter Name (ueqpMeterNameTB120) — VARCHAR2(360)
- Asset Name (upmEqpName) — VARCHAR2(750)
- Gauge / Meter (uuu_rec_ast_meter_li) — NUMBER(10)
- Effective Date (uuu_effective_date) — DATE
- Cumulative Reading (uuu_meter_cumu_rdng) — FLOAT(50)
- Base Reading (uuu_meter_base_rdng) — FLOAT(50)
Meters Line Item (unifier_umt_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Gauge / Meter UOM (ufmMeterUOMPD) — VARCHAR2(384)
- Effective Date (uuu_effective_date) — DATE
- Reading Type (uuu_meter_rdng_type) — NUMBER(10)
- Initial Reading (uuu_meter_init_rdng) — FLOAT(50)
- Meter Reading (uuu_meter_reading) — FLOAT(50)
- Lineitem Status (uuu_line_item_status) — VARCHAR2(150)
Move Work Orders (unifier_umwo)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Empty Data (uSpaceElementClear2MN) — VARCHAR2(192)
- Empty Data (uSpaceElementClear4MN) — VARCHAR2(192)
- New Space (uemSpace4DPK) — NUMBER(10)
- Move Request Reference (uMoveRequestRefBP) — NUMBER(10)
- City (ugenCityTXT50) — VARCHAR2(150)
- Move to Location (umtMoveLocBldDPK) — NUMBER(10)
- Zip/Postal Code (uZipCodeTXT216) — VARCHAR2(48)
- Creation Date (uuu_creation_date) — DATE
- JobPlan (umtJobPlnDPK) — NUMBER(10)
- Address Code (uuu_address_code) — VARCHAR2(1500)
- Address 3 (uAddress3TXT120) — VARCHAR2(360)
- Employee Last Name (uEmpLastNameSMN) — VARCHAR2(192)
- Employee Phone (uEmpPhone) — VARCHAR2(192)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- SKONe 그룹 (usmUSAssignedDeptPD) — VARCHAR2(384)
- Default Status for Vacant Space (usmVacantOccupStatus) — VARCHAR2(384)
- Country (ugenCountryPD) — VARCHAR2(384)
- Building Code of Move Location (uBuildingNumber2) — VARCHAR2(384)
- Shell Picker (ugenShellPK) — NUMBER(10)
- Building Name (BuildingName) — VARCHAR2(384)
- Empty Data (uSpaceElementClear1MN) — VARCHAR2(192)
- Empty Data (uSpaceElementClear3MN) — VARCHAR2(192)
- Requires Job Plan? (umtReqJpPD) — VARCHAR2(30)
- Floor (ugen3FlrTB120) — VARCHAR2(150)
- Space No. (uplRoom3TB250) — VARCHAR2(750)
- Employee Email (uEmpEmail) — VARCHAR2(192)
- Country (uCountry1PD) — VARCHAR2(384)
- Requested Move Date (umrReqMovDatDOP) — DATE
- Address 2 (uAddress2TXT120) — VARCHAR2(360)
- Job Plan Type (ujpJobPlanTypePD) — VARCHAR2(384)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Employee (umtEmployeeDPK) — NUMBER(10)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
- Default Status for Occupied Space (usmOccupOccupStatus) — VARCHAR2(384)
- 직무 (ugenFlrTB120) — VARCHAR2(150)
- Building Code (uBuildingNumber) — VARCHAR2(384)
- Reason For Move (ugenResnMovMTL4000) — VARCHAR2(384)
- Instructions (ugenInstructionMTL4000) — VARCHAR2(4000)
- Employee First Name (uEmpFirstNameSMN) — VARCHAR2(192)
- Building Name (uBuildingName) — VARCHAR2(384)
- Current Space (uemSpaceDPK) — NUMBER(10)
- Actual Move Date (umrActlMovDatDOP) — DATE
- Move from Location (umoverequestBuildingDP) — NUMBER(10)
- Clear Assigned Department (uSpaceAssignedDeptClearPD) — VARCHAR2(384)
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Address 1 (uAddress1TXT120) — VARCHAR2(360)
- Space No. (uplRoom4TB250) — VARCHAR2(750)
- … +3
Move Work Orders Line Item (unifier_umwo_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Task Sequence # (ujpActivitySequenceTXT4) — VARCHAR2(12)
- Item Quantity (uuu_quantity) — FLOAT(50)
- UOM (uuu_resc_assign_uom) — VARCHAR2(75)
- Asset Type (uempAsstTypePD) — VARCHAR2(384)
- Asset (usmAssetDP) — NUMBER(10)
- Quantity — FLOAT(50)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Material Name (uuu_cm5_name) — VARCHAR2(750)
- Need to Move? (umtMovePD) — VARCHAR2(30)
- Estimated Time (Hrs) (ucwoEstimReqTimeDA) — FLOAT(50)
- Material from Inventory (uuu_cm5_picker) — NUMBER(10)
- Task Name (ujpTaskNameTXT250) — VARCHAR2(750)
- Estimated Quantity (upwoEstiQtyDA) — FLOAT(50)
- Labor Type (ucwoLaborTypePD) — VARCHAR2(384)
- Notes — VARCHAR2(4000)
- Moved? (umtMovedPD) — VARCHAR2(30)
- Id from cm_cost_li table for Material Inventory Manager (cm5) (uuu_cm5_li_id) — NUMBER(10)
PM Book Templates (unifier_upmbt)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- PM Book Template ID (uPMTemplateIdAS) — VARCHAR2(1536)
- Short Description Default Value (Short_Descrip_Default_Value) — VARCHAR2(150)
- Creation Date (uuu_creation_date) — DATE
- Asset Record (uuu_rec_asset_bp) — NUMBER(10)
- Model (upmModelTXT120) — VARCHAR2(360)
- Asset Type (upmEqpTypePD) — VARCHAR2(384)
- PM Book Template Name Suffix (uepqPMBookTempNameCV) — VARCHAR2(360)
- Manufacturer (upmManufacturerTXT120) — VARCHAR2(360)
- Asset Template Picker (Asset_Template_Pkr) — NUMBER(10)
- Asset Template Name (upmEqpAssetTempName) — VARCHAR2(750)
- PM Book Template Name (uepqPMBookTempName) — VARCHAR2(360)
- Asset Template Record # (Asset_Template_Record_No) — VARCHAR2(60)
PM Book Templates Line Item (unifier_upmbt_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (uuu_guid) — VARCHAR2(384)
- hidden (uuu_tab_type) — NUMBER(10)
- Less Than (uuu_rec_gauge_lt) — FLOAT(50)
- Tolerance (uuu_rec_tolerance) — FLOAT(50)
- Job Plan Name (ujpJobPlanName) — VARCHAR2(360)
- Additional Scheduling Conditions (uuu_rec_ses_dates_pkr) — NUMBER(10)
- Gauge / Meter UOM (ufmMeterUOMPD) — VARCHAR2(384)
- Related Job Plan (ujpJobPlanDP) — NUMBER(10)
- Family Identifier (uuu_rec_family_identifier) — NUMBER(10)
- Greater Than (uuu_rec_gauge_gt) — FLOAT(50)
- Line Item Status (uuu_line_item_status) — VARCHAR2(150)
- Frequency Unit (uuu_rec_frequency_unit) — NUMBER(10)
- Schedule Type (uuu_rec_schedule_type) — NUMBER(10)
- Gauge / Meter (uuu_rec_ast_meter_li) — NUMBER(10)
- Frequency (uuu_rec_frequency) — NUMBER(10)
- Recurrence (uuu_recurrence) — VARCHAR2(750)
- Lead Time (days) (uuu_rec_lead_time) — NUMBER(10)
PO Amendments (unifier_upa1)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- hidden (xid) — NUMBER(10)
- Fax (uveFaxTB16) — VARCHAR2(48)
- Primary Contact (uvePrimaryContactTB64) — VARCHAR2(192)
- PO Number (upoPONumberTXT16) — VARCHAR2(48)
- P6 Activity (ugenActivityDPK) — NUMBER(10)
- City (ugenCityTXT50) — VARCHAR2(150)
- Publish Path (uuu_dm_publish_path) — VARCHAR2(4000)
- Contract/PO (refid) — NUMBER(10)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- P6 Planned Finish (ugenP6PlannedFinishDOP) — DATE
- Email (uveEmailTB120) — VARCHAR2(360)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- PO Title (upoTitleSD) — VARCHAR2(150)
- P6 Planned Cost (ugenP6PlannedCostCA) — FLOAT(50)
- Phone (uvePhoneTB64) — VARCHAR2(192)
- Vendor Name (uveVendorNameTB50) — VARCHAR2(150)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- P6 Planned Start (ugenP6PlannedStartDOP) — DATE
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- Transaction Currency (currencyid) — NUMBER(10)
- Vendor ID (uveVendorIDTB16) — VARCHAR2(48)
- State/Province (ugenStatePD) — VARCHAR2(384)
PO Amendments Line Item (unifier_upa1_lineitem)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (xid) — NUMBER(10)
- YTB Amount (ytb) — FLOAT(50)
- AFC Amount (afc) — FLOAT(50)
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- Item Quantity (uuu_quantity) — Decimal Amount
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- Work Package (wpid) — NUMBER(10)
- P6 Planned Cost (ugenP6PlannedCostCA) — FLOAT(50)
- Item Unit Cost (uuu_unit_price) — FLOAT(50)
- P6 Planned Start (ugenP6PlannedStartDOP) — DATE
- P6 Activity (ugenActivityDPK) — NUMBER(10)
- Spend Category (uestSpendTypePD) — VARCHAR2(384)
- Cost Code (bItemID) — NUMBER(10)
- hidden (budgetID) — NUMBER(10)
- hidden (sovitemid) — NUMBER(10)
- P6 Planned Finish (ugenP6PlannedFinishDOP) — DATE
- Reference (uuu_sovlinum) — NUMBER(10)
PO Amendments-FM (unifier_upafm)
- hidden (id) — NUMBER(10) — Primary key — NOT NULL
- Record No. (record_no) — VARCHAR2(60)
- Title (title) — VARCHAR2(150)
- Due Date (due_date) — DATE
- End Date (end_date) — DATE
- Record Last Update Date (uuu_record_last_update_date) — DATE
- hidden (process_status) — NUMBER(10)
- Status (status) — VARCHAR2(60)
- Creator (creator_id) — NUMBER(10)
- hidden (project_id) — NUMBER(10)
- hidden (attach_cnt) — NUMBER(10)
- hidden (reason) — NUMBER(10)
- Rate in Project Currency (currencyrate) — FLOAT(50)
- Rate in Base Currency (usd_currencyrate) — FLOAT(50)
- Transaction Currency (currencyid) — NUMBER(10)
- Fax (uveFaxTB16) — VARCHAR2(48)
- Primary Contact (uvePrimaryContactTB64) — VARCHAR2(192)
- PO Number (upoPONumberTXT16) — VARCHAR2(48)
- Description (upoContractDescMLT4000) — VARCHAR2(4000)
- City (ugenCityTXT50) — VARCHAR2(150)
- Contract/PO (refid) — NUMBER(10)
- Zip/Postal Code (ugenZipCodeTXT16) — VARCHAR2(48)
- Email (uveEmailTB120) — VARCHAR2(360)
- Type of PO (upoTypeOfPO) — VARCHAR2(384)
- Address 3 (ugenAddress3TXT120) — VARCHAR2(360)
- Amount (amount) — FLOAT(50)
- Creation Date (uuu_creation_date) — DATE
- Phone (uvePhoneTB64) — VARCHAR2(192)
- Vendor Name (uveVendorNameTB50) — VARCHAR2(150)
- Address 1 (ugenAddress1TXT120) — VARCHAR2(360)
- Effective Date (uuu_effective_date) — DATE
- Address 2 (ugenAddress2TXT120) — VARCHAR2(360)
- Country (ugenCountryPD) — VARCHAR2(384)
- Vendor ID (uveVendorIDTB16) — VARCHAR2(48)
- State/Province (ugenStatePD) — VARCHAR2(384)
PO Amendments-FM Line Item (unifier_upafm_lineitem)
- (id) — NUMBER(10) — Primary key — NOT NULL
- hidden (record_id) — NUMBER(10)
- hidden (task_id) — NUMBER(10)
- hidden (group_id) — NUMBER(10)
- hidden (group_type) — NUMBER(10)
- Item No. (li_num) — NUMBER(10)
- Amount (amount) — FLOAT(50)
- Short Description (short_desc) — VARCHAR2(150)
- Description (description) — VARCHAR2(750)
- hidden (attach_cnt) — NUMBER(10)
- hidden (uuu_tab_id) — NUMBER(10)
- Line Item Last Update Date (uuu_li_last_update_date) — DATE
- hidden (sovitemid) — NUMBER(10)
- hidden (cm_cost_lineitem_id) — NUMBER(10)
- Item Quantity (uuu_quantity) — FLOAT(50)
- Unit of Measure (ugenUnitofMeasurePD) — VARCHAR2(75)
- Account Code (uuu_cm0_picker) — NUMBER(10)
- Spend Category (uestSpendTypePD) — VARCHAR2(384)
- Effective Date (uuu_effective_date) — DATE
- Item Unit Cost (uuu_unit_price) — FLOAT(50)
- Reference (uuu_sovlinum) — NUMBER(10)