JC RFP Transaction WORK File (JCRFP100)

azurecurveProductsWennSoft Products (131)3rd PartyJC RFP Transaction WORK File (JCRFP100)

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_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BACHNUMB SearchBatch NumberSTR15_LBAUString1615
2BCHSOURC SearchBatch SourceSTR15String1615
3VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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'].VENDORID
5DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
6DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
7SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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'].SOURCDOC
8DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
9DOCDATE SearchDocument DateDTDate48
10PSTGDATE SearchPosting DateDTDate48
11VADDCDPR SearchVendor Address Code - PrimarySTR15_Address_CodeString1615
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'].VENDORID
12PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
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'].PYMTRMID
13TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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'].TAXSCHID
14DUEDATE SearchDue DateDTDate48
15DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
16DISCDATE SearchDiscount DateDTDate48
17PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency1017
18CHRGAMNT SearchCharge AmountDLR19_RBSO_UTR$Currency1019
19CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency1019
20CAMCBKID SearchCash Amount Checkbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
21CDOCNMBR SearchCash Document NumberSTR20_Document_NumberString2220
22CAMTDATE SearchCash Amount DateDTDate48
23CAMPMTNM SearchCash Amount Payment NumberSTR20_LBAUString2220
24CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019
25CHAMCBID SearchCheck Amount Checkbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
26CHEKDATE SearchCheck DateDATEDate46
27CAMPYNBR SearchCheck Amount Payment NumberSTR20_LBAUString2220
28CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency1019
29CCAMPYNM SearchCredit Card Amount Payment NumberSTR20_LBAUString2220
30CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
31CARDNAME SearchCard NameSTR15_Card_NameString1615
32CCRCTNUM SearchCredit Card Receipt NumberSTR20_Document_NumberString2220
33CRCARDDT SearchCredit Card DateDATEDate46
34CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
35CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
36TRXDSCRN SearchTransaction DescriptionSTR30String3230
37UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency1017
38TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
39TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
40FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
41TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
42MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
43PORDNMBR SearchPurchase Order NumberPurchase Order NumberString2220
44SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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'].SHIPMTHD
45DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
46DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
47APDSTKAM SearchApplied Discount Taken AmountDLR17_RBS0_UTR$Currency1017
48WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
49CURTRXAM SearchCurrent Trx AmountDLR17_RBS0_UTR$Currency1017
50TXENGCLD SearchTax Engine CalledYNBoolean20
51PMWRKMSG SearchPM WORK MessagesML_PM_WORK_MessagesLong Integer40
52PMDSTMSG SearchPM Distribution MessagesML_PM_Distribution_MessagesLong Integer40
53GSTDSAMT SearchGST Discount AmountDLR17_RBS0_STR$Currency1017
54PGRAMSBJ SearchPercent Of Gross Amount SubjectINT5_RBS2_U%Integer25
55PPSAMDED SearchPPS Amount DeductedDLR17_RBS0_UTR$Currency1017
56PPSTAXRT SearchPPS Tax RateINT5_%2Integer25
57PSTGSTUS SearchPosting StatusINTInteger20
58POSTED SearchPostedTrue/FalseBoolean20
59APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
60VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
61CNTRLTYP SearchControl TypeINT1Integer21
62MODIFDT SearchModified DateDTDate48
63MDFUSRID SearchModified User IDSTR15String1615
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'].USERID
64POSTEDDT SearchPosted DateDATEDate46
65PTDUSRID SearchPosted User IDSTR15String1615
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'].USERID
66NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
67BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
68BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
69BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
70PCHSCHID SearchPurchase Schedule IDSTR15_LBAUString1615
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'].TAXSCHID
71FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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'].TAXSCHID
72MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
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'].TAXSCHID
73PRINTED SearchPrintedCBBoolean20

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
74PRCTDISC SearchPercent DiscountINT5_%2Integer25
75RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
76ICTRX SearchIC TRXCB_IC_TRXBoolean20

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
77ICDISTS SearchICDistsBooleanBoolean20

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
78PMICMSGS SearchICMessagesML_IC_Post_MessagesLong Integer40
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.
79Tax_Date SearchTax DateDTDate48
80PRCHDATE SearchPurchase DateDTDate48
81CORRCTN SearchCorrectionCB_CorrectionBoolean20
82SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
83CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean20
84VCHRNCOR SearchVoucher Number CorrectedSTR20_LBAUString2220
85PMWRKMS2 SearchPM WORK Messages 2ML_PM_WORK_Messages_2Long Integer40
86BNKRCAMT SearchBank Receipts AmountDLR17_RBS0_STR$Currency1017
87APLYWITH SearchApply WithholdingBooleanBoolean20
88Electronic SearchElectronicCB_ElectronicBoolean20
89ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
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.
90DocPrinted SearchDocPrintedCB_DocPrintedBoolean20

Click to show/hide Document Printed flag


0	Record has not been printed.
1	Record has been printed.
91TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
92BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
93CIS_Amount SearchCIS AmountDLR11_$S2Currency1014
94CITB_Amount SearchCITB AmountDLR11_$S2Currency1014
95Originating_CIS_Amount SearchOriginating CIS AmountDLR17_RBS0_STR$Currency1017
96Originating_CITB_Amount SearchOriginating CITB AmountDLR17_RBS0_STR$Currency1017
97Retention_Amount SearchRetention AmountDLR14_TSCurrency1014
98Originating_Retention_Am SearchOriginating Retention AmountDLR14_TSCurrency1014
99HOLD SearchHoldCB_HoldBoolean20
100RetainageDocument SearchRetainageDocumentBooleanBoolean20
101ORIG_VOUCHER_NUM SearchOriginal Voucher NumberSTR20_LBAUString2220
102Posted_To_WIP SearchPosted To WIPBooleanBoolean20
103CIS_Certificate_Type SearchCIS Certificate TypeDDLInteger20
104JCCIS_Payment_Status SearchJCCIS Payment StatusINTInteger20
105Subcontractor_Type SearchSubcontractor TypeDDLInteger20
azurecurveProductsWennSoft Products (131)3rd PartyJC RFP Transaction WORK File (JCRFP100)

Leave a Reply

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