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)