| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PSMISCLTRXTYPE | PA Miscellaneous Log TRX Type |
Integer | 2 | View | |
| PAMISCLDOCNO | PA Miscellaneous Log No. |
String | 18 | View | |
| PADOCDT | PA Document Date |
Date | 4 | View | |
| PAYR | PA Year |
Integer | 2 | View | |
| USERID | User ID |
String | 16 | View | |
| BACHNUMB | Batch Number |
String | 16 | View | |
| BCHSOURC | Batch Source |
String | 16 | View | |
| TRXSORCE | TRX Source |
String | 14 | View | |
| PAREFNO | PA Reference Document No. |
String | 18 | View | |
| PSMISCID | PA Miscellaneous ID |
String | 16 | View | |
| PAREPD | PA Reporting Period |
Integer | 2 | View | |
| PAREPDT | PA Reporting Date |
Date | 4 | View | |
| PAPeriodEndDate | PA Period End Date |
Date | 4 | View | |
| PACOMM | PA Comment |
String | 52 | View | |
| PAUD1 | PA User Defined 1 |
String | 22 | View | |
| PAUD2 | PA User Defined 2 |
String | 22 | View | |
| PATQTY | PA Total Quantity |
Currency | 10 | View | |
| PAtotcosts | PA Total Costs |
Currency | 10 | View | |
| PATACRV | PA Total Accrued Revenues |
Currency | 10 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| PAreptsuff | PA Reporting Suffix |
String | 6 | View | |
| LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
| PAPD | PA Post Date |
Date | 4 | View | |
| CURNCYID | Currency ID |
String | 16 | 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 | |
| PAORIGTOTCOSTS | PA Originating Total Costs |
Currency | 10 | View | |
| PAORIACCRREV | PA Originating Accrued Revenues |
Currency | 10 | View | |
| Correcting_Trx_Type | Correcting Trx Type |
Integer | 2 | View | |
| PAORIGINLDOCNUM | PA Original Document Number |
String | 18 | View | |
| CREATDDT | Created Date |
Date | 4 | View | |
| CRUSRID | Created User ID |
String | 16 | View | |
| POSTEDDT | Posted Date |
Date | 4 | View | |
| PTDUSRID | Posted User ID |
String | 16 | View |