Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP25
Product: SmartList (1493)
Series:
Display Name: SmartList Invoicing Transaction Work
Physical Name: ASIEXP25
Technical Name: ASI_IVC_HDR_WORK_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 2 ASI_Order_By ASI_Order_By Long Integer LI_14 14 3 ASI_Document_Status ASI_Document_Status Integer INT 0 4 DOCTYPE Document Type Integer DDL_Document_Type 0 5 INVCNMBR Invoice Number String STR20_IVC_Document_Number 17 6 BACHNUMB Batch Number String STR15_LBAU 15 7 BCHSOURC Batch Source String STR15 15 8 PCKSLPNO Packing Slip Number String STR20_IVC_Document_Number 17 9 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].CUSTNMBR AS 'SmartList Invoicing Transaction Work-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SmartList Invoicing Transaction Work'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR10 CUSTNAME Customer Name String STR64_Customer_Name 64 11 CSTPONBR Customer PO Number String STR20_Document_Number 20 12 POSTDATE Post Date Date DT_Date 6 13 GLPOSTDT GL Posting Date Date DT 8 14 DOCDATE Document Date Date DT 8 15 QUOTEDAT Quote Date Date DT 8 16 ORDRDATE Order Date Date DT 8 17 DISCDATE Discount Date Date DT 8 18 DUEDATE Due Date Date DT 8 19 HOLDNT Hold NT Boolean CB 0 20 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].SHIPMTHD AS 'SmartList Invoicing Transaction Work-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SmartList Invoicing Transaction Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD21 TAXEXMT1 Tax Exempt 1 String STR25 25 22 TAXEXMT2 Tax Exempt 2 String STR25 25 23 TAXSCHID Tax Schedule ID String STR15_Tax_Schedule_ID 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].TAXSCHID AS 'SmartList Invoicing Transaction Work-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Invoicing Transaction Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID24 FRTSCHID Freight Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].FRTSCHID AS 'SmartList Invoicing Transaction Work-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Invoicing Transaction Work'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID25 FRGTTXBL Freight Taxable Integer DDL_Tax_Options 0 26 FRTTXAMT Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 27 MSCSCHID Misc Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].MSCSCHID AS 'SmartList Invoicing Transaction Work-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Invoicing Transaction Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID28 MISCTXBL Misc Taxable Integer DDL_Tax_Options 0 29 MSCTXAMT Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 30 SLPRSNID Salesperson ID String STR15_Salesperson_ID 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].SLPRSNID AS 'SmartList Invoicing Transaction Work-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SmartList Invoicing Transaction Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID31 SALSTERR Sales Territory String STR15_Sales_Territory 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].SALSTERR AS 'SmartList Invoicing Transaction Work-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['SmartList Invoicing Transaction Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR32 TXRGNNUM Tax Registration Number String STR25 25 33 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].PYMTRMID AS 'SmartList Invoicing Transaction Work-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['SmartList Invoicing Transaction Work'].PYMTRMID = ['Payment Terms Master'].PYMTRMID34 PRCLEVEL PriceLevel String STR10_LBAU 10 35 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].LOCNCODE AS 'SmartList Invoicing Transaction Work-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Invoicing Transaction Work'].LOCNCODE = ['Site Setup'].LOCNCODE36 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].CURNCYID AS 'SmartList Invoicing Transaction Work-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Invoicing Transaction Work'].CURNCYID = ['Currency Setup'].CURNCYID37 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].COMMNTID AS 'SmartList Invoicing Transaction Work-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['SmartList Invoicing Transaction Work'].COMMNTID = ['Comment Master'].COMMNTID38 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 39 SUBTOTAL Subtotal Currency DLR17_RBS0_STR$ 17 40 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 41 MISCAMNT Misc Amount Currency DLR17_RBS0_UTR$ 17 42 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 43 TXBTXAMT Taxable Tax Amount Currency DLR19_RBSO_UTR$ 19 44 BCKTXAMT Backout Tax Amount Currency DLR17_RBS0_UTR$ 17 45 BKTSLSAM Backout Sales Amount Currency DLR19_RBS0_UTR$ 19 46 BKTFRTAM Backout Freight Amount Currency DLR19_RBS0_UTR$ 19 47 BKTMSCAM Backout Misc Amount Currency DLR19_RBS0_UTR$ 19 48 DISCFRGT Discount Available Freight Currency DLR17_RBS0_UTR$ 17 49 DISCMISC Discount Available Misc Currency DLR17_RBS0_UTR$ 17 50 TRDISPCT Trade Discount Percent Integer INT4_%2 4 51 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 52 ACCTAMNT Account Amount Currency DLR19_RBS0_UTR$ 19 53 PYMTRCVD Payment Received Currency DLR19_RBS0_UTR$ 19 54 CODAMNT COD Amount Currency DLR17_RBS0_UTR$ 17 55 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 56 DISCRTND Discount Returned Currency DLR17_RBS0_STR$ 17 57 DISAVTKN Discount Available Taken Currency DLR17_RBS0_UTR$ 17 58 DISTKNAM Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 59 DISAVAMT Discount Available Amount Currency DLR17_RBS0_UTR$ 17 60 DSCDLRAM Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 61 DSCPCTAM Discount Percent Amount Integer INT5_%2 5 62 MRKDNAMT Markdown Amount Currency DLR17_RBS0_UTR$ 17 63 PRBTADCD Primary Billto Address Code String STR15_LBAU 15 64 PRSTADCD Primary Shipto Address Code String STR15_LBAU 15 65 CNTCPRSN Contact Person String STR60 60 66 ADDRESS1 Address 1 String STR60 60 67 ADDRESS2 Address 2 String STR60 60 68 ADDRESS3 Address 3 String STR60 60 69 CITY City String STR35 35 70 STATE State String STR30_State 29 71 ZIPCODE Zip Code String STR10 10 72 COUNTRY Country String STR60 60 73 PHNUMBR1 Phone Number 1 String Phone_Number 14 74 PHNUMBR2 Phone Number 2 String Phone_Number 14 75 PHONE3 Phone 3 String Phone_Number3 14 76 FAXNUMBR Fax Number String STR14_FAX 14 77 COMAPPTO Commission Applied To Integer GB 0 78 COMDLRAM Commission Dollar Amount Currency DLR17_RBSO_STR$ 17 79 NCOMAMNT Non-Commissioned Amount Currency DLR19_RBS0_STR$ 19 80 UPSZONE UPS Zone String STR3 3 81 LSTUSRED Last User to Edit String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].LSTUSRED AS 'SmartList Invoicing Transaction Work-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Invoicing Transaction Work'].LSTUSRED = ['Users Master'].USERID82 LSTEDTDT Last Edit Date Date DT_Date 6 83 MODIFDT Modified Date Date DT 8 84 CREATDDT Created Date Date DT 8 85 USER2ENT User To Enter String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].USER2ENT AS 'SmartList Invoicing Transaction Work-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Invoicing Transaction Work'].USER2ENT = ['Users Master'].USERID86 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SmartList Invoicing Transaction Work'].NOTEINDX AS 'SmartList Invoicing Transaction Work-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP25 AS ['SmartList Invoicing Transaction Work']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Invoicing Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX87 TIMESPRT Times Printed Integer INT4_U0 4 88 NOCARTNS Number Of Cartons Integer INT4_U0 4 89 USERDEF1 User Defined 1 String STR20 20 90 USERDEF2 User Defined 2 String STR20 20 91 VOIDSTTS Void Status Integer INT 0 92 TRXSORCE TRX Source String STR13 13 93 PSTGSTUS Posting Status Integer INT 0 94 IVCHDER1 IVC HDR Errors 1 Long Integer ML_IVC_HDR_Errors_1 0 95 IVCHDER2 IVC HDR Errors 2 Long Integer ML_IVC_HDR_Errors_2 0 96 IVCLINEERR IVC LINE Errors Long Integer ML_IVC_LINE_Errors 0 97 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 98 COMMENT_1 Comment[1] String STR50 50 99 COMMENT_2 Comment[2] String STR50 50 100 COMMENT_3 Comment[3] String STR50 50 101 COMMENT_4 Comment[4] String STR50 50 102 ECTRX EC Transaction Boolean CB_EC_Transaction 0 The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction.103 ShipToName ShipToName String STR64_Customer_Name 64 104 Tax_Date Tax Date Date DT 8 105 APLYWITH Apply Withholding Boolean Boolean 0 106 WITHHAMT Withholding Amount Currency DLR19_RBSO_UTR$ 19 107 CMMTTEXT Comment Text Text TX500 500