Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JCRFP100
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC RFP Transaction WORK File
Physical Name: JCRFP100
Technical Name: JC_RFP_Transaction_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 BCHSOURC Batch Source STR15 String 15 3 VCHNUMWK Voucher Number - WORK STR17_LBAU String 17 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].VENDORID AS 'JC RFP Transaction WORK File-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['JC RFP Transaction WORK File'].VENDORID = ['PM Vendor Master File'].VENDORID5 DOCNUMBR Document Number STR20_Document_Number String 20 6 DOCTYPE Document Type DDL_Document_Type Integer 0 7 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].SOURCDOC AS 'JC RFP Transaction WORK File-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['JC RFP Transaction WORK File'].SOURCDOC = ['Source Document Master'].SOURCDOC8 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 9 DOCDATE Document Date DT Date 8 10 PSTGDATE Posting Date DT Date 8 11 VADDCDPR Vendor Address Code - Primary STR15_Address_Code String 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].VADDCDPR AS 'JC RFP Transaction WORK File-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['JC RFP Transaction WORK File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['JC RFP Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID12 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].PYMTRMID AS 'JC RFP Transaction WORK File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['JC RFP Transaction WORK File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID13 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].TAXSCHID AS 'JC RFP Transaction WORK File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['JC RFP Transaction WORK File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID14 DUEDATE Due Date DT Date 8 15 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 16 DISCDATE Discount Date DT Date 8 17 PRCHAMNT Purchases Amount DLR17_RBS0_UTR$ Currency 17 18 CHRGAMNT Charge Amount DLR19_RBSO_UTR$ Currency 19 19 CASHAMNT Cash Amount DLR19_RBS0_UTR$ Currency 19 20 CAMCBKID Cash Amount Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].CAMCBKID AS 'JC RFP Transaction WORK File-Cash Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['JC RFP Transaction WORK File'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID21 CDOCNMBR Cash Document Number STR20_Document_Number String 20 22 CAMTDATE Cash Amount Date DT Date 8 23 CAMPMTNM Cash Amount Payment Number STR20_LBAU String 20 24 CHEKAMNT Check Amount DLR19_RBS0_UTR$ Currency 19 25 CHAMCBID Check Amount Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].CHAMCBID AS 'JC RFP Transaction WORK File-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['JC RFP Transaction WORK File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID26 CHEKDATE Check Date DATE Date 6 27 CAMPYNBR Check Amount Payment Number STR20_LBAU String 20 28 CRCRDAMT Credit Card Amount DLR19_RBS0_UTR$ Currency 19 29 CCAMPYNM Credit Card Amount Payment Number STR20_LBAU String 20 30 CHEKNMBR Check Number STR20_Document_Number String 20 31 CARDNAME Card Name STR15_Card_Name String 15 32 CCRCTNUM Credit Card Receipt Number STR20_Document_Number String 20 33 CRCARDDT Credit Card Date DATE Date 6 34 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].CURNCYID AS 'JC RFP Transaction WORK File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['JC RFP Transaction WORK File'].CURNCYID = ['Currency Setup'].CURNCYID35 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].CHEKBKID AS 'JC RFP Transaction WORK File-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['JC RFP Transaction WORK File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID36 TRXDSCRN Transaction Description STR30 String 30 37 UN1099AM Unapplied 1099 Amount DLR17_RBS0_UTR$ Currency 17 38 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 39 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 40 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 41 TEN99AMNT 1099 Amount DLR17_RBS0_UTR$ Currency 17 42 MSCCHAMT Misc Charges Amount DLR17_RBS0_UTR$ Currency 17 43 PORDNMBR Purchase Order Number Purchase Order Number String 20 44 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].SHIPMTHD AS 'JC RFP Transaction WORK File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['JC RFP Transaction WORK File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD45 DISAMTAV Discount Amount Available DLR17_RBS0_UTR$ Currency 17 46 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 47 APDSTKAM Applied Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 48 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 49 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 50 TXENGCLD Tax Engine Called YN Boolean 0 51 PMWRKMSG PM WORK Messages ML_PM_WORK_Messages Long Integer 0 52 PMDSTMSG PM Distribution Messages ML_PM_Distribution_Messages Long Integer 0 53 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 54 PGRAMSBJ Percent Of Gross Amount Subject INT5_RBS2_U% Integer 5 55 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 56 PPSTAXRT PPS Tax Rate INT5_%2 Integer 5 57 PSTGSTUS Posting Status INT Integer 0 58 POSTED Posted True/False Boolean 0 59 APPLDAMT Applied Amount DLR17_RBS0_STR$ Currency 17 60 VCHRNMBR Voucher Number STR20_LBAU String 20 61 CNTRLTYP Control Type INT1 Integer 1 62 MODIFDT Modified Date DT Date 8 63 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].MDFUSRID AS 'JC RFP Transaction WORK File-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC RFP Transaction WORK File'].MDFUSRID = ['Users Master'].USERID64 POSTEDDT Posted Date DATE Date 6 65 PTDUSRID Posted User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].PTDUSRID AS 'JC RFP Transaction WORK File-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC RFP Transaction WORK File'].PTDUSRID = ['Users Master'].USERID66 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].NOTEINDX AS 'JC RFP Transaction WORK File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['JC RFP Transaction WORK File'].NOTEINDX = ['Record Notes Master'].NOTEINDX67 BKTFRTAM Backout Freight Amount DLR19_RBS0_UTR$ Currency 19 68 BKTMSCAM Backout Misc Amount DLR19_RBS0_UTR$ Currency 19 69 BKTPURAM Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 70 PCHSCHID Purchase Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].PCHSCHID AS 'JC RFP Transaction WORK File-Purchase Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['JC RFP Transaction WORK File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID71 FRTSCHID Freight Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].FRTSCHID AS 'JC RFP Transaction WORK File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['JC RFP Transaction WORK File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID72 MSCSCHID Misc Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['JC RFP Transaction WORK File'].MSCSCHID AS 'JC RFP Transaction WORK File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
JCRFP100 AS ['JC RFP Transaction WORK File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['JC RFP Transaction WORK File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID73 PRINTED Printed CB Boolean 0 Click to show/hide Printed flag
0 Record has not been printed.
1 Record has been printed.74 PRCTDISC Percent Discount INT5_%2 Integer 5 75 RETNAGAM Retainage Amount DLR17_RBS0_UTR$ Currency 17 76 ICTRX IC TRX CB_IC_TRX Boolean 0 Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany77 ICDISTS ICDists Boolean Boolean 0 Click to show/hide Intercompany distirubtions
0 Not intercompany.
1 Intercompany distributions present.78 PMICMSGS ICMessages ML_IC_Post_Messages Long Integer 0 Error messages from posting an Intercompany Transaction.
Click to show/hide Intercompany posting error messages
1 The currency ID is missing.
2 A destination company does not have access to this currency ID.
3 The currency ID is inactive for a destination company.
4 A rate type ID is missing for a destination company.
5 Rate type ID is not associated with the currency ID for a destination
company.
6 An exchange table ID is missing for a destination company.
7 A destination company does not have access to an exchange table ID.
8 An exchange table ID is inactive for a destination company.
9 An exchange rate does not exist for a destination company.
10 An exchange rate has expired for a destination company.
11 Cannot post intercompany multicurrency transactions to a recurring batch.
12 A rounding account missing for a destination company.
13 A distribution type is invalid for a destination company distribution.
14 A destination company distribution contains MDA information.
15 A destination company ID does not exist; please select another company ID.
16 The user does not have access to a destination company.
17 A destination company does not have a functional currency set up.
18 Destination functional currency doesn't match originating functional currency.
19 No relationship exists between originating company and a destination company.
20 Due To / Due From account not specified.
21 The rounding account does not exist for the originating company.
22 Unknown SQL error occurred.
23 Intrastat information is missing or invalid.
24 The goods value for Intrastat exceeds the document total.
25 Transaction has successfully posted.79 Tax_Date Tax Date DT Date 8 80 PRCHDATE Purchase Date DT Date 8 81 CORRCTN Correction CB_Correction Boolean 0 82 SIMPLIFD Simplified CB_Simplified Boolean 0 83 CORRNXST Correction to Nonexisting Transaction Boolean Boolean 0 84 VCHRNCOR Voucher Number Corrected STR20_LBAU String 20 85 PMWRKMS2 PM WORK Messages 2 ML_PM_WORK_Messages_2 Long Integer 0 86 BNKRCAMT Bank Receipts Amount DLR17_RBS0_STR$ Currency 17 87 APLYWITH Apply Withholding Boolean Boolean 0 88 Electronic Electronic CB_Electronic Boolean 0 89 ECTRX EC Transaction CB_EC_Transaction Boolean 0 The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction.90 DocPrinted DocPrinted CB_DocPrinted Boolean 0 Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed.91 TaxInvReqd Tax Invoice Required CB_Tax_Invoice_Required Boolean 0 92 BackoutTradeDisc Backout Trade Discount Amount DLR19_RBS0_UTR$ Currency 19 93 CIS_Amount CIS Amount DLR11_$S2 Currency 14 94 CITB_Amount CITB Amount DLR11_$S2 Currency 14 95 Originating_CIS_Amount Originating CIS Amount DLR17_RBS0_STR$ Currency 17 96 Originating_CITB_Amount Originating CITB Amount DLR17_RBS0_STR$ Currency 17 97 Retention_Amount Retention Amount DLR14_TS Currency 14 98 Originating_Retention_Am Originating Retention Amount DLR14_TS Currency 14 99 HOLD Hold CB_Hold Boolean 0 100 RetainageDocument RetainageDocument Boolean Boolean 0 101 ORIG_VOUCHER_NUM Original Voucher Number STR20_LBAU String 20 102 Posted_To_WIP Posted To WIP Boolean Boolean 0 103 CIS_Certificate_Type CIS Certificate Type DDL Integer 0 104 JCCIS_Payment_Status JCCIS Payment Status INT Integer 0 105 Subcontractor_Type Subcontractor Type DDL Integer 0