OE模块常用表结构so_headers_all；so_lines_all；表名:ONT.OE_order_headers_all说明:订单头HEADER_IDORG_IDORDER_TYPE_IDORDER_NUMBERORDERED_DATEREQUEST_DATEDEMAND_CLASS_CODEPRICE_LIST_IDTRANSACTIONAL_CURR_CODECUST_PO_NUMBERINVOICING_RULE_IDACCOUNTING_RULE_IDPAYMENT_TERM_IDSHIPPING_METHOD_CODEFOB_POINT_CODEFREIGHT_TERMS_CODESHIP_FROM_ORG_IDSHIP_TO_ORG_IDINVOICE_TO_ORG_IDSOLD_TO_CONTACT_IDSHIP_TO_CONTACT_IDINVOICE_TO_CONTACT_IDCREATION_DATECREATED_BYLAST_UPDATED_BYLAST_UPDATE_DATELAST_UPDATE_LOGINATTRIBUTE1ATTRIBUTE2ATTRIBUTE3ATTRIBUTE11ATTRIBUTE12ATTRIBUTE13ATTRIBUTE14CANCELLED_FLAGOPEN_FLAGBOOKED_FLAGSALESREP_IDRETURN_REASON_CODESALES_CHANNEL_CODEORDER_CATEGORY_CODESHIPPING_INSTRUCTIONSPACKING_INSTRUCTIONSFLOW_STATUS_CODEBOOKED_DATE表名:ONT.OE_order_lines_all说明:订单行LINE_IDORG_IDHEADER_IDLINE_TYPE_IDLINE_NUMBERORDERED_ITEMREQUEST_DATEPROMISE_DATESCHEDULE_SHIP_DATEORDER_QUANTITY_UOMCANCELLED_QUANTITYSHIPPED_QUANTITYORDERED_QUANTITYSHIPPING_QUANTITY_UOMDELIVERY_LEAD_TIMESHIP_FROM_ORG_IDSHIP_TO_ORG_IDINVOICE_TO_ORG_IDSHIP_TO_CONTACT_IDINVOICE_TO_CONTACT_IDSOLD_TO_ORG_IDCUST_PO_NUMBERINVENTORY_ITEM_IDINVOICE_INTERFACE_STATUS_CODEDEMAND_CLASS_CODESHIPPED_NUMBERPRICE_LIST_IDSHIPPING_METHOD_CODEFREIGHT_TERMS_CODEFOB_POINT_CODEPAYMENT_TERM_IDINVOICING_RULE_IDACCOUNTING_RULE_IDITEM_REVISIONUNIT_SELLING_PRICEUNIT_LIST_PRICECONTEXTATTRIBUTE1ATTRIBUTE2ATTRIBUTE3ATTRIBUTE4ATTRIBUTE5ATTRIBUTE6ATTRIBUTE7ATTRIBUTE8ATTRIBUTE9ATTRIBUTE10ATTRIBUTE11ATTRIBUTE12ATTRIBUTE13ATTRIBUTE14CREATION_DATECREATED_BYLAST_UPDATE_DATELAST_UPDATED_BYLAST_UPDATE_LOGINTOP_MODEL_LINE_IDLINK_TO_LINE_IDITEM_TYPE_CODEVISIBLE_DEMAND_FLAGLINE_CATEGORY_CODEATO_LINE_IDSCHEDULE_ARRIVAL_DATESCHEDULE_STATUS_CODECANCELLED_FLAGOPEN_FLAGBOOKED_FLAGSALESREP_IDRETURN_REASON_CODEORDERED_ITEM_IDSHIPPING_INTERFACED_FLAGFULFILLED_FLAGINVOICED_QUANTITYSHIPPABLE_FLAGFLOW_STATUS_CODESUBINVENTORYTAX_VALUE表名:oe_transaction_types_tl以及oe_transaction_types_all说明:订单类别表oe_transaction_ty pes_tlTRANSACTION_TYPE_IDLANGUAGE...
VIP
