Module List > Module POP tables POP30300
You are currently viewing the COMPANY database.
Change

COMPANY..POP30300 Table Definition

(COMPANY..Purchasing Receipt History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPRCTNM char(17)
''
POP Receip...(more) Join Now
POPTYPE smallint
0
POP Type b...(more) Join Now
VNDDOCNM char(21)
''
Vendor Doc...(more) Join Now
receiptdate datetime
'1/1/1900'
Receipt Da...(more) Join Now
GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
ACTLSHIP datetime
'1/1/1900'
Actual Shi...(more) Join Now
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now
SUBTOTAL numeric(19,5)
0.00
Subtotal T...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
TRDPCTPR numeric(23,0)
0.00
Trade Disc...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
MISCAMNT numeric(19,5)
0.00
Misc Amoun...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
DSCPCTAM smallint
0
Discount P...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now
DISAVAMT numeric(19,5)
0.00
Amount: Th...(more) Join Now
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now
REFRENCE char(31)
''
Reference:...(more) Join Now
VOIDSTTS smallint
0
Void Statu...(more) Join Now
RCPTNOTE_1 numeric(19,5)
0.00
Receipt No...(more) Join Now
RCPTNOTE_2 numeric(19,5)
0.00
See s...(more) Join Now
RCPTNOTE_3 numeric(19,5)
0.00
span style...(more) Join Now
RCPTNOTE_4 numeric(19,5)
0.00

RCPTNOTE_5 numeric(19,5)
0.00

RCPTNOTE_6 numeric(19,5)
0.00

RCPTNOTE_7 numeric(19,5)
0.00

RCPTNOTE_8 numeric(19,5)
0.00

POPHDR1 binary(4)
0
POP HDR Er...(more) Join Now
POPHDR2 binary(4)
0
POP HDR Er...(more) Join Now
POPLNERR binary(4)
0
POP LINE Errors Multi-select listbox used to track line item level posting errors with the following possible errors: 1 **ERROR: Item record doesn't exist. 2 **ERROR: Item site record doesn't exist. 3 **ERROR: Item's vendor record doesn't exist. 4 **ERROR: Serial numbers don't match ext. qty. 5 **ERROR: Lot and item extended qty don't match. 6 **ERROR: Serial No. already exists for item. 7 **ERROR: Can't receive or return against kit items. 8 **ERROR: Can't receive missing PO line item. 9 **ERROR: Can't receive or return canceled PO line item. 10 **ERROR: Can't post. Qty distribution error. 11 **ERROR: Can't receive closed PO line item. 12 **ERROR: Line items are not fully matched. 13 **ERROR: Editing PO; can't receive or return against. 14 ** ERROR: PO missing; can't receive or return against. 15 ** ERROR: PO closed or canceled; can't receive. 16 **ERROR: One or more purchase orders are on hold. 17 **ERROR: Intrastat info. missing or invalid. 18 **ERROR: Invalid linked MO status. 19 **ERROR: The tax detail record doesn't exist. 20 **ERROR: Tax detail distributions don't match tax amount. 21 **ERROR: The vendor is inactive. 22 **ERROR: Currency information has errors. 23 **ERROR: The exchange rate has expired. 24 **ERROR: PO canceled; can't return. 25 **ERROR: Receipt is missing; can't return against. 26 **ERROR: Receipt is invoiced; can't return against. 27 **ERROR: Bin and item extended qty don't match. 28 **ERROR: Item not assigned to a bin. 29 **ERROR :Item uses average costing now but not at the time of the Document Date 30 **ERROR: The in-transit transfer is being edited. 31 **ERROR: Can't post. In-transit transfer missing. 32 **ERROR: Can't post. In-transit transfer line missing.
POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
PTDUSRID char(15)
''
Posted Use...(more) Join Now
USER2ENT char(15)
''
User To En...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
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
ORSUBTOT numeric(19,5)
0.00
Originatin...(more) Join Now
ORTDISAM numeric(19,5)
0.00

ORFRTAMT numeric(19,5)
0.00
Originatin...(more) Join Now
ORMISCAMT numeric(19,5)
0.00

ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
OR1099AM numeric(19,5)
0.00
Originatin...(more) Join Now
ORDDLRAT numeric(19,5)
0.00
Orig Disco...(more) Join Now
ORDAVAMT numeric(19,5)
0.00
Orig Disco...(more) Join Now
SIMPLIFD tinyint
0
Simplified...(more) Join Now
WITHHAMT numeric(19,5)
0.00
Withholdin...(more) Join Now
ECTRX tinyint
0
EC Transac...(more) Join Now
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
BSIVCTTL tinyint
0
Based On I...(more) Join Now
Purchase_Freight_Taxable smallint
0
Purchase F...(more) Join Now
Purchase_Misc_Taxable smallint
0
Purchase M...(more) Join Now
FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now
ORMSCTAX numeric(19,5)
0.00
Originatin...(more) Join Now
BCKTXAMT numeric(19,5)
0.00
Backout Ta...(more) Join Now
OBTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now
BackoutFreightTaxAmt numeric(19,5)
0.00
Backout Fr...(more) Join Now
OrigBackoutFreightTaxAmt numeric(19,5)
0.00
Originatin...(more) Join Now
BackoutMiscTaxAmt numeric(19,5)
0.00
Backout Mi...(more) Join Now
OrigBackoutMiscTaxAmt numeric(19,5)
0.00
Originatin...(more) Join Now
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now
APLYWITH tinyint
0
Apply With...(more) Join Now
PPSTAXRT smallint
0
PPS Tax Ra...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
Total_Landed_Cost_Amount numeric(19,5)
0.00
Total Land...(more) Join Now
CBVAT tinyint
0
Cash Based...(more) Join Now
VADCDTRO char(15)
''
Vendor Add...(more) Join Now
REVALJRNENTRY int
0

REVALTRXSOURCE char(13)
''

TEN99TYPE smallint
0
1099 Type:...(more) Join Now
TEN99BOXNUMBER smallint
0
1099 Box N...(more) Join Now
REPLACEGOODS tinyint
0
Replace Re...(more) Join Now
INVOICEEXPECTED tinyint
0
Invoice Ex...(more) Join Now
PrepaymentAmount numeric
0.00

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
OriginatingPrepaymentAmt numeric
0.00

POP_HDR_Errors_4 binary
0

DISTKNAM numeric
0.00
Discount T...(more) Join Now
ORDISTKN numeric
0.00
Orig Disco...(more) Join Now RM20102.ORDISTKN
DISAVTKN numeric
0.00
Discount A...(more) Join Now
ORDATKN numeric
0.00
Orig Disco...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3