| Name | Description | Type | Additional information |
|---|---|---|---|
| DOC_NO | integer |
None. |
|
| PARENT_DOC_NO | integer |
None. |
|
| PARENT_DOCCATEGORY | string |
None. |
|
| PARENT_LINE | decimal number |
None. |
|
| USER_DOC | string |
None. |
|
| DOC_TYPE | string |
None. |
|
| DOC_CATEGORY | string |
None. |
|
| DOC_STATUS | integer |
None. |
|
| PROC_TYPE | string |
None. |
|
| ACCTNO | string |
None. |
|
| SUBC | string |
None. |
|
| CCODE | string |
None. |
|
| OURCONTACT | string |
None. |
|
| LINES | integer |
None. |
|
| ULINES | string |
None. |
|
| ENTER_DATE | date |
None. |
|
| DOC_DATE | date |
None. |
|
| DUE_DATE | date |
None. |
|
| SHIP_DATE | date |
None. |
|
| SHIP_COMPLETE | string |
None. |
|
| PRICED_DATE | date |
None. |
|
| VALIDTILL_DATE | date |
None. |
|
| VALIDFOR | integer |
None. |
|
| AMENDED | date |
None. |
|
| ACKNLDGE | date |
None. |
|
| RECV_DATE | date |
None. |
|
| PICKED_DATE | date |
None. |
|
| SHIPPED_DATE | date |
None. |
|
| REVISION | string |
None. |
|
| POST_GL_DATE | date |
None. |
|
| POST_STK_DATE | date |
None. |
|
| APPROVED_DATE | date |
None. |
|
| BATCH_NO | integer |
None. |
|
| BATCH_DATE | date |
None. |
|
| PRINTED_DATE | date |
None. |
|
| PRINTED_COUNT | integer |
None. |
|
| CUST_REF1 | string |
None. |
|
| CUST_REF2 | string |
None. |
|
| CUST_REF3 | string |
None. |
|
| CUST_REF4 | string |
None. |
|
| DROPSHIP | string |
None. |
|
| DROPSHIP_ACCT | string |
None. |
|
| DROPSHIP_SUBC | string |
None. |
|
| DROPSHIP_CCODE | string |
None. |
|
| DROPSHIPTO | integer |
None. |
|
| SHIPTO | integer |
None. |
|
| SHIPTO_SUBC | string |
None. |
|
| SHIPTO_CCODE | string |
None. |
|
| BILLTO | integer |
None. |
|
| BILLTO_SUBC | string |
None. |
|
| BILLTO_CCODE | string |
None. |
|
| PAYTO | integer |
None. |
|
| PAYTO_SUBC | string |
None. |
|
| PAYTO_CCODE | string |
None. |
|
| COMPANYNO | integer |
None. |
|
| DIVISION | string |
None. |
|
| DEPART | string |
None. |
|
| HOLD_DATE | date |
None. |
|
| HOLD_BY | string |
None. |
|
| HOLD_REASON | string |
None. |
|
| DELIVERY | string |
None. |
|
| TERM_CODE | string |
None. |
|
| PRIORITY | string |
None. |
|
| SHIPVIA | string |
None. |
|
| FOB | string |
None. |
|
| FOB_LBL | string |
None. |
|
| PACKAGES | integer |
None. |
|
| SHIPMENT_NO | integer |
None. |
|
| CONSOL_NO | integer |
None. |
|
| HOUS_AIRBILL | string |
None. |
|
| MAST_AIRBILL | string |
None. |
|
| PRINT_PN_MEM1 | string |
None. |
|
| PRINT_PN_MEM2 | string |
None. |
|
| PRINT_DOC_MSG | string |
None. |
|
| PRINT_DOC_MEM | string |
None. |
|
| DOC_INVNO | string |
None. |
|
| DOC_INVAMOUNT | decimal number |
None. |
|
| GL_ACCOUNT | string |
None. |
|
| GL_BYLINE | string |
None. |
|
| FORM_1099TYPE | string |
None. |
|
| SMAN1_CODE | string |
None. |
|
| SMAN2_CODE | string |
None. |
|
| SMAN3_CODE | string |
None. |
|
| SMAN4_CODE | string |
None. |
|
| SMAN5_CODE | string |
None. |
|
| SMAN1_PERC | decimal number |
None. |
|
| SMAN2_PERC | decimal number |
None. |
|
| SMAN3_PERC | decimal number |
None. |
|
| SMAN4_PERC | decimal number |
None. |
|
| SMAN5_PERC | decimal number |
None. |
|
| SMAN1_DOCLN | string |
None. |
|
| SMAN2_DOCLN | string |
None. |
|
| SMAN3_DOCLN | string |
None. |
|
| SMAN4_DOCLN | string |
None. |
|
| SMAN5_DOCLN | string |
None. |
|
| SMAN1_NG | string |
None. |
|
| SMAN2_NG | string |
None. |
|
| SMAN3_NG | string |
None. |
|
| SMAN4_NG | string |
None. |
|
| SMAN5_NG | string |
None. |
|
| WGHT_TO | string |
None. |
|
| VOL_TO | string |
None. |
|
| LENGTH_TO | string |
None. |
|
| WGHT_TTL | decimal number |
None. |
|
| VOL_TTL | decimal number |
None. |
|
| LENGTH_TTL | decimal number |
None. |
|
| WGHT_GROSS | decimal number |
None. |
|
| VOL_GROSS | decimal number |
None. |
|
| LENGTH_GROSS | decimal number |
None. |
|
| CURENCY_STATE | string |
None. |
|
| CURENCY_BASE | string |
None. |
|
| CURENCY_CONV | string |
None. |
|
| CURENCY_FACTOR | decimal number |
None. |
|
| CURENCY_DATE | date |
None. |
|
| SIGN_1 | string |
None. |
|
| SIGN_2 | string |
None. |
|
| SIGN_3 | string |
None. |
|
| SIGN_4 | string |
None. |
|
| SIGN_5 | string |
None. |
|
| SIGN_1_APR | string |
None. |
|
| SIGN_2_APR | string |
None. |
|
| SIGN_3_APR | string |
None. |
|
| SIGN_4_APR | string |
None. |
|
| SIGN_5_APR | string |
None. |
|
| SIGN_1_DATE | date |
None. |
|
| SIGN_2_DATE | date |
None. |
|
| SIGN_3_DATE | date |
None. |
|
| SIGN_4_DATE | date |
None. |
|
| SIGN_5_DATE | date |
None. |
|
| DISC_TYPE | string |
None. |
|
| MISC1_TYPE | string |
None. |
|
| MISC2_TYPE | string |
None. |
|
| MISC3_TYPE | string |
None. |
|
| MISC4_TYPE | string |
None. |
|
| MISC5_TYPE | string |
None. |
|
| MISC6_TYPE | string |
None. |
|
| DISC_PERC | decimal number |
None. |
|
| MISC1_PERC | decimal number |
None. |
|
| MISC2_PERC | decimal number |
None. |
|
| MISC3_PERC | decimal number |
None. |
|
| MISC4_PERC | decimal number |
None. |
|
| MISC5_PERC | decimal number |
None. |
|
| MISC6_PERC | decimal number |
None. |
|
| MISC1_PRN | string |
None. |
|
| MISC2_PRN | string |
None. |
|
| MISC3_PRN | string |
None. |
|
| MISC4_PRN | string |
None. |
|
| MISC5_PRN | string |
None. |
|
| MISC6_PRN | string |
None. |
|
| MISC1_TTL | string |
None. |
|
| MISC2_TTL | string |
None. |
|
| MISC3_TTL | string |
None. |
|
| MISC4_TTL | string |
None. |
|
| MISC5_TTL | string |
None. |
|
| MISC6_TTL | string |
None. |
|
| LABOR_MISC1_TTL | string |
None. |
|
| LABOR_MISC2_TTL | string |
None. |
|
| LABOR_MISC3_TTL | string |
None. |
|
| LABOR_MISC4_TTL | string |
None. |
|
| LABOR_MISC5_TTL | string |
None. |
|
| LABOR_MISC6_TTL | string |
None. |
|
| DISC_DOCLN | string |
None. |
|
| MISC1_DOCLN | string |
None. |
|
| MISC2_DOCLN | string |
None. |
|
| MISC3_DOCLN | string |
None. |
|
| MISC4_DOCLN | string |
None. |
|
| MISC5_DOCLN | string |
None. |
|
| MISC6_DOCLN | string |
None. |
|
| TAX_SUBTOTAL_DOCLN | string |
None. |
|
| TAX_SUBTOTAL_TYPE | string |
None. |
|
| TAX_A_CODE | string |
None. |
|
| TAX_B_CODE | string |
None. |
|
| TAX_C_CODE | string |
None. |
|
| TAX_A_PERC | decimal number |
None. |
|
| TAX_B_PERC | decimal number |
None. |
|
| TAX_C_PERC | decimal number |
None. |
|
| TAX_A_AMT | decimal number |
None. |
|
| TAX_B_AMT | decimal number |
None. |
|
| TAX_C_AMT | decimal number |
None. |
|
| ADDITIONAL_TAX_AMT | decimal number |
None. |
|
| TAX_A_TTL | string |
None. |
|
| TAX_B_TTL | string |
None. |
|
| TAX_C_TTL | string |
None. |
|
| TAX_ON_TAX_B | string |
None. |
|
| TAX_A_CALC | string |
None. |
|
| TAX_B_CALC | string |
None. |
|
| SUB_TAX_A | string |
None. |
|
| SUB_TAX_B | string |
None. |
|
| SUB_TAX_AMT | decimal number |
None. |
|
| M1_TAX_A | string |
None. |
|
| M1_TAX_B | string |
None. |
|
| M1_TAX_AMT | decimal number |
None. |
|
| M2_TAX_A | string |
None. |
|
| M2_TAX_B | string |
None. |
|
| M2_TAX_AMT | decimal number |
None. |
|
| M3_TAX_A | string |
None. |
|
| M3_TAX_B | string |
None. |
|
| M3_TAX_AMT | decimal number |
None. |
|
| M4_TAX_A | string |
None. |
|
| M4_TAX_B | string |
None. |
|
| M4_TAX_AMT | decimal number |
None. |
|
| M5_TAX_A | string |
None. |
|
| M5_TAX_B | string |
None. |
|
| M5_TAX_AMT | decimal number |
None. |
|
| M6_TAX_A | string |
None. |
|
| M6_TAX_B | string |
None. |
|
| M6_TAX_AMT | decimal number |
None. |
|
| AEROXCHANGE | string |
None. |
|
| LINE_TAX_A_AMT | decimal number |
None. |
|
| LINE_TAX_B_AMT | decimal number |
None. |
|
| LINE_TAX_C_AMT | decimal number |
None. |
|
| HDR_TAX_A_AMT | decimal number |
None. |
|
| HDR_TAX_B_AMT | decimal number |
None. |
|
| HDR_TAX_C_AMT | decimal number |
None. |
|
| TAX_A_GL | string |
None. |
|
| TAX_B_GL | string |
None. |
|
| TAX_C_GL | string |
None. |
|
| SUBTOTAL | decimal number |
None. |
|
| DISC_AMT | decimal number |
None. |
|
| SUBTOTALNET | decimal number |
None. |
|
| SMAN1_AMT | decimal number |
None. |
|
| SMAN2_AMT | decimal number |
None. |
|
| SMAN3_AMT | decimal number |
None. |
|
| SMAN4_AMT | decimal number |
None. |
|
| SMAN5_AMT | decimal number |
None. |
|
| MISC1_AMT | decimal number |
None. |
|
| MISC2_AMT | decimal number |
None. |
|
| MISC3_AMT | decimal number |
None. |
|
| MISC4_AMT | decimal number |
None. |
|
| MISC5_AMT | decimal number |
None. |
|
| MISC6_AMT | decimal number |
None. |
|
| MISC1_AMT_PAID | decimal number |
None. |
|
| MISC2_AMT_PAID | decimal number |
None. |
|
| MISC3_AMT_PAID | decimal number |
None. |
|
| MISC4_AMT_PAID | decimal number |
None. |
|
| MISC5_AMT_PAID | decimal number |
None. |
|
| MISC6_AMT_PAID | decimal number |
None. |
|
| DOC_TOTAL | decimal number |
None. |
|
| C_SUBTOTAL | decimal number |
None. |
|
| C_DISC_AMT | decimal number |
None. |
|
| C_SUBTOTALNET | decimal number |
None. |
|
| C_SMAN1_AMT | decimal number |
None. |
|
| C_SMAN2_AMT | decimal number |
None. |
|
| C_SMAN3_AMT | decimal number |
None. |
|
| C_SMAN4_AMT | decimal number |
None. |
|
| C_SMAN5_AMT | decimal number |
None. |
|
| C_MISC1_AMT | decimal number |
None. |
|
| C_MISC2_AMT | decimal number |
None. |
|
| C_MISC3_AMT | decimal number |
None. |
|
| C_MISC4_AMT | decimal number |
None. |
|
| C_MISC5_AMT | decimal number |
None. |
|
| C_MISC6_AMT | decimal number |
None. |
|
| C_MISC1_AMT_PAID | decimal number |
None. |
|
| C_MISC2_AMT_PAID | decimal number |
None. |
|
| C_MISC3_AMT_PAID | decimal number |
None. |
|
| C_MISC4_AMT_PAID | decimal number |
None. |
|
| C_MISC5_AMT_PAID | decimal number |
None. |
|
| C_MISC6_AMT_PAID | decimal number |
None. |
|
| C_TAX_A_AMT | decimal number |
None. |
|
| C_TAX_B_AMT | decimal number |
None. |
|
| C_TAX_C_AMT | decimal number |
None. |
|
| C_ADDITIONAL_TAX_AMT | decimal number |
None. |
|
| C_LINE_TAX_A_AMT | decimal number |
None. |
|
| C_LINE_TAX_B_AMT | decimal number |
None. |
|
| C_LINE_TAX_C_AMT | decimal number |
None. |
|
| C_HDR_TAX_A_AMT | decimal number |
None. |
|
| C_HDR_TAX_B_AMT | decimal number |
None. |
|
| C_HDR_TAX_C_AMT | decimal number |
None. |
|
| C_SUB_TAX_AMT | decimal number |
None. |
|
| C_M1_TAX_AMT | decimal number |
None. |
|
| C_M2_TAX_AMT | decimal number |
None. |
|
| C_M3_TAX_AMT | decimal number |
None. |
|
| C_M4_TAX_AMT | decimal number |
None. |
|
| C_M5_TAX_AMT | decimal number |
None. |
|
| C_M6_TAX_AMT | decimal number |
None. |
|
| BLANKET_VALUE | decimal number |
None. |
|
| C_BLANKET_VALUE | decimal number |
None. |
|
| C_DOC_TOTAL | decimal number |
None. |
|
| END_USER_STATEMENT_REQUIRED | string |
None. |
|
| IMP_EXP_ULTIMATE_DEST | integer |
None. |
|
| ULTIMATE_DEST_COUNTRY | string |
None. |
|
| RECALC_WO | string |
None. |
|
| QA_STATUS | string |
None. |
|
| SQWK_NO | string |
None. |
|
| CUST_PO | string |
None. |
|
| WH_DEF | string |
None. |
|
| LOC_DEF | string |
None. |
|
| CREDITCARD | string |
None. |
|
| CREDITCARD_NUM | string |
None. |
|
| LIC_NO | string |
None. |
|
| LIC_EXPIRES | date |
None. |
|
| LIC_VALUE | decimal number |
None. |
|
| LIC_AMENDED | date |
None. |
|
| PARTNUMBER | string |
None. |
|
| SUBP | string |
None. |
|
| LINE_TYPE | string |
None. |
|
| LSTATUS | string |
None. |
|
| SERIAL_NO | string |
None. |
|
| PART_SSN | integer |
None. |
|
| LOGNO | integer |
None. |
|
| CUST_PN | string |
None. |
|
| MFG | string |
None. |
|
| MFG_SUBC | string |
None. |
|
| QTY_INSTOCKREV | string |
None. |
|
| PART_TYPE | string |
None. |
|
| DESCRIPTN | string |
None. |
|
| CURRENT_OPR_SEQ | decimal number |
None. |
|
| WO_STATUS | string |
None. |
|
| WO_STATUS_DOC_NO | integer |
None. |
|
| INHOUSE_WO | string |
None. |
|
| PARENT_DOCTYPE | string |
None. |
|
| CONV_DOC_CATEGORY | string |
None. |
|
| CONV_DOC | integer |
None. |
|
| CONV_LN | decimal number |
None. |
|
| QORDER | decimal number |
None. |
|
| QSHIP | decimal number |
None. |
|
| QBACK | decimal number |
None. |
|
| QPROCESSED | decimal number |
None. |
|
| QRECV | decimal number |
None. |
|
| QFINISHED | decimal number |
None. |
|
| QTY_UM | string |
None. |
|
| FIXED_RATE | string |
None. |
|
| POST_WIP | string |
None. |
|
| BOM_PARTS | string |
None. |
|
| OVERHEAD_COST_DETAIL | string |
None. |
|
| RETURN_PARTS_TO_CUSTOMER | string |
None. |
|
| COPY_LABOR_ACTUAL | string |
None. |
|
| CUSTOMER_APPROVED_ON | date |
None. |
|
| PROJECT_MNGR | string |
None. |
|
| FLAT_DOC_TOTAL | decimal number |
None. |
|
| C_FLAT_DOC_TOTAL | decimal number |
None. |
|
| ACT_TIME_BUDGET | decimal number |
None. |
|
| OVER_TIME_BUDGET | decimal number |
None. |
|
| PLAN_TIME_BUDGET | decimal number |
None. |
|
| PLAN_TIME_TOTAL_BUDGET | decimal number |
None. |
|
| TOTAL_COST_BUDGET | decimal number |
None. |
|
| C_TOTAL_COST_BUDGET | decimal number |
None. |
|
| SUBTOTAL_COST | decimal number |
None. |
|
| C_SUBTOTAL_COST | decimal number |
None. |
|
| SUBTOTAL_CHARGES | decimal number |
None. |
|
| C_SUBTOTAL_CHARGES | decimal number |
None. |
|
| SUBTOTAL_CHARGES_COST | decimal number |
None. |
|
| C_SUBTOTAL_CHARGES_COST | decimal number |
None. |
|
| SUBTOTAL_CHARGES_DISC_AMT | decimal number |
None. |
|
| C_SUBTOTAL_CHARGES_DISC_AMT | decimal number |
None. |
|
| SUBTOTALNET_CHARGES | decimal number |
None. |
|
| C_SUBTOTALNET_CHARGES | decimal number |
None. |
|
| SUBTOTAL_OS_CHARGES | decimal number |
None. |
|
| C_SUBTOTAL_OS_CHARGES | decimal number |
None. |
|
| SUBTOTAL_OS_COST | decimal number |
None. |
|
| C_SUBTOTAL_OS_COST | decimal number |
None. |
|
| AIRCRAFT_DOC_NO | integer |
None. |
|
| CONTRACT_DOC_NO | integer |
None. |
|
| PRICE_CONTRACT_DOC_NO | integer |
None. |
|
| BOM_PLANNER | string |
None. |
|
| SUB_CHARGES_TAX_A | string |
None. |
|
| SUB_CHARGES_TAX_B | string |
None. |
|
| SUB_CHARGES_TAX_AMT | decimal number |
None. |
|
| C_SUB_CHARGES_TAX_AMT | decimal number |
None. |
|
| DATE_START_PLAN | date |
None. |
|
| DATE_END_PLAN | date |
None. |
|
| DATE_START_ACT | date |
None. |
|
| DATE_END_ACT | date |
None. |
|
| FIX_DATE | string |
None. |
|
| CALCULATE_TOTAL_BY | string |
None. |
|
| CHARGE_SHIP_VIA_ACCT | string |
None. |
|
| MILESTONE_DOC_NO | integer |
None. |
|
| WO_SUBTYPE | string |
None. |
|
| ROUTINE | string |
None. |
|
| SCOPE | string |
None. |
|
| FUNCTION_CODE | string |
None. |
|
| UNIT_NO | string |
None. |
|
| DEFECT_DOC_NO | integer |
None. |
|
| DEFECT_DOC_CATEGORY | string |
None. |
|
| FLIGHT_DOC_NO | integer |
None. |
|
| TASK_KIND | integer |
None. |
|
| SIGN_PART_LIMIT | decimal number |
None. |
|
| MNT_COMPANYNO | integer |
None. |
|
| MNT_DIVISION | string |
None. |
|
| MNT_DEPART | string |
None. |
|
| RECLOCK | string |
None. |
|
| ADDED_USR | string |
None. |
|
| ADDED_DTE | date |
None. |
|
| UPDATED_USR | string |
None. |
|
| UPDATED_DTE | date |
None. |