CIS Payment WORK Virtual 2007 (CIS1031V)

azurecurveProductsMIS-AMS Extensions (3459)PurchasingCIS Payment WORK Virtual 2007 (CIS1031V)

Easily find this page again using the shortlink:

Product: MIS-AMS Extensions (3459)
Series: Purchasing

Display Name: CIS Payment WORK Virtual 2007
Physical Name: CIS1031V
Technical Name: CIS_Payment_Work_2007_V

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BCHSOURC SearchBatch SourceSTR15String15
2BACHNUMB SearchBatch NumberSTR15_LBAUString15
3PMNTNMBR SearchPayment NumberSTR20_LBAUString20
4APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency17
5CHEKTOTL SearchCheck TotalDLR19_RBS0_UTR$Currency19
6CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
Key to the CM Checkbook Master (CM00100).

Click to show/hide

       ['CIS Payment WORK Virtual 2007'].CHEKBKID AS 'CIS Payment WORK Virtual 2007-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
       CIS1031V AS ['CIS Payment WORK Virtual 2007']
       CM00100 AS ['CM Checkbook Master']
                     ['CIS Payment WORK Virtual 2007'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
7COMMENT1 SearchComment1STR30String30
8CNTRLTYP SearchControl TypeINT1Integer1
9CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

       ['CIS Payment WORK Virtual 2007'].CURNCYID AS 'CIS Payment WORK Virtual 2007-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
       CIS1031V AS ['CIS Payment WORK Virtual 2007']
       DYNAMICS..MC40200 AS ['Currency Setup']
                     ['CIS Payment WORK Virtual 2007'].CURNCYID = ['Currency Setup'].CURNCYID
10CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency17
11DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
12DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
13DOCDATE SearchDocument DateDTDate8
14DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
15DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0

Click to show/hide Document Types

1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
16Electronic SearchElectronicCB_ElectronicBoolean0
17KEYFIELD SearchKey FieldSTR20String20
18Net_Paid_Amount SearchNet Paid AmountDLR19_RBS0_UTR$Currency19
19Outstanding_Amount SearchOutstanding AmountDLR19_RBS0_UTR$Currency19
20PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer0
21PMWRKMSG SearchPM WORK MessagesML_PM_WORK_MessagesLong Integer0
22PMWRKMS2 SearchPM WORK Messages 2ML_PM_WORK_Messages_2Long Integer0
23POSTEDDT SearchPosted DateDATEDate6
24PSTGDATE SearchPosting DateDTDate8
25TotAmtPaid SearchTotal Amount PaidDLR19_RBS0_UTR$Currency19
26TotCrdAmt SearchTotal Credit AmountDLR19_RBS0_UTR$Currency19
27TotCrdDocAmt SearchTotal Credit Document AmountDLR19_RBS0_UTR$Currency19
28TotDiscTknAmt SearchTotal Discount Taken AmountDLR19_RBS0_UTR$Currency19
29TotDiscTknTot SearchTotal Discount Taken TotalDLR19_RBS0_UTR$Currency19
30TotDocAmt SearchTotal Document AmountDLR19_RBS0_STR$Currency19
31TotalPaidTot SearchTotal Paid TotalDLR19_RBS0_UTR$Currency19
32TotTotDocAmt SearchTotal Total Document AmountDLR19_RBS0_UTR$Currency19
33TotWOAmt SearchTotal Write Off AmountDLR19_RBS0_UTR$Currency19
34TotWOTot SearchTotal Write Off TotalDLR19_RBS0_UTR$Currency19
35VNDCHKNM SearchVendor Check NameSTR64_Vendor_NameString64
36VENDORID SearchVendor IDSTR_15_Vendor_IDString15
Key to the PM Vendor Master File (PM00200).

Click to show/hide

       ['CIS Payment WORK Virtual 2007'].VENDORID AS 'CIS Payment WORK Virtual 2007-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
       CIS1031V AS ['CIS Payment WORK Virtual 2007']
       PM00200 AS ['PM Vendor Master File']
                     ['CIS Payment WORK Virtual 2007'].VENDORID = ['PM Vendor Master File'].VENDORID
37VENDNAME SearchVendor NameSTR64_Vendor_NameString64
38VOIDED SearchVoidedCBBoolean0
39VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
Partial key to the PM Key Master File (PM00400).

Click to show/hide

       ['CIS Payment WORK Virtual 2007'].VCHRNMBR AS 'CIS Payment WORK Virtual 2007-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
       CIS1031V AS ['CIS Payment WORK Virtual 2007']
       PM00400 AS ['PM Key Master File']
                     ['CIS Payment WORK Virtual 2007'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
                     ['CIS Payment WORK Virtual 2007'].DOCTYPE = ['PM Key Master File'].DOCTYPE
40WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency17
41CISDEDUCT SearchCIS DeductedDLR17_RBS0_STR$Currency17
42DEDUCTERR SearchCIS Deduction ErrorSTR255String255
43CISNONTAX SearchCIS Non-taxable AmountDLR17_RBS0_UTR$Currency17
44CISTAXABLE SearchCIS Taxable AmountDLR17_RBSO_STR$Currency17
45CISVCHRNUM SearchCIS Voucher NumberSTR20_LBAUString20
46CISVerificationStatus SearchCISVerificationStatusDDL_CIS_Verification_StatusInteger0
azurecurveProductsMIS-AMS Extensions (3459)PurchasingCIS Payment WORK Virtual 2007 (CIS1031V)

Leave a Reply

Your email address will not be published. Required fields are marked *