| PAVIDN |
char(17)
''
|
PA Vendor ...(more) Join Now
|
|
|
|
| CARDNAME |
char(15)
''
|
Card Name:...(more) Join Now
|
|
|
|
| CASHAMNT |
numeric(19,5)
0.00
|
Cash Amoun...(more) Join Now
|
|
|
|
| CAMCBKID |
char(15)
''
|
Cash Amoun...(more) Join Now
|
|
|
|
| CAMTDATE |
datetime
'1/1/1900'
|
Cash Amoun...(more) Join Now
|
|
|
|
| CAMPMTNM |
char(21)
''
|
Cash Amoun...(more) Join Now
|
|
|
|
| CDOCNMBR |
char(21)
''
|
Cash Docum...(more) Join Now
|
|
|
|
| CHEKAMNT |
numeric(19,5)
0.00
|
Check Amou...(more) Join Now
|
|
|
|
| CHAMCBID |
char(15)
''
|
Check Amou...(more) Join Now
|
|
|
|
| CAMPYNBR |
char(21)
''
|
Check Amou...(more) Join Now
|
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
Check Date...(more) Join Now
|
|
|
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| CRCRDAMT |
numeric(19,5)
0.00
|
Credit Car...(more) Join Now
|
|
|
|
| CCAMPYNM |
char(21)
''
|
Credit Car...(more) Join Now
|
|
|
|
| CRCARDDT |
datetime
'1/1/1900'
|
Credit Car...(more) Join Now
|
|
|
|
| CCRCTNUM |
char(21)
''
|
Credit Car...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| ORCHKAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORCCDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDISTKN |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| PACOMM |
char(51)
''
|
PA Comment...(more) Join Now
|
|
|
|
| PAFreight_Taxable_P |
smallint
0
|
PA Freight...(more) Join Now
|
|
|
|
| PAMisc_Taxable_P |
smallint
0
|
PA Misc Ta...(more) Join Now
|
|
|
|
| PAPO_HDR_Errors |
binary(4)
0
|
PA PO HDR ...(more) Join Now
|
|
|
|
| PAPO_Line_Errors |
binary(4)
0
|
PA PO Line...(more) Join Now
|
|
|
|
| PApostoDynPM |
tinyint
0
|
PA Post to...(more) Join Now
|
|
|
|
| PA_Trade_Discount_Pcnt |
smallint
0
|
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| TRXTYPE |
smallint
0
|
Transactio...(more) Join Now
|
|
|
|
| USEADVTX |
smallint
0
|
Use Advanc...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|