Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT41200
Product: Extender (3107)
Series: Project
Display Name: Extender Invoices
Physical Name: EXT41200
Technical Name: PT_Extender_InvoicesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Invoice_ID 
Extender Invoice ID STR15_LBAU String 15 2 Extender_Invoice_Desc Extender Invoice Description STR64 String 64 3 Extender_Type Extender Type INT5 Integer 4 4 Extender_Form_ID Extender Form ID STR15_LBAU String 15 5 Ext_Inv_Frequency Ext_Inv_Frequency Extender Invoice Frequency Integer 0 6 Ext_Inv_Document_From Ext_Inv_Document_From Extender Invoice Document From Integer 0 7 Ext_Inv_Batch_From Ext_Inv_Batch_From Extender Invoice Batch From Integer 0 8 Ext_Inv_Description_From Ext_Inv_Description_From Extender Invoice Description From Integer 0 9 Ext_Inv_Debtor_From Ext_Inv_Debtor_From Extender Invoice Debtor From Integer 0 10 Ext_Inv_Address_From Ext_Inv_Address_From Extender Invoice Address From Integer 0 11 Ext_Inv_Salesperson_From Ext_Inv_Salesperson_From Extender Invoice Salesperson From Integer 0 12 Ext_Inv_Territory_From Ext_Inv_Territory_From Extender Invoice Territory From Integer 0 13 Ext_Inv_PO_From Ext_Inv_PO_From Extender Invoice PO From Integer 0 14 Ext_Inv_Cost_From Ext_Inv_Cost_From Extender Invoice Cost From Integer 0 15 Ext_Inv_Sales_From Ext_Inv_Sales_From Extender Invoice Sales From Integer 0 16 Ext_Inv_Freight_From Ext_Inv_Freight_From Extender Invoice Freight From Integer 0 17 Ext_Inv_Misc_From Ext_Inv_Misc_From Extender Invoice Misc From Integer 0 18 DOCNUMBR Document Number STR20_Document_Number String 20 19 BACHNUMB Batch Number STR15_LBAU String 15 20 DSCRIPTN Description STR30 String 30 21 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Extender Invoices'].CUSTNMBR AS 'Extender Invoices-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
EXT41200 AS ['Extender Invoices']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Extender Invoices'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR22 ADRSCODE Address Code STR15_Address_Code String 15 23 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['Extender Invoices'].SLPRSNID AS 'Extender Invoices-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
EXT41200 AS ['Extender Invoices']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['Extender Invoices'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID24 SALSTERR Sales Territory STR15_Sales_Territory String 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['Extender Invoices'].SALSTERR AS 'Extender Invoices-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
EXT41200 AS ['Extender Invoices']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['Extender Invoices'].SALSTERR = ['Sales Territory Master File'].SALSTERR25 PONUMBER PO Number STR17_POP_Number String 17 26 COSTAMNT Cost Amount DLR19_RBSO_UTR$ Currency 19 27 SLSAMNT Sales Amount DLR19_RBSO_UTR$ Currency 19 28 Sales_Percentage Sales Percentage INT5_%2 Integer 5 29 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 30 Freight_Percentage Freight Percentage INT5_%2 Integer 5 31 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 32 Misc_Percentage Misc Percentage INT5_%2 Integer 5 33 Maximum_Freight_Amount Maximum Freight Amount Dollar19 Currency 19 34 Maximum_Misc_Amount Maximum Misc Amount Dollar19 Currency 19 35 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Extender Invoices'].NOTEINDX AS 'Extender Invoices-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT41200 AS ['Extender Invoices']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Extender Invoices'].NOTEINDX = ['Record Notes Master'].NOTEINDX36 Minimum_Freight_Amount Minimum Freight Amount Dollar19 Currency 19 37 Minimum_Misc_Amount Minimum Misc Amount Dollar19 Currency 19 38 Form_Field_Number_1 Form Field Number[1] INT5 Integer 4 39 Form_Field_Number_2 Form Field Number[2] INT5 Integer 4 40 Form_Field_Number_3 Form Field Number[3] INT5 Integer 4 41 Form_Field_Number_4 Form Field Number[4] INT5 Integer 4 42 Form_Field_Number_5 Form Field Number[5] INT5 Integer 4 43 Form_Field_Number_6 Form Field Number[6] INT5 Integer 4 44 Form_Field_Number_7 Form Field Number[7] INT5 Integer 4 45 Form_Field_Number_8 Form Field Number[8] INT5 Integer 4 46 Form_Field_Number_9 Form Field Number[9] INT5 Integer 4 47 Form_Field_Number_10 Form Field Number[10] INT5 Integer 4 48 Form_Field_Number_11 Form Field Number[11] INT5 Integer 4 49 Form_Field_Number_12 Form Field Number[12] INT5 Integer 4 50 Form_Field_Number_13 Form Field Number[13] INT5 Integer 4 51 Form_Field_Number_14 Form Field Number[14] INT5 Integer 4 52 Form_Field_Number_15 Form Field Number[15] INT5 Integer 4 53 Form_Field_Number_16 Form Field Number[16] INT5 Integer 4 54 Form_Field_Number_17 Form Field Number[17] INT5 Integer 4 55 Form_Field_Number_18 Form Field Number[18] INT5 Integer 4 56 Form_Field_Number_19 Form Field Number[19] INT5 Integer 4 57 Form_Field_Number_20 Form Field Number[20] INT5 Integer 4 58 CREATDDT Created Date DT Date 8 59 CRUSRID Created User ID STR15_User_ID String 15 60 MODIFDT Modified Date DT Date 8 61 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Invoices'].MDFUSRID AS 'Extender Invoices-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT41200 AS ['Extender Invoices']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Invoices'].MDFUSRID = ['Users Master'].USERID62 RMDTYPAL RM Document Type-All INT2 Integer 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 Payments63 Ext_Date_From Ext_Date_From Extender Date From Integer 0