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 TypeLength
1Extender_Voucher_ID SearchExtender Voucher IDSTR15_LBAUString15
2Extender_Voucher_Desc SearchExtender Voucher DescriptionSTR64String64
3Extender_Type SearchExtender TypeINT5Integer4
4Extender_Form_ID SearchExtender Form IDSTR15_LBAUString15
5Ext_Inv_Batch_From SearchExt_Inv_Batch_FromExtender Invoice Batch FromInteger0
6Ext_Voucher_Voucher_From SearchExt_Voucher_Voucher_FromExtender Voucher Voucher FromInteger0
7Ext_Inv_Description_From SearchExt_Inv_Description_FromExtender Invoice Description FromInteger0
8Ext_Voucher_Creditor SearchExt_Voucher_Creditor_FromExtender Voucher Creditor FromInteger0
9Ext_Voucher_Addrs_From SearchExt_Voucher_Addrs_FromExtender Voucher Address FromInteger0
10Ext_Voucher_Doc_From SearchExt_Voucher_Doc_FromExtender Voucher Document FromInteger0
11Ext_Inv_PO_From SearchExt_Inv_PO_FromExtender Invoice PO FromInteger0
12Ext_Voucher_Purch_From SearchExt_Voucher_Purch_FromExtender Voucher Purchases FromInteger0
13Ext_Voucher_Freight_From SearchExt_Voucher_Freight_FromExtender Voucher Freight FromInteger0
14Ext_Voucher_Misc_From SearchExt_Voucher_Misc_FromExtender Voucher Misc FromInteger0
15Form_Field_Number_1 SearchForm Field Number[1]INT5Integer4
16Form_Field_Number_2 SearchForm Field Number[2]INT5Integer4
17Form_Field_Number_3 SearchForm Field Number[3]INT5Integer4
18Form_Field_Number_4 SearchForm Field Number[4]INT5Integer4
19Form_Field_Number_5 SearchForm Field Number[5]INT5Integer4
20Form_Field_Number_6 SearchForm Field Number[6]INT5Integer4
21Form_Field_Number_7 SearchForm Field Number[7]INT5Integer4
22Form_Field_Number_8 SearchForm Field Number[8]INT5Integer4
23Form_Field_Number_9 SearchForm Field Number[9]INT5Integer4
24Form_Field_Number_10 SearchForm Field Number[10]INT5Integer4
25Form_Field_Number_11 SearchForm Field Number[11]INT5Integer4
26Form_Field_Number_12 SearchForm Field Number[12]INT5Integer4
27Form_Field_Number_13 SearchForm Field Number[13]INT5Integer4
28Form_Field_Number_14 SearchForm Field Number[14]INT5Integer4
29Form_Field_Number_15 SearchForm Field Number[15]INT5Integer4
30Form_Field_Number_16 SearchForm Field Number[16]INT5Integer4
31Form_Field_Number_17 SearchForm Field Number[17]INT5Integer4
32Form_Field_Number_18 SearchForm Field Number[18]INT5Integer4
33Form_Field_Number_19 SearchForm Field Number[19]INT5Integer4
34Form_Field_Number_20 SearchForm Field Number[20]INT5Integer4
35BACHNUMB SearchBatch NumberSTR15_LBAUString15
36VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
37DSCRIPTN SearchDescriptionSTR30String30
38VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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_CodeString15
40DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
41PONUMBER SearchPO NumberSTR17_POP_NumberString17
42PRCHAMNT SearchPurchases AmountDLR17_RBS0_UTR$Currency17
43FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
44Freight_Percentage SearchFreight PercentageINT5_%2Integer5
45MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
46Misc_Percentage SearchMisc PercentageINT5_%2Integer5
47Default_Distributions_CB SearchDefault Distributions CBDefault Distributions CBBoolean0
48NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
50CRUSRID SearchCreated User IDSTR15_User_IDString15
51MODIFDT SearchModified DateDTDate8
52MDFUSRID SearchModified User IDSTR15String15
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 FromInteger0
azurecurveProductsExtender (3107)ProjectExtender Vouchers (EXT41300)

Leave a Reply

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