Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICJC9000
Product: Manufacturing (346)
Series:
Display Name: ICJC RM Sales Work Group Display Name: Manufacturing Job Costing
Physical Name: ICJC9000
Technical Name: ICJC_RM_Sales_WORK
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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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/hideSELECT
['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 |