SmartList Payables Transactions (ASIEXP09)

azurecurve Products SmartList (1493)PathnameSmartList Payables Transactions (ASIEXP09)

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

Display Name: SmartList Payables Transactions
Physical Name: ASIEXP09
Technical Name: ASI_PM_Document_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
2	BACHNUMB	Batch Number	String	STR15_LBAU	15
3	BCHSOURC	Batch Source	String	STR15	15
4	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SmartList Payables Transactions'].VENDORID AS 'SmartList Payables Transactions-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SmartList Payables Transactions'].VENDORID = ['PM Vendor Master File'].VENDORID
5	DOCNUMBR	Document Number	String	STR20_Document_Number	20
6	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
7	ASI_Document_Status	ASI_Document_Status	Integer	INT	0
8	SOURCDOC	Source Document	String	STR10_Source_Document	10
	Key to the Source Document Master (SY00900). Click to show/hide SELECT ['SmartList Payables Transactions'].SOURCDOC AS 'SmartList Payables Transactions-Source Document' ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN SY00900 AS ['Source Document Master'] ON ['SmartList Payables Transactions'].SOURCDOC = ['Source Document Master'].SOURCDOC
9	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
10	DOCDATE	Document Date	Date	DT	8
11	PSTGDATE	Posting Date	Date	DT	8
12	VADDCDPR	Vendor Address Code - Primary	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Payables Transactions'].VADDCDPR AS 'SmartList Payables Transactions-Vendor Address Code - Primary' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Payables Transactions'].VADDCDPR = ['PM Address MSTR'].ADRSCODE AND ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
13	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList Payables Transactions'].PYMTRMID AS 'SmartList Payables Transactions-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList Payables Transactions'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
14	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 Payables Transactions'].TAXSCHID AS 'SmartList Payables Transactions-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Payables Transactions'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
15	DUEDATE	Due Date	Date	DT	8
16	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
17	DISCDATE	Discount Date	Date	DT	8
18	PRCHAMNT	Purchases Amount	Currency	DLR17_RBS0_UTR$	17
19	CHRGAMNT	Charge Amount	Currency	DLR19_RBSO_UTR$	19
20	CASHAMNT	Cash Amount	Currency	DLR19_RBS0_UTR$	19
21	CAMCBKID	Cash Amount Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList Payables Transactions'].CAMCBKID AS 'SmartList Payables Transactions-Cash Amount Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList Payables Transactions'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
22	CDOCNMBR	Cash Document Number	String	STR20_Document_Number	20
23	CAMTDATE	Cash Amount Date	Date	DT	8
24	CAMPMTNM	Cash Amount Payment Number	String	STR20_LBAU	20
25	CHEKAMNT	Check Amount	Currency	DLR19_RBS0_UTR$	19
26	CHAMCBID	Check Amount Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList Payables Transactions'].CHAMCBID AS 'SmartList Payables Transactions-Check Amount Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList Payables Transactions'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
27	CHEKDATE	Check Date	Date	DATE	6
28	CAMPYNBR	Check Amount Payment Number	String	STR20_LBAU	20
29	CRCRDAMT	Credit Card Amount	Currency	DLR19_RBS0_UTR$	19
30	CCAMPYNM	Credit Card Amount Payment Number	String	STR20_LBAU	20
31	CHEKNMBR	Check Number	String	STR20_Document_Number	20
32	CARDNAME	Card Name	String	STR15_Card_Name	15
33	CCRCTNUM	Credit Card Receipt Number	String	STR20_Document_Number	20
34	CRCARDDT	Credit Card Date	Date	DATE	6
35	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Payables Transactions'].CURNCYID AS 'SmartList Payables Transactions-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Payables Transactions'].CURNCYID = ['Currency Setup'].CURNCYID
36	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList Payables Transactions'].CHEKBKID AS 'SmartList Payables Transactions-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList Payables Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
37	TRXDSCRN	Transaction Description	String	STR30	30
38	UN1099AM	Unapplied 1099 Amount	Currency	DLR17_RBS0_UTR$	17
39	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
40	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
41	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
42	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
43	MSCCHAMT	Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
44	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
45	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList Payables Transactions'].SHIPMTHD AS 'SmartList Payables Transactions-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList Payables Transactions'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
46	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
47	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
48	APDSTKAM	Applied Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
49	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
50	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
51	TXENGCLD	Tax Engine Called	Boolean	YN	0
52	PMWRKMSG	PM WORK Messages	Long Integer	ML_PM_WORK_Messages	0
53	PMDSTMSG	PM Distribution Messages	Long Integer	ML_PM_Distribution_Messages	0
54	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
55	PGRAMSBJ	Percent Of Gross Amount Subject	Integer	INT5_RBS2_U%	5
56	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
57	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
58	POSTED	Posted	Boolean	True/False	0
59	APPLDAMT	Applied Amount	Currency	DLR17_RBS0_STR$	17
60	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
61	CNTRLTYP	Control Type	Integer	INT1	1
62	MODIFDT	Modified Date	Date	DT	8
63	MDFUSRID	Modified User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Payables Transactions'].MDFUSRID AS 'SmartList Payables Transactions-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Payables Transactions'].MDFUSRID = ['Users Master'].USERID
64	POSTEDDT	Posted Date	Date	DATE	6
65	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Payables Transactions'].PTDUSRID AS 'SmartList Payables Transactions-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Payables Transactions'].PTDUSRID = ['Users Master'].USERID
66	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Payables Transactions'].NOTEINDX AS 'SmartList Payables Transactions-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Payables Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX
67	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
68	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
69	BKTPURAM	Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
70	PCHSCHID	Purchase Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Payables Transactions'].PCHSCHID AS 'SmartList Payables Transactions-Purchase Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Payables Transactions'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
71	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Payables Transactions'].FRTSCHID AS 'SmartList Payables Transactions-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Payables Transactions'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Payables Transactions'].MSCSCHID AS 'SmartList Payables Transactions-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Payables Transactions'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73	PRINTED	Printed	Boolean	CB	0
	Click to show/hide Printed flag 0 Record has not been printed. 1 Record has been printed.
