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:

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 TypeLength
1BACHNUMB SearchBatch NumberStringSTR15_LBAU15
2BCHSOURC SearchBatch SourceStringSTR1515
3VCHNUMWK SearchVoucher Number - WORKStringSTR17_LBAU17
4VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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 NumberStringSTR20_Document_Number20
6DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
7SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
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 AmountCurrencyDLR19_RBSO_UTR$19
9DOCDATE SearchDocument DateDateDT8
10PSTGDATE SearchPosting DateDateDT8
11VADDCDPR SearchVendor Address Code - PrimaryStringSTR15_Address_Code15
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 IDStringSTR20_Payment_Terms_ID20
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 IDStringSTR15_Tax_Schedule_ID15
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 DateDateDT8
15DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
16DISCDATE SearchDiscount DateDateDT8
17PRCHAMNT SearchPurchases AmountCurrencyDLR17_RBS0_UTR$17
18CHRGAMNT SearchCharge AmountCurrencyDLR19_RBSO_UTR$19
19CASHAMNT SearchCash AmountCurrencyDLR19_RBS0_UTR$19
20CAMCBKID SearchCash Amount Checkbook IDStringSTR15_Checkbook_ID15
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 NumberStringSTR20_Document_Number20
22CAMTDATE SearchCash Amount DateDateDT8
23CAMPMTNM SearchCash Amount Payment NumberStringSTR20_LBAU20
24CHEKAMNT SearchCheck AmountCurrencyDLR19_RBS0_UTR$19
25CHAMCBID SearchCheck Amount Checkbook IDStringSTR15_Checkbook_ID15
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 DateDateDATE6
27CAMPYNBR SearchCheck Amount Payment NumberStringSTR20_LBAU20
28CRCRDAMT SearchCredit Card AmountCurrencyDLR19_RBS0_UTR$19
29CCAMPYNM SearchCredit Card Amount Payment NumberStringSTR20_LBAU20
30CHEKNMBR SearchCheck NumberStringSTR20_Document_Number20
31CARDNAME SearchCard NameStringSTR15_Card_Name15
32CCRCTNUM SearchCredit Card Receipt NumberStringSTR20_Document_Number20
33CRCARDDT SearchCredit Card DateDateDATE6
34CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 IDStringSTR15_Checkbook_ID15
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 DescriptionStringSTR3030
37UN1099AM SearchUnapplied 1099 AmountCurrencyDLR17_RBS0_UTR$17
38TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
39TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
40FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
41TEN99AMNT Search1099 AmountCurrencyDLR17_RBS0_UTR$17
42MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
43PORDNMBR SearchPurchase Order NumberStringPurchase Order Number20
44SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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 AvailableCurrencyDLR17_RBS0_UTR$17
46DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
47APDSTKAM SearchApplied Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
48WROFAMNT SearchWrite Off AmountCurrencyDLR17_RBS0_STR$17
49CURTRXAM SearchCurrent Trx AmountCurrencyDLR17_RBS0_UTR$17
50TXENGCLD SearchTax Engine CalledBooleanYN0
51PMWRKMSG SearchPM WORK MessagesLong IntegerML_PM_WORK_Messages0
52PMDSTMSG SearchPM Distribution MessagesLong IntegerML_PM_Distribution_Messages0
53GSTDSAMT SearchGST Discount AmountCurrencyDLR17_RBS0_STR$17
54PGRAMSBJ SearchPercent Of Gross Amount SubjectIntegerINT5_RBS2_U%5
55PPSAMDED SearchPPS Amount DeductedCurrencyDLR17_RBS0_UTR$17
56PPSTAXRT SearchPPS Tax RateIntegerINT5_%25
57POSTED SearchPostedBooleanTrue/False0
58APPLDAMT SearchApplied AmountCurrencyDLR17_RBS0_STR$17
59VCHRNMBR SearchVoucher NumberStringSTR20_LBAU20
60CNTRLTYP SearchControl TypeIntegerINT11
61MODIFDT SearchModified DateDateDT8
62MDFUSRID SearchModified User IDStringSTR1515
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 DateDateDATE6
64PTDUSRID SearchPosted User IDStringSTR1515
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 IndexCurrencyDLR1414
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 AmountCurrencyDLR19_RBS0_UTR$19
67BKTMSCAM SearchBackout Misc AmountCurrencyDLR19_RBS0_UTR$19
68BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
69PCHSCHID SearchPurchase Schedule IDStringSTR15_LBAU15
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 IDStringSTR15_LBAU15
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 IDStringSTR15_LBAU15
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 SearchPrintedBooleanCB0

Click to show/hide Printed flag


0	Record has not been printed.
1	Record has been printed.
73PRCTDISC SearchPercent DiscountIntegerINT5_%25
74RETNAGAM SearchRetainage AmountCurrencyDLR17_RBS0_UTR$17
azurecurveProductsManufacturing (346)3rd PartyPM Transaction WORK File (ICJC9001)

Leave a Reply

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