PA Combined History Header file (PA11800)

azurecurveProductsProject Accounting (258)ProjectPA Combined History Header file (PA11800)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA11800

Product: Project Accounting (258)
Series: Project

Display Name: PA Combined History Header file
Physical Name: PA11800
Technical Name: PA_Combined_History_WORK_HDR

Group Display Name: PA Combined History
Group Technical Name: PA Combined History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
2PADocnumber20 SearchPA Document No.STR17_LBAUString1817
3PATRXType SearchPA TRX TypePA_DDL_TRX_TypeInteger20
4PADOCDT SearchPA Document DatePA_DateDate48
5USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PA Combined History Header file'].USERID AS 'PA Combined History Header file-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PA Combined History Header file'].USERID = ['Users Master'].USERID
6BACHNUMB SearchBatch NumberSTR15_LBAUString1615
7PAREFNO SearchPA Reference Document No.STR17_LBAUString1817
8PAUD1 SearchPA User Defined 1STR20String2220
9PAUD2 SearchPA User Defined 2STR20String2220
10VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['PA Combined History Header file'].VENDORID AS 'PA Combined History Header file-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['PA Combined History Header file'].VENDORID = ['PM Vendor Master File'].VENDORID
11PACOSTOWNER SearchPA Cost OwnerSTR30_Item_NumberString3230
12PAREPD SearchPA Reporting PeriodINT3Integer23
13PAREPDT SearchPA Reporting DatePA_DateDate48
14PAreptsuff SearchPA Reporting SuffixPA_STR5String65
15PAYR SearchPA YearINT4Integer24
16PAVENINVNO SearchPA Vendor Invoice NumberSTR20_Document_NumberString2220
17PAVENADDRESSID SearchPA Vendor Address IDSTR15_Address_CodeString1615
18PACOMM SearchPA CommentSTR50String5250
19PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['PA Combined History Header file'].PYMTRMID AS 'PA Combined History Header file-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['PA Combined History Header file'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
20DUEDATE SearchDue DateDTDate48
21DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
22DISCDATE SearchDiscount DateDTDate48
23DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
24PRCTDISC SearchPercent DiscountINT5_%2Integer25
25CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Combined History Header file'].CURNCYID AS 'PA Combined History Header file-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Combined History Header file'].CURNCYID = ['Currency Setup'].CURNCYID
26SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['PA Combined History Header file'].SHIPMTHD AS 'PA Combined History Header file-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['PA Combined History Header file'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
27PATQTY SearchPA Total QuantityDLR17_QTY_RBS0_UTRCurrency1017
28PAtotcosts SearchPA Total CostsPA_DLR17_RBS0_STR$Currency1017
29BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
30PATACRV SearchPA Total Accrued RevenuesDLR17_RBS0_UTR$Currency1017
31TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
32PAFreight_Taxable_P SearchPA Freight Taxable - PurchasePA_DDL_Tax_Options_PurchaseInteger20
33FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Header file'].FRTSCHID AS 'PA Combined History Header file-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Header file'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
34FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
35FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency1019
36PAMisc_Taxable_P SearchPA Misc Taxable - PurchasePA_DDL_Tax_Options_PurchaseInteger20
37MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Header file'].MSCSCHID AS 'PA Combined History Header file-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Header file'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
38MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
39MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
40TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
41DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
42TEN99AMNT Search1099 AmountDLR17_RBS0_UTR$Currency1017
43UN1099AM SearchUnapplied 1099 AmountDLR17_RBS0_UTR$Currency1017
44CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency1019
45CAMCBKID SearchCash Amount Checkbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].CAMCBKID AS 'PA Combined History Header file-Cash Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PA Combined History Header file'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
46CDOCNMBR SearchCash Document NumberSTR20_Document_NumberString2220
47CAMTDATE SearchCash Amount DateDTDate48
48CAMPMTNM SearchCash Amount Payment NumberSTR20_LBAUString2220
49CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019
50CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
51CHEKDATE SearchCheck DateDATEDate46
52CAMPYNBR SearchCheck Amount Payment NumberSTR20_LBAUString2220
53CHAMCBID SearchCheck Amount Checkbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].CHAMCBID AS 'PA Combined History Header file-Check Amount Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['PA Combined History Header file'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
54CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency1019
55CARDNAME SearchCard NameSTR15_Card_NameString1615
56CRCARDDT SearchCredit Card DateDATEDate46
57CCAMPYNM SearchCredit Card Amount Payment NumberSTR20_LBAUString2220
58CCRCTNUM SearchCredit Card Receipt NumberSTR20_Document_NumberString2220
59DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
60CHRGAMNT SearchCharge AmountDLR19_RBSO_UTR$Currency1019
61LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
62PAPD SearchPA Post DatePA_DateDate48
63VOIDSTTS SearchVoid StatusINTInteger20
64VOIDDATE SearchVoid DateDTDate48
65NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PA Combined History Header file'].NOTEINDX AS 'PA Combined History Header file-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PA Combined History Header file'].NOTEINDX = ['Record Notes Master'].NOTEINDX
66RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].RATETPID AS 'PA Combined History Header file-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PA Combined History Header file'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
67EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PA Combined History Header file'].EXGTBLID AS 'PA Combined History Header file-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PA Combined History Header file'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
68XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
69EXCHDATE SearchExchange DateDT_DateDate46
70TIME1 SearchTimeTM6Time46
71RTCLCMTD SearchRate Calculation MethodGBInteger20
72DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
73PAORIGTOTCOSTS SearchPA Originating Total CostsDLR17_RBS0_UTR$Currency1017
74PAORIACCRREV SearchPA Originating Accrued RevenuesDLR17_RBS0_UTR$Currency1017
75DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency1017
76TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Header file'].TAXSCHID AS 'PA Combined History Header file-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11800 AS ['PA Combined History Header file']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Header file'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
77PYMNTTRM SearchPayment TermsPayment_TermString1615
78POPTYPE SearchPOP TypeDDL_POP_TypeInteger20
79VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString2220
80ACTLSHIP SearchActual Ship DateDTDate48
81GLPOSTDT SearchGL Posting DateDTDate48
82DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
83TRXSORCE SearchTRX SourceSTR13String1413
84VCHRNMBR SearchVoucher NumberSTR20_LBAUString2220
85DEX_ROW_ID Searchintint1010

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.

azurecurveProductsProject Accounting (258)ProjectPA Combined History Header file (PA11800)

Leave a Reply

Your email address will not be published. Required fields are marked *