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_VouchersSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Voucher_ID 
Extender Voucher ID STR15_LBAU String 15 2 Extender_Voucher_Desc Extender Voucher 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_Batch_From Ext_Inv_Batch_From Extender Invoice Batch From Integer 0 6 Ext_Voucher_Voucher_From Ext_Voucher_Voucher_From Extender Voucher Voucher From Integer 0 7 Ext_Inv_Description_From Ext_Inv_Description_From Extender Invoice Description From Integer 0 8 Ext_Voucher_Creditor Ext_Voucher_Creditor_From Extender Voucher Creditor From Integer 0 9 Ext_Voucher_Addrs_From Ext_Voucher_Addrs_From Extender Voucher Address From Integer 0 10 Ext_Voucher_Doc_From Ext_Voucher_Doc_From Extender Voucher Document From Integer 0 11 Ext_Inv_PO_From Ext_Inv_PO_From Extender Invoice PO From Integer 0 12 Ext_Voucher_Purch_From Ext_Voucher_Purch_From Extender Voucher Purchases From Integer 0 13 Ext_Voucher_Freight_From Ext_Voucher_Freight_From Extender Voucher Freight From Integer 0 14 Ext_Voucher_Misc_From Ext_Voucher_Misc_From Extender Voucher Misc From Integer 0 15 Form_Field_Number_1 Form Field Number[1] INT5 Integer 4 16 Form_Field_Number_2 Form Field Number[2] INT5 Integer 4 17 Form_Field_Number_3 Form Field Number[3] INT5 Integer 4 18 Form_Field_Number_4 Form Field Number[4] INT5 Integer 4 19 Form_Field_Number_5 Form Field Number[5] INT5 Integer 4 20 Form_Field_Number_6 Form Field Number[6] INT5 Integer 4 21 Form_Field_Number_7 Form Field Number[7] INT5 Integer 4 22 Form_Field_Number_8 Form Field Number[8] INT5 Integer 4 23 Form_Field_Number_9 Form Field Number[9] INT5 Integer 4 24 Form_Field_Number_10 Form Field Number[10] INT5 Integer 4 25 Form_Field_Number_11 Form Field Number[11] INT5 Integer 4 26 Form_Field_Number_12 Form Field Number[12] INT5 Integer 4 27 Form_Field_Number_13 Form Field Number[13] INT5 Integer 4 28 Form_Field_Number_14 Form Field Number[14] INT5 Integer 4 29 Form_Field_Number_15 Form Field Number[15] INT5 Integer 4 30 Form_Field_Number_16 Form Field Number[16] INT5 Integer 4 31 Form_Field_Number_17 Form Field Number[17] INT5 Integer 4 32 Form_Field_Number_18 Form Field Number[18] INT5 Integer 4 33 Form_Field_Number_19 Form Field Number[19] INT5 Integer 4 34 Form_Field_Number_20 Form Field Number[20] INT5 Integer 4 35 BACHNUMB Batch Number STR15_LBAU String 15 36 VCHRNMBR Voucher Number STR20_LBAU String 20 37 DSCRIPTN Description STR30 String 30 38 VENDORID Vendor ID STR_15_Vendor_ID String 15 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'].VENDORID39 ADRSCODE Address Code STR15_Address_Code String 15 40 DOCNUMBR Document Number STR20_Document_Number String 20 41 PONUMBER PO Number STR17_POP_Number String 17 42 PRCHAMNT Purchases Amount DLR17_RBS0_UTR$ Currency 17 43 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 44 Freight_Percentage Freight Percentage INT5_%2 Integer 5 45 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 46 Misc_Percentage Misc Percentage INT5_%2 Integer 5 47 Default_Distributions_CB Default Distributions CB Default Distributions CB Boolean 0 48 NOTEINDX Note Index DLR14 Currency 14 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'].NOTEINDX49 CREATDDT Created Date DT Date 8 50 CRUSRID Created User ID STR15_User_ID String 15 51 MODIFDT Modified Date DT Date 8 52 MDFUSRID Modified User ID STR15 String 15 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'].USERID53 Ext_Date_From Ext_Date_From Extender Date From Integer 0