FnaVoucherObjInitSAP.properties
11.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
#SAP凭证配置开始********************************************************************************************************************************
#凭证头信息设置
SAPvoucherInfoV1={"voucherInfo":[\
{"fieldDbName":"uid","fieldName":"账户","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"root_attr","detailTable":"0","fieldDbType":"string","memo":"SAP的账户，如：administrator","isLockDefType":"yes"},\
{"fieldDbName":"pwd","fieldName":"密码","fieldValue":"","fieldValueType1":"9","fieldValueType2":"ipt","fieldDbTbName":"root_attr","detailTable":"0","fieldDbType":"string","memo":"SAP的密码，如：88888888","isLockDefType":"yes"},\
{"fieldDbName":"OriginalReferenceDocumentType","fieldName":"会计凭证","fieldValue":"BKPFF","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"固定值:BKPFF "},\
{"fieldDbName":"OriginalReferenceDocument","fieldName":"外部系统编号","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"OriginalReferenceDocumentLogicalSystem","fieldName":"外部系统","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"BusinessTransactionType","fieldName":"RFBU","fieldValue":"RFBU","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"固定值:RFBU"},\
{"fieldDbName":"AccountingDocumentType","fieldName":"DZorSA","fieldValue":"SA","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"固定值:SA"},\
{"fieldDbName":"DocumentHeaderText","fieldName":"日记账头名称","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"CreatedByUser","fieldName":"创建人","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"CompanyCode","fieldName":"公司代码","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"DocumentDate","fieldName":"日记账日期","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"dateTime","memo":"必填项"},\
{"fieldDbName":"PostingDate","fieldName":"过账日期","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"dateTime","memo":"必填项"},\
{"fieldDbName":"DocumentReferenceID","fieldName":"员工号-员工姓名","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"JournalEntry","detailTable":"0","fieldDbType":"string","memo":"必填项"},\
]}
#凭证借方信息设置1
SAPvoucherDebitInfoV1={"voucherInfo":[\
{"fieldDbName":"GLAccount","fieldName":"科目","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"Debtor","fieldName":"客户","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"DebitCreditCode","fieldName":"借贷方向","fieldValue":"S","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"string","memo":"S借方，H贷方"},\
{"fieldDbName":"AmountInTransactionCurrency","fieldName":"以交易货币计的金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"AmountInCompanyCodeCurrency","fieldName":"集团货币金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"DocumentItemText","fieldName":"费用报销+报销事由+OA报销单号","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"AssignmentReference","fieldName":"员工号-员工姓名","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"ValueDate","fieldName":"起息日","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"1","fieldDbType":"dateTime","memo":"必填项"},\
{"fieldDbName":"TaxCode","fieldName":"税码","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Tax","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"CostCenter","fieldName":"成本中心","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"AccountAssignment","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"WBSElement","fieldName":"项目编码","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"AccountAssignment","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"Segment","fieldName":"细分","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"AccountAssignment","detailTable":"1","fieldDbType":"string","memo":"必填项"},\
]}
#凭证贷方信息设置1
SAPvoucherCreditInfoV1={"voucherInfo":[\
{"fieldDbName":"GLAccount","fieldName":"科目","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"Debtor","fieldName":"客户","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"DebitCreditCode","fieldName":"借贷方向","fieldValue":"H","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"string","memo":"S借方，H贷方"},\
{"fieldDbName":"AmountInTransactionCurrency","fieldName":"以交易货币计的金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"AmountInCompanyCodeCurrency","fieldName":"集团货币金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"DocumentItemText","fieldName":"费用报销+报销事由+OA报销单号","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"AssignmentReference","fieldName":"员工号-员工姓名","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"ValueDate","fieldName":"起息日","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"Item","detailTable":"2","fieldDbType":"dateTime","memo":"必填项"},\
]}
#凭证贷方信息2（冲销借款）
SAPvoucherCreditInfoV2={"voucherInfo":[\
{"fieldDbName":"ReferenceDocumentItem","fieldName":"ReferenceDocumentItem","fieldValue":"1","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"string","memo":"固定值:1"},\
{"fieldDbName":"Debtor","fieldName":"客户","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"AmountInTransactionCurrency","fieldName":"以交易货币计的金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"AmountInCompanyCodeCurrency","fieldName":"集团货币金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"DebitCreditCode","fieldName":"借贷方向","fieldValue":"H","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"string","memo":"S借方，H贷方"},\
{"fieldDbName":"DocumentItemText","fieldName":"费用报销+报销事由+OA报销单号","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"AssignmentReference","fieldName":"员工号-员工姓名","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"DebtorItem","detailTable":"3","fieldDbType":"string","memo":"必填项"},\
]}
#凭证税信息设置1
SAPvoucherTaxInfoV1={"voucherInfo":[\
{"fieldDbName":"TaxCode","fieldName":"税码","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"TaxItemClassification","fieldName":"税分类","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"AmountInTransactionCurrency","fieldName":"以交易货币计的金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"AmountInCompanyCodeCurrency","fieldName":"集团货币金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"DebitCreditCode","fieldName":"借贷方向","fieldValue":"S","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"string","memo":"S借方，H贷方"},\
{"fieldDbName":"TaxBaseAmountInTransCrcy","fieldName":"以交易货币计的金额-计税基数","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"TaxBaseAmountInCoCodeCrcy","fieldName":"集团货币金额-计税基数","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"ProductTaxItem","detailTable":"4","fieldDbType":"float","memo":"必填项"},\
]}
#凭证供应商信息
SAPvoucherSupplierInfoV1={"voucherInfo":[\
{"fieldDbName":"ReferenceDocumentItem","fieldName":"ReferenceDocumentItem","fieldValue":"1","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"CreditorItem","detailTable":"5","fieldDbType":"string","memo":"固定值:1"},\
{"fieldDbName":"Creditor","fieldName":"供应商","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"CreditorItem","detailTable":"5","fieldDbType":"string","memo":"必填项"},\
{"fieldDbName":"AmountInTransactionCurrency","fieldName":"以交易货币计的金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"CreditorItem","detailTable":"5","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"AmountInCompanyCodeCurrency","fieldName":"集团货币金额","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"CreditorItem","detailTable":"5","fieldDbType":"float","memo":"必填项"},\
{"fieldDbName":"DebitCreditCode","fieldName":"借贷方向","fieldValue":"S","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"CreditorItem","detailTable":"5","fieldDbType":"string","memo":"S借方，H贷方"},\
{"fieldDbName":"DocumentItemText","fieldName":"材料款支付+OA单据号","fieldValue":"","fieldValueType1":"3","fieldValueType2":"ipt","fieldDbTbName":"CreditorItem","detailTable":"5","fieldDbType":"string","memo":"必填项"},\
]}
#SAP凭证配置开始********************************************************************************************************************************