| ield Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| chargeLineTagDescription | Charge Line Tag Description | nvarchar | |
| chargeLineTagNumber | Charge Line Tag Number | nvarchar | |
| cht_code | Charge Type Code | nvarchar | |
| cht_description | Charge Type Description | nvarchar | |
| creatorname | Creator Name | nvarchar | |
| cst_code | Account Code | nvarchar | |
| cst_name | Account Name | nvarchar | |
| ex_batchID | Batch Id | int | |
| ex_bj_fk | Batch Job Id | int | vr_BatchJob |
| ex_chargeAccountNeeded | Charge Account Needed | varchar | |
| ex_cht_fk | Charge Type Id | int | vr_chargeType |
| ex_clnt_fk | Obsolete Column (No Longer Used) | int | |
| ex_comment | Comments | nvarchar | |
| ex_company | Company | nvarchar | |
| ex_createdDate | Record Creation Date | datetime | |
| ex_creator_fk | User Id (Record Creator) | int | |
| ex_cst_fk | Account Id | int | vr_account |
| ex_curr_fk | Currency Id | int | vrpt_Currency |
| ex_exch_date | Currency Exchange Date | datetime | |
| ex_exch_fk | Currency Exchange Id | int | |
| ex_extRetail | Extended Retail | decimal | |
| ex_inventoryAmount | Inventory Amount | decimal | |
| ex_inventoryDate | Inventory Date | datetime | |
| ex_inventoryNumber | Inventory Number | nvarchar | |
| ex_item_fk | Item Id | int | |
| ex_itemtype_fk | Item Type Id | int | |
| ex_lease_bj_fk | Lease Batch Job Id | int | |
| ex_modifiedDate | Last Modified Date | datetime | |
| ex_modifier_fk | User Id (Record Modifier) | int | |
| ex_noCharge | No Charge | bit | |
| ex_pk | Charge Line Id | int | |
| ex_poNumber | Purchase Order Number | nvarchar | |
| ex_postDate | Post Date | datetime | |
| ex_product | Product | nvarchar | |
| ex_quantity | Quantity | decimal | |
| ex_SLPostDate | Sub Ledger Post Date | datetime | |
| ex_tagNumber | Tag Number | nvarchar | |
| ex_taxable | Taxable | bit | |
| ex_taxamount | Tax Amount | decimal | |
| ex_transDate | Transaction Date (Date of Work) | datetime | |
| ex_unit | Unit Cost | nvarchar | |
| ex_unitCost | Unit Cost | decimal | |
| ex_woTask_fk | Work Order Task Id | int | vr_WorkOrderTask |
| ex_wotypepercentage | Work Order Type Percentage | decimal | |
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fromApp | From App | bit | |
| itemType_name | Item Type Name | nvarchar | |
| tagDescription | Tag Description | nvarchar | |
| tagNumber | Tag Number | nvarchar | |
| wo_actionRequested | Action Requested | nvarchar | |
| wo_charge | Indicates Whether the Work Order is Chargeable or Not | bit | |
| wo_completionDate | Completion (Closed) Date | datetime | |
| wo_number | Work Order Number | nvarchar | |
| wo_pk | Work Order Id | int | |
| wo_ReferenceNumber | Reference Number | nvarchar | |
| wo_requestDate | Request Date | datetime | |
| wo_requestor | Requestor | nvarchar | |
| wocstCode | Work Order Account Code | nvarchar | |
| woTask_completionDate | Completion Date (Closed Date) | datetime | |
| woTask_failedPM | Failed PM | bit | |
| woTask_finishDate | Finish Date | datetime | |
| woTask_notLocated | Not Located | bit | |
| wotask_rts_fk | Rate Schedule Id | int | vr_rateSchedule |
| wotask_ss_fk | Status Id | int | vr_Status |
| wotask_status | Task Status | varchar | |
| woTask_workNotDone | Work Not Done | bit |