D44H0070 - F44H501 Get Sales Master Information
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cMode_EV01 | EV01 | char | REQ | INPUT |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessage | SUPPS | char | OPT | INPUT |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
cFoundFlag_EV01 | EV01 | char | REQ | OUTPUT |
An option that specifies the type of processing for an event. | ||||
szCommunity | HBMCUS | char | REQ | INPUT |
A value that specifies a community, project, or subdivision. A community is a distinct grouping of lots which can be grouped together
| ||||
szHomeBuilderLotNumber | HBLOT | char | REQ | INPUT |
The specific lot upon which the home will be constructed. | ||||
szCurrentSalesSequence | CSSEQ | char | OPT | NONE |
A code that indicates the order in which a lot sells within a community. | ||||
szErrorMessageID_DTAI | DTAI | char | OPT | OUTPUT |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cActiveSalesSequence | ACTVSEQ | char | OPT | NONE |
A code used to specify whether Current Sales Sequence (CSSEQ) is active. Valid values are:
1
Current Sales Sequence is active
0
Current
| ||||
szCostCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szHomeBuilderArea | HBAREA | char | OPT | NONE |
A component, typically a company division or geographic region, that is larger than a community. Large homebuilders might have many
| ||||
szPhaseNumber | CPHASE | char | OPT | NONE |
A code that indicates the number of a specific phase within a community. | ||||
mnBuyerNumberA | BYR | MATH_NUMERIC | OPT | NONE |
This is a Lot Proceed field used to record the Buyer of a given house. | ||||
cMultipleBuyers | MLTBYR | char | OPT | NONE |
A code that specifies whether there are multiple buyers of a house. Valid values are: 0 or Blank No multiple buyers 1 Multiple buyers | ||||
szPlan | HBPLAN | char | OPT | NONE |
A value that specifies a plan within a community. A plan represents an architectural design based on an arrangement, location and size of
| ||||
szElevation | HBELEV | char | OPT | NONE |
A value that specifies the type of elevation used on a lot. When a unit is built on a lot, the lot is identified by plan, elevation, and swing. A
| ||||
cSwing | SWING | char | OPT | NONE |
A user defined code (44H2/SW) that specifies which side of the house the driveway is on. It is part of the key used to locate takeoff records
| ||||
szSalesActivityCodeLast | SALLST | char | OPT | NONE |
A user defined code (44H0/RL) used to specify the sales activity for the last sale completed in the sales process. | ||||
szSalesActivityCodeNext | SALNXT | char | OPT | NONE |
A user defined code (44H0/RL) used to specify the sales activity for the next sale that needs to be completed in the sales process. | ||||
jdDateStatusChanged | DCG | JDEDATE | OPT | NONE |
The date the status last changed. | ||||
szSoldatConstructionActivi | CONACT | char | OPT | NONE |
A user defined code (44H0/RL) that indicates the construction activity of the house when it was sold. | ||||
szSalesContractStatus | HBSCS | char | OPT | NONE |
A user defined code (44H5/ST) that specifies the status of a sales contract. | ||||
jdSalesDate | SDJ | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdSaleReportedDate | SRPDJ | JDEDATE | OPT | NONE |
The date on which the seller reports the sale and notifies all concerned parties that it is a sale. | ||||
jdSaleRatifiedDate | SRDJ | JDEDATE | OPT | NONE |
The date on which the seller signs the purchase agreement. | ||||
jdCreditApprovalDate | CAPRVL | JDEDATE | OPT | NONE |
The date that the buyer's credit was approved. | ||||
jdProjectedCloseDate | ECDJ | JDEDATE | OPT | NONE |
The date that the homebuilder expects the house to close escrow. This date is a projection and is subject to change. | ||||
jdCloseDate | CDJ | JDEDATE | OPT | NONE |
Julian date used to record the Closing of a house in the Lot Proceed files. | ||||
jdCancelDateJulian | EDJ | JDEDATE | OPT | NONE |
Julian date used to record the cancellation of a house sale to a given buyer. | ||||
szCancelSaleReasonCode | CSRCD | char | OPT | NONE |
A user defined code (44H/CS) that indicates the reason a sale was cancelled. | ||||
szCancelSaleNote1 | CSN1 | char | OPT | NONE |
A code that indicates when a sale is in the process of being cancelled. You can enter notes regarding the cancelled sale. | ||||
szCancelSaleNote2 | CSN2 | char | OPT | NONE |
A code that indicates when a sale is in the process of being cancelled. You can enter notes regarding the cancelled sale. | ||||
szCancelSaleNote3 | CSN3 | char | OPT | NONE |
A code that indicates when a sale is in the process of being cancelled. You can enter notes regarding the cancelled sale. | ||||
mnBaseHouseSalesPrice | BHPRICE | MATH_NUMERIC | OPT | NONE |
The sales price for a plan and elevation. This value is stored in the Sales Master Table (F44H501). | ||||
mnLotPremium | LOTPREM | MATH_NUMERIC | OPT | NONE |
A value that indicates the premium amount for a lot. Typically, this is an additional monetary amount applied to the selling price to account
| ||||
mnAmountIncentive1 | INCA1 | MATH_NUMERIC | OPT | NONE |
A value that specifies a monetary amount of incentive given to the buyer. This value is entered into the Sales Master table (F44H501) and is
| ||||
mnAmountIncentive2 | INCA2 | MATH_NUMERIC | OPT | NONE |
A value that specifies a monetary amount of incentive given to the buyer. This value is entered into the Sales Master table (F44H501) and is
| ||||
mnAmountIncentive3 | INCA3 | MATH_NUMERIC | OPT | NONE |
A value that specifies a monetary amount of incentive given to the buyer. This value is entered into the Sales Master table (F44H501) and is
| ||||
mnAmountUpgrade | UPG | MATH_NUMERIC | OPT | NONE |
The dollar amount of upgrades the buyer requested. This field is used in the calculation of the total house price. | ||||
mnNetBasePrice | NETBP | MATH_NUMERIC | OPT | NONE |
A value that is calculated as follows:
Net base price = (Base house sales price (BHPRICE) + Lot premium (LOTPREM) + Upgrade amount
| ||||
mnAmountOptionRevenue1 | OPRV1 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue2 | OPRV2 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue3 | OPRV3 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue4 | OPRV4 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can cateogorize option revenue into nine groups for accounting purposes. Each
| ||||
mnAmountOptionRevenue5 | OPRV5 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue6 | OPRV6 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue7 | OPRV7 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue8 | OPRV8 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionRevenue9 | OPRV9 | MATH_NUMERIC | OPT | NONE |
A value that indicates the revenue for an option. You can categorize option revenue into nine groups for accounting purposes. Each option
| ||||
mnAmountOptionIncentive | OPINCA | MATH_NUMERIC | OPT | NONE |
The monetary amount of the option incentive given to the buyer. This field is stored into the Lot Sales History table (F44H501H) and is used
| ||||
mnNetOptionPrice | NETOPT | MATH_NUMERIC | OPT | NONE |
A value that is calculated as follows:
Net Option Price = (Option Revenue 1 + Option Revenue 2 + Option Revenue 3 + Option Revenue 4 +
| ||||
mnTotalSalesPrice | TOTSAL | MATH_NUMERIC | OPT | NONE |
The total amount of the sales price of a lot. This value is stored in the Sales Master Table F44H501. It is calculated as follows:
Total Sales
| ||||
mnAddressNumberSalesMaster1 | ANSM01 | MATH_NUMERIC | OPT | NONE |
The address book number of the first sales associate. | ||||
mnAddressNumberSalesMaster2 | ANSM02 | MATH_NUMERIC | OPT | NONE |
The address book number of the second sales associate. | ||||
mnAddressNumberSalesMaster3 | ANSM03 | MATH_NUMERIC | OPT | NONE |
The address book number of the third sales associate. | ||||
mnAddressNumberSalesMaster4 | ANSM04 | MATH_NUMERIC | OPT | NONE |
The address book number of the fourth sales associate. | ||||
mnAddressNumberSalesMaster5 | ANSM05 | MATH_NUMERIC | OPT | NONE |
The address book number of the fifth sales associate. | ||||
mnAddressNumberSalesMaster6 | ANSM06 | MATH_NUMERIC | OPT | NONE |
The address book number of the sixth sales associate. | ||||
mnAddressNumberSalesMaster7 | ANSM07 | MATH_NUMERIC | OPT | NONE |
The address book number of the seventh sales associate. | ||||
mnAddressNumberSalesMaster8 | ANSM08 | MATH_NUMERIC | OPT | NONE |
The address book number of the eighth sales associate. | ||||
mnAddressNumberSalesMaster9 | ANSM09 | MATH_NUMERIC | OPT | NONE |
The address book number of the ninth sales associate. | ||||
mnAddressNumberSalesMaster | ANSM10 | MATH_NUMERIC | OPT | NONE |
The address book number of the tenth sales associate. | ||||
mnCommissionPercentage1 | CMPCT1 | MATH_NUMERIC | OPT | NONE |
The percentage for calculating commission. | ||||
mnCommissionPercentage2 | CMPCT2 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage3 | CMPCT3 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage4 | CMPCT4 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage5 | CMPCT5 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage6 | CMPCT6 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage7 | CMPCT7 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage8 | CMPCT8 | MATH_NUMERIC | OPT | NONE |
A percentage for calculating commission. | ||||
mnCommissionPercentage9 | CMPCT9 | MATH_NUMERIC | OPT | NONE |
The percentage for calculating commission. | ||||
mnCommissionPercentage10 | CMPCT10 | MATH_NUMERIC | OPT | NONE |
The percentage for calculating commission. | ||||
mnAmountCommission1 | CM1 | MATH_NUMERIC | OPT | NONE |
Lot Proceed Sales person No. 1 commission amount. This field is manually calculated using the sales person No. 1 commission %. | ||||
mnAmountCommission2 | CM2 | MATH_NUMERIC | OPT | NONE |
Lot Proceed Sales person No. 2 commission amount. This field is manually calculated using the sales person No. 2 commission %. | ||||
mnAmountCommission3 | CM3 | MATH_NUMERIC | OPT | NONE |
Lot Proceed Sales person No. 3 commission amount. This field is manually calculated using the sales person No. 3 commission %. | ||||
mnAmountCommission4 | CM4 | MATH_NUMERIC | OPT | NONE |
The amount to store for commission earned. | ||||
mnAmountCommission5 | CM5 | MATH_NUMERIC | OPT | NONE |
A value that indicates the amount of earned commissions. | ||||
mnAmountCommission6 | CM6 | MATH_NUMERIC | OPT | NONE |
A value used to specify the amount to store for commission earned. | ||||
mnAmountCommission7 | CM7 | MATH_NUMERIC | OPT | NONE |
A value used to specify the amount to store for commission earned. | ||||
mnAmountCommission8 | CM8 | MATH_NUMERIC | OPT | NONE |
A value used to specify the amount to store for commission earned. | ||||
mnAmountCommission9 | CM9 | MATH_NUMERIC | OPT | NONE |
The amount of commission earned. | ||||
mnAmountCommission10 | CM10 | MATH_NUMERIC | OPT | NONE |
The amount of commission earned. | ||||
mnLenderNumber | LDR | MATH_NUMERIC | OPT | NONE |
Lot Proceed information field. | ||||
szLoanNumber | LOANNUM | char | OPT | NONE |
A value that specifies the buyer's loan number in the Sales Management program (P44H500). | ||||
szLoanType | LOANTYP | char | OPT | NONE |
A user defined code (44H5/LT) that specifies the buyer's loan type. | ||||
mnMortageAmount | MGA | MATH_NUMERIC | OPT | NONE |
Lot Proceed information field. | ||||
mnInterestRate | INRTE | MATH_NUMERIC | OPT | NONE |
A value that indicates the percentage of interest. This field is informational only. | ||||
jdIntrestRateLockDate | INRLCK | JDEDATE | OPT | NONE |
The date on which the interest rate was locked. | ||||
jdPointsExpirationDate | PXD | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
mnDownPayment | DNPT | MATH_NUMERIC | OPT | NONE |
Lot Proceed information field. | ||||
mnEarnestMoneyDeposit | EMD | MATH_NUMERIC | OPT | NONE |
Lot Proceed information field. | ||||
mnAmountDepositTaken | DTKN | MATH_NUMERIC | OPT | NONE |
The amount of the deposit taken for a given Option. This field is enter manually into the Option Master file and will default into Option
| ||||
jdMortgageApprovalDate | MAD | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdTitleApptDate | TAD | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdLoanApplicationDate | LADJ | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
cContingentSaleFlag | CTG | char | OPT | NONE |
A code that specifies whether the sale has a contingency. Additional fields are available to record information about the contingency. | ||||
szContingentSaleType | CTGS | char | OPT | NONE |
Lot Proceed information field. | ||||
szPropertyText | PTX | char | OPT | NONE |
A memo field for additional text information. | ||||
jdContingencyEffectiveDate | CTGJ | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdListingReceiptDate | LRD | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdContigencyConvertedDate | CCNVD | JDEDATE | OPT | NONE |
The date that the contingency is satisfied. The sale is no longer encumbered with a contingency as of this date. | ||||
jdConversionLossDate | CLJ | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdContingencyExpirationdate | CXD | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
jdContingencyReleaseDate | CRD | JDEDATE | OPT | NONE |
Lot Proceed information field. | ||||
szContingentNote1 | CN1 | char | OPT | NONE |
Lot Proceed information field. | ||||
szContingentNote2 | CN2 | char | OPT | NONE |
Lot Proceed information field. | ||||
mnListingAgent | LAG | MATH_NUMERIC | OPT | NONE |
Lot Proceed information field. | ||||
jdDesignCenterAppointment | DCAPPT | JDEDATE | OPT | NONE |
A code that indicates the date of the buyer's first scheduled design center appointment. | ||||
szDesignCenterAppointmentT | DCSTM | char | OPT | NONE |
A code that indicates the time when the buyer's first design center appointment is scheduled. | ||||
jdActualDesignCenterAppoin | DCADT | JDEDATE | OPT | NONE |
A code that indicates the date on which the buyer's design center appointment occurred. | ||||
szChangeLot | CLT | char | OPT | NONE |
This field is use to initiate the transfer of a given buyer from one lot to another in the Lot Proceed files. | ||||
jdTransferBuyerDateJulian | TEDJ | JDEDATE | OPT | NONE |
The date that the buyer transfered to another lot. | ||||
jdTransferBuyerInDateJulian | TIDJ | JDEDATE | OPT | NONE |
The date that the buyer was transferred into the lot. | ||||
szTransferLotNote1 | TLN1 | char | OPT | NONE |
An informational field regarding a buyer that has transferred to another lot. | ||||
szTransferLotNote2 | TLN2 | char | OPT | NONE |
An informational field regarding a buyer that has transferred to another lot. | ||||
szTransferLotNote3 | TLN3 | char | OPT | NONE |
An informational field regarding a buyer that has transferred to another lot. | ||||
jdBuyerScheduledWalkThruDa | BSWD | JDEDATE | OPT | NONE |
The date that the buyer is scheduled to do the walk-through. | ||||
szBuyerScheduledWalkThruTi | BSWT | char | OPT | NONE |
The time the buyer is scheduled to do the walk-through. | ||||
jdBuyerActualWalkThruDate | BAWD | JDEDATE | OPT | NONE |
The actual date that the buyer walk-through occurred. | ||||
jdUserDate1 | USD1 | JDEDATE | OPT | NONE |
User defined Julian Date 1. | ||||
jdUserDate2 | USD2 | JDEDATE | OPT | NONE |
User defined Julian Date 2. | ||||
jdUserDate3 | USD3 | JDEDATE | OPT | NONE |
A Julian date. | ||||
jdUserDate4 | USD4 | JDEDATE | OPT | NONE |
A Julian date. | ||||
jdUserDate5 | USD5 | JDEDATE | OPT | NONE |
jdUserDate6 | USD6 | JDEDATE | OPT | NONE |
jdUserDate7 | USD7 | JDEDATE | OPT | NONE |
jdUserDate8 | USD8 | JDEDATE | OPT | NONE |
jdUserDate9 | USD9 | JDEDATE | OPT | NONE |
jdUserDate10 | USD10 | JDEDATE | OPT | NONE |
A user defined date. Enter the date in Julian format. | ||||
jdUserDate11 | USD11 | JDEDATE | OPT | NONE |
A user defined date. Enter the date in Julian format. | ||||
jdUserDate12 | USD12 | JDEDATE | OPT | NONE |
A user defined date. Enter the date in Julian format. | ||||
jdUserDate13 | USD13 | JDEDATE | OPT | NONE |
A user defined date. Enter the date in Julian format. | ||||
jdUserDate14 | USD14 | JDEDATE | OPT | NONE |
A user defined date. Enter the date in Julian format. | ||||
jdUserDate15 | USD15 | JDEDATE | OPT | NONE |
A user defined date. Enter the date in Julian format. | ||||
jdUserDate16 | USD16 | JDEDATE | OPT | NONE |
A user defined Julian date. | ||||
jdUserDate17 | USD17 | JDEDATE | OPT | NONE |
A user defined Julian date. | ||||
jdUserDate18 | USD18 | JDEDATE | OPT | NONE |
A user defined Julian date. | ||||
jdUserDate19 | USD19 | JDEDATE | OPT | NONE |
A user defined Julian date. | ||||
jdUserDate20 | USD20 | JDEDATE | OPT | NONE |
A user defined Julian date. | ||||
mnAmountUserDefinedAmount01 | UAMT01 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount02 | UAMT02 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount03 | UAMT03 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount04 | UAMT04 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount05 | UAMT05 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount06 | UAMT06 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount07 | UAMT07 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount08 | UAMT08 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount09 | UAMT09 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
mnAmountUserDefinedAmount10 | UAMT10 | MATH_NUMERIC | OPT | NONE |
A user defined amount. | ||||
szSalesMasterCategoryCode1 | SMC01 | char | OPT | NONE |
A user defined category code (44H5/01) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode2 | SMC02 | char | OPT | NONE |
A user defined category code (44H5/02) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode3 | SMC03 | char | OPT | NONE |
A user defined category code (44H5/03) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode4 | SMC04 | char | OPT | NONE |
A user defined category code (44H5/04) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode5 | SMC05 | char | OPT | NONE |
A user defined category code (44H5/05) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode6 | SMC06 | char | OPT | NONE |
A user defined category code (44H5/06) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode7 | SMC07 | char | OPT | NONE |
A user defined category code (44H5/07) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode8 | SMC08 | char | OPT | NONE |
A user defined category code (44H5/08) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode9 | SMC09 | char | OPT | NONE |
A user defined category code (44H5/09) used to update the Sales Master Table (F44H501). | ||||
szSalesMasterCategoryCode10 | SMC10 | char | OPT | NONE |
A user defined category code (44H5/10) used to update the Sales Master Table (F44H501). | ||||
mnAddressNumberUserDefined | USAN01 | MATH_NUMERIC | OPT | NONE |
A code used for address book number information. | ||||
mnAddressNumberUserDefined_2 | USAN02 | MATH_NUMERIC | OPT | NONE |
A code used for address book number information. | ||||
mnAddressNumberUserDefined_3 | USAN03 | MATH_NUMERIC | OPT | NONE |
A code used for address book number information. | ||||
mnAddressNumberUserDefined_4 | USAN04 | MATH_NUMERIC | OPT | NONE |
A code used for address book number information. | ||||
mnAddressNumberUserDefined_5 | USAN05 | MATH_NUMERIC | OPT | NONE |
A code used for address book number information. | ||||
cStatusCode1 | HBST1 | char | OPT | NONE |
A code used for transactional posting other than normal posting. For example, generating records for export to another system such as field
| ||||
cStatusCode2 | HBST2 | char | OPT | NONE |
A code used for transactional posting other than normal posting. For example, generating records for export to another system such as field
| ||||
cStatusCode3 | HBST3 | char | OPT | NONE |
A code used for transactional posting other than normal posting. For example, generating records for export to another system such as field
| ||||
cStatusCode4 | HBST4 | char | OPT | NONE |
A code used for transactional posting other than normal posting. For example, generating records for export to another system such as field
| ||||
cStatusCode5 | HBST5 | char | OPT | NONE |
A code used for transactional posting other than normal posting. For example, generating records for export to another system such as field
| ||||
szCreatedByUser | CRTU | char | OPT | NONE |
The address book number of the user who created this record. | ||||
jdDateCreated | CRTJ | JDEDATE | OPT | NONE |
A code that indicates the date on which the record was created. | ||||
mnTimeCreated | CRTT | MATH_NUMERIC | OPT | NONE |
A code that specifies the time when the record was created. | ||||
szOriginalWorkStationId | WRKSTNID | char | OPT | NONE |
The identification number of the workstation on which the expense report was entered. | ||||
szUpdatedByUser | UPMB | char | OPT | NONE |
The User I.D. of the individual who replaced or changed one or more values in this record. Captured by the subject program automatically. | ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. | ||||
szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szOriginalProgramId | HBOPID | char | OPT | NONE |
None |
None |