PM Transaction WORK File (ICJC9001)

azurecurveProductsManufacturing (346)3rd PartyPM Transaction WORK File (ICJC9001)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICJC9001

Product: Manufacturing (346)
Series: 3rd Party

Display Name: PM Transaction WORK File
Physical Name: ICJC9001
Technical Name: ICJC_PM_Transaction_WORK

Group Display Name: Manufacturing Job Costing
Group Technical Name: Manufacturing Job Costing

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
       ['PM Transaction WORK File'].VENDORID AS 'PM Transaction WORK File-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].SOURCDOC AS 'PM Transaction WORK File-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].VADDCDPR AS 'PM Transaction WORK File-Vendor Address Code - Primary'
       ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       PM00300 AS ['PM Address MSTR']
              ON
                     ['PM Transaction WORK File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
              AND
                     ['PM 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
       ['PM Transaction WORK File'].PYMTRMID AS 'PM Transaction WORK File-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].TAXSCHID AS 'PM Transaction WORK File-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].CAMCBKID AS 'PM Transaction WORK File-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].CHAMCBID AS 'PM Transaction WORK File-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].CURNCYID AS 'PM Transaction WORK File-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PM Transaction WORK File'].CURNCYID = ['Currency Setup'].CURNCYID
35CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].CHEKBKID AS 'PM Transaction WORK File-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PM 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
       ['PM Transaction WORK File'].SHIPMTHD AS 'PM Transaction WORK File-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PM 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
57POSTED SearchPostedTrue/FalseBoolean20
58APPLDAMT SearchApplied AmountDLR17_RBS0_STR$Currency1017
59VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
60CNTRLTYP SearchControl TypeINT1Integer21
61MODIFDT SearchModified DateDTDate48
62MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].MDFUSRID AS 'PM Transaction WORK File-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Transaction WORK File'].MDFUSRID = ['Users Master'].USERID
63POSTEDDT SearchPosted DateDATEDate46
64PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].PTDUSRID AS 'PM Transaction WORK File-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PM Transaction WORK File'].PTDUSRID = ['Users Master'].USERID
65NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].NOTEINDX AS 'PM Transaction WORK File-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PM Transaction WORK File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
66BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
67BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
68BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
69PCHSCHID SearchPurchase Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].PCHSCHID AS 'PM Transaction WORK File-Purchase Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
70FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].FRTSCHID AS 'PM Transaction WORK File-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
71MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PM Transaction WORK File'].MSCSCHID AS 'PM Transaction WORK File-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ICJC9001 AS ['PM Transaction WORK File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PM Transaction WORK File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72PRINTED SearchPrintedCBBoolean20

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
73PRCTDISC SearchPercent DiscountINT5_%2Integer25
74RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
75DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyPM Transaction WORK File (ICJC9001)

Leave a Reply

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