74	PRCTDISC	Percent Discount	Integer	INT5_%2	5
75	RETNAGAM	Retainage Amount	Currency	DLR17_RBS0_UTR$	17
76	ICTRX	IC TRX	Boolean	CB_IC_TRX	0
	Click to show/hide Intercompany flag 0 Not intercompany. 1 Intercompany
77	ICDISTS	ICDists	Boolean	Boolean	0
	Click to show/hide Intercompany distirubtions 0 Not intercompany. 1 Intercompany distributions present.
78	PMICMSGS	ICMessages	Long Integer	ML_IC_Post_Messages	0
	Error messages from posting an Intercompany Transaction. Click to show/hide Intercompany posting error messages 1 The currency ID is missing. 2 A destination company does not have access to this currency ID. 3 The currency ID is inactive for a destination company. 4 A rate type ID is missing for a destination company. 5 Rate type ID is not associated with the currency ID for a destination company. 6 An exchange table ID is missing for a destination company. 7 A destination company does not have access to an exchange table ID. 8 An exchange table ID is inactive for a destination company. 9 An exchange rate does not exist for a destination company. 10 An exchange rate has expired for a destination company. 11 Cannot post intercompany multicurrency transactions to a recurring batch. 12 A rounding account missing for a destination company. 13 A distribution type is invalid for a destination company distribution. 14 A destination company distribution contains MDA information. 15 A destination company ID does not exist; please select another company ID. 16 The user does not have access to a destination company. 17 A destination company does not have a functional currency set up. 18 Destination functional currency doesn't match originating functional currency. 19 No relationship exists between originating company and a destination company. 20 Due To / Due From account not specified. 21 The rounding account does not exist for the originating company. 22 Unknown SQL error occurred. 23 Intrastat information is missing or invalid. 24 The goods value for Intrastat exceeds the document total. 25 Transaction has successfully posted.
