| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PABILLTRXT | PA Biller Trx Type |
Integer | 2 | View | |
| PADocnumber20 | PA Document No. |
String | 18 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| PADOCDT | PA Document Date |
Date | 4 | View | |
| PAPD | PA Post Date |
Date | 4 | View | |
| BACHNUMB | Batch Number |
String | 16 | View | |
| BCHSOURC | Batch Source |
String | 16 | View | |
| TRXSORCE | TRX Source |
String | 14 | View | |
| PAuserid | PA User ID |
String | 16 | View | |
| LSTEDTDT | Last Edit Date |
Date | 4 | View | |
| LSTUSRED | Last User to Edit |
String | 16 | View | |
| PAREFNO | PA Reference Document No. |
String | 18 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CSTPONBR | Customer PO Number |
String | 22 | View | |
| PRBTADCD | Primary Billto Address Code |
String | 16 | View | |
| PYMTRMID | Payment Terms ID |
String | 22 | View | |
| PABILLFORMAT | PA Bill Format |
String | 16 | View | |
| PACOMM | PA Comment |
String | 52 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| PAUD1 | PA User Defined 1 |
String | 22 | View | |
| PAUD2 | PA User Defined 2 |
String | 22 | View | |
| CASHAMNT | Cash Amount |
Currency | 10 | View | |
| CBKIDCSH | Checkbook ID Cash |
String | 16 | View | |
| CASHDATE | Cash Date |
Date | 4 | View | |
| DCNUMCSH | Document Number Cash |
String | 22 | View | |
| CHEKAMNT | Check Amount |
Currency | 10 | View | |
| CBKIDCHK | Checkbook ID Check |
String | 16 | View | |
| CHEKNMBR | Check Number |
String | 22 | View | |
| CHEKDATE | Check Date |
Date | 4 | View | |
| DCNUMCHK | Document Number Check |
String | 22 | View | |
| CRCRDAMT | Credit Card Amount |
Currency | 10 | View | |
| CRCRDNAM | Credit Card Name |
String | 16 | View | |
| RCTNCCRD | Receipt Number Credit Card |
String | 22 | View | |
| CRCARDDT | Credit Card Date |
Date | 4 | View | |
| DCNUMCRD | Document Number Credit Card |
String | 22 | View | |
| DSCPCTAM | Discount Percent Amount |
Integer | 2 | View | |
| DSCDLRAM | Discount Dollar Amount |
Currency | 10 | View | |
| DISAVAMT | Discount Available Amount |
Currency | 10 | View | |
| DISCAMNT | Discount Amount |
Currency | 10 | View | |
| DISCDATE | Discount Date |
Date | 4 | View | |
| DISTKNAM | Discount Taken Amount |
Currency | 10 | View | |
| DISCRTND | Discount Returned |
Currency | 10 | View | |
| PABillingAmount | PA Billing Amount |
Currency | 10 | View | |
| TRDISAMT | Trade Discount Amount |
Currency | 10 | View | |
| PA_Freight_Amount | PA Freight Amount |
Currency | 10 | View | |
| FRTTXAMT | Freight Tax Amount |
Currency | 10 | View | |
| PA_Misc_Amount | PA Misc Amount |
Currency | 10 | View | |
| MSCTXAMT | Misc Tax Amount |
Currency | 10 | View | |
| PATOTTAX | PA Total Tax |
Currency | 10 | View | |
| PABACKBILL | PA Backout Bill Amount |
Currency | 10 | View | |
| BKTFRTAM | Backout Freight Amount |
Currency | 10 | View | |
| BKTMSCAM | Backout Misc Amount |
Currency | 10 | View | |
| DOCAMNT | Document Amount |
Currency | 10 | View | |
| DUEDATE | Due Date |
Date | 4 | View | |
| APPLDAMT | Applied Amount |
Currency | 10 | View | |
| PALastDateApplied | PA Last Date Applied |
Date | 4 | View | |
| SLPRSNID | Salesperson ID |
String | 16 | View | |
| SALSTERR | Sales Territory |
String | 16 | View | |
| TAXSCHID | Tax Schedule ID |
String | 16 | View | |
| COMDLRAM | Commission Dollar Amount |
Currency | 10 | View | |
| COMAPPTO | Commission Applied To |
Integer | 2 | View | |
| LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
| CUTOFDAT | Cutoff Date |
Date | 4 | View | |
| SHIPMTHD | Shipping Method |
String | 16 | View | |
| MSCSCHID | Misc Schedule ID |
String | 16 | View | |
| MISCTXBL | Misc Taxable 1 = Taxable |
Integer | 2 | View | |
| FRTSCHID | Freight Schedule ID |
String | 16 | View | |
| FRGTTXBL | Freight Taxable 1 = Taxable |
Integer | 2 | View | |
| PARetentionFeeAmount | PA Retention Fee Amount |
Currency | 10 | View | |
| PAtotbillings | PA Total Billings |
Currency | 10 | View | |
| PARetainer_Fee_Amount | PA Retainer Fee Amount |
Currency | 10 | View | |
| PAApplyTax | PA Apply Tax |
Boolean | 2 | View | |
| PA_Applied_Freight_Misc | PA Applied Freight Misc |
Currency | 10 | View | |
| AGNGBUKT | Aging Bucket |
Integer | 2 | View | |
| PAlastprtby | PA Last Printed By |
String | 16 | View | |
| PAlastprtdate | PA Last Printed Date |
Date | 4 | View | |
| ORCASAMT | Originating Cash Amount |
Currency | 10 | View | |
| ORCHKAMT | Originating Check Amount |
Currency | 10 | View | |
| ORCCDAMT | Originating Credit Card Amount |
Currency | 10 | View | |
| ORDDLRAT | Originating Discount Dollar Amount |
Currency | 10 | View | |
| ORDAVAMT | Originating Discount Available Amount |
Currency | 10 | View | |
| ORTDISAM | Originating Trade Discount Amount |
Currency | 10 | View | |
| ORFRTTAX | Originating Freight Tax Amount |
Currency | 10 | View | |
| ORMSCTAX | Originating Misc Tax Amount |
Currency | 10 | View | |
| ORBKTFRT | Originating Backout Freight Amount |
Currency | 10 | View | |
| ORBKTMSC | Originating Backout Misc Amount |
Currency | 10 | View | |
| ORDOCAMT | Originating Document Amount |
Currency | 10 | View | |
| ORAPPAMT | Originating Applied Amount |
Currency | 10 | View | |
| ORCOMAMT | Originating Commission Dollar Amount |
Currency | 10 | View | |
| PAOrigBillAmount | PA Originating Billing Amount |
Currency | 10 | View | |
| PAOrigFreightAmt | PA Originating Freight Amount |
Currency | 10 | View | |
| PAOrigMiscAmt | PA Originating Misc Amount |
Currency | 10 | View | |
| PAOrigTotalTaxAmt | PA Originating Total Tax |
Currency | 10 | View | |
| PAOrigBackoutBillAmt | PA Originating Backout Bill Amt |
Currency | 10 | View | |
| PAOrigRetentionFeeAmt | PA Originating Retention Fee Amt |
Currency | 10 | View | |
| PAOrigTotalBilings | PA Originating Total Billings |
Currency | 10 | View | |
| PAOrigRetainerFeeAmt | PA Originating Retainer Fee Amt |
Currency | 10 | View | |
| PAOrigDiscTakenAmt | PA Originating Discount Taken Amt |
Currency | 10 | View | |
| PAOrigDiscRetAmt | PA Originating Discount Returned Amt |
Currency | 10 | View | |
| PAOrigAppliedFreightMisc | PA Originating Applied Freight Misc |
Currency | 10 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| RATETPID | Rate Type ID |
String | 16 | View | |
| EXGTBLID | Exchange Table ID |
String | 16 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| EXCHDATE | Exchange Date |
Date | 4 | View | |
| TIME1 | Time |
Time | 4 | View | |
| RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
| DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
| PAPostoDynRM | PA Post to Dyn Receivables Mgmt |
Boolean | 2 | View | |
| Tax_Date | Tax Date |
Date | 4 | View | |
| PA_Third_Party_CB | PA Third Party CB |
Boolean | 2 | View | |
| BCKTXAMT | Backout Tax Amount |
Currency | 10 | View | |
| OBTAXAMT | Originating Backout Tax Amount |
Currency | 10 | View | |
| BackoutTradeDiscTax | Backout Trade Discount Tax Amount |
Currency | 10 | View | |
| OrigBackoutTradeDiscTax | Originating Backout Trade Discount Tax Amount |
Currency | 10 | View | |
| PA_Backout_Retention_Tax | PA Backout Retention Tax Amount |
Currency | 10 | View | |
| PA_OrigBackRetentionTax | PA Originating Backout Retention Tax Amount |
Currency | 10 | View |