Null ATTRIBUTE12,
Null ATTRIBUTE13,
Null ATTRIBUTE14,
Null ATTRIBUTE15,
OEH.context HEADER_ATTRIBUTE_CATEGORY, ---订单主题弹性域上下文
SUBSTRB(OEH.attribute1,1,150) HEADER_ATTRIBUTE1, --对订单主题弹性域attribute1
SUBSTRB(OEH.attribute2,1,150) HEADER_ATTRIBUTE2,
SUBSTRB(OEH.attribute3,1,150) HEADER_ATTRIBUTE3,
SUBSTRB(OEH.attribute4,1,150) HEADER_ATTRIBUTE4,
SUBSTRB(OEH.attribute5,1,150) HEADER_ATTRIBUTE5,
SUBSTRB(OEH.attribute6,1,150) HEADER_ATTRIBUTE6,
SUBSTRB(OEH.attribute7,1,150) HEADER_ATTRIBUTE7,
SUBSTRB(OEH.attribute8,1,150) HEADER_ATTRIBUTE8,
SUBSTRB(OEH.attribute9,1,150) HEADER_ATTRIBUTE9,
SUBSTRB(OEH.attribute10,1,150) HEADER_ATTRIBUTE10,
SUBSTRB(OEH.attribute11,1,150) HEADER_ATTRIBUTE11,
SUBSTRB(OEH.attribute12,1,150) HEADER_ATTRIBUTE12,
SUBSTRB(OEH.attribute13,1,150) HEADER_ATTRIBUTE13,
SUBSTRB(OEH.attribute14,1,150) HEADER_ATTRIBUTE14,
SUBSTRB(OEH.attribute15,1,150) HEADER_ATTRIBUTE15,
Null COMMENTS,
Null INTERNAL_NOTES,
Null INITIAL_CUSTOMER_TRX_ID,
Null USSGL_TRANSACTION_CODE_CONTEXT,
Null USSGL_TRANSACTION_CODE,
Null ACCTD_AMOUNT,
Null CUSTOMER_BANK_ACCOUNT_ID,
Null CUSTOMER_BANK_ACCOUNT_NAME,
WDV.requested_quantity_uom UOM_CODE, --发运单位代码
Null UOM_NAME,
Null DOCUMENT_NUMBER_SEQUENCE_ID,
Null LINK_TO_LINE_ATTRIBUTE10,
Null LINK_TO_LINE_ATTRIBUTE11,
Null LINK_TO_LINE_ATTRIBUTE12,
Null LINK_TO_LINE_ATTRIBUTE13,
Null LINK_TO_LINE_ATTRIBUTE14,
Null LINK_TO_LINE_ATTRIBUTE15,
Null LINK_TO_LINE_ATTRIBUTE8,
Null LINK_TO_LINE_ATTRIBUTE9,
Null REFERENCE_LINE_ATTRIBUTE10,
Null REFERENCE_LINE_ATTRIBUTE11,
Null REFERENCE_LINE_ATTRIBUTE13,
Null REFERENCE_LINE_ATTRIBUTE14,
Null REFERENCE_LINE_ATTRIBUTE15,
Null REFERENCE_LINE_ATTRIBUTE8,
Null REFERENCE_LINE_ATTRIBUTE9,
WDV.organization_id INTERFACE_LINE_ATTRIBUTE10, --发运库存组织ID
0 INTERFACE_LINE_ATTRIBUTE11, ---------
1 INTERFACE_LINE_ATTRIBUTE12, ---------
0 INTERFACE_LINE_ATTRIBUTE13, ---------
0 INTERFACE_LINE_ATTRIBUTE14, ---------
Null INTERFACE_LINE_ATTRIBUTE15,
(Case
When OEL.ORDERED_ITEM = MSI.SEGMENT1 Then
'0'
Else
OEL.ORDERED_ITEM
End) INTERFACE_LINE_ATTRIBUTE9, ----
Null VAT_TAX_ID,
Null REASON_CODE_MEANING,
Null LAST_PERIOD_TO_CREDIT,
Null PAYING_CUSTOMER_ID,
Null PAYING_SITE_USE_ID,
'S' TAX_EXEMPT_FLAG, ---------
Null TAX_EXEMPT_REASON_CODE,
Null TAX_EXEMPT_REASON_CODE_MEANING,
Null TAX_EXEMPT_NUMBER,
Null SALES_TAX_ID,
0 CREATED_BY,
SYSDATE CREATION_DATE,
0 LAST_UPDATED_BY,
SYSDATE LAST_UPDATE_DATE,
0 LAST_UPDATE_LOGIN,
Null LOCATION_SEGMENT_ID,
Null MOVEMENT_ID,
OEH.org_id ORG_ID, ---OU
Null AMOUNT_INCLUDES_TAX_FLAG,
Null HEADER_GDF_ATTR_CATEGORY,
Null HEADER_GDF_ATTRIBUTE1,
Null HEADER_GDF_ATTRIBUTE2,
Null HEADER_GDF_ATTRIBUTE3,
N