| PTE_Empl_Expense_Doc_No |
char
''
|
|
|
|
|
| PADOCDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAYR |
smallint
0
|
|
|
|
|
| EMPLOYID |
char
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| USERID |
char
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| PAStartDate |
datetime
'1/1/1900'
|
|
|
|
|
| PAEnDate |
datetime
'1/1/1900'
|
PA End Dat...(more) Join Now
|
|
|
|
| PACOMM |
char
''
|
|
|
|
|
| PTE_Total_Quantity |
numeric
0.00
|
|
|
|
|
| PAEXTCOST |
numeric
0.00
|
|
|
|
|
| OREXTCST |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PAtotcosts |
numeric
0.00
|
|
|
|
|
| PAORIGTOTCOSTS |
numeric
0.00
|
|
|
|
|
| PAORIACCRREV |
numeric
0.00
|
|
|
|
|
| PATACRV |
numeric
0.00
|
|
|
|
|
| DOCAMNT |
numeric
0.00
|
Document A...(more) Join Now
|
|
|
|
| ORDOCAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| TEN99AMNT |
numeric
0.00
|
1099 Amoun...(more) Join Now
|
ICJC9001.TEN99AMNT
|
|
|
| OR1099AM |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| UN1099AM |
numeric
0.00
|
|
|
|
|
| PAVENADDRESSID |
char
''
|
|
|
|
|
| PYMTRMID |
char
''
|
Payment Te...(more) Join Now
|
RM50105.PYMTRMID
|
|
SY033... more text available
|
| DUEDATE |
datetime
'1/1/1900'
|
Due Date...(more) Join Now
|
|
|
|
| DSCDLRAM |
numeric
0.00
|
|
|
|
|
| ORDDLRAT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| DISCDATE |
datetime
'1/1/1900'
|
Discount D...(more) Join Now
|
|
|
|
| DISAMTAV |
numeric
0.00
|
Discount A...(more) Join Now
|
|
|
|
| ODISAMTAV |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric
0.00
|
Discount T...(more) Join Now
|
|
|
|
| ORDISTKN |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| BKTPURAM |
numeric
0.00
|
Backout Pu...(more) Join Now
|
|
|
|
| OBKPURAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| SHIPMTHD |
char
''
|
|
|
|
join ... more text available
|
| PRCTDISC |
smallint
0
|
|
|
|
|
| TRDISAMT |
numeric
0.00
|
Trade Disc...(more) Join Now
|
PA11801.TRDISAMT
|
|
|
| ORTDISAM |
numeric
0.00
|
|
|
|
|
| FRTAMNT |
numeric
0.00
|
Freight Am...(more) Join Now
|
|
|
|
| ORFRTAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| MSCCHAMT |
numeric
0.00
|
Misc Amoun...(more) Join Now
|
|
|
|
| OMISCAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PAPD |
datetime
'1/1/1900'
|
|
|
|
|
| CARDNAME |
char
''
|
Card Name...(more) Join Now
|
|
|
|
| CRCRDAMT |
numeric
0.00
|
Credit Car...(more) Join Now
|
|
|
|
| ORCCDAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| CRCARDDT |
datetime
'1/1/1900'
|
Credit Car...(more) Join Now
|
|
|
|
| CCRCTNUM |
char
''
|
|
|
|
|
| TAXAMNT |
numeric
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| ORTAXAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| TAXSCHID |
char
''
|
|
|
|
join ... more text available
|
| PAFreight_Taxable_P |
smallint
0
|
|
|
|
|
| FRTSCHID |
char
''
|
Freight Sc...(more) Join Now
|
|
|
join ... more text available
|
| FRTTXAMT |
numeric
0.00
|
Freight Ta...(more) Join Now
|
|
|
|
| ORFRTTAX |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDAVFRT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ODAVPUR |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDAVMSC |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PAMisc_Taxable_P |
smallint
0
|
|
|
|
|
| MSCSCHID |
char
''
|
|
|
|
join ... more text available
|
| MSCTXAMT |
numeric
0.00
|
Misc Tax A...(more) Join Now
|
|
|
|
| ORMSCTAX |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| CHRGAMNT |
numeric
0.00
|
Charge Amo...(more) Join Now
|
|
|
|
| OCHGAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CURNCYID |
char
''
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char
''
|
|
|
|
|
| EXGTBLID |
char
''
|
Exchange T...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
WO010213.TIME1
|
|
|
| DENXRATE |
numeric
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| PAReimbursableAmount |
numeric
0.00
|
|
|
|
|
| PAOrigReimbursableAmt |
numeric
0.00
|
|
|
|
|
| PAREIMBURSTAXAMT |
numeric
0.00
|
|
|
|
|
| PAORIGREIMTAXAMT |
numeric
0.00
|
|
|
|
|
| BCKTXAMT |
numeric
0.00
|
Backout Ta...(more) Join Now
|
|
|
|
| OBTAXAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PAREFNO |
char
''
|
|
|
|
|
| Tax_Date |
datetime
'1/1/1900'
|
|
|
|
|
| TaxInvRecvd |
tinyint
0
|
|
|
|
|
| TaxInvReqd |
tinyint
0
|
|
|
|
|
| CAMCBKID |
char
''
|
|
|
|
|
| CDOCNMBR |
char
''
|
|
|
|
|
| CAMTDATE |
datetime
'1/1/1900'
|
|
|
|
|
| CASHAMNT |
numeric
0.00
|
Cash Amoun...(more) Join Now
|
|
|
|
| ORCASAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| CHAMCBID |
char
''
|
|
|
|
|
| CHEKNMBR |
char
''
|
Check Numb...(more) Join Now
|
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
|
|
|
|
| CHEKAMNT |
numeric
0.00
|
Check Amou...(more) Join Now
|
|
|
|
| ORCHKAMT |
numeric
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PATQTY |
numeric
0.00
|
|
|
|
|
| PADocnumber20 |
char
''
|
|
|
|
|
| Workflow_Status |
smallint
0
|
|
|
|
|
| RTCLCMTD |
smallint
0
|
Rate calcu...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
|
|
|
|
| PAerdocnumber |
char
''
|
|
|
|
|
| TEN99TYPE |
smallint
0
|
|
|
|
|
| TEN99BOXNUMBER |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|