PM Transaction WORK File (ICJC9001)

azurecurve Products Manufacturing (346)3rd PartyPM Transaction WORK File (ICJC9001)

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

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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BACHNUMB	Batch Number	String	STR15_LBAU	15
2	BCHSOURC	Batch Source	String	STR15	15
3	VCHNUMWK	Voucher Number - WORK	String	STR17_LBAU	17
4	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	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
5	DOCNUMBR	Document Number	String	STR20_Document_Number	20
6	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
7	SOURCDOC	Source Document	String	STR10_Source_Document	10
	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
8	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
9	DOCDATE	Document Date	Date	DT	8
10	PSTGDATE	Posting Date	Date	DT	8
11	VADDCDPR	Vendor Address Code - Primary	String	STR15_Address_Code	15
	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
12	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	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
13	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	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
14	DUEDATE	Due Date	Date	DT	8
15	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
16	DISCDATE	Discount Date	Date	DT	8
17	PRCHAMNT	Purchases Amount	Currency	DLR17_RBS0_UTR$	17
18	CHRGAMNT	Charge Amount	Currency	DLR19_RBSO_UTR$	19
19	CASHAMNT	Cash Amount	Currency	DLR19_RBS0_UTR$	19
20	CAMCBKID	Cash Amount Checkbook ID	String	STR15_Checkbook_ID	15
	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
21	CDOCNMBR	Cash Document Number	String	STR20_Document_Number	20
22	CAMTDATE	Cash Amount Date	Date	DT	8
23	CAMPMTNM	Cash Amount Payment Number	String	STR20_LBAU	20
24	CHEKAMNT	Check Amount	Currency	DLR19_RBS0_UTR$	19
25	CHAMCBID	Check Amount Checkbook ID	String	STR15_Checkbook_ID	15
	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
26	CHEKDATE	Check Date	Date	DATE	6
27	CAMPYNBR	Check Amount Payment Number	String	STR20_LBAU	20
28	CRCRDAMT	Credit Card Amount	Currency	DLR19_RBS0_UTR$	19
29	CCAMPYNM	Credit Card Amount Payment Number	String	STR20_LBAU	20
30	CHEKNMBR	Check Number	String	STR20_Document_Number	20
31	CARDNAME	Card Name	String	STR15_Card_Name	15
32	CCRCTNUM	Credit Card Receipt Number	String	STR20_Document_Number	20
33	CRCARDDT	Credit Card Date	Date	DATE	6
34	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	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
35	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	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
36	TRXDSCRN	Transaction Description	String	STR30	30
37	UN1099AM	Unapplied 1099 Amount	Currency	DLR17_RBS0_UTR$	17
38	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
39	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
40	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
41	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
42	MSCCHAMT	Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
43	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
44	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	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
45	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
46	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
47	APDSTKAM	Applied Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
48	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
49	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
50	TXENGCLD	Tax Engine Called	Boolean	YN	0
51	PMWRKMSG	PM WORK Messages	Long Integer	ML_PM_WORK_Messages	0
52	PMDSTMSG	PM Distribution Messages	Long Integer	ML_PM_Distribution_Messages	0
53	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
54	PGRAMSBJ	Percent Of Gross Amount Subject	Integer	INT5_RBS2_U%	5
55	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
56	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
57	POSTED	Posted	Boolean	True/False	0
58	APPLDAMT	Applied Amount	Currency	DLR17_RBS0_STR$	17
59	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
60	CNTRLTYP	Control Type	Integer	INT1	1
61	MODIFDT	Modified Date	Date	DT	8
62	MDFUSRID	Modified User ID	String	STR15	15
	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
63	POSTEDDT	Posted Date	Date	DATE	6
64	PTDUSRID	Posted User ID	String	STR15	15
	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
65	NOTEINDX	Note Index	Currency	DLR14	14
	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
66	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
67	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
68	BKTPURAM	Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
69	PCHSCHID	Purchase Schedule ID	String	STR15_LBAU	15
	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
70	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	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
71	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	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
72	PRINTED	Printed	Boolean	CB	0
	Click to show/hide Printed flag 0 Record has not been printed. 1 Record has been printed.
73	PRCTDISC	Percent Discount	Integer	INT5_%2	5
74	RETNAGAM	Retainage Amount	Currency	DLR17_RBS0_UTR$	17

azurecurve Products Manufacturing (346)3rd PartyPM Transaction WORK File (ICJC9001)

Leave a Reply Cancel reply