ICJC RM Sales Work (ICJC9000)

azurecurve Products Manufacturing (346)3rd PartyICJC RM Sales Work (ICJC9000)

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

Display Name: ICJC RM Sales Work
Physical Name: ICJC9000
Technical Name: ICJC_RM_Sales_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	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
2	RMDTYPAL	RM Document Type-All	Integer	INT2	2
	Document Type records the type of document. Click to show/hide the Document Types 0 Balance Carried Forward 1 Sales / Invoice 2 Scheduled Payments 3 Debit Memo 4 Finance Charge 5 Service Repairs 6 Warranties 7 Credit Memo 8 Returns 9 Payments
3	RMDNUMWK	RM Document Number-WORK	String	STR17_LBAU	17
4	DOCNUMBR	Document Number	String	STR20_Document_Number	20
5	DOCPRFIX	Document Prefix	String	STR3	3
6	DOCDESCR	Document Description	String	STR30	30
7	DOCDATE	Document Date	Date	DT	8
8	BACHNUMB	Batch Number	String	STR15_LBAU	15
9	BCHSOURC	Batch Source	String	STR15	15
10	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['ICJC RM Sales Work'].NOTEINDX AS 'ICJC RM Sales Work-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['ICJC RM Sales Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
11	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['ICJC RM Sales Work'].CUSTNMBR AS 'ICJC RM Sales Work-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['ICJC RM Sales Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
12	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
13	ADRSCODE	Address Code	String	STR15_Address_Code	15
14	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['ICJC RM Sales Work'].SLPRSNID AS 'ICJC RM Sales Work-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['ICJC RM Sales Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
15	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['ICJC RM Sales Work'].SALSTERR AS 'ICJC RM Sales Work-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['ICJC RM Sales Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR
16	COMAPPTO	Commission Applied To	Integer	GB	0
17	COMDLRAM	Commission Dollar Amount	Currency	DLR17_RBSO_STR$	17
18	NCOMAMNT	Non-Commissioned Amount	Currency	DLR19_RBS0_STR$	19
19	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['ICJC RM Sales Work'].SHIPMTHD AS 'ICJC RM Sales Work-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['ICJC RM Sales Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
20	CSTPONBR	Customer PO Number	String	STR20_Document_Number	20
21	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 ['ICJC RM Sales Work'].TAXSCHID AS 'ICJC RM Sales Work-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['ICJC RM Sales Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
22	SLSCHDID	Sales Schedule ID	String	STR15_LBU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['ICJC RM Sales Work'].SLSCHDID AS 'ICJC RM Sales Work-Sales Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['ICJC RM Sales Work'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
23	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['ICJC RM Sales Work'].FRTSCHID AS 'ICJC RM Sales Work-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['ICJC RM Sales Work'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
24	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['ICJC RM Sales Work'].MSCSCHID AS 'ICJC RM Sales Work-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['ICJC RM Sales Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
25	COSTAMNT	Cost Amount	Currency	DLR19_RBSO_UTR$	19
26	SLSAMNT	Sales Amount	Currency	DLR19_RBSO_UTR$	19
27	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
28	TRDDISCT	Trade Discount	Integer	INT4_%2	4
29	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
30	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
31	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
32	BKTSLSAM	Backout Sales Amount	Currency	DLR19_RBS0_UTR$	19
33	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
34	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
35	TXENGCLD	Tax Engine Called	Boolean	YN	0
36	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
37	APPLDAMT	Applied Amount	Currency	DLR17_RBS0_STR$	17
38	CASHAMNT	Cash Amount	Currency	DLR19_RBS0_UTR$	19
39	CBKIDCSH	Checkbook ID Cash	String	STR15_Checkbook_ID	15
40	CASHDATE	Cash Date	Date	DATE	6
41	DCNUMCSH	Document Number Cash	String	STR20_Document_Number	20
42	CHEKAMNT	Check Amount	Currency	DLR19_RBS0_UTR$	19
43	CBKIDCHK	Checkbook ID Check	String	STR15_Checkbook_ID	15
44	CBKIDCRD	Checkbook ID Credit Card	String	STR15_Checkbook_ID	15
45	CHEKNMBR	Check Number	String	STR20_Document_Number	20
46	CHEKDATE	Check Date	Date	DATE	6
47	DCNUMCHK	Document Number Check	String	STR20_Document_Number	20
48	CRCRDAMT	Credit Card Amount	Currency	DLR19_RBS0_UTR$	19
49	CRCRDNAM	Credit Card Name	String	STR15	15
50	RCTNCCRD	Receipt Number Credit Card	String	STR20_Document_Number	20
51	CRCARDDT	Credit Card Date	Date	DATE	6
52	DCNUMCRD	Document Number Credit Card	String	STR20_Document_Number	20
53	DISCRTND	Discount Returned	Currency	DLR17_RBS0_STR$	17
54	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
55	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
56	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
57	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
58	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
59	ACCTAMNT	Account Amount	Currency	DLR19_RBS0_UTR$	19
60	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['ICJC RM Sales Work'].PYMTRMID AS 'ICJC RM Sales Work-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['ICJC RM Sales Work'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
61	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
62	DISCDATE	Discount Date	Date	DT	8
63	DUEDATE	Due Date	Date	DT	8
64	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
65	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
66	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['ICJC RM Sales Work'].CURNCYID AS 'ICJC RM Sales Work-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['ICJC RM Sales Work'].CURNCYID = ['Currency Setup'].CURNCYID
67	POSTED	Posted	Boolean	True/False	0
68	LSTEDTDT	Last Edit Date	Date	DT_Date	6
69	LSTUSRED	Last User to Edit	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ICJC RM Sales Work'].LSTUSRED AS 'ICJC RM Sales Work-Last User to Edit' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ICJC RM Sales Work'].LSTUSRED = ['Users Master'].USERID
70	RMTREMSG	RM TRX Posting Error Messages	Long Integer	RM_TRX_Posting_Error_Messages	0
71	RMDPEMSG	RM Dist Posting Error Messages	Long Integer	RM_Dist_Posting_Error_Messages	0
72	GLPOSTDT	GL Posting Date	Date	DT	8
73	POSTEDDT	Posted Date	Date	DATE	6
74	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ICJC RM Sales Work'].PTDUSRID AS 'ICJC RM Sales Work-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ICJC9000 AS ['ICJC RM Sales Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ICJC RM Sales Work'].PTDUSRID = ['Users Master'].USERID

azurecurve Products Manufacturing (346)3rd PartyICJC RM Sales Work (ICJC9000)

Leave a Reply Cancel reply