| PAVIDN |
char(17)
''
|
|
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
UPR10304.BACHNUMB
|
|
join ... more text available
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
|
|
|
| BNKRCAMT |
numeric(19,5)
0.00
|
Bank Recei...(more) Join Now
|
POP10300.BNKRCAMT
|
|
|
| CARDNAME |
char(15)
''
|
Card Name:...(more) Join Now
|
PM10000.CARDNAME
|
|
|
| CASHAMNT |
numeric(19,5)
0.00
|
Cash Amoun...(more) Join Now
|
PM10000.CASHAMNT
|
|
|
| CAMCBKID |
char(15)
''
|
Cash Amoun...(more) Join Now
|
PM10000.CAMCBKID
|
|
|
| CAMTDATE |
datetime
'1/1/1900'
|
Cash Amoun...(more) Join Now
|
PM10000.CAMTDATE
|
|
|
| CAMPMTNM |
char(21)
''
|
Cash Amoun...(more) Join Now
|
PM10000.CAMPMTNM
|
|
|
| CDOCNMBR |
char(21)
''
|
Cash Docum...(more) Join Now
|
PM10000.CDOCNMBR
|
|
|
| CHEKAMNT |
numeric(19,5)
0.00
|
Check Amou...(more) Join Now
|
PM10000.CHEKAMNT
|
|
|
| CHAMCBID |
char(15)
''
|
Check Amou...(more) Join Now
|
PM10000.CHAMCBID
|
|
|
| CAMPYNBR |
char(21)
''
|
Check Amou...(more) Join Now
|
PM10000.CAMPYNBR
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
Check Date...(more) Join Now
|
PM10000.CHEKDATE
|
|
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| CRCRDAMT |
numeric(19,5)
0.00
|
Credit Car...(more) Join Now
|
PM10000.CRCRDAMT
|
|
|
| CCAMPYNM |
char(21)
''
|
Credit Car...(more) Join Now
|
PM10000.CCAMPYNM
|
|
|
| CRCARDDT |
datetime
'1/1/1900'
|
Credit Car...(more) Join Now
|
PM10000.CRCARDDT
|
|
|
| CCRCTNUM |
char(21)
''
|
Credit Car...(more) Join Now
|
PM10000.CCRCTNUM
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| DocPrinted |
tinyint
0
|
DocPrinted...(more) Join Now
|
RM10301.DocPrinted
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ORCASAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
PTE30500.ORCASAMT
|
|
|
| ORCHKAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
PTE30500.ORCHKAMT
|
|
|
| ORCCDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
PTE30500.ORCCDAMT
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
SOP30200.ORDISTKN
|
|
|
| PACOMM |
char(51)
''
|
|
|
|
|
| PAFreight_Taxable_P |
smallint
0
|
|
|
|
|
| PAMisc_Taxable_P |
smallint
0
|
|
|
|
|
| PAPO_HDR_Errors |
binary(4)
0
|
|
|
|
|
| PAPO_Line_Errors |
binary(4)
0
|
|
|
|
|
| PApostoDynPM |
tinyint
0
|
|
|
|
|
| PA_Trade_Discount_Pcnt |
smallint
0
|
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| RegKey |
char(129)
''
|
|
|
|
|
| TRXTYPE |
smallint
0
|
Transactio...(more) Join Now
|
GL10000.TRXTYPE
|
|
|
| USEADVTX |
smallint
0
|
Use Advanc...(more) Join Now
|
POP40100.USEADVTX
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|