79	Tax_Date	Tax Date	Date	DT	8
80	DISCAMNT	Discount Amount	Currency	DLR17_RBS0_STR$	17
81	TRXSORCE	TRX Source	String	STR13	13
82	VOIDED	Voided	Boolean	CB	0
83	HOLD	Hold	Boolean	CB_Hold	0
84	DINVPDOF	Date Invoice Paid Off	Date	DT	8
85	PYENTTYP	Payment Entry Type	Integer	GB	0
86	TTLPYMTS	Total Payments	Currency	DLR19_RBS0_UTR$	19
87	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
88	VOIDPDATE	Void GL Posting Date	Date	DT	8
89	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
90	DCSTATUS	Document Status	Integer	DDL_Doc_Status	0
91	PMNTNMBR	Payment Number	String	STR20_LBAU	20
92	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Payables Transactions'].CURRNIDX AS 'SmartList Payables Transactions-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Payables Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX
93	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SmartList Payables Transactions'].RATETPID AS 'SmartList Payables Transactions-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList Payables Transactions'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
94	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['SmartList Payables Transactions'].EXGTBLID AS 'SmartList Payables Transactions-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['SmartList Payables Transactions'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
95	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
96	EXCHDATE	Exchange Date	Date	DT_Date	6
97	TIME1	Time	Time	TM6	6
98	RTCLCMTD	Rate Calculation Method	Integer	GB	0
99	ORCTRXAM	Originating Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
100	OPURAMT	Originating Purchases Amount	Currency	DLR17_RBS0_UTR$	17
101	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
102	OMISCAMT	Originating Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
103	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
104	ORCASAMT	Originating Cash Amount	Currency	DLR19_RBSO_UTR$	19
105	ORCHKAMT	Originating Check Amount	Currency	DLR19_RBSO_UTR$	19
106	ORCHKTTL	Originating Check Total	Currency	DLR19_RBS0_UTR$	19
107	ORCCDAMT	Originating Credit Card Amount	Currency	DLR19_RBSO_UTR$	19
108	ORAPPAMT	Originating Applied Amount	Currency	DLR17_RBS0_STR$	17
109	ORDISTKN	Originating Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
110	ORDATKN	Originating Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
111	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
112	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
113	ORWROFAM	Originating Write Off Amount	Currency	DLR17_RBS0_STR$	17
114	OBKPURAMT	Originating Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
115	ORBKTFRT	Originating Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
116	ORBKTMSC	Originating Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
117	UNGANLOS	Unrealized Gain-Loss Amount	Currency	DLR19_$S2	19
118	RMMCERRS	RM MC Posting Error Messages	Long Integer	RM_MC_Posting_Error_Messages	0
119	OCHGAMT	Originating Charge Amount	Currency	DLR19_RBSO_UTR$	19
120	ORDOCAMT	Originating Document Amount	Currency	DLR17_RBS0_STR$	17
121	ODISAMTAV	Originating Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
122	ORGAPDISCTKN	Originating Applied Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
123	OTOTPAY	Originating Total Payments	Currency	DLR19_RBS0_UTR$	19
124	OR1099AM	Originating 1099 Amount	Currency	DLR17_RBS0_UTR$	17
125	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
126	MCTRXSTT	MC Transaction State	Integer	INT1	1
127	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
128	VNDCHKNM	Vendor Check Name	String	STR64_Vendor_Name	64
129	VENDSHNM	Vendor Short Name	String	STR15	15
130	VADCDPAD	Vendor Address Code - Purchase Address	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Payables Transactions'].VADCDPAD AS 'SmartList Payables Transactions-Vendor Address Code - Purchase Address' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Payables Transactions'].VADCDPAD = ['PM Address MSTR'].ADRSCODE AND ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
131	VADCDSFR	Vendor Address Code - Ship From	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Payables Transactions'].VADCDSFR AS 'SmartList Payables Transactions-Vendor Address Code - Ship From' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Payables Transactions'].VADCDSFR = ['PM Address MSTR'].ADRSCODE AND ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
132	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList Payables Transactions'].VADCDTRO AS 'SmartList Payables Transactions-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList Payables Transactions'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID
133	VNDCLSID	Vendor Class ID	String	STR10_Class_ID	10
	Key to the PM Class Master File (PM00100). Click to show/hide SELECT ['SmartList Payables Transactions'].VNDCLSID AS 'SmartList Payables Transactions-Vendor Class ID' ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN PM00100 AS ['PM Class Master File'] ON ['SmartList Payables Transactions'].VNDCLSID = ['PM Class Master File'].VNDCLSID
