Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP20
Product: SmartList (1493)
Series: Pathname
Display Name: ASI SOP Line Item SmartList
Physical Name: ASIEXP20
Technical Name: ASI_SOP_LINE_Items_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Order_By 
ASI_Order_By LI_14 Long Integer 14 2 ASI_Favorite_Sequence ASI_Favorite_Sequence ASI_LI_10_RU Long Integer 10 3 SOPTYPE SOP Type DDL_SOP_Type Integer 0 4 SOPNUMBE SOP Number STR20_SOP_Number String 17 5 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 6 CMPNTSEQ Component Sequence LI_Sequence_Number Long Integer 10 7 ASI_Document_Status ASI_Document_Status INT Integer 0 8 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ITEMNMBR AS 'ASI SOP Line Item SmartList-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ASI SOP Line Item SmartList'].ITEMNMBR = ['Item Master'].ITEMNMBR9 ITEMDESC Item Description STR100 String 100 10 NONINVEN Non IV INT1 Integer 1 11 DROPSHIP Drop Ship INT2 Integer 2 12 UOFM U Of M U_Of_M String 8 13 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].LOCNCODE AS 'ASI SOP Line Item SmartList-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['ASI SOP Line Item SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE14 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 15 ORUNTCST Originating Unit Cost DLR17_RBS0_UTR$ Currency 17 16 UNITPRCE Unit Price DLR17_RBS0_STR$ Currency 17 17 ORUNTPRC Originating Unit Price DLR17_RBS0_STR$ Currency 17 18 XTNDPRCE Extended Price DLR17_RBS0_STR$ Currency 17 19 OXTNDPRC Originating Extended Price DLR17_RBS0_STR$ Currency 17 20 REMPRICE Remaining Price DLR17_RBS0_UTR$ Currency 17 21 OREPRICE Originating Remaining Price DLR17_RBS0_UTR$ Currency 17 22 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 17 23 OREXTCST Originating Extended Cost DLR17_RBS0_UTR$ Currency 17 24 MRKDNAMT Markdown Amount DLR17_RBS0_UTR$ Currency 17 25 ORMRKDAM Originating Markdown Amount DLR17_RBS0_UTR$ Currency 17 26 MRKDNPCT Markdown Percent INT5_%2 Integer 5 27 MRKDNTYP Markdown Type GB Integer 0 28 INVINDX Inventory Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INVINDX AS 'ASI SOP Line Item SmartList-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INVINDX = ['Account Index Master'].ACTINDX29 CSLSINDX Cost Of Sales Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CSLSINDX AS 'ASI SOP Line Item SmartList-Cost Of Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].CSLSINDX = ['Account Index Master'].ACTINDX30 SLSINDX Sales Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SLSINDX AS 'ASI SOP Line Item SmartList-Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].SLSINDX = ['Account Index Master'].ACTINDX31 MKDNINDX Markdown Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].MKDNINDX AS 'ASI SOP Line Item SmartList-Markdown Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].MKDNINDX = ['Account Index Master'].ACTINDX32 RTNSINDX Returns Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].RTNSINDX AS 'ASI SOP Line Item SmartList-Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].RTNSINDX = ['Account Index Master'].ACTINDX33 INUSINDX In Use Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INUSINDX AS 'ASI SOP Line Item SmartList-In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INUSINDX = ['Account Index Master'].ACTINDX34 INSRINDX In Service Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INSRINDX AS 'ASI SOP Line Item SmartList-In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INSRINDX = ['Account Index Master'].ACTINDX35 DMGDINDX Damaged Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].DMGDINDX AS 'ASI SOP Line Item SmartList-Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].DMGDINDX = ['Account Index Master'].ACTINDX36 ITMTSHID Item Tax Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ITMTSHID AS 'ASI SOP Line Item SmartList-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID37 IVITMTXB IV Item Taxable DDL_Tax_Options Integer 0 38 BKTSLSAM Backout Sales Amount DLR19_RBS0_UTR$ Currency 19 39 ORBKTSLS Originating Backout Sales Amount DLR19_RBS0_UTR$ Currency 19 40 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 41 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 42 TXBTXAMT Taxable Tax Amount DLR19_RBSO_UTR$ Currency 19 43 OTAXTAMT Originating Taxable Tax Amount DLR17_RBS0_UTR$ Currency 17 44 BSIVCTTL Based On Invoice Total YN Boolean 0 45 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 46 ORTDISAM Originating Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 47 DISCSALE Discount Available Sales DLR17_RBS0_UTR$ Currency 17 48 ORDAVSLS Originating Discount Available Sales DLR17_RBS0_UTR$ Currency 17 49 QUANTITY QTY DLR17_QTY_RBS0_STR Currency 17 50 ATYALLOC QTY Allocated DLR17_QTY_RBS0_UTR Currency 17 51 QTYINSVC QTY In Service DLR17_QTY_RBS0_UTR Currency 17 52 QTYINUSE QTY In Use DLR17_QTY_RBS0_UTR Currency 17 53 QTYDMGED QTY Damaged DLR17_QTY_RBS0_UTR Currency 17 54 QTYRTRND QTY Returned DLR17_QTY_RBS0_UTR Currency 17 55 QTYONHND QTY On Hand DLR17_QTY_RBS0_STR Currency 17 56 QTYCANCE QTY Canceled DLR17_QTY_RBS0_UTR Currency 17 57 QTYCANOT QTY Canceled Other DLR17_QTY_RBS0_UTR Currency 17 58 QTYORDER QTY Ordered DLR17_QTY_RBS0_UTR Currency 17 59 QTYPRBAC QTY Prev Back Ordered DLR17_QTY_RBS0_UTR Currency 17 60 QTYPRBOO QTY Prev BO On Order DLR17_QTY_RBS0_UTR Currency 17 61 QTYPRINV QTY Prev Invoiced DLR17_QTY_RBS0_UTR Currency 17 62 QTYPRORD QTY Prev Ordered DLR17_QTY_RBS0_UTR Currency 17 63 QTYREMAI QTY Remaining DLR17_QTY_RBS0_UTR Currency 17 64 QTYREMBO QTY Remaining On BO DLR17_QTY_RBS0_UTR Currency 17 65 QTYTBAOR QTY To Back Order DLR17_QTY_RBS0_UTR Currency 17 66 QTYTOINV QTY To Invoice DLR17_QTY_RBS0_UTR Currency 17 67 QTYTORDR QTY To Order DLR17_QTY_RBS0_UTR Currency 17 68 QTYFULFI QTY Fulfilled DLR17_QTY_RBS0_UTR Currency 17 69 QTYSLCTD QTY Selected DLR17_QTY_RBS0_UTR Currency 17 70 QTYBSUOM QTY In Base U Of M DLR17_QTY_RBS0_STR Currency 17 71 EXTQTYAL Existing Qty Available DLR17_RBS0_UTR$ Currency 17 72 EXTQTYSEL Existing Qty Selected DLR17_QTY_RBS0_STR Currency 17 73 ReqShipDate Requested Ship Date DT Date 8 74 FUFILDAT Fulfillment Date DT Date 8 75 ACTLSHIP Actual Ship Date DT Date 8 76 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SHIPMTHD AS 'ASI SOP Line Item SmartList-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['ASI SOP Line Item SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD77 SALSTERR Sales Territory STR15_Sales_Territory String 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SALSTERR AS 'ASI SOP Line Item SmartList-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['ASI SOP Line Item SmartList'].SALSTERR = ['Sales Territory Master File'].SALSTERR78 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SLPRSNID AS 'ASI SOP Line Item SmartList-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['ASI SOP Line Item SmartList'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID79 PRCLEVEL PriceLevel STR10_LBAU String 10 80 COMMNTID Comment ID STR15_Comment_ID String 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].COMMNTID AS 'ASI SOP Line Item SmartList-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['ASI SOP Line Item SmartList'].COMMNTID = ['Comment Master'].COMMNTID81 BRKFLD1 Break Field 1 INT1 Integer 1 82 BRKFLD2 Break Field 2 INT1 Integer 1 83 BRKFLD3 Break Field 3 INT1 Integer 1 84 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CURRNIDX AS 'ASI SOP Line Item SmartList-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ASI SOP Line Item SmartList'].CURRNIDX = ['Currency Setup'].CURRNIDX85 TRXSORCE TRX Source STR13 String 13 86 SOPLNERR SOP LINE Errors ML_SOP_LINE_Errors Long Integer 0 87 PURCHSTAT Purchasing Status DDL_PurchasingStatus Integer 0 88 QTYONPO QTY On PO DLR17_QTY_RBS0_UTR Currency 17 89 QTYRECVD QTY Received DLR17_QTY_RBS0_UTR Currency 17 90 QTYPRVRECVD QTY Prev Received DLR17_QTY_RBS0_UTR Currency 17 91 ORIGTYPE Original Type DDL_SOP_Type Integer 0 92 DOCID Document ID STR15_LBAU String 15 93 DOCDATE Document Date DT Date 8 94 GLPOSTDT GL Posting Date DT Date 8 95 QUOTEDAT Quote Date DT Date 8 96 QUOEXPDA Quote Expiration Date DT Date 8 97 ORDRDATE Order Date DT Date 8 98 INVODATE Invoice Date DT Date 8 99 BACKDATE Back Order Date DT Date 8 100 RETUDATE Return Date DT Date 8 101 DISCDATE Discount Date DT Date 8 102 DUEDATE Due Date DT Date 8 103 REPTING Repeating CB_Repeating Boolean 0 104 TRXFREQU TRX Frequency DDL_TRX_Frequency Integer 0 105 TIMEREPD Times Repeated INT4_U0 Integer 4 106 DYSTINCR Days to Increment INT3_RB0_U Integer 3 107 DTLSTREP Date Last Repeated DT Date 8 108 DSTBTCH1 Dest Batch 1 STR15_LBAU String 15 109 DSTBTCH2 Dest Batch 2 STR15_LBAU String 15 110 USDOCID1 Use Document ID 1 STR15_LBAU String 15 111 USDOCID2 Use Document ID 2 STR15_LBAU String 15 112 DISCFRGT Discount Available Freight DLR17_RBS0_UTR$ Currency 17 113 ORDAVFRT Originating Discount Available Freight DLR17_RBS0_UTR$ Currency 17 114 DISCMISC Discount Available Misc DLR17_RBS0_UTR$ Currency 17 115 ORDAVMSC Originating Discount Available Misc DLR17_RBS0_UTR$ Currency 17 116 DISAVAMT Discount Available Amount DLR17_RBS0_UTR$ Currency 17 117 ORDAVAMT Originating Discount Available Amount DLR17_RBS0_UTR$ Currency 17 118 DISCRTND Discount Returned DLR17_RBS0_STR$ Currency 17 119 ORDISRTD Originating Discount Returned DLR17_RBS0_STR$ Currency 17 120 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 121 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 122 DSCPCTAM Discount Percent Amount INT5_%2 Integer 5 123 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 124 ORDATKN Originating Discount Available Taken DLR17_RBS0_UTR$ Currency 17 125 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PYMTRMID AS 'ASI SOP Line Item SmartList-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['ASI SOP Line Item SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID126 BCHSOURC Batch Source STR15 String 15 127 BACHNUMB Batch Number STR15_LBAU String 15 128 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CUSTNMBR AS 'ASI SOP Line Item SmartList-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ASI SOP Line Item SmartList'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR129 CUSTNAME Customer Name STR64_Customer_Name String 64 130 CSTPONBR Customer PO Number STR20_Document_Number String 20 131 PROSPECT Prospect INT1 Integer 1 132 MSTRNUMB Master Number LI_MasterNumber Long Integer 9 133 PCKSLPNO Packing Slip Number STR20_IVC_Document_Number String 17 134 PICTICNU Picking Ticket Number STR20_SOP_Number String 17 135 PRBTADCD Primary Billto Address Code STR15_LBAU String 15 136 PRSTADCD Primary Shipto Address Code STR15_LBAU String 15 137 CNTCPRSN Contact Person STR60 String 60 138 ShipToName ShipToName STR64_Customer_Name String 64 139 ADDRESS1 Address 1 STR60 String 60 140 ADDRESS2 Address 2 STR60 String 60 141 ADDRESS3 Address 3 STR60 String 60 142 CITY City STR35 String 35 143 STATE State STR30_State String 29 144 ZIPCODE Zip Code STR10 String 10 145 COUNTRY Country STR60 String 60 146 PHNUMBR1 Phone Number 1 Phone_Number String 14 147 PHNUMBR2 Phone Number 2 Phone_Number String 14 148 FAXNUMBR Fax Number STR14_FAX String 14 149 COMAPPTO Commission Applied To GB Integer 0 150 COMMAMNT Commission Amount DLR17_RBS0_STR$ Currency 17 151 OCOMMAMT Originating Commission Amount DLR17_RBSO_STR$ Currency 17 152 CMMSLAMT Commission Sale Amount DLR17_RBS0_STR$ Currency 17 153 ORCOSAMT Originating Commission Sales Amount DLR17_RBS0_STR$ Currency 17 154 NCOMAMNT Non-Commissioned Amount DLR19_RBS0_STR$ Currency 19 155 ORNCMAMT Originating Non-Commissioned Amount DLR19_RBS0_STR$ Currency 19 156 TRDISPCT Trade Discount Percent INT4_%2 Integer 4 157 SUBTOTAL Subtotal DLR17_RBS0_STR$ Currency 17 158 ORSUBTOT Originating Subtotal DLR17_RBS0_STR$ Currency 17 159 REMSUBTO Remaining Subtotal DLR17_RBS0_UTR$ Currency 17 160 OREMSUBT Originating Remaining Subtotal DLR17_RBS0_UTR$ Currency 17 161 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 162 ORFRTAMT Originating Freight Amount DLR17_RBS0_UTR$ Currency 17 163 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 164 ORMISCAMT Originating Misc Amount DLR19_RBSO_UTR$ Currency 19 165 TXENGCLD Tax Engine Called YN Boolean 0 166 TAXEXMT1 Tax Exempt 1 STR25 String 25 167 TAXEXMT2 Tax Exempt 2 STR25 String 25 168 TXRGNNUM Tax Registration Number STR25 String 25 169 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].TAXSCHID AS 'ASI SOP Line Item SmartList-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID170 TXSCHSRC Tax Schedule Source INT1 Integer 1 171 FRTSCHID Freight Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].FRTSCHID AS 'ASI SOP Line Item SmartList-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID172 FRTTXAMT Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 173 ORFRTTAX Originating Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 174 FRGTTXBL Freight Taxable DDL_Tax_Options Integer 0 175 MSCSCHID Misc Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].MSCSCHID AS 'ASI SOP Line Item SmartList-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID176 MSCTXAMT Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 177 ORMSCTAX Originating Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 178 MISCTXBL Misc Taxable DDL_Tax_Options Integer 0 179 BKTFRTAM Backout Freight Amount DLR19_RBS0_UTR$ Currency 19 180 ORBKTFRT Originating Backout Freight Amount DLR19_RBS0_UTR$ Currency 19 181 BKTMSCAM Backout Misc Amount DLR19_RBS0_UTR$ Currency 19 182 ORBKTMSC Originating Backout Misc Amount DLR19_RBS0_UTR$ Currency 19 183 BCKTXAMT Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 184 OBTAXAMT Originating Backout Tax Amount DLR17_RBS0_UTR$ Currency 17 185 ECTRX EC Transaction CB_EC_Transaction Boolean 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.186 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 187 ORDOCAMT Originating Document Amount DLR17_RBS0_STR$ Currency 17 188 PYMTRCVD Payment Received DLR19_RBS0_UTR$ Currency 19 189 ORPMTRVD Originating Payment Received DLR19_RBS0_UTR$ Currency 19 190 DEPRECVD Deposit Received DLR19_RBS0_UTR$ Currency 19 191 ORDEPRVD Originating Deposit Received DLR19_RBS0_UTR$ Currency 19 192 CODAMNT COD Amount DLR17_RBS0_UTR$ Currency 17 193 ORCODAMT Originating COD Amount DLR17_RBS0_UTR$ Currency 17 194 ACCTAMNT Account Amount DLR19_RBS0_UTR$ Currency 19 195 ORACTAMT Originating Account Amount DLR19_RBS0_UTR$ Currency 19 196 UPSZONE UPS Zone STR3 String 3 197 TIMESPRT Times Printed INT4_U0 Integer 4 198 PSTGSTUS Posting Status INT Integer 0 199 VOIDSTTS Void Status INT Integer 0 200 ALLOCABY Allocate By DDL_Allocate_By Integer 0 201 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CURNCYID AS 'ASI SOP Line Item SmartList-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ASI SOP Line Item SmartList'].CURNCYID = ['Currency Setup'].CURNCYID202 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].RATETPID AS 'ASI SOP Line Item SmartList-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['ASI SOP Line Item SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID203 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].EXGTBLID AS 'ASI SOP Line Item SmartList-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['ASI SOP Line Item SmartList'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID204 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 205 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 206 EXCHDATE Exchange Date DT_Date Date 6 207 TIME1 Time TM6 Time 6 208 RTCLCMTD Rate Calculation Method GB Integer 0 209 MCTRXSTT MC Transaction State INT1 Integer 1 210 SOPHDRE1 SOP HDR Errors 1 ML_SOP_HDR_Errors_1 Long Integer 0 211 SOPHDRE2 SOP HDR Errors 2 ML_SOP_HDR_Errors_2 Long Integer 0 212 SOPHDRFL SOP HDR Flags ML_SOP_HDR_Flags Long Integer 0 213 REFRENCE Reference STR30 String 30 214 POSTEDDT Posted Date DATE Date 6 215 PTDUSRID Posted User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PTDUSRID AS 'ASI SOP Line Item SmartList-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ASI SOP Line Item SmartList'].PTDUSRID = ['Users Master'].USERID216 USER2ENT User To Enter STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].USER2ENT AS 'ASI SOP Line Item SmartList-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ASI SOP Line Item SmartList'].USER2ENT = ['Users Master'].USERID217 CREATDDT Created Date DT Date 8 218 MODIFDT Modified Date DT Date 8 219 Tax_Date Tax Date DT Date 8 220 ITMSHNAM Item Short Name STR15 String 15 221 ITEMTYPE Item Type DDL_Item_Type Integer 0 222 ITMGEDSC Item Generic Description STR10 String 10 223 STNDCOST Standard Cost DLR17_RBS0_UTR$ Currency 17 224 CURRCOST Current Cost DLR17_RBS0_UTR$ Currency 17 225 LISTPRCE List Price DLR17_RBS0_STR$ Currency 17 226 ITEMSHWT Item Shipping Weight LI6_RBS2_UT Long Integer 6 227 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 0 228 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 229 TAXOPTNS Tax Options DDL_Tax_Options Integer 0 230 COMMCODE Commission Code STR15_LBAU String 15 231 IVIVINDX IV IV Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVIVINDX AS 'ASI SOP Line Item SmartList-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVIVINDX = ['Account Index Master'].ACTINDX232 IVIVOFIX IV IV Offset Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVIVOFIX AS 'ASI SOP Line Item SmartList-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVIVOFIX = ['Account Index Master'].ACTINDX233 IVCOGSIX IV COGS Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVCOGSIX AS 'ASI SOP Line Item SmartList-IV COGS Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVCOGSIX = ['Account Index Master'].ACTINDX234 IVSLSIDX IV Sales Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVSLSIDX AS 'ASI SOP Line Item SmartList-IV Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVSLSIDX = ['Account Index Master'].ACTINDX235 IVSLDSIX IV Sales Discounts Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVSLDSIX AS 'ASI SOP Line Item SmartList-IV Sales Discounts Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVSLDSIX = ['Account Index Master'].ACTINDX236 IVSLRNIX IV Sales Returns Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVSLRNIX AS 'ASI SOP Line Item SmartList-IV Sales Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVSLRNIX = ['Account Index Master'].ACTINDX237 IVINUSIX IV In Use Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVINUSIX AS 'ASI SOP Line Item SmartList-IV In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVINUSIX = ['Account Index Master'].ACTINDX238 IVINSVIX IV In Service Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVINSVIX AS 'ASI SOP Line Item SmartList-IV In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVINSVIX = ['Account Index Master'].ACTINDX239 IVDMGIDX IV Damaged Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVDMGIDX AS 'ASI SOP Line Item SmartList-IV Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVDMGIDX = ['Account Index Master'].ACTINDX240 IVVARIDX IV Variances Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVVARIDX AS 'ASI SOP Line Item SmartList-IV Variances Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVVARIDX = ['Account Index Master'].ACTINDX241 DPSHPIDX Drop Ship Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].DPSHPIDX AS 'ASI SOP Line Item SmartList-Drop Ship Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].DPSHPIDX = ['Account Index Master'].ACTINDX242 PURPVIDX Purchase Price Variance Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PURPVIDX AS 'ASI SOP Line Item SmartList-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].PURPVIDX = ['Account Index Master'].ACTINDX243 IVRETIDX Inventory Returns Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVRETIDX AS 'ASI SOP Line Item SmartList-Inventory Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVRETIDX = ['Account Index Master'].ACTINDX244 ASMVRIDX Assembly Variance Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ASMVRIDX AS 'ASI SOP Line Item SmartList-Assembly Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].ASMVRIDX = ['Account Index Master'].ACTINDX245 ITMCLSCD Item Class Code STR10_Class_ID String 10 Key to the Item Class Setup (IV40400).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ITMCLSCD AS 'ASI SOP Line Item SmartList-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['ASI SOP Line Item SmartList'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD246 ITMTRKOP Item Tracking Option DDL_Track Integer 0 247 LOTTYPE Lot Type STR10_Lot_Type String 10 248 KPERHIST Keep Period History CB_Keep_Period_History Boolean 0 249 KPTRXHST Keep Trx History CB_Keep_Trx_History Boolean 0 250 KPCALHST Keep Calendar History CB_Keep_Calendar_History Boolean 0 251 KPDSTHST Keep Distribution History CB_Keep_Dist_History Boolean 0 252 ALWBKORD Allow Back Orders CB_Allow_Back_Orders Boolean 0 253 VCTNMTHD Valuation Method DDL_Valuation_Method Integer 0 254 UOMSCHDL U Of M Schedule STR10_Schedule String 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].UOMSCHDL AS 'ASI SOP Line Item SmartList-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['ASI SOP Line Item SmartList'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL255 ObjRef1 ObjRef1 Reference Invalid storage type 30 0 256 ALTITEM1 Alternate Item 1 STR30_Item_Number String 30 257 ALTITEM2 Alternate Item 2 STR30_Item_Number String 30 258 USCATVLS_1 User Category Values[1] User_Category_Value String 10 259 USCATVLS_2 User Category Values[2] User_Category_Value String 10 260 USCATVLS_3 User Category Values[3] User_Category_Value String 10 261 USCATVLS_4 User Category Values[4] User_Category_Value String 10 262 USCATVLS_5 User Category Values[5] User_Category_Value String 10 263 USCATVLS_6 User Category Values[6] User_Category_Value String 10 264 MSTRCDTY Master Record Type INT1 Integer 1 265 WRNTYDYS Warranty Days INT4 Integer 4 266 ORIGNUMB Original Number STR20_SOP_Number String 17 267 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 17 268 TIMETREP Times To Repeat INT4_U0 Integer 4 269 ORDDLRAT Originating Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 270 SOPMCERR SOP MC Posting Error Messages SOP MC Posting Error Messages Long Integer 0 271 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].NOTEINDX AS 'ASI SOP Line Item SmartList-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['ASI SOP Line Item SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX272 CUSTCLAS Customer Class STR15_Customer_Class String 15 273 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 274 STMTNAME Statement Name STR64 String 64 275 ADRSCODE Address Code STR15_Address_Code String 15 276 STADDRCD Statement Address Code STR15_LBAU String 15 277 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CHEKBKID AS 'ASI SOP Line Item SmartList-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['ASI SOP Line Item SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID278 CRLMTTYP Credit Limit Type GB_Amt_Type Integer 0 279 CRLMTAMT Credit Limit Amount DLR17_RBS0_UTR$ Currency 17 280 CRLMTPER Credit Limit Period DDL Integer 0 281 CRLMTPAM Credit Limit Period Amount DLR17_RBS0_UTR$ Currency 17 282 CUSTDISC Customer Discount INT5_%2 Integer 5 283 SHRTNAME Short Name STR15 String 15 284 MINPYTYP Minimum Payment Type GB_Amt_Type Integer 0 285 MINPYDLR Minimum Payment Dollar DLR17_RBS0_UTR$ Currency 17 286 MINPYPCT Minimum Payment Percent INT5_%2 Integer 5 287 FNCHATYP Finance Charge Amt Type GB_Amt_Type Integer 0 288 FNCHPCNT Finance Charge Percent INT5_%2 Integer 5 289 FINCHDLR Finance Charge Dollar DLR17_RBS0_UTR$ Currency 17 290 MXWOFTYP Maximum Writeoff Type GP_Max_Writeoff Integer 0 291 MXWROFAM Max Writeoff Amount DLR17_RBS0_UTR$ Currency 17 292 USERDEF1 User Defined 1 STR20 String 20 293 USERDEF2 User Defined 2 STR20 String 20 294 BALNCTYP Balance Type GB_Bal_Type Integer 0 295 STMTCYCL Statement Cycle DDL_Stmt_Cycle Integer 0 296 BANKNAME Bank Name STR30 String 30 297 BNKBRNCH Bank Branch STR20 String 20 298 DEFCACTY Default Cash Account Type GB Integer 0 299 RMCSHACC RM Cash Account Index LI_14 Long Integer 14 300 RMARACC RM AR Account Index LI_14 Long Integer 14 301 RMSLSACC RM Sales Account Index LI_14 Long Integer 14 302 RMIVACC RM IV Account Index LI_14 Long Integer 14 303 RMCOSACC RM Cost Of Sales Account Index LI_14 Long Integer 14 304 RMTAKACC RM Discounts Taken Account Index LI_14 Long Integer 14 305 RMAVACC RM Discounts Avail Account Index LI_14 Long Integer 14 306 RMFCGACC RM Finance Charge Account Index LI_14 Long Integer 14 307 RMWRACC RM Writeoff Account Index LI_14 Long Integer 14 308 FRSTINDT First Invoice Date DT_Date Date 6 309 INACTIVE Inactive CB_Inactive Boolean 0 310 HOLD Hold CB_Hold Boolean 0 311 CRCARDID Credit Card ID STR15 String 15 312 CRCRDNUM Credit Card Number STR20 String 20 313 CCRDXPDT Credit Card Exp Date DT_Date Date 6 314 Revalue_Customer Revalue Customer CB Revalue Customer Boolean 0 315 Post_Results_To Post Results To GB Integer 0 316 FINCHID Finance Charge ID STR15_Charge_ID String 15 317 GOVCRPID Governmental Corporate ID STR30_Gov_Corp_ID String 30 318 GOVINDID Governmental Individual ID STR30_Gov_Indiv_ID String 30 319 TNSFCLIF Total Amount Of NSF Checks Life DLR19_RBS0_STR$ Currency 19 320 NONSFLIF Number Of NSF Checks Life LI6_U0 Long Integer 6 321 CUSTBLNC Customer Balance DLR19_RBS0_STR$ Currency 19 322 AGPERAMT_1 Aging Period Amounts[1] DLR17_RBSO_STR$ Currency 17 323 AGPERAMT_2 Aging Period Amounts[2] DLR17_RBSO_STR$ Currency 17 324 AGPERAMT_3 Aging Period Amounts[3] DLR17_RBSO_STR$ Currency 17 325 AGPERAMT_4 Aging Period Amounts[4] DLR17_RBSO_STR$ Currency 17 326 AGPERAMT_5 Aging Period Amounts[5] DLR17_RBSO_STR$ Currency 17 327 AGPERAMT_6 Aging Period Amounts[6] DLR17_RBSO_STR$ Currency 17 328 AGPERAMT_7 Aging Period Amounts[7] DLR17_RBSO_STR$ Currency 17 329 LASTAGED Last Aged DATE Date 6 330 LSTNSFCD Last NSF Check Date DT_Date Date 6 331 LPYMTAMT Last Payment Amount DLR17_RBS0_STR$ Currency 17 332 LASTPYDT Last Payment Date DT_Date Date 6 333 LSTTRXDT Last Transaction Date DT_Date Date 6 334 LSTTRXAM Last Transaction Amount DLR17_RBS0_STR$ Currency 17 335 LSTFCHAM Last Finance Charge Amount DLR19_RBS0_STR$ Currency 19 336 UPFCHYTD Unpaid Finance Charges YTD DLR17_RBS0_UTR$ Currency 17 337 AVDTPLYR Average Days to Pay - LYR INT3_U0 Integer 3 338 AVDTPLIF Average Days To Pay - Life INT3_U0 Integer 3 339 AVGDTPYR Average Days To Pay - Year INT3_U0 Integer 3 340 NUMADTPL Number ADTP Documents - Life Long_10U Long Integer 10 341 NUMADTPR Number ADTP Documents - LYR Long_10U Long Integer 10 342 NUMADTPY Number ADTP Documents - Year Long_10U Long Integer 10 343 TDTKNLTD Total Discounts Taken LTD DLR19_RBS0_STR$ Currency 19 344 TDTKNLYR Total Discounts Taken LYR DLR19_RBS0_STR$ Currency 19 345 TDTKNYTD Total Discounts Taken YTD DLR19_RBS0_STR$ Currency 19 346 TDISAYTD Total Discounts Available YTD DLR19_RBS0_STR$ Currency 19 347 RETAINAG Retainage DLR19_RBS0_STR$ Currency 19 348 TNSFCYTD Total Amount Of NSF Checks YTD DLR19_RBS0_STR$ Currency 19 349 NONSFYTD Number Of NSF Checks YTD LI6_U0 Long Integer 6 350 UNPSTDSA Unposted Sales Amount DLR19_RBS0_UTR$ Currency 19 351 UNPSTDCA Unposted Cash Amount DLR19_RBS0_UTR$ Currency 19 352 UNPSTOSA Unposted Other Sales Amount DLR19_RBS0_UTR$ Currency 19 353 UNPSTOCA Unposted Other Cash Amount DLR19_RBS0_UTR$ Currency 19 354 NCSCHPMT Non Current Scheduled Payments DLR19_RBS0_STR$ Currency 19 355 TTLSLLTD Total Sales LTD DLR19_RBS0_STR$ Currency 19 356 TTLSLLYR Total Sales LYR DLR19_RBS0_STR$ Currency 19 357 TTLSLYTD Total Sales YTD DLR19_RBS0_STR$ Currency 19 358 TCOSTLTD Total Costs LTD DLR19_RBS0_STR$ Currency 19 359 TCOSTLYR Total Costs LYR DLR19_RBS0_STR$ Currency 19 360 TCOSTYTD Total Costs YTD DLR19_RBS0_STR$ Currency 19 361 TCSHRLTD Total Cash Received LTD DLR19_RBS0_STR$ Currency 19 362 TCSHRLYR Total Cash Received LYR DLR19_RBS0_STR$ Currency 19 363 TCSHRYTD Total Cash Received YTD DLR19_RBS0_STR$ Currency 19 364 TFNCHLTD Total Finance Charges LTD DLR19_RBS0_STR$ Currency 19 365 TFNCHLYR Total Finance Charges LYR DLR19_RBS0_STR$ Currency 19 366 TFNCHYTD Total Finance Charges YTD DLR19_RBS0_STR$ Currency 19 367 FNCHCYTD Finance Charges CYTD DLR19_RBS0_STR$ Currency 19 368 FNCHLYRC Finance Charges LYR Calendar DLR19_RBS0_STR$ Currency 19 369 TBDDTLYR Total Bad Deb LYR DLR19_RBS0_STR$ Currency 19 370 TBDDTLTD Total Bad Debt LTD DLR19_RBS0_STR$ Currency 19 371 TBDDTYTD Total Bad Debt YTD DLR19_RBS0_STR$ Currency 19 372 TWVFCLTD Total Waived FC LTD DLR19_RBS0_STR$ Currency 19 373 TWVFCLYR Total Waived FC LYR DLR19_RBS0_STR$ Currency 19 374 TWVFCYTD Total Waived FC YTD DLR19_RBS0_STR$ Currency 19 375 TWROFLTD Total Writeoffs LTD DLR19_RBS0_STR$ Currency 19 376 TWROFLYR Total Writeoffs LYR DLR19_RBS0_STR$ Currency 19 377 TWROFYTD Total Writeoffs YTD DLR19_RBS0_STR$ Currency 19 378 TTLINLTD Total # Invoices LTD LI6_U0 Long Integer 6 379 TTLINLYR Total # Invoices LYR LI6_U0 Long Integer 6 380 TTLINYTD Total # Invoices YTD LI6_U0 Long Integer 6 381 TTLFCLTD Total # FC LTD LI6_U0 Long Integer 6 382 TTLFCLYR Total # FC LYR LI6_U0 Long Integer 6 383 TTLFCYTD Total # FC YTD LI6_U0 Long Integer 6 384 WROFSLIF Write Offs LIFE DLR19_RBS0_STR$ Currency 19 385 WROFSLYR Write Offs LYR DLR19_RBS0_STR$ Currency 19 386 WROFSYTD Write Offs YTD DLR19_RBS0_STR$ Currency 19 387 HIBALLTD High Balance LTD DLR19_RBSO_STR$ Currency 19 388 HIBALLYR High Balance LYR DLR19_RBSO_STR$ Currency 19 389 HIBALYTD High Balance YTD DLR19_RBSO_STR$ Currency 19 390 LASTSTDT Last Statement Date DATE Date 6 391 LSTSTAMT Last Statement Amount DLR17_RBS0_STR$ Currency 17 392 DEPRECV Deposits Received DLR19_RBS0_STR$ Currency 19 393 ONORDAMT On Order Amount DLR19_RBS0_UTR$ Currency 19 394 DISGRPER Discount Grace Period INT2_U0 Integer 2 395 DOCFMTID Document Format ID STR15_LBU String 15 396 DUEGRPER Due Date Grace Period INT2_U0 Integer 2 397 APLYWITH Apply Withholding Boolean Boolean 0 398 CORRCTN Correction CB_Correction Boolean 0 399 DOCNCORR Document Number Corrected Document_Number String 20 400 PHONE3 Phone 3 Phone_Number3 String 14 401 SALEDATE Sale Date DT Date 8 402 SEQNCORR Sequence Number Corrected INT Integer 0 403 SHPPGDOC Shipping Document CB_Shipping_Document Boolean 0 404 SIMPLIFD Simplified CB_Simplified Boolean 0 405 WITHHAMT Withholding Amount DLR19_RBSO_UTR$ Currency 19 406 CORRNXST Correction to Nonexisting Transaction Boolean Boolean 0 407 SOPHDRE3 SOP HDR Errors 3 ML_SOP_HDR_Errors_3 Long Integer 0 408 ABCCODE ABC Code DDL_ABC_Code Integer 0 409 CGSINFLX COGS Inflation Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CGSINFLX AS 'ASI SOP Line Item SmartList-COGS Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].CGSINFLX = ['Account Index Master'].ACTINDX410 CGSMCIDX COGS Monetary Correction Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CGSMCIDX AS 'ASI SOP Line Item SmartList-COGS Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].CGSMCIDX = ['Account Index Master'].ACTINDX411 IVINFIDX Inventory Inflation Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVINFIDX AS 'ASI SOP Line Item SmartList-Inventory Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVINFIDX = ['Account Index Master'].ACTINDX412 INVMCIDX Inventory Monetary Correction Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INVMCIDX AS 'ASI SOP Line Item SmartList-Inventory Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INVMCIDX = ['Account Index Master'].ACTINDX413 ITEMCODE Item Code STR15 String 15 414 KTACCTSR Kit COGS Account Source GB Integer 0 415 LASTGENSN Last Generated Serial Number STR20_LBAU String 20 416 PriceGroup Price Group STR10_LBAU String 10 417 PRICMTHD Price Method DDL_Price_Method Integer 0 418 PINFLIDX Purch Inflation Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PINFLIDX AS 'ASI SOP Line Item SmartList-Purch Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].PINFLIDX = ['Account Index Master'].ACTINDX419 PURMCIDX Purch Monetary Correction Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PURMCIDX AS 'ASI SOP Line Item SmartList-Purch Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].PURMCIDX = ['Account Index Master'].ACTINDX420 PRCHSUOM Purchasing U Of M U_Of_M String 8 421 SELNGUOM Selling U Of M U_Of_M String 8 422 TCC Tax Commodity Code STR30_VAT String 30 423 UPPVIDX Unrealized Purchase Price Variance Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].UPPVIDX AS 'ASI SOP Line Item SmartList-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].UPPVIDX = ['Account Index Master'].ACTINDX424 ORGSEQNM Original Sequence Number Corrected LI_Sequence_Number Long Integer 10 425 ODECPLCU Originating Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 426 TTLRTLTD Total Returns LTD DLR19_RBS0_STR$ Currency 19 427 TTLRTLYR Total Returns LYR DLR19_RBS0_STR$ Currency 19 428 TTLRTYTD Total Returns YTD DLR19_RBS0_STR$ Currency 19 429 CUSTNAME1 ASI_Customer_Name STR64_Customer_Name String 64 430 CNTCPRSN1 ASI_Contact_Person STR60 String 60 431 ASI_Address_Code ASI_Address_Code STR15_Address_Code String 15 432 UPSZONE1 ASI_UPS_Zone STR3 String 3 433 SHIPMTHD1 ASI_Shipping_Method STR15_Shipping_Method String 15 434 TAXSCHID1 ASI_Tax_Schedule_ID STR15_Tax_Schedule_ID String 15 435 ADDRESS11 ASI_Address_1 STR60 String 60 436 ADDRESS21 ASI_Address_2 STR60 String 60 437 ADDRESS31 ASI_Address_3 STR60 String 60 438 COUNTRY1 ASI_Country STR60 String 60 439 CITY1 ASI_City STR35 String 35 440 STATE1 ASI_State STR30_State String 29 441 ZIP1 ASI_Zip STR10 String 10 442 PHONE11 ASI_Phone_1 Phone_Number String 14 443 PHONE21 ASI_Phone_2 Phone_Number String 14 444 FAX1 ASI_Fax STR14_FAX String 14 445 PRBTADCD1 ASI_Primary_Billto_Address_Code STR15_LBAU String 15 446 PRSTADCD1 ASI_Primary_Shipto_Address_Code STR15_LBAU String 15 447 SLPRSNID1 ASI_Salesperson_ID STR15_Salesperson_ID String 15 448 PYMTRMID1 ASI_Payment_Terms_ID STR20_Payment_Terms_ID String 20 449 CURNCYID1 ASI_Currency_ID STR15_Currency_ID String 15 450 RATETPID1 ASI_Rate_Type_ID STR15_Rate_Type_ID String 15 451 PRCLEVEL1 ASI_PriceLevel STR10_LBAU String 10 452 COMMENT11 ASI_Comment1 STR30 String 30 453 COMMENT21 ASI_Comment2 STR30 String 30 454 TXRGNNUM1 ASI_Tax_Registration_Number STR25 String 25 455 TAXEXMT11 ASI_Tax_Exempt_1 STR25 String 25 456 TAXEXMT21 ASI_Tax_Exempt_2 STR25 String 25 457 SALSTERR1 ASI_Sales_Territory STR15_Sales_Territory String 15 458 KPCALHST1 ASI_Keep_Calendar_History CB_Keep_Calendar_History Boolean 0 459 KPDSTHST1 ASI_Keep_Distribution_History CB_Keep_Dist_History Boolean 0 460 KPERHIST1 ASI_Keep_Period_History CB_Keep_Period_History Boolean 0 461 KPTRXHST1 ASI_Keep_Trx_History CB_Keep_Trx_History Boolean 0 462 NOTEINDX1 ASI_Note_Index DLR14 Currency 14 463 CREATDDT1 ASI_Created_Date DT Date 8 464 MODIFDT1 ASI_Modified_Date DT Date 8 465 PHONE31 ASI_Phone_3 Phone_Number String 14 466 ITEMDESC1 ASI_Item_Description STR50 String 50 467 ITMTSHID1 ASI_Item_Tax_Schedule_ID STR15_LBAU String 15 468 PRCLEVEL11 ASI_PriceLevel2 STR10_LBAU String 10 469 DECPLQTY1 ASI_Decimal_Places_QTYS DDL_Decimal_Places_QTYS Integer 0 470 DECPLCUR1 ASI_Decimal_Places_Currency DDL_Decimal_Places_Dollars Integer 0 471 ITEMCODE1 ASI_Item_Code STR15 String 15 472 ReqShipDate1 ASI_Requested_Ship_Date DT Date 8 473 FUFILDAT1 ASI_Fulfillment_Date DT Date 8 474 ACTLSHIP1 ASI_Actual_Ship_Date DT Date 8 475 PRCLEVEL111 ASI_PriceLevel3 STR10_LBAU String 10 476 LOCNCODE1 ASI_Location_Code STR10_Location_Code String 10 477 MRKDNAMT1 ASI_Markdown_Amount DLR17_RBS0_UTR$ Currency 17 478 SHIPMTHD11 ASI_Shipping_Method2 STR15_Shipping_Method String 15 479 TRDISAMT1 ASI_Trade_Discount_Amount DLR17_RBS0_UTR$ Currency 17 480 EXTDCOST1 ASI_Extended_Cost DLR17_RBS0_UTR$ Currency 17 481 TXBTXAMT1 ASI_Taxable_Tax_Amount DLR19_RBSO_UTR$ Currency 19 482 TAXAMNT1 ASI_Tax_Amount DLR17_RBS0_UTR$ Currency 17 483 SALSTERR11 ASI_Sales_Territory2 STR15_Sales_Territory String 15 484 SLPRSNID11 ASI_Salesperson_ID2 STR15_Salesperson_ID String 15 485 TRXSORCE1 ASI_TRX_Source STR13 String 13 486 COMMNTID1 ASI_Comment_ID STR15_Comment_ID String 15 487 CREATDDT11 ASI_Created_Date2 DT Date 8 488 MODIFDT11 ASI_Modified_Date2 DT Date 8 489 ORMRKDAM1 ASI_Originating_Markdown_Amount DLR17_RBS0_UTR$ Currency 17 490 ORTDISAM1 ASI_Originating_Trade_Discount_Amount DLR17_RBS0_UTR$ Currency 17 491 BSIVCTTL1 ASI_Based_On_Invoice_Total YN Boolean 0 492 OREXTCST1 ASI_Originating_Extended_Cost DLR17_RBS0_UTR$ Currency 17 493 OTAXTAMT1 ASI_Originating_Taxable_Tax_Amount DLR17_RBS0_UTR$ Currency 17 494 ORTAXAMT1 ASI_Originating_Tax_Amount DLR17_RBS0_UTR$ Currency 17 495 NOTEINDX11 ASI_Note_Index2 DLR14 Currency 14 496 ASI_Currency_Index ASI_Currency_Index INT3 Integer 3 497 SOPLNERR1 ASI_SOP_LINE_Errors_MSLB ML_SOP_LINE_Errors Long Integer 0 498 LOCNCODE11 ASI_Location_Code2 STR10_Location_Code String 10 499 DOCNCORR1 ASI_Document_Number_Corrected Document_Number String 20 500 TAXSCHID2 ASI_Tax_Schedule_ID_2 STR15_Tax_Schedule_ID String 15 501 PRSTADCD2 ASI_Primary_Shipto_Address_Code_2 STR15_LBAU String 15 502 ShipToName1 ASI_ShipToName STR64_Customer_Name String 64 503 CNTCPRSN2 ASI_Contact_Person_2 STR60 String 60 504 ADDRESS111 ASI_Address_12 STR60 String 60 505 ADDRESS211 ASI_Address_22 STR60 String 60 506 ADDRESS311 ASI_Address_32 STR60 String 60 507 CITY11 ASI_City2 STR35 String 35 508 STATE11 ASI_State2 STR30_State String 29 509 ZIPCODE1 ASI_Zip_Code STR10 String 10 510 COUNTRY11 ASI_Country2 STR60 String 60 511 PHONE1 Phone 1 Phone_Number String 14 512 PHONE2 Phone 2 Phone_Number String 14 513 PHONE311 ASI_Phone_32 Phone_Number String 14 514 FAXNUMBR1 ASI_Fax_Number STR14_FAX String 14 515 EXCEPTIONALDEMAND Exceptional Demand CB_Exceptional_Demand Boolean 0 516 ASI_Tax_Schedule_Source ASI_Tax_Schedule_Source ASI_Tax_Schedule_Source Integer 0 517 CONTNBR Contract Number STR11 String 11 518 CONTSTARTDTE Contract Start Date DATE Date 6 519 CONTENDDTE Contract End Date DATE_L Date 0 520 CONTITEMNBR Contract Item Number STR30_Item_Number String 30 521 CONTSERIALNBR Contract Serial Number STR20_LBAU String 20 522 SOPSTATUS SOP Status INT Integer 0 523 CUSTPRIORITY Customer Priority DDL_CustomerPriority Integer 0 524 ORDERFULFILLDEFAULT Order Fulfillment Shortage Default DDL_OrderFulfillDefault Integer 0 525 UMSCHDSC U Of M Schedule Description STR30 String 30 526 SHIPCOMPLETE Ship Complete Document CB_ShipComplete Boolean 0 527 SHIPCOMPLETE1 ASI_Ship_Complete_Document CB_ShipComplete Boolean 0