SmartList PM Vendor Master File (ASIEXP03)

azurecurve Products SmartList (1493)PathnameSmartList PM Vendor Master File (ASIEXP03)

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

Display Name: SmartList PM Vendor Master File
Physical Name: ASIEXP03
Technical Name: ASI_PM_Vendor_MSTR_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	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SmartList PM Vendor Master File'].VENDORID AS 'SmartList PM Vendor Master File-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SmartList PM Vendor Master File'].VENDORID = ['PM Vendor Master File'].VENDORID
3	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
4	VNDCHKNM	Vendor Check Name	String	STR64_Vendor_Name	64
5	VENDSHNM	Vendor Short Name	String	STR15	15
6	VADDCDPR	Vendor Address Code - Primary	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['SmartList PM Vendor Master File'].VADDCDPR AS 'SmartList PM Vendor Master File-Vendor Address Code - Primary' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList PM Vendor Master File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE AND ['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
7	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 PM Vendor Master File'].VADCDPAD AS 'SmartList PM Vendor Master File-Vendor Address Code - Purchase Address' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList PM Vendor Master File'].VADCDPAD = ['PM Address MSTR'].ADRSCODE AND ['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
8	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 PM Vendor Master File'].VADCDSFR AS 'SmartList PM Vendor Master File-Vendor Address Code - Ship From' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList PM Vendor Master File'].VADCDSFR = ['PM Address MSTR'].ADRSCODE AND ['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
9	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 PM Vendor Master File'].VADCDTRO AS 'SmartList PM Vendor Master File-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['SmartList PM Vendor Master File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['SmartList PM Vendor Master File'].VENDORID = ['PM Address MSTR'].VENDORID
10	VNDCLSID	Vendor Class ID	String	STR10_Class_ID	10
	Key to the PM Class Master File (PM00100). Click to show/hide SELECT ['SmartList PM Vendor Master File'].VNDCLSID AS 'SmartList PM Vendor Master File-Vendor Class ID' ,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN PM00100 AS ['PM Class Master File'] ON ['SmartList PM Vendor Master File'].VNDCLSID = ['PM Class Master File'].VNDCLSID
11	VNDCNTCT	Vendor Contact	String	STR60	60
12	ADDRESS1	Address 1	String	STR60	60
13	ADDRESS2	Address 2	String	STR60	60
14	ADDRESS3	Address 3	String	STR60	60
15	CITY	City	String	STR35	35
16	STATE	State	String	STR30_State	29
17	ZIPCODE	Zip Code	String	STR10	10
18	COUNTRY	Country	String	STR60	60
19	PHNUMBR1	Phone Number 1	String	Phone_Number	14
20	PHNUMBR2	Phone Number 2	String	Phone_Number	14
21	FAXNUMBR	Fax Number	String	STR14_FAX	14
22	UPSZONE	UPS Zone	String	STR3	3
23	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList PM Vendor Master File'].SHIPMTHD AS 'SmartList PM Vendor Master File-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList PM Vendor Master File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
24	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 PM Vendor Master File'].TAXSCHID AS 'SmartList PM Vendor Master File-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList PM Vendor Master File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
25	ACNMVNDR	Account Number With Vendor	String	STR20	20
26	TXIDNMBR	Tax ID Number	String	Tax_ID_Number	11
27	VENDSTTS	Vendor Status	Integer	DDL_Vendor_Status	0
28	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList PM Vendor Master File'].CURNCYID AS 'SmartList PM Vendor Master File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList PM Vendor Master File'].CURNCYID = ['Currency Setup'].CURNCYID
29	TXRGNNUM	Tax Registration Number	String	STR25	25
30	PARVENID	Parent Vendor ID	String	STR_15_Vendor_ID	15
31	TRDDISCT	Trade Discount	Integer	INT4_%2	4
32	TEN99TYPE	1099 Type	Integer	1099_Type	0
33	MINORDER	Minimum Order	Currency	DLR17_$U2	17
34	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PYMTRMID AS 'SmartList PM Vendor Master File-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList PM Vendor Master File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
35	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
36	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
37	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
38	MXIAFVND	Maximum Invoice Amount For Vendors	Integer	GB	0
39	MAXINDLR	Maximum Invoice Dollar	Currency	DLR17_$U2	17
40	COMMENT1	Comment1	String	STR30	30
41	COMMENT2	Comment2	String	STR30	30
42	USERDEF1	User Defined 1	String	STR20	20
43	USERDEF2	User Defined 2	String	STR20	20
44	CRLMTDLR	Credit Limit Dollar	Currency	DLR17_$U2	17
45	PYMNTPRI	Payment Priority	String	STR3	3
46	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
47	KGLDSTHS	Keep GL Dist History	Boolean	CB_Keep_GL_Dist_History	0
48	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
49	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
50	HOLD	Hold	Boolean	CB_Hold	0
51	PTCSHACF	Post To Cash Account From	Integer	GB	0
52	CREDTLMT	Credit Limit	Integer	GB	0
53	WRITEOFF	Writeoff	Integer	GB	0
54	MXWOFAMT	Maximum Write Off Amount	Currency	DLR17_$U2	17
55	SBPPSDED	Subject To PPS Deductions	Boolean	CB_Subject_To_PPS_Deductions	0
56	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
57	DXVARNUM	Deduction Exemption/Variation Number	String	STR25	25
58	CRTCOMDT	Certificate Commencing Date	Date	DT	8
59	CRTEXPDT	Certificate Expiration Date	Date	DT	8
60	RTOBUTKN	Reporting Obligation Undertaken	Boolean	CB_Reporting_Obligation	0
61	XPDTOBLG	Expiration Date Obligation	Boolean	CB_Expiration_Date_Obligation	0
62	PRSPAYEE	Prescribed Payee	Boolean	CB_Prescribed_Payee	0
63	PMAPINDX	PM AP Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMAPINDX AS 'SmartList PM Vendor Master File-PM AP Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMAPINDX = ['Account Index Master'].ACTINDX
64	PMCSHIDX	PM Cash Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMCSHIDX AS 'SmartList PM Vendor Master File-PM Cash Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMCSHIDX = ['Account Index Master'].ACTINDX
65	PMDAVIDX	PM Discount Available Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMDAVIDX AS 'SmartList PM Vendor Master File-PM Discount Available Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMDAVIDX = ['Account Index Master'].ACTINDX
66	PMDTKIDX	PM Discount Taken Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMDTKIDX AS 'SmartList PM Vendor Master File-PM Discount Taken Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMDTKIDX = ['Account Index Master'].ACTINDX
67	PMFINIDX	PM Finance Charge Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMFINIDX AS 'SmartList PM Vendor Master File-PM Finance Charge Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMFINIDX = ['Account Index Master'].ACTINDX
68	PMMSCHIX	PM Misc Charges Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMMSCHIX AS 'SmartList PM Vendor Master File-PM Misc Charges Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMMSCHIX = ['Account Index Master'].ACTINDX
69	PMFRTIDX	PM Freight Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMFRTIDX AS 'SmartList PM Vendor Master File-PM Freight Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMFRTIDX = ['Account Index Master'].ACTINDX
70	PMTAXIDX	PM Tax Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMTAXIDX AS 'SmartList PM Vendor Master File-PM Tax Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMTAXIDX = ['Account Index Master'].ACTINDX
71	PMWRTIDX	PM Write Offs Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMWRTIDX AS 'SmartList PM Vendor Master File-PM Write Offs Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMWRTIDX = ['Account Index Master'].ACTINDX
72	PMPRCHIX	PM Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMPRCHIX AS 'SmartList PM Vendor Master File-PM Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMPRCHIX = ['Account Index Master'].ACTINDX
73	PMRTNGIX	PM Retainage Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMRTNGIX AS 'SmartList PM Vendor Master File-PM Retainage Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMRTNGIX = ['Account Index Master'].ACTINDX
74	PMTDSCIX	PM Trade Discount Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PMTDSCIX AS 'SmartList PM Vendor Master File-PM Trade Discount Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PMTDSCIX = ['Account Index Master'].ACTINDX
75	ACPURIDX	Accrued Purchases Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].ACPURIDX AS 'SmartList PM Vendor Master File-Accrued Purchases Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].ACPURIDX = ['Account Index Master'].ACTINDX
76	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList PM Vendor Master File'].PURPVIDX AS 'SmartList PM Vendor Master File-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList PM Vendor Master File'].PURPVIDX = ['Account Index Master'].ACTINDX
77	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList PM Vendor Master File'].NOTEINDX AS 'SmartList PM Vendor Master File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList PM Vendor Master File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
78	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList PM Vendor Master File'].CHEKBKID AS 'SmartList PM Vendor Master File-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList PM Vendor Master File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
79	MODIFDT	Modified Date	Date	DT	8
80	CREATDDT	Created Date	Date	DT	8
81	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SmartList PM Vendor Master File'].RATETPID AS 'SmartList PM Vendor Master File-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP03 AS ['SmartList PM Vendor Master File'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList PM Vendor Master File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
82	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
83	HIESTBAL	Highest Balance	Currency	DLR17_RBS0_UTR$	17
84	CURRBLNC	Current Balance	Currency	DLR19_RBS0_STR$	19
85	NOINVYTD	Number of Invoices YTD	Long Integer	LI_9U0	9
86	NOINVLIF	Number of Invoices LIFE	Long Integer	LI_9U0	9
87	NOINVLYR	Number of Invoices LYR	Long Integer	LI_9U0	9
88	NOPINYTD	Number of Paid Invoices YTD	Long Integer	LI_9U0	9
89	NOPILIFE	Number of Paid Invoices LIFE	Long Integer	LI_9U0	9
90	AMBLDTYD	Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
91	AMBLDLIF	Amount Billed LIFE	Currency	DLR19_RBS0_STR$	19
92	AMBLDLYR	Amount Billed LYR	Currency	DLR19_RBS0_STR$	19
93	AMTPDYTD	Amount Paid YTD	Currency	DLR19_RBS0_STR$	19
94	AMTPDLIF	Amount Paid LIFE	Currency	DLR19_RBS0_STR$	19
95	AMTPDLYR	Amount Paid LYR	Currency	DLR19_RBS0_STR$	19
96	TEN99AYTD	1099 Amount YTD	Currency	DLR19_RBS0_STR$	19
97	TEN99ALIF	1099 Amount LIFE	Currency	DLR19_RBS0_STR$	19
98	TEN99ALYR	1099 Amount LYR	Currency	DLR19_RBS0_STR$	19
99	DISAVYTD	Discount Available YTD	Currency	DLR19_RBS0_STR$	19
100	DISAVLIF	Discount Available LIFE	Currency	DLR19_RBS0_STR$	19
101	DISAVLYR	Discount Available LYR	Currency	DLR19_RBS0_STR$	19
102	DISTKYTD	Discount Taken YTD	Currency	DLR19_RBS0_STR$	19
103	DISTKNLF	Discount Taken LIFE	Currency	DLR19_RBS0_STR$	19
104	DISTKLYR	Discount Taken LYR	Currency	DLR19_RBS0_STR$	19
105	DISLSYTD	Discount Lost YTD	Currency	DLR19_RBS0_STR$	19
106	DISLSTLF	Discount Lost LIFE	Currency	DLR19_RBS0_STR$	19
107	DISLSLYR	Discount Lost LYR	Currency	DLR19_RBS0_STR$	19
108	FINCHLIF	Finance Charge LIFE	Currency	DLR19_RBS0_STR$	19
109	FINCHLYR	Finance Charge LYR	Currency	DLR19_RBS0_STR$	19
110	FINCHYTD	Finance Charge YTD	Currency	DLR19_RBS0_STR$	19
111	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
112	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
113	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
114	RTRNSYTD	Returns YTD	Currency	DLR19_RBS0_STR$	19
115	RTRNSLIF	Returns LIFE	Currency	DLR19_RBS0_STR$	19
116	RTRNSLYR	Returns LYR	Currency	DLR19_RBS0_STR$	19
117	TRDTKLIF	Trade Discounts Taken LIFE	Currency	DLR19_RBSO_STR$	19
118	TRDTLYR	Trade Discounts Taken LYR	Currency	DLR19_RBSO_STR$	19
119	TRDTYTD	Trade Discounts Taken YTD	Currency	DLR19_RBSO_STR$	19
120	NFNCHLIF	Number of Finance Charges LIFE	Long Integer	LI_9U0	9
121	NFNCHLYR	Number of Finance Charges LYR	Long Integer	LI_9U0	9
122	NFNCHYTD	Number of Finance Charges YTD	Long Integer	LI_9U0	9
123	RTNGOWED	Retainage Owed	Currency	DLR17_RBS0_STR$	17
124	LSTCHNUM	Last Check Number	String	Check_Number	20
125	LSTCHKDT	Last Check Date	Date	DT	8
126	LSTCHAMT	Last Check Amount	Currency	DLR17_RBS0_UTR$	17
127	LSTINNUM	Last Invoice Number	String	STR20	20
128	LSTINVAM	Last Invoice Amount	Currency	DLR17_RBS0_UTR$	17
129	LSTPURDT	Last Purchase Date	Date	DT	8
130	FSTPURDT	First Purchase Date	Date	DT	8
131	CURUNPBN	Current Unapplied Payment Balance	Currency	DLR17_RBS0_UTR$	17
132	UNPDFNCH	Unpaid Finance Charges	Currency	DLR17_RBS0_UTR$	17
133	DYCHTCLR	Days Checks To Clear	Integer	INT3_U0	3
134	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
135	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
136	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
137	Revalue_Vendor	Revalue Vendor	Boolean	CB Revalue Vendor	0
138	Post_Results_To	Post Results To	Integer	GB	0
139	FREEONBOARD	Free On Board	Integer	DDL_Free_On_Board	0
140	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
141	DOCFMTID	Document Format ID	String	STR15_LBU	15
142	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
143	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
144	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
145	PHONE3	Phone 3	String	Phone_Number3	14
146	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
147	Withholding_LIFE	Withholding LIFE	Currency	DLR19_RBS0_STR$	19
148	WITHLYR	Withholding LYR	Currency	DLR19_RBS0_STR$	19
149	WITHYTD	Withholding YTD	Currency	DLR19_RBS0_STR$	19
150	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
151	VENDDBA	DBA	String	STR65	65

azurecurve Products SmartList (1493)PathnameSmartList PM Vendor Master File (ASIEXP03)

Leave a Reply Cancel reply