134	VNDCNTCT	Vendor Contact	String	STR60	60
135	ADDRESS1	Address 1	String	STR60	60
136	ADDRESS2	Address 2	String	STR60	60
137	ADDRESS3	Address 3	String	STR60	60
138	CITY	City	String	STR35	35
139	STATE	State	String	STR30_State	29
140	ZIPCODE	Zip Code	String	STR10	10
141	COUNTRY	Country	String	STR60	60
142	PHNUMBR1	Phone Number 1	String	Phone_Number	14
143	PHNUMBR2	Phone Number 2	String	Phone_Number	14
144	FAXNUMBR	Fax Number	String	STR14_FAX	14
145	UPSZONE	UPS Zone	String	STR3	3
146	ACNMVNDR	Account Number With Vendor	String	STR20	20
147	TXIDNMBR	Tax ID Number	String	Tax_ID_Number	11
148	VENDSTTS	Vendor Status	Integer	DDL_Vendor_Status	0
149	TXRGNNUM	Tax Registration Number	String	STR25	25
150	PARVENID	Parent Vendor ID	String	STR_15_Vendor_ID	15
151	TRDDISCT	Trade Discount	Integer	INT4_%2	4
152	TEN99TYPE	1099 Type	Integer	1099_Type	0
153	MINORDER	Minimum Order	Currency	DLR17_$U2	17
154	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
155	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
156	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
157	MXIAFVND	Maximum Invoice Amount For Vendors	Integer	GB	0
158	MAXINDLR	Maximum Invoice Dollar	Currency	DLR17_$U2	17
159	COMMENT1	Comment1	String	STR30	30
160	COMMENT2	Comment2	String	STR30	30
161	USERDEF1	User Defined 1	String	STR20	20
162	USERDEF2	User Defined 2	String	STR20	20
163	CRLMTDLR	Credit Limit Dollar	Currency	DLR17_$U2	17
164	PYMNTPRI	Payment Priority	String	STR3	3
165	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
166	KGLDSTHS	Keep GL Dist History	Boolean	CB_Keep_GL_Dist_History	0
167	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
168	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
169	PTCSHACF	Post To Cash Account From	Integer	GB	0
170	CREDTLMT	Credit Limit	Integer	GB	0
171	WRITEOFF	Writeoff	Integer	GB	0
172	MXWOFAMT	Maximum Write Off Amount	Currency	DLR17_$U2	17
173	SBPPSDED	Subject To PPS Deductions	Boolean	CB_Subject_To_PPS_Deductions	0
174	DXVARNUM	Deduction Exemption/Variation Number	String	STR25	25
175	CRTCOMDT	Certificate Commencing Date	Date	DT	8
176	CRTEXPDT	Certificate Expiration Date	Date	DT	8
177	RTOBUTKN	Reporting Obligation Undertaken	Boolean	CB_Reporting_Obligation	0
178	XPDTOBLG	Expiration Date Obligation	Boolean	CB_Expiration_Date_Obligation	0
179	PRSPAYEE	Prescribed Payee	Boolean	CB_Prescribed_Payee	0
180	PMAPINDX	PM AP Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMAPINDX AS 'SmartList Payables Transactions-PM AP Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMAPINDX = ['Account Index Master'].ACTINDX
181	PMCSHIDX	PM Cash Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMCSHIDX AS 'SmartList Payables Transactions-PM Cash Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMCSHIDX = ['Account Index Master'].ACTINDX
182	PMDAVIDX	PM Discount Available Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMDAVIDX AS 'SmartList Payables Transactions-PM Discount Available Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMDAVIDX = ['Account Index Master'].ACTINDX
183	PMDTKIDX	PM Discount Taken Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMDTKIDX AS 'SmartList Payables Transactions-PM Discount Taken Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMDTKIDX = ['Account Index Master'].ACTINDX
184	PMFINIDX	PM Finance Charge Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMFINIDX AS 'SmartList Payables Transactions-PM Finance Charge Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMFINIDX = ['Account Index Master'].ACTINDX
185	PMMSCHIX	PM Misc Charges Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMMSCHIX AS 'SmartList Payables Transactions-PM Misc Charges Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMMSCHIX = ['Account Index Master'].ACTINDX
186	PMFRTIDX	PM Freight Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMFRTIDX AS 'SmartList Payables Transactions-PM Freight Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMFRTIDX = ['Account Index Master'].ACTINDX
187	PMTAXIDX	PM Tax Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMTAXIDX AS 'SmartList Payables Transactions-PM Tax Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMTAXIDX = ['Account Index Master'].ACTINDX
188	PMWRTIDX	PM Write Offs Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMWRTIDX AS 'SmartList Payables Transactions-PM Write Offs Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMWRTIDX = ['Account Index Master'].ACTINDX
189	PMPRCHIX	PM Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMPRCHIX AS 'SmartList Payables Transactions-PM Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMPRCHIX = ['Account Index Master'].ACTINDX
190	PMRTNGIX	PM Retainage Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMRTNGIX AS 'SmartList Payables Transactions-PM Retainage Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMRTNGIX = ['Account Index Master'].ACTINDX
191	PMTDSCIX	PM Trade Discount Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PMTDSCIX AS 'SmartList Payables Transactions-PM Trade Discount Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PMTDSCIX = ['Account Index Master'].ACTINDX
192	ACPURIDX	Accrued Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].ACPURIDX AS 'SmartList Payables Transactions-Accrued Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].ACPURIDX = ['Account Index Master'].ACTINDX
193	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Payables Transactions'].PURPVIDX AS 'SmartList Payables Transactions-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP09 AS ['SmartList Payables Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Payables Transactions'].PURPVIDX = ['Account Index Master'].ACTINDX
194	Revalue_Vendor	Revalue Vendor	Boolean	CB Revalue Vendor	0
195	Post_Results_To	Post Results To	Integer	GB	0
196	FREEONBOARD	Free On Board	Integer	DDL_Free_On_Board	0
197	HIESTBAL	Highest Balance	Currency	DLR17_RBS0_UTR$	17
198	CURRBLNC	Current Balance	Currency	DLR19_RBS0_STR$	19
199	NOINVYTD	Number of Invoices YTD	Long Integer	LI_9U0	9
200	NOINVLIF	Number of Invoices LIFE	Long Integer	LI_9U0	9
201	NOINVLYR	Number of Invoices LYR	Long Integer	LI_9U0	9
202	NOPINYTD	Number of Paid Invoices YTD	Long Integer	LI_9U0	9
203	NOPILIFE	Number of Paid Invoices LIFE	Long Integer	LI_9U0	9
204	AMBLDTYD	Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
205	AMBLDLIF	Amount Billed LIFE	Currency	DLR19_RBS0_STR$	19
206	AMBLDLYR	Amount Billed LYR	Currency	DLR19_RBS0_STR$	19
207	AMTPDYTD	Amount Paid YTD	Currency	DLR19_RBS0_STR$	19
208	AMTPDLYR	Amount Paid LYR	Currency	DLR19_RBS0_STR$	19
209	AMTPDLIF	Amount Paid LIFE	Currency	DLR19_RBS0_STR$	19
210	TEN99ALIF	1099 Amount LIFE	Currency	DLR19_RBS0_STR$	19
211	TEN99ALYR	1099 Amount LYR	Currency	DLR19_RBS0_STR$	19
212	TEN99AYTD	1099 Amount YTD	Currency	DLR19_RBS0_STR$	19
213	DISAVYTD	Discount Available YTD	Currency	DLR19_RBS0_STR$	19
214	DISAVLIF	Discount Available LIFE	Currency	DLR19_RBS0_STR$	19
215	DISAVLYR	Discount Available LYR	Currency	DLR19_RBS0_STR$	19
216	DISTKYTD	Discount Taken YTD	Currency	DLR19_RBS0_STR$	19
217	DISTKNLF	Discount Taken LIFE	Currency	DLR19_RBS0_STR$	19
218	DISTKLYR	Discount Taken LYR	Currency	DLR19_RBS0_STR$	19
219	DISLSYTD	Discount Lost YTD	Currency	DLR19_RBS0_STR$	19
220	DISLSTLF	Discount Lost LIFE	Currency	DLR19_RBS0_STR$	19
221	DISLSLYR	Discount Lost LYR	Currency	DLR19_RBS0_STR$	19
222	FINCHLIF	Finance Charge LIFE	Currency	DLR19_RBS0_STR$	19
223	FINCHLYR	Finance Charge LYR	Currency	DLR19_RBS0_STR$	19
224	FINCHYTD	Finance Charge YTD	Currency	DLR19_RBS0_STR$	19
225	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
226	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
227	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
228	RTRNSLIF	Returns LIFE	Currency	DLR19_RBS0_STR$	19
229	RTRNSLYR	Returns LYR	Currency	DLR19_RBS0_STR$	19
230	RTRNSYTD	Returns YTD	Currency	DLR19_RBS0_STR$	19
231	TRDTKLIF	Trade Discounts Taken LIFE	Currency	DLR19_RBSO_STR$	19
232	TRDTLYR	Trade Discounts Taken LYR	Currency	DLR19_RBSO_STR$	19
233	TRDTYTD	Trade Discounts Taken YTD	Currency	DLR19_RBSO_STR$	19
234	NFNCHLIF	Number of Finance Charges LIFE	Long Integer	LI_9U0	9
235	NFNCHLYR	Number of Finance Charges LYR	Long Integer	LI_9U0	9
236	NFNCHYTD	Number of Finance Charges YTD	Long Integer	LI_9U0	9
237	RTNGOWED	Retainage Owed	Currency	DLR17_RBS0_STR$	17
238	LSTCHNUM	Last Check Number	String	Check_Number	20
239	LSTCHKDT	Last Check Date	Date	DT	8
240	LSTCHAMT	Last Check Amount	Currency	DLR17_RBS0_UTR$	17
241	LSTINNUM	Last Invoice Number	String	STR20	20
242	LSTINVAM	Last Invoice Amount	Currency	DLR17_RBS0_UTR$	17
243	LSTPURDT	Last Purchase Date	Date	DT	8
244	FSTPURDT	First Purchase Date	Date	DT	8
245	CURUNPBN	Current Unapplied Payment Balance	Currency	DLR17_RBS0_UTR$	17
246	UNPDFNCH	Unpaid Finance Charges	Currency	DLR17_RBS0_UTR$	17
247	DYCHTCLR	Days Checks To Clear	Integer	INT3_U0	3
248	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
249	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
250	ACCRDINV	Accured Inventory	Currency	DLR17_RBS0_STR$	17
251	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
252	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
253	DOCFMTID	Document Format ID	String	STR15_LBU	15
254	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
255	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
256	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
257	PHONE3	Phone 3	String	Phone_Number3	14
258	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
259	Withholding_LIFE	Withholding LIFE	Currency	DLR19_RBS0_STR$	19
260	WITHLYR	Withholding LYR	Currency	DLR19_RBS0_STR$	19
261	WITHYTD	Withholding YTD	Currency	DLR19_RBS0_STR$	19
262	APLYWITH	Apply Withholding	Boolean	Boolean	0
263	CORRCTN	Correction	Boolean	CB_Correction	0
264	DocPrinted	DocPrinted	Boolean	CB_DocPrinted	0
	Click to show/hide Document Printed flag 0 Record has not been printed. 1 Record has been printed.
265	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.
266	Electronic	Electronic	Boolean	CB_Electronic	0
267	PRCHDATE	Purchase Date	Date	DT	8
268	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
269	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
270	BNKRCAMT	Bank Receipts Amount	Currency	DLR17_RBS0_STR$	17
271	CORRNXST	Correction to Nonexisting Transaction	Boolean	Boolean	0
272	PMWRKMS2	PM WORK Messages 2	Long Integer	ML_PM_WORK_Messages_2	0
273	VCHRNCOR	Voucher Number Corrected	String	STR20_LBAU	20
274	VNDCHKNM1	ASI_Vendor_Check_Name	String	STR64_Vendor_Name	64
275	VADDCDPR1	ASI_Vendor_Address_Code_Primary	String	STR15_Address_Code	15
276	PYMTRMID1	ASI_Payment_Terms_ID	String	STR20_Payment_Terms_ID	20
277	SHIPMTHD1	ASI_Shipping_Method	String	STR15_Shipping_Method	15
278	TAXSCHID1	ASI_Tax_Schedule_ID	String	STR15_Tax_Schedule_ID	15
279	CURNCYID1	ASI_Currency_ID	String	STR15_Currency_ID	15
280	HOLD1	ASI_Hold	Boolean	CB_Hold	0
281	PPSTAXRT1	ASI_PPS_Tax_Rate	Integer	INT5_%2	5
282	NOTEINDX1	ASI_Note_Index	Currency	DLR14	14
283	CHEKBKID1	ASI_Checkbook_ID	String	STR15_Checkbook_ID	15
284	MODIFDT1	ASI_Modified_Date	Date	DT	8
285	CREATDDT1	ASI_Created_Date	Date	DT	8
286	RATETPID1	ASI_Rate_Type_ID	String	STR15_Rate_Type_ID	15
287	TaxInvRecvd1	ASI_Tax_Invoice_Received	Boolean	CB_Tax_Invoice_Received	0
288	VADCDTRO1	ASI_Vendor_Address_Code_Remit_To	String	STR15_Address_Code	15

azurecurve Products SmartList (1493)PathnameSmartList Payables Transactions (ASIEXP09)

Leave a Reply Cancel reply