Extender Invoices (EXT41200)

azurecurveProductsExtender (3107)ProjectExtender Invoices (EXT41200)

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_Invoices

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Invoice_ID SearchExtender Invoice IDSTR15_LBAUString1615
2Extender_Invoice_Desc SearchExtender Invoice DescriptionSTR64String6664
3Extender_Type SearchExtender TypeINT5Integer24
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
5Ext_Inv_Frequency SearchExt_Inv_FrequencyExtender Invoice FrequencyInteger20
6Ext_Inv_Document_From SearchExt_Inv_Document_FromExtender Invoice Document FromInteger20
7Ext_Inv_Batch_From SearchExt_Inv_Batch_FromExtender Invoice Batch FromInteger20
8Ext_Inv_Description_From SearchExt_Inv_Description_FromExtender Invoice Description FromInteger20
9Ext_Inv_Debtor_From SearchExt_Inv_Debtor_FromExtender Invoice Debtor FromInteger20
10Ext_Inv_Address_From SearchExt_Inv_Address_FromExtender Invoice Address FromInteger20
11Ext_Inv_Salesperson_From SearchExt_Inv_Salesperson_FromExtender Invoice Salesperson FromInteger20
12Ext_Inv_Territory_From SearchExt_Inv_Territory_FromExtender Invoice Territory FromInteger20
13Ext_Inv_PO_From SearchExt_Inv_PO_FromExtender Invoice PO FromInteger20
14Ext_Inv_Cost_From SearchExt_Inv_Cost_FromExtender Invoice Cost FromInteger20
15Ext_Inv_Sales_From SearchExt_Inv_Sales_FromExtender Invoice Sales FromInteger20
16Ext_Inv_Freight_From SearchExt_Inv_Freight_FromExtender Invoice Freight FromInteger20
17Ext_Inv_Misc_From SearchExt_Inv_Misc_FromExtender Invoice Misc FromInteger20
18DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
19BACHNUMB SearchBatch NumberSTR15_LBAUString1615
20DSCRIPTN SearchDescriptionSTR30String3230
21CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
22ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
23SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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'].SLPRSNID
24SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
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'].SALSTERR
25PONUMBER SearchPO NumberSTR17_POP_NumberString1817
26COSTAMNT SearchCost AmountDLR19_RBSO_UTR$Currency1019
27SLSAMNT SearchSales AmountDLR19_RBSO_UTR$Currency1019
28Sales_Percentage SearchSales PercentageINT5_%2Integer25
29FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
30Freight_Percentage SearchFreight PercentageINT5_%2Integer25
31MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
32Misc_Percentage SearchMisc PercentageINT5_%2Integer25
33Maximum_Freight_Amount SearchMaximum Freight AmountDollar19Currency1019
34Maximum_Misc_Amount SearchMaximum Misc AmountDollar19Currency1019
35NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
36Minimum_Freight_Amount SearchMinimum Freight AmountDollar19Currency1019
37Minimum_Misc_Amount SearchMinimum Misc AmountDollar19Currency1019
38Form_Field_Number_1 SearchForm Field Number[1]INT5Integer24
39Form_Field_Number_2 SearchForm Field Number[2]INT5Integer24
40Form_Field_Number_3 SearchForm Field Number[3]INT5Integer24
41Form_Field_Number_4 SearchForm Field Number[4]INT5Integer24
42Form_Field_Number_5 SearchForm Field Number[5]INT5Integer24
43Form_Field_Number_6 SearchForm Field Number[6]INT5Integer24
44Form_Field_Number_7 SearchForm Field Number[7]INT5Integer24
45Form_Field_Number_8 SearchForm Field Number[8]INT5Integer24
46Form_Field_Number_9 SearchForm Field Number[9]INT5Integer24
47Form_Field_Number_10 SearchForm Field Number[10]INT5Integer24
48Form_Field_Number_11 SearchForm Field Number[11]INT5Integer24
49Form_Field_Number_12 SearchForm Field Number[12]INT5Integer24
50Form_Field_Number_13 SearchForm Field Number[13]INT5Integer24
51Form_Field_Number_14 SearchForm Field Number[14]INT5Integer24
52Form_Field_Number_15 SearchForm Field Number[15]INT5Integer24
53Form_Field_Number_16 SearchForm Field Number[16]INT5Integer24
54Form_Field_Number_17 SearchForm Field Number[17]INT5Integer24
55Form_Field_Number_18 SearchForm Field Number[18]INT5Integer24
56Form_Field_Number_19 SearchForm Field Number[19]INT5Integer24
57Form_Field_Number_20 SearchForm Field Number[20]INT5Integer24
58CREATDDT SearchCreated DateDTDate48
59CRUSRID SearchCreated User IDSTR15_User_IDString1615
60MODIFDT SearchModified DateDTDate48
61MDFUSRID SearchModified User IDSTR15String1615
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'].USERID
62RMDTYPAL SearchRM Document Type-AllINT2Integer22
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
63Ext_Date_From SearchExt_Date_FromExtender Date FromInteger20
azurecurveProductsExtender (3107)ProjectExtender Invoices (EXT41200)

Leave a Reply

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