|
1
|
formCode
|
formCode |
FBillNo
|
单据编号 |
单据编号 |
|
2
|
_findCollection find F_JSJT_Text_MKBM from dac46c84-b360-329a-889f-f8bbb8cca5b1 where FName=customObject-CF561-text
|
关联查询函数 |
FSETTLEORGID
|
结算组织 |
100 |
|
3
|
paymentBaseAmount-amountStr
|
固定值 |
FPAYAMOUNTFOR_H
|
应付金额 |
|
|
4
|
submittedAt|datetime
|
固定值 |
FDATE
|
申请日期 |
|
|
5
|
FKSQ010_SYS
|
固定值 |
FBillTypeID
|
单据类型 |
单据类型 |
|
6
|
paymentBaseAmount-amountStr
|
固定值 |
FAPPLYAMOUNTFOR_H
|
申请付款金额 |
|
|
7
|
BD_Empinfo
|
固定值 |
FCONTACTUNITTYPE
|
往来单位类型 |
往来单位类型 |
|
8
|
_findCollection find FNumber from 75ccce48-a5cb-3769-b966-28b1c01593a7 where FName=fillEmployeeName
|
关联查询函数 |
FCONTACTUNIT
|
往来单位 |
往来单位 |
|
9
|
BD_Empinfo
|
固定值 |
FRECTUNITTYPE
|
收款单位类型 |
收款单位类型 |
|
10
|
customObject-CF506-0_userId
|
固定值 |
FRECTUNIT
|
收款单位 |
|
|
11
|
_findCollection find FUseOrgId_Fnumber from c2b5e68c-1b80-398b-bec8-59612f54e804 where FNumber=payerAccounts_payerBankAccount
|
关联查询函数 |
FPAYORGID
|
付款组织 |
100 |
|
12
|
items
|
固定值 |
FPAYAPPLYENTRY
|
付款申请单明细 |
|
|
13
|
_function case '_findCollection find payerAccountType from e834a036-85f9-33be-bc48-168d584a3de6 where payeeTargetBusinessCode=formCode _endFind' when '从公司支付宝账户付款' then 'JSFS32_SYS' else 'JSFS04_SYS' end
|
关联查询函数 |
FPAYAPPLYENTRY.FSETTLETYPEID
|
结算方式 |
|
|
14
|
customObject-CF199-detailBusinessCode
|
固定值 |
FPAYAPPLYENTRY.FPAYPURPOSEID
|
付款用途 |
|
|
15
|
approvedBaseAmount-amountStr
|
固定值 |
FPAYAPPLYENTRY.FAFTTAXTOTALAMOUNT
|
应付金额 |
|
|
16
|
approvedBaseAmount-amountStr
|
固定值 |
FPAYAPPLYENTRY.FAPPLYAMOUNTFOR
|
申请付款金额 |
|
|
17
|
loanName
|
固定值 |
FPAYAPPLYENTRY.FDescription
|
备注 |
|
|
18
|
_function case when 'customObject-CF199-text' in ('股东分红预支款') then '_findCollection find bizCode from 1c2d71bb-4cff-32a5-98aa-f04a13b4575f where name=customObject-CF506-0.text _endFind' else '' end
|
关联查询函数 |
FPAYAPPLYENTRY.F_JSJT_Assistant
|
股东 |
|
|
19
|
_function CASE LOCATE('其他应收款-职员借支','customObject-CF199-text') WHEN 0 THEN 'CI161' ELSE 'QTYS001' END
|
计算函数 |
FPAYAPPLYENTRY.FCOSTID
|
费用项目 |
|
|
20
|
_findCollection find F_JSJT_Text_MKBM from dac46c84-b360-329a-889f-f8bbb8cca5b1 where FNumber=customObject-CF561-detailBusinessCode
|
关联查询函数 |
FAPPLYORGID
|
申请组织 |
|
