Module List >
Module POP tables
POP30700
You are currently viewing the COMPANY
database.
Change
|
COMPANY..POP30700 Table Definition
(COMPANY..Purchasing Landed Cost History)
Field Definitions:
What is the 'source' column?
| POPRCTNM |
char(17)
''
|
POP Receip...(more) Join Now
|
|
|
|
| RCPTLNNM |
int
0
|
Receipt Li...(more) Join Now
|
|
|
|
| LCLINENUMBER |
int
0
|
|
|
|
|
| LCHDRNUMBER |
int
0
|
|
|
|
|
| Landed_Cost_ID |
char(15)
''
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| Long_Description |
char(51)
''
|
|
|
|
|
| Landed_Cost_Type |
smallint
0
|
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
|
|
join ... more text available
|
| Vendor_Note_Index |
numeric(19,5)
0.00
|
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| Currency_Note_Index |
numeric(19,5)
0.00
|
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time: The...(more) Join Now
|
|
|
|
| RATECALC |
smallint
0
|
Rate Calc ...(more) Join Now
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| DECPLCUR |
smallint
0
|
Number of ...(more) Join Now
|
|
|
|
| ODECPLCU |
smallint
0
|
|
|
|
|
| ACPURIDX |
int
0
|
Accrued Pu...(more) Join Now
|
|
|
|
| DistRef |
char(31)
''
|
Distributi...(more) Join Now
|
|
|
|
| PURPVIDX |
int
0
|
Purchase P...(more) Join Now
|
|
|
|
| Invoice_Match |
tinyint
0
|
|
|
|
|
| CALCMTHD |
smallint
0
|
|
|
|
|
| Orig_Landed_Cost_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| Calculation_Percentage |
int
0
|
|
|
|
|
| Total_Landed_Cost_Amount |
numeric(19,5)
0.00
|
Total Land...(more) Join Now
|
|
|
|
| Orig_TotalLandedCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| Landed_Cost_Warnings |
smallint
0
|
|
|
|
|
| Apportion_By |
smallint
0
|
|
|
|
|
| Orig_UnapportionedAmount |
numeric(19,5)
0.00
|
|
|
|
|
| INVINDX |
int
0
|
Inventory ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|