PA30103 - PA Timesheet Distribution History
Dynamics GP table PA30103 (PA Timesheet Distribution History) contains 15 columns including PATSNO, TRXSORCE, DSTSQNUM....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| PATSNO | PA Timesheet No. | String | 18 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| DSTSQNUM | Distribution Sequence Number | Long Integer | 4 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| CRDTAMNT | Credit Amount | Currency | 10 | ||
| DEBITAMT | Debit Amount | Currency | 10 | ||
| DSTINDX | Distribution Account Index | Long Integer | 4 | ||
| DISTTYPE | Distribution Type1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase8 = Misc. Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Disc | Integer | 2 | ||
Distribution Type (Payables) values (19) 1 = Cash2 = Payable3 = Discount Available4 = Discount Taken5 = Finance Charge6 = Purchase7 = Trade Discount8 = Miscellaneous Charge9 = Freight10 = Taxes11 = Writeoffs12 = Other13 = GST Discount14 = PPS Amount16 = Rounding17 = Realized Gain18 = Realized Loss19 = Due To20 = Due From | |||||
| DistRef | Distribution Reference | String | 32 | ||
| USERID | User ID | String | 16 | ||
| EMPLOYID | Employee ID | String | 16 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| ORCRDAMT | Originating Credit Amount | Currency | 10 | ||
| ORDBTAMT | Originating Debit Amount | Currency | 10 | ||
Related Tables
Tables that share columns with PA30103. Click "Join" to add to your query.