| POPRCTNM |
char(17)
''
|
POP Receip...(more) Join Now
|
|
|
|
| POPTYPE |
smallint
0
|
POP Type 1...(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'
|
GL Posting...(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
|
Discount A...(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
|
|
|
|
| RCPTNOTE_1 |
numeric(19,5)
0.00
|
Receipt No...(more) Join Now
|
|
|
|
| RCPTNOTE_2 |
numeric(19,5)
0.00
|
|
|
|
|
| RCPTNOTE_3 |
numeric(19,5)
0.00
|
|
|
|
|
| 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 D...(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
|
Originatin...(more) Join Now
|
|
|
|
| WITHHAMT |
numeric(19,5)
0.00
|
Withholdin...(more) Join Now
|
|
|
|
| SIMPLIFD |
tinyint
0
|
Simplified...(more) Join Now
|
|
|
|
| BNKRCAMT |
numeric(19,5)
0.00
|
Bank Recei...(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
|
| TXENGCLD |
tinyint
0
|
Tax Engine...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| TaxInvReqd |
tinyint
0
|
Tax Invoic...(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
|
| DocPrinted |
tinyint
0
|
DocPrinted...(more) Join Now
|
|
|
|
| Total_Landed_Cost_Amount |
numeric(19,5)
0.00
|
Total Land...(more) Join Now
|
|
|
|
| BackoutTradeDiscTax |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
|
|
|
| OrigBackoutTradeDiscTax |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| CBVAT |
tinyint
0
|
Cash Based...(more) Join Now
|
|
|
|
| VADCDTRO |
char(15)
''
|
Vendor Add...(more) Join Now
|
|
|
|
| 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
|
|
|
|