Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA30500
Product: Project Accounting (258)
Series: Project
Display Name: PA Employee Expense Header History File Group Display Name: PA Employee Expense Transactions History
Physical Name: PA30500
Technical Name: PA_Employee_Expense_HDR_HIST
Group Technical Name: PA Employee Expense Transactions History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | PAertrxtype ![]() | PA Empl Expense TRX Type | PA_DDL_EE_Trx_Typ | Integer | 0 | |
2 | PAerdocnumber ![]() | PA Empl Expense Document No. | STR30_LBAU | String | 30 | |
3 | PDK_EE_No ![]() | PDK EE No. | PDK_Document_Number | String | 30 | |
4 | PADOCDT ![]() | PA Document Date | PA_Date | Date | 8 | |
5 | PAPD ![]() | PA Post Date | PA_Date | Date | 8 | |
6 | USERID ![]() | User ID | STR15_User_ID | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PA Employee Expense Header History File'].USERID AS 'PA Employee Expense Header History File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Employee Expense Header History File'].USERID = ['Users Master'].USERID | ||||||
7 | BACHNUMB ![]() | Batch Number | STR15_LBAU | String | 15 | |
8 | BCHSOURC ![]() | Batch Source | STR15 | String | 15 | |
9 | TRXSORCE ![]() | TRX Source | STR13 | String | 13 | |
10 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['PA Employee Expense Header History File'].SHIPMTHD AS 'PA Employee Expense Header History File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PA Employee Expense Header History File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
11 | PAREFNO ![]() | PA Reference Document No. | STR17_LBAU | String | 17 | |
12 | PAUD1 ![]() | PA User Defined 1 | STR20 | String | 20 | |
13 | PAUD2 ![]() | PA User Defined 2 | STR20 | String | 20 | |
14 | EMPLOYID ![]() | Employee ID | STR15_Employee_ID | String | 15 | |
15 | PAVENADDRESSID ![]() | PA Vendor Address ID | STR15_Address_Code | String | 15 | |
16 | PAStartDate ![]() | PA Start Date | DT | Date | 8 | |
17 | PAEnDate ![]() | PA End Date | DT | Date | 8 | |
18 | PAreptsuff ![]() | PA Reporting Suffix | PA_STR5 | String | 5 | |
19 | PAYR ![]() | PA Year | INT4 | Integer | 4 | |
20 | PACOMM ![]() | PA Comment | STR50 | String | 50 | |
21 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['PA Employee Expense Header History File'].PYMTRMID AS 'PA Employee Expense Header History File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PA Employee Expense Header History File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
22 | DUEDATE ![]() | Due Date | DT | Date | 8 | |
23 | DSCDLRAM ![]() | Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 11 | |
24 | ORDDLRAT ![]() | Originating Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 11 | |
25 | DISCDATE ![]() | Discount Date | DT | Date | 8 | |
26 | DISAMTAV ![]() | Discount Amount Available | DLR17_RBS0_UTR$ | Currency | 17 | |
27 | ODISAMTAV ![]() | Originating Discount Amount Available | DLR17_RBS0_UTR$ | Currency | 17 | |
28 | PRCTDISC ![]() | Percent Discount | INT5_%2 | Integer | 5 | |
29 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA Employee Expense Header History File'].CURNCYID AS 'PA Employee Expense Header History File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Employee Expense Header History File'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
30 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA Employee Expense Header History File'].CURRNIDX AS 'PA Employee Expense Header History File-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Employee Expense Header History File'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
31 | PATQTY ![]() | PA Total Quantity | DLR17_QTY_RBS0_UTR | Currency | 17 | |
32 | PAEXTCOST ![]() | PA Extended Cost | PA_DLR17_RBS0_STR$ | Currency | 17 | |
33 | OREXTCST ![]() | Originating Extended Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
34 | PAtotcosts ![]() | PA Total Costs | PA_DLR17_RBS0_STR$ | Currency | 17 | |
35 | PAORIGTOTCOSTS ![]() | PA Originating Total Costs | DLR17_RBS0_UTR$ | Currency | 17 | |
36 | PAREIMBURSTAXAMT ![]() | PA Reimbursable Tax Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
37 | PAORIGREIMTAXAMT ![]() | PA Originating Reimbursable Tax Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
38 | BKTPURAM ![]() | Backout Purchases Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
39 | PATACRV ![]() | PA Total Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
40 | PAORIACCRREV ![]() | PA Originating Accrued Revenues | DLR17_RBS0_UTR$ | Currency | 17 | |
41 | TRDISAMT ![]() | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
42 | ORTDISAM ![]() | Originating Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
43 | PAFreight_Taxable_P ![]() | PA Freight Taxable - Purchase | PA_DDL_Tax_Options_Purchase | Integer | 0 | |
44 | FRTSCHID ![]() | Freight Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Employee Expense Header History File'].FRTSCHID AS 'PA Employee Expense Header History File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Employee Expense Header History File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
45 | FRTAMNT ![]() | Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
46 | ORFRTAMT ![]() | Originating Freight Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
47 | FRTTXAMT ![]() | Freight Tax Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
48 | ORFRTTAX ![]() | Originating Freight Tax Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
49 | PAMisc_Taxable_P ![]() | PA Misc Taxable - Purchase | PA_DDL_Tax_Options_Purchase | Integer | 0 | |
50 | MSCSCHID ![]() | Misc Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Employee Expense Header History File'].MSCSCHID AS 'PA Employee Expense Header History File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Employee Expense Header History File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
51 | MSCCHAMT ![]() | Misc Charges Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
52 | OMISCAMT ![]() | Originating Misc Charges Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
53 | MSCTXAMT ![]() | Misc Tax Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
54 | ORMSCTAX ![]() | Originating Misc Tax Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
55 | DOCAMNT ![]() | Document Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
56 | ORDOCAMT ![]() | Originating Document Amount | DLR17_RBS0_STR$ | Currency | 17 | |
57 | TEN99AMNT ![]() | 1099 Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
58 | OR1099AM ![]() | Originating 1099 Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
59 | UN1099AM ![]() | Unapplied 1099 Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
60 | CASHAMNT ![]() | Cash Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
61 | ORCASAMT ![]() | Originating Cash Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
62 | CAMCBKID ![]() | Cash Amount Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PA Employee Expense Header History File'].CAMCBKID AS 'PA Employee Expense Header History File-Cash Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PA Employee Expense Header History File'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
63 | CDOCNMBR ![]() | Cash Document Number | STR20_Document_Number | String | 20 | |
64 | CAMTDATE ![]() | Cash Amount Date | DT | Date | 8 | |
65 | CAMPMTNM ![]() | Cash Amount Payment Number | STR20_LBAU | String | 20 | |
66 | CHRGAMNT ![]() | Charge Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
67 | OCHGAMT ![]() | Originating Charge Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
68 | CHEKAMNT ![]() | Check Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
69 | ORCHKAMT ![]() | Originating Check Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
70 | CHEKNMBR ![]() | Check Number | STR20_Document_Number | String | 20 | |
71 | CHEKDATE ![]() | Check Date | DATE | Date | 6 | |
72 | CAMPYNBR ![]() | Check Amount Payment Number | STR20_LBAU | String | 20 | |
73 | CHAMCBID ![]() | Check Amount Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PA Employee Expense Header History File'].CHAMCBID AS 'PA Employee Expense Header History File-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PA Employee Expense Header History File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID | ||||||
74 | BCKTXAMT ![]() | Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
75 | OBTAXAMT ![]() | Originating Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
76 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Employee Expense Header History File'].TAXSCHID AS 'PA Employee Expense Header History File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Employee Expense Header History File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
77 | TAXAMNT ![]() | Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
78 | ORTAXAMT ![]() | Originating Tax Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
79 | CARDNAME ![]() | Card Name | STR15_Card_Name | String | 15 | |
80 | CRCRDAMT ![]() | Credit Card Amount | DLR19_RBS0_UTR$ | Currency | 19 | |
81 | ORCCDAMT ![]() | Originating Credit Card Amount | DLR19_RBSO_UTR$ | Currency | 19 | |
82 | CRCARDDT ![]() | Credit Card Date | DATE | Date | 6 | |
83 | CCAMPYNM ![]() | Credit Card Amount Payment Number | STR20_LBAU | String | 20 | |
84 | CCRCTNUM ![]() | Credit Card Receipt Number | STR20_Document_Number | String | 20 | |
85 | DISTKNAM ![]() | Discount Taken Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
86 | ORDISTKN ![]() | Originating Discount Taken Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
87 | ORDAVFRT ![]() | Originating Discount Available Freight | DLR17_RBS0_UTR$ | Currency | 17 | |
88 | ORDAVMSC ![]() | Originating Discount Available Misc | DLR17_RBS0_UTR$ | Currency | 17 | |
89 | ODAVPUR ![]() | Originating Discount Available Purchases | DLR17_RBS0_UTR$ | Currency | 17 | |
90 | PAReimbursableAmount ![]() | PA Reimbursable Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
91 | PAOrigReimbursableAmt ![]() | PA Originating Reimbursable Amount | PA_DLR17_RBS0_STR$ | Currency | 17 | |
92 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['PA Employee Expense Header History File'].RATETPID AS 'PA Employee Expense Header History File-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PA Employee Expense Header History File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
93 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['PA Employee Expense Header History File'].EXGTBLID AS 'PA Employee Expense Header History File-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PA Employee Expense Header History File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
94 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
95 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 6 | |
96 | TIME1 ![]() | Time | TM6 | Time | 6 | |
97 | RTCLCMTD ![]() | Rate Calculation Method | GB | Integer | 0 | |
98 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
99 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 1 | |
100 | PApostoDynPM ![]() | PA Post to Dyn Payables Mgmt | PA_CB_Post_PM | Boolean | 0 | |
101 | Tax_Date ![]() | Tax Date | DT | Date | 8 | |
102 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PA Employee Expense Header History File'].NOTEINDX AS 'PA Employee Expense Header History File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA Employee Expense Header History File'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
103 | TaxInvRecvd ![]() | Tax Invoice Received | CB_Tax_Invoice_Received | Boolean | 0 | |
104 | TaxInvReqd ![]() | Tax Invoice Required | CB_Tax_Invoice_Required | Boolean | 0 | |
105 | Correcting_Trx_Type ![]() | Correcting Trx Type | INT | Integer | 0 | |
106 | PAORIGINLDOCNUM ![]() | PA Original Document Number | STR17_LBAU | String | 17 | |
107 | TEN99TYPE ![]() | 1099 Type | 1099_Type | Integer | 0 | |
108 | TEN99BOXNUMBER ![]() | 1099 Box Number | DDL_1099_Box | Integer | 0 | |
109 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
110 | CRUSRID ![]() | Created User ID | STR15_User_ID | String | 15 | |
111 | POSTEDDT ![]() | Posted Date | DATE | Date | 6 | |
112 | PSTUSRID ![]() | Post User ID | STR15 | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PA Employee Expense Header History File'].PSTUSRID AS 'PA Employee Expense Header History File-Post User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA30500 AS ['PA Employee Expense Header History File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Employee Expense Header History File'].PSTUSRID = ['Users Master'].USERID | ||||||
113 | DEX_ROW_ID ![]() | int | int | 10 | ||
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |