```sql
--销售单据表头常用基础资料（客户、销售员、销售部门）字段关联方式
--销售订单
SELECT
SO.FBILLNO 单据编号,
CU.FNUMBER 客户编码,CUL.FNAME 客户名称,
OPE.FNUMBER 销售员编码,OPEL.FNAME 销售员名称,
DE.FNUMBER 销售部门编码,DEL.FNAME 销售部门名称
FROM
T_SAL_ORDER SO
LEFT JOIN T_BD_CUSTOMER CU ON SO.FCUSTID = CU.FCUSTID --客户关联T_BD_CUSTOMER.FCUSTID
LEFT JOIN T_BD_CUSTOMER_L CUL ON CU.FCUSTID = CUL.FCUSTID AND CUL.FLOCALEID = 2052
LEFT JOIN T_BD_OPERATORENTRY OPE ON SO.FSALERID = OPE.FENTRYID --销售员关联T_BD_OPERATORENTRY.FENTRYID
LEFT JOIN T_BD_OPERATORENTRY_L OPEL ON OPE.FENTRYID = OPEL.FENTRYID AND OPEL.FLOCALEID = 2052
LEFT JOIN T_BD_DEPARTMENT DE ON SO.FSALEDEPTID = DE.FDEPTID --销售部门关联T_BD_DEPARTMENT.FDEPTID
LEFT JOIN T_BD_DEPARTMENT_L DEL ON DE.FDEPTID = DEL.FDEPTID AND DEL.FLOCALEID = 2052
WHERE 1=1
AND SO.FBILLNO = 'TEST' --录入订单号
--销售出库单
SELECT
SO.FBILLNO 单据编号,
CU.FNUMBER 客户编码,CUL.FNAME 客户名称,
OPE.FNUMBER 销售员编码,OPEL.FNAME 销售员名称,
DE.FNUMBER 销售部门编码,DEL.FNAME 销售部门名称
FROM
T_SAL_OUTSTOCK SO
LEFT JOIN T_BD_CUSTOMER CU ON SO.FCUSTOMERID = CU.FCUSTID --客户关联T_BD_CUSTOMER.FCUSTID
LEFT JOIN T_BD_CUSTOMER_L CUL ON CU.FCUSTID = CUL.FCUSTID AND CUL.FLOCALEID = 2052
LEFT JOIN T_BD_OPERATORENTRY OPE ON SO.FSALESMANID = OPE.FENTRYID --销售员关联T_BD_OPERATORENTRY.FENTRYID
LEFT JOIN T_BD_OPERATORENTRY_L OPEL ON OPE.FENTRYID = OPEL.FENTRYID AND OPEL.FLOCALEID = 2052
LEFT JOIN T_BD_DEPARTMENT DE ON SO.FSALEDEPTID = DE.FDEPTID --销售部门关联T_BD_DEPARTMENT.FDEPTID
LEFT JOIN T_BD_DEPARTMENT_L DEL ON DE.FDEPTID = DEL.FDEPTID AND DEL.FLOCALEID = 2052
WHERE 1=1
AND SO.FBILLNO = 'TEST' --录入出库单号
--发货通知单
SELECT
SO.FBILLNO 单据编号,
CU.FNUMBER 客户编码,CUL.FNAME 客户名称,
OPE.FNUMBER 销售员编码,OPEL.FNAME 销售员名称,
DE.FNUMBER 销售部门编码,DEL.FNAME 销售部门名称
FROM
T_SAL_DELIVERYNOTICE SO
LEFT JOIN T_BD_CUSTOMER CU ON SO.FCUSTOMERID = CU.FCUSTID --客户关联T_BD_CUSTOMER.FCUSTID
LEFT JOIN T_BD_CUSTOMER_L CUL ON CU.FCUSTID = CUL.FCUSTID AND CUL.FLOCALEID = 2052
LEFT JOIN T_BD_OPERATORENTRY OPE ON SO.FSALESMANID = OPE.FENTRYID --销售员关联T_BD_OPERATORENTRY.FENTRYID
LEFT JOIN T_BD_OPERATORENTRY_L OPEL ON OPE.FENTRYID = OPEL.FENTRYID AND OPEL.FLOCALEID = 2052
LEFT JOIN T_BD_DEPARTMENT DE ON SO.FSALEDEPTID = DE.FDEPTID --销售部门关联T_BD_DEPARTMENT.FDEPTID
LEFT JOIN T_BD_DEPARTMENT_L DEL ON DE.FDEPTID = DEL.FDEPTID AND DEL.FLOCALEID = 2052
WHERE 1=1
AND SO.FBILLNO = 'TEST' --录入发货通知单号
```
