| Name | Description | Type | Additional information |
|---|---|---|---|
| DOC_NO | integer |
None. |
|
| DOC_CATEGORY | string |
None. |
|
| DOC_STATUS | integer |
None. |
|
| PARENT_DOC_NO | integer |
None. |
|
| PARENT_DOCCATEGORY | string |
None. |
|
| QA_STATUS | string |
None. |
|
| SETUP_DOC_NO | integer |
None. |
|
| SETUP_DOC_CATEGORY | string |
None. |
|
| SETUP_WO_TYPE | string |
None. |
|
| OUTSIDE_SERVICE | string |
None. |
|
| OUTSIDE_SERVICE_TYPE | integer |
None. |
|
| INVOICE_DOC_NO | integer |
None. |
|
| INVOICE_LINE | decimal number |
None. |
|
| OPR_SEQ | decimal number |
None. |
|
| PREREQ_OPR_SEQ | decimal number |
None. |
|
| PREREQ_DOC_NO | integer |
None. |
|
| DESCRIPTION | string |
None. |
|
| ACCTNO | string |
None. |
|
| SUBC | string |
None. |
|
| UNDER_WARRANTY | string |
None. |
|
| WORK_DATE | date |
None. |
|
| STATION_NO | string |
None. |
|
| OPR_TASK_CODE | string |
None. |
|
| OPR_FUNCTION_CODE | string |
None. |
|
| COST_CODE | string |
None. |
|
| COPY_LABOR_ACTUAL | string |
None. |
|
| MACHINE | string |
None. |
|
| MACHINE_SUBP | string |
None. |
|
| MACHINE_LOGNO | integer |
None. |
|
| SKILL_CODE | string |
None. |
|
| QTY_START | decimal number |
None. |
|
| QTY_FINISH | decimal number |
None. |
|
| QTY_REJECT | decimal number |
None. |
|
| STATUS_CODE | string |
None. |
|
| AUTHORIZED_BY | string |
None. |
|
| AUTHORIZED_DATE | date |
None. |
|
| AUTHORIZED_REV | string |
None. |
|
| SIGNEDOFF_BY | string |
None. |
|
| SIGNEDOFF_DATE | date |
None. |
|
| UNITP_UM | string |
None. |
|
| STANDARD_HOURS_DURATION | decimal number |
None. |
|
| STANDARD_TIME_DURATION | decimal number |
None. |
|
| STANDARD_DAYS_DURATION | integer |
None. |
|
| PLAN_HOURS_DURATION | decimal number |
None. |
|
| PLAN_TIME_START | date |
None. |
|
| PLAN_TIME_END | date |
None. |
|
| MIN_START_DATE | date |
None. |
|
| MAX_START_DATE | date |
None. |
|
| MIN_COMPLETED_DATE | date |
None. |
|
| MAX_COMPLETED_DATE | date |
None. |
|
| PLAN_TIME_DURATION | decimal number |
None. |
|
| RUN_TIME | integer |
None. |
|
| RUN_TIME_SECONDS | decimal number |
None. |
|
| RUN_AND_PLAN_TIME | decimal number |
None. |
|
| REG_COST | decimal number |
None. |
|
| REG_CHARGE | decimal number |
None. |
|
| C_REG_COST | decimal number |
None. |
|
| C_REG_CHARGE | decimal number |
None. |
|
| OVER_COST | decimal number |
None. |
|
| OVER_CHARGE | decimal number |
None. |
|
| C_OVER_COST | decimal number |
None. |
|
| C_OVER_CHARGE | decimal number |
None. |
|
| ACT_TIME_DURATION | decimal number |
None. |
|
| ACT_TIME_COST | decimal number |
None. |
|
| ACT_TIME_CHARGE | decimal number |
None. |
|
| C_ACT_TIME_COST | decimal number |
None. |
|
| C_ACT_TIME_CHARGE | decimal number |
None. |
|
| OVER_TIME_DURATION | decimal number |
None. |
|
| OVER_TIME_COST | decimal number |
None. |
|
| OVER_TIME_CHARGE | decimal number |
None. |
|
| C_OVER_TIME_COST | decimal number |
None. |
|
| C_OVER_TIME_CHARGE | decimal number |
None. |
|
| TOTAL_TIME_DURATION | decimal number |
None. |
|
| TOTAL_CHARGE | decimal number |
None. |
|
| C_TOTAL_CHARGE | decimal number |
None. |
|
| TOTAL_COST | decimal number |
None. |
|
| C_TOTAL_COST | decimal number |
None. |
|
| SUBWO_TOTAL_CHARGE | decimal number |
None. |
|
| C_SUBWO_TOTAL_CHARGE | decimal number |
None. |
|
| SUBWO_TOTAL_COST | decimal number |
None. |
|
| C_SUBWO_TOTAL_COST | decimal number |
None. |
|
| TAX_A_PERC | decimal number |
None. |
|
| TAX_B_PERC | decimal number |
None. |
|
| TAX_A_AMT | decimal number |
None. |
|
| TAX_B_AMT | decimal number |
None. |
|
| TAX_TOTAL | decimal number |
None. |
|
| C_TAX_A_AMT | decimal number |
None. |
|
| C_TAX_B_AMT | decimal number |
None. |
|
| C_TAX_TOTAL | decimal number |
None. |
|
| ROUTINE | string |
None. |
|
| PRIORITY | string |
None. |
|
| MILESTONE_DOC_NO | integer |
None. |
|
| CARD_NO | string |
None. |
|
| PAGE_NO | string |
None. |
|
| USER_DOC | string |
None. |
|
| PARENT_CARD_DOC_NO | integer |
None. |
|
| PARENT_CARD_DOCCATEGORY | string |
None. |
|
| SCOPE_DOC_NO | integer |
None. |
|
| SCOPE_DOCCATEGORY | string |
None. |
|
| CONV_DOC | integer |
None. |
|
| CONV_DOC_CATEGORY | string |
None. |
|
| BILLTO_ACCT | string |
None. |
|
| BILLTO_SUBC | string |
None. |
|
| BILLTO | integer |
None. |
|
| BILLTO_CCODE | string |
None. |
|
| SHIPTO | integer |
None. |
|
| INSTALL_REMOVE | integer |
None. |
|
| INSTALL_REMOVE_DOC_NO | integer |
None. |
|
| FIXED_RATE | string |
None. |
|
| FIXED_AMOUNT | decimal number |
None. |
|
| C_FIXED_AMOUNT | decimal number |
None. |
|
| GL_ACCOUNT | string |
None. |
|
| CARD_REWORK | string |
None. |
|
| CARD_REWORK_BY | string |
None. |
|
| CARD_DEFERRED | string |
None. |
|
| CARD_DEFERRED_BY | string |
None. |
|
| CARD_DEFERRED_DATE | date |
None. |
|
| DEFERRED_DUE_DATE | date |
None. |
|
| DESCRIPTION2 | string |
None. |
|
| DESCRIPTION3 | string |
None. |
|
| OVERTIME_APPROVED | string |
None. |
|
| OVERTIME_APPROVED_BY | string |
None. |
|
| DOT_NO | string |
None. |
|
| ZONE | string |
None. |
|
| ATA | string |
None. |
|
| STATUS_CODE_DATE | date |
None. |
|
| START_DATE | date |
None. |
|
| COMPLETED_DATE | date |
None. |
|
| CARD_DISCOVERED | string |
None. |
|
| CARD_DISCOVERED_BY | string |
None. |
|
| CARD_DISCOVERED_DATE | date |
None. |
|
| FUNCTION_CODE | string |
None. |
|
| CARD_TYPE | string |
None. |
|
| CARD_CLASS | string |
None. |
|
| SKILL_CODE1 | string |
None. |
|
| SKILL_CODE2 | string |
None. |
|
| PRINTED_DATE | date |
None. |
|
| PRINTED_COUNT | integer |
None. |
|
| APPROVED | string |
None. |
|
| APPROVED_DATE | date |
None. |
|
| APPROVED_BY | string |
None. |
|
| APPROVED_BY_CCODE | string |
None. |
|
| ORIG_HOURS_DURATION | decimal number |
None. |
|
| MARKUP_PERC | decimal number |
None. |
|
| SUBTOTAL_CHARGE | decimal number |
None. |
|
| C_SUBTOTAL_CHARGE | decimal number |
None. |
|
| SUBTOTAL_CHARGES_DISC_AMT | decimal number |
None. |
|
| C_SUBTOTAL_CHARGES_DISC_AMT | decimal number |
None. |
|
| DOC_DATE | date |
None. |
|
| REQUIRED_INSPECTION | string |
None. |
|
| COMPANYNO | integer |
None. |
|
| DIVISION | string |
None. |
|
| DEPART | string |
None. |
|
| SUPPRESS_PRINTING | string |
None. |
|
| ORIGINAL_PARENT_CARD | integer |
None. |
|
| FORBIDDEN_BILL_MORE_THEN_PLANE | string |
None. |
|
| INCLUDE_CARD_IN_LOG_BOOK | string |
None. |
|
| WOMNT_CARD_STATUS_DOC_NO | integer |
None. |
|
| APPROVED_HOURS | decimal number |
None. |
|
| CUST_REF1 | string |
None. |
|
| CUST_REF2 | string |
None. |
|
| CUST_REF3 | string |
None. |
|
| CUST_REF4 | string |
None. |
|
| OVER_TIME_BUDGET | decimal number |
None. |
|
| PLAN_TIME_BUDGET | decimal number |
None. |
|
| TOTAL_COST_BUDGET | decimal number |
None. |
|
| C_TOTAL_COST_BUDGET | decimal number |
None. |
|
| WARNING_PERC_OF_COST | decimal number |
None. |
|
| WARNING_PERC_OF_OT | decimal number |
None. |
|
| HOLD_DATE | date |
None. |
|
| HOLD_BY | string |
None. |
|
| HOLD_REASON | string |
None. |
|
| RECLOCK | string |
None. |
|
| ADDED_USR | string |
None. |
|
| ADDED_DTE | date |
None. |
|
| UPDATED_USR | string |
None. |
|
| UPDATED_DTE | date |
None. |