|
1
|
formCode
|
单据号 |
FBillNo
|
单据编号 |
单据编号 |
|
2
|
_findCollection find F_JSJT_Text_MKBM from dac46c84-b360-329a-889f-f8bbb8cca5b1 where FNumber=customObject-YJBM-detailBusinessCode
|
关联查询函数 |
FSETTLEORGID
|
结算组织 |
100 |
|
3
|
expenseList_allocationList_approvedBaseAmount-amountStr
|
固定值 |
FPAYAMOUNTFOR_H
|
应付金额 |
|
|
4
|
customObject-CF565-endTime|datetime
|
固定值 |
FDATE
|
申请日期 |
|
|
5
|
FKSQ011_SYS
|
固定值 |
FBillTypeID
|
单据类型 |
单据类型 |
|
6
|
baseAmount-amountStr
|
固定值 |
FAPPLYAMOUNTFOR_H
|
申请付款金额 |
|
|
7
|
BD_Customer
|
固定值 |
FCONTACTUNITTYPE
|
往来单位类型 |
往来单位类型 |
|
8
|
tradingPartnerBizCode
|
往来单位code |
FCONTACTUNIT
|
往来单位 |
往来单位 |
|
9
|
BD_Customer
|
固定值 |
FRECTUNITTYPE
|
收款单位类型 |
收款单位类型 |
|
10
|
tradingPartnerBizCode
|
往来单位code |
FRECTUNIT
|
收款单位 |
|
|
11
|
_findCollection find F_JSJT_Text_MKBM from dac46c84-b360-329a-889f-f8bbb8cca5b1 where FNumber=customObject-YJBM-detailBusinessCode
|
关联查询函数 |
FPAYORGID
|
付款组织 |
100 |
|
12
|
_findCollection find F_JSJT_Text_MKBM from dac46c84-b360-329a-889f-f8bbb8cca5b1 where FNumber=customObject-YJBM-detailBusinessCode
|
关联查询函数 |
FAPPLYORGID
|
申请组织 |
|
|
13
|
items
|
固定值 |
FPAYAPPLYENTRY
|
付款申请单明细 |
|
|
14
|
expenseList_viceExpenseTypeBizCode
|
固定值 |
FPAYAPPLYENTRY.FCOSTID
|
费用项目 |
|
|
15
|
expenseList_allocationList_approvedBaseAmount-amountStr
|
固定值 |
FPAYAPPLYENTRY.FAPPLYAMOUNTFOR
|
申请付款金额 |
|
|
16
|
expenseList_allocationList_approvedBaseAmount-amountStr
|
固定值 |
FPAYAPPLYENTRY.FAFTTAXTOTALAMOUNT
|
应付金额 |
|
|
17
|
SFKYT018
|
固定值 |
FPAYAPPLYENTRY.FPAYPURPOSEID
|
付款用途 |
|
|
18
|
approvedAt|datetime
|
固定值 |
FPAYAPPLYENTRY.FEXPIRY
|
到期日 |
|
|
19
|
approvedAt|datetime
|
固定值 |
FPAYAPPLYENTRY.FEXPECTPAYDATE
|
期望付款日期 |
|
|
20
|
expenseList_comments
|
固定值 |
FPAYAPPLYENTRY.FDescription
|
备注 |
|
|
21
|
_findCollection find F_JSJT_Text_MKBM from dac46c84-b360-329a-889f-f8bbb8cca5b1 where FNumber=items.expenseList_allocationList_customObject_detailBusinessCode
|
关联查询函数 |
FPAYAPPLYENTRY.F_JSJT_Base_FYCDZZ
|
费用承担组织 |
|
|
22
|
expenseList_allocationList_customObject_CF367_detailBusinessCode
|
固定值 |
FPAYAPPLYENTRY.FEXPENSEDEPTID
|
费用承担部门 |
|
|
23
|
_function case when 'items.expenseList_viceExpenseTypeBizCode' in ('CI099','CI097') then 'items.tradingPartnerBizCode' else 'items.expenseList_allocationList_customObject_CF327_detailBusinessCode' end
|
计算函数 |
FPAYAPPLYENTRY.F_JSJT_Base_FKKH
|
费用承担客户 |
|
|
24
|
|
固定值 |
FPAYAPPLYENTRY.F_JSJT_Base_CK
|
仓库 |
|
|
25
|
expenseList_customObject_CF462_CF466_detailBusinessCode
|
固定值 |
FPAYAPPLYENTRY.F_JSJT_Assistant
|
股东 |
|
|
26
|
expenseList_customObject_CF557_CF559_detailBusinessCode
|
固定值 |
FPAYAPPLYENTRY.F_JSJT_Assistant1
|
投资项目 |
|
|
27
|
_findCollection find FNumber from 359e10ac-9ab3-3388-86d0-3fb422cf95d7 where FDataValue=items.expenseList_customObject_CF369_detailBusinessCode
|
关联查询函数 |
FPAYAPPLYENTRY.F_JSJT_Assistant2
|
公司 |
|
|
28
|
items.expenseList_customObjectCFFF
|
固定值 |
FPAYAPPLYENTRY.F_JSJT_FDBL
|
返点比率 |
|
