Extender Vouchers (EXT41300)

azurecurveProductsExtender (3107)ProjectExtender Vouchers (EXT41300)

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

Product: Extender (3107)
Series: Project

Display Name: Extender Vouchers
Physical Name: EXT41300
Technical Name: PT_Extender_Vouchers

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Voucher_ID SearchExtender Voucher IDSTR15_LBAUString1615
2Extender_Voucher_Desc SearchExtender Voucher DescriptionSTR64String6664
3Extender_Type SearchExtender TypeINT5Integer24
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString1615
5Ext_Inv_Batch_From SearchExt_Inv_Batch_FromExtender Invoice Batch FromInteger20
6Ext_Voucher_Voucher_From SearchExt_Voucher_Voucher_FromExtender Voucher Voucher FromInteger20
7Ext_Inv_Description_From SearchExt_Inv_Description_FromExtender Invoice Description FromInteger20
8Ext_Voucher_Creditor SearchExt_Voucher_Creditor_FromExtender Voucher Creditor FromInteger20
9Ext_Voucher_Addrs_From SearchExt_Voucher_Addrs_FromExtender Voucher Address FromInteger20
10Ext_Voucher_Doc_From SearchExt_Voucher_Doc_FromExtender Voucher Document FromInteger20
11Ext_Inv_PO_From SearchExt_Inv_PO_FromExtender Invoice PO FromInteger20
12Ext_Voucher_Purch_From SearchExt_Voucher_Purch_FromExtender Voucher Purchases FromInteger20
13Ext_Voucher_Freight_From SearchExt_Voucher_Freight_FromExtender Voucher Freight FromInteger20
14Ext_Voucher_Misc_From SearchExt_Voucher_Misc_FromExtender Voucher Misc FromInteger20
15Form_Field_Number_1 SearchForm Field Number[1]INT5Integer24
16Form_Field_Number_2 SearchForm Field Number[2]INT5Integer24
17Form_Field_Number_3 SearchForm Field Number[3]INT5Integer24
18Form_Field_Number_4 SearchForm Field Number[4]INT5Integer24
19Form_Field_Number_5 SearchForm Field Number[5]INT5Integer24
20Form_Field_Number_6 SearchForm Field Number[6]INT5Integer24
21Form_Field_Number_7 SearchForm Field Number[7]INT5Integer24
22Form_Field_Number_8 SearchForm Field Number[8]INT5Integer24
23Form_Field_Number_9 SearchForm Field Number[9]INT5Integer24
24Form_Field_Number_10 SearchForm Field Number[10]INT5Integer24
25Form_Field_Number_11 SearchForm Field Number[11]INT5Integer24
26Form_Field_Number_12 SearchForm Field Number[12]INT5Integer24
27Form_Field_Number_13 SearchForm Field Number[13]INT5Integer24
28Form_Field_Number_14 SearchForm Field Number[14]INT5Integer24
29Form_Field_Number_15 SearchForm Field Number[15]INT5Integer24
30Form_Field_Number_16 SearchForm Field Number[16]INT5Integer24
31Form_Field_Number_17 SearchForm Field Number[17]INT5Integer24
32Form_Field_Number_18 SearchForm Field Number[18]INT5Integer24
33Form_Field_Number_19 SearchForm Field Number[19]INT5Integer24
34Form_Field_Number_20 SearchForm Field Number[20]INT5Integer24
35BACHNUMB SearchBatch NumberSTR15_LBAUString1615
36VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
37DSCRIPTN SearchDescriptionSTR30String3230
38VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['Extender Vouchers'].VENDORID AS 'Extender Vouchers-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       EXT41300 AS ['Extender Vouchers']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['Extender Vouchers'].VENDORID = ['PM Vendor Master File'].VENDORID
39ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
40DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
41PONUMBER SearchPO NumberSTR17_POP_NumberString1817
42PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency1017
43FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
44Freight_Percentage SearchFreight PercentageINT5_%2Integer25
45MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
46Misc_Percentage SearchMisc PercentageINT5_%2Integer25
47Default_Distributions_CB SearchDefault Distributions CBDefault Distributions CBBoolean20
48NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Extender Vouchers'].NOTEINDX AS 'Extender Vouchers-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       EXT41300 AS ['Extender Vouchers']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Extender Vouchers'].NOTEINDX = ['Record Notes Master'].NOTEINDX
49CREATDDT SearchCreated DateDTDate48
50CRUSRID SearchCreated User IDSTR15_User_IDString1615
51MODIFDT SearchModified DateDTDate48
52MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Extender Vouchers'].MDFUSRID AS 'Extender Vouchers-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       EXT41300 AS ['Extender Vouchers']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extender Vouchers'].MDFUSRID = ['Users Master'].USERID
53Ext_Date_From SearchExt_Date_FromExtender Date FromInteger20
azurecurveProductsExtender (3107)ProjectExtender Vouchers (EXT41300)

Leave a Reply

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