Module List >
Module PM tables
PM00202
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PM00202 Table Definition
(COMPANY..PM Vendor Master Period Summary)
This file would not normally be imported into. An exception would be to provide totals for previous periods and years before dynamics was used for comparative reports to current data.
Field Definitions:
What is the 'source' column?
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| PERIODID |
smallint
0
|
Period ID:...(more) Join Now
|
|
|
|
| YEAR1 |
smallint
0
|
Year: The...(more) Join Now
|
|
|
|
| HISTTYPE |
smallint
0
|
History Ty...(more) Join Now
|
|
|
|
| AMBLDLIF |
numeric(19,5)
0.00
|
Amount Bil...(more) Join Now
|
|
|
|
| AMTPDLIF |
numeric(19,5)
0.00
|
Amount Pai...(more) Join Now
|
|
|
|
| TEN99ALIF |
numeric(19,5)
0.00
|
1099 Amoun...(more) Join Now
|
|
|
|
| DISAVLIF |
numeric(19,5)
0.00
|
Discount A...(more) Join Now
|
|
|
|
| DISTKNLF |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DISLSTLF |
numeric(19,5)
0.00
|
Discount L...(more) Join Now
|
|
|
|
| FINCHLIF |
numeric(19,5)
0.00
|
Finance Ch...(more) Join Now
|
|
|
|
| WROFSLIF |
numeric(19,5)
0.00
|
Writeoffs ...(more) Join Now
|
|
|
|
| RTRNSLIF |
numeric(19,5)
0.00
|
Returns Li...(more) Join Now
|
|
|
|
| TRDTKLIF |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| NFNCHLIF |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| NOINVLIF |
int
0
|
Number of ...(more) Join Now
|
|
|
|
| Withholding_LIFE |
numeric(19,5)
0.00
|
Withholdin